@php
	echo "<pre>";
		// print_r($getActiveUsersList);
		// print_r($ResultDetails);
		// print_r($GetAllUserandRole);
		// print_r($GetAllRoles);
		// print_r($GetAllTeams);
		//print_r($ResultLogReport);
	echo "</pre>";
	$a=0;
	$OverAll['TodayCreatedTicket']=0;
	$OverAll['TodayOpen']=0;
	$OverAll['TodayClosed']=0;
	$OverAll['Others']=0;
@endphp

<h3>User Statistcal Report</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="ExportUserStatReport()" >Export Excel</button>
	</div>
</div>
<table class="table table-no-space table-bordered" id="UserStatReport">
	<tr>
		<th>S.No</th>
		<th>User</th>
		<th>Type of access</th>
		<th>Support / Implementer</th>
		<th>Total Tickets</th>
		<th>Tickets In Progress</th>
		<th>Tickets Closed</th>
		<th>Tickets(of Others Status)</th>
		<th>Hours</th>
	</tr>
	@foreach($getActiveUsersList as $UserId=>$UserDetails)
		@php
			$a++;
			$TodayCreatedTicket=0;
			$TodayOpen=0;
			$TodayClosed=0;
			$Others=0;
			if(array_key_exists($UserId,$ResultDetails))
			{
				$TodayCreatedTicket=$ResultDetails[$UserId]->TodayCreatedTicket;
				$TodayOpen=$ResultDetails[$UserId]->TodayOpen;
				$TodayClosed=$ResultDetails[$UserId]->TodayClosed;
				$Others=$ResultDetails[$UserId]->Others;
			}
			$OverAll['TodayCreatedTicket']=$OverAll['TodayCreatedTicket']+$TodayCreatedTicket;
			$OverAll['TodayOpen']=$OverAll['TodayOpen']+$TodayOpen;
			$OverAll['TodayClosed']=$OverAll['TodayClosed']+$TodayClosed;
			$OverAll['Others']=$OverAll['Others']+$Others;
			$sampleArray=array('eachUsers'=>$UserId,'SearchDate'=>$SearchDate);
		@endphp
		<tr>
			<td>{{$a}}</td>
			<td>{{$UserDetails['name']}}</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>
				<a href="{{url('DetailofUserStatReport/1/TodayCreatedTicket',$sampleArray)}}" class="text-primary" target='_blank'>
				{{$TodayCreatedTicket}}
				</a>
			</td>
			<td>
				<a href="{{url('DetailofUserStatReport/1/TodayOpen',$sampleArray)}}" class="text-primary" target='_blank'>
				{{$TodayOpen}}
				</a>
			</td>
			<td>
				<a href="{{url('DetailofUserStatReport/1/TodayClosed',$sampleArray)}}" class="text-primary" target='_blank'>
				{{$TodayClosed}}
				</a>
			</td>
			<td>
				<a href="{{url('DetailofUserStatReport/1/Others',$sampleArray)}}" class="text-primary" target='_blank'>
				{{$Others}}
				</a>
			</td>
			<td>
				@if(array_key_exists($UserId,$ResultLogReport))	
					@php
						$TotalMinutes=$ResultLogReport[$UserId];
						$Displayhours = intdiv($TotalMinutes, 60).':'. ($TotalMinutes % 60);
					@endphp
					{{$Displayhours}} hrs
				@endif
			</td>
		</tr>
	@endforeach
	<tr>
		<td colspan="4">Total</td>
		<td>{{$OverAll['TodayCreatedTicket']}}</td>
		<td>{{$OverAll['TodayOpen']}}</td>
		<td>{{$OverAll['TodayClosed']}}</td>
		<td>{{$OverAll['Others']}}</td>
		<td></td>
	</tr>
</table>