@php $totalCol = 17 + count($earningDerivedComponents) + count($deductionDerivedComponents) + count($dateList) ; @endphp @foreach ($earningDerivedComponents as $component) @endforeach @foreach ($deductionDerivedComponents as $component) @endforeach @foreach ($dateList as $date) @endforeach @for ($i = 0; $i < $totalCol; $i++) @endfor @foreach ($employees as $index => $employee) @php $dayCount = 0; $slipLogs = []; $earningDerivedTotal = 0; $deductionDerivedTotal = 0; $totalEarningDerived = []; $totalDeductionDerived = []; $attendanceSummary = $employee->attendanceSummary ->pluck('status', 'attendance_date') ->toArray(); $attendanceDayCount = $employee->attendanceSummary ->pluck('day_count', 'attendance_date') ->toArray(); $ctc = isset($employee->salarySlip->ctc_for_month) && $employee->salarySlip->ctc_for_month ? $employee->salarySlip->ctc_for_month : 0; $totalPayDays += $dayCount; if ( isset($employee->salarySlip->slipLogs) && !empty($employee->salarySlip->slipLogs) ) { $slipLogs = $employee->salarySlip->slipLogs->pluck( 'calculate_salary', 'type_id', ); } @endphp @foreach ($dateList as $index => $date) @php if ( isset($attendanceSummary[$date]) && isset($attendanceDayCount[$date]) ) { $dateWiseTotalPresent[$date] += $attendanceDayCount[$date]; $dayCount += $attendanceDayCount[$date]; } @endphp @endforeach @foreach ($earningDerivedComponents as $component) @php $earningDerived = isset($slipLogs[$component->id]) && $slipLogs[$component->id] ? round($slipLogs[$component->id], 2) : 0; $earningDerivedTotalArr[$component->id] = (isset($earningDerivedTotalArr[$component->id]) ? round($earningDerivedTotalArr[$component->id]) : 0) + $earningDerived; $earningDerivedTotal += $earningDerived; @endphp @endforeach @foreach ($deductionDerivedComponents as $component) @php $deductionDerived = isset($slipLogs[$component->id]) && $slipLogs[$component->id] ? $slipLogs[$component->id] : 0; $deductionDerivedTotalArr[$component->id] = ($deductionDerivedTotalArr[$component->id] ?? 0) + $deductionDerived; $deductionDerivedTotal += $deductionDerived; @endphp @endforeach @php $totalEarningDerivedTotal += $earningDerivedTotal; $totalDeductionDerivedTotal += $deductionDerivedTotal; $netSalary = $employee->salarySlip->net_salary ?? 0; $totalNetSalary += $netSalary; @endphp @endforeach @foreach ($dateList as $index => $date) @endforeach @foreach ($earningDerivedComponents as $component) @endforeach @foreach ($deductionDerivedComponents as $component) @endforeach

FROM X
[See Rule 15(3)]
COMBINED MUSTER ROLL-CUM-REGISTER OF WAGES
Name/Address of the Factory/Est.:-	{{ isset($organization->name) && $organization->name ? $organization->name : '' }} - {{ isset($organization->address->line_1) && $organization->address->line_1 ? $organization->address->line_1 : '' }}	Name/Address of Principal Employer:-	{{ isset($organization->address->line_1) && $organization->address->line_1 ? $organization->address->line_1 : '' }}
Name/Address of the Contractor:-	{{ @$contractor->name }} - {{ @$contractor->userDetail->company_address }}	Place of Work:-	{{ isset($organization->address->city->name) && $organization->address->city->name ? $organization->address->city->name : ' ' }}   {{ isset($organization->address->city->state->name) && $organization->address->city->state->name ? $organization->address->city->state->name : ' ' }}   {{ isset($organization->address->city->state->country->name) && $organization->address->city->state->country->name ? $organization->address->city->state->country->name : ' ' }}	Month:-	{{ $month_name }}	Year:-	{{ $year }}
Serial No	Name of Employee	Father's Name or Husband's Name in case of Married Woman	Sex M/F	Date of Birth	Employee Code	Categ./ Desig./ Deptt.	Date of Joining	ESI No.	PF No./UAN No.	ATTENDANCE	No. of payable days./ Total Units of work done.	Basic Wages Rate DA/VDA	{{ isset($component->name) && $component->name ? $component->name : ' ' }}	Total Earnings	{{ isset($component->name) && $component->name ? $component->name : ' ' }}	Total Deductions	Net Payable	Date of payment	Signature
										{{ date('d (D)', strtotime($date)) }}
{{ $i }}
{{ $index + 1 }}	{{ isset($employee->name) && $employee->name ? ucfirst($employee->name) : ' ' }}	{{ isset($employee->father_name) && $employee->father_name ? ucfirst($employee->father_name) : ' ' }}	{{ isset($employee->gender) && $employee->gender ? ucfirst($employee->gender) : ' ' }}	{{ isset($employee->dob) && $employee->dob ? ucfirst($employee->dob) : ' ' }}	{{ isset($employee->employee_code) && $employee->employee_code ? ucfirst($employee->employee_code) : ' ' }}	{{ isset($employee->designation->name) && $employee->designation->name ? ucfirst($employee->designation->name) : ' ' }} - {{ isset($employee->department->name) && $employee->department->name ? ucfirst($employee->department->name) : ' ' }} - {{ isset($employee->category->name) && $employee->category->name ? ucfirst($employee->category->name) : ' ' }}	{{ isset($employee->date_of_joining) && $employee->date_of_joining ? $employee->date_of_joining : ' ' }}	{{ isset($employee->esic_no) && $employee->esic_no ? strtoupper($employee->esic_no) : ' ' }}	{{ isset($employee->pf_no) && $employee->pf_no ? strtoupper($employee->pf_no) : ' ' }}	{{ isset($attendanceSummary[$date]) ? $attendanceSummary[$date] : '-' }}	{{ $dayCount }}	@if (isset($basicDAVDA)) {{ isset($slipLogs[$basicDAVDA->id]) && $slipLogs[$basicDAVDA->id] ? round($slipLogs[$basicDAVDA->id], 2) : 0 }} @else 0 @endif	{{ $earningDerived }}	{{ round($earningDerivedTotal, 2) }}	{{ $deductionDerived }}	{{ round($deductionDerivedTotal, 2) }}	{{ round($totalNetSalary, 2) }}
Total										{{ $dateWiseTotalPresent[$date] ?? '-' }}	{{ $totalPayDays }}		{{ isset($earningDerivedTotalArr[$component->id]) ? round($earningDerivedTotalArr[$component->id], 2) : 0 }}	{{ round($totalEarningDerivedTotal, 2) }}	{{ isset($deductionDerivedTotalArr[$component->id]) ? round($deductionDerivedTotalArr[$component->id], 2) : 0 }}	{{ round($totalDeductionDerivedTotal, 2) }}	{{ round($totalNetSalary) }}