@php
	$file_type = "vnd.ms-excel";
	$file_name= "DetailHourswiseMailBoxIdReportXL.xls";
	header("Content-Type: application/$file_type");
	header("Content-Disposition: attachment; filename=$file_name");
	
	$XAxis=$Result['XAxis'];
	$YAxis=$Result['YAxis'];
	$Result=$Result['Result'];
	// echo "<pre>";
	// print_r($YAxis);
	// echo "</pre>";
	$a=1;
	$Test="00:00:00";
	//echo date('h',strtotime($Test));
	$YAxisTotal=array();
	$XAxisTotal=array();
@endphp

<table border='1'>
	<tr>
		<th>S.No</th>
		<th>Mail Box Id</th>
		@foreach($YAxis as $EachYAxis)
			<th>
			@php
				$l=$EachYAxis.":00:00";
				$m=$EachYAxis+1;
				$n=$m.":00:00";
				$o=date('h a',strtotime($l));
				$p=date('h a',strtotime($n));
				echo $o." - ".$p;
			@endphp
			</th>
		@endforeach
			<th></th>
	</tr>
	@foreach($XAxis as $EachXAxis)
		<tr>
			<td>{{$a}}</td>
			<td>
				@if($EachXAxis)
					{{$EachXAxis}}
				@else
					(EMPTY)
				@endif
			</td>
			@foreach($YAxis as $EachYAxis)
			<td>
				@php
					if(array_key_exists($EachYAxis,$YAxisTotal))
					{
						$YAxisTotal[$EachYAxis]=$YAxisTotal[$EachYAxis]+$Result[$EachXAxis][$EachYAxis];
					}
					else
					{
						$YAxisTotal[$EachYAxis]=$Result[$EachXAxis][$EachYAxis];
					}
					if(array_key_exists($EachXAxis,$XAxisTotal))
					{
						$XAxisTotal[$EachXAxis]=$XAxisTotal[$EachXAxis]+$Result[$EachXAxis][$EachYAxis];
					}
					else
					{
						$XAxisTotal[$EachXAxis]=$Result[$EachXAxis][$EachYAxis];
					}
				@endphp
				{{$Result[$EachXAxis][$EachYAxis]}}
			</td>
		@endforeach
			<td>
				{{$XAxisTotal[$EachXAxis]}}
			</td>
		</tr>
		@php
		$a++;
		@endphp
	@endforeach
	<tr>
		<td colspan='2'>Total</td>
		@foreach($YAxis as $EachYAxis)
			<td>
				{{$YAxisTotal[$EachYAxis]}}
			</td>
		@endforeach
		<td></td>
	</tr>
</table>