@php
    $totalRecords = $summaries->count();
    $grandExpense = $summaries->sum('total_expense');
    $avgExpense   = $totalRecords > 0 ? round($grandExpense / $totalRecords, 2) : 0;
    $maxExpense   = $summaries->max('total_expense');
@endphp

{{-- Stat cards --}}
<div class="row g-3 mb-3">
    <div class="col-6 col-lg-3">
        <div class="card text-bg-primary">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Total Expense</div>
                <div class="fs-5 fw-bold">{{ number_format($grandExpense, 2) }}</div>
                <div class="small text-white-50">{{ $totalRecords }} summaries</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-success">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Avg per Summary</div>
                <div class="fs-5 fw-bold">{{ number_format($avgExpense, 2) }}</div>
                <div class="small text-white-50">per period</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-warning">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Highest Single</div>
                <div class="fs-5 fw-bold">{{ number_format($maxExpense, 2) }}</div>
                <div class="small text-white-50">peak expense day</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-secondary">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Periods Recorded</div>
                <div class="fs-5 fw-bold">{{ $totalRecords }}</div>
                <div class="small text-white-50">in date range</div>
            </div>
        </div>
    </div>
</div>

{{-- Table --}}
<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center py-2">
        <span class="fw-semibold small">Expense Summaries</span>
        <span class="badge bg-secondary">{{ $totalRecords }} records</span>
    </div>
    <div class="table-responsive">
        @if($summaries->isEmpty())
            <div class="text-center text-muted py-5">
                <p class="mb-0">No expense records found for this period.</p>
            </div>
        @else
        <table class="table table-hover table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Date</th>
                    <th>Summary #</th>
                    <th>Branch</th>
                    <th class="text-end">Entries</th>
                    <th>Top Item</th>
                    <th class="text-end">Total Expense</th>
                    <th class="text-end">vs Average</th>
                </tr>
            </thead>
            <tbody>
                @foreach($summaries as $s)
                @php $diff = $s->total_expense - $avgExpense; @endphp
                <tr>
                    <td class="text-nowrap">{{ \Carbon\Carbon::parse($s->date)->format('M d, Y') }}</td>
                    <td><span class="badge bg-primary">{{ $s->id }}</span></td>
                    <td>{{ $s->branch?->name }}</td>
                    <td class="text-end">{{ $s->expense_count }}</td>
                    <td class="text-muted small">{{ $s->top_expense_item }}</td>
                    <td class="text-end fw-semibold">{{ number_format($s->total_expense, 2) }}</td>
                    <td class="text-end">
                        <span class="badge {{ $diff > 0 ? 'bg-danger' : 'bg-success' }}">
                            {{ $diff > 0 ? '+' : '' }}{{ number_format($diff, 2) }}
                        </span>
                    </td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="table-light fw-semibold">
                <tr>
                    <td colspan="5">Grand Total</td>
                    <td class="text-end">{{ number_format($grandExpense, 2) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
        @endif
    </div>
</div>