/PHP/Laravel/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 vote165 views1 answer
Laravel token logout
PHP Laravel
13 votes170 views6 answers
How to create model in laravel
PHP Laravel
10 votes153 views2 answers
ForeignId in laravel
PHP Laravel
16 votes152 views3 answers
Laravel request validate
PHP Laravel
45 votes202 views6 answers
Laravel migration add column after
PHP Laravel
0 vote101 views2 answers
Laravel restrict home route access
PHP Laravel
37 votes181 views6 answers
Laravel create or update
PHP Laravel
0 vote152 views2 answers
How to rollback if one table in laravel didn't save data successfully
PHP Laravel
53 votes317 views6 answers
Check laravel version
PHP Laravel
0 vote143 views1 answer
Country code validation in laravel
PHP Laravel