@extends('admin_dashboard') @section('admin')
{{-- Header --}}
Collection Sheet
Loan A/C: {{ $disbursement->loan_ac_number }} {{ $disbursement->loanMember->memberInfo->member_name ?? '—' }} {{ $disbursement->loanMember->memberInfo->member_mobile ?? '—' }} Disbursed: {{ \Carbon\Carbon::parse($disbursement->disbursement_date)->format('d M Y') }} ৳ {{ number_format($disbursement->disbursed_amount, 2) }} {{ $disbursement->loanMember->loan_type ?? '—' }}
Back
{{-- Summary stats --}} @php $totalAmt = $collections->sum('installment_amount'); $paidAmt = $collections->sum('paid_amount'); $balanceAmt= $totalAmt - $paidAmt; $paidCount = $collections->where('status', 1)->count(); $dueCount = $collections->where('status', 0)->count(); @endphp
@foreach([ ['Total Terms', $collections->count(), '#1a3a5c', '#dbeafe', 'bi-list-ol'], ['Paid Terms', $paidCount, '#065f46', '#d1fae5', 'bi-check-circle-fill'], ['Pending Terms', $dueCount, '#92400e', '#fef3c7', 'bi-hourglass-split'], ['Total Collected', '৳ '.number_format($paidAmt,2), '#1a7a5e', '#f0fdf4', 'bi-cash-coin'], ['Balance Due', '৳ '.number_format($balanceAmt,2), '#991b1b', '#fee2e2', 'bi-exclamation-circle'], ] as $s)
{{ $s[0] }}
{{ $s[1] }}
@endforeach
{{-- Collection table --}}
@foreach($collections as $i => $c) @php $isOverdue = $c->status === 0 && \Carbon\Carbon::parse($c->collection_date)->isPast(); @endphp @endforeach
# Term No. Collection Date Instalment (৳) Paid (৳) Balance (৳) Paid Date Status
{{ $i + 1 }} {{ $c->installment_no }} {{ \Carbon\Carbon::parse($c->collection_date)->format('d M Y') }} @if($isOverdue) (overdue) @endif ৳ {{ number_format($c->installment_amount, 2) }} ৳ {{ number_format($c->paid_amount, 2) }} ৳ {{ number_format($c->balance, 2) }} {{ $c->paid_date ? \Carbon\Carbon::parse($c->paid_date)->format('d M Y') : '—' }} @if($c->status === 1) Paid @elseif($isOverdue) Overdue @else Pending @endif
Total ৳ {{ number_format($totalAmt, 2) }} ৳ {{ number_format($paidAmt, 2) }} ৳ {{ number_format($balanceAmt, 2) }}
@endsection