ESS LOAN APPLICATIONS REPORT

Employee Self Service Loan Requests
Generated on: {{ date('F d, Y h:i A') }}

Summary Statistics

{{ $loanOffers->count() }}
{{ $loanOffers->whereIn('approval', ['PENDING', null])->count() }}
{{ $loanOffers->where('approval', 'APPROVED')->count() }}
{{ $loanOffers->where('approval', 'REJECTED')->count() }}
{{ $loanOffers->where('approval', 'CANCELLED')->count() }}
TZS {{ number_format($loanOffers->sum('requested_amount'), 2) }}
@forelse($loanOffers as $index => $offer) @empty @endforelse
# Application # Check # Name Employment Requested Take Home Tenure Rate Approval Status Date
{{ $index + 1 }} {{ $offer->application_number }} {{ $offer->check_number }} {{ $offer->first_name }} {{ $offer->last_name }} {{ $offer->employment_date ? \Carbon\Carbon::parse($offer->employment_date)->format('Y-m-d') : '-' }} TZS {{ number_format($offer->requested_amount, 2) }} TZS {{ number_format($offer->take_home_amount ?? $offer->net_loan_amount ?? 0, 2) }} {{ $offer->tenure ?? '-' }} {{ $offer->interest_rate ? $offer->interest_rate . '%' : '-' }} @php $approval = $offer->approval ?: 'PENDING'; $approvalClass = 'status-' . strtolower($approval); @endphp {{ $approval }} @php $status = $offer->status ?: 'NEW'; $statusClass = 'status-' . str_replace('_', '-', strtolower($status)); @endphp {{ str_replace('_', ' ', ucfirst($status)) }} {{ $offer->created_at ? $offer->created_at->format('Y-m-d') : '-' }}
No loan applications found
TOTALS: TZS {{ number_format($loanOffers->sum('requested_amount'), 2) }} TZS {{ number_format($loanOffers->sum('take_home_amount') ?: $loanOffers->sum('net_loan_amount'), 2) }}

This is a system-generated report from URAERP - ESS Loan Management System

© {{ date('Y') }} URASACCOS. All rights reserved.

Page 1 of 1