qimall/addons/Happiness/agent/controllers/StoreCasherController.php

<?php

namespace addons\Happiness\agent\controllers;

use addons\Coupon\common\enums\AddonsCouponEnum;
use addons\Coupon\common\models\AddonsCoupon;
use addons\Happiness\common\models\HappinessCashierOrder;
use addons\Happiness\common\models\HappinessStore;
use addons\Happiness\common\models\HappinessStoreMiniCode;
use addons\Happiness\common\models\HappinessWithdrawLog;
use common\components\export\CsvTool;
use common\enums\AddonsEnum;
use common\enums\StatusEnum;
use common\helpers\csv\CsvExportHelper;
use common\helpers\MiniQrCode;
use common\models\common\CapitalLog;
use common\models\mall\MallAddons;
use common\models\order\OrderDetail;
use common\models\user\User;
use common\models\user\UserLevel;

class StoreCasherController extends BaseController
{

    public function actionIndex()
    {
        if (\Yii::$app->request->isAjax) {
            if (\Yii::$app->request->isGet) {
                $params = \Yii::$app->request->get();
                $where[] = ['mall_id' => $this->mall_id];
                $where[] = ['pay_status' => 1];
                $where[] = ['status' => StatusEnum::ENABLED];
                if (!empty($params['keyword'])) {
                    $user_list = User::lists(['where' => [['mall_id' => $this->mall_id], [
                        'or',
                        ['like', 'username', $params['keyword']],
                        ['like', 'nickname', $params['keyword']],
                    ]], 'select' => 'id']);
                    $user_ids = array_column($user_list, 'id');
                    $where[] = ['in', 'user_id', $user_ids];
                }
                if (!empty($params['start'])) $where[] = ['>=', 'pay_time', strtotime($params['start'])];
                if (!empty($params['end'])) $where[] = ['<=', 'pay_time', strtotime($params['end'])];
                if (!empty($params['min'])) $where[] = ['>=', 'pay_money', $params['min']];
                if (!empty($params['max'])) $where[] = ['<=', 'pay_money', $params['max']];
                $params['where'] = $where;
                $params['order'] = 'id desc';
                $params['with'] = ['user', 'detail'];
                $params['limit'] = $params['limit'] ?? $this->pageSize;
                $page_data = HappinessCashierOrder::listPage($params);
                if ($page_data === false) return $this->error(HappinessWithdrawLog::getStaticError());
                if (!empty($page_data['list'])) {
                    $store_ids = array_column($page_data['list'], 'store_id');
                    $store_list = HappinessStore::lists([
                        'where' => [
                            ['id' => $store_ids]
                        ],
                        'index' => 'id'
                    ]);
                    foreach ($page_data['list'] as &$item) {
                        $item['extra'] = '';
                        $item['commission'] = 0;
                        $item['store_name'] = $store_list[$item['store_id']]['store_name']??'';

                    }
                }
                $page_data['export_list'] = HappinessCashierOrder::fieldsList(true);
                return $this->success('ok', $page_data);
            }

        }
        if (\Yii::$app->request->post('flag') == 'EXPORT') {
            $params = \Yii::$app->request->post();
            $params['mall_id'] = $this->mall_id;
            $filename = '幸福小店收银订单列表-' . date('YmdHis') . '_' . rand(10000, 99999);
            $model = HappinessCashierOrder::find();
            $model->where(['mall_id' => $params['mall_id']]);
            $model->andWhere(['pay_status' => 1]);
            if (!empty($params['start'])) $model->andWhere(['>=', 'pay_time', strtotime($params['start'])]);
            if (!empty($params['end'])) $model->andWhere(['<=', 'pay_time', strtotime($params['end'])]);
            if (!empty($params['min'])) $model->andWhere(['>=', 'pay_money', $params['min']]);
            if (!empty($params['max'])) $model->andWhere(['<=', 'pay_money', $params['max']]);
            if (!empty($params['keyword'])) {
                $user_list = User::lists(['where' => [['mall_id' => $params['mall_id']], [
                    'or',
                    ['like', 'username', $params['keyword']],
                    ['like', 'nickname', $params['keyword']],
                ]], 'select' => 'id']);
                $user_ids = array_column($user_list, 'id');
                $model->andWhere(['in', 'user_id', $user_ids]);
            }
            $model->with(['user']);
            $fields = $params['fields'];
            $fields = explode(',', $fields);
            $fields_arr = HappinessCashierOrder::fieldsList(true);
            $have_select_field_arr = [];
            foreach ($fields as $value) {
                $have_select_field_arr[] = $fields_arr[$value];
            }
            $csv = new CsvTool();
            $csv->filename = $filename;
            $csv->export_mode = CsvTool::EXPORT_MODE_SYNC;
            $csv->header = $have_select_field_arr;
            $orders = $model->all();
            empty($csv->header) && $csv->header = array_keys($orders[0]);
            $data = [];
            $store_ids = array_column($orders, 'store_id');
            $store_list = HappinessStore::lists([
                'where' => [
                    ['id' => $store_ids]
                ],
                'index' => 'id'
            ]);
            foreach ($orders as $order) {
                $row = [];
                foreach ($fields as $field) {
                    if ($field == 'nickname') {
                        $row[] = $order['user']['nickname'];
                    }
                    else if ($field == 'pay_time') {
                        $row[] = !empty($order['pay_time']) ? date('Y-m-d H:i:s', $order['pay_time']) : '';
                    } else if($field=='store_name'){
                        $row[] = $store_list[$order['store_id']]['store_name']?? '';
                    }else {
                        if ((isset($order[$field]))) $row[] = $order[$field];
                    }
                }
                $data[] = $row;
            }
            $csv->data = $data;
            $csv->export();
        }
        return $this->render($this->action->id);

    }

    public function actionCommissionAndScoreList()
    {
        $params = \Yii::$app->request->get();
        $wallet_type = 'commission';
        if (!empty($params['wallet_type'])) $wallet_type = $params['wallet_type'];
        $condition = [
            'where' => [
                ['source_table' => ['store_cashier_order',StoreCashierOrder::tableName(),'store_cashier_order_detail']],
                ['source_table_id' => $params['order_id']]
            ],
        ];
        CapitalLog::$capitalType = "{$wallet_type}";
        $list = CapitalLog::getList($condition, 0);
        $level = UserLevel::find()->select("name,level")->where(['mall_id' => $this->mall_id, 'status' => StatusEnum::ENABLED])->asArray()->all();
        $level_data = array_column($level, 'name', 'level');
        CapitalLog::$capitalType = "{$wallet_type}_frozen";
        $condition['where'][] = ['status' => 0];
        $frozen_list = CapitalLog::getList($condition, 1);
        $list = array_merge($list, $frozen_list);
        return $this->success('操作成功', ['list' => $list, 'user_level' => $level_data]);

    }


    public function actionGetCouponList()
    {
        $params = \Yii::$app->request->get();
        $type = $params['type'] ?? 2;
        $store_id = $this->store_id;

        $is_install = MallAddons::isInstall($this->mall_id, AddonsEnum::ADDONS_NAME_COUPON);
        $coupon_list = [];
        if ($is_install) {
            $coupon_list = AddonsCoupon::lists([
                'where' => [
                    ['store_id' => $store_id],
                    ['type' => $type],
                    ['status' => StatusEnum::ENABLED],
                    ['coupon_status' => AddonsCouponEnum::STATUS_RECEIVING],
                ],
                'select' => 'id,name'
            ]);
        }
        return $this->success('ok', ['coupon_list' => $coupon_list]);
    }

    public function actionShowMiniPromotionCode()
    {
        $request = \Yii::$app->request;
        if ($request->isAjax) {
            if ($request->isPost) {
                $params = \Yii::$app->request->post();
                // 检查提交的参数
                $res = \Yii::$app->services->validate->validate($params, [
                    [['type'], 'required'],
                ]);
                if ($res === false) return $this->error(\Yii::$app->services->validate->getErrorMessage());
                $store = HappinessStore::findOne(['mall_id' => $this->mall_id, 'id' => $this->store_id]);
                if (empty($store)) return $this->error('店铺不存在');
                $model = StoreMiniCode::findOne(['store_id' => $store['id'], 'mall_id' => $this->mall_id, 'type' => $params['type']]);
                if (empty($model)) {
                    $mall = $this->mall;
                    $content = [
                        'mall_id' => $this->mall_id,
                        'store_id' => $store['id'],
                        'mall_sign' => $mall['mall_sign'],
                        'type' => $params['type'],
                    ];
                    $content = json_encode($content);
                    if ($params['type'] == 1) {
                        $page = 'plugins2/Store/store/index';
                    } else {
                        $page = '/plugins2/Store/pay/cashRegister';
                    }
                    $code = md5($content);
                    $obj = new MiniQrCode();
                    $applet_code = $obj->getAppletQrCode($this->mall_id, $page, $code);
                    $params['mall_id'] = $this->mall_id;
                    $params['code'] = $code;
                    $params['store_id'] = $store['id'];
                    $params['content'] = $content;
                    $params['applet_code'] = $applet_code;
                    $model = StoreMiniCode::setData($params);
                }
                $applet_url = $model['applet_code'];
                $this->success('获取成功', ['applet_url' => $applet_url]);
            }
        }
    }

}