qimall/console/migrations/M250811085140AlterQimallUserTeamProfitStatistics.php

<?php

namespace app\migrations;

use common\enums\RabbitMqEnum;
use common\models\user\UserTeamProfitStatistics;
use yii\db\Migration;

/**
 * Class M250811085140AlterQimallUserTeamProfitStatistics
 */
class M250811085140AlterQimallUserTeamProfitStatistics extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "ALTER TABLE `qimall_user_team_profit_statistics` 
        ADD COLUMN `children_order_pay_achievement` decimal(16, 2) NOT NULL DEFAULT '0' COMMENT '下级团队订单支付总金额（实付金额）（不包含自己）',
        ADD COLUMN `team_order_pay_achievement` decimal(16, 2) NOT NULL DEFAULT '0' COMMENT '团队订单支付总金额（实付金额）（包含自己）',
        ADD COLUMN `children_order_finish_achievement` decimal(16, 2) NOT NULL DEFAULT '0' COMMENT '下级团队订单完成总金额（实付金额）（不包含自己）',
        ADD COLUMN `team_order_finish_achievement` decimal(16, 2) NOT NULL DEFAULT '0' COMMENT '团队订单完成总金额（实付金额）（包含自己）';";
        $this->execute($sql);

        //处理累计历史订单实付金额数据
        // \Yii::$app->services->rabbitMq->push(RabbitMqEnum::EXCHANGE_LONG_DURATION, RabbitMqEnum::LONG_DURATION_QUEUE,
        //             ['type' => 1], UserTeamProfitStatistics::class, 'cumulativeOrderAchievement');
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        echo "M250811085140AlterQimallUserTeamProfitStatistics cannot be reverted.\n";

        return false;
    }

    /*
    // Use up()/down() to run migration code without a transaction.
    public function up()
    {

    }

    public function down()
    {
        echo "M250811085140AlterQimallUserTeamProfitStatistics cannot be reverted.\n";

        return false;
    }
    */
}