/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 vote118 views2 answers
Laravel pagination keep query string
PHP Laravel
39 votes126 views6 answers
Foreign key laravel migration
PHP Laravel
0 vote132 views1 answer
Laravel collective form include image
PHP Laravel
0 vote116 views1 answer
Verify laravel string must be null
PHP Laravel
2 votes107 views4 answers
Laravel redirect action
PHP Laravel
12 votes110 views4 answers
Laravel call controller method from another controller
PHP Laravel
1 vote113 views1 answer
Laravel word count utf8
PHP Laravel
0 vote105 views5 answers
Laravel authentication in laravel 8
PHP Laravel
1 vote109 views1 answer
Laravel eloquent where id not equal to
PHP Laravel
1 vote159 views1 answer
Include a file in laravel controller
PHP Laravel