/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 vote163 views1 answer
If condition view page of laravel
PHP Laravel
1 vote147 views2 answers
Laravel return response with headers
PHP Laravel
4 votes157 views2 answers
Laravel eloquent sum column
PHP Laravel
5 votes168 views5 answers
Table drop foreign php laravel
PHP Laravel
2 votes150 views1 answer
Get user ip laravel
PHP Laravel
0 vote145 views2 answers
Laravel logout all users
PHP Laravel
3 votes166 views1 answer
Back route laravel
PHP Laravel
0 vote140 views3 answers
Laravel has many deep
PHP Laravel
1 vote119 views1 answer
Custom column for latest() laravel
PHP Laravel
1 vote150 views2 answers
Re migrate laravel
PHP Laravel