/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 vote136 views1 answer
How to check exist in array in rule validation laravel
PHP Laravel
0 vote133 views1 answer
Integrity constraint violation laravel socialite google login
PHP Laravel
1 vote118 views1 answer
Date format in laravel month name day name
PHP Laravel
-1 vote128 views3 answers
Delete rows by migration laravel
PHP Laravel
12 votes125 views6 answers
Set session data in laravel
PHP Laravel
1 vote126 views1 answer
How to catch query exception in laravel 8
PHP Laravel
-1 vote120 views1 answer
Clear Caching of Queries Laravel Specific Model Cache
PHP Laravel
0 vote134 views2 answers
Carbon Format date with timezone in views Laravel
PHP Laravel
0 vote147 views1 answer
Edit items in Laravel collection
PHP Laravel
1 vote262 views2 answers
Laravel 8 livewire tutorial
PHP Laravel