@php
    $totalAmount  = $trend->sum('total_amount');
    $totalEntries = $trend->sum('entry_count');
    $peakPeriod   = $trend->sortByDesc('total_amount')->first();
    $maxVal       = $trend->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">Total in Range</div>
                <div class="fs-5 fw-bold">{{ number_format($totalAmount, 2) }}</div>
                <div class="small text-white-50">{{ $trend->count() }} {{ $groupBy }} periods</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">Peak Period</div>
                <div class="fw-bold">{{ $peakPeriod?->period ?? '—' }}</div>
                <div class="small text-white-50">{{ number_format($peakPeriod?->total_amount ?? 0, 2) }}</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 Period</div>
                <div class="fs-5 fw-bold">
                    {{ $trend->count() > 0 ? number_format($totalAmount / $trend->count(), 2) : '0.00' }}
                </div>
                <div class="small text-white-50">{{ ucfirst($groupBy) }} average</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 Entries</div>
                <div class="fs-5 fw-bold">{{ number_format($totalEntries) }}</div>
                <div class="small text-white-50">expense records</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">Expense Trend — {{ ucfirst($groupBy) }} View</span>
        <span class="badge bg-secondary">{{ $trend->count() }} periods</span>
    </div>
    <div class="table-responsive">
        @if($trend->isEmpty())
            <div class="text-center text-muted py-5">No trend data found.</div>
        @else
        <table class="table table-hover table-sm align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>Period</th>
                    <th class="text-end">Summaries</th>
                    <th class="text-end">Entries</th>
                    <th class="text-end">Avg per Entry</th>
                    <th class="text-end">Total Amount</th>
                    <th>vs Peak</th>
                </tr>
            </thead>
            <tbody>
                @foreach($trend as $row)
                @php $pct = $maxVal > 0 ? round($row->total_amount / $maxVal * 100, 1) : 0; @endphp
                <tr>
                    <td class="fw-semibold small">{{ $row->period }}</td>
                    <td class="text-end">{{ number_format($row->summary_count) }}</td>
                    <td class="text-end">{{ number_format($row->entry_count) }}</td>
                    <td class="text-end">
                        {{ $row->entry_count > 0 ? number_format($row->total_amount / $row->entry_count, 2) : '0.00' }}
                    </td>
                    <td class="text-end fw-semibold">{{ number_format($row->total_amount, 2) }}</td>
                    <td style="min-width:140px">
                        <div class="d-flex align-items-center gap-2">
                            <div class="progress flex-grow-1" style="height:6px">
                                <div class="progress-bar" style="width:{{ $pct }}%"></div>
                            </div>
                            <small class="text-muted text-nowrap">{{ $pct }}%</small>
                        </div>
                    </td>
                </tr>
                @endforeach
            </tbody>
            <tfoot class="table-light fw-semibold">
                <tr>
                    <td colspan="4">Total</td>
                    <td class="text-end">{{ number_format($totalAmount, 2) }}</td>
                    <td></td>
                </tr>
            </tfoot>
        </table>
        @endif
    </div>
</div>