qimall/addons/Agent/common/models/AgentLevel.php

<?php

namespace addons\Agent\common\models;

use addons\Agent\common\enums\AgentEnum;
use common\enums\StatusEnum;
use common\models\base\BaseActiveRecord;
use Yii;

/**
 * This is the model class for table "qimall_addons_agent_level".
 *
 * @property int $id
 * @property int $mall_id 商城ID
 * @property int $level
 * @property string $name 等级名称
 * @property int $is_auto_upgrade 是否开启自动升级
 * @property int $upgrade_type_condition 是否开启条件升级
 * @property string $checked_condition_values 升级条件
 * @property string $checked_condition_keys 升级条件选中的key集合
 * @property int $condition_type 0 未选择、1满足其一  2、满足所有
 * @property int $upgrade_type_goods 购买升级商品,0关闭，1开启
 * @property int $buy_goods_type 购买升级商品触发升级:0订单完成 1下单完成
 * @property int $goods_type 商品升级类型，1- 任意商品 2- 指定商品
 * @property string $goods_ids 商品id集合
 * @property string $goods_list 商品列表json
 * @property string $explain 等级说明
 * @property int $status 状态[-1:删除;0:禁用;1启用]
 * @property int $created_at
 * @property int $updated_at
 * @property int $upgrade_type_store_goods    购买门店商品升级,0关闭，1开启
 * @property int $buy_store_goods_type  购买门店商品触发升级:0订单完成 1下单完成
 * @property int $store_goods_type 门店商品升级类型，1- 任意商品 2- 指定商品
 * @property int $store_goods_ids 门店商品id集合
 * @property int $store_goods_list 门店商品集合
 * @property int $is_custom_condition_num 是否自定义升级商品条件数量
 */
