@php
    $topTotal = $topItems->sum('total_amount');
    $topPct   = $grandTotal > 0 ? round($topTotal / $grandTotal * 100, 1) : 0;
    $maxAmt   = $topItems->max('total_amount');
@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">Grand Total</div>
                <div class="fs-5 fw-bold">{{ number_format($grandTotal, 2) }}</div>
                <div class="small text-white-50">all categories</div>
            </div>
        </div>
    </div>
    <div class="col-6 col-lg-3">
        <div class="card text-bg-danger">
            <div class="card-body py-3">
                <div class="small fw-semibold text-white-50 mb-1">Top {{ $limit }} Spend</div>
                <div class="fs-5 fw-bold">{{ number_format($topTotal, 2) }}</div>
                <div class="small text-white-50">{{ $topPct }}% of total</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">#1 Item</div>
                <div class="fw-bold text-truncate">{{ $topItems->first()?->expense_item_name ?? '—' }}</div>
                <div class="small text-white-50">{{ number_format($topItems->first()?->total_amount ?? 0, 2) }}</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">Total Occurrences</div>
                <div class="fs-5 fw-bold">{{ number_format($topItems->sum('occurrence_count')) }}</div>
                <div class="small text-white-50">across top {{ $limit }}</div>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center py-2">
        <span class="fw-semibold small">Top {{ $limit }} Expense Items</span>
        <span class="badge bg-secondary">Ranked by total amount</span>
    </div>
    <div class="table-responsive">
        @if($topItems->isEmpty())
            <div class="text-center text-muted py-5">No expense items found.</div>
        @else
        <table class="table table-hover table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Rank</th>
                    <th>Expense Item</th>
                    <th class="text-end">Occurrences</th>
                    <th class="text-end">Total Amount</th>
                    <th class="text-end">% of Total</th>
                    <th>Amount Bar</th>
                </tr>
            </thead>
            <tbody>
                @foreach($topItems as $i => $row)
                @php $barPct = $maxAmt > 0 ? round($row->total_amount / $maxAmt * 100) : 0; @endphp
                <tr>
                    <td>
                        @if($i === 0)
                            <span class="badge bg-warning text-dark">#1</span>
                        @elseif($i === 1)
                            <span class="badge bg-secondary">#2</span>
                        @elseif($i === 2)
                            <span class="badge" style="background:#cd7f32">#3</span>
                        @else
                            <span class="text-muted small">#{{ $i + 1 }}</span>
                        @endif
                    </td>
                    <td class="fw-semibold">{{ $row->expense_item_name }}</td>
                    <td class="text-end">{{ number_format($row->occurrence_count) }}</td>
                    <td class="text-end fw-semibold">{{ number_format($row->total_amount, 2) }}</td>
                    <td class="text-end">
                        <span class="badge bg-primary">{{ $row->percentage }}%</span>
                    </td>
                    <td style="min-width:140px">
                        <div class="progress" style="height:6px">
                            <div class="progress-bar bg-danger" style="width:{{ $barPct }}%"></div>
                        </div>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
        @endif
    </div>
</div>