qimall/console/migrations/M240814092348AddSellingPriceStatisticsColumn.php

<?php

namespace app\migrations;

use yii\db\Migration;

/**
 * Class M240814092348AddSellingPriceStatisticsColumn
 */
class M240814092348AddSellingPriceStatisticsColumn extends Migration
{
    /**
     * 新增售价总额（包含已支付未支付）（个人及直推、团队、间推）
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
ALTER TABLE `qimall_user_statistics` 
ADD COLUMN `pay_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已支付的订单售价总额（商品价格）',
ADD COLUMN `finish_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已完成的订单售价总额（商品价格）';

ALTER TABLE `qimall_user_statistics_total` 
ADD COLUMN `pay_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已支付的订单售价总额（商品价格）',
ADD COLUMN `finish_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已完成的订单售价总额（商品价格）';

ALTER TABLE `qimall_user_team_statistics` 
ADD COLUMN `user_direct_pay_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已支付的订单售价总额（商品价格）',
ADD COLUMN `user_direct_finish_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已完成的订单售价总额（商品价格）',
ADD COLUMN `user_indirect_pay_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已支付的订单售价总额（商品价格）',
ADD COLUMN `user_indirect_finish_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已完成的订单售价总额（商品价格）',
ADD COLUMN `team_pay_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '团队已支付的订单售价总额（商品价格）',
ADD COLUMN `team_finish_selling_price` decimal(10, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '团队已完成的订单售价总额（商品价格）';
SQL;
        $this->execute($sql);
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        return false;
    }

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

    }

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

        return false;
    }
    */
}