@if (!empty($contractorName)) @endif @if (!empty($locationName)) @endif @if (!empty($employeeType)) @endif @if (!empty($status)) @endif @if (!empty($departmentName)) @endif @if(!$showColumns) @endif @if($showColumns) @endif @foreach ($dateList as $date) @endforeach @if(!$showColumns) @endif @foreach ($leaveTypes as $leaveType) @endforeach @if($showColumns) @endif @foreach ($totalEmployees as $key => $employee) @php $payrollProcess = new \App\Lib\Services\PayrollProcess(); $attendanceData = $payrollProcess->getPayrollAttendanceData($organization, $employee, $month, $year); $atSummary = $employee->getAttendanceSummaryList($month, $year); $leavesData = $payrollProcess->getMonthlyLeaves($employee, $month, $year); $present = @$attendanceData['present']; $absent = @$attendanceData['absent']; $weekOff = @$attendanceData['weekOffs']; $totalHd = @$attendanceData['halfDays']; $totalCo = @$attendanceData['compensations']; $totalPh = @$attendanceData['holidays']; $totalSco = @$attendanceData['scoDays']; $payDay = @$attendanceData['totalPaidDays']; $totalMonthlyHrs = @$attendanceData['payableHours']; $totalMonthlyOvertime = @$attendanceData['totalOvertime']; $pow = @$attendanceData['pow']; $poh = @$attendanceData['poh']; $totalPaidDay = ($payDay + $totalCo + $totalSco) - ($totalPh + $totalHd); // Accumulate totals $totalHdDays += $totalHd; $totalCoDays += $totalCo; $totalPhDays += $totalPh; $totalScoDays += $totalSco; $totalAbsentDays += $absent; $totalPresentWorkDays += $present; $totalPaidDays += $totalPaidDay; $totalWeekoff += $weekOff; @endphp @if(!$showColumns) @endif @if($showColumns) @endif @foreach ($dateList as $index => $date) @php $attendance = $atSummary[$date] ?? null; $st = $attendance->status ?? '--'; if ($st === 'P') { $totalPresentDays[$index]++; } @endphp @endforeach @if(!$showColumns) @endif @foreach ($leaveTypes as $leaveType) @php $leaveDetail = $employee->leaves->flatMap->leaveDetail->firstWhere('leave_type_id', $leaveType->id) ?? null; if ($leaveDetail) { $totalLeaveCounts[$leaveType->id] = ($totalLeaveCounts[$leaveType->id] ?? 0) + $leaveDetail->total_leave_count; } @endphp @endforeach @if($showColumns) @endif @endforeach @foreach ($totalPresentDays as $presentCount) @endforeach @if(!$showColumns) @endif @foreach ($leaveTypes as $leaveType) @endforeach

FORM XVI
1[See rule 78 (1) (a) (i)]
{{ $organization->name }} Muster Roll Report - {{ $month_name }} {{ $year }}
Contractor: {{ $contractorName }}
Location: {{ $locationName }}
Employee Type: {{ $employeeType }}
Month Day's Status: {{ $status }}
Department: {{ $departmentName }}
Sr No.	Employee Code	Employee Name	Gender	DOB	DOJ	Department	Activity	Workstation	Company	Date Of Exit	Status	Designation	{{ date('d (D)', strtotime($date)) }}	Total Work Days	Present Days	Week Off	Absent Days	Half Day	CF	SCO Days	PH	{{ $leaveType->name }}	Holiday	Paid Days	Total Monthly Hrs	Total Monthly OT Hrs	POW	POH	Location	Reporting Officer
@if (isset($_GET['page']) && $_GET['page'] > 0) {{ ($_GET['page'] - 1) * 50 + $loop->iteration }} @else {{ $loop->iteration }} @endif	{{ $employee->employee_code }}	{{ $employee->name }}	{{ $employee->gender ? ucfirst($employee->gender) : '-' }}	{{ $employee->dob ? date('d-F-Y', strtotime($employee->dob)) : '-' }}	{{ $employee->date_of_joining ? date('d-F-Y', strtotime($employee->date_of_joining)) : '-' }}	{{ $employee->department->name ?? '-' }}	{{ $employee->activity ?? '-' }}	{{ $employee->workstation->name ?? '-' }}	{{ $employee->contractor? $employee->contractor->name : $group}}	{{ $employee->date_of_leaving ?? '-' }}	{{ $employee->status ?? '-' }}	{{ $employee->designation->name ?? '-' }}	{{ $st }}	{{ $totalPaidDay }}	{{ $present }}	{{ $weekOff }}	{{ $absent }}	{{ $totalHd }}	{{ $totalCo }}	{{ $totalSco }}	{{ $totalPh }}	{{ $leaveDetail->total_leave_count ?? 0 }}	{{ $totalPh }}	{{ $payDay }}	{{ $totalMonthlyHrs }}	{{ $totalMonthlyOvertime }}	{{ $pow }}	{{ $poh }}	{{ $employee->organization->name ?? '-' }}	{{ @$employee->hod->name}}
	Total Present Days	{{ $presentCount }}	{{ $totalWeekoff }}	{{ $totalAbsentDays }}	{{ $totalHdDays }}	{{ $totalCoDays }}	{{ $totalPhDays }}	{{ $totalLeaveCounts[$leaveType->id] ?? 0 }}	{{ $totalPresentWorkDays }}	{{ $totalScoDays }}	{{ $totalPaidDays }}	{{ $employee->organization->name ?? '-' }}	{{ @$employee->hod->name}}