/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

0 vote463 views1 answer
Plesk web config file laravel
PHP Laravel
1 vote323 views1 answer
String to uppercase laravel
PHP Laravel
15 votes349 views3 answers
Laravel date set timezone
PHP Laravel
2 votes320 views1 answer
Laravel where update query
PHP Laravel
0 vote363 views1 answer
Select max id laravel
PHP Laravel
4 votes375 views1 answer
Get client size in laravel
PHP Laravel
0 vote340 views2 answers
Add blade in blade laravel
PHP Laravel
6 votes393 views4 answers
Laravel url previous
PHP Laravel
0 vote354 views1 answer
Cout post on category in controller laravel
PHP Laravel
7 votes334 views2 answers
Laravel collection isEmpty
PHP Laravel