qimall/addons/CloudStock/console/migrations/M241119082148PriceDiffGiftPackage.php

<?php

namespace addons\CloudStock\console\migrations;

use addons\CloudStock\common\models\CloudStockDeductionDetail;
use yii\db\Migration;

/**
 * Class M241119082148PriceDiffGiftPackage
 */
class M241119082148PriceDiffGiftPackage extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "
ALTER TABLE qimall_addons_cloud_stock_fill_order add price_difference_order_id int(11) not null default 0 COMMENT '价差礼包订单id';
ALTER TABLE qimall_addons_cloud_stock_fill_order add price_difference_order_detail_id int(11) not null default 0 COMMENT '价差礼包订单详情id';
ALTER TABLE qimall_addons_cloud_stock_agent_order add order_type tinyint(1) not null default 1 COMMENT '1:云仓自提；2：价差礼包自提';
INSERT INTO `qimall_global_var_map` ( `name`, `title`, `type`, `is_addons`, `status`, `created_at`, `updated_at`) VALUES ('recommend_reward', '推荐奖励', 'CapitalTypeMap', 0, 1, 1654569888, 1654569888);


CREATE TABLE `qimall_addons_cloud_stock_price_difference_gift_package` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `name` varchar(255) NOT NULL COMMENT '礼包名称',
  `pic_type` tinyint(255) NOT NULL DEFAULT '0' COMMENT '0:默认；1：自定义',
  `pic` varchar(255) NOT NULL COMMENT '礼包主图',
  `level` int(11) NOT NULL COMMENT '升级等级权重',
  `price` decimal(12,2) NOT NULL COMMENT '礼包金额',
  `goods_id` text,
  `recommend_reward` text COMMENT '推荐奖励设置',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='价差礼包';

CREATE TABLE `qimall_addons_cloud_stock_price_difference_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `user_id` int(11) NOT NULL COMMENT '补货代理商用户id',
  `trade_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '支付流水记录id',
  `address_id` int(11) NOT NULL DEFAULT '0' COMMENT '收货地址id',
  `receiver_name` varchar(255) NOT NULL DEFAULT '' COMMENT '收货人',
  `receiver_mobile` varchar(20) NOT NULL DEFAULT '' COMMENT '收货人手机号',
  `address` varchar(1000) NOT NULL DEFAULT '' COMMENT '收货地址',
  `price_difference_gift_package_id` int(11) NOT NULL DEFAULT '0' COMMENT '价差礼包id',
  `pay_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
  `shipping_money` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '运费',
  `order_no` varchar(255) NOT NULL COMMENT '补货订单编号',
  `trade_no` varchar(255) NOT NULL DEFAULT '' COMMENT '支付流水号',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '订单备注',
  `is_pay` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否支付',
  `pay_time` int(11) NOT NULL DEFAULT '0' COMMENT '支付时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  `payment_type` tinyint(4) DEFAULT '0' COMMENT '支付类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='价差礼包订单表';

CREATE TABLE `qimall_addons_cloud_stock_price_difference_order_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mall_id` int(11) NOT NULL COMMENT '商城id',
  `user_id` int(11) NOT NULL COMMENT '补货代理商用户id',
  `price_difference_order_id` int(11) NOT NULL COMMENT '补货代理商用户id',
  `goods_price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '支付金额',
  `goods_id` int(11) NOT NULL COMMENT '商品id',
  `self_pickup_num` int(11) NOT NULL DEFAULT '0' COMMENT '自提数量',
  `cloud_warehouse_num` int(11) NOT NULL DEFAULT '0' COMMENT '云仓数量',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `updated_at` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='价差礼包订单详情表';

CREATE TABLE `qimall_addons_cloud_stock_price_difference_user_team_statistics` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `mall_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '商城ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '用户ID',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
  `created_at` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updated_at` int(10) NOT NULL DEFAULT '0' COMMENT '上次更新数据时间',
  `user_direct_pay_selling_price` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '直推已支付的订单售价总额（商品价格）',
  `user_indirect_pay_selling_price` decimal(12,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '间推已支付的订单售价总额（商品价格）',
  `team_pay_selling_price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '团队已支付的订单售价总额（商品价格）',
  `self_selling_price` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '本人已支付的订单售价总额（商品价格）',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `mall_id` (`mall_id`) USING BTREE,
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='价差礼包用户数据统计表';;
";
        $this->execute($sql);
        CloudStockDeductionDetail::fixOrderType();

    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}