qimall/console/migrations/M240903034626AlertClumnDecimal10ToDecimal12.php

<?php

namespace app\migrations;

use common\models\statistics\BaseUserTeamStatistics;
use yii\db\Migration;

/**
 * Class M240903034626AlertClumnDecimal10ToDecimal12
 */
class M240903034626AlertClumnDecimal10ToDecimal12 extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = <<<SQL
ALTER TABLE `qimall_user_achievement_statistics` 
MODIFY COLUMN `pay_selling_price` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '已支付的订单售价总额（商品价格）',
MODIFY COLUMN `finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已完成的订单售价总额（商品价格）',
MODIFY COLUMN `user_goods_price_total` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '已支付的业绩';

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

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

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

ALTER TABLE `qimall_user_team_statistics` 
MODIFY COLUMN `user_direct_pay_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已支付的订单售价总额（商品价格）',
MODIFY COLUMN `user_direct_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已完成的订单售价总额（商品价格）',
MODIFY COLUMN `user_indirect_pay_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已支付的订单售价总额（商品价格）',
MODIFY COLUMN `user_indirect_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已完成的订单售价总额（商品价格）',
MODIFY COLUMN `team_pay_selling_price` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '团队已支付的订单售价总额（商品价格）',
MODIFY COLUMN `team_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '团队已完成的订单售价总额（商品价格）';

ALTER TABLE `qimall_user_team_achievement_statistics` 
MODIFY COLUMN `user_direct_pay_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已支付的订单售价总额（商品价格）',
MODIFY COLUMN `user_direct_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已完成的订单售价总额（商品价格）',
MODIFY COLUMN `user_indirect_pay_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已支付的订单售价总额（商品价格）',
MODIFY COLUMN `user_indirect_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已完成的订单售价总额（商品价格）',
MODIFY COLUMN `team_pay_selling_price` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '团队已支付的订单售价总额（商品价格）',
MODIFY COLUMN `team_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '团队已完成的订单售价总额（商品价格）',
MODIFY COLUMN `team_goods_price_total` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '团队已支付的业绩（不包含运费，不包含本人）';
SQL;

        $dateAchievementModifyColumnBaseSql = <<<SQL
ALTER TABLE `qimall_user_team_date_achievement_statistics_%d` 
MODIFY COLUMN `user_direct_pay_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已支付的订单售价总额（商品价格）',
MODIFY COLUMN `user_direct_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '直推已完成的订单售价总额（商品价格）',
MODIFY COLUMN `user_indirect_pay_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已支付的订单售价总额（商品价格）',
MODIFY COLUMN `user_indirect_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '间推已完成的订单售价总额（商品价格）',
MODIFY COLUMN `team_goods_price_total` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '群组总业绩（不包含运费）（不包含自己）',
MODIFY COLUMN `team_pay_selling_price` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '群组产品总额（不包含自己）',
MODIFY COLUMN `team_finish_selling_price` decimal(12, 2) UNSIGNED NOT NULL DEFAULT 0.00 COMMENT '团队已完成的订单售价总额（商品价格）';
SQL;
        for ($i = 1; $i <= BaseUserTeamStatistics::TABLE_NUM; $i++) {
            $sql .= sprintf($dateAchievementModifyColumnBaseSql, $i);
        }

        $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 "M240903034626AlertClumnDecimal10ToDecimal12 cannot be reverted.\n";

        return false;
    }
    */
}