/PHP/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

10 votes113 views4 answers
Twig dump
PHP
0 vote112 views5 answers
Date format change in laravel
PHP
0 vote131 views2 answers
Delete in wordpress query
PHP
0 vote128 views1 answer
IP Authorization php code
PHP
2 votes127 views1 answer
Get the current route in laravel
PHP Laravel
0 vote117 views1 answer
Woocommerce get image galleries by product id
PHP
0 vote120 views1 answer
Check default token ttl value in vault
PHP
0 vote142 views1 answer
Laravel webmix scss
PHP
16 votes120 views6 answers
Laravel redirect back
PHP
1 vote121 views1 answer
Create new laravel project ubuntu
PHP