/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

0 vote311 views1 answer
Token delete laravel
PHP
8 votes299 views5 answers
Wherebetween laravel
PHP Laravel
1 vote196 views1 answer
Return response array laravel
PHP
4 votes172 views1 answer
Rewrite .php to no extension
PHP
21 votes137 views4 answers
Php artisan migrate fresh seed
PHP
0 vote173 views1 answer
Php server on local machine
PHP
0 vote173 views3 answers
Laravel transform object to array
PHP
0 vote322 views1 answer
Yii 1 clear cache
PHP Yii
38 votes214 views6 answers
Create seed file laravel
PHP
0 vote275 views1 answer
HP officejet pro 8720 default password
PHP