{{ $client->client->agency->name }}

{{ $client->department_name }} Summary Payroll Report (Batch ID: {{ $batchCode->id }})

Period Cover: {{ \Carbon\Carbon::parse($batchCode->pay_period_start)->format('F j, Y') }} to {{ \Carbon\Carbon::parse($batchCode->pay_period_end)->format('F j, Y') }}

@foreach ($payrolls as $payroll)
Employee Rate Earnings Deductions Net Pay
{{ $payroll->employee->last_name }}, {{ $payroll->employee->first_name }} {{ $payroll->employee->middle_name ? $payroll->employee->middle_name[0] . '.' : '' }} {{ $payroll->rate }} @php $pay = $payroll->rate * $payroll->days_worked_withdeduction; $constantearning = App\Models\ConstantDeduction::where('status', 1) ->where('payroll_id', $payroll->id) ->sum('E_Amount'); $constantdeduction = App\Models\ConstantDeduction::whereNull('status') ->where('payroll_id', $payroll->id) ->sum('E_Amount'); $deductionsb = App\Models\Benefits::where('payroll_id', $payroll->id)->sum( 'employee_share', ); $others = App\Models\OthersForPayroll::where('payroll_id', $payroll->id)->sum('amount') ?? 0; $netpay = $pay + $constantearning + $others - $deductionsb - $constantdeduction; @endphp {{ $constantearning + $pay + $others }} {{ $constantdeduction + $deductionsb }} {{ $netpay }}
Basic Salary Constant Loan Other
{{ $payroll->days_worked_withdeduction }} Days - {{ $pay }} @foreach ($payroll->trxConstantDeductions as $deduction)

{{ $deduction->trxConstant->trxCode->description ?? 'N/A' }}: {{ $deduction->E_Amount }}

@endforeach 		@foreach ($payroll->trxLoanDeductions as $loanDeduction)

{{ $loanDeduction->trxLoan->trxCode->description ?? 'N/A' }}: {{ $loanDeduction->Amount }}

@endforeach 		@foreach ($payroll->benefits as $benefit)

{{ $benefit->type }}: {{ $benefit->employee_share }}

@endforeach @foreach ($payroll->othersForPayroll as $otherDeduction)

{{ $otherDeduction->name }}: {{ $otherDeduction->amount }}

@endforeach
@endforeach