qimall/addons/Happiness/console/migrations/M250919103036AddHappinessWeightTable.php

<?php

namespace addons\Happiness\console\migrations;

use yii\db\Migration;

/**
 * Class M250919103036AddHappinessWeightTable
 */
class M250919103036AddHappinessWeightTable extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $sql = "CREATE TABLE `qimall_addons_happiness_weight_pool_job`  (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `mall_id` int(10) NOT NULL DEFAULT 0 COMMENT '商城ID',
  `date_limit` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci 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启用]',
  `num` int(10) NOT NULL DEFAULT 0 COMMENT '分红人数',
  `total_amount` decimal(12, 2) NOT NULL COMMENT '分红总金额',
  `period_total_amount` decimal(12, 2) NOT NULL 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,
  INDEX `mall_id`(`mall_id`, `date_limit`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权重值奖金池已结算日期记录表' ROW_FORMAT = DYNAMIC;";
        $this->execute($sql);
        
        $sql = "CREATE TABLE `qimall_addons_happiness_weight_pool_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',
  `total_amount` decimal(12, 2) NOT NULL COMMENT '分红池总额',
  `num` int(8) NOT NULL DEFAULT 0 COMMENT '分红人数',
  `amount` decimal(12, 2) NOT NULL COMMENT '可获得分红金额',
  `scale` decimal(10, 2) NOT NULL COMMENT '分红比例',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1删除；0禁用；1正常]',
  `start_at` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '开始时间',
  `end_at` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 '更新时间',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户分红记录表' ROW_FORMAT = DYNAMIC;";
        $this->execute($sql);
        
        $sql = "CREATE TABLE `qimall_addons_happiness_weight_pool_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 COMMENT '进入奖金池金额',
  `price` decimal(12, 2) NOT NULL COMMENT '订单金额',
  `pay_price` decimal(12, 2) NOT NULL COMMENT '实付金额',
  `before_amount` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '变动前金额',
  `after_amount` decimal(12, 2) NOT NULL DEFAULT 0.00 COMMENT '变动后金额',
  `order_id` int(11) NOT NULL DEFAULT 0 COMMENT '订单ID',
  `order_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '订单编号',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态[-1删除；0禁用；1正常]',
  `date` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '日期',
  `settlement_status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '结算状态[0未结算；1已结算]',
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `created_at` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `updated_at` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '分红池订单表' ROW_FORMAT = DYNAMIC;";
        $this->execute($sql);
        
        $this->execute("INSERT INTO `qimall_crontab_task`(`name`, `command`, `type`, `rule`, `is_warning`, `status`, `created_at`, `updated_at`) VALUES ('幸福小店权重分红定时发放-每天一次', 'happiness/index/pool-run', 2, '0 0 1 * * *', 0, 1, 1718070034, 1718070034);");
        
        

    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {

        return false;
    }

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

    }

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

        return false;
    }
    */
}