/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

2 votes268 views4 answers
Foreach in laravel
PHP Laravel
0 vote291 views1 answer
Check for headers laravel
PHP Laravel
0 vote332 views1 answer
Laravel command Retrieve a specific option
PHP Laravel
5 votes297 views3 answers
Laravel model limit
PHP Laravel
-1 vote319 views1 answer
Chrome web driver laravel
PHP Laravel
3 votes281 views1 answer
Check file size validation laravel
PHP Laravel
0 vote292 views3 answers
Method put laravel
PHP Laravel
0 vote268 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
26 votes328 views6 answers
Laravel model with migration
PHP Laravel
0 vote319 views1 answer
Laravel get all vendor files
PHP Laravel