Laravel具有多个值的过滤器

本文介绍了Laravel具有多个值的过滤器的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

当尝试仅使用用户名或电子邮件代码进行过滤时效果很好.但是当我尝试同时使用电子邮件和用户名进行过滤时，它将返回空值.

When trying to filter with only username or email code works fine.But when i am trying to filter with both email and username it returns empty.what i am missing

用户模型

public function scopeEmail($query, $email) { $query->where('email','=', $email); } public function scopeUsername($query, $username) { $query->where('username','=', $username); }

控制器:

public function filter(Request $request) { $q = User::query(); $email = $request->input('email'); $username= $request->input('username'); if (isset($email)) { // simple where here or another scope, whatever you like $q->Email($request->input('email')); } if (isset($username)) { $q->Username($request->input('username')); } //execute $results = $q->get(); return response()->json(['issError'=>0, 'errorCode'=>0,'message'=>$results],200); }

推荐答案

使用何时简化过滤器:

public function filter(Request $request) { $q = User::query(); $email = $request->input('email'); $username= $request->input('username'); $q->when($email,function ($query){ $query->where('email',$email); }); $q->when($username,function ($query){ $query->where('username',$username); }); $results = $q->get(); return response()->json(['issError'=>0, 'errorCode'=>0,'message'=>$results],200); }