/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 vote209 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
6 votes210 views3 answers
Laravel ecommerce
PHP Laravel
9 votes235 views4 answers
Composer require laravel/ui laravel 7
PHP Laravel
24 votes210 views2 answers
Clear laravel cache and clear vue
PHP Laravel
-1 vote217 views1 answer
When to create a service in laravel
PHP Laravel
7 votes203 views2 answers
Laravel field types from database field type
PHP Laravel
1 vote230 views2 answers
Laravel generate unique token
PHP Laravel
0 vote192 views1 answer
Laravel return view with multiple variable
PHP Laravel
12 votes258 views6 answers
Laravel redirect back with input
PHP Laravel
5 votes243 views2 answers
Laravel naming conventions
PHP Laravel