<?php

namespace App\Reporting;

use App\Contracts\ReportTile;
use App\Reporting\Concerns\HasReportingPeriod;
use Carbon\Carbon;
use Mtc\VehicleReservations\Reservation;

class ReservationsKPI extends ReportTile
{
    use HasReportingPeriod;

    private mixed $value = null;
    private mixed $second_value = null;

    public function name(): string
    {
        return 'Reservations';
    }

    public function value(): mixed
    {
        if ($this->value === null) {
            $this->value = $this->countBetween($this->windowStart(), $this->windowEnd());
        }
        return $this->value;
    }

    public function difference(): mixed
    {
        if ($this->secondaryValue() > 0) {
            return (100 * round(($this->value() - $this->secondaryValue()) / $this->secondaryValue(), 2)) . '%';
        }
        return '';
    }

    public function secondaryValue(): mixed
    {
        if ($this->second_value === null) {
            $this->second_value = $this->countBetween($this->previousStart(), $this->previousEnd());
        }
        return $this->second_value;
    }

    public function subtitle(): string
    {
        return $this->periodSubtitle();
    }

    public function secondaryValueName(): string
    {
        return $this->previousPeriodName();
    }

    private function countBetween(Carbon $from, Carbon $to): int
    {
        return Reservation::query()
            ->whereNotNull('confirmed_at')
            ->whereBetween('confirmed_at', [$from, $to])
            ->count();
    }
}
