rf3main/addons/Wechat/merchant/controllers/QrcodeStatController.php

<?php

namespace addons\Wechat\merchant\controllers;

use Yii;
use yii\data\Pagination;
use common\traits\MerchantCurd;
use common\helpers\ExcelHelper;
use addons\Wechat\common\models\QrcodeStat;
use addons\Wechat\common\enums\QrcodeStatTypeEnum;

/**
 * 微信二维码统计
 *
 * Class QrcodeStatController
 * @package addons\Wechat\merchant\controllers
 * @author jianyan74 <751393839@qq.com>
 */
class QrcodeStatController extends BaseController
{
    use MerchantCurd;

    /**
     * @var QrcodeStat
     */
    public $modelClass = QrcodeStat::class;

    /**
     * 首页
     */
    public function actionIndex()
    {
        $request = Yii::$app->request;
        $type = $request->get('type', '');
        $keyword = $request->get('keyword', '');
        $from_date = $request->get('from_date', date('Y-m-d', strtotime("-60 day")));
        $to_date = $request->get('to_date', date('Y-m-d', strtotime("+1 day")));

        $data = QrcodeStat::find()
            ->where(['merchant_id' => $this->getMerchantId()])
            ->andFilterWhere(['like', 'name', $keyword])
            ->andFilterWhere(['type' => $type])
            ->andFilterWhere(['between', 'created_at', strtotime($from_date), strtotime($to_date)]);

        $attention_data = clone $data;
        $scan_data = clone $data;

        $pages = new Pagination(['totalCount' => $data->count(), 'pageSize' => $this->pageSize]);
        $models = $data->offset($pages->offset)
            ->orderBy('id desc')
            ->limit($pages->limit)
            ->all();

        // 关注统计
        $attention_count = $attention_data
            ->andWhere(['type' => QrcodeStatTypeEnum::ATTENTION])
            ->count();
        // 扫描统计
        $scan_count = $scan_data
            ->andWhere(['type' => QrcodeStatTypeEnum::SCAN])
            ->count();

        return $this->render('index', [
            'models' => $models,
            'pages' => $pages,
            'type' => $type,
            'attention_count' => $attention_count,
            'scan_count' => $scan_count,
            'keyword' => $keyword,
            'from_date' => $from_date,
            'to_date' => $to_date,
        ]);
    }

    /**
     * 导出
     *
     * @throws \PhpOffice\PhpSpreadsheet\Exception
     * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
     */
    public function actionExport()
    {
        $request = Yii::$app->request;
        $from_date = $request->get('from_date');
        $to_date = $request->get('to_date');

        $dataList = QrcodeStat::find()
            ->where(['between', 'created_at', strtotime($from_date), strtotime($to_date)])
            ->andWhere(['merchant_id' => $this->getMerchantId()])
            ->andFilterWhere(['type' => $request->get('type')])
            ->andFilterWhere(['like', 'name', $request->get('keyword')])
            ->orderBy('created_at desc')
            ->with('fans')
            ->asArray()
            ->all();

        $header = [
            ['ID', 'id'],
            ['场景名称', 'name'],
            ['openid', 'fans.openid'],
            ['昵称', 'fans.nickname'],
            ['场景值', 'scene_str'],
            ['场景ID', 'scene_id'],
            ['关注/扫描', 'type', 'selectd', ['' => '全部', '1' => '关注', '2' => '扫描']],
            ['创建时间', 'created_at', 'date', 'Y-m-d H:i:s'],
        ];

        // 导出Excel
        return ExcelHelper::exportData($dataList, $header, '扫描统计_' . time());
    }
}