input('page_index'); $page_size=$request->input('page_size'); $num=$page_size*($page_index-1); $search_name=$request->input('search_name'); $data=User::where(function($query){ $query->whereNotNull('phone') ->orWhereNotNull('openId'); }); if($search_name){ $data->where(function($query)use($search_name){ $query->where('phone','like','%'.$search_name.'%') ->orWhere('nickname','like','%'.$search_name.'%'); }); } $count=$data->count(); $list=$data->orderBy('id','desc')->skip($num)->take($page_size)->get(); return $this->success_list($list,'成功',$count); } //导出用户列表 public function export(Request $request){ $search_name=$request->input('search_name'); $data=User::where(function($query){ $query->whereNotNull('phone') ->orWhereNotNull('openId'); }); if($search_name){ $data->where(function($query)use($search_name){ $query->where('phone','like','%'.$search_name.'%') ->orWhere('nickname','like','%'.$search_name.'%'); }); } $list=$data->orderBy('id','desc')->get(); return $this->success($list); } //禁用 | 启用 用户 public function disabled(Request $request){ $user=User::where('id',$request->input('id'))->first(); $user->status = $user->status ? 0 : 1; $res=$user->save(); if($res){ return $this->success([]); }else{ return $this->error(); } } }