request->param(); $page = $params['page'] ?? 1; $limit = $params['limit'] ?? 15; $user_id = $params['user_id'] ?? ''; $name = $params['name'] ?? ''; $role = $params['role'] ?? 0; $query = new UserModel(); if ($role == 0) { $query = $query->where('role', 0); } else { $query = $query->where('role', 3); } if (!empty($user_id)) { $query = $query->where('user_id', $user_id); } if (!empty($name)) { $query = $query->where(function ($query) use ($name) { $query->where('account', 'like', "%{$name}%") ->whereOr('phone', 'like', "%{$name}%") ->whereOr('realname', 'like', "%{$name}%"); }); } $count = $query->count(); $list = $query->order('last_login_time','desc') ->limit($limit) ->page($page) ->select(); foreach($list as &$item) { $item['last_login_time'] = date('Y-m-d H:i:s', $item['last_login_time']); $item['offline_time'] = $item['offline_time'] ? date('Y-m-d H:i:s', $item['offline_time']) : ''; } } catch (Exception $e) { return $this->error($e->getMessage()); } return $this->success(['count' => $count, 'list' => $list]); } //设置用户状态 public function setStatus() { $user_id = (int)$this->request->param('user_id'); $user = UserModel::where('user_id', $user_id)->find(); if (!$user) { return $this->error('用户不存在'); } $user->status = $user->status == 0 ? 1 : 0; $user->save(); return $this->success($user); } //设置用户备注 public function setRemark() { $user_id = (int)$this->request->param('user_id'); $user = UserModel::where('user_id', $user_id)->find(); if (!$user) { return $this->error('用户不存在'); } $remark = $this->request->param('remark'); $user->remark = $remark; $user->save(); return $this->success($user, '保存成功'); } }