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

<div class="container-fluid">
    {{-- Breadcrumb Navigation --}}
    <nav aria-label="breadcrumb" class="mb-3">
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}"><i class='bx bx-home'></i> Dashboard</a></li>
            <li class="breadcrumb-item"><a href="{{ route('branches.manager.dashboard') }}">Branch Analytics</a></li>
            <li class="breadcrumb-item active">All Regions</li>
        </ol>
    </nav>

    {{-- Page Header --}}
    <div class="page-header-modern mb-4">
        <div class="row align-items-center">
            <div class="col-lg-6 col-md-12 mb-3 mb-lg-0">
                <h2 class="mb-2 text-white"><i class='bx bx-world'></i> All Regions Analytics</h2>
                <p class="mb-0 opacity-75">
                    <i class='bx bx-building'></i> Branch: {{ $branch->name }}
                </p>
            </div>
            <div class="col-lg-6 col-md-12 text-lg-end">
                <button class="btn btn-light btn-lg mb-2 mb-sm-0" data-bs-toggle="modal" data-bs-target="#filterModal">
                    <i class='bx bx-filter'></i> Filters
                </button>
                <div class="btn-group ms-0 ms-sm-2">
                    <button type="button" class="btn btn-success dropdown-toggle" data-bs-toggle="dropdown">
                        <i class='bx bx-download'></i> Export
                    </button>
                    <ul class="dropdown-menu">
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'all'] + request()->all()) }}">All Data</a></li>
                        <li><hr class="dropdown-divider"></li>
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'loans'] + request()->all()) }}">Loans</a></li>
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'overdue'] + request()->all()) }}">Overdue</a></li>
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'commands'] + request()->all()) }}">Commands</a></li>
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'type_breakdown'] + request()->all()) }}">Type Breakdown</a></li>
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'rejections'] + request()->all()) }}">Rejections</a></li>
                        <li><a class="dropdown-item" href="{{ route('branches.manager.export.excel', ['section' => 'withdrawals'] + request()->all()) }}">Withdrawals</a></li>
                    </ul>
                </div>
            </div>
        </div>
    </div>

    {{-- Simple Metric Cards --}}
    <div class="row mb-4">
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #17479E;"><div class="card-body text-center" style="background:#e3f2fd;">
                <i class="fa fa-map-marked-alt mb-2" style="font-size:28px;color:#17479E;"></i>
                <p class="mb-1 small text-muted">REGIONS</p>
                <h3 class="mb-0 text-primary">{{ count($regionsInBranch) }}</h3>
            </div></div>
        </div>
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #333;"><div class="card-body text-center" style="background:#f5f5f5;">
                <i class="fa fa-list-alt mb-2" style="font-size:28px;color:#333;"></i>
                <p class="mb-1 small text-muted">TOTAL</p>
                <h3 class="mb-0">{{ number_format($statusCounts['pending'] + $statusCounts['assigned'] + $statusCounts['approved'] + $statusCounts['rejected']) }}</h3>
            </div></div>
        </div>
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #ff9800;"><div class="card-body text-center" style="background:#fff3e0;">
                <i class="fa fa-clock mb-2" style="font-size:28px;color:#ff9800;"></i>
                <p class="mb-1 small text-muted">PENDING</p>
                <h3 class="mb-0 text-warning">{{ number_format($statusCounts['pending'] ?? 0) }}</h3>
            </div></div>
        </div>
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #2196f3;"><div class="card-body text-center" style="background:#e1f5fe;">
                <i class="fa fa-user-check mb-2" style="font-size:28px;color:#2196f3;"></i>
                <p class="mb-1 small text-muted">ASSIGNED</p>
                <h3 class="mb-0 text-info">{{ number_format($statusCounts['assigned'] ?? 0) }}</h3>
            </div></div>
        </div>
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #4caf50;"><div class="card-body text-center" style="background:#e8f5e9;">
                <i class="fa fa-check-circle mb-2" style="font-size:28px;color:#4caf50;"></i>
                <p class="mb-1 small text-muted">APPROVED</p>
                <h3 class="mb-0 text-success">{{ number_format($statusCounts['approved'] ?? 0) }}</h3>
            </div></div>
        </div>
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #f44336;"><div class="card-body text-center" style="background:#ffebee;">
                <i class="fa fa-times-circle mb-2" style="font-size:28px;color:#f44336;"></i>
                <p class="mb-1 small text-muted">REJECTED</p>
                <h3 class="mb-0 text-danger">{{ number_format($statusCounts['rejected'] ?? 0) }}</h3>
            </div></div>
        </div>
        <div class="col-lg-2 col-md-4 col-sm-6 mb-3">
            <div class="card h-100" style="border-left:4px solid #9e9e9e;"><div class="card-body text-center" style="background:#fafafa;">
                <i class="fa fa-exclamation-triangle mb-2" style="font-size:28px;color:#9e9e9e;"></i>
                <p class="mb-1 small text-muted">OVERDUE</p>
                <h3 class="mb-0"><a href="#" data-bs-toggle="modal" data-bs-target="#overdueModal" style="text-decoration:none;color:inherit;">{{ number_format($overdueCount ?? 0) }}</a></h3>
            </div></div>
        </div>
    </div>

    {{-- Regions Summary Table --}}
    <div class="card analytics-card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <h5 class="mb-0 text-white">Regions Summary</h5>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead>
                        <tr>
                            <th>SN</th>
                            <th>REGION NAME</th>
                            <th>TOTAL ENQUIRIES</th>
                            <th>PENDING</th>
                            <th>APPROVED</th>
                            <th>REJECTED</th>
                            <th>TOTAL AMOUNT</th>
                            <th>ACTION</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($regionsInBranch as $index => $region)
                        @php
                            $analytics = $regionAnalytics[$region->id] ?? [];
                        @endphp
                        <tr>
                            <td><span class="badge-sn">{{ $index + 1 }}</span></td>
                            <td><strong>{{ $region->name }}</strong></td>
                            <td>{{ number_format($analytics['total_enquiries'] ?? 0) }}</td>
                            <td><span class="badge bg-warning">{{ $analytics['pending'] ?? 0 }}</span></td>
                            <td><span class="badge bg-success">{{ $analytics['approved'] ?? 0 }}</span></td>
                            <td><span class="badge bg-danger">{{ $analytics['rejected'] ?? 0 }}</span></td>
                            <td><strong>{{ number_format($analytics['total_amount'] ?? 0, 2) }}</strong></td>
                            <td>
                                <a href="{{ route('branches.manager.region.analytics', $region->id) }}" class="btn btn-sm btn-secondary">
                                   view
                                </a>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    {{-- All Enquiries Table --}}
    <div class="card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <div class="d-flex justify-content-between align-items-center">
                <h5 class="mb-0 text-white">All Enquiries</h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'all_enquiries']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead>
                        <tr><th>SN</th><th>NAME</th><th>CHECK</th><th>REGION</th><th>TYPE</th><th>AMOUNT</th><th>INITIATED</th><th>PAID</th><th>STATUS</th><th>DATE</th><th>ACTION</th></tr>
                    </thead>
                    <tbody>
                        @forelse($enquiries as $i => $e)
                        <tr>
                            <td><span class="badge-sn">{{ ($enquiries->currentPage()-1)*$enquiries->perPage()+$i+1 }}</span></td>
                            <td>{{ $e->full_name ?? 'N/A' }}</td>
                            <td>{{ $e->check_number ?? 'N/A' }}</td>
                            <td>{{ $e->region->name ?? 'N/A' }}</td>
                            <td>{{ ucwords(str_replace('_',' ',$e->type)) }}</td>
                            <td>
                                @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) }}
                            </td>
                            <td><strong class="text-warning">{{ number_format($initiatedAmt,2) }}</strong></td>
                            <td><strong class="text-success">{{ number_format($paidAmt,2) }}</strong></td>
                            <td>
                                @if($e->status=='approved')<span class="badge bg-success">Approved</span>
                                @elseif($e->status=='rejected')<span class="badge bg-danger">Rejected</span>
                                @elseif($e->status=='pending')<span class="badge bg-warning">Pending</span>
                                @else<span class="badge bg-secondary">{{ ucfirst($e->status) }}</span>@endif
                            </td>
                            <td>{{ \Carbon\Carbon::parse($e->created_at)->format('d M Y') }}</td>
                            <td>
                                <a href="{{ route('enquiries.show', $e->id) }}" class="btn btn-sm btn-primary" target="_blank">
                                    <i class='bx bx-show'></i> View
                                </a>
                            </td>
                        </tr>
                        @empty
                        <tr><td colspan="11" class="text-center py-4">No data</td></tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>
        @if($enquiries->hasPages())
        <div class="card-footer">
            {{ $enquiries->appends(request()->query())->links('pagination::bootstrap-5') }}
        </div>
        @endif
    </div>

    @if($loanApplications && count($loanApplications) > 0)
    <div class="card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <div class="d-flex justify-content-between align-items-center">
                <h5 class="mb-0 text-white">Loan Applications <span class="badge bg-light text-dark ms-2">Total: {{ $totalLoanApplications }}</span></h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'loans']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead>
                        <tr>
                            <th>SN</th>
                            <th>NAME</th>
                            <th>CHECK</th>
                            <th>TYPE</th>
                            <th>CATEGORY</th>
                            <th>DURATION</th>
                            <th>RATE</th>
                            <th>REQUESTED</th>
                            <th>LOAN AMT</th>
                            <th>DISBURSEMENT</th>
                            <th>MONTHLY</th>
                            <th>TOTAL W/INT</th>
                            <th>INTEREST</th>
                            <th>PROC FEE</th>
                            <th>INSURANCE</th>
                            <th>STATUS</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($loanApplications as $index => $loan)
                        <tr>
                            <td><span class="badge-sn">{{ $index+1 }}</span></td>
                            <td>{{ $loan->enquiry->full_name ?? 'N/A' }}</td>
                            <td>{{ $loan->enquiry->check_number ?? 'N/A' }}</td>
                            <td>{{ ucwords(str_replace('_',' ',$loan->loan_type ?? 'N/A')) }}</td>
                            <td>{{ ucwords(str_replace('_',' ',$loan->loan_category ?? 'N/A')) }}</td>
                            <td>{{ $loan->loan_duration ?? 'N/A' }}</td>
                            <td>{{ $loan->interest_rate ?? 'N/A' }}%</td>
                            <td>{{ number_format($loan->requested_amount,2) }}</td>
                            <td>{{ number_format($loan->loan_amount,2) }}</td>
                            <td>{{ number_format($loan->disbursement_amount,2) }}</td>
                            <td>{{ number_format($loan->monthly_deduction,2) }}</td>
                            <td>{{ number_format($loan->total_loan_with_interest,2) }}</td>
                            <td>{{ number_format($loan->total_interest,2) }}</td>
                            <td>{{ number_format($loan->processing_fee,2) }}</td>
                            <td>{{ number_format($loan->insurance,2) }}</td>
                            <td><span class="badge bg-{{ $loan->enquiry->status == 'approved' ? 'success' : ($loan->enquiry->status == 'rejected' ? 'danger' : 'warning') }}">{{ ucfirst($loan->enquiry->status) }}</span></td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot style="background:#f8f9fa;font-weight:bold;">
                        <tr>
                            <td colspan="7" class="text-end">TOTALS:</td>
                            <td>{{ number_format($loanApplications->sum('requested_amount'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('loan_amount'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('disbursement_amount'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('monthly_deduction'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('total_loan_with_interest'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('total_interest'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('processing_fee'),2) }}</td>
                            <td>{{ number_format($loanApplications->sum('insurance'),2) }}</td>
                            <td></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
        <div class="card-footer">
            {{ $loanApplications->appends(request()->query())->links('pagination::bootstrap-5') }}
        </div>
    </div>
    @endif

    {{-- All Regions Type Analytics --}}
    <div class="card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <div class="d-flex justify-content-between">
                <h5 class="mb-0 text-white">All Regions Type Analytics</h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'type_breakdown']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body">
            <table class="table table-hover">
                <thead>
                    <tr>
                        <th>TYPE</th>
                        <th>COUNT</th>
                        <th>INITIATED AMT</th>
                        <th>PAID AMT</th>
                        <th>TOTAL (PAID)</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($districtTypeAnalytics as $type => $data)
                    <tr>
                        <td>{{ ucwords(str_replace('_',' ',$type)) }}</td>
                        <td><span class="badge bg-primary">{{ $data['count'] }}</span></td>
                        <td><strong class="text-warning">{{ number_format($data['initiated'],2) }}</strong></td>
                        <td><strong class="text-success">{{ number_format($data['paid'],2) }}</strong></td>
                        <td><strong class="text-primary">{{ number_format($data['paid'],2) }}</strong></td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>

    {{-- Command Analytics --}}
    @if(count($commandAnalytics) > 0)
    <div class="card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <div class="d-flex justify-content-between">
                <h5 class="mb-0 text-white">Command Analytics with Type Breakdown</h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'commands']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead>
                        <tr>
                            <th>COMMAND</th>
                            <th>TOTAL</th>
                            <th>TYPE</th>
                            <th>COUNT</th>
                            <th>INITIATED AMT</th>
                            <th>PAID AMT</th>
                        </tr>
                    </thead>
                    <tbody>
                        @foreach($commandAnalytics as $cmd => $data)
                            @php $first=true; @endphp
                            @foreach($data['by_type'] as $type => $td)
                            <tr>
                                @if($first)
                                <td rowspan="{{ count($data['by_type']) }}"><strong>{{ $cmd }}</strong></td>
                                <td rowspan="{{ count($data['by_type']) }}"><span class="badge bg-primary">{{ $data['total'] }}</span></td>
                                @php $first=false; @endphp
                                @endif
                                <td>{{ ucwords(str_replace('_',' ',$type)) }}</td>
                                <td>{{ is_array($td) ? $td['count'] : $td }}</td>
                                <td><strong class="text-warning">{{ is_array($td) ? number_format($td['initiated'],2) : '0.00' }}</strong></td>
                                <td><strong class="text-success">{{ is_array($td) ? number_format($td['paid'],2) : '0.00' }}</strong></td>
                            </tr>
                            @endforeach
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    @endif

    {{-- Rejections --}}
    @if(count($rejectionsByType) > 0)
    <div class="card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <div class="d-flex justify-content-between">
                <h5 class="mb-0 text-white">Rejections by Type</h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'rejections']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body">
            <table class="table table-hover">
                <thead>
                    <tr><th>TYPE</th><th>COUNT</th></tr>
                </thead>
                <tbody>
                    @foreach($rejectionsByType as $type => $count)
                    <tr>
                        <td>{{ ucwords(str_replace('_',' ',$type)) }}</td>
                        <td><span class="badge bg-danger">{{ $count }}</span></td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
    </div>
    @endif

    {{-- Overdue Enquiries Table --}}
    @if(isset($overdueEnquiries) && count($overdueEnquiries) > 0)
    <div class="card mb-4">
        <div class="card-header" style="background:#6c757d;color:white;">
            <div class="d-flex justify-content-between align-items-center">
                <h5 class="mb-0 text-white">Overdue Enquiries (>3 Days)</h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'overdue']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead>
                        <tr><th>SN</th><th>NAME</th><th>CHECK</th><th>REGION</th><th>TYPE</th><th>STATUS</th><th>DATE</th><th>DAYS</th><th>ACTION</th></tr>
                    </thead>
                    <tbody>
                        @foreach($overdueEnquiries as $i => $e)
                        <tr>
                            <td><span class="badge-sn">{{ ($overdueEnquiries->currentPage()-1)*$overdueEnquiries->perPage()+$i+1 }}</span></td>
                            <td>{{ $e->full_name ?? 'N/A' }}</td>
                            <td>{{ $e->check_number ?? 'N/A' }}</td>
                            <td>{{ $e->region->name ?? 'N/A' }}</td>
                            <td><span class="badge bg-info">{{ ucwords(str_replace('_',' ',$e->type)) }}</span></td>
                            <td><span class="badge bg-warning">{{ ucfirst($e->status) }}</span></td>
                            <td>{{ \Carbon\Carbon::parse($e->created_at)->format('d M Y') }}</td>
                            <td><span class="badge bg-danger">{{ now()->diffInDays($e->created_at) }} days</span></td>
                            <td>
                                <a href="{{ route('enquiries.show', $e->id) }}" class="btn btn-sm btn-primary" target="_blank">
                                    <i class='bx bx-show'></i> View
                                </a>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
        @if($overdueEnquiries->hasPages())
        <div class="card-footer">
            {{ $overdueEnquiries->appends(request()->query())->links('pagination::bootstrap-5') }}
        </div>
        @endif
    </div>
    @endif

    {{-- Withdrawals (90+ Days) - Combined Table with Details and Total --}}
    @if(isset($withdrawalEligible) && count($withdrawalEligible) > 0)
    <div class="card mb-4">
        <div class="card-header" style="background:#17479E;color:white;">
            <div class="d-flex justify-content-between align-items-center">
                <h5 class="mb-0 text-white">Withdrawals (90+ Days) - {{ $withdrawalEligible->total() }} Records</h5>
                <a href="{{ route('branches.manager.export.excel', ['section'=>'withdrawals']+request()->all()) }}" class="btn btn-light btn-sm">Export</a>
            </div>
        </div>
        <div class="card-body p-0">
            <div class="table-responsive">
                <table class="table table-hover mb-0">
                    <thead>
                        <tr><th>SN</th><th>NAME</th><th>CHECK</th><th>FORCE NO</th><th>PHONE</th><th>REGION</th><th>TYPE</th><th>AMOUNT</th><th>REASON</th><th>WITHDRAWAL DATE</th><th>DAYS</th></tr>
                    </thead>
                    <tbody>
                        @php $totalAmount = 0; @endphp
                        @foreach($withdrawalEligible as $i => $m)
                        <tr>
                            <td><span class="badge-sn">{{ ($withdrawalEligible->currentPage()-1)*$withdrawalEligible->perPage()+$i+1 }}</span></td>
                            <td>{{ $m->name }}</td>
                            <td>{{ $m->check_number }}</td>
                            <td>{{ $m->enquiry->force_no ?? 'N/A' }}</td>
                            <td>{{ $m->enquiry->phone ?? 'N/A' }}</td>
                            <td>{{ $m->region_name }}</td>
                            <td><span class="badge bg-info">{{ $m->type ? ucwords(str_replace('_', ' ', $m->type)) : 'N/A' }}</span></td>
                            <td><strong class="text-success">{{ number_format($m->amount, 2) }}</strong></td>
                            <td>{{ $m->reason ?? 'N/A' }}</td>
                            <td>{{ $m->last_withdrawal_date ? \Carbon\Carbon::parse($m->last_withdrawal_date)->format('d M Y') : 'Never' }}</td>
                            <td><span class="badge bg-success">{{ $m->days_elapsed }} days</span></td>
                        </tr>
                        @php $totalAmount += $m->amount; @endphp
                        @endforeach
                    </tbody>
                    <tfoot style="background:#f8f9fa;font-weight:bold;">
                        <tr>
                            <td colspan="7" class="text-end">TOTAL:</td>
                            <td><strong class="text-primary">{{ number_format($totalAmount, 2) }}</strong></td>
                            <td colspan="3"></td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
        @if($withdrawalEligible->hasPages())
        <div class="card-footer">
            {{ $withdrawalEligible->appends(request()->query())->links('pagination::bootstrap-5') }}
        </div>
        @endif
    </div>
    @endif
</div>

{{-- Filter Modal --}}
<div class="modal fade" id="filterModal" tabindex="-1">
    <div class="modal-dialog modal-xl">
        <div class="modal-content">
            <div class="modal-header" style="background:#17479E;color:white;">
                <h5 class="modal-title"><i class='bx bx-filter-alt'></i> Advanced Filters</h5>
                <button type="button" class="btn-close btn-close-white" data-bs-dismiss="modal"></button>
            </div>
            <form method="GET" action="{{ route('branches.manager.all.regions') }}">
                <div class="modal-body">
                    <div class="row">
                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-world'></i> Region</label>
                            <select name="region_id" class="form-select">
                                <option value="">All Regions</option>
                                @foreach($regionsInBranch as $region)
                                <option value="{{ $region->id }}" {{ request('region_id') == $region->id ? 'selected' : '' }}>{{ $region->name }}</option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-category'></i> Enquiry Type</label>
                            <select name="type" class="form-select">
                                <option value="">All Types</option>
                                <option value="loan_application" {{ request('type') == 'loan_application' ? 'selected' : '' }}>Loan Application</option>
                                <option value="refund" {{ request('type') == 'refund' ? 'selected' : '' }}>Refund</option>
                                <option value="withdraw_savings" {{ request('type') == 'withdraw_savings' ? 'selected' : '' }}>Withdraw Savings</option>
                                <option value="withdraw_deposit" {{ request('type') == 'withdraw_deposit' ? 'selected' : '' }}>Withdraw Deposit</option>
                                <option value="membership_change" {{ request('type') == 'membership_change' ? 'selected' : '' }}>Membership Change</option>
                                <option value="share" {{ request('type') == 'share' ? 'selected' : '' }}>Share</option>
                            </select>
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-info-circle'></i> Status</label>
                            <select name="status" class="form-select">
                                <option value="">All Statuses</option>
                                <option value="pending" {{ request('status') == 'pending' ? 'selected' : '' }}>Pending</option>
                                <option value="assigned" {{ request('status') == 'assigned' ? 'selected' : '' }}>Assigned</option>
                                <option value="approved" {{ request('status') == 'approved' ? 'selected' : '' }}>Approved</option>
                                <option value="rejected" {{ request('status') == 'rejected' ? 'selected' : '' }}>Rejected</option>
                            </select>
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-command'></i> Command</label>
                            <select name="command_id" class="form-select">
                                <option value="">All Commands</option>
                                @foreach(\App\Models\Command::all() as $cmd)
                                <option value="{{ $cmd->id }}" {{ request('command_id') == $cmd->id ? 'selected' : '' }}>{{ $cmd->name }}</option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-user'></i> Registered By</label>
                            <select name="registered_by" class="form-select">
                                <option value="">All Users</option>
                                @foreach($branchUsers as $user)
                                <option value="{{ $user->id }}" {{ request('registered_by') == $user->id ? 'selected' : '' }}>{{ $user->name }}</option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-user-check'></i> Assigned To</label>
                            <select name="assigned_to" class="form-select">
                                <option value="">All Users</option>
                                @foreach($branchUsers as $user)
                                <option value="{{ $user->id }}" {{ request('assigned_to') == $user->id ? 'selected' : '' }}>{{ $user->name }}</option>
                                @endforeach
                            </select>
                        </div>

                        <div class="col-md-12 mb-3">
                            <label class="form-label"><i class='bx bx-time'></i> Quick Date Filters</label>
                            <div class="btn-group d-flex flex-wrap gap-2" role="group">
                                <button type="button" class="btn btn-outline-primary btn-sm" onclick="setQuickDate('today')">Today</button>
                                <button type="button" class="btn btn-outline-primary btn-sm" onclick="setQuickDate('week')">This Week</button>
                                <button type="button" class="btn btn-outline-primary btn-sm" onclick="setQuickDate('month')">This Month</button>
                                <button type="button" class="btn btn-outline-primary btn-sm" onclick="setQuickDate('year')">This Year</button>
                                <button type="button" class="btn btn-outline-success btn-sm" onclick="setQuickDate('q1')">Q1 (Jan-Mar)</button>
                                <button type="button" class="btn btn-outline-success btn-sm" onclick="setQuickDate('q2')">Q2 (Apr-Jun)</button>
                                <button type="button" class="btn btn-outline-success btn-sm" onclick="setQuickDate('q3')">Q3 (Jul-Sep)</button>
                                <button type="button" class="btn btn-outline-success btn-sm" onclick="setQuickDate('q4')">Q4 (Oct-Dec)</button>
                                <button type="button" class="btn btn-outline-info btn-sm" onclick="setQuickDate('h1')">H1 (Jan-Jun)</button>
                                <button type="button" class="btn btn-outline-info btn-sm" onclick="setQuickDate('h2')">H2 (Jul-Dec)</button>
                            </div>
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-calendar'></i> Date From</label>
                            <input type="date" name="date_from" id="date_from" class="form-control" value="{{ request('date_from') }}">
                        </div>

                        <div class="col-md-6 mb-3">
                            <label class="form-label"><i class='bx bx-calendar'></i> Date To</label>
                            <input type="date" name="date_to" id="date_to" class="form-control" value="{{ request('date_to') }}">
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <a href="{{ route('branches.manager.all.regions') }}" class="btn btn-secondary">
                        <i class='bx bx-reset'></i> Reset Filters
                    </a>
                    <button type="submit" class="btn btn-primary">
                        <i class='bx bx-filter'></i> Apply Filters
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>

<script>
function setQuickDate(period) {
    const today = new Date();
    const year = today.getFullYear();
    let dateFrom = '';
    let dateTo = '';

    switch(period) {
        case 'today':
            dateFrom = today.toISOString().split('T')[0];
            dateTo = today.toISOString().split('T')[0];
            break;
        case 'week':
            const weekStart = new Date(today);
            weekStart.setDate(today.getDate() - today.getDay());
            dateFrom = weekStart.toISOString().split('T')[0];
            dateTo = today.toISOString().split('T')[0];
            break;
        case 'month':
            const monthStart = new Date(year, today.getMonth(), 1);
            dateFrom = monthStart.toISOString().split('T')[0];
            dateTo = today.toISOString().split('T')[0];
            break;
        case 'year':
            const yearStart = new Date(year, 0, 1);
            dateFrom = yearStart.toISOString().split('T')[0];
            dateTo = today.toISOString().split('T')[0];
            break;
        case 'q1':
            dateFrom = year + '-01-01';
            dateTo = year + '-03-31';
            break;
        case 'q2':
            dateFrom = year + '-04-01';
            dateTo = year + '-06-30';
            break;
        case 'q3':
            dateFrom = year + '-07-01';
            dateTo = year + '-09-30';
            break;
        case 'q4':
            dateFrom = year + '-10-01';
            dateTo = year + '-12-31';
            break;
        case 'h1':
            dateFrom = year + '-01-01';
            dateTo = year + '-06-30';
            break;
        case 'h2':
            dateFrom = year + '-07-01';
            dateTo = year + '-12-31';
            break;
    }

    document.getElementById('date_from').value = dateFrom;
    document.getElementById('date_to').value = dateTo;
}
</script>

@endsection