class AgentLevel extends BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_agent_level}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'checked_condition_values'], 'required'],
            [['mall_id', 'level', 'is_auto_upgrade', 'upgrade_type_condition', 'condition_type', 'upgrade_type_goods',
                'buy_goods_type', 'goods_type', 'status', 'created_at', 'updated_at','is_open_equal_settle_type','equal_settle_type', 'is_custom_condition_num'], 'integer'],
            [['checked_condition_values'], 'string'],
            [['name'], 'string', 'max' => 45],
            [['checked_condition_keys'], 'string', 'max' => 1000],
            [['goods_ids'], 'string', 'max' => 3000],
            [['goods_list', 'explain'], 'string'],
            [['upgrade_type_store_goods','buy_store_goods_type','store_goods_type'],'integer'],
            [['store_goods_ids','store_goods_list'],'string']
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => '商城ID',
            'level' => 'Level',
            'name' => '等级名称',
            'is_auto_upgrade' => '是否开启自动升级',
            'upgrade_type_condition' => '是否开启条件升级',
            'checked_condition_values' => '升级条件',
            'checked_condition_keys' => '升级条件选中的key集合',
            'condition_type' => '0 未选择、1满足其一  2、满足所有',
            'upgrade_type_goods' => '购买升级商品,0关闭，1开启',
            'buy_goods_type' => '购买升级商品触发升级:0订单完成 1下单完成',
            'goods_type' => '商品升级类型，1- 任意商品 2- 指定商品',
            'goods_ids' => '商品id集合',
            'goods_list' => '商品列表json',
            'explain' => '等级说明',
            'status' => '状态[-1:删除;0:禁用;1启用]',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
            'is_custom_condition_num' => '是否自定义升级商品条件数量',
        ];
    }

    /**关联模型 */
    // 分类关系
    public function getCommissionLevelSetting()
    {
        return $this->hasOne(AgentCommissionLevelSetting::class, ['level' => 'level']);
    }
    public function getCommissionLevelSettingList()
    {
        return $this->hasMany(AgentCommissionLevelSetting::class, ['level' => 'level']);
    }

    /**
     * @desc:保存数据
     * @Author: hua
     * @Date: 2021/10/20
     * @Time: 15:46
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param array $params
     * @return AgentLevel|false|null
     * @throws \Exception
     */
    public static function setData(array $params)
    {
        $t = \Yii::$app->db->beginTransaction();
        try {
            if(!empty($params['id'])){
                $model = self::findOne(['mall_id' => $params['mall_id'], 'id' => $params['id'], 'status' => [StatusEnum::ENABLED, StatusEnum::DISABLED]]);
                if (empty($model)) throw new \Exception('服务不存在或已删除');
            }else{
                $model = new self();
                $model->loadDefaultValues();
            }
            if (!$model->load($params, '')) throw new \Exception($model->getErrorMessage());
            if (empty($params['checked_condition_keys'])) $params['checked_condition_keys'] = [];
            if (empty($params['checked_condition_values'])) $params['checked_condition_values'] = [];
            if (empty($params['goods_ids'])) $params['goods_ids'] = [];
            if (empty($params['goods_list'])) $params['goods_list'] = [];
            if (empty($params['store_goods_ids'])) $params['store_goods_ids'] = [];
            if (empty($params['store_goods_list'])) $params['store_goods_list'] = [];

            $model->checked_condition_keys = json_encode($params['checked_condition_keys'], JSON_NUMERIC_CHECK);
            $model->checked_condition_values = json_encode($params['checked_condition_values'], JSON_NUMERIC_CHECK);
            $model->goods_ids = json_encode($params['goods_ids'], JSON_NUMERIC_CHECK);
            $model->goods_list = json_encode($params['goods_list'], JSON_NUMERIC_CHECK);
            $model->store_goods_ids = json_encode($params['store_goods_ids'], JSON_NUMERIC_CHECK);
            $model->store_goods_list = json_encode($params['store_goods_list'], JSON_NUMERIC_CHECK);
            $status = 1;
            if (!$model->save()) throw new \Exception($model->getErrorMessage());
            if (isset($params['score']) && !empty($params['commission'])) {
                $params['from_type'] = AgentEnum::ADDONS_NAME;

                //  积分
                $params['commission_type'] = 'score';
                unset($params['score']['level']);
                $params = array_merge($params,$params['score']);
                $params['status'] = $status;
                if(!empty($params['alone_agent_equal_prize_info'])){
                    $params['alone_agent_equal_prize_info'] = json_encode($params['alone_agent_equal_prize_info']);
                }else{
                    $params['alone_agent_equal_prize_info'] = "";
                }
                if(!empty($params['repurchase_subsidy_condition'])){
                    $params['repurchase_subsidy_condition'] = json_encode($params['repurchase_subsidy_condition']);
                }else{
                    $params['repurchase_subsidy_condition'] = "";
                }
                $res = AgentCommissionLevelSetting::setData($params);
                if (!$res) throw new \Exception(AgentCommissionLevelSetting::getStaticError());

                //  佣金
                $params['commission_type'] = 'commission';
                unset($params['commission']['level']);
                $params = array_merge($params,$params['commission']);
                $params['status'] = $status;
                if(!empty($params['alone_agent_equal_prize_info'])){
                    $params['alone_agent_equal_prize_info'] = json_encode($params['alone_agent_equal_prize_info']);
                }else{
                    $params['alone_agent_equal_prize_info'] = "";
                }
                if(!empty($params['repurchase_subsidy_condition'])){
                    $params['repurchase_subsidy_condition'] = json_encode($params['repurchase_subsidy_condition']);
                }else{
                    $params['repurchase_subsidy_condition'] = "";
                }
                $res = AgentCommissionLevelSetting::setData($params);
                if (!$res) throw new \Exception(AgentCommissionLevelSetting::getStaticError());

                //  金币
                $params['commission_type'] = 'digital';
                unset($params['digital']['level']);
                $params = array_merge($params,$params['digital']);
                $params['status'] = $status;
                if(!empty($params['alone_agent_equal_prize_info'])){
                    $params['alone_agent_equal_prize_info'] = json_encode($params['alone_agent_equal_prize_info']);
                }else{
                    $params['alone_agent_equal_prize_info'] = "";
                }
                if(!empty($params['repurchase_subsidy_condition'])){
                    $params['repurchase_subsidy_condition'] = json_encode($params['repurchase_subsidy_condition']);
                }else{
                    $params['repurchase_subsidy_condition'] = "";
                }
                $res = AgentCommissionLevelSetting::setData($params);
                if (!$res) throw new \Exception(AgentCommissionLevelSetting::getStaticError());

                //  额外积分
                if (!empty($params['additional_score'])) {
                    $params['commission_type'] = 'additional_score';
                    unset($params['additional_score']['level']);
                    $params = array_merge($params,$params['additional_score']);
                    $params['status'] = $status;
                    if(!empty($params['alone_agent_equal_prize_info'])){
                        $params['alone_agent_equal_prize_info'] = json_encode($params['alone_agent_equal_prize_info']);
                    }else{
                        $params['alone_agent_equal_prize_info'] = "";
                    }
                    if(!empty($params['repurchase_subsidy_condition'])){
                        $params['repurchase_subsidy_condition'] = json_encode($params['repurchase_subsidy_condition']);
                    }else{
                        $params['repurchase_subsidy_condition'] = "";
                    }
                    $res = AgentCommissionLevelSetting::setData($params);
                    if (!$res) throw new \Exception(AgentCommissionLevelSetting::getStaticError());
                }
            }
            $t->commit();
            return $model;
        } catch (\Exception $e) {
            $t->rollBack();
            self::$static_error = $e->getMessage();
            return false;
        }
    }

    /**
     * @desc:条件升级数据源使用
     * @Author: hua
     * @Date: 2021/10/20
     * @Time: 9:54
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param $params
     * @return array
     */
    public static function getAgentListByUpgrade($params)
    {
        $rows = [];
        if (!empty($params['mall_id'])) {
            $where = ['mall_id' => $params['mall_id'], 'status' => StatusEnum::ENABLED];
            $list = self::findAll($where);
            foreach ($list as $v) {
                $rows[] = ['level' => $v['level'], 'name' => $v['name']];
            }
        }
        return $rows;
    }

    /**
     * @desc:等级和权重
     * @Author: hua
     * @Date: 2021/10/20
     * @Time: 16:08
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param $mall_id
     * @return array
     */
    public static function getLevelWeights($mall_id)
    {
        $list = self::find()->select('level')->where(['status' => [StatusEnum::DISABLED, StatusEnum::ENABLED], 'mall_id' => $mall_id])->column();
        $newList = [];
        for ($i = 1; $i <= 10; $i++) {
            $newList[] = [
                'name' => '等级' . $i,
                'level' => $i,
                'disabled' => in_array($i, $list),
            ];
        }
//        array_unshift($newList, [
//            'name' => "默认等级",
//            'level' => 0,
//            'disabled' => true,
//        ]);
        return $newList;
    }

    /**
     * @desc:获取经销商等级列表
     * @Author: hua
     * @Date: 2021/10/26
     * @Time: 14:52
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param array $cond
     * @param array $with
     * @param bool $is_array
     * @param string $select
     * @return array|\yii\db\ActiveRecord[]
     */
    public static function getLevelList(array $cond = [], array $with = [], bool $is_array = true, string $select = '*')
    {
        $default_cond = [['<>', 'status', StatusEnum::DELETE]];
        $cond = array_merge($default_cond, $cond);
        $query = self::find()->select($select);
        self::paramPack(['where' => $cond, 'with' => $with], $query);
        return $query->asArray($is_array)->all();
    }

    public static function del($params){
        try{
            $model = self::findOne(['id'=>$params['id']]);
            if(!empty($model)){
                $res = Agent::findOne(['level'=>$model->level,'mall_id'=>$params['mall_id'],'status'=>[StatusEnum::ENABLED,StatusEnum::DISABLED]]);
                if(!empty($res))  throw new \Exception('该等级关联了经销商');
                $model->status = StatusEnum::DELETE;
                $res = $model->save();
                if($res==false)  throw new \Exception($model->getErrorMessage());
                $params['level'] = $model->level;
                $res =  AgentCommissionLevelSetting::del($params);
                if($res==false)  throw new \Exception(AgentCommissionLevelSetting::getStaticError());
            }
            return true;
        }catch (\Exception $e){
            self::$static_error = $e->getMessage();
            return false;
        }
    }

    /**
     * 获取等级
     * @Author: lun
     * @DateTime: 2021/12/16 0016 9:17
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param $mall_id
     * @return array
     */
    public static function getLevelByColumn($mall_id){
        return self::find()
            ->select('name')
            ->where(array('mall_id'=>$mall_id,'status'=>StatusEnum::ENABLED))
            ->asArray()
            ->indexBy('level')
            ->orderBy('level desc')
            ->column();
    }

    public static function getLevelCheckbox($params)
    {
        $rows = [];
        if (!empty($params['mall_id'])) {
            $rows = self::find()->where(['mall_id' => $params['mall_id']])
                ->andWhere(['status' => StatusEnum::ENABLED])
                ->select('level as value, name as label')->asArray()->all();
        }
        return $rows;
    }
}