2018-11-08

 public function getQueryList()
    {
        $data = $this->request->param();
        if (empty($data['page'])) {
            $data['page'] = 1;
        }
        if (empty($data['num'])) {
            $data['num'] = 10;
        }
        $where = [
            'query_from' => 0
        ];
        $subQuery = Db::name('query_list')->fetchSql()->field('openid, COUNT(*) as query_times')->where($where)->group('openid')->select();
        $where = [];
        if (isset($data['status'])) {
            $where['status'] = $data['status'];
        }
        if (isset($data['like'])) {
            $where['idCard|name|companyAccount|account|company'] = ['like', '%' . $data['like'] . '%'];
        }
        if (isset($data['date'])) {
            $where['update_time'] = [['>=', $data['date'][0]], ['<=', ($data['date'][1]) + 86400]];
        }

        $queryList = Db::name('gjj')->alias('gjj')
            ->join('('. $subQuery . ') query', 'gjj.openid = query.openid')
            ->field('gjj.*, query_times')->order('id', 'desc')->where($where)->page($data['page'], $data['num'])->select();
        $count = Db::name('gjj')->where($where)->count();
        return json([
            'code' => 1,
            'data' => $queryList,
            'count' => $count,
        ]);
    }