@php
	// echo "<pre>";
		// print_r($getActiveUsersList);
		// print_r($GetREsult);
	// echo "</pre>";
	$GetResultNew=$GetREsult['TicketResult'];
	$NotRespondedArray=$GetREsult['NotRespondedArray'];
	$GetResultEncode=json_encode($GetREsult);
	$GetResultEncodeNew=base64_encode($GetResultEncode);
@endphp

<h3>First Response TAT Report User wise</h3>
<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="ExcelExportFRTATNew()">Export Excel</button>
	</div>
</div>
<table class="table table-no-space table-bordered"  id="FRTATUserwise">
	<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 $UserId=>$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);
			
			$NotRespondedMail=$NotRespondedArray[$UserId][0]->NotRespondedCount;
			$NotRespondedMailPercentage=(($NotRespondedMail*100)/$TotalCnt);
			$NotRespondedMailPercentage=round($NotRespondedMailPercentage,2);
			
			$DisplayUserName=$UserId;
			if(array_key_exists($UserId,$getActiveUsersList))
			{
				$DisplayUserName=$getActiveUsersList[$UserId]['name'];
			}
		@endphp
	<tr>
		<td>{{$DisplayUserName}}</td>
		<td >
			{{$TotalCnt}}
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','TotalAssignUser')">
			<font color="blue">{{$TotalAssignUser}}</font>
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','Lessthanonehour')">
			<font color="blue">{{$Lessthanonehour}} </font>
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','GreaterthanOnehour')">
			<font color="blue">{{$GreaterthanOnehour}}</font>
			( {{$GreaterthanOnehourPercentage}} %)
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','GreaterthanTwohour')">
			<font color="blue">{{$GreaterthanTwohour}}</font>
			( {{$GreaterthanTwohourPercentage}} %)
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','GreaterthanFourhour')">
			<font color="blue">{{$GreaterthanFourhour}}</font>
			({{$GreaterthanFourhourPercentage}} %)
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','GreaterthanSixhour')">
			<font color="blue">{{$GreaterthanSixhour}}</font>
			( {{$GreaterthanSixhourPercentage}} %)
		</td>
		<td style="cursor:pointer" onclick="DetailofFRTATUserwiseReport('{{$UserId}}','NotRespondedMail')">
			<font color="blue">{{$NotRespondedMail}}</font>
			( {{$NotRespondedMailPercentage}} %)
		</td>
	</tr>
	@endforeach
</table>
<script>
function ExcelExportFRTATNew()
{
	const table = document.getElementById('FRTATUserwise');

  // Convert the table to a workbook
  const workbook = XLSX.utils.table_to_book(table);

  // Convert the workbook to a binary Excel file
  const excelBuffer = XLSX.write(workbook, { bookType: 'xlsx', type: 'array' });

  // Create a blob object from the binary Excel file
  const blob = new Blob([excelBuffer], { type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' });

  // Create a download link for the Excel file
  const downloadLink = document.createElement('a');
  downloadLink.href = window.URL.createObjectURL(blob);
  downloadLink.download = 'FRTAT-Userwise.xlsx';

  // Trigger the download
  downloadLink.click();
}

</script>