@php $shiftDeptWiseCountArr = []; $countractorWiseCountArr = []; @endphp @foreach ($shifts as $shift) @foreach ($dateList as $date) @endforeach @foreach ($dateList as $date) @endforeach @foreach ($departments as $department) @foreach ($dateList as $date) @php $count = $attendanceProcess->getEmployeePresentCount($shift, $department, $date, $organization, $locationIds, $sublocationIds, $designationIds, $contractorIds); $shiftDeptWiseCountArr[$shift->id][$department->id]['total'] = (@$shiftDeptWiseCountArr[$shift->id][$department->id]['total'] ?: 0) + $count; $shiftDeptWiseCountArr[$shift->id]['all'][$date] = (@$shiftDeptWiseCountArr[$shift->id]['all'][$date] ?: 0) + $count; $shiftDeptWiseCountArr[$shift->id]['all']['total'] = (@$shiftDeptWiseCountArr[$shift->id]['all']['total'] ?: 0) + $count; $shiftDeptWiseCountArr['all'][$department->id][$date] = (@$shiftDeptWiseCountArr['all'][$department->id][$date] ?: 0) + $count; $shiftDeptWiseCountArr['all'][$department->id]['total'] = (@$shiftDeptWiseCountArr['all'][$department->id]['total'] ?: 0) + $count; $shiftDeptWiseCountArr['all']['all'][$date] = (@$shiftDeptWiseCountArr['all']['all'][$date] ?: 0) + $count; $shiftDeptWiseCountArr['all']['all']['total'] = (@$shiftDeptWiseCountArr['all']['all']['total'] ?: 0) + $count; @endphp @endforeach @endforeach @foreach ($dateList as $date) @endforeach @endforeach //total table @foreach ($dateList as $date) @endforeach @foreach ($dateList as $date) @endforeach @foreach ($departments as $department) @foreach ($dateList as $date) @endforeach @endforeach @foreach ($dateList as $date) @endforeach //Contractor table @foreach ($dateList as $date) @endforeach @foreach ($contractors as $contractor) @foreach ($dateList as $date) @php $count = $attendanceProcess->getEmployeePresentByContractorCount($contractor, $date, $organization, $locationIds, $sublocationIds, $designationIds, [], null); $countractorWiseCountArr[$contractor->id]['total'] = (@$countractorWiseCountArr[$contractor->id]['total'] ?: 0) + $count; $countractorWiseCountArr['all'][$date] = (@$countractorWiseCountArr['all'][$date] ?: 0) + $count; $countractorWiseCountArr['all']['total'] = (@$countractorWiseCountArr['all']['total'] ?: 0) + $count; @endphp @endforeach @endforeach @foreach ($dateList as $date) @endforeach

{{ $organization->name }} Functional MIS Report - {{ $month_name }} {{ $year }}
Date	{{ date('d-M', strtotime($date)) }}
Shift	{{ $shift->name }}	Total
{{ $department->name }}	{{ $count }}	{{ $shiftDeptWiseCountArr[$shift->id][$department->id]['total'] }}
Total	{{ $shiftDeptWiseCountArr[$shift->id]['all'][$date] }}	{{ $shiftDeptWiseCountArr[$shift->id]['all']['total'] }}
Date	{{ date('d-M', strtotime($date)) }}
Shift	TTL	Total
{{ $department->name }}	{{ $shiftDeptWiseCountArr['all'][$department->id][$date] }}	{{ $shiftDeptWiseCountArr['all'][$department->id]['total'] }}
Total	{{ $shiftDeptWiseCountArr['all']['all'][$date] }}	{{ $shiftDeptWiseCountArr['all']['all']['total'] }}
Date	{{ date('d-M', strtotime($date)) }}	TTL
{{ $contractor->name }}	{{ $count }}	{{ $countractorWiseCountArr[$contractor->id]['total'] }}
Total	{{ $countractorWiseCountArr['all'][$date] }}	{{ $countractorWiseCountArr['all']['total'] }}