@extends('layouts.app') @section('content')

{{ $branch->name }} Branch Manager

@php $col_class = 'col-xl col-lg-4 col-md-6'; @endphp

Total Enquiries

All Applications

Pending Review

{{ $analytics['total'] > 0 ? round(($analytics['pending'] / $analytics['total']) * 100, 1) : 0 }}% of total

Action Needed

Assigned

{{ $analytics['total'] > 0 ? round(($analytics['assigned'] / $analytics['total']) * 100, 1) : 0 }}% assigned

{{ $analytics['total'] > 0 ? round(($analytics['assigned'] / $analytics['total']) * 100, 1) : 0 }}% Progress

IN PROGRESS

Approved

{{ $analytics['total'] > 0 ? round(($analytics['approved'] / $analytics['total']) * 100, 1) : 0 }}% success rate

Completion Rate

COMPLETED

Rejected

{{ $analytics['total'] > 0 ? round(($analytics['rejected'] / $analytics['total']) * 100, 1) : 0 }}% rejected

Rejection Rate

Overdue

Needs urgent attention

{{ $analytics['total'] > 0 ? round(($analytics['pending_overdue'] / $analytics['total']) * 100, 1) : 0 }}% Overdue

@if(request()->hasAny(['region_id', 'district_id', 'type', 'status', 'date_from', 'date_to', 'search']))

Filtered Results

Total Filtered

Pending

Assigned

Approved

@endif

Quick Actions @if(request()->hasAny(['region_id', 'district_id', 'type', 'status', 'date_from', 'date_to', 'search'])) Filters Active @endif

@if(request()->hasAny(['region_id', 'district_id', 'type', 'status', 'date_from', 'date_to', 'search'])) Reset @endif

@if($analyticsByRegion->count() > 0)

Regions

{{-- -

View detailed statistics for {{ $analyticsByRegion->count() }} regions

--}}

@endif @if($analyticsByDistrict->count() > 0)

Districts

{{--

View detailed statistics for {{ $analyticsByDistrict->count() }} districts

--}}

@endif

Categories

{{--

View detailed type for all Enquiries

--}}

@forelse($enquiries as $enquiry) @empty @endforelse

SN	Date	CheckNo	Member	Type	Region	Registered By	Status	Actions
{{ $loop->iteration + (($enquiries->currentPage() - 1) * $enquiries->perPage()) }}	{{ $enquiry->created_at->format('d/m/Y') }} {{ $enquiry->created_at->format('H:i') }} HRS	{{ $enquiry->check_number }}	{{ ucwords($enquiry->full_name) }} {{ $enquiry->phone }}	{{ ucfirst(str_replace('_', ' ', $enquiry->type)) }}	{{ $enquiry->region->name ?? 'N/A' }} {{ $enquiry->district->name ?? 'N/A' }}	@if($enquiry->registeredBy) {{ $enquiry->registeredBy->name }} @else N/A @endif	@php $statusConfig = [ 'pending' => ['class' => 'bg-warning', 'icon' => 'fa-clock', 'text' => 'text-dark'], 'assigned' => ['class' => 'bg-info', 'icon' => 'fa-user-check', 'text' => 'text-white'], 'approved' => ['class' => 'bg-success', 'icon' => 'fa-check-circle', 'text' => 'text-white'], 'rejected' => ['class' => 'bg-danger', 'icon' => 'fa-times-circle', 'text' => 'text-white'], ]; $config = $statusConfig[$enquiry->status] ?? ['class' => 'bg-secondary', 'icon' => 'fa-question', 'text' => 'text-white']; @endphp {{ strtoupper($enquiry->status) }}	View
No Enquiries Found Try adjusting your filters or search criteria

@if($enquiries->hasPages())

Showing {{ $enquiries->firstItem() }} to {{ $enquiries->lastItem() }} of {{ number_format($enquiries->total()) }} results

{{ $enquiries->appends(request()->query())->links('pagination::bootstrap-4') }}

@endif

Region

District

Enquiry Type

Status

From Date

To Date

Search Keywords

{{-- Hapa ndio tumebadilisha: table-hover, table-striped, na table-bordered --}} {{-- Kichwa cha jedwali kimetumika rangi nyeusi kwa utofauti zaidi --}} @foreach($analyticsByRegion as $regionId => $statuses) @php // LOGIC YAKO YA ASILI IMEBAKI HAPA $region = $regionsInBranch->firstWhere('id', $regionId); $total = $statuses->sum('count'); $pending = $statuses->where('status', 'pending')->sum('count'); $assigned = $statuses->where('status', 'assigned')->sum('count'); $approved = $statuses->where('status', 'approved')->sum('count'); $rejected = $statuses->where('status', 'rejected')->sum('count'); @endphp @if($region) {{-- Tumia rounded-pill kwa muonekano wa kisasa --}} @endif @endforeach {{-- Ongeza row ikiwa hakuna data --}} @if(count($analyticsByRegion) == 0) @endif

SN	REGION	TOTAL	PENDING	ASSIGNED	APPROVED	REJECTED	ACTIONS
{{ $loop->iteration }}	{{ $region->name }}	{{ $total }}	{{ $pending }}	{{ $assigned }}	{{ $approved }}	{{ $rejected }}	Tazama
Hakuna data ya uchambuzi wa mikoa iliyopatikana.

