/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

1 vote262 views3 answers
Laravel api enable cors
PHP Laravel
33 votes280 views6 answers
Laravel carbon
PHP Laravel
5 votes230 views3 answers
Laravel destroy session
PHP Laravel
6 votes264 views1 answer
Route params link laravel
PHP Laravel
1 vote310 views4 answers
Laravel flash message
PHP Laravel
6 votes278 views6 answers
Laravel create project
PHP Laravel
0 vote254 views1 answer
Laravel cmd add to column
PHP Laravel
1 vote269 views6 answers
Laravel get url parameters in controller
PHP Laravel
23 votes243 views6 answers
Laravel validation messages
PHP Laravel
0 vote248 views1 answer
Optimize clear laravel not working
PHP Laravel