@php
	$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
<div class="row">
	<div class="col-sm-12 col-md-12" style="text-align: right">
		<button class="btn btn-primary mb-2 me-4"  onclick="ExcelClosedReport()">Export Excel</button>
	</div>
</div>
<div class="table-responsive">
	<table class="table style-2 table-hover no-footer" id="table1">
		<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;
			$DisplayFirstResponseTime='';
			if($FirstResponseTime)
			{
				$DisplayFirstResponseTime=date('d-m-Y h:i a',strtotime("$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>
				<a href="{{ url('ShowDetailView',$pass_array) }}" class="text-primary" title="{{$TicketName}}">{{$TicketNumber}}</a>
			</td>
			<td>{{$DisplayStatusValue}}</td>
			<td>{{$DisplayCreatedDate}}</td>
			<td>{{$statumodifiedDate}}</td>
			<td>{{$abc}}</td>
			<td>{{$UpdatedBy}}</td>
			<td>{{$DisplayFirstResponseTime}}</td>
			<td>{{$DisplayTypeValue}}</td>
			<td>{{$DisplaySubTypeValue}}</td>
			<td>{{$emailsInboundCount}}</td>
			<td>{{$emailsOutBoundCount}}</td>
			<td>{{$emailsBothCount}}</td>
		</tr>
		@endforeach
	</table>
</div>