/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

1 vote232 views2 answers
Laravel loop counter
PHP Laravel
0 vote273 views1 answer
Laravel resource set status code
PHP Laravel
-1 vote312 views3 answers
Grouping route in laravel
PHP Laravel
11 votes310 views2 answers
Select distinct laravel
PHP Laravel
30 votes274 views6 answers
Laravel insert
PHP Laravel
24 votes306 views4 answers
Clear cache command in laravel controller
PHP Laravel
51 votes414 views6 answers
Left join laravel
PHP Laravel
2 votes296 views6 answers
Laravel sanctum authentication
PHP Laravel
1 vote313 views1 answer
Integer nullable laravel
PHP Laravel
0 vote238 views1 answer
Laravel wordpress reset password
PHP Laravel