Morio Sacco

Loan Report

Generated on {{ date('l, F j, Y \a\t g:i A') }}

@if(request()->hasAny(['status', 'user_id']))

Applied Filters:

@if(request('status'))

Status: {{ ucfirst(request('status')) }}

@endif @if(request('user_id')) @php $user = \App\Models\User::find(request('user_id')) @endphp

Member: {{ $user ? $user->full_name : 'N/A' }}

@endif
@endif @if($loans->count() > 0) @foreach($loans as $loan) @endforeach
# Member Amount Interest Term Total Amount Monthly Payment Status Approved Application Date
{{ $loop->iteration }} {{ $loan->user->full_name ?? 'N/A' }} KSh {{ number_format($loan->amount, 2) }} {{ $loan->interest_rate }}% {{ $loan->term_months }}m KSh {{ number_format($loan->total_amount, 2) }} KSh {{ number_format($loan->monthly_payment, 2) }} {{ ucfirst($loan->status) }} {{ $loan->approved_at ? $loan->approved_at->format('d M Y') : '-' }} {{ $loan->created_at->format('d M Y') }}

Loan Portfolio Summary

{{ $loans->count() }}
Total Loans
{{ $loans->where('status', 'approved')->count() }}
Approved
KSh {{ number_format($loans->sum('amount'), 2) }}
Total Principal
KSh {{ number_format($loans->sum('total_amount'), 2) }}
Total Amount
KSh {{ number_format($loans->avg('amount'), 2) }}
Average Loan
@else

No Loans Found

No loans match the specified criteria.

@endif