@php
	$todaydate=$SearchDate;
	$YesterdayDate=date('Y-m-d',strtotime("$SearchDate -1 days"));
	$TomorowDate=date('Y-m-d',strtotime("$SearchDate +1 days"));
	$a=0;
	$b=0;
	$c=0;
	$d=0;
	$e=0;
	$f=0;
	$g=0;
	$h=0;
	$i=0;
	$j=0;
	$k=0;
	$l=0;
	$m=0;
	$n=0;
	$o=0;
	$p=0;
	$q=0;
	$r=0;
	$s=0;
	//echo "<pre>";
	//print_r($GetTaskDetail);
	//echo "</pre>";
@endphp
<div class="table-responsive">
	<table class="table table-bordered mb-4">
		<thead>
			<tr>
				<th class="text-center" rowspan="3">Users</th>
				<th colspan="2" align='center'><br>{{$YesterdayDate}}</th>
				<th colspan="8" align='center'><br>{{$todaydate}}</th>
				<th colspan="2" align='center'>{{$TomorowDate}}</th>
				<th colspan="2" align='center'>InComplete</th>
				<th colspan="2" align='center'>Aim / Target</th>
				<th colspan="2" align='center'>Total</th>
			</tr>
		</thead>
		<tr align='center' >
			<td rowspan='2'></td>
			<td rowspan='2'>Task</td>
			<td rowspan='2'>Ticket</td>
			<td  colspan="2">Planned</td>
			<td  colspan="2">UnPlanned</td>
			<td  colspan="2">Closed</td>
			<td  colspan="2">Due</td>
			<td rowspan='2'>Task</td>
			<td rowspan='2'>Ticket</td>
			<td rowspan='2'>Task</td>
			<td rowspan='2'>Ticket</td>
			<td rowspan='2'>Task</td>
			<td rowspan='2'>Ticket</td>
			<td rowspan='2'>Task</td>
			<td rowspan='2'>Ticket</td>
		</tr>
		<tr >
		  <td>Task</td>
		  <td>Ticket</td>
		  <td>Task</td>
		  <td>Ticket</td>
		  <td>Task</td>
		  <td>Ticket</td>
		  <td>Task</td>
		  <td>Ticket</td>
		</tr>
		<tbody>
			@foreach ($GetAllUser as $EachUserId=>$EachUser)
			@php
				$EachDetailTaskArray=$GetTaskDetail[$EachUserId];
				$EachDetailTicketArray=$GetTicketDetail[$EachUserId];
				$TodayUnPlannedMailCnt=$EachDetailTicketArray['TodayUnPlannedMail']['Cnt'];
				$m=$m+$TodayUnPlannedMailCnt;
				$YesterdaytakCnt=$EachDetailTaskArray['Yesterday']['Cnt'];
				$a=$a+$YesterdaytakCnt;
				$YesterdayTicketCnt=$EachDetailTicketArray['Yesterday']['Cnt'];
				$b=$b+$YesterdayTicketCnt;
				$TodayPlannedTaskCnt=$EachDetailTaskArray['TodayPlanned']['Cnt'];
				$c=$c+$TodayPlannedTaskCnt;
				$TodayPlannedTicketCnt=$EachDetailTicketArray['TodayPlanned']['Cnt'];
				$d=$d+$TodayPlannedTicketCnt;
				$TodayUnPlannedTaskCnt=$EachDetailTaskArray['TodayUnPlanned']['Cnt'];
				$e=$e+$TodayUnPlannedTaskCnt;
				$TodayUnPlannedTicketCnt=$EachDetailTicketArray['TodayUnPlanned']['Cnt'];
				$f=$f+$TodayUnPlannedTicketCnt;
				$TodayClosedTaskCnt=$EachDetailTaskArray['TodayClosed']['Cnt'];
				$g=$g+$TodayClosedTaskCnt;
				$TodayClosedTicketCnt=$EachDetailTicketArray['TodayClosed']['Cnt'];
				$h=$h+$TodayClosedTicketCnt;
				$TodayDueTaskCnt=$EachDetailTaskArray['TodayDue']['Cnt'];
				$i=$i+$TodayDueTaskCnt;
				$TodayDueTicketCnt=$EachDetailTicketArray['TodayDue']['Cnt'];
				$j=$j+$TodayDueTicketCnt;
				$TomPlannedTaskCnt=$EachDetailTaskArray['TomPlanned']['Cnt'];
				$k=$k+$TomPlannedTaskCnt;
				$TomPlannedTicketCnt=$EachDetailTicketArray['TomPlanned']['Cnt'];
				$l=$l+$TomPlannedTicketCnt;
				$InCompleteTaskCnt=$EachDetailTaskArray['InComplete']['Cnt'];
				$n=$n+$InCompleteTaskCnt;
				$InCompleteTicketCnt=$EachDetailTicketArray['InComplete']['Cnt'];
				$o=$o+$InCompleteTicketCnt;
				$AimTargetTaskCnt=$EachDetailTaskArray['AimTarget']['Cnt'];
				$p=$p+$AimTargetTaskCnt;
				$AimTargetTicketCnt=$EachDetailTicketArray['AimTarget']['Cnt'];
				$q=$q+$AimTargetTicketCnt;
				$TotalTaskCnt=$EachDetailTaskArray['Total']['Cnt'];
				$r=$r+$TotalTaskCnt;
				$TotalTicketCnt=$EachDetailTicketArray['Total']['Cnt'];
				$s=$s+$TotalTicketCnt;
				$pass_arrayforYesterday=array("CheckDate"=>$todaydate,"EachUserId"=>"$EachUserId");
				$pass_arrayforToday=array("CheckDate"=>$todaydate,"EachUserId"=>"$EachUserId");
				$pass_arrayforTomorow=array("CheckDate"=>$todaydate,"EachUserId"=>"$EachUserId");
			@endphp
			<tr>						
				<td>{{$EachUser}}</td>	
				<td title="{{$EachDetailTaskArray['Yesterday']['Details']}}" style="cursor:pointer" >
					<a href="{{url('ViewDetailofTaskandTicket/Yesterday/Task',$pass_arrayforYesterday)}}" title="{{$EachDetailTaskArray['Yesterday']['Details']}}" target='_blank'>{{$YesterdaytakCnt}}</a>
				</td>
				<td  style="cursor:pointer">
					<a href="{{url('ViewDetailofTaskandTicket/Yesterday/Ticket',$pass_arrayforYesterday)}}" title="{{$EachDetailTicketArray['Yesterday']['Details']}}" target='_blank'>{{$YesterdayTicketCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/TodayPlanned/Task',$pass_arrayforToday)}}" title="{{$EachDetailTaskArray['TodayPlanned']['Details']}}" target='_blank'>{{$TodayPlannedTaskCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/TodayPlanned/Ticket',$pass_arrayforToday)}}" title="{{$EachDetailTicketArray['TodayPlanned']['Details']}}" target='_blank'>{{$TodayPlannedTicketCnt}}</a>
				</td>
				<td style="cursor:pointer" >
					<a href="{{url('ViewDetailofTaskandTicket/TodayUnPlanned/Task',$pass_arrayforToday)}}" title="{{$EachDetailTaskArray['TodayUnPlanned']['Details']}}" target='_blank'>{{$TodayUnPlannedTaskCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/TodayUnPlanned/Ticket',$pass_arrayforToday)}}" title="{{$EachDetailTicketArray['TodayUnPlanned']['Details']}}" target='_blank'>{{$TodayUnPlannedTicketCnt}}</a>
					@if($TodayUnPlannedMailCnt>0)
						<a href="{{url('ViewDetailofTaskandTicket/TodayUnPlannedMail/Ticket',$pass_arrayforToday)}}" title="{{$EachDetailTicketArray['TodayUnPlannedMail']['Details']}}" target='_blank'><font color="red">{{$TodayUnPlannedMailCnt}}</font></a>
					@endif
				</td>
				<td style="cursor:pointer">
					<a href="{{url('ViewDetailofTaskandTicket/TodayClosed/Task',$pass_arrayforToday)}}" title="{{$EachDetailTaskArray['TodayClosed']['Details']}}" target='_blank'>{{$TodayClosedTaskCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/TodayClosed/Ticket',$pass_arrayforToday)}}" title="{{$EachDetailTicketArray['TodayClosed']['Details']}}" target='_blank'>{{$TodayClosedTicketCnt}}</a>
				</td>
				<td style="cursor:pointer">
					<a href="{{url('ViewDetailofTaskandTicket/TodayDue/Task',$pass_arrayforToday)}}" title="{{$EachDetailTaskArray['TodayDue']['Details']}}" target='_blank'>{{$TodayDueTaskCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/TodayDue/Ticket',$pass_arrayforToday)}}" title="{{$EachDetailTicketArray['TodayDue']['Details']}}" target='_blank'>{{$TodayDueTicketCnt}}</a>
				</td>
				<td style="cursor:pointer">
					<a href="{{url('ViewDetailofTaskandTicket/TomPlanned/Task',$pass_arrayforTomorow)}}" title="{{$EachDetailTaskArray['TomPlanned']['Details']}}" target='_blank'>{{$TomPlannedTaskCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/TomPlanned/Ticket',$pass_arrayforTomorow)}}" title="{{$EachDetailTicketArray['TomPlanned']['Details']}}" target='_blank'>{{$TomPlannedTicketCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/InComplete/Task',$pass_arrayforTomorow)}}" title="{{$EachDetailTaskArray['InComplete']['Details']}}" target='_blank'>{{$InCompleteTaskCnt}}</a>
				</td>
				<td>
					<a href="{{url('ViewDetailofTaskandTicket/InComplete/Ticket',$pass_arrayforTomorow)}}" title="{{$EachDetailTicketArray['InComplete']['Details']}}" target='_blank'>{{$InCompleteTicketCnt}}</a>
				</td>
				<td><a href="{{url('ViewDetailofTaskandTicket/AimTarget/Task',$pass_arrayforTomorow)}}" title="{{$EachDetailTaskArray['AimTarget']['Details']}}" target='_blank'>{{$AimTargetTaskCnt}}</a></td>
				<td><a href="{{url('ViewDetailofTaskandTicket/AimTarget/Ticket',$pass_arrayforTomorow)}}" title="{{$EachDetailTicketArray['AimTarget']['Details']}}" target='_blank'>{{$AimTargetTicketCnt}}</a></td>
				<td><a href="{{url('ViewDetailofTaskandTicket/Total/Task',$pass_arrayforTomorow)}}" title="{{$EachDetailTaskArray['Total']['Details']}}" target='_blank'>{{$TotalTaskCnt}}</a></td>
				<td><a href="{{url('ViewDetailofTaskandTicket/Total/Ticket',$pass_arrayforTomorow)}}" title="{{$EachDetailTicketArray['Total']['Details']}}" target='_blank'>{{$TotalTicketCnt}}</a></td>
			</tr>
			@endforeach
			<tr>
				<td>Total</td>
				<td>{{$a}}</td>
				<td>{{$b}}</td>
				<td>{{$c}}</td>
				<td>{{$d}}</td>
				<td>{{$e}}</td>
				<td>{{$f}} <font color="red">{{$m}}</font></td>
				<td>{{$g}}</td>
				<td>{{$h}}</td>
				<td>{{$i}}</td>
				<td>{{$j}}</td>
				<td>{{$k}}</td>
				<td>{{$l}}</td>
				<td>{{$n}}</td>
				<td>{{$o}}</td>
				<td>{{$p}}</td>
				<td>{{$q}}</td>
				<td>{{$r}}</td>
				<td>{{$s}}</td>
			</tr>
		</tbody>
	</table>
</div>