qimall/addons/ServeBonus/console/migrations/M230830075244ServebonusUpdate.php

<?php

namespace addons\ServeBonus\console\migrations;

use yii\db\Migration;

/**
 * Class M230830075244ServebonusUpdate
 */
class M230830075244ServebonusUpdate extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "ALTER TABLE `qimall_addons_servebonus_level_setting`
            ADD COLUMN `is_cloud_stock_open`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '云库存加权分红 0关闭 1 开启',
            ADD COLUMN `cloud_stock_achievement_percent`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '云库存业绩分红类型 0百分比 1 固定金额',
            ADD COLUMN `cloud_stock_achievement_prize`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '云库存业绩分红奖励';
            ALTER TABLE `qimall_addons_servebonus_reward_log` ADD COLUMN `is_cloud_stock`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否云库存结算[0否; 1是]';
            ALTER TABLE `qimall_addons_servebonus_commission_log` ADD COLUMN `achievement_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '业绩分红，单位：元';
            ALTER TABLE `qimall_addons_servebonus` ADD COLUMN `achievement_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '累计业绩分红，单位：元';
            ALTER TABLE `qimall_addons_servebonus_commission_item_setting` ADD COLUMN `cloud_stock_achievement_percent`  tinyint(1) NOT NULL DEFAULT 0 COMMENT '云库存业绩分红类型 0百分比 1 固定金额';
            ALTER TABLE `qimall_addons_servebonus_commission_item_setting_detail` ADD COLUMN `cloud_stock_achievement_prize`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '云库存业绩分红奖励';
            ALTER TABLE `qimall_addons_servebonus_period` ADD COLUMN `achievement_commission`  decimal(10,2) NOT NULL DEFAULT 0.00 COMMENT '业绩分红，单位：元';";
        $this->execute($sql);

        $sql = "CREATE TABLE `qimall_addons_servebonus_achievement_settle_log` (
		  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
		  `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城id',
		  `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单id',
		  `order_type` tinyint(5) NOT NULL DEFAULT '1' COMMENT 'order类型,1:会员购买订单，2：补货订单;',
		  `not_yet_num` int(11) NOT NULL DEFAULT '0' COMMENT '剩余未结算数量',
		  `num` int(11) NOT NULL DEFAULT '0' COMMENT '补货数量',
		  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
		  `insert_id` int(11) NOT NULL DEFAULT '0' COMMENT '库存新增id',
		  `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',
		  `changes_type` int(11) NOT NULL COMMENT '库存变动类型;100向上级补货;101上级给自己配货;102退货退库存;103系统添加;104平台补货赠送;105购买礼包赠送;',
		  PRIMARY KEY (`id`) USING BTREE,
		  KEY `user_id` (`user_id`) USING BTREE
		) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT COMMENT='云库存扣库存明细表';";
		
		$this->execute($sql);
		$sql = "CREATE TABLE `qimall_addons_servebonus_cloud_stock_period` (
		  `id` int(10) NOT NULL AUTO_INCREMENT,
		  `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
		  `period_num` int(10) NOT NULL DEFAULT '1' COMMENT '第N期',
		  `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '得奖励用户ID',
		  `amounts` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '个人补货业绩，单位：元',
		  `amounts_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '等级补货业绩',
		  `total_amounts_num` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '结算金额',
		  `commission` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '结算的佣金，单位：元',
		  `compute_period` tinyint(1) NOT NULL DEFAULT '0' COMMENT '结算周期：1天，2周，3月',
		  `start_time` int(10) NOT NULL DEFAULT '0' COMMENT '结算开始日期',
		  `end_time` int(10) NOT NULL DEFAULT '0' COMMENT '结算结束日期',
		  `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
		  `created_at` int(10) NOT NULL DEFAULT '0',
		  `updated_at` int(10) NOT NULL DEFAULT '0',
		  `is_settlement` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否已结算【0否，1是】',
		  `period_id` int(10) DEFAULT '0' COMMENT '分红期数ID',
		  PRIMARY KEY (`id`) USING BTREE,
		  KEY `mall_id+period_num` (`mall_id`,`period_num`) USING BTREE
		) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='业绩分红结算期数表';";
		$this->execute($sql);

		$sql = "CREATE TABLE `qimall_addons_servebonus_order_log` (
		  `id` int(10) NOT NULL AUTO_INCREMENT,
		  `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
		  `order_id` int(10) NOT NULL DEFAULT '0' COMMENT '订单ID',
		  `order_detail_id` int(10) NOT NULL DEFAULT '0' COMMENT '订单详情ID',
		  `goods_id` int(10) NOT NULL DEFAULT '0' COMMENT '商品ID',
		  `num` int(10) NOT NULL DEFAULT '0' COMMENT '商品数量',
		  `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '订单编号',
		  `order_type` tinyint(5) NOT NULL DEFAULT '1' COMMENT 'order类型,0: 商城订单，1:会员购买订单，2：补货订单;',
		  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '订单金额，单位：元',
		  `date` int(8) NOT NULL DEFAULT '0' COMMENT '出单日期，格式:20220124',
		  `status` tinyint(4) DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
		  `created_at` int(10) NOT NULL DEFAULT '0',
		  `updated_at` int(10) NOT NULL DEFAULT '0',
		  PRIMARY KEY (`id`) USING BTREE,
		  KEY `mall_id+date` (`mall_id`,`date`) USING BTREE
		) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='服务商业绩出单表';";
		$this->execute($sql);
    }

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

        return false;
    }

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

    }

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

        return false;
    }
    */
}