/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

9 votes190 views3 answers
Show all validation errors in laravel's blade view
PHP Laravel
0 vote131 views1 answer
Laravel valet refresh env
PHP Laravel
0 vote152 views1 answer
Payment gateway webhook returning 302 laravel
PHP Laravel
2 votes92 views2 answers
Laravel dump
PHP Laravel
0 vote161 views1 answer
Laravel import data from csv
PHP Laravel
0 vote150 views2 answers
How change default value for enum colun in laravel
PHP Laravel
0 vote172 views1 answer
Laravel 8 created at format
PHP Laravel
2 votes158 views3 answers
How to change the colum type in migration laravel
PHP Laravel
1 vote129 views1 answer
Laravel doesNotHave in model
PHP Laravel
0 vote96 views1 answer
How convert the string to int in laravel function event
PHP Laravel