<?php

namespace App\Filament\Widgets;

use App\Models\Order;
use Carbon\Carbon;
use Filament\Widgets\ChartWidget;

class OrdersLast12MonthsChart extends ChartWidget
{
    protected static ?string $heading = 'Orders - Last 12 Months';

    protected static ?int $sort = 6;

    


    protected function getData(): array
    {
        $end = Carbon::now()->endOfMonth();
        $start = (clone $end)->subMonths(11)->startOfMonth();

        $orders = Order::query()
            ->selectRaw('DATE_FORMAT(order_date, "%Y-%m") as ym, COUNT(*) as total')
            ->whereBetween('order_date', [$start, $end])
            ->groupByRaw('DATE_FORMAT(order_date, "%Y-%m")')
            ->orderByRaw('DATE_FORMAT(order_date, "%Y-%m")')
            ->pluck('total', 'ym');

        $labels = [];
        $data = [];

        $period = new \DatePeriod(
            $start,
            new \DateInterval('P1M'),
            (clone $end)->addMonth()->startOfMonth(),
        );

        /** @var Carbon $date */
        foreach ($period as $date) {
            $key = $date->format('Y-m');

            $labels[] = $date->format('M Y');
            $data[] = (int) ($orders[$key] ?? 0);
        }

        return [
            'datasets' => [
                [
                    'label' => 'Orders',
                    'data' => $data,
                    'borderColor' => '#000', // Tailwind blue-500
                    'backgroundColor' => 'rgba(0, 0, 0, 0.2)',
                    'fill' => true,
                    'tension' => 0.4,
                ],
            ],
            'labels' => $labels,
        ];
    }

    protected function getType(): string
    {
        return 'line';
    }


     /**
     * @return int | string | array<string, int | null>
     */
    public function getColumnSpan(): int | string | array
    {
        return 3;
    }
}