/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 vote146 views1 answer
Laravel create coma separated string from query
PHP Laravel
2 votes158 views3 answers
Spartie all user with role get laravel
PHP Laravel
9 votes143 views2 answers
How to write for loop in laravel blade
PHP Laravel
0 vote164 views2 answers
Fetch data based on month and year in laravel
PHP Laravel
3 votes157 views3 answers
Insert timestamps manually in laravel
PHP Laravel
0 vote220 views1 answer
Laravel 8 model filter
PHP Laravel
0 vote129 views1 answer
Redirect to attempting url after login laravel
PHP Laravel
6 votes153 views1 answer
Insall laravel
PHP Laravel
5 votes154 views2 answers
Laravel blade upper case
PHP Laravel
1 vote144 views1 answer
Invalid datetime format laravel
PHP Laravel