qimall/addons/Store/console/migrations/M231229032830StoreReserveOrder.php

<?php

namespace addons\Store\console\migrations;

use yii\db\Migration;

/**
 * Class M231229032830StoreReserveOrder
 */
class M231229032830StoreReserveOrder extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {

        $this->execute("CREATE TABLE `qimall_addons_store_goods_reserve` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`mall_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商城id',
	`store_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
	`goods_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商品id',
	`price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '售价',
	`original_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '原价（划线价仅展示）',
	`cost_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
	`reserve_date_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '可预约时间类型(1范围 2自选日期)',
	`reserve_week` VARCHAR(32) NULL DEFAULT '0,1,2,3,4,5,6' COMMENT '可预约周' COLLATE 'utf8mb4_general_ci',
	`reserve_date` LONGTEXT NULL DEFAULT NULL COMMENT '可预约日期' COLLATE 'utf8mb4_general_ci',
	`reserve_time_range_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '预约模式(1按天预约 2按时间段预约)',
	`time_slot_type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '时间段划分方式(1自定义划分 2自动划分)',
	`reserve_time_slot` LONGTEXT NULL DEFAULT NULL COMMENT '时间段划分' COLLATE 'utf8mb4_general_ci',
	`reserve_price_type` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '价格设置方式(0统一售价 1按日期时间段设置)',
	`reserve_time_slot_price` LONGTEXT NULL DEFAULT NULL COMMENT '时间段价格设置' COLLATE 'utf8mb4_general_ci',
	`reserve_max_buy` INT(11) NOT NULL DEFAULT '0' COMMENT '每天最大预约数量',
	`reserve_advance_hourse` INT(11) NOT NULL DEFAULT '0' COMMENT '提前预约时间（小时）',
	`reserve_days_range` INT(11) NOT NULL DEFAULT '0' COMMENT '限制选择并购买的时间在设置内天数的商品',
	`cancel_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '取消类型(1不允许取消 2服务开始前取消 3订单类型取消)',
	`cancel_rule` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '取消退款规则' COLLATE 'utf8mb4_general_ci',
	`expired_handle_type` TINYINT(1) NOT NULL COMMENT '预约码过期后处理方式(1不退款 2自动退款)',
	`province_id` INT(11) NOT NULL COMMENT '省ID',
	`city_id` INT(11) NOT NULL COMMENT '市ID',
	`district_id` INT(11) NOT NULL DEFAULT '0' COMMENT '区县ID',
	`detail` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '详细地址' COLLATE 'utf8mb4_general_ci',
	`lat` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '纬度' COLLATE 'utf8mb4_general_ci',
	`lng` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '经度' COLLATE 'utf8mb4_general_ci',
	`region_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '省市区字符串' COLLATE 'utf8mb4_general_ci',
	`service_type` TINYINT(3) NOT NULL DEFAULT '0' COMMENT '服务方式(1上门 2到店)',
	`created_at` INT(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
	`ordering_information` TEXT NOT NULL COMMENT '订购须知' COLLATE 'utf8mb4_general_ci',
	`information_detail` TEXT NOT NULL COMMENT '须知详情' COLLATE 'utf8mb4_general_ci',
	`reserve_type` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0商品预约，1项目服务预约',
	`distance` DECIMAL(5,2) NOT NULL DEFAULT '0.00' COMMENT '有效距离',
	`service_min` SMALLINT(6) NOT NULL DEFAULT '0' COMMENT '服务时长',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `mall_id_mch_id_goods_name_index` (`mall_id`, `store_id`) USING BTREE
)
COMMENT='预约商品表'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB");

        $this->execute("CREATE TABLE `qimall_addons_store_goods_reserve_sku` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`mall_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商城id',
	`store_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
	`name` VARCHAR(500) NOT NULL DEFAULT '' COMMENT '规格名称' COLLATE 'utf8mb4_general_ci',
	`sign_id` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '规格ID标识' COLLATE 'utf8mb4_general_ci',
	`pic_url` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '规格图片' COLLATE 'utf8mb4_general_ci',
	`goods_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商品id',
	`price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '售价',
	`original_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '原价（划线价仅展示）',
	`cost_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
	`reserve_date_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '可预约时间类型(1范围 2自选日期)',
	`reserve_week` VARCHAR(32) NULL DEFAULT '0,1,2,3,4,5,6' COMMENT '可预约周' COLLATE 'utf8mb4_general_ci',
	`reserve_date` LONGTEXT NULL DEFAULT NULL COMMENT '可预约日期' COLLATE 'utf8mb4_general_ci',
	`reserve_time_range_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '预约模式(1按天预约 2按时间段预约)',
	`time_slot_type` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '时间段划分方式(1自定义划分 2自动划分)',
	`reserve_time_slot` LONGTEXT NULL DEFAULT NULL COMMENT '时间段划分' COLLATE 'utf8mb4_general_ci',
	`reserve_price_type` TINYINT(1) NOT NULL COMMENT '价格设置方式(0统一售价 1按日期时间段设置)',
	`reserve_time_slot_price` LONGTEXT NOT NULL COMMENT '时间段价格设置' COLLATE 'utf8mb4_general_ci',
	`reserve_max_buy` INT(11) NOT NULL DEFAULT '0' COMMENT '每天最大预约数量',
	`created_at` INT(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
	`service_min` INT(11) NOT NULL DEFAULT '0' COMMENT '服务分钟',
	`unit` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '单位' COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `mall_id_mch_id_goods_name_index` (`mall_id`, `store_id`) USING BTREE
)
COMMENT='预约商品规格'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

        $this->execute("CREATE TABLE `qimall_addons_store_goods_reserve_time` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`mall_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商城id',
	`store_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商家id',
	`price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '售价',
	`original_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '原价（划线价仅展示）',
	`cost_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
	`reserve_max_buy` INT(11) NOT NULL DEFAULT '0' COMMENT '每天最大预约数量',
	`reserve_time` VARCHAR(32) NULL DEFAULT NULL COMMENT '预约日期标题' COLLATE 'utf8mb4_general_ci',
	`reserve_range_time` TEXT NULL DEFAULT NULL COMMENT '时分秒时间范围' COLLATE 'utf8mb4_general_ci',
	`reserve_sku_id` INT(11) NOT NULL DEFAULT '0' COMMENT '预约商品SKU',
	`stock` INT(11) NOT NULL DEFAULT '0' COMMENT '库存',
	`sales` INT(11) NULL DEFAULT NULL COMMENT '销量',
	`time_span` INT(11) NULL DEFAULT '0' COMMENT '时间间隔',
	`created_at` INT(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `mall_id_mch_id_goods_name_index` (`mall_id`, `store_id`) USING BTREE
)
COMMENT='预约商品时间表'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");


        $this->execute("CREATE TABLE `qimall_addons_store_goods_reserve_time_spec` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`spec_time` VARCHAR(16) NULL DEFAULT NULL COMMENT 'spec标题' COLLATE 'utf8mb4_general_ci',
	`start` VARCHAR(32) NULL DEFAULT NULL COMMENT '开始时间点' COLLATE 'utf8mb4_general_ci',
	`end` VARCHAR(32) NULL DEFAULT NULL COMMENT '结束时间点' COLLATE 'utf8mb4_general_ci',
	`reserve_time_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商城id',
	`reserve_sku_id` INT(11) NULL DEFAULT NULL COMMENT '预约商品SKU',
	`checked` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否选中',
	`is_next` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '结束时间[0当日 1次日]',
	`stock` INT(11) NOT NULL DEFAULT '0' COMMENT '库存',
	`price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '售价',
	`original_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '原价（划线价仅展示）',
	`cost_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '成本价',
	`reserve_max_buy` INT(11) NOT NULL DEFAULT '0' COMMENT '每天最大预约数量',
	`updated_at` INT(11) NOT NULL DEFAULT '0' COMMENT '修改时间',
	`created_at` INT(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `mall_id_mch_id_goods_name_index` (`reserve_time_id`) USING BTREE
)
COMMENT='预约商品时间规格表'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

        $this->execute("CREATE TABLE `qimall_addons_store_order_reserve` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
	`order_id` INT(11) NOT NULL DEFAULT '0' COMMENT '主订单id',
	`main_order_id` INT(11) NOT NULL DEFAULT '0' COMMENT '主订单ID',
	`store_id` INT(11) NOT NULL DEFAULT '0' COMMENT '门店id',
	`mall_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
	`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户id',
	`time_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '预约时间id',
	`time_spec_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '预约时间id',
	`reserve_date_time` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '预约时间' COLLATE 'utf8mb4_general_ci',
	`reserve_time_range_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '预约模式(1按天预约 2按时间段预约)',
	`province_id` INT(11) NOT NULL COMMENT '省ID',
	`city_id` INT(11) NOT NULL COMMENT '市ID',
	`district_id` INT(11) NOT NULL DEFAULT '0' COMMENT '区县ID',
	`detail` VARCHAR(1000) NOT NULL DEFAULT '' COMMENT '详细地址' COLLATE 'utf8mb4_general_ci',
	`lat` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '纬度' COLLATE 'utf8mb4_general_ci',
	`lng` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '经度' COLLATE 'utf8mb4_general_ci',
	`region_name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '地区字符串' COLLATE 'utf8mb4_general_ci',
	`service_type` VARCHAR(255) NULL DEFAULT NULL COMMENT '服务方式(1上门 2到店)' COLLATE 'utf8mb4_general_ci',
	`order_status` TINYINT(4) NULL DEFAULT '0' COMMENT '订单状态',
	`pay_status` TINYINT(4) NULL DEFAULT '0' COMMENT '订单付款状态',
	`reserve_status` TINYINT(4) NULL DEFAULT '0' COMMENT '订单预约状态',
	`feedback_status` TINYINT(4) NULL DEFAULT '0' COMMENT '售后状态',
	`cancel_rule` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '取消退款规则' COLLATE 'utf8mb4_general_ci',
	`cancel_type` TINYINT(1) NOT NULL DEFAULT '1' COMMENT '取消类型(1不允许取消 2服务开始前取消 3订单类型取消)',
	`reserve_code` VARCHAR(32) NOT NULL DEFAULT '' COMMENT '预约码' COLLATE 'utf8mb4_general_ci',
	`created_at` INT(10) NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(10) NULL DEFAULT '0' COMMENT '更新时间',
	`reserve_type` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0商品预约，1项目服务预约',
	`tech_id` INT(11) NOT NULL DEFAULT '0' COMMENT '技师/师傅ID',
	`distance` DECIMAL(5,2) NOT NULL DEFAULT '0.00' COMMENT '有效距离',
	PRIMARY KEY (`id`) USING BTREE
)
COMMENT='订单表'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

        $this->execute("CREATE TABLE `qimall_addons_store_reserve_underwriter` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
	`created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
	`mall_id` INT(10) UNSIGNED NOT NULL COMMENT '商城ID',
	`status` TINYINT(3) NOT NULL DEFAULT '1' COMMENT '状态0禁用，-1删除，1正常',
	`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
	`order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
	`order_no` CHAR(30) NOT NULL DEFAULT '' COMMENT '订单号' COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `user_id` (`user_id`) USING BTREE,
	INDEX `order_id` (`order_id`) USING BTREE,
	INDEX `order_no` (`order_no`) USING BTREE
)
COMMENT='核销记录'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

        $this->execute("CREATE TABLE `qimall_addons_store_reserve_order` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
	`created_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '更新时间',
	`mall_id` INT(10) UNSIGNED NOT NULL COMMENT '商城ID',
	`status` TINYINT(3) NOT NULL DEFAULT '1' COMMENT '状态0禁用，-1删除，1正常',
	`user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
	`staff_user_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '技师用户ID',
	`order_id` INT(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT '订单ID',
	`service_status` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT '服务状态',
	`order_no` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '订单编号' COLLATE 'utf8mb4_general_ci',
	`service_start_at` INT(11) NOT NULL DEFAULT '0' COMMENT '服务开始时间',
	`service_end_at` INT(11) NOT NULL DEFAULT '0' COMMENT '服务结束时间',
	`remark` TEXT NULL DEFAULT NULL COMMENT '备注信息' COLLATE 'utf8mb4_general_ci',
	`commission` DECIMAL(10,2) NOT NULL DEFAULT '0.00' COMMENT '佣金信息',
	`order_detail_id` INT(11) NOT NULL DEFAULT '0' COMMENT '订单详情ID',
	`goods_id` INT(11) NOT NULL DEFAULT '0' COMMENT '商品ID',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `user_id` (`user_id`) USING BTREE,
	INDEX `staff_user_id` (`staff_user_id`) USING BTREE,
	INDEX `service_start_at` (`service_start_at`, `service_end_at`) USING BTREE
)
COMMENT='预约记录'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

        $this->execute("CREATE TABLE `qimall_addons_store_staff_apply` (
	`id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
	`mall_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '商城ID',
	`user_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '用户ID',
	`store_id` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '门店ID',
	`status` TINYINT(4) NOT NULL DEFAULT '1' COMMENT '状态；1正常，0禁用，-1删除',
	`check_status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '审核状态：0：待审核；1：已通过；2：未通过',
	`check_remark` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '审核备注' COLLATE 'utf8mb4_general_ci',
	`created_at` INT(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
	`updated_at` INT(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
	`name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '姓名' COLLATE 'utf8mb4_general_ci',
	`pic` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '相片' COLLATE 'utf8mb4_general_ci',
	`phone` CHAR(15) NOT NULL DEFAULT '' COMMENT '电话' COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `user_id` (`user_id`) USING BTREE,
	INDEX `store_id` (`store_id`) USING BTREE
)
COMMENT='技师申请列表'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB;");

//        $this->execute("ALTER TABLE `qimall_addons_store_order_refund` ADD COLUMN `goods_type` TINYINT NOT NULL DEFAULT 1 COMMENT '商品类型' AFTER `updated_at`;");
        $this->execute("ALTER TABLE `qimall_addons_store_cate` CHANGE COLUMN `advert_url` `advert_url` TEXT NULL COMMENT '广告链接' COLLATE 'utf8mb4_general_ci' AFTER `advert_pic`;");
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}