I have a many to many relationship set up, between locations and stations. A location can have many assigned stations, but only one can be active. I have a pivot table (station_location) where i'm setting an is_active attribute using a setActive method, however i'm trying to figure out a sensible way to approach setting one to active, and all others to inactive.
I need this to be reusable as i'll have to set it in multiple places (not just from a controller). I wonder if anybody has an idea of how to achieve this?
You can use sync method as below
$station->locations()
->sync([1 => ['is_active' => true], 2 => ['is_active' => false], 3 => ['is_active' => false]]);
more here
PS: 1,2,3 etc in passed array are locations ids.