qimall/addons/Achievement/console/migrations/M250603104636AlterTableAchievementAduit.php

<?php

namespace addons\Achievement\console\migrations;

use yii\db\Migration;

/**
 * 添加团长列表是否手动创建字段
 * Class M250505104636AlterTableAchievementUser
 */
class M250603104636AlterTableAchievementAduit extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            $sql =<<<SQL
            ALTER TABLE `qimall_addons_achievement_grant_log` 
            ADD COLUMN `is_award_need_confirm` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启业绩审核确认模式：0否 1是',
            ADD COLUMN `is_leader_first_month_no_award` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否首月成为团长不发放结算金额：0否 1是';

            ALTER TABLE `qimall_addons_achievement_award_log` 
            ADD COLUMN `is_skip_settlement` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否不结算：0否 1是' AFTER `is_settlement`;

            CREATE TABLE `qimall_addons_achievement_grant_confirm_log` (
              `id` int(11) NOT NULL AUTO_INCREMENT,
              `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
              `grant_id` int(11) NOT NULL DEFAULT '0' COMMENT '规则id',
              `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员id',
              `created_at` int(11) NOT NULL DEFAULT '0',
              `updated_at` int(11) NOT NULL DEFAULT '0',
              `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
              PRIMARY KEY (`id`) USING BTREE,
              KEY `idx_mall_grant` (`mall_id`, `grant_id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='结算业绩审核日志';

            CREATE TABLE `qimall_addons_achievement_award_log_update_log` (
              `id` int(11) NOT NULL AUTO_INCREMENT,
              `mall_id` int(11) NOT NULL DEFAULT '0',
              `grant_id` int(11) NOT NULL DEFAULT '0' COMMENT '发放规则日志id',
              `award_id` int(11) NOT NULL DEFAULT '0' COMMENT '奖励明细id',
              `before_award_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '修改前奖励金额', 
              `after_award_money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '修改后奖励金额', 
              `created_at` int(11) NOT NULL DEFAULT '0',
              `updated_at` int(11) NOT NULL DEFAULT '0',
              `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
              PRIMARY KEY (`id`) USING BTREE,
              KEY `idx_mall_grant` (`mall_id`, `grant_id`, `award_id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='奖励明细更新日志';
SQL;
            $this->execute($sql);
        }catch (\Exception $e) {
            \Yii::error($e->getMessage());
        }
    }

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

        return false;
    }

}