/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

7 votes219 views4 answers
$errors show this error in laravel
PHP Laravel
1 vote222 views1 answer
Laravel add crf token form
PHP Laravel
0 vote232 views1 answer
Laravel convert eloquent collection to collection
PHP Laravel
0 vote223 views1 answer
Laravel update all relations
PHP Laravel
0 vote221 views1 answer
Compile custom/plain css with mix in laravel
PHP Laravel
0 vote210 views1 answer
Laravel withcount change name
PHP Laravel
2 votes190 views2 answers
Laravel select query return array
PHP Laravel
2 votes224 views3 answers
Format date laravel timestamp view
PHP Laravel
1 vote213 views1 answer
How create page 419 in laravel
PHP Laravel
9 votes246 views6 answers
Laravel validation custom message
PHP Laravel