@foreach($results->where('fkDepartmentId',$ad->id) as $res) @php $myArray = explode(',', $res->totalWeekend); $offday=[]; $dateDay = $startDate;//use your date to get month and year $year = $dateDay->year; $month = $dateDay->month; $days = $dateDay->daysInMonth; $mondays=[]; foreach (range(1, $days) as $day) { $date = \Carbon\Carbon::createFromDate($year, $month, $day); if (in_array(strtolower($date->format('l')),$myArray)) { $mondays[]=($date->day); } } $offday[]=count($mondays); $holidayarray=[]; foreach ($allHoliday as $holiday){ if ((date("m",strtotime($holiday->startDate))==date("m",strtotime($startDate)))&& (date("m",strtotime($holiday->endDate))==date("m",strtotime($endDate)))){ $holidayarray[]=$holiday->noOfDays; }elseif((date("m",strtotime($holiday->startDate))==date("m",strtotime($startDate)))&& (date("m",strtotime($holiday->endDate))!=date("m",strtotime($endDate)))) { $st = \Carbon\Carbon::parse($holiday->startDate); $holidayarray[]=($days-$st->day); }elseif ((date("m",strtotime($holiday->startDate))!=date("m",strtotime($startDate)))&& (date("m",strtotime($holiday->endDate))==date("m",strtotime($endDate)))) { $etd = \Carbon\Carbon::parse($holiday->endDate); $std = \Carbon\Carbon::parse($holiday->endDate)->startOfMonth(); $holidayarray[]=(($etd->diffInDays($std))+1); } } @endphp @endforeach

Name		Total Present	Total Late	Total Absent	Leave	Offday	Holiday	NoShift	Marriage	LWP	N/A	Practice	Team		HR COMENTS
{{$res->empname}}		{{$res->totAttendance}}	{{$res->totalLate}}	@php $diff_in_days = $endDate->daysInMonth; if($res->actualJoinDate !=null ){ $joiningDate = \Carbon\Carbon::parse($res->actualJoinDate); if($joiningDate->year ==date('Y') && $joiningDate->month == date('m')){ $totalLeaveOrOff=($allLeave->where('fkEmployeeId',$res->employeeId)->whereIn('categoryCode',[LEAVE_CATEGORY['Casual'],LEAVE_CATEGORY['Sick'],LEAVE_CATEGORY['NoShift'], LEAVE_CATEGORY['Marriage'],LEAVE_CATEGORY['Vacation'],LEAVE_CATEGORY['Leave with out pay'],LEAVE_CATEGORY['Team Leave']])->where('applicationStatus','Approved')->sum('noOfDays') +array_sum($offday)+$joiningDate->day+array_sum($holidayarray)); echo $absent=((($diff_in_days-$res->totAttendance)-$totalLeaveOrOff)); }else{ $totalLeaveOrOff=($allLeave->where('fkEmployeeId',$res->employeeId)->whereIn('categoryCode',[LEAVE_CATEGORY['Casual'],LEAVE_CATEGORY['Sick'],LEAVE_CATEGORY['NoShift'], LEAVE_CATEGORY['Marriage'],LEAVE_CATEGORY['Vacation'],LEAVE_CATEGORY['Leave with out pay'],LEAVE_CATEGORY['Team Leave']])->where('applicationStatus','Approved')->sum('noOfDays') +array_sum($offday)+array_sum($holidayarray) ); echo $absent=((($diff_in_days-$res->totAttendance)-$totalLeaveOrOff)); } }else{ $totalLeaveOrOff=($allLeave->where('fkEmployeeId',$res->employeeId)->whereIn('categoryCode',[LEAVE_CATEGORY['Casual'],LEAVE_CATEGORY['Sick'],LEAVE_CATEGORY['NoShift'], LEAVE_CATEGORY['Marriage'],LEAVE_CATEGORY['Vacation'],LEAVE_CATEGORY['Leave with out pay'],LEAVE_CATEGORY['Team Leave']])->where('applicationStatus','Approved')->sum('noOfDays') +array_sum($offday)+array_sum($holidayarray) ); echo $absent=((($diff_in_days-$res->totAttendance)-$totalLeaveOrOff)); } @endphp	{{$allLeave->where('fkEmployeeId',$res->employeeId)->whereIn('categoryCode',[LEAVE_CATEGORY['Casual'],LEAVE_CATEGORY['Sick']])->where('applicationStatus','Approved')->sum('noOfDays')}}	{{array_sum($offday)}}	{{array_sum($holidayarray)}}	{{$allLeave->where('fkEmployeeId',$res->employeeId)->where('categoryCode',LEAVE_CATEGORY['NoShift'])->where('applicationStatus','Approved')->sum('noOfDays')}}	{{$allLeave->where('fkEmployeeId',$res->employeeId)->where('categoryCode',LEAVE_CATEGORY['Marriage'])->where('applicationStatus','Approved')->sum('noOfDays')}}	{{$allLeave->where('fkEmployeeId',$res->employeeId)->where('categoryCode',LEAVE_CATEGORY['Leave with out pay'])->where('applicationStatus','Approved')->sum('noOfDays')}}	0	0	{{$allLeave->where('fkEmployeeId',$res->employeeId)->where('categoryCode',LEAVE_CATEGORY['Team Leave'])->where('applicationStatus','Approved')->sum('noOfDays')}}		@foreach($comments->where('fkemployeeId',$res->employeeId) as $comment) {{$comment->comment}} @endforeach