/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

12 votes190 views6 answers
Set session data in laravel
PHP Laravel
2 votes172 views1 answer
Laravel vendor:publish not working
PHP Laravel
0 vote186 views1 answer
Get deleted value laravel
PHP Laravel
5 votes161 views2 answers
Laravel encrypt decrypt
PHP Laravel
6 votes211 views1 answer
In order to use the Auth::routes() method, please install the laravel/ui package.
PHP Laravel
1 vote171 views2 answers
Laravel throttle
PHP Laravel
0 vote199 views1 answer
Laravel imap - Set message flags
PHP Laravel
0 vote212 views1 answer
How to pass parameters to relationships laravel
PHP Laravel
0 vote183 views1 answer
Laravel Secured Password
PHP Laravel
8 votes207 views4 answers
Get single column value in laravel eloquent
PHP Laravel