{{-- Modal Header: Use a custom utility class for the gradient and improve the title --}}

{{-- Added table-striped, table-bordered, and align-middle for clarity and structure --}} {{-- Using table-dark for high contrast header --}} @foreach($analyticsByDistrict as $districtId => $statuses) @php // Your existing data logic remains here $district = $districtsInBranch->firstWhere('id', $districtId); $total = $statuses->sum('count'); $pending = $statuses->where('status', 'pending')->sum('count'); $assigned = $statuses->where('status', 'assigned')->sum('count'); $approved = $statuses->where('status', 'approved')->sum('count'); $rejected = $statuses->where('status', 'rejected')->sum('count'); @endphp @if($district) {{-- Updated badges to rounded-pill for modern look --}} @endif @endforeach {{-- Fallback message for empty data --}} @if(count($analyticsByDistrict) == 0) @endif

#	NAME	TOTAL	PENDING	ASSIGNED	APPROVED	REJECTED	DETAILS
{{ $loop->iteration }}	{{ $district->name }}	{{ $total }}	{{ $pending }}	{{ $assigned }}	{{ $approved }}	{{ $rejected }}	{{-- Simplified action button for cleaner cell presentation --}} View
No district analytics data available.

{{-- Modal Header: Use a custom utility class for the gradient --}}

{{-- Table with table-hover, table-striped, table-bordered, and align-middle --}} {{-- Loan Applications --}} {{-- Payments --}} {{-- Refunds --}} {{-- Withdrawals --}} {{-- Shares --}} {{-- Membership Changes --}} {{-- Retirements (No Amount) --}} {{-- Condolences (No Amount) --}} {{-- Injuries (No Amount) --}} {{-- Sick Leaves (No Amount) --}} {{-- Benefits (No Amount) --}} {{-- Deductions (No Amount) --}} {{-- URA Mobile (No Amount) --}} {{-- Residential Disasters (No Amount) --}}

ENQUIRY	RECORDS	REQUESTED AMOUNT (GRAND)
LOAN APPLICATIONS	{{ number_format($childTableStats['loan_applications']['total'] ?? 0) }}	TZS {{ number_format($childTableStats['loan_applications']['total_amount'] ?? 0) }}
PAYMENTS	{{ number_format($childTableStats['payments']['total'] ?? 0) }}	TZS {{ number_format($childTableStats['payments']['total_amount'] ?? 0) }}
REFUNDS	{{ number_format($childTableStats['refunds']['total'] ?? 0) }}	TZS {{ number_format($childTableStats['refunds']['total_amount'] ?? 0) }}
WITHDRAWALS	{{ number_format($childTableStats['withdrawals']['total'] ?? 0) }}	TZS {{ number_format($childTableStats['withdrawals']['total_amount'] ?? 0) }}
SHARES	{{ number_format($childTableStats['shares']['total'] ?? 0) }}	TZS {{ number_format($childTableStats['shares']['total_amount'] ?? 0) }}
MEMBERSHIP CHANGES	{{ number_format($childTableStats['membership_changes']['total'] ?? 0) }}	Joins: {{ $childTableStats['membership_changes']['joins'] ?? 0 }} Unjoins: {{ $childTableStats['membership_changes']['unjoins'] ?? 0 }}
RETIREMENTS	{{ number_format($childTableStats['retirements']['total'] ?? 0) }}	N/A
CONDOLENCES	{{ number_format($childTableStats['condolences']['total'] ?? 0) }}	N/A
INJURIES	{{ number_format($childTableStats['injuries']['total'] ?? 0) }}	N/A
SICK LEAVES	{{ number_format($childTableStats['sick_leaves']['total'] ?? 0) }}	N/A
BENEFITS	{{ number_format($childTableStats['benefits']['total'] ?? 0) }}	N/A
DEDUCTIONS	{{ number_format($childTableStats['deductions']['total'] ?? 0) }}	N/A
URA MOBILE	{{ number_format($childTableStats['ura_mobile']['total'] ?? 0) }}	N/A
RESIDENTIAL DISASTERS	{{ number_format($childTableStats['residential_disasters']['total'] ?? 0) }}	N/A

@endsection

{{ number_format($analytics['total']) }}

{{ number_format($analytics['pending']) }}

{{ number_format($analytics['assigned']) }}

{{ number_format($analytics['approved']) }}

{{ number_format($analytics['rejected']) }}

{{ number_format($analytics['pending_overdue']) }}

Filtered Results

{{ number_format($filteredAnalytics['total']) }}

{{ number_format($filteredAnalytics['pending']) }}

{{ number_format($filteredAnalytics['assigned']) }}

{{ number_format($filteredAnalytics['approved']) }}

Regions

Districts

Categories

No Enquiries Found

Generating Export...

{{ number_format($analytics['total']) }}

{{ number_format($analytics['pending']) }}

{{ number_format($analytics['assigned']) }}

{{ number_format($analytics['approved']) }}

{{ number_format($analytics['rejected']) }}

{{ number_format($analytics['pending_overdue']) }}

Filtered Results

{{ number_format($filteredAnalytics['total']) }}

{{ number_format($filteredAnalytics['pending']) }}

{{ number_format($filteredAnalytics['assigned']) }}

{{ number_format($filteredAnalytics['approved']) }}

Regions

Districts

Categories

No Enquiries Found

Advanced Filters

Export Data

Generating Export...