I have two models with relationship: City and Events.

In the controller i have this:

$cities = City::all();

return View::make('eventsdetails', compact('cities'));

In the view i have this:

@foeach($cities as $city) {{ $city->name." Events: ".$city->Events()->count(); }} @endforeach

It works!! My problem is when i need to add "wheres" in the count(). Eg:

if($categorie->id > 0){ $city->Events() ->whereCategorie($categorie->id) ->count(); }

if($subcategorie->id > 0){ $city->Events() ->whereCategorie($categorie->id) ->whereSubcategorie($subcategorie->id) ->count(); }

I don't want to use this kind of queries in my view.

What is the best way to do that??