@include('loan.payments.partials.flash')
@php $registerExportQuery = collect(request()->query())->except(['embedded', 'page'])->merge(['export' => 'csv'])->all(); @endphp Clear Export @include('loan.collections.hub.partials.register-intelligence', [ 'filters' => $filters, 'registerTotals' => $registerTotals ?? [], 'allocationTotals' => $allocationTotals ?? [], ]) @php $amountTotal = (float) ($registerTotals['period'] ?? $registerTotals['today'] ?? 0); $principalTotal = (float) ($allocationTotals['principal'] ?? 0); $interestTotal = (float) ($allocationTotals['interest'] ?? 0); $feesTotal = (float) ($allocationTotals['fees'] ?? 0); $penaltyTotal = (float) ($allocationTotals['penalty'] ?? 0); $overpaymentTotal = (float) ($allocationTotals['overpayment'] ?? 0); @endphp
@forelse ($payments as $payment) @php $client = $payment->loan?->loanClient; $officer = $payment->loan?->collectionAgent ?? $client?->assignedEmployee; $officerName = trim(($officer?->first_name ?? '').' '.($officer?->last_name ?? '')); @endphp @empty @endforelse @if ($payments->isNotEmpty()) @endif
# M-Pesa Txn Date Client Loan Branch Loan officer Channel Principal Interest Fees Penalty Overpayment Amount
{{ ($payments->firstItem() ?? 0) + $loop->index }} {{ $payment->mpesa_receipt_number ?: '—' }} {{ optional($payment->transaction_at)->format('Y-m-d H:i') }} {{ trim(($client->first_name ?? '').' '.($client->last_name ?? '')) ?: '—' }} {{ $payment->loan?->loan_number ?? '—' }} {{ $payment->loan?->loanBranch?->name ?? $payment->loan?->branch ?? '—' }} {{ $officerName !== '' ? $officerName : '—' }} {{ $payment->channel }} {{ number_format((float) ($payment->register_principal ?? 0), 2) }} {{ number_format((float) ($payment->register_interest ?? 0), 2) }} {{ number_format((float) ($payment->register_fees ?? 0), 2) }} {{ number_format((float) ($payment->register_penalty ?? 0), 2) }} {{ number_format((float) ($payment->register_overpayment ?? 0), 2) }} {{ number_format((float) $payment->amount, 2) }}
No processed payments in this range.
Total {{ number_format($principalTotal, 2) }} {{ number_format($interestTotal, 2) }} {{ number_format($feesTotal, 2) }} {{ number_format($penaltyTotal, 2) }} {{ number_format($overpaymentTotal, 2) }} {{ number_format($amountTotal, 2) }}