/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

5 votes163 views2 answers
Php global variable function
PHP
4 votes196 views2 answers
Laravel session forget
PHP Laravel
5 votes178 views6 answers
Laravel 8 auth
PHP Laravel
0 vote190 views1 answer
@lang laravel blade
PHP Laravel
0 vote182 views1 answer
Php mail merge docx document
PHP
4 votes184 views4 answers
Php escape special characters
PHP
67 votes162 views4 answers
Substr php
PHP
-1 vote168 views1 answer
Laravel 7 generator
PHP
0 vote193 views2 answers
View blade not found in laravel
PHP Laravel
13 votes190 views4 answers
Laravel make migration update table
PHP Laravel