<?php

namespace App\Console\Commands;

use App\Services\KpiService;
use Illuminate\Console\Command;

class RefreshKpiCache extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'kpi:refresh {--force : Force refresh even if cache is valid}';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Refresh KPI data from Google Sheets';

    /**
     * Execute the console command.
     */
    public function handle(KpiService $kpiService): int
    {
        $this->info('Refreshing KPI data from Google Sheets...');

        // Clear existing cache first
        $kpiService->clearCache();
        $this->line('Cache cleared.');

        // Fetch fresh data
        $data = $kpiService->getKpiData();

        if ($data['updated_at']) {
            $this->info('KPI data refreshed successfully!');
            $this->table(
                ['Metric', 'Value'],
                collect($data['data'])->map(function ($value, $key) {
                    return [
                        str_replace('_', ' ', ucwords($key, '_')),
                        number_format($value),
                    ];
                })->toArray()
            );
            $this->line("Updated at: {$data['updated_at']}");
            return Command::SUCCESS;
        }

        $this->warn('Failed to fetch fresh data, using default values.');
        return Command::FAILURE;
    }
}