@php
	$file_type = "vnd.ms-excel";
	$file_name= "ExportData.xls";
	header("Content-Type: application/$file_type");
	header("Content-Disposition: attachment; filename=$file_name");
	
	$TicketStatusDemoId='8d8e0cfd-f258-403f-9e99-b1c984a2536e';
	$TicketSubTypeDemoId='33951c92-9e1d-4ceb-99b0-71bcb4b7abbd';
	$TicketTypeDemoId='b0e5c84d-2eca-4b2f-9dbd-28ac7a2200e9';

	$StatusNameId=$GetModuleDropdownDet[$TicketStatusDemoId];
	$SubTypeNameId=$GetModuleDropdownDet[$TicketSubTypeDemoId];
	$TypeNameId=$GetModuleDropdownDet[$TicketTypeDemoId];

	$TypeArray=array();
	$StatusArray=array();
	$SubTypeArray=array();

	$TypeArray=$GetDropdownLists[$TypeNameId];
	$StatusArray=$GetDropdownLists[$StatusNameId];
	$SubTypeArray=$GetDropdownLists[$SubTypeNameId];
	echo "<pre>";
	// print_r($TypeArray);
	// print_r($SubTypeArray);
	echo "</pre>";
	$i=0;
@endphp
	<table border='1'>
		<tr>
			<th>S.No</th>
			<th>Ticket Number</th>
			<th>Status</th>
			<th>Ticket Start Time</th>
			<th>Ticket Closed Time</th>
			<th>Total Turn AroundTime</th>
			<th>Ticket Closed By</th>
			<th>First Response Time</th>
			<th>Ticket Type</th>
			<th>Ticket Sub Type</th>
			<th>Emails InBound count</th>
			<th>Emails OutBound count</th>
			<th>InBound & OutBound count</th>
		</tr>
		@foreach($ClosedTicketReportResult as $EachRecord)
			@php
			$i++;
			$TicketNumber=$EachRecord->TicketNumber;
			$TicketId=$EachRecord->TicketId;
			$CreatedDate=$EachRecord->CreatedDate;
			$DisplayCreatedDate=date('d-m-Y h:i a',strtotime("$CreatedDate"));
			$UpdatedBy=$EachRecord->UpdatedBy;
			$TicketName=$EachRecord->TicketName;
			$TicketType=$EachRecord->TicketType;
			$TicketSubType=$EachRecord->TicketSubType;
			$Status=$EachRecord->Status;
			$DisplayStatusValue='';
			$DisplayTypeValue='';
			$DisplaySubTypeValue='';
			if(array_key_exists($Status,$StatusArray))
			{
				$DisplayStatusValue=$StatusArray[$Status];
			}
			if(array_key_exists($TicketType,$TypeArray))
			{
				$DisplayTypeValue=$TypeArray[$TicketType];
			}
			if(array_key_exists($TicketSubType,$SubTypeArray))
			{
				$DisplaySubTypeValue=$SubTypeArray[$TicketSubType];
			}
			$statumodifieddate=$EachRecord->statumodifieddate;
			$statumodifiedDate=date('d-m-Y h:i a',strtotime("$statumodifieddate"));
			$FirstResponseTime=$EachRecord->FirstResponseTime;
			// $starttimestamp = strtotime($CreatedDate);
			// $endtimestamp = strtotime($statumodifieddate);
			// $difference = abs($endtimestamp - $starttimestamp)/3600;
			//$hourdiff = round((strtotime($statumodifieddate) - strtotime($CreatedDate))/3600, 1);
			$datetime1 = new DateTime($CreatedDate);
			$datetime2 = new DateTime($statumodifieddate);
			$interval = $datetime1->diff($datetime2);
			$abc=$interval->format('%h')." Hr ".$interval->format('%i')." Min";
			$pass_array=array("ModuleId"=>'806867ab-96a5-11eb-948a-56b1773fd56f',"RowId"=>$TicketId);
			$emailsBothCount=$EmailsList[$TicketId]['both'];
			$emailsInboundCount=$EmailsList[$TicketId]['inbound'];
			$emailsOutBoundCount=$EmailsList[$TicketId]['outbound'];
			@endphp
		<tr>
			<td>{{$i}}</td>
			<td>
				{{$TicketNumber}}
			</td>
			<td>{{$DisplayStatusValue}}</td>
			<td>{{$DisplayCreatedDate}}</td>
			<td>{{$statumodifiedDate}}</td>
			<td>{{$abc}}</td>
			<td>{{$UpdatedBy}}</td>
			<td>{{$FirstResponseTime}}</td>
			<td>{{$DisplayTypeValue}}</td>
			<td>{{$DisplaySubTypeValue}}</td>
			<td>{{$emailsInboundCount}}</td>
			<td>{{$emailsOutBoundCount}}</td>
			<td>{{$emailsBothCount}}</td>
		</tr>
		@endforeach
	</table>