/PHP/Laravel/Laravel - Add conditional where clause in query

Laravel - Add conditional where clause in query

$user_to_mail = User::where('store_id', $item->store_id)
                    ->when($store->notification_role_id > 0, function ($q) use ($store) {
                        return $q->where('role_id', $store->notification_role_id);
                    })
                    ->get();

Similar codes

7 votes295 views2 answers
Php laravel between dates
PHP Laravel
23 votes277 views6 answers
Make auth in laravel 7
PHP Laravel
0 vote271 views2 answers
Array collapse laravel
PHP Laravel
0 vote233 views1 answer
How to store multiple value in session in laravel
PHP Laravel
5 votes286 views4 answers
Laravel remove foreign key
PHP Laravel
0 vote280 views1 answer
Case inside laravel query
PHP Laravel
0 vote279 views2 answers
What is composer in laravel
PHP Laravel
12 votes279 views4 answers
Laravel return redirect to named route
PHP Laravel
0 vote255 views1 answer
Laravel auth trying to get property 'instid' of non-object
PHP Laravel
0 vote317 views1 answer
How to prevent user to add duplicate card in stripe using laravel
PHP Laravel