/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

3 votes328 views4 answers
Codeigniter apache remove index.php
PHP CodeIgniter
2 votes247 views1 answer
Laravel carbon human readable
PHP Laravel
2 votes206 views1 answer
Convert number to month php
PHP
0 vote330 views1 answer
Laravel joins eloquent model
PHP Laravel
6 votes231 views4 answers
Laravel base url
PHP
4 votes200 views1 answer
Phpunit repeat
PHP
0 vote257 views1 answer
Orwherebetween laravel
PHP Laravel
0 vote276 views1 answer
Wordpress plugin development
PHP Wordpress
1 vote224 views3 answers
Woocommerce get post meta
PHP
1 vote277 views1 answer
Laravel where multiple conditions on single colmn
PHP Laravel