whereLike('nickname', "%{$params['nickname']}%"); isset($params['mobile']) && filled($params['mobile']) && $user->whereLike('mobile', "%{$params['mobile']}%"); // isset($params['status']) && filled($params['status']) && $user->where('status', $params['status']); !empty($params['loginDate']) && $user->whereBetween('login_date', $params['loginDate']); !empty($params['createTime']) && $user->whereBetween('created_at', $params['createTime']); $rolePage = $user->select([...$this->selectColumn, ...$this->appendColumn])->paginate($params['pageSize'], ['*'], 'page', $params['pageNo']); return ['list' => $rolePage->items(), 'total' => $rolePage->total()]; } public function getUser($id) { return User::query()->select($this->selectColumn)->find($id); } }