|
EMI Report
Loan and payment collection report
@if($fromDate && $toDate)
Date Range:
{{ \Carbon\Carbon::parse($fromDate)->format('d-m-Y') }}
-
{{ \Carbon\Carbon::parse($toDate)->format('d-m-Y') }}
@elseif($fromDate)
From:
{{ \Carbon\Carbon::parse($fromDate)->format('d-m-Y') }}
@elseif($toDate)
Up to:
{{ \Carbon\Carbon::parse($toDate)->format('d-m-Y') }}
@else
All Dates
@endif
|
Generated
{{ now()->format('d-m-Y h:i A') }}
|
|
Total Loans
{{ $totalLoans }}
|
Total Disbursed
{{ $currencySymbol }}{{ number_format($totalDisbursed, $decimalPlaces) }}
|
Total Collected
{{ $currencySymbol }}{{ number_format($totalCollected, $decimalPlaces) }}
|
Total Outstanding
{{ $currencySymbol }}{{ number_format($totalOutstanding, $decimalPlaces) }}
|
| Date | Client | Loan | Type | Method | Amount | Reference |
|---|---|---|---|---|---|---|
| {{ $payment->paid_at?->format('d-m-Y') ?? '-' }} | {{ $payment->user?->name ?? '-' }} | {{ $payment->loan?->loan_number ?? '-' }} | {{ ucfirst( str_replace( '_', ' ', $payment->payment_type ?? 'general' ) ) }} | {{ ucfirst( str_replace( '_', ' ', $payment->payment_method ?? '-' ) ) }} | {{ $currencySymbol }}{{ number_format((float) $payment->amount, $decimalPlaces) }} | {{ $payment->reference_number ?? '-' }} |
| No payments found for the selected date range. | ||||||
| Total Collection | {{ $currencySymbol }}{{ number_format((float) $totalCollected, $decimalPlaces) }} | |||||
| Loan Number | Client | Loan Amount | Disbursed Date | Outstanding | Status |
|---|---|---|---|---|---|
| {{ $loan->loan_number ?? '-' }} | {{ $loan->user?->name ?? '-' }} | {{ $currencySymbol }}{{ number_format((float) $loan->loan_amount, $decimalPlaces) }} | {{ $loan->disbursed_at?->format('d-m-Y') ?? '-' }} | {{ $currencySymbol }}{{ number_format((float) $loan->outstanding_amount, $decimalPlaces) }} | {{ ucfirst($loan->status ?? '-') }} |
| No loans found for the selected date range. | |||||
| Total | {{ $currencySymbol }}{{ number_format((float) $totalDisbursed, $decimalPlaces) }} | {{ $currencySymbol }}{{ number_format((float) $totalOutstanding, $decimalPlaces) }} | |||