/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

0 vote302 views2 answers
Htmlspecialchars
PHP
0 vote397 views1 answer
Comment ajouter un fil d’Ariane personnalisé à l’URL d’accueil dans WooCommerce
PHP
0 vote325 views1 answer
Beanstalk run laravel command
PHP Laravel
1 vote369 views1 answer
Php check how much time each instruction takes to complete
PHP
2 votes305 views1 answer
Laravel artisan create criteria
PHP
0 vote311 views2 answers
Validate contact us page 2021 php coding
PHP
11 votes335 views4 answers
Redirect back with input laravel in request
PHP Laravel
9 votes301 views3 answers
PHP Numbers
PHP
2 votes345 views2 answers
Laravel custom model primary Key
PHP Laravel
0 vote332 views1 answer
Laravel form validation based on another field value
PHP Laravel