@php

$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
<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="ExcelDetailHourwiseReport()">Export Excel</button>
	</div>
</div>
<table class="table style-2 table-hover no-footer" id="table1">
	<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
				<a style="cursor:pointer" data-bs-toggle="modal" data-bs-target="#MailBoxModal" onclick="MailboxDrillDown('{{$EachXAxis}}','{{$EachYAxis}}',1)">{{$Result[$EachXAxis][$EachYAxis]}}</a>
			</td>
		@endforeach
			<td>
				<a style="cursor:pointer" data-bs-toggle="modal" data-bs-target="#MailBoxModal" onclick="MailboxDrillDown('{{$EachXAxis}}','',1)">{{$XAxisTotal[$EachXAxis]}}</a>
			</td>
		</tr>
		@php
		$a++;
		@endphp
	@endforeach
	<tr>
		<td colspan='2'>Total</td>
		@foreach($YAxis as $EachYAxis)
			<td>
				<a style="cursor:pointer" data-bs-toggle="modal" data-bs-target="#MailBoxModal" onclick="MailboxDrillDown('','{{$EachYAxis}}',1)">{{$YAxisTotal[$EachYAxis]}}</a>
			</td>
		@endforeach
		<td></td>
	</tr>
</table>