{{ __('Salary & Loan Report') }}

Generate @if($employee) Print Report PDF Report Excel Report {{ __('Print Slip') }} @endif
@if($employee)
Basic Salary
{{ number_format($basic, 2) }}
Allowances
{{ number_format($allowances, 2) }}
Deductions
{{ number_format($deductions, 2) }}
Net Salary (Before Loan)
{{ number_format($netBeforeLoan, 2) }}
Loan Deduction (This Month)
{{ number_format($loanDeduction, 2) }}
Net Salary (After Loan)
{{ number_format($netAfterLoan, 2) }}
Total Approved Loan Amount: {{ number_format($totalLoanApprovedAmount, 2) }}

Active Loans (This Month)

@foreach($activeLoanRows as $row) @php $loan = $row['loan']; @endphp @endforeach @if($activeLoanRows->isEmpty()) @endif
Amount Period Term Monthly Remaining
{{ number_format($loan->amount, 2) }} {{ $loan->start_date ? $loan->start_date->format('Y-m-d') : '' }} - {{ $loan->end_date ? $loan->end_date->format('Y-m-d') : '' }} {{ $loan->term_months }} months {{ number_format($loan->monthly_installment, 2) }} {{ number_format($row['remaining_balance_calc'], 2) }} ({{ $row['remaining_months_calc'] }} months)
No active loans for this month.

All Approved Loans

@foreach($approvedLoanRows as $row) @php $loan = $row['loan']; @endphp @endforeach @if($approvedLoanRows->isEmpty()) @endif
Amount Term Monthly Approved Period Status
{{ number_format($loan->amount, 2) }} {{ $loan->term_months }} months {{ number_format($loan->monthly_installment, 2) }} {{ $loan->approved_at ? $loan->approved_at->format('Y-m-d') : '' }} {{ $loan->start_date ? $loan->start_date->format('Y-m-d') : '' }} - {{ $loan->end_date ? $loan->end_date->format('Y-m-d') : '' }} {{ ucfirst($loan->status) }}
No approved loans.
@endif