/** * Lists all MHd201509t6 models. * @return mixed */ public function actionIndex() { $searchModel = new MHd201509t6Search(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); if (isset($_GET['download'])) { $dataProvider->setPagination(false); $data = $dataProvider->getModels(); $date = date('Y-m-d-His'); $filename = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'zqshfhd' . "-{$date}.csv"; $rowsx = []; foreach ($data as $row) { $rows = []; $rows["mobile"] = $row->mobile; $rows["yfzx"] = $row->yfzx; $rows["fsc"] = $row->fsc; $rows["create_time"] = $row->create_time; $rows["hbme"] = $row->hbme; //$rows["status"] = $row->status; if ($row->status == 0) { $rows["status"] = "未领"; } else { $rows["status"] = "已领"; } $rows["qdbm"] = $row->qdbm; $qd = MQdbm::findOne(["qdbm" => $row->qdbm]); if (empty($qd)) { $rows["gsyf"] = "--"; $rows["qdmc"] = "--"; } else { $rows["gsyf"] = $qd->gsyf; $rows["qdmc"] = $qd->qdmc; } $rowsx[] = $rows; } //$csv = new \app\models\ECSVExport($data); $csv = new \app\models\ECSVExport($rowsx); $attributes = ['mobile', 'yfzx', 'fsc', 'hbme', 'create_time', 'hbme', 'status', 'qdbm', 'gsyf', 'qdmc']; $csv->setInclude($attributes); //$csv->setHeaders(['Score'=>'成绩']); //mobile yfzx fsc create_time status qdbm gsyf qdmc $csv->setHeaders(['mobile' => '手机', 'yfzx' => '营服中心', 'fsc' => '分市场', 'create_time' => '时间', 'hbme' => '红包(元)', 'status' => '领取状态', 'qdbm' => '渠道编码', 'gsyf' => '归属营服', 'qdmc' => '渠道名称']); $csv->toCSV($filename); Yii::$app->response->sendFile($filename); return; } return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }
/** * Lists all MHd201509t2 models. * @return mixed */ public function actionIndex() { $searchModel = new MHd201509t2Search(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); if (isset($_GET['download'])) { $dataProvider->setPagination(false); $data = $dataProvider->getModels(); $date = date('Y-m-d-His'); $filename = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . 'chfshf' . "-{$date}.csv"; $csv = new \app\models\ECSVExport($data); $attributes = ['mobile', 'yfzx', 'fsc', 'create_time', 'status']; $csv->setInclude($attributes); //$csv->setHeaders(['Score'=>'成绩']); $csv->toCSV($filename); Yii::$app->response->sendFile($filename); return; } return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }
/** * Lists all Custom models. * @return mixed */ public function actionIndex() { $searchModel = new CustomSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); if (isset($_GET['download'])) { $dataProvider->setPagination(false); $data = $dataProvider->getModels(); $date = date('Y-m-d-His'); $filename = Yii::$app->getRuntimePath() . DIRECTORY_SEPARATOR . $this->id . "-{$date}.csv"; $csv = new \app\models\ECSVExport($data); $attributes = ['mobile', 'name', 'user.nickname', 'user.create_time', 'office.title', 'is_vip', 'vipLevel.title']; $csv->setInclude($attributes); $csv->setHeaders(['User Nickname' => '微信昵称', 'VIP' => '是否VIP', 'User Create Time' => '关注时间', 'title' => 'VIP级别']); $csv->toCSV($filename); Yii::$app->response->sendFile($filename); return; } return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]); }
public function actionIndex() { $searchModel = new MUserSearch(); $dataProvider = $searchModel->search(Yii::$app->request->get()); if (isset($_GET['download'])) { if ($dataProvider->getTotalCount() > 10000) { //return 'abc'; } $dataProvider->setPagination(false); $data = $dataProvider->getModels(); $date = date('Y-m-d-His'); $filename = Yii::$app->getRuntimePath() . "/user-{$date}.csv"; $csv = new \app\models\ECSVExport($data); $attributes = ['nickname', 'bindMobileNumbersStr', 'create_time', 'sceneStaff.name', 'sceneStaff.office.title']; $csv->setInclude($attributes); $csv->setHeaders(['Nickname' => '微信昵称', 'Bind Mobile Numbers Str' => '绑定手机号', 'Create Time' => '关注时间']); $csv->toCSV($filename); Yii::$app->response->sendFile($filename); return; } return $this->render('index', ['dataProvider' => $dataProvider, 'searchModel' => $searchModel]); }
public function actionHeatmapsdownload() { $searchModel = new HeatMapSearch(); $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $dataProvider->setPagination(false); $data = $dataProvider->getModels(); $rows = []; foreach ($data as $model) { $row['openid'] = $model->openid; $row['nickname'] = $model->user->nickname; $staff = MStaff::findOne(['gh_id' => $model->gh_id, 'scene_id' => $model->user->scene_pid]); if ($staff->cat == 0) { $row['scene_pid_name'] = empty($staff->name) ? '' : $staff->name; $row['scene_pid_office'] = empty($staff->office->title) ? '' : $staff->office->title; $row['scene_pid_cat'] = '内部员工'; } else { $row['scene_pid_name'] = empty($staff->name) ? '' : $staff->name; $row['scene_pid_office'] = '-'; $row['scene_pid_cat'] = '-'; } //$row['user_account_charge_mobile'] = $model->user->user_account_charge_mobile; if (empty($model->user)) { //return ''; $row['user_account_charge_mobile'] = ''; } else { $mobiles = $model->user->getBindMobileNumbers(); //return empty($mobiles) ? '' : implode(',', $mobiles); $row['user_account_charge_mobile'] = empty($mobiles) ? '' : implode(',', $mobiles); } $row['create_time'] = $model->create_time; if ($model->status == 0) { $row['status'] = '有效'; } else { $row['status'] = '无效'; } $rows[] = $row; } $data = $rows; $filename = Yii::$app->getRuntimePath() . '/heatmaps.csv'; $csv = new \app\models\ECSVExport($data); $attributes = ['openid', 'nickname', 'scene_pid_name', 'scene_pid_office', 'scene_pid_cat', 'user_account_charge_mobile', 'create_time', 'status']; $csv->setInclude($attributes); $csv->setHeaders(['openid' => 'openid', 'nickname' => '昵称', 'scene_pid_name' => '粉丝来源', 'scene_pid_office' => '粉丝来源所属部门', 'scene_pid_cat' => '粉丝来源类别', 'user_account_charge_mobile' => '手机号码', 'create_time' => '创建时间', 'status' => '是否有效']); $csv->toCSV($filename); Yii::$app->response->sendFile($filename); return; }
public function actionOfficetopbymonth($month) { $rows = MOffice::getOfficeScoreTopByMonth(Yii::$app->user->getGhid(), $month); $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() . "/Officetopbymonth-{$month}.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('officetopbymonth', ['dataProvider' => $dataProvider, 'month' => $month, 'filter' => $filter]); }