@extends('layouts.app') @section('content') @include('branches.manager._shared_styles')

{{ $district->name }} Analytics

Branch: {{ $branch->name }}

TOTAL

{{ number_format($enquiries->total()) }}

PENDING

{{ number_format($statusCounts['pending'] ?? 0) }}

ASSIGNED

{{ number_format($statusCounts['assigned'] ?? 0) }}

APPROVED

{{ number_format($statusCounts['approved'] ?? 0) }}

REJECTED

{{ number_format($statusCounts['rejected'] ?? 0) }}

@if($loanApplications && count($loanApplications) > 0)
Loan Applications
Export
@foreach($loanApplications as $i => $loan) @endforeach
SN NAME CHECK TYPE CATEGORY DURATION RATE REQUESTED LOAN AMT DISBURSEMENT MONTHLY TOTAL W/INT INTEREST PROC FEE INSURANCE STATUS
{{ $i+1 }} {{ $loan->enquiry->full_name ?? 'N/A' }} {{ $loan->enquiry->check_number ?? 'N/A' }} {{ $loan->loan_type ?? '-' }} {{ $loan->loan_category ?? '-' }} {{ $loan->loan_duration ?? 0 }}m {{ $loan->interest_rate ?? 0 }}% {{ number_format($loan->requested_amount,2) }} {{ number_format($loan->loan_amount??0,2) }} {{ number_format($loan->disbursement_amount??0,2) }} {{ number_format($loan->monthly_deduction??0,2) }} {{ number_format($loan->total_loan_with_interest??0,2) }} {{ number_format($loan->total_interest??0,2) }} {{ number_format($loan->processing_fee??0,2) }} {{ number_format($loan->insurance??0,2) }} @if($loan->status=='approved')Approved @elseif($loan->status=='rejected')Rejected @else{{ ucfirst($loan->status) }}@endif
TOTALS: {{ number_format($loanApplications->sum('requested_amount'),2) }} {{ number_format($loanApplications->sum('loan_amount'),2) }} {{ number_format($loanApplications->sum('disbursement_amount'),2) }} {{ number_format($loanApplications->sum('monthly_deduction'),2) }} {{ number_format($loanApplications->sum('total_loan_with_interest'),2) }} {{ number_format($loanApplications->sum('total_interest'),2) }} {{ number_format($loanApplications->sum('processing_fee'),2) }} {{ number_format($loanApplications->sum('insurance'),2) }}
@endif @if(isset($districtTypeAnalytics) && count($districtTypeAnalytics) > 0)
District Type Analytics
Export
@foreach($districtTypeAnalytics as $type => $data) @endforeach
TYPE COUNT INITIATED AMT PAID AMT TOTAL (PAID)
{{ ucwords(str_replace('_',' ',$type)) }} {{ $data['count'] }} {{ number_format($data['initiated'],2) }} {{ number_format($data['paid'],2) }} {{ number_format($data['paid'],2) }}
TOTALS: {{ array_sum(array_column($districtTypeAnalytics,'count')) }} {{ number_format(array_sum(array_column($districtTypeAnalytics,'initiated')),2) }} {{ number_format(array_sum(array_column($districtTypeAnalytics,'paid')),2) }} {{ number_format(array_sum(array_column($districtTypeAnalytics,'initiated'))+array_sum(array_column($districtTypeAnalytics,'paid')),2) }}
@endif @if(isset($commandAnalytics) && count($commandAnalytics) > 0)
Command Analytics
Export
@foreach($commandAnalytics as $cmd => $data) @php $first=true; @endphp @foreach($data['by_type'] as $type => $td) @if($first) @php $first=false; @endphp @endif @endforeach @endforeach
COMMAND TOTAL TYPE COUNT INITIATED AMT PAID AMT
{{ $cmd }} {{ $data['total'] }}{{ ucwords(str_replace('_',' ',$type)) }} {{ is_array($td) ? $td['count'] : $td }} {{ is_array($td) ? number_format($td['initiated'],2) : '0.00' }} {{ is_array($td) ? number_format($td['paid'],2) : '0.00' }}
@endif {{-- Withdrawals (90+ Days) - Combined Table with Details and Total --}} @if(isset($withdrawalEligible) && count($withdrawalEligible) > 0)
Withdrawals (90+ Days) - {{ $withdrawalEligible->total() }} Records
Export
@php $totalAmount = 0; @endphp @foreach($withdrawalEligible as $i => $m) @php $totalAmount += $m->amount; @endphp @endforeach
SNNAMECHECKFORCE NOPHONETYPEAMOUNTREASONWITHDRAWAL DATEDAYS
{{ ($withdrawalEligible->currentPage()-1)*$withdrawalEligible->perPage()+$i+1 }} {{ $m->name }} {{ $m->check_number }} {{ $m->enquiry->force_no ?? 'N/A' }} {{ $m->enquiry->phone ?? 'N/A' }} {{ $m->type ? ucwords(str_replace('_', ' ', $m->type)) : 'N/A' }} {{ number_format($m->amount, 2) }} {{ $m->reason ?? 'N/A' }} {{ $m->last_withdrawal_date ? \Carbon\Carbon::parse($m->last_withdrawal_date)->format('d M Y') : 'Never' }} {{ $m->days_elapsed }} days
TOTAL: {{ number_format($totalAmount, 2) }}
@if($withdrawalEligible->hasPages()) @endif
@endif @if(isset($overdueEnquiries) && count($overdueEnquiries) > 0)
Overdue Enquiries (>3 Days)
Export
@foreach($overdueEnquiries as $i => $e) @endforeach
SNNAMECHECKTYPESTATUSDATEDAYSACTION
{{ $i+1 }} {{ $e->full_name ?? 'N/A' }} {{ $e->check_number ?? 'N/A' }} {{ ucwords(str_replace('_',' ',$e->type)) }} {{ ucfirst($e->status) }} {{ \Carbon\Carbon::parse($e->created_at)->format('d M Y') }} {{ now()->diffInDays($e->created_at) }} days View
@endif
All Enquiries
Export
@forelse($enquiries as $i => $e) @empty @endforelse
SNNAMECHECKTYPEAMOUNTINITIATEDPAIDSTATUSDATEACTION
{{ ($enquiries->currentPage()-1)*$enquiries->perPage()+$i+1 }} {{ $e->full_name ?? 'N/A' }} {{ $e->check_number ?? 'N/A' }} {{ ucwords(str_replace('_',' ',$e->type)) }} @php $amt = match($e->type) { 'loan_application' => $e->loanApplication->requested_amount ?? 0, 'refund' => $e->refund->refund_amount ?? 0, 'withdraw_savings','withdraw_deposit' => $e->withdrawal->amount ?? 0, default => $e->payment->amount ?? 0 }; $initiatedAmt = $e->payments()->where('status', 'initiated')->sum('amount'); $paidAmt = $e->payments()->where('status', 'paid')->sum('amount'); @endphp {{ number_format($amt,2) }} {{ number_format($initiatedAmt,2) }} {{ number_format($paidAmt,2) }} @if($e->status=='approved')Approved @elseif($e->status=='rejected')Rejected @elseif($e->status=='pending')Pending @else{{ ucfirst($e->status) }}@endif {{ \Carbon\Carbon::parse($e->created_at)->format('d M Y') }} View
No data
@if($enquiries->hasPages()) @endif
@endsection