qimall/common/models/user/UserTeamPayMoneyStatistics.php

<?php

namespace common\models\user;

use common\enums\OrderStatusEnum;
use common\enums\RabbitMqEnum;
use common\enums\StatusEnum;
use common\models\order\Order;
use common\models\order\OrderDetail;
use Yii;

/**
 * This is the model class for table "qimall_user_team_pay_money_statistics".
 *
 * @property int $id ID
 * @property int $mall_id 商城ID
 * @property int $user_id 用户ID
 * @property float $pay_team 总团队实付业绩[订单支付]
 * @property float $accomplish_team 总团队实付业绩[订单完成]
 * @property float $pay_big_market 大市场实付业绩[订单支付]
 * @property float $accomplish_big_market 大市场实付业绩[订单完成]
 * @property float $pay_user 用户实付业绩[订单支付]
 * @property float $accomplish_user 用户实付业绩[订单完成]
 * @property int $status 状态[-1删除; 0禁用; 1正常]
 * @property int $created_at 创建时间
 * @property int $updated_at 更新时间
 */
class UserTeamPayMoneyStatistics extends \common\models\base\BaseActiveRecord
{
    /**
     * {@inheritdoc}
     */
    public static function tableName()
    {
        return 'qimall_user_team_pay_money_statistics';
    }

    /**
     * {@inheritdoc}
     */
    public function rules()
    {
        return [
            [['mall_id', 'user_id', 'status', 'created_at', 'updated_at'], 'integer'],
            [['pay_team', 'accomplish_team', 'pay_big_market', 'accomplish_big_market', 'pay_user', 'accomplish_user'], 'number'],
        ];
    }

    /**
     * {@inheritdoc}
     */
    public function attributeLabels()
    {
        return [
            'id' => 'ID',
            'mall_id' => '商城ID',
            'user_id' => '用户ID',
            'pay_team' => '总团队实付业绩[订单支付]',
            'accomplish_team' => '总团队实付业绩[订单完成]',
            'pay_big_market' => '大市场实付业绩[订单支付]',
            'accomplish_big_market' => '大市场实付业绩[订单完成]',
            'pay_user' => '用户实付业绩[订单支付]',
            'accomplish_user' => '用户实付业绩[订单完成]',
            'status' => '状态[-1删除; 0禁用; 1正常]',
            'created_at' => '创建时间',
            'updated_at' => '更新时间',
        ];
    }
    public static function setData(array $data)
    {
        try {
            $model = self::findOne(['user_id' => $data['user_id'], 'status' => StatusEnum::ENABLED]);
            if (empty($model)) {
                $model = new self();
                $model->loadDefaultValues();
            }
            if (!$model->load($data, '') || !$model->save()) {
                throw new \Exception($model->getErrorMessage());
            }
            return $model;
        } catch (\Exception $e) {
            self::setStaticError($e->getMessage());
            return false;
        }
    }

    public static function calculatePerformance($params)
    {
        $mall_id= $params['mall_id'];
        $uid    = $params['user_id'];
        $order_id = $params['order_id'];
        try {
            $parent_id_arr = UserPartitionRelationship::getParentIdArr($uid);
            $parent_id_arr[] = $uid;
            foreach ($parent_id_arr as $user_id) {
                $user_id_arr = UserPartitionRelationship::getChildIdArr($user_id);
                $pay_team_performance = 0;
                $accomplish_team_performance = 0;
                if (!empty($user_id_arr)) {
                    $pay_team_performance = self::computeGoodsPerformance($user_id_arr, ['order_status' => [OrderStatusEnum::PAY, OrderStatusEnum::SHIPMENTS, OrderStatusEnum::SING, OrderStatusEnum::ACCOMPLISH, OrderStatusEnum::TAKE, OrderStatusEnum::TAKE_FINISH]]);
                    $accomplish_team_performance =  self::computeGoodsPerformance($user_id_arr, ['order_status' => OrderStatusEnum::ACCOMPLISH]);
                }

                $pay_user_performance = self::computeGoodsPerformance($user_id, ['order_status' => [OrderStatusEnum::PAY, OrderStatusEnum::SHIPMENTS, OrderStatusEnum::SING, OrderStatusEnum::ACCOMPLISH]]);
                $accomplish_user_performance = self::computeGoodsPerformance($user_id, ['order_status' => [OrderStatusEnum::ACCOMPLISH]]);

                $direct_user_id_arr = UserPartitionRelationship::getChildIdArr($user_id, 1);

                $pay_big_market_performance = 0;
                $accomplish_big_market_performance = 0;
                if (!empty($direct_user_id_arr)) {
                    $pay_performance_arr = [];
                    $accomplish_performance_arr = [];
                    foreach ($direct_user_id_arr as $id) {
                        $child_id_arr = UserPartitionRelationship::getChildIdArr($id);
                        $child_id_arr[] = $id;
                        $pay_performance_arr[] = self::computeGoodsPerformance($child_id_arr, ['order_status' => [OrderStatusEnum::PAY, OrderStatusEnum::SHIPMENTS, OrderStatusEnum::SING, OrderStatusEnum::ACCOMPLISH, OrderStatusEnum::TAKE, OrderStatusEnum::TAKE_FINISH]]);
                        $accomplish_performance_arr[] = self::computeGoodsPerformance($child_id_arr, ['order_status' => [OrderStatusEnum::ACCOMPLISH]]);
                    }
                    $pay_big_market_performance = max($pay_performance_arr);
                    $accomplish_big_market_performance = max($accomplish_performance_arr);
                }
                if (self::setData([
                    'mall_id' => $mall_id,
                    'user_id' => $user_id,
                    'pay_team' => $pay_team_performance > 0 ? $pay_team_performance : 0,
                    'accomplish_team' => $accomplish_team_performance > 0 ? $accomplish_team_performance : 0,
                    'pay_big_market' => $pay_big_market_performance > 0 ? $pay_big_market_performance : 0,
                    'accomplish_big_market' => $accomplish_big_market_performance > 0 ? $accomplish_big_market_performance : 0,
                    'pay_user' => $pay_user_performance > 0 ? $pay_user_performance : 0,
                    'accomplish_user' => $accomplish_user_performance > 0 ? $accomplish_user_performance : 0,
                ]) === false) {
                    throw new \Exception(self::getStaticError());
                }
            }
            if (isset($params['is_refund']) && $params['is_refund']) return true;
            //再次执行会员升级任务
            //\Yii::$app->services->rabbitMq->push(RabbitMqEnum::EXCHANGE_ORDER, RabbitMqEnum::ORDER_QUEUE, ['id' => $order_id], \common\listeners\user\UserUpgradeListener::class, 'handleSync');

            return true;
        } catch (\Exception $e) {
            \Yii::error(__METHOD__ . ' ' . json_encode(['msg' => $e->getMessage(), 'line' => $e->getLine()]));
            self::setStaticError($e->getMessage());
            return false;
        }
    }

    public static function computeGoodsPerformance($user_id, $andwhere)
    {
        $pay_money = Order::find()
            ->where(['user_id' => $user_id, 'status' => StatusEnum::ENABLED])
            ->andWhere($andwhere)
            ->sum('pay_money');
        return $pay_money ?? 0;
    }
}