/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 vote267 views1 answer
Onbeforeunload com mysql php
PHP
0 vote275 views1 answer
Php prepared statement upload file
PHP
0 vote357 views1 answer
Laravel get week dates
PHP Laravel
1 vote209 views4 answers
Laravel get route path uri
PHP
21 votes236 views6 answers
Laravel route parameters
PHP Laravel
3 votes230 views2 answers
Laravel eloquent search query 2020
PHP Laravel
0 vote190 views1 answer
Wordpress how to string multple function.php files together
PHP
5 votes189 views1 answer
Check if valid url php
PHP
0 vote241 views1 answer
How to get local current time in laravel
PHP Laravel
0 vote173 views1 answer
Running laravel project in mobile phone
PHP