$vaccinations = Vaccinations::where([ 'society_id' => $user->id ]) ->with(['spot.regional']) // Include the 'spot.regional' relationship ->select('dose', 'date as vaccination_date', 'spot_id') ->orderBy('date', 'ASC') ->get();
$vaccinations = Vaccinations::where([ 'society_id' => $user->id ]) ->with(['spot.regional']) // Include the 'spot.regional' relationship ->select('dose', 'date as vaccination_date', 'spot_id') ->orderBy('date', 'ASC') ->get();