qimall/addons/CloudStock/common/models/CloudStockLevel.php

<?php

namespace addons\CloudStock\common\models;

use common\enums\StatusEnum;
use common\models\base\BaseActiveRecord;
use Yii;

/**
 * This is the model class for table "{{%addons_cloud_stock_level".
 *
 * @property int $id
 * @property int $mall_id 商城id
 * @property int $level 等级权重id
 * @property string $name 等级名称
 * @property string|null $checked_condition_values 升级条件
 * @property string|null $checked_condition_keys 升级条件选中的key集合
 * @property int $condition_type 0 未选择、1满足其一  2、满足所有
 * @property int $upgrade_type_condition 是否开启条件升级
 * @property int $is_over 超越奖励
 * @property int $is_equal 平级
 * @property int $is_fill 补货
 * @property string|null $give_quota json;赠送等级配置
 * @property string $explain 等级说明
 * @property int $status 状态[-1:删除;0:禁用;1启用]
 * @property int $created_at
 * @property int $updated_at
 * @property int $is_open_fill_min
 * @property int $fill_min
 */
class CloudStockLevel extends BaseActiveRecord
{
    private static $levels = [];

    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_cloud_stock_level}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'name'], 'required'],
            [['mall_id', 'level', 'condition_type', 'upgrade_type_condition', 'is_over', 'is_equal', 'is_fill', 'status', 'created_at', 'updated_at','is_open_fill_min','fill_min','is_open_fill_min_once','fill_min_once','fill_max_once', 'upgrade_type_goods', 'upgrade_type_store_goods'], 'integer'],
            [['checked_condition_values', 'checked_condition_keys', 'give_quota', 'upgrade_goods_list', 'upgrade_store_goods_list'], 'string'],
            [['name'], 'string', 'max' => 255],
            [['explain'], 'string', 'max' => 5000],
            [['detail'], 'safe'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => '商城id',
            'level' => '等级权重id',
            'name' => '等级名称',
            'checked_condition_values' => '升级条件',
            'checked_condition_keys' => '升级条件选中的key集合',
            'condition_type' => '0 未选择、1满足其一  2、满足所有',
            'upgrade_type_condition' => '是否开启条件升级',
            'is_over' => '超越奖励',
            'is_equal' => '平级',
            'is_fill' => '补货',
            'give_quota' => 'json;赠送等级配置',
            'explain' => '等级说明',
            'status' => '状态[-1:删除;0:禁用;1启用]',
            'created_at' => 'Created At',
            'updated_at' => 'Updated At',
            'is_open_fill_min' => '代理进货数量限制',
            'fill_min' => '最低补货数量',
            'is_open_fill_min_once' => '代理一次性提货数量限制',
            'fill_min_once' => '一次性提货最低数量',
            'fill_max_once' => '一次性提货最高数量',
            'upgrade_type_goods' => '是否开启购买商品升级',
            'upgrade_goods_list' => '商品升级条件',
            'upgrade_type_store_goods' => '是否开启购买门店商品升级',
            'upgrade_store_goods_list' => '门店商品升级条件',
        ];
    }

    public static function setData(array $params)
    {
        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('服务不存在或已删除');
                if($params['status']==StatusEnum::DELETE){
                    $res = CloudStockAgent::findOne(['mall_id'=> $params['mall_id'],'level'=>$model->level,'status'=>[StatusEnum::ENABLED,StatusEnum::DISABLED]]);
                    if($res) throw new \Exception('该等级关联了代理商');
                }
            }else{
                $model = new self();
                $model->loadDefaultValues();
            }
            if (!$model->load($params, '')) throw new \Exception($model->getErrorMessage());
            if (!$model->save()) throw new \Exception($model->getErrorMessage());

            return $model;
        } catch (\Exception $e) {

            self::$static_error = $e->getMessage();
            return false;
        }
    }

    /**
     * @name:
     * @msg: 获取云库存代理商等级列表
     * @param {int} $mall_id 商城id
     * @param {int} $level 等级
     * @return array
     */
    public static function getLevelList(int $mall_id, int $level = null) : array
    {
        if (!empty(self::$levels)) return self::$levels;
        $levels = self::find()
            ->select('id,mall_id,level,name as level_name,give_quota,created_at')
            ->where(['mall_id' => $mall_id, 'status' => StatusEnum::ENABLED])
            ->orderBy('level asc')
            ->asArray()
            ->indexBy('level')
            ->all();
        if (empty($levels)) return [];
        self::$levels = $levels;
        if ($level !== null) {
            $levels = $levels[$level] ?? [];
        }
        return $levels;
    }

    /**
     * @name:
     * @msg: 获取特定等级设置代理商的名额配置
     * @param {int} $mall_id 商城 id
     * @param {int} $level 等级
     * @return int
     */
    public static function getGiveQuota(int $mall_id, int $level, int $user_id) : int
    {
        $give_quota = CloudStockAgentQuota::find()
            ->select('id,mall_id,user_id,level,num,status')
            ->where(['mall_id' => $mall_id, 'status' => StatusEnum::ENABLED, 'level' => $level, 'user_id' => $user_id])
            ->asArray()
            ->one();
        if (empty($give_quota)) {
            $number = 0;
        } else {
            $number = $give_quota['num'];
        }
        return $number;
    }
    public static function getMap($mall_id)
    {
        $data = [];
        $list = self::find()->select('level,name')->where(['mall_id' => $mall_id, 'status' => [StatusEnum::ENABLED,StatusEnum::DISABLED]])->orderBy('level asc')->asArray()->all();
        if ($list) {
            foreach ($list as $item) {
                $data[$item['level']] = $item['name'];
            }
        }
        return $data;
    }

    public static function getListByUpgrade($params)
    {
        $rows = [];
        if (!empty($params['mall_id'])) {
            $where = ['mall_id' => $params['mall_id'], 'status' => StatusEnum::ENABLED];
            $list = self::find()->where($where)->orderBy('level asc')->all();
            foreach ($list as $v) {
                $rows[] = ['level' => $v['level'], 'name' => $v['name']];
            }
        }
        return $rows;
    }
}