/PHP/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 vote309 views3 answers
Php artisan create controller inside folder
PHP
0 vote323 views1 answer
The Laravel installer requires PHP 7.3.0 or greater. Please use "composer create-project laravel/laravel" instead.
PHP
6 votes334 views2 answers
Laravel migration make column nullable
PHP Laravel
1 vote345 views1 answer
Php absolute value
PHP
5 votes330 views6 answers
Sync laravel
PHP Laravel
0 vote417 views1 answer
Laravel nova card duplicate keys
PHP Laravel
0 vote330 views1 answer
Laravel npm run dev mix error FIX
PHP
0 vote356 views1 answer
Wp custom rest endpoint
PHP
0 vote349 views3 answers
Permissions for laravel deployment
PHP
0 vote336 views1 answer
Pass variable in laravel ancher tag laravel 8
PHP Laravel