Consolidate prediction functionality by merging /api/prediction endpoint into /api/stations response. Move prediction logic from PredictionController into StationController, returning prediction data alongside station results. Replace usePrediction composable with unified useStations that returns {stations, meta, prediction}. Remove PredictionRequest, related tests, and unused Vue components (FuelFinderTest, MapTest, RecommendationTest, StationListTest). Add PredictionFull component and UpsellBanner. Extend NationalFuelPredictionService to include weekly_summary (7-day series, yesterday/today averages, cheapest/priciest days) and oil signal from price_predictions table. Update Home.vue to consume prediction from stations response. Add Plan::resolveCadenceForUser helper and configure Cashier to use custom Subscription model.
55 lines
1.5 KiB
PHP
55 lines
1.5 KiB
PHP
<?php
|
|
|
|
namespace App\Models;
|
|
|
|
use App\Enums\PredictionSource;
|
|
use App\Enums\TrendDirection;
|
|
use Database\Factories\PricePredictionFactory;
|
|
use Illuminate\Database\Eloquent\Attributes\Fillable;
|
|
use Illuminate\Database\Eloquent\Builder;
|
|
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
|
use Illuminate\Database\Eloquent\Model;
|
|
|
|
#[Fillable(['predicted_for', 'source', 'direction', 'confidence', 'reasoning', 'generated_at'])]
|
|
class PricePrediction extends Model
|
|
{
|
|
/** @use HasFactory<PricePredictionFactory> */
|
|
use HasFactory;
|
|
|
|
public $timestamps = false;
|
|
|
|
protected function casts(): array
|
|
{
|
|
return [
|
|
'predicted_for' => 'date',
|
|
'source' => PredictionSource::class,
|
|
'direction' => TrendDirection::class,
|
|
'confidence' => 'integer',
|
|
'generated_at' => 'datetime',
|
|
];
|
|
}
|
|
|
|
/**
|
|
* Order by source quality: llm_with_context → llm → ewma.
|
|
* Use this whenever reading the "best" prediction for a given date.
|
|
*
|
|
* @param Builder<PricePrediction> $query
|
|
* @return Builder<PricePrediction>
|
|
*/
|
|
public function scopeBestFirst(Builder $query): Builder
|
|
{
|
|
$priority = [
|
|
PredictionSource::LlmWithContext->value,
|
|
PredictionSource::Llm->value,
|
|
PredictionSource::Ewma->value,
|
|
];
|
|
|
|
$cases = '';
|
|
foreach ($priority as $rank => $source) {
|
|
$cases .= " WHEN '$source' THEN $rank";
|
|
}
|
|
|
|
return $query->orderByRaw("CASE source$cases ELSE ".count($priority).' END');
|
|
}
|
|
}
|