@php $totalCol = 28 + count($earningDerivedComponents) + count($deductionDerivedComponents); @endphp @foreach ($earningDerivedComponents as $component) @endforeach @foreach ($deductionDerivedComponents as $component) @endforeach @php $counter = 0; @endphp @for ($i = 0; $i <= 30; $i++) @if ($counter == 10 || $counter == 20) @endif @php $counter++; @endphp @endfor @if (count($dateList) < 31) @endif @for ($i = 0; $i < $totalCol; $i++) @endfor @foreach ($employees as $index => $employee) @php $counter = 0; $dayCount = 0; $attendanceSummary = $employee->attendanceSummary ->pluck('status', 'attendance_date') ->toArray(); $attendanceDayCount = $employee->attendanceSummary ->pluck('day_count', 'attendance_date') ->toArray(); @endphp @for ($i = 0; $i < 31; $i++) @if ($counter == 10 || $counter == 20) @endif @php $counter++; if (isset($attendanceSummary[$dateList[$i]]) && isset($attendanceDayCount[$dateList[$i]])) { $dateWiseTotalPresent[$dateList[$i]] += $attendanceDayCount[$dateList[$i]]; $dayCount += $attendanceDayCount[$dateList[$i]]; } @endphp @endfor @php $slipLogs = []; $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 @php $earningDerivedTotal = 0; $totalEarningDerived = []; $totalDeductionDerived = []; @endphp @foreach ($earningDerivedComponents as $component) @php $earningDerived = isset($slipLogs[$component->id]) && $slipLogs[$component->id] ? $slipLogs[$component->id] : 0; $earningDerivedTotalArr[$component->id] = ($earningDerivedTotalArr[$component->id] ?? 0) + $earningDerived; $earningDerivedTotal += $earningDerived; @endphp @endforeach @php $deductionDerivedTotal = 0; @endphp @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 @php $counter = 0; @endphp @for ($i = 0; $i <= 30; $i++) @if ($counter == 10 || $counter == 20) @endif @php $counter++; @endphp @endfor @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 Units of work done(if piece rated)											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
										{{ isset($dateList[$i]) ? date('d', strtotime($dateList[$i])) : '-' }}
{{ $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($dateList[$i]) && isset($attendanceSummary[$dateList[$i]]) ? $attendanceSummary[$dateList[$i]] : '-' }}	{{ $dayCount }}	@if (isset($basicDAVDA)) {{ isset($slipLogs[$basicDAVDA->id]) && $slipLogs[$basicDAVDA->id] ? $slipLogs[$basicDAVDA->id] : 0 }} @else 0 @endif	{{ $earningDerived }}	{{ round($earningDerivedTotal, 2) }}	{{ $deductionDerived }}	{{ round($deductionDerivedTotal, 2) }}	{{ $totalNetSalary }}
Total
										{{ isset($dateList[$i]) ? $dateWiseTotalPresent[$dateList[$i]] : '-' }}	{{ $totalPayDays }}		{{ isset($totalEarningDerivedArr[$component->id]) ? $totalEarningDerivedArr[$component->id] : 0 }}	{{ round($totalEarningDerivedTotal, 2) }}	{{ isset($totalDeductionDerivedArr[$component->id]) ? $totalDeductionDerivedArr[$component->id] : 0 }}	{{ round($totalDeductionDerivedTotal, 2) }}	{{ $totalNetSalary }}