Is there a way to add a where clause the query everytime it's called?

I have city_id in my users table. And every user has more than one product. Is there a way to automatically add whereCityId(Auth::user()->city_id) to all my queries?

I know I can make a hasone method in the model but I want it to be included as soon as I make a query for it.

In simpler words, I want to get Model::whereCityId(Auth::user()->city_id)->get() when I type Model::all()

Sinnbeck

3 years ago

Best Answer

Level 102

Add a global scope: https://laravel.com/docs/9.x/eloquent#global-scopes

1 like

motinska94

3 years ago

Level 3

@Sinnbeck I'm pretty new to laravel and I have no idea how this works but I feel like this is exactly what I need. Thanks! I'll look it up.

Edit : Yup, it did! Took me 3 minutes to learn and implement. Thanks again!

Please or to participate in this conversation.