qimall/addons/Agent/console/migrations/M240102095541AgentRewardUpdate.php

<?php

namespace addons\Agent\console\migrations;

use yii\db\Migration;

/**
 * Class M240102095541AgentRewardUpdate
 */
class M240102095541AgentRewardUpdate extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('diff_parent', '极差平均分红(上级代理)', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
        INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('diff_area_commission', '极差平均分红(区域代理)', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
        INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('diff_user', '极差平均分红(指定用户)', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');
        INSERT INTO `qimall_global_var_map` (`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('equal_upgrade', '平级代理分红', 'CapitalTypeMap', '0', '1', '1654569888', '1654569888');";
        $this->execute($sql);

        $sql = "ALTER TABLE `qimall_addons_agent_commission_item_setting`
            ADD COLUMN `is_equal_by_upgrade`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启代理平级奖励 0 否 1 是',
            ADD COLUMN `is_self_buy_alone`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启经销内购独立设置 0 否 1 是',
            ADD COLUMN `is_self_buy`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启经销内购 0 否 1 是',
            ADD COLUMN `enable_goods_deduct`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否开启商品抵扣 0 否 1 是';";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}