| Cat. | NO. OF SUBSC. | SALARY/WAGES AMOUNT | PENSION AMOUNT | E.P.F AMOUNT | V.P.F AMOUNT | VPF EMPLOYEES | @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|
|---|---|---|---|---|---|---|---|
| {{ $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%
&
GRATER THAN BASIC @15000/- |
|
| 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 |