setAttributes($params); // 初始化DataTable查询参数 $this->initSearchParams(); $pagination = new Pagination(); $pagination->setPageSize($this->pageSize); $data['pageSize'] = $pagination->getPageSize(); $data['page'] = $this->page; if ($this->orderBy) { $data['orderBy'] = $this->orderBy; } if (!empty($this->search['value']) && trim($this->search['value']) !== '') { $data['search'] = trim($this->search['value']); } $data['member_id'] = \Yii::$app->getUser()->getId(); if ($this->pageSize > 1000) { if (\Yii::$app->getRequest()->isAjax) { \Yii::$app->getResponse()->redirect(Url::current()); } else { $this->exportXls($data); } \Yii::$app->end(); } $api = new OpenApi(); $result = $api->getOpenList($data); $models = []; if ($result['code'] == 1) { $models = (array)$result['data']['dataList']; $pagination->totalCount = (int)$result['data']['totalCount']; } $dataProvider = new ArrayDataProvider([ 'models' => $models, 'pagination' => $pagination, 'totalCount' => $pagination->totalCount, ]); return $dataProvider; } /** * @param $data */ private function exportXls($data) { \Yii::$app->getResponse()->setDownloadHeaders("开户申请记录_" . date('Y-m-d') . '.xls')->send(); if (!ob_get_level()) { ob_start(); } echo ''; echo ''; echo ''; $api = new OpenApi(); $leftSize = $this->pageSize; while ($leftSize > 0) { // 重新计算页数和分页大小 start $pageSize = $leftSize > 1000 ? 1000 : $leftSize; $data['pageSize'] = $pageSize; $data['page'] = ceil($this->start / $pageSize) + 1; // 重新计算页数和分页大小 end $result = $api->getOpenList($data); if ($result['code'] == 1 && $result['data']['dataList']) { foreach ((array)$result['data']['dataList'] as $key => $row) { $str = ''; $str .= ""; if ((int)$row['type'] == 0) { $str .= ""; } elseif ((int)$row['type'] == 1) { $str .= ""; } elseif ((int)$row['type'] == 2) { $str .= ""; } else { $str .= ""; } $str .= ""; $str .= ""; $str .= ""; $str .= ""; $str .= ""; $str .= ""; echo $str; } ob_flush(); flush(); } else { break; } $this->start += $pageSize; $leftSize -= $pageSize; if ($this->start >= $result['data']['totalCount']) { break; } } echo "

ID	状态	姓名	邮箱	手机	推广ID	申请时间
{$row['id']}	等待	处理中	完成	拒绝	{$row['name']}	{$row['email']}	{$row['mobile']}	{$row['rid']}	".date('Y-m-d H:i:s', intval($row['in_time'] / 1000))."

"; if (ob_get_level()) { ob_end_flush(); } } }