qimall/addons/YunfastPay/console/migrations/M230313091754CreateTablePaymentOrder.php

<?php

namespace addons\YunfastPay\console\migrations;

use yii\db\Migration;

/**
 * Class M230313091754CreateTablePaymentOrder
 */
class M230313091754CreateTablePaymentOrder extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        try {
            // 插入表数据
            $sql = "
            CREATE TABLE `qimall_addons_yunfast_pay_payment_order` (
                `id` int(11) NOT NULL AUTO_INCREMENT,
                `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT 'mall_id',
                `store_id` int(11) NOT NULL DEFAULT '0' COMMENT 'store_id',
                `user_id` int(11) NOT NULL DEFAULT '0',
                `trade_id` int(11) NOT NULL DEFAULT '0',
                `order_no` varchar(30) NOT NULL COMMENT '订单号',
                `amount` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
                `is_split_bill` tinyint(1) DEFAULT '0' COMMENT '是否分账',
                `req_data` text COMMENT '请求参数',
                `res_data` text COMMENT '返回参数',
                `status` varchar(10) NOT NULL DEFAULT '' COMMENT '状态',
                `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
                `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
                PRIMARY KEY (`id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=315 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='支付订单';
            CREATE TABLE `qimall_addons_yunfast_pay_agent_order` (
                `id` int(11) NOT NULL AUTO_INCREMENT,
                `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT 'mall_id',
                `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '会员ID',
                `withdraw_id` int(11) NOT NULL DEFAULT '0' COMMENT '提现ID',
                `order_no` varchar(32) NOT NULL COMMENT '订单号',
                `trans_amount` decimal(10,2) NOT NULL COMMENT '交易金额',
                `acct_number` varchar(64) NOT NULL DEFAULT '' COMMENT '收款卡号',
                `acct_name` varchar(64) NOT NULL DEFAULT '' COMMENT '收款户名',
                `acct_type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '账户类型 1：对私 2：对公',
                `req_data` text COMMENT '请求参数',
                `res_data` text COMMENT '返回参数',
                `status` varchar(5) NOT NULL DEFAULT '1' COMMENT '100-支付成功（支付订单）或退款成功（退款订单） 101-待支付 102-支付失败（支付订单）或退款失败（退款订单） 103-订单处理中 104-已撤销\n',
                `created_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
                `updated_at` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
                PRIMARY KEY (`id`) USING BTREE
            ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='代付订单';
            CREATE TABLE `qimall_addons_yunfast_pay_refund_order` (
                `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
                `mall_id` int(10) unsigned NOT NULL COMMENT '商城ID',
                `user_id` int(10) NOT NULL COMMENT '会员ID',
                `refund_id` int(10) NOT NULL COMMENT '退款订单ID',
                `order_id` int(10) NOT NULL COMMENT '订单ID',
                `order_no` varchar(32) NOT NULL COMMENT '退款订单号',
                `refund_amount` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '退款金额',
                `req_data` longtext COMMENT '请求参数',
                `res_data` longtext COMMENT '返回参数',
                `refund_params` longtext COMMENT '退款参数',
                `status` varchar(10) NOT NULL DEFAULT '0' COMMENT '退款状态',
                `updated_at` int(10) NOT NULL DEFAULT '0',
                `created_at` int(10) NOT NULL DEFAULT '0',
                PRIMARY KEY (`id`)
            ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='退款订单';
            CREATE TABLE `qimall_addons_yunfast_pay_splitbill_item` (
                `id` int(10) NOT NULL AUTO_INCREMENT,
                `mall_id` int(10) NOT NULL,
                `log_id` int(10) NOT NULL COMMENT '分账记录ID',
                `store_id` int(10) NOT NULL COMMENT '店铺ID',
                `amount` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '分账金额',
                `role` varchar(32) DEFAULT NULL COMMENT '分账角色',
                `mcht_cd` varchar(32) DEFAULT NULL COMMENT '接收方商户号',
                `fee_party` tinyint(1) DEFAULT NULL COMMENT '手续费承担方，只能有一方承担,是 0：否，1：是，部分通道不支持',
                `updated_at` int(10) NOT NULL DEFAULT '0',
                `created_at` int(10) NOT NULL DEFAULT '0',
                PRIMARY KEY (`id`)
            ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='分账子项';
            CREATE TABLE `qimall_addons_yunfast_pay_splitbill_log` (
                `id` int(10) NOT NULL AUTO_INCREMENT,
                `mall_id` int(10) NOT NULL COMMENT '商城ID',
                `payment_id` int(10) NOT NULL COMMENT '支付订单ID',
                `order_no` varchar(32) NOT NULL COMMENT '订单号',
                `req_data` longtext COMMENT '请求数据',
                `res_data` longtext COMMENT '返回数据',
                `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
                `updated_at` int(10) NOT NULL DEFAULT '0',
                `created_at` int(10) NOT NULL DEFAULT '0',
                PRIMARY KEY (`id`)
            ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COMMENT='分账表';
            ";
            $this->execute($sql);
        } catch (\Exception $e) {

        }
    }

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

        return false;
    }
}