/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 vote323 views1 answer
Laravel collection reject
PHP Laravel
0 vote299 views1 answer
Laravel 8 template favicon
PHP Laravel
4 votes250 views1 answer
Use str laravel
PHP Laravel
1 vote293 views1 answer
Laravel date rule before 18 years ago
PHP Laravel
1 vote308 views1 answer
Redirect http to https htaccess laravel 8
PHP Laravel
4 votes271 views2 answers
Delete all rows in table laravel
PHP Laravel
50 votes375 views6 answers
Laravel add column to table
PHP Laravel
0 vote309 views1 answer
Laravel print builder
PHP Laravel
2 votes283 views4 answers
Laravel hash password check
PHP Laravel
4 votes250 views3 answers
Laravel description substring
PHP Laravel