/**
* 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]);
}
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 actionIphone6subdownload()
{
$searchModel = new \app\models\MIphone6SubSearch();
$dataProvider = $searchModel->search(Yii::$app->request->get());
$dataProvider->setPagination(false);
$data = $dataProvider->getModels();
//$query = clone $dataProvider->query;
//$data = $query->asArray()->all($dataProvider->db);
//U::W($data);
$filename = Yii::$app->getRuntimePath() . '/iphone6.csv';
$csv = new \app\models\ECSVExport($data);
$csv->toCSV($filename);
Yii::$app->response->sendFile($filename);
return;
}
public function actionVipbind()
{
$in_office = Yii::$app->request->get('in_office', 0);
$rows = Custom::getBindVipCustoms($in_office);
$dataProvider = new ArrayDataProvider(['allModels' => $rows, 'sort' => [], '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() . "/vipbind-{$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('vipbind', ['dataProvider' => $dataProvider]);
}
