qimall/console/migrations/M210909073847CreateQimallGlobalVarMap.php

<?php

namespace app\migrations;

use yii\db\Migration;


/**
 * Class M220909073847CreateQimallGlobalVarMap
 */
class M210909073847CreateQimallGlobalVarMap extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $table = 'qimall_global_var_map';
        $check_table_sql="select * from information_schema.TABLES where TABLE_NAME = '{$table}';";
        $res = $this->db->createCommand($check_table_sql)->execute();
        if(!empty($res)) return '';

        // 创建表
        $this->createTable($table, [
            'id' => $this->primaryKey(),
            'name' => $this->string(50)->notNull()->defaultValue('')->comment('标识'),
            'title' => $this->string(50)->notNull()->defaultValue('')->comment('中文标识'),
            'type' => $this->string(50)->notNull()->defaultValue('')->comment('类型'),
            'is_addons' => $this->tinyInteger(2)->notNull()->defaultValue(0)->comment('是否是插件[0:否,1:是]'),
            'status' => $this->tinyInteger(1)->notNull()->defaultValue(1)->comment('状态[-1:删除;0:禁用;1启用]'),
            'created_at' => $this->integer(10)->notNull()->defaultValue(0)->comment('添加时间'),
            'updated_at' => $this->integer(10)->notNull()->defaultValue(0)->comment('修改时间'),

        ]);
        $this->addCommentOnTable($table,'枚举类表');

        // 插入表数据
        $sql = "INSERT INTO `qimall_global_var_map`(`name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ";
        $sql .= "('consume', '消费', 'FromTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('recharge', '充值', 'FromTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('transfer', '转送', 'FromTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('refund', '退款', 'FromTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('reward', '奖励', 'FromTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('consume_order', '商城订单消费抵扣', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('consume_order_close', '订单关闭', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('consume_order_give', '订单支付赠送', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('refund_order', '订单退款', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('transfer_balance', '转入到余额', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('recharge_platform', '后台充值', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('balance_transfer', '余额转出', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('transfer_give', '转送', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('first', '直推奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('second', '间推奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('third', '分销奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('team', '渠道奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('extra', '额外奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('equal', '平级奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('over', '越级奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('withdrawal_balance_transfer', '提现余额转积分', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('withdrawal_commission_transfer', '提现佣金转积分', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('give', '赠送奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('deduct', '扣除', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('signin', '签到奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('user_coupon_give', '优惠券使用赠送', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('register', '注册', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('short_video_reward', '短视频观看奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('short_video_goods', '短视频观看奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('user_recharge', '会员充值', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('fill', '补货', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('bouns', '分红', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('attend_reward', '参团奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('win_reward', '拼中奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('recommend', '推荐奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('withdrawal', '提现', 'FromTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('watch_reward', '观看奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('browse_reward', '浏览奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('withdrawal_refund', '提现被驳回', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('commission_transfer', '转入余额', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('boss_forever', '永久分红', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('boss_extra', '额外分红', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('direct_reward', '提现直推荐奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('indirect_reward', '提现间推荐奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('payment_for_goods_fill', '补货货款', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('payment_for_goods_buy', '会员买货货款', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('achievement_reward', '业绩奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('first_prize', '直推奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('invite_reward', '邀请奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888),";
        $sql .= "('pool_reward', '奖金池奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888);";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}