items() as $item) { $item->tags = json_decode($item->tags); array_push($resultSets, $item->toArray()); } return $resultSets; } /** * 根据微信账号ID获取好友列表 * * @param array $where * @return \think\Paginator 分页对象 */ protected function getFriendsByWechatIdAndQueryParams(array $where): \think\Paginator { $query = WechatFriendShipModel::alias('f') ->field( [ 'w.id', 'w.nickname', 'w.avatar', 'w.wechatId', 'CASE WHEN w.alias IS NULL OR w.alias = "" THEN w.wechatId ELSE w.alias END AS wechatAccount', 'f.memo', 'f.tags', 'ff.accountUserName', 'ff.accountRealName','ff.id AS friendId' ] ) ->join('wechat_account w', 'w.wechatId = f.wechatId') ->join(['s2_wechat_friend' => 'ff'], 'ff.id = f.id'); foreach ($where as $key => $value) { if (is_numeric($key) && is_array($value) && isset($value[0]) && $value[0] === 'exp') { $query->whereExp('', $value[1]); continue; } $query->where($key, $value); } return $query->paginate($this->request->param('limit/d', 10), false, ['page' => $this->request->param('page/d', 1)]); } /** * 构建查询条件 * * @param array $params * @return array */ protected function makeWhere(array $params = []): array { // 关键词搜索(同时搜索好友备注和标签) if (!empty($keyword = $this->request->param('keyword'))) { $where[] = ['exp', "f.memo LIKE '%{$keyword}%' OR f.tags LIKE '%{$keyword}%'"]; } $where['f.ownerWechatId'] = $this->request->param('id/s') ?: 'x_x'; return array_merge($where, $params); } /** * 获取微信好友列表 * * @return \think\response\Json */ public function index() { try { $result = $this->getFriendsByWechatIdAndQueryParams( $this->makeWhere() ); return ResponseHelper::success( [ 'list' => $this->makeResultedSet($result), 'total' => $result->total(), ] ); } catch (\Exception $e) { return ResponseHelper::error($e->getMessage(), $e->getCode()); } } }