@php
	// echo "<pre>";
		// print_r($GetREsult);
	// echo "</pre>";
	$TodayDate=date('Y-m-d');
	$oneDays=date('Y-m-d',strtotime("-1 days"));
	$ThreeDays=date('Y-m-d',strtotime("-3 days"));
	$FourDays=date('Y-m-d',strtotime("-4 days"));
	$SevenDays=date('Y-m-d',strtotime("-7 days"));
	$EightDays=date('Y-m-d',strtotime("-8 days"));
	$FiftenDays=date('Y-m-d',strtotime("-15 days"));
	$SixtenDays=date('Y-m-d',strtotime("-16 days"));
	$ThirtyDays=date('Y-m-d',strtotime("-30 days"));
	$TodayTotalCount=0;
	$onetoThreeDaysTotalCount=0;
	$ThreetosevenDaysTotalCount=0;
	$EighttoFiftenDaysTotalCount=0;
	$SixtentoThirtyDaysTotalCount=0;
	$belowThirtyTotalCount=0;
	$OverAllTotalTotalCount=0;
	$TeamId=0;
	if($TeamImplodeencode)
	{
		$TeamId=$TeamImplodeencode;
	}
@endphp
<h3>Ageing Report-Team wise</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="ExcelAgeingTeamwise()">Export Excel</button>
	</div>
</div>
<table class="table table-no-space table-bordered" id="AgeingReportTeamwise">
	<tr>
		<th>Team Name</th>
		<th>0-1 Days <br>({{$TodayDate}})</th>
		<th>1-3 Days  <br>({{$oneDays}} - {{$ThreeDays}})</th>
		<th>4-7 Days  <br>({{$FourDays}} - {{$SevenDays}})</th>
		<th>8-15 Days <br>({{$EightDays}} - {{$FiftenDays}})</th>
		<th>16-30 Days <br>({{$SixtenDays}} - {{$ThirtyDays}})</th>
		<th>>30 Days <br> > ({{$ThirtyDays}})</th>
		<th>Grand Total</th>
	</tr>
	@foreach($GetAllTeams as $EachTeamId=>$EachTeamNamme)
		@php
			$TempTotal=0;
			$EachTeamResult=$GetREsult[$EachTeamId][0];
			$Today=$EachTeamResult->Today;
			$onetoThreeDays=$EachTeamResult->onetoThreeDays;
			$ThreetosevenDays=$EachTeamResult->ThreetosevenDays;
			$EighttoFiftenDays=$EachTeamResult->EighttoFiftenDays;
			$SixtentoThirtyDays=$EachTeamResult->SixtentoThirtyDays;
			$belowThirty=$EachTeamResult->belowThirty;
			$TempTotal=$Today+$onetoThreeDays+$ThreetosevenDays+$EighttoFiftenDays+$SixtentoThirtyDays+$belowThirty;
			
			$TodayTotalCount=$TodayTotalCount+$Today;
			$onetoThreeDaysTotalCount=$onetoThreeDaysTotalCount+$onetoThreeDays;
			$ThreetosevenDaysTotalCount=$ThreetosevenDaysTotalCount+$ThreetosevenDays;
			$EighttoFiftenDaysTotalCount=$EighttoFiftenDaysTotalCount+$EighttoFiftenDays;
			$SixtentoThirtyDaysTotalCount=$SixtentoThirtyDaysTotalCount+$SixtentoThirtyDays;
			$belowThirtyTotalCount=$belowThirtyTotalCount+$belowThirty;
			$OverAllTotalTotalCount=$OverAllTotalTotalCount+$TempTotal;
		@endphp
	<tr>
		<td>{{$EachTeamNamme}}</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/Today/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$Today}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/onetoThreeDays/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$onetoThreeDays}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/ThreetosevenDays/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$ThreetosevenDays}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/EighttoFiftenDays/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$EighttoFiftenDays}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/SixtentoThirtyDays/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$SixtentoThirtyDays}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/belowThirty/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$belowThirty}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReport/ALL/1',$EachTeamId)}}" class="text-primary" target='_blank'>
			{{$TempTotal}}
			</a>
		</td>
	</tr>
	@endforeach
	<tr>
		<td>Grand Total</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReportwithTeamBased/Today/1',$TeamId)}}" class="text-primary" target='_blank'>
			{{$TodayTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReportwithTeamBased/onetoThreeDays/1',$TeamId)}}" class="text-primary" target='_blank'>
			{{$onetoThreeDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReportwithTeamBased/ThreetosevenDays/1',$TeamId)}}" class="text-primary" target='_blank'>
			{{$ThreetosevenDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReportwithTeamBased/EighttoFiftenDays/1',$TeamId)}}" class="text-primary" target='_blank'>
			{{$EighttoFiftenDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReportwithTeamBased/SixtentoThirtyDays/1',$TeamId)}}" class="text-primary" target='_blank'>
			{{$SixtentoThirtyDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofTeamWiseDayReportwithTeamBased/belowThirty/1',$TeamId)}}" class="text-primary" target='_blank'>
			{{$belowThirtyTotalCount}}
			</a>
		</td>
		<td>{{$OverAllTotalTotalCount}}</td>
	</tr>
</table>