@php
	// echo "<pre>";
		// print_r($GetREsult);
		// print_r($getActiveUsersList);
	// 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;
	$UserRequest=0;
	if($UserImplodeencode)
	{
		$UserRequest=$UserImplodeencode;
	}
	$GetREsultQueryEncode=base64_encode($GetREsultQuery);
@endphp
<h3>Ageing Report - UserWise</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="ExcelUserwiseDaysReportNew()">Export Excel</button>
	</div>
</div>
<table class="table table-no-space table-bordered" id="DisplayUserwiseDaysReport">
	<tr>
		<th>User 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($getActiveUsersList as $UserId=>$UserDetails)
		@php
			$TempTotal=0;
			$UserName=$UserDetails['name'];
			$Today=0;
			$onetoThreeDays=0;
			$ThreetosevenDays=0;
			$EighttoFiftenDays=0;
			$SixtentoThirtyDays=0;
			$belowThirty=0;
			$TempTotal=0;
			
			if(array_key_exists($UserId,$GetREsult))
			{
				$EachTeamResult=$GetREsult[$UserId];
				$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>{{$UserName}}</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/Today/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$Today}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/onetoThreeDays/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$onetoThreeDays}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/ThreetosevenDays/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$ThreetosevenDays}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/EighttoFiftenDays/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$EighttoFiftenDays}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/SixtentoThirtyDays/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$SixtentoThirtyDays}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/belowThirty/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$belowThirty}}
			</a>
			</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReport/ALL/1',$UserId)}}" class="text-primary" target='_blank'>
			{{$TempTotal}}
			</a>
		</td>
	</tr>
	@endforeach
	<tr>
		<td>Grand Total</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReportUserBased/Today/1',$UserRequest)}}" class="text-primary" target='_blank'>
			{{$TodayTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReportUserBased/onetoThreeDays/1',$UserRequest)}}" class="text-primary" target='_blank'>
			{{$onetoThreeDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReportUserBased/ThreetosevenDays/1',$UserRequest)}}" class="text-primary" target='_blank'>
			{{$ThreetosevenDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReportUserBased/EighttoFiftenDays/1',$UserRequest)}}" class="text-primary" target='_blank'>
			{{$EighttoFiftenDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReportUserBased/SixtentoThirtyDays/1',$UserRequest)}}" class="text-primary" target='_blank'>
			{{$SixtentoThirtyDaysTotalCount}}
			</a>
		</td>
		<td>
			<a href="{{url('DetailofUserWiseDayReportUserBased/belowThirty/1',$UserRequest)}}" class="text-primary" target='_blank'>
			{{$belowThirtyTotalCount}}
			</a>
		</td>
		<td>
			{{$OverAllTotalTotalCount}}
		</td>
	</tr>
</table>