@php
	$file_type = "vnd.ms-excel";
	$file_name= "FRTAT-UserwiseReport.xls";
	header("Content-Type: application/$file_type");
	header("Content-Disposition: attachment; filename=$file_name");
$GetResultNew=$ResultDataArray->TicketResult;
$NotRespondedArray=$ResultDataArray->NotRespondedArray;
@endphp

<table border='1'>
	<tr>
		<th>Date</th>
		<th>No.Of.Ticket Created</th>
		<th>No.Of.Ticket to Assigned</th>
		<th>FR TAT Less than 1 hour</th>
		<th>FR TAT Greater than 1 hour & Less than 2 hour</th>
		<th>FR TAT Greater than 2 hour & Less than 4 hour</th>
		<th>FR TAT Greater than 4 hour & Less than 6 hour</th>
		<th>FR TAT Greater than 6 hour</th>
		<th>Not Responded Ticket</th>
	</tr>
	@foreach($GetResultNew as $Date=>$RecordDetails)
		@php
			$TempTotal=0;
			$TicketDetails=$RecordDetails[0];
			$TotalCnt=$TicketDetails->TotalCnt;
			$Lessthanonehour=$TicketDetails->Lessthanonehour;
			$LessthanonehourPercentage=(($Lessthanonehour*100)/$TotalCnt);
			$LessthanonehourPercentage=round($LessthanonehourPercentage,2);
			
			$TotalAssignUser=$TicketDetails->TotalAssignUser;
			
			$GreaterthanOnehour=$TicketDetails->GreaterthanOnehour;
			$GreaterthanOnehourPercentage=(($GreaterthanOnehour*100)/$TotalCnt);
			$GreaterthanOnehourPercentage=round($GreaterthanOnehourPercentage,2);
			
			$GreaterthanTwohour=$TicketDetails->GreaterthanTwohour;
			$GreaterthanTwohourPercentage=(($GreaterthanTwohour*100)/$TotalCnt);
			$GreaterthanTwohourPercentage=round($GreaterthanTwohourPercentage,2);
			
			$GreaterthanFourhour=$TicketDetails->GreaterthanFourhour;
			$GreaterthanFourhourPercentage=(($GreaterthanFourhour*100)/$TotalCnt);
			$GreaterthanFourhourPercentage=round($GreaterthanFourhourPercentage,2);
			
			$GreaterthanSixhour=$TicketDetails->GreaterthanSixhour;
			$GreaterthanSixhourPercentage=(($GreaterthanSixhour*100)/$TotalCnt);
			$GreaterthanSixhourPercentage=round($GreaterthanSixhourPercentage,2);
			
			$NotRespondedArrayNew=$NotRespondedArray->$Date;
			$NotRespondedMail=$NotRespondedArrayNew[0]->NotRespondedCount;
			$NotRespondedMailPercentage=(($NotRespondedMail*100)/$TotalCnt);
			$NotRespondedMailPercentage=round($NotRespondedMailPercentage,2);
			
			$DisplayDate=date('d-M-y',strtotime($Date));
		@endphp
	<tr>
		<td>{{$DisplayDate}}</td>
		<td>
			{{$TotalCnt}}
		</td>
		<td>
			{{$TotalAssignUser}}
		</td>
		<td>
			{{$Lessthanonehour}} 
			( {{$LessthanonehourPercentage}} %)
		</td>
		<td>
			{{$GreaterthanOnehour}}
			( {{$GreaterthanOnehourPercentage}} %)
		</td>
		<td>
			{{$GreaterthanTwohour}}
			( {{$GreaterthanTwohourPercentage}} %)
		</td>
		<td>
			{{$GreaterthanFourhour}}
			( {{$GreaterthanFourhourPercentage}} %)
		</td>
		<td>
			{{$GreaterthanSixhour}}
			( {{$GreaterthanSixhourPercentage}} %)
		</td>
		<td>
			{{$NotRespondedMail}}
			( {{$NotRespondedMailPercentage}} %)
		</td>
	</tr>
	@endforeach
</table>