讨论数量:
$data = User::when($request->name, function ($query) use ($request) {
return $query->whereName($request->name);
})
->when($request->job, function ($query) use ($request) {
return $query->whereJob($request->job);
})
->get();
hhh,我是搬运工。
这就很简单啦!举个例子~ 比如你把对应的查询条件按照键值对应关系放在一个数组中
public function getUserCollection($where){
$user = $this->model;
if(count($where)){
$user = $user->where(function ($query) use ($where) {
foreach($where as $key => $value){
if($key=='你需要查询的字段'){
$query->where($key,$value);
}
}
});
}
}
推荐文章: