/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

5 votes256 views2 answers
Php check if class exists
PHP
0 vote262 views1 answer
Laravel username validation
PHP Laravel
7 votes256 views3 answers
Wordpress echo the date in post
PHP
0 vote252 views5 answers
Laravel 8 app with more than one database
PHP
1 vote237 views1 answer
Laravel read file from tmp
PHP
0 vote294 views1 answer
Use s3 storage laravel
PHP Laravel
0 vote295 views1 answer
Laravel skip a loop if error
PHP Laravel
1 vote242 views3 answers
Php check if some string contains from array
PHP
8 votes253 views1 answer
Laravel storage not found
PHP Laravel
2 votes316 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel