/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

11 votes337 views6 answers
Datetime validation in laravel
PHP Laravel
8 votes320 views3 answers
Laravel redirect back with errors and input
PHP Laravel
0 vote353 views1 answer
Show selected value in dropdown laravel
PHP Laravel
0 vote401 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
0 vote329 views1 answer
Laravel carbon first day of month
PHP Laravel
0 vote408 views1 answer
Create command laravel sample parameter
PHP Laravel
-1 vote317 views1 answer
Return true false laravel
PHP Laravel
0 vote341 views1 answer
Laravel get week dates
PHP Laravel
18 votes346 views6 answers
Laravel unique validation
PHP Laravel
2 votes316 views2 answers
Laravel eloquent multiple primary key
PHP Laravel