/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 vote350 views3 answers
Laravel query builder get last insert id
PHP Laravel
14 votes374 views3 answers
How to convert string to int in php laravel
PHP Laravel
0 vote336 views1 answer
Laravel get data from model to controller
PHP Laravel
1 vote334 views2 answers
Laravel query relationship nested
PHP Laravel
10 votes288 views2 answers
Laravel migration default value not working
PHP Laravel
0 vote367 views1 answer
Laravel raw query join many to many
PHP Laravel
2 votes381 views2 answers
Laravel migration column type json
PHP Laravel
0 vote346 views1 answer
Redirect with compact laravel
PHP Laravel
7 votes318 views1 answer
Rollback laravel transaction
PHP Laravel
0 vote418 views1 answer
Laravel count the types of users
PHP Laravel