LatencyChartWidgetForUrl.php

<?php

namespace App\Filament\Widgets;

use App\Models\PingResult;
use Filament\Widgets\ChartWidget;

class LatencyChartWidgetForUrl extends ChartWidget
{
    protected int|string|array $columnSpan = 'full';
    protected static ?string $maxHeight = '250px';

    public ?string $url = null; // Public property for URL
    public ?string $filter = '24h';

    protected function getPollingInterval(): ?string
    {
        return config('speedtest.dashboard_polling');
    }

    protected function getFilters(): ?array
    {
        return [
            '24h' => 'Last 24h',
            'week' => 'Last week',
            'month' => 'Last month',
        ];
    }

    protected function getData(): array
    {
        \Log::info("Widget URL in getData: " . ($this->url ?? 'null'));

        if (!$this->url) {
            \Log::info("No URL provided for widget.");
            return [];
        }

        // Fetch results based on the URL and filter
        $results = PingResult::query()
            ->select(['id', 'avg_latency', 'packet_loss', 'created_at'])
            ->where('url', $this->url)
            ->when($this->filter == '24h', function ($query) {
                $query->where('created_at', '>=', now()->subDay());
            })
            ->when($this->filter == 'week', function ($query) {
                $query->where('created_at', '>=', now()->subWeek());
            })
            ->when($this->filter == 'month', function ($query) {
                $query->where('created_at', '>=', now()->subMonth());
            })
            ->orderBy('created_at')
            ->get();

        \Log::info("Query Results: ", $results->toArray());

        if ($results->isEmpty()) {
            \Log::info("No results found for URL: " . $this->url);
        } else {
            \Log::info("Results found: " . $results->count());
        }

        return [
            'datasets' => [
                [
                    'label' => 'Average (ms)',
                    'data' => $results->map(fn ($item) => $item->avg_latency ?? 0)->toArray(),
                    'borderColor' => 'rgb(51, 181, 229)',
                    'backgroundColor' => 'rgba(51, 181, 229, 0.2)',
                    'pointBackgroundColor' => 'rgb(51, 181, 229)',
                    'fill' => true,
                    'yAxisID' => 'left-y-axis',
                    'tension' => 0.4,
                ],
                [
                    'label' => 'Packet Loss (%)',
                    'data' => $results->map(fn ($item) => $item->packet_loss ?? 0)->toArray(),
                    'borderColor' => 'rgb(255, 87, 51)',
                    'backgroundColor' => 'rgba(255, 87, 51, 0.2)',
                    'pointBackgroundColor' => 'rgb(255, 87, 51)',
                    'fill' => true,
                    'yAxisID' => 'right-y-axis',
                    'tension' => 0.4,
                ],
            ],
            'labels' => $results->map(fn ($item) => $item->created_at->timezone(config('app.display_timezone'))->format(config('app.chart_datetime_format')))->toArray(),
            'heading' => $this->url,
        ];
    }

    protected function getOptions(): array
    {
        return [
            'plugins' => [
                'legend' => [
                    'display' => true,
                ],
            ],
            'scales' => [
                'left-y-axis' => [
                    'type' => 'linear',
                    'position' => 'left',
                    'beginAtZero' => false,
                    'title' => [
                        'display' => true,
                        'text' => 'Average (ms)',
                    ],
                    'grid' => [
                        'display' => false,
                        'drawBorder' => false,
                    ],
                ],
                'right-y-axis' => [
                    'type' => 'linear',
                    'position' => 'right',
                    'beginAtZero' => true,
                    'title' => [
                        'display' => true,
                        'text' => 'Packet Loss (%)',
                    ],
                    'grid' => [
                        'display' => false,
                        'drawBorder' => false,
                    ],
                ],
            ],
        ];
    }

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