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

	$uniqueId = uniqid('report_');

$tableId = "DownloadUserFRTATReport_" . $uniqueId;
$buttonId = "ExportButton_" . $uniqueId;
	
@endphp

<h3>UserWise - First Response TAT Report</h3>
<div class="row">
        <div class="col-sm-12 col-md-12" style="text-align: right">
            <button class="btn btn-primary" type="button" id="{{ $buttonId }}">Export Excel</button>
        </div>
    </div>
<table class="table table-no-space table-bordered" id="{{ $tableId }}">
	<tr>
		<th>Users</th>
		<th>Role</th>
		<th>Team</th>
		<th>No.Of.Ticket Created</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
			
			$TicketDetails=$RecordDetails[0];
			$TotalCnt=$TicketDetails->TotalCnt;
			$Lessthanonehour=$TicketDetails->Lessthanonehour;
			$LessthanonehourPercentage = ($TotalCnt > 0) ? (($Lessthanonehour * 100) / $TotalCnt) : 0;
			$LessthanonehourPercentage=round($LessthanonehourPercentage,2);
	
			$GreaterthanOnehour=$TicketDetails->GreaterthanOnehour;
			$GreaterthanOnehourPercentage = ($TotalCnt > 0) ? (($GreaterthanOnehour * 100) / $TotalCnt) : 0;
			$GreaterthanOnehourPercentage=round($GreaterthanOnehourPercentage,2);
			
			$GreaterthanTwohour=$TicketDetails->GreaterthanTwohour;
			$GreaterthanTwohourPercentage = ($TotalCnt > 0) ? (($GreaterthanTwohour * 100) / $TotalCnt) : 0;
			$GreaterthanTwohourPercentage=round($GreaterthanTwohourPercentage,2);
			
			$GreaterthanFourhour=$TicketDetails->GreaterthanFourhour;
			$GreaterthanFourhourPercentage=($TotalCnt > 0) ? (($GreaterthanFourhour * 100) / $TotalCnt) : 0;
			$GreaterthanFourhourPercentage=round($GreaterthanFourhourPercentage,2);
			
			$GreaterthanSixhour=$TicketDetails->GreaterthanSixhour;
			$GreaterthanSixhourPercentage=($TotalCnt > 0) ? (($GreaterthanSixhour * 100) / $TotalCnt) : 0;;
			$GreaterthanSixhourPercentage=round($GreaterthanSixhourPercentage,2);
			
			
			$NotRespondedCount = isset($NotRespondedArray[$UserId]) ? $NotRespondedArray[$UserId] : 0;
			$NotRespondedMailPercentage = ($TotalCnt > 0) ? (($NotRespondedCount * 100) / $TotalCnt) : 0;
			$NotRespondedMailPercentage = round($NotRespondedMailPercentage, 2);

			
			$DisplayUserName=$UserId;
			if(array_key_exists($UserId,$getActiveUsersList))
			{
				$DisplayUserName=$getActiveUsersList[$UserId]['name'];
			}
		@endphp
	<tr>
		<td>{{$DisplayUserName}}</td>
		<td>
            @if(array_key_exists($UserId, $GetAllUserandRole))
                @foreach($GetAllUserandRole[$UserId]['Role'] as $EachRoleId)
                    {{$GetAllRoles[$EachRoleId]}}&nbsp;&nbsp;
                    <br>
                @endforeach
            @endif
        </td>
		<td>
			@if(array_key_exists($UserId,$GetAllUserandRole))
				@foreach($GetAllUserandRole[$UserId]['Team'] as $EachTeamId)
						@if(array_key_exists($EachTeamId,$GetAllTeams))
						{{$GetAllTeams[$EachTeamId]}}&nbsp;&nbsp;<br>
					@endif
				@endforeach
			@endif
			</td>
		<td>
			{{$TotalCnt}}
		</td>
		<td>
			<a href="{{url('DetailofUserFRTATTicketReport/Lessthanonehour/1/'.$SearchDate.'/'.$UserId)}}" class="text-primary" target='_blank'>
			{{$Lessthanonehour}} 
			</a>( {{$LessthanonehourPercentage}} %)
		</td>
		<td>
			<a href="{{url('DetailofUserFRTATTicketReport/GreaterthanOnehour/1/'.$SearchDate.'/'.$UserId)}}" class="text-primary" target='_blank'>
			{{$GreaterthanOnehour}}
			</a>( {{$GreaterthanOnehourPercentage}} %)
		</td>
		<td>
			<a href="{{url('DetailofUserFRTATTicketReport/GreaterthanTwohour/1/'.$SearchDate.'/'.$UserId)}}" class="text-primary" target='_blank'>
			{{$GreaterthanTwohour}}
			</a>( {{$GreaterthanTwohourPercentage}} %)
		</td>
		<td>
			<a href="{{url('DetailofUserFRTATTicketReport/GreaterthanFourhour/1/'.$SearchDate.'/'.$UserId)}}" class="text-primary" target='_blank'>
			{{$GreaterthanFourhour}}
			</a>( {{$GreaterthanFourhourPercentage}} %)
		</td>
		<td>
			<a href="{{url('DetailofUserFRTATTicketReport/GreaterthanSixhour/1/'.$SearchDate.'/'.$UserId)}}" class="text-primary" target='_blank'>
			{{$GreaterthanSixhour}}
			</a>( {{$GreaterthanSixhourPercentage}} %)
		</td>
		<td>
			<a href="{{url('DetailofUserFRTATTicketReport/NotRespondedMail/1/'.$SearchDate.'/'.$UserId)}}" class="text-primary" target='_blank'>
			{{$NotRespondedCount}}
			</a>( {{$NotRespondedMailPercentage}} %)
		</td>
	</tr>
	@endforeach
</table>

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script>
(function() {
        var tableId = '{{ $tableId }}';
        var buttonId = '{{ $buttonId }}';
        var fileName = 'USERFRTATReport.xlsx';

        function exportToExcel() {
            var table = document.getElementById(tableId);
            if (!table) {
                console.error('Table not found:', tableId);
                return;
            }

            if (typeof XLSX === 'undefined') {
                console.error('XLSX library not loaded');
                return;
            }

            try {
                var wb = XLSX.utils.table_to_book(table, {
                    sheet: "Sheet JS"
                });
                var wbout = XLSX.write(wb, {
                    bookType: 'xlsx',
                    type: 'array'
                });
                var blob = new Blob([wbout], {
                    type: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
                });
                var url = URL.createObjectURL(blob);
                var a = document.createElement('a');
                a.href = url;
                a.download = fileName;
                document.body.appendChild(a);
                a.click();
                setTimeout(function() {
                    document.body.removeChild(a);
                    window.URL.revokeObjectURL(url);
                }, 0);
            } catch (error) {
                console.error('Error exporting Excel:', error);
            }
        }

        var button = document.getElementById(buttonId);
        if (button) {
            button.addEventListener('click', exportToExcel);
        } else {
            console.error('Export button not found:', buttonId);
        }
    })();
	
</script>