@extends('layouts.app')
@section('title', 'Cashier Dashboard')
@section('content')
    <div class="content-heading">
        <div>
            Cashier Dashboard - {{ $company->name }}
            <small>Welcome, {{ Auth::user()->name }}</small>
        </div>
    </div>

    <!-- START KPI cards box -->
    <div class="row">
        <div class="col-xl-3 col-md-6">
            <!-- Total Clients -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-success-dark justify-content-center rounded-left">
                    <em class="fas fa-users fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-success rounded-right">
                    <div class="h2 mt-0">{{ $totalClients }}</div>
                    <div class="text-uppercase">Total Clients</div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Total Billings -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-danger-dark justify-content-center rounded-left">
                    <em class="fas fa-file-invoice-dollar fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-danger rounded-right">
                    <div class="h2 mt-0">{{ $totalBillings }}</div>
                    <div class="text-uppercase">Billings</div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Total Collected -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-info-dark justify-content-center rounded-left">
                    <em class="fas fa-money-bill-wave fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-info rounded-right">
                    <div class="h2 mt-0">{{ $currencySymbol }}{{ number_format($totalCollected, 2) }}</div>
                    <div class="text-uppercase">Collected</div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Total Due -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-warning-dark justify-content-center rounded-left">
                    <em class="fas fa-hand-holding-usd fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-warning rounded-right">
                    <div class="h2 mt-0">{{ $currencySymbol }}{{ number_format($totalDue, 2) }}</div>
                    <div class="text-uppercase">Total Due</div>
                </div>
            </div>
        </div>
    </div>

    <!-- Additional KPI Cards -->
    <div class="row">
        <div class="col-xl-3 col-md-6">
            <!-- Paid Billings -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-success-dark justify-content-center rounded-left">
                    <em class="fas fa-check-circle fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-success rounded-right">
                    <div class="h2 mt-0">{{ $paidBillings }}</div>
                    <div class="text-uppercase">Paid Billings</div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Unpaid Billings -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-danger-dark justify-content-center rounded-left">
                    <em class="fas fa-exclamation-circle fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-danger rounded-right">
                    <div class="h2 mt-0">{{ $unpaidBillings }}</div>
                    <div class="text-uppercase">Unpaid Billings</div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Overdue Billings -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-warning-dark justify-content-center rounded-left">
                    <em class="fas fa-hourglass-end fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-warning rounded-right">
                    <div class="h2 mt-0">{{ $overdueBillings }}</div>
                    <div class="text-uppercase">Overdue</div>
                </div>
            </div>
        </div>

        <div class="col-xl-3 col-md-6">
            <!-- Disconnected Clients -->
            <div class="card flex-row align-items-center align-items-stretch border-0">
                <div class="col-4 d-flex align-items-center bg-dark justify-content-center rounded-left">
                    <em class="fas fa-plug fa-3x"></em>
                </div>
                <div class="col-8 py-3 bg-dark rounded-right">
                    <div class="h2 mt-0">{{ $disconnectedClients }}</div>
                    <div class="text-uppercase">Disconnected</div>
                </div>
            </div>
        </div>
    </div>
    <!-- END KPI cards box -->

    <!-- Quick Actions -->
    <div class="card mb-4">
        <div class="card-header">
            <i class="fas fa-rocket me-2"></i>Quick Actions
        </div>
        <div class="card-body">
            <div class="row">
                <div class="col-md-3 col-sm-6 mb-3">
                    <a href="{{ route('payments.create') }}" class="btn btn-success btn-block w-100">
                        <i class="fas fa-plus"></i> Record Payment
                    </a>
                </div>
                <div class="col-md-3 col-sm-6 mb-3">
                    <a href="{{ route('billings.index') }}" class="btn btn-info btn-block w-100">
                        <i class="fas fa-search"></i> Search Billing
                    </a>
                </div>
                <div class="col-md-3 col-sm-6 mb-3">
                    <a href="{{ route('applications.index') }}" class="btn btn-primary btn-block w-100">
                        <i class="fas fa-file-alt"></i> New Application
                    </a>
                </div>
                <div class="col-md-3 col-sm-6 mb-3">
                    <a href="{{ route('clients.index') }}" class="btn btn-warning btn-block w-100">
                        <i class="fas fa-ban"></i> Disconnect/Reconnect
                    </a>
                </div>
            </div>
        </div>
    </div>

    <div class="row">
        <div class="col-lg-8">
            <!-- Recent Payments -->
            <div class="card mb-4">
                <div class="card-header">
                    <i class="fas fa-receipt me-2"></i>Recent Payments
                </div>
                <div class="card-body">
                    @if($recentPayments->count() > 0)
                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead>
                                    <tr>
                                        <th>Date</th>
                                        <th>Client</th>
                                        <th>Billing #</th>
                                        <th>Amount</th>
                                        <th>Method</th>
                                        <th>Status</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($recentPayments as $payment)
                                        <tr>
                                            <td>{{ $payment->created_at ? \Carbon\Carbon::parse($payment->created_at)->format('M d, Y') : 'N/A' }}</td>
                                            <td>{{ $payment->billing?->client?->name ?? 'N/A' }}</td>
                                            <td>
                                                <a href="{{ route('billings.show', $payment->billing) }}">
                                                    {{ $payment->billing->billing_number ?? 'N/A' }}
                                                </a>
                                            </td>
                                            <td><strong>{{ $currencySymbol }}{{ number_format($payment->amount, 2) }}</strong></td>
                                            <td>{{ ucfirst(str_replace('_', ' ', $payment->payment_method)) }}</td>
                                            <td><span class="badge bg-success">{{ ucfirst($payment->status) }}</span></td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <p class="text-muted">No payments recorded yet.</p>
                    @endif
                </div>
            </div>
        </div>

        <div class="col-lg-4">
            <!-- Company Settings Summary -->
            <div class="card mb-4">
                <div class="card-header">
                    <i class="fas fa-info-circle me-2"></i>Quick Summary
                </div>
                <div class="card-body">
                    <div class="mb-3">
                        <div class="d-flex justify-content-between align-items-center mb-2">
                            <span>Collections Today:</span>
                            <strong class="h5">{{ $currencySymbol }}{{ number_format($todayCollections, 2) }}</strong>
                        </div>
                    </div>
                    <hr>
                    <div class="mb-3">
                        <div class="d-flex justify-content-between align-items-center mb-2">
                            <span>Pending Billings:</span>
                            <span class="badge bg-warning">{{ $pendingBillings }}</span>
                        </div>
                    </div>
                    <div class="mb-3">
                        <div class="d-flex justify-content-between align-items-center mb-2">
                            <span>Overdue Billings:</span>
                            <span class="badge bg-danger">{{ $overdueBillings }}</span>
                        </div>
                    </div>
                    <hr>
                    <div class="mb-3">
                        <strong>{{ $company->name }}</strong>
                        <p class="text-muted small mb-2">{{ $company->city ?? 'N/A' }}, {{ $company->country ?? 'N/A' }}</p>
                        <p class="text-muted small">
                            <strong>Currency:</strong> <span class="badge bg-primary">{{ $currencySymbol }}</span>
                        </p>
                    </div>
                </div>
            </div>

            <!-- Payment Methods Distribution -->
            <div class="card">
                <div class="card-header">
                    <i class="fas fa-chart-pie me-2"></i>Collection Methods
                </div>
                <div class="card-body">
                    @php
                        $paymentMethods = \App\Models\Payment::whereIn('billing_id', 
                            \App\Models\Billing::whereIn('client_id', $company->clients()->pluck('id'))->pluck('id')
                        )->whereDate('created_at', today())->groupBy('payment_method')->selectRaw('payment_method, COUNT(*) as count')->get();
                    @endphp
                    @if($paymentMethods->count() > 0)
                        <div class="list-group list-group-sm">
                            @foreach($paymentMethods as $method)
                                <div class="list-group-item d-flex justify-content-between align-items-center">
                                    <span>{{ ucfirst(str_replace('_', ' ', $method->payment_method)) }}</span>
                                    <span class="badge bg-secondary">{{ $method->count }}</span>
                                </div>
                            @endforeach
                        </div>
                    @else
                        <p class="text-muted small">No collections recorded today</p>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Non-Payment and Disconnection Section -->
    <div class="row mt-4">
        <!-- Overdue Billings Card -->
        <div class="col-xl-6 mb-4">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center bg-danger">
                    <div>
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <strong>Overdue Billings</strong>
                        <span class="badge bg-white text-danger ms-2">{{ $totalOverdueBillings }}</span>
                    </div>
                    <a href="{{ route('disconnections.index') }}" class="btn btn-sm btn-light">View All</a>
                </div>
                <div class="card-body p-0">
                    @if($overdueBillingsList && $overdueBillingsList->count() > 0)
                        <div class="table-responsive">
                            <table class="table table-hover table-sm mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Client</th>
                                        <th>Account #</th>
                                        <th>Overdue</th>
                                        <th>Overdue Since</th>
                                        <th>Amount Due</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($overdueBillingsList as $billing)
                                        <tr>
                                            <td>
                                                <strong>{{ $billing->client->name }}</strong>
                                            </td>
                                            <td>{{ $billing->client->account_number }}</td>
                                            <td>
                                                <span class="badge bg-danger" title="Due {{ $billing->due_date?->format('M d, Y g:i A') }}">
                                                    {{ $billing->overdueForHumans() }}
                                                </span>
                                            </td>
                                            <td>
                                                <small>{{ $billing->overdueSince()?->format('M d, Y') ?? '—' }}</small>
                                            </td>
                                            <td><strong>{{ $currencySymbol }}{{ number_format($billing->balance, 2) }}</strong></td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <p class="text-muted text-center py-4">No overdue billings</p>
                    @endif
                </div>
            </div>
        </div>

        <!-- Disconnection Eligible Card -->
        <div class="col-xl-6 mb-4">
            <div class="card">
                <div class="card-header d-flex justify-content-between align-items-center bg-warning">
                    <div>
                        <i class="fas fa-plug-circle-xmark me-2"></i>
                        <strong>Disconnection Eligible</strong>
                        <span class="badge bg-white text-warning ms-2">{{ $totalDisconnectionEligible }}</span>
                    </div>
                    <a href="{{ route('disconnections.index') }}" class="btn btn-sm btn-light">Manage</a>
                </div>
                <div class="card-body p-0">
                    @if($disconnectionEligibleList && $disconnectionEligibleList->count() > 0)
                        <div class="table-responsive">
                            <table class="table table-hover table-sm mb-0">
                                <thead class="table-light">
                                    <tr>
                                        <th>Client</th>
                                        <th>Account #</th>
                                        <th>Disconnect Date</th>
                                        <th>Amount Due</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach($disconnectionEligibleList as $billing)
                                        <tr>
                                            <td>
                                                <strong>{{ $billing->client->name }}</strong>
                                            </td>
                                            <td>{{ $billing->client->account_number }}</td>
                                            <td>
                                                <span class="badge bg-warning">
                                                    {{ $billing->getEffectiveDisconnectionDate()?->format('M d, Y') ?? 'N/A' }}
                                                </span>
                                            </td>
                                            <td><strong>{{ $currencySymbol }}{{ number_format($billing->balance, 2) }}</strong></td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <p class="text-muted text-center py-4">No billings eligible for disconnection</p>
                    @endif
                </div>
            </div>
        </div>
    </div>

    <!-- Recent Late Fees Card -->
    <div class="card mt-4">
        <div class="card-header bg-info d-flex justify-content-between align-items-center">
            <div>
                <i class="fas fa-hand-holding-heart me-2"></i>
                <strong>Recent Late Fees Applied</strong>
            </div>
        </div>
        <div class="card-body p-0">
            @if($recentLateFeesList && $recentLateFeesList->count() > 0)
                <div class="table-responsive">
                    <table class="table table-hover table-sm mb-0">
                        <thead class="table-light">
                            <tr>
                                <th>Client</th>
                                <th>Amount</th>
                                <th>Date Applied</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($recentLateFeesList as $payment)
                                <tr>
                                    <td>
                                        <strong>{{ $payment->billing?->client->name ?? 'N/A' }}</strong>
                                    </td>
                                    <td><strong>{{ $currencySymbol }}{{ number_format($payment->amount, 2) }}</strong></td>
                                    <td><small>{{ $payment->created_at->format('M d, Y H:i') }}</small></td>
                                </tr>
                            @endforeach
                        </tbody>
                    </table>
                </div>
            @else
                <p class="text-muted text-center py-4">No late fees applied</p>
            @endif
        </div>
    </div>
@endsection