/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

4 votes211 views3 answers
Laravel execute command from terminal
PHP Laravel
0 vote226 views1 answer
Laravel mysql specified key was too long
PHP Laravel
0 vote229 views1 answer
Spatie/laravel-activitylog display only changed data
PHP Laravel
4 votes186 views2 answers
Laravel eloquent sum column
PHP Laravel
14 votes222 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP Laravel
8 votes228 views1 answer
Laravel sotrage linkl
PHP Laravel
1 vote214 views1 answer
Insert data using model in laravel 8
PHP Laravel
-1 vote217 views1 answer
Laravel list of tables
PHP Laravel
1 vote210 views2 answers
Laravel check collection has key
PHP Laravel
0 vote229 views1 answer
Laravel permit only some inputs
PHP Laravel