Filament stats overview with sparkline trends

<?php

namespace App\Filament\Widgets;

use App\Models\PageView;
use Filament\Support\Icons\Heroicon;
use Filament\Widgets\StatsOverviewWidget;
use Filament\Widgets\StatsOverviewWidget\Stat;
use Illuminate\Support\Carbon;
use Illuminate\Support\Collection;

class TrafficStats extends StatsOverviewWidget
{
    protected ?string $pollingInterval = '60s';

    private const DAYS = 14;

    protected function getStats(): array
    {
        $views = $this->daily(fn ($query) => $query->selectRaw('date(viewed_at) as day, count(*) as value'));
        $visitors = $this->daily(fn ($query) => $query->selectRaw('date(viewed_at) as day, count(distinct visitor_id) as value'));

        return [
            $this->card('Page views', $views),
            $this->card('Unique visitors', $visitors),
        ];
    }

    /** Build one card: total, % change versus the previous half, sparkline. */
    private function card(string $label, Collection $series): Stat
    {
        [$previous, $current] = $series->chunk(self::DAYS / 2)->map->sum()->values()->all();
        $change = $previous > 0 ? round(($current - $previous) / $previous * 100, 1) : null;
        $up = ($change ?? 0) >= 0;

        return Stat::make($label, number_format($series->sum()))
            ->description($change === null ? 'No earlier data' : abs($change).'% '.($up ? 'increase' : 'decrease'))
            ->descriptionIcon($up ? Heroicon::ArrowTrendingUp : Heroicon::ArrowTrendingDown)
            ->color($up ? 'success' : 'danger')
            ->chart($series->all());
    }

    /** Return exactly DAYS values, filling quiet days with zero so the line is continuous. */
    private function daily(callable $select): Collection
    {
        $from = Carbon::today()->subDays(self::DAYS - 1);
        $rows = $select(PageView::query()->where('viewed_at', '>=', $from))
            ->groupBy('day')
            ->pluck('value', 'day');

        return collect(range(0, self::DAYS - 1))->map(
            fn (int $i) => (int) ($rows[$from->copy()->addDays($i)->toDateString()] ?? 0)
        );
    }
}