/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

7 votes167 views3 answers
Laravel seed migrate
PHP Laravel
62 votes281 views6 answers
Clear cache laravel
PHP Laravel
0 vote142 views1 answer
Null check nested object laravel
PHP Laravel
0 vote136 views1 answer
Laravel notification attach file
PHP Laravel
0 vote182 views5 answers
Download file laravel s3
PHP Laravel
2 votes142 views2 answers
Update laravel 7 to 8
PHP Laravel
4 votes138 views2 answers
Laravel kill current session
PHP Laravel
0 vote146 views1 answer
Getting key from env returns null laravel
PHP Laravel
5 votes136 views3 answers
Crrate model in laravel
PHP Laravel
1 vote143 views1 answer
Laravel server sent events
PHP Laravel