@php $totalEmployees = 0; $totalNetSalary = 0; $totalPensionAmount = 0; $totalEpfAmount = 0; $totalVpfAmount = 0; $totalVpfEmployees = 0; $pensionComponent = $complianceData['pensionComponent'] ?? null; $epfComponent = $complianceData['epfComponent'] ?? null; $vpfComponent = $complianceData['vpfComponent'] ?? null; $logs = $complianceData['payrollData']->groupBy('employee.category_id'); @endphp @foreach ($logs as $categoryId => $log) @php $category = $log->first()->employee->category->name ?? '-'; $employeeIds = $log->pluck('employee_id')->unique(); $vpaEmployeeIds = $log ->where('type_id', optional($vpfComponent)->id) ->pluck('employee_id') ->unique(); $totalEmployees += $employeeIds->count(); $totalNetSalary += $log->sum('payrollSalarySlip.net_salary'); $totalPensionAmount += $pensionComponent ? $log->sum(function ($item) use ($pensionComponent) { return $item->type_id == $pensionComponent->id ? $item->calculate_salary : 0; }) : 0; $totalEpfAmount += $epfComponent ? $log->sum(function ($item) use ($epfComponent) { return $item->type_id == $epfComponent->id ? $item->calculate_salary : 0; }) : 0; $totalVpfAmount += $vpfComponent ? $log->sum(function ($item) use ($vpfComponent) { return $item->type_id == $vpfComponent->id ? $item->calculate_salary : 0; }) : 0; $totalVpfEmployees += $vpfComponent ? $vpaEmployeeIds->count() : 0; @endphp @endforeach

Cat.	NO. OF SUBSC.	SALARY/WAGES AMOUNT	PENSION AMOUNT	E.P.F AMOUNT	V.P.F AMOUNT	VPF EMPLOYEES
{{ $category }}	{{ $employeeIds->count() }}	{{ $log->sum('payrollSalarySlip.net_salary') }}	{{ $pensionComponent? $log->sum(function ($item) use ($pensionComponent) {return $item->type_id == $pensionComponent->id ? $item->calculate_salary : 0;}): 0 }}	{{ $epfComponent? $log->sum(function ($item) use ($epfComponent) {return $item->type_id == $epfComponent->id ? $item->calculate_salary : 0;}): 0 }}	{{ $vpfComponent? $log->sum(function ($item) use ($vpfComponent) {return $item->type_id == $vpfComponent->id ? $item->calculate_salary : 0;}): 0 }}	{{ $vpfComponent ? $vpaEmployeeIds->count() : 0 }}
Total :	{{ $totalEmployees }}	{{ $totalNetSalary }}	{{ $totalPensionAmount }}	{{ $totalEpfAmount }}	{{ $totalVpfAmount }}	{{ $totalVpfEmployees }}

E.P.F. EMPLOYEE SHARE:	{{ $totalEpfAmount }}
V.P.F. EMPLOYEE SHARE:	{{ $totalVpfAmount }}
E.P.F. EMPLOYER SHARE @3.67% & GREATER THAN BASIC @15000/-	0
PENSION FUND EMPLOYER SHARE @8.33%	0
ADMIN CHARGES: 10,511,141.00*0.5%	0
EDLI CHARGES: 12,107,545.00*0.5%	0
INSPEC. CHARGES: 10,511,141.00*0.00%	0
TOTAL OF A/c.No.(1+2+10+21+22)	0