{{-- total data --}} @foreach ($departments as $department) @php $data = $attendanceProcess->getDepartmentWiseTotalHrs( $department, $organization, $request->date, $request->location_ids, $request->workstation_ids, $request->status, $request->employee_mapped, ); @endphp @endforeach {{-- location wise bifurcation --}} @foreach ($locationWiseData as $locationData) @php $location = $locationData['location']; $departments = $locationData['departments']; @endphp @foreach ($departments as $department) @php $data = $attendanceProcess->getDepartmentWiseTotalHrs( $department, $organization, $request->date, [$location->id], $request->workstation_ids, $request->status, $request->employee_mapped, ); @endphp @endforeach @endforeach

{{ $organization->name }} Department Headcount Report - {{ $request->date }}
All Locations
Departments	Headcounts	OT Eligibility	Comp Off Eligibility	Marked only In Time	Marked only Out Time	Marked Both In & OUT	Below Working Hrs	Below Working Hrs (OT Eligible)	Above Working Hrs	Above Working Hrs (OT Eligible)	Present	Absent	Absenteeism	Total Man Hours Available	Net Man hours Available	Net Man Hours Present	Utilization Net Man Hours Available vs Present
{{ $department->name }}	{{ $department->employee_count }}	{{ $department->ot_eligibility_count }}	{{ $department->comp_off_eligibility_count }}	{{ $department->marked_only_in_count }}	{{ $department->marked_only_out_count }}	{{ $department->marked_both_in_out_count }}	{{ $department->below_working_hrs_count }}	{{ $department->below_working_hrs_ot_eligible_count }}	{{ $department->above_working_hrs_count }}	{{ $department->above_working_hrs_ot_eligible_count }}	{{ $department->present_count }}	{{ $department->absent_count }}	{{ round($department->present_count + $department->absent_count ? ($department->absent_count / ($department->present_count + $department->absent_count)) * 100 : 0, 2) }} %	{{ $data['total_man_hours_available'] }}	{{ $data['net_man_hours_available'] }}	{{ $data['net_man_hours_present'] }}	{{ $data['available_vs_present_perc'] }} %
{{$location->name}}
Departments	Headcounts	OT Eligibility	Comp Off Eligibility	Marked only In Time	Marked only Out Time	Marked Both In & OUT	Below Working Hrs	Below Working Hrs (OT Eligible)	Above Working Hrs	Above Working Hrs (OT Eligible)	Present	Absent	Absenteeism	Total Man Hours Available	Net Man hours Available	Net Man Hours Present	Utilization Net Man Hours Available vs Present
{{ $department->name }}	{{ $department->employee_count }}	{{ $department->ot_eligibility_count }}	{{ $department->comp_off_eligibility_count }}	{{ $department->marked_only_in_count }}	{{ $department->marked_only_out_count }}	{{ $department->marked_both_in_out_count }}	{{ $department->below_working_hrs_count }}	{{ $department->below_working_hrs_ot_eligible_count }}	{{ $department->above_working_hrs_count }}	{{ $department->above_working_hrs_ot_eligible_count }}	{{ $department->present_count }}	{{ $department->absent_count }}	{{ round($department->present_count + $department->absent_count ? ($department->absent_count / ($department->present_count + $department->absent_count)) * 100 : 0, 2) }} %	{{ $data['total_man_hours_available'] }}	{{ $data['net_man_hours_available'] }}	{{ $data['net_man_hours_present'] }}	{{ $data['available_vs_present_perc'] }} %