/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 vote229 views1 answer
How run all seeder at once in laravel
PHP Laravel
0 vote220 views1 answer
Order by sum() laravel
PHP Laravel
17 votes295 views6 answers
Laravel auth user in constructor
PHP Laravel
1 vote218 views1 answer
Laravel set config value dynamically
PHP Laravel
0 vote228 views3 answers
Laravel 7 upload file s3
PHP Laravel
0 vote222 views2 answers
Use class in blade laravel
PHP Laravel
0 vote235 views1 answer
Send emails with runtime configurations in laravelk
PHP Laravel
0 vote261 views1 answer
Loop laravel 8
PHP Laravel
0 vote261 views1 answer
Laravel cmd add to column
PHP Laravel
0 vote240 views2 answers
Sweet alert confirm box laravel
PHP Laravel