/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

1 vote314 views2 answers
Laravel check if object empty
PHP
2 votes336 views3 answers
Laravel subdays
PHP Laravel
0 vote380 views1 answer
Ubuntu 7.2 deleted php
PHP
0 vote392 views1 answer
Access-control-allow-origin php laravel
PHP Laravel
3 votes347 views2 answers
Laravel check if query builder is empty
PHP
0 vote347 views1 answer
Install phpredis MAC OSX
PHP
3 votes357 views3 answers
Insert timestamps manually in laravel
PHP Laravel
0 vote422 views1 answer
Blade Keep input values after failed validation
PHP
0 vote336 views1 answer
Laravel datatable columnDefs
PHP Laravel
0 vote352 views1 answer
Laravel 8 date difference in days
PHP