Payroll Summary Report

@php $totalBase = 0; $totalAdditions = 0; $totalDeductions = 0; $totalPayable = 0; foreach($payrolls as $payroll) { $totalBase += $payroll->base_salary; $totalAdditions += $payroll->total_addition; $totalDeductions += $payroll->total_deduction; $totalPayable += $payroll->total_payable; } @endphp

{{ $payrolls->count() }}

Employees

{{ number_format($totalBase, 0) }}

Base Salaries

{{ number_format($totalAdditions, 0) }}

Additions

{{ number_format($totalPayable, 0) }}

Net Payout

Report Date: {{ now()->format('Y-m-d H:i') }} @if(isset($filters['user_id'])) Employee: #{{ $filters['user_id'] }} @endif @if(isset($filters['month'])) Month: {{ date('F', mktime(0, 0, 0, $filters['month'], 1)) }} @endif @if(isset($filters['year'])) Year: {{ $filters['year'] }} @endif

@if($payrolls->count() > 0) @foreach($payrolls as $payroll) @endforeach

ID	Employee	Period	Base Salary	Additions	Deductions	Net Pay	Generated
#{{ $loop->iteration }}	{{ substr($payroll->user?->name ?? 'NA', 0, 2) }} {{ $payroll->user?->name ?? 'N/A' }} {{ $payroll->user?->email ?? '' }}	{{ date('M Y', mktime(0, 0, 0, $payroll->month, 1, $payroll->year)) }}	{{ number_format($payroll->base_salary, 2) }}	+{{ number_format($payroll->total_addition, 2) }}	-{{ number_format($payroll->total_deduction, 2) }}	{{ number_format($payroll->total_payable, 2) }}	{{ $payroll->created_at?->format('M d') ?? '-' }}
TOTALS			{{ number_format($totalBase, 2) }}	+{{ number_format($totalAdditions, 2) }}	-{{ number_format($totalDeductions, 2) }}	{{ number_format($totalPayable, 2) }}

@else

📊

No payroll records found matching your criteria.

@endif