qimall/addons/CardSecret/backend/controllers/CardSecretUseController.php

<?php

namespace addons\CardSecret\backend\controllers;

use addons\CardSecret\common\models\CardSecret;
use addons\CardSecret\common\models\CardSecretUse;
use addons\CardSecret\common\models\Cate;
use common\enums\StatusEnum;
use common\models\user\User;
use Yii;
use common\controllers\AddonsController;
use yii\db\Exception;
use yii\helpers\Json;

/**
 * 默认控制器
 *
 * Class DefaultController
 * @package addons\CardSecret\backend\controllers
 */
class CardSecretUseController extends BaseController
{
    public $enableCsrfValidation = false;
    /**
    * 首页
    *
    * @return string
    */
    public function actionIndex()
    {
        $retuest = Yii::$app->request;
        if ($retuest->isAjax) {
            if ($retuest->isGet) {
                $get = Yii::$app->request->get();
                // 检查提交的参数
                $res = Yii::$app->services->validate->validate($get,[
                    [['user_id','mobile','cate_id','user_keyword','name','use_status','create_time'], 'safe'],
                    [['limit'],'default','value' => '15'],
                ]);
                if($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());
                $where = [];
                if (!empty($get['user_keyword'])) {
                    $user_ids = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'mobile', $get['user_keyword'] . '%', false])->asArray()->column();
                    $user_name = User::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'nickname', $get['user_keyword'] . '%', false])->asArray()->column();
                    $user_ids = $user_ids + $user_name;
                    if (empty($user_ids)) $this->success('查无此用户');
                    $where[] = ['in', 'user_id', $user_ids];
                }
                if($get['create_time']) $where[] = ['between', 'created_at', strtotime($get['create_time'][0]),strtotime($get['create_time'][1])];
                $with = ['user','cate','cardSecret'];
                if(!empty($get['name'])) {
                    $card_ids = CardSecret::find()->select("id")->where(['mall_id' => $this->mall_id])->andWhere(['like', 'name', $get['name'] . '%', false])->asArray()->column();
                    $where[] = ['in', 'card_secret_id', $card_ids];
                }
                if(!empty($get['use_status'])) $where[] = ['=', 'use_status', $get['use_status']];
                if(!empty($get['user_id'])) $where[] = ['=', 'user_id', $get['user_id']];
                if(!empty($get['cate_id'])) $where[] = ['=', 'cate_id', $get['cate_id']];
                $where[] = ['=', 'mall_id', $this->mall_id];
                $where[] = ['>=', 'status', StatusEnum::DISABLED];
                $order = 'id desc';
                $params = array('where' => $where,'with' => $with, 'order'=>$order, 'limit' => $get['limit']);
                $list = CardSecretUse::listPage($params, false, true);
                //获取分类
                $list['cate'] = Cate::getCateMap(1,$this->mall_id);
                $this->success('获取成功', $list);
            }
        } else {
            return $this->render($this->action->id);
        }
    }
    /**
     * 等级编辑
     * @Author: ltm
     * @DateTime: 2021/10/21 0021 11:29
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @return mixed|string|void
     */
    public function actionEdit()
    {
        try {
            $request = Yii::$app->request;
            if ($request->isAjax) {
                // 提交等级内容
                if ($request->isPost) {
                    $params = Yii::$app->request->post();
                    $res = Yii::$app->services->validate->validate($params, [
                        [['name','id','status'], 'safe'],
                    ]);
                    if ($res === false) return $this->error(Yii::$app->services->validate->getErrorMessage());
                    $params = Cate::exceptNullVal($params);
                    if(!empty($params['id'])) $params['updated_at'] = time();//更新
                    $params['create_at'] = time();
                    if(!$params['name']) unset($params['name']);
                    $params['mall_id'] = $this->mall_id;
                    if(isset($params['status']) && !in_array($params['status'],[StatusEnum::DISABLED,StatusEnum::ENABLED,StatusEnum::DELETE])) throw new Exception("参数错误");;
                    $res = Cate::setData($params);
                    if ($res === false) throw new Exception(MaterialCate::getStaticError());
                    return $this->success('操作成功');
                }
            }
        } catch (\Exception $e) {
            return $this->error($e->getMessage(), []);
        }
        return $this->render($this->action->id);
    }
}