/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

4 votes250 views3 answers
Laravel on delete set null
PHP Laravel
5 votes299 views5 answers
Laravel file permissions
PHP Laravel
0 vote275 views1 answer
Laravel asset prevent browser caching
PHP Laravel
12 votes250 views5 answers
Laravel transactions
PHP Laravel
4 votes264 views3 answers
Laravel cmd command to watch logs
PHP Laravel
0 vote306 views1 answer
Laravel request protected prop
PHP Laravel
42 votes256 views5 answers
Create controller laravel with model
PHP Laravel
9 votes250 views2 answers
Laravel query count raw
PHP Laravel
0 vote191 views2 answers
Laravel restrict home route access
PHP Laravel
0 vote235 views2 answers
Gate and policy in laravel
PHP Laravel