public function actionOfficetopbyrange() { $cur_date = Yii::$app->request->get('cur_date'); if (empty($cur_date)) { $date_start = Yii::$app->request->get('date_start', date("Y-m-d", strtotime("-1 day"))); $date_end = Yii::$app->request->get('date_end', date("Y-m-d", strtotime("-1 day"))); } else { $date_start = $cur_date; $date_end = $cur_date; } $rows = MOffice::getOfficeScoreTopByRange(Yii::$app->user->getGhid(), $date_start, $date_end); $filter = new \app\models\FiltersForm(); $filter->unsetAttributes(); if (isset($_GET['FiltersForm'])) { $filter->setAttributes($_GET['FiltersForm'], false); } $rows = $filter->filterArrayData($rows); $dataProvider = new ArrayDataProvider(['allModels' => $rows, 'sort' => ['attributes' => ['office_id', 'title', 'cnt_office', 'cnt_staffs', 'cnt_sum'], 'defaultOrder' => ['cnt_sum' => SORT_DESC]], 'pagination' => ['pageSize' => 50]]); if (isset($_GET['download'])) { $data = $rows; \yii\helpers\ArrayHelper::multisort($data, 'cnt_sum', SORT_DESC); $date = date('Y-m-d-His'); $filename = Yii::$app->getRuntimePath() . "/Officetopbyrange-{$date}.csv"; $csv = new \app\models\ECSVExport($data); $attributes = ['office_id', 'scene_id', 'title', 'is_jingxiaoshang', 'cnt_office', 'cnt_staffs', 'cnt_sum']; $csv->setInclude($attributes); $csv->setHeaders(['office_id' => '营业厅ID', 'scene_id' => '推广码ID', 'title' => '名称', 'is_jingxiaoshang' => '类别', 'cnt_office' => '部门推广人数', 'cnt_staffs' => '部门员工推广人数', 'cnt_sum' => '合计推广人数']); $csv->toCSV($filename); Yii::$app->response->sendFile($filename); return; } return $this->render('officetopbyrange', ['dataProvider' => $dataProvider, 'cur_date' => $cur_date, 'date_start' => $date_start, 'date_end' => $date_end, 'filter' => $filter]); }