qimall/addons/ServeBonus/common/models/ServeBonus.php

<?php

namespace addons\ServeBonus\common\models;

use addons\ServeBonus\common\enums\LevelEnum;
use addons\ServeBonus\common\enums\ServeBonusEnum;
use common\enums\StatusEnum;
use common\models\common\Addons;
use common\models\mall\MallAddons;
use common\models\user\User;
use Yii;
use yii\db\Exception;

/**
 * This is the model class for table "qimall_addons_servebonus".
 *
 * @property int $id
 * @property int $mall_id 商城ID
 * @property int $user_id 用户ID
 * @property int $level 服务商等级
 * @property float $commission 累计出单奖励佣金，单位：元
 * @property float $extra_commission 累计加权平分佣金，单位：元
 * @property float $temp_extra_commission 加权平分金额，主要用于判断是否会导致超额
 * @property float $total_commission 累计总佣金，单位：元
 * @property int $upgrade_status 1条件升级，2购买指定商品升级，3手动升级
 * @property int $upgrade_level_at 股东等级升级时间
 * @property int $period_num 已分红期数
 * @property int|null $status 状态[-1:删除;0:禁用;1启用]
 * @property int $created_at 创建时间
 * @property int $updated_at 修改时间
 */
class ServeBonus extends \common\models\base\BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return '{{%addons_servebonus}}';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'user_id', 'level', 'upgrade_status', 'upgrade_level_at', 'period_num', 'status', 'created_at', 'updated_at'], 'integer'],
            [['commission', 'extra_commission', 'temp_extra_commission', 'total_commission'], 'number'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => '商城ID',
            'user_id' => '用户ID',
            'level' => '服务商等级',
            'commission' => '累计出单奖励佣金，单位：元',
            'extra_commission' => '累计加权平分佣金，单位：元',
            'temp_extra_commission' => '加权平分金额，主要用于判断是否会导致超额',
            'total_commission' => '累计总佣金，单位：元',
            'upgrade_status' => '1条件升级，2购买指定商品升级，3手动升级',
            'upgrade_level_at' => '股东等级升级时间',
            'period_num' => '已分红期数',
            'status' => '状态[-1:删除;0:禁用;1启用]',
            'created_at' => '创建时间',
            'updated_at' => '修改时间',
        ];
    }

    public function getUser()
    {
        return $this->hasOne(User::class, ['id' => 'user_id'])->select('id,mobile,nickname,avatar_url,parent_id');
    }
    /**
     * @desc:关联服务商等级
     * @Author: hua
     * @Date: 2021/11/5
     * @Time: 10:04
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @return \yii\db\ActiveQuery
     */
    public function getServeBonusLevel(){
        return $this->hasOne(ServeBonusLevel::class, ['level' => 'level'])->andWhere(['<>','status',StatusEnum::DELETE]);
    }

    /**
     * @Author: ltm
     * @DateTime: 2022/2/11 0011 10:58
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param $data
     * @return string
     */
    public function beforeSave($insert){
        $old_level = $this->getOldAttribute('level');
        if($this->level != $old_level){
            if(!$old_level){ //添加
                $level['level'] = $this->level;
                $level['num'] = 1;
                ServeBonusLevel::statisticsServeBonus($level,[],$this->mall_id);
            }else{
                if($this->level){ //编辑的时候和升级的时候
                    $level['level'] = $this->level;
                    $level['num'] = 1;
                    $last_level['level'] =  $old_level;
                    $last_level['num'] =  1;
                    ServeBonusLevel::statisticsServeBonus($level,$last_level,$this->mall_id);
                }
            }
        }else if($this->status == StatusEnum::DELETE){ //删除的时候统计
            $last_level['level'] =  $old_level;
            $last_level['num'] =  1;
            ServeBonusLevel::statisticsServeBonus('',$last_level,$this->mall_id);
        }
        return parent::beforeSave($insert);
    }


    /**
     * 保存数据
     * @Author: ltm
     * @DateTime: 2021/10/22 0022 17:13
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param array $params
     * @return ServeBonus|bool
     */
    public static function setData(array $params){
        try{
            if(!empty($params['user_id'])){
                $model = self::findOne(['user_id' => $params['user_id'],'mall_id' => $params['mall_id'], 'status' => StatusEnum::ENABLED]);
                if(empty($model)) {
                    $model = new self();
                    $model->loadDefaultValues();
                    $model->mall_id = $params['mall_id'];
                    $model->upgrade_status = LevelEnum::UPGRADE_MANUAL;
                    $model->upgrade_level_at = time();
                }
            } else {
                throw new \Exception('服务商数据不存在或已删除');
            }
            if(!$model->load($params,'') || !$model->save()){
                throw new Exception($model->getErrorMessage());
            }
            return $model;
        }catch(\Exception $e){
            self::setStaticError($e->getMessage());
            return false;
        }
    }


    /**
     * 获取服务商列表
     * @Author: ltm
     * @DateTime: 2021/10/25 0025 10:05
     * @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 getServeBonus(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);
        $data = $query->asArray($is_array)->all();
        return $data;
    }

    /**
     * @desc:推广中心-调用
     * @Author: hua
     * @Date: 2021/11/12
     * @Time: 9:30
     * @Copyright: copyright (c) 2021 广东七件事集团
     * @param $params ['user_id' => 1, 'mall_id' => 5, 'addons_name' => 'Agent']
     * @return array
     */
    public static function getIncomeInfo(array $params){
        $is_install = MallAddons::isInstall($params['mall_id'], $params['addons_name']);
        $data['total_commission'] = 0;
        $data['is_install'] = 0;
        $basic = \Yii::$app->services->setting->addons->get($params['mall_id'], $params['addons_name'], 'basic');
        $data['is_show_at_center'] = 1;
        if(isset($basic['is_show_at_center'])) $data['is_show_at_center'] = $basic['is_show_at_center'];
        if($is_install){
            $model = self::findOne(['user_id'=>$params['user_id']]);
            $data['total_commission'] = $model['total_commission']??0;
            $data['is_install'] = $is_install;
        }
        return $data;
    }
    public static function getAddons(array $params){
        $addons_name = $params['addons_name'];
        $is_install = MallAddons::isInstall($params['mall_id'], $addons_name);
        if($is_install){
            $detail = Addons::getOne([['name' =>$addons_name], ['is_online' => 1]], true,);
            return [
                'addons_name'=>$addons_name,
                'title'=>$detail['title'],
            ];
        }
        return [];
    }
}