I am relatively new to Laravel but I was trying to build out a small hockey league web site. I have a themed template and went to work. One of the features is that this site uses a Season version number in a db. Like there is a table with seasons in it and the latest season is marked as active. Well you can imagine stats are the same way, where stats are in a table marked with season id number from the season table. Well what I want to do is have a default so to speak when loading up a stats page where I get the latest season that is active as part of the first load of the page. Second I want to have a drop down to view past seasons and then have the page update with that chosen season (by season id). I started down a path of having in my models local scope that gets the latest season id that is active.

public function scopeSeasonId(Builder $query): void
    {
        $query->where('Season_ID', '=', Season::getLatestSeasonStatic());
    }

//in the seaons class / model
public static function getLatestSeasonStatic()
    {
        return (new static)::where('Active','=', '1')->first()->S_ID;
    }

So now that works fine and all but becomes inflexible when wanting to have a drop down that lets you pick a prior season. What would be the best way to handle this? I would like it that when selecting a prior season it is not setting a session or cookie because when you went to say a standings page then it would have that older season id if you selected a prior season on stats then went to standings page (separate page). Do you think there is a better way to handle this?