@php
	$file_type = "vnd.ms-excel";
	$file_name= "DayEndReport.xls";
	header("Content-Type: application/$file_type");
	header("Content-Disposition: attachment; filename=$file_name");
@endphp

<h3>Day End Report</h3>
<div class="table-responsive" id="DayEndReport">
	@foreach($GetAllTeams as $EachTeamId=>$EachTeamName)
		@php
			$TeamUsersDet=$FinalResultTeamArray[$EachTeamId];
			$sampleArrayNew=array('eachUsers'=>$EachTeamId,'Date'=>$Date);
			$TotalTodayCreatedTicket=0;
			$TotalTodayCall=0;
			$TotalTodayEmail=0;
			$TotalTodayClosed=0;
			$TotalAbsoluteClosed=0;
			$TotalOherClosedCondition=0;
			$TotalAllOpenTickets=0;
			$Totallastthreedaysopen=0;
			$TotallastSevendaysopen=0;
			$TotalEightotfifteen=0;
			$Totalsixtenthtothirty=0;
			$Totalmorethanthirty=0;
		@endphp
		@if(!empty($TeamUsersDet))
			<h4>{{$EachTeamName}}</h4>
			<table border='1'>
				<tr>
					<td >S.No</td>
					<td >Ticket Created  </td>
					<td >Call</td>
					<td >Email</td>
					<td >Over All Closed Tickets</td>
					<td >Absolute Closed Tickets</td>
					<td >Other Closed Tickets</td>
					<td >Total Open Tickets</td>
					<td > <3 Days </td>
					<td >4- 7 Days </td>
					<td >8 - 15 Days </td>
					<td >16 - 30 Days</td>
					<td >> 30 Days</td>
				</tr>
			@foreach($TeamUsersDet as $eachUsers)
				@if(array_key_exists($eachUsers,$GetREsult))
				@php
					$TempUserDetArray=$GetREsult[$eachUsers];
					$name=$TempUserDetArray->name;
					$TodayCreatedTicket=$TempUserDetArray->TodayCreatedTicket;
					$TodayCall=$TempUserDetArray->TodayCall;
					$TodayEmail=$TempUserDetArray->TodayEmail;
					$TodayClosed=$TempUserDetArray->TodayClosed;
					$AbsoluteClosed=$TempUserDetArray->AbsoluteClosed;
					$OherClosedCondition=$TempUserDetArray->OherClosedCondition;
					$AllOpenTickets=$TempUserDetArray->AllOpenTickets;
					$lastthreedaysopen=$TempUserDetArray->lastthreedaysopen;
					$lastSevendaysopen=$TempUserDetArray->lastSevendaysopen;
					$Eightotfifteen=$TempUserDetArray->Eightotfifteen;
					$sixtenthtothirty=$TempUserDetArray->sixtenthtothirty;
					$morethanthirty=$TempUserDetArray->morethanthirty;
					$sampleArray=array('eachUsers'=>$eachUsers,'Date'=>$Date);
					$TotalTodayCreatedTicket=$TotalTodayCreatedTicket+$TodayCreatedTicket;
					$TotalTodayCall=$TotalTodayCall+$TodayCall;
					$TotalTodayEmail=$TotalTodayEmail+$TodayEmail;
					$TotalTodayClosed=$TotalTodayClosed+$TodayClosed;
					$TotalAbsoluteClosed=$TotalAbsoluteClosed+$AbsoluteClosed;
					$TotalOherClosedCondition=$TotalOherClosedCondition+$OherClosedCondition;
					$TotalAllOpenTickets=$TotalAllOpenTickets+$AllOpenTickets;
					$Totallastthreedaysopen=$Totallastthreedaysopen+$lastthreedaysopen;
					$TotallastSevendaysopen=$TotallastSevendaysopen+$lastSevendaysopen;
					$TotalEightotfifteen=$TotalEightotfifteen+$Eightotfifteen;
					$Totalsixtenthtothirty=$Totalsixtenthtothirty+$sixtenthtothirty;
					$Totalmorethanthirty=$Totalmorethanthirty+$morethanthirty;
				@endphp
				<tr>
					<td >{{$name}}</td>
					<td>
							{{$TodayCreatedTicket}}
					</td>
					<td>
							{{$TodayCall}}
					</td>
					<td>
							{{$TodayEmail}}
					</td>
					<td>
							{{$TodayClosed}}
					</td>
					<td>
							{{$AbsoluteClosed}}
					<td>
							{{$OherClosedCondition}}
					</td>
					<td>
							{{$AllOpenTickets}}
					</td> 
					<td>
							{{$lastthreedaysopen}}
					</td>
					<td>
							{{$lastSevendaysopen}}
					</td>
					<td>
							{{$Eightotfifteen}}
						</a>
					</td>
					<td>
							{{$sixtenthtothirty}}
					</td>
					<td>
							{{$morethanthirty}}
					</td>
				</tr>
				@endif
			@endforeach
			<tr>
				<td>Grand Total</td>
				<td>
					{{$TotalTodayCreatedTicket}}
				</td>
				<td>
					{{$TotalTodayCall}}
				</td>
				<td>
					{{$TotalTodayEmail}}
				</td>
				<td>
					{{$TotalTodayClosed}}
				</td>
				<td>
					{{$TotalAbsoluteClosed}}
				</td>          
				<td>
					{{$TotalOherClosedCondition}}
				</td>
				<td>
					{{$TotalAllOpenTickets}}
				</td>
				<td>
					{{$Totallastthreedaysopen}}
				</td>
				<td>
					{{$TotallastSevendaysopen}}
				</td>
				<td>
					{{$TotalEightotfifteen}}
				</td>
				<td>
					{{$Totalsixtenthtothirty}}
				</td>
				<td>
					{{$Totalmorethanthirty}}
				</td>
			</tr>
			</table>
			<table >
				<tr>
					<td></td>
				</tr>
			</table>
		@endif
	@endforeach
</div>