/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

14 votes172 views6 answers
Laravel Password Validation
PHP Laravel
0 vote204 views1 answer
Laravel unique funcation
PHP Laravel
0 vote184 views1 answer
Laravel on cascade set null
PHP Laravel
0 vote163 views2 answers
Where () laravel Eloquent
PHP Laravel
4 votes174 views3 answers
Laravel 8 check if null or empty
PHP Laravel
0 vote176 views1 answer
Laravel Add regx on password
PHP Laravel
1 vote225 views1 answer
?? ' ' operator in php laravel
PHP Laravel
0 vote162 views1 answer
Was loaded over https, but requested an insecure xmlhttprequest endpoint laravel
PHP Laravel
0 vote164 views1 answer
Laravel view not created using foreign keys
PHP Laravel
0 vote209 views1 answer
Get the last saved row in a table laravel
PHP Laravel