qimall/addons/Boss/console/migrations/M231129094408CreateQimallAddonsBoss.php

<?php

namespace addons\Boss\console\migrations;

use yii\db\Migration;

/**
 * Class M231129094408CreateQimallAddonsBoss
 */
class M231129094408CreateQimallAddonsBoss extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
       $this->createCommissionLogTable();
       $this->createJobTable();
       $this->createOrderLogTable();
       $this->createPerformanceTable(); 
    }

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

        return false;
    }

    protected function createCommissionLogTable(){
        $sql = "CREATE TABLE `qimall_addons_boss_pool_prize_commission_log` (
            `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
            `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
            `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
            `boss_id` int(11) NOT NULL DEFAULT '0' COMMENT '股东ID',
            `total_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '分红总额',
            `total_performance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '团队总业绩',
            `personal_performance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '个人团队业绩',
            `num` int(8) NOT NULL DEFAULT '0' COMMENT '分红人数',
            `amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '分红金额',
            `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1删除；0禁用；1正常]',
            `start_at` varchar(8) NOT NULL DEFAULT '' COMMENT '开始时间',
            `end_at` varchar(8) NOT NULL DEFAULT '' COMMENT '结算时间',
            `billing_cycle` tinyint(1) NOT NULL DEFAULT '0' COMMENT '结算周期',
            `job_id` int(11) NOT NULL DEFAULT '0' COMMENT '任务ID',
            `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
            `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
          $this->execute($sql);
    }

    protected function createJobTable(){
        $sql = "CREATE TABLE `qimall_addons_boss_pool_prize_job` (
            `id` int(10) NOT NULL AUTO_INCREMENT,
            `mall_id` int(10) NOT NULL DEFAULT '0' COMMENT '商城ID',
            `date_limit` varchar(45) NOT NULL DEFAULT '' COMMENT '结算开始~结束日期',
            `compute_period` tinyint(1) NOT NULL DEFAULT '0' COMMENT '结算周期：1天，2周，3月',
            `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
            `total_performance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '团队总业绩',
            `num` int(10) NOT NULL DEFAULT '0' COMMENT '分红人数',
            `total_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '分红总金额',
            `period_total_amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '本期奖金池总金额',
            `period` int(10) NOT NULL DEFAULT '1' COMMENT '发放期数',
            `created_at` int(10) NOT NULL DEFAULT '0',
            `updated_at` int(10) NOT NULL DEFAULT '0',
            PRIMARY KEY (`id`) USING BTREE,
            KEY `mall_id` (`mall_id`,`date_limit`) USING BTREE
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='股东分奖金池已结算日期记录表';";
          $this->execute($sql);
    }

    protected function createOrderLogTable(){
        $sql = "CREATE TABLE `qimall_addons_boss_pool_prize_order_log` (
            `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
            `mall_id` int(11) NOT NULL DEFAULT '0' COMMENT '商城ID',
            `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户ID',
            `amount` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '进入奖金池金额',
            `order_id` int(11) NOT NULL DEFAULT '0' COMMENT '订单ID',
            `order_no` varchar(100) NOT NULL DEFAULT '' COMMENT '订单编号',
            `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1删除；0禁用；1正常]',
            `date` varchar(8) NOT NULL DEFAULT '' COMMENT '日期',
            `settlement_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '结算状态[0未结算；1已结算]',
            `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
            `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
          $this->execute($sql);
    }

    protected function createPerformanceTable(){
        $sql = "CREATE TABLE `qimall_addons_boss_pool_prize_performance` (
            `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',
            `performance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '商品业绩',
            `date` varchar(8) NOT NULL DEFAULT '' COMMENT '日期',
            `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态[-1删除；0禁用；1正常]',
            `created_at` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
            `updated_at` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
            PRIMARY KEY (`id`)
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
          $this->execute($sql);
    }

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

    }

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

        return false;
    }
    */
}