qimall/addons/Area/console/migrations/M241119072927CreateAddonsAreaOrder.php

<?php

namespace addons\Area\console\migrations;

use yii\db\Migration;

/**
 * Class M241119072927CreateAddonsAreaOrder
 */
class M241119072927CreateAddonsAreaOrder extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "CREATE TABLE `qimall_addons_area_order` (
            `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
            `mall_id` int(11) NOT NULL COMMENT '商城id',
            `user_id` int(11) NOT NULL COMMENT '用户id',
            `level` tinyint(1) NOT NULL DEFAULT '0' COMMENT '等级',
            `area_id` int(11) NOT NULL DEFAULT '0' COMMENT '地区id',
            `is_pay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否支付（0：未支付，1：已支付）',
            `price` decimal(15,2) NOT NULL COMMENT '支付金额',
            `pay_time` int(11) DEFAULT NULL COMMENT '支付时间',
            `created_at` int(11) DEFAULT NULL COMMENT '创建时间',
            `updated_at` int(11) DEFAULT NULL COMMENT '修改时间',
            `total_commission` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '总佣金',
            `commission` decimal(15,2) NOT NULL DEFAULT '0.00' COMMENT '需发放佣金',
            `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态（0：已回退，1：未回退）',
            `order_no` varchar(255) NOT NULL DEFAULT '' COMMENT '订单号',
            `out_trade_no` varchar(255) NOT NULL DEFAULT '' COMMENT '系统支付流水号',
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='购买区代订单数据';";
        $this->execute($sql);

        $sql = "ALTER TABLE `qimall_addons_area_apply` 
        ADD COLUMN `pay_price` decimal(14, 2) NOT NULL DEFAULT '0.00' COMMENT '申请金额' AFTER `agent_id`,
        ADD COLUMN `refund_time` int(11) NULL COMMENT '退回时间' AFTER `pay_price`,
        ADD COLUMN `is_refund` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否退回（0：未退回，1：已退回）' AFTER `refund_time`,
        ADD COLUMN `order_id` int(11) NULL COMMENT '订单id' AFTER `is_refund`,
        ADD COLUMN `refund_remark` varchar(255) DEFAULT NULL COMMENT '退回原因' AFTER `order_id`;";

        $this->execute($sql);

        $sql="INSERT INTO `qimall_global_var_map`( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ( 'area_apply_consume', '购买区代申请资格', 'CapitalTypeMap', 0, 1, 1732008804, 1732008804);";
        $this->execute($sql);
        $sql="INSERT INTO `qimall_global_var_map`( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ( 'area_bonus_reward', '加价分红奖励', 'CapitalTypeMap', 0, 1, 1732008804, 1732008804);";
        $this->execute($sql);

        $sql="INSERT INTO `qimall_global_var_map`( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ( 'area_bonus_refund', '代理身份被加价占用', 'CapitalTypeMap', 0, 1, 1732008804, 1732008804);";
        $this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}