仿拼多多天天领红包

活动目的：推广app、增强用户参与使用app。每凑足100元即可提现。24小时内没有凑够100则清零重新参与。

CREATE TABLE `yq_hb_take` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`uid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`hbsn` VARCHAR(50) NULL DEFAULT NULL COMMENT '期号' COLLATE 'utf8mb4_general_ci',
	`finish_time` INT(11) NULL DEFAULT NULL COMMENT '完成时间',
	`maxmoney` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00' COMMENT '本次最大累计',
	`maxcount` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '助力了多少次',
	`needcount` INT(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '需要几次完成',
	`status` TINYINT(4) NULL DEFAULT '0' COMMENT '-1失败0未完成1已完成',
	`tx_time` INT(11) NULL DEFAULT NULL COMMENT '提现时间',
	`tx_status` TINYINT(4) NULL DEFAULT '0' COMMENT '0未提现1已提现2提现中',
	`create_time` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COMMENT='天天领红包参与纪录\r\n'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=16
;
CREATE TABLE `yq_hb_record` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`uid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`hbsn` VARCHAR(50) NULL DEFAULT NULL COMMENT '期号' COLLATE 'utf8mb4_general_ci',
	`from` TINYINT(4) NULL DEFAULT '0' COMMENT '0来自系统1分享好友2做任务3升级年费4好友助力5浏览任务',
	`getmoney` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00' COMMENT '获得',
	`maxmoney` DECIMAL(10,2) UNSIGNED NOT NULL DEFAULT '0.00' COMMENT '当前累计金额',
	`fromnickname` VARCHAR(50) NULL DEFAULT NULL COMMENT '来源昵称' COLLATE 'utf8mb4_general_ci',
	`fromavatar` VARCHAR(255) NULL DEFAULT NULL COMMENT '来源头像' COLLATE 'utf8mb4_general_ci',
	`create_time` INT(11) NULL DEFAULT NULL COMMENT '领红包的时间',
	PRIMARY KEY (`id`) USING BTREE
)
COMMENT='天天领红包纪录\r\n'
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=20
;
CREATE TABLE `yq_wheel_config` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`activity_time` TEXT(65535) NOT NULL COLLATE 'utf8_general_ci',
	`activity_explain` TEXT(65535) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`everyday` INT(11) NOT NULL DEFAULT '0',
	`status` INT(11) NOT NULL DEFAULT '0',
	`level1_prob` FLOAT(4,2) NOT NULL DEFAULT '0.00',
	`level2_prob` FLOAT(4,2) NOT NULL DEFAULT '0.00',
	`level3_prob` FLOAT(4,2) NOT NULL DEFAULT '0.00',
	`level4_prob` FLOAT(4,2) NOT NULL DEFAULT '0.00',
	`level5_prob` FLOAT(4,2) NOT NULL DEFAULT '0.00',
	`level6_prob` FLOAT(4,2) NOT NULL DEFAULT '0.00',
	`level1_store` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`level2_store` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`level3_store` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`level4_store` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`level5_store` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`level6_store` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8_general_ci',
	`level1_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`level2_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`level3_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`level4_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`level5_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`level6_price` DECIMAL(10,2) NOT NULL DEFAULT '0.00',
	`level1_type` TINYINT(4) NOT NULL DEFAULT '0',
	`level2_type` TINYINT(4) NOT NULL DEFAULT '0',
	`level3_type` TINYINT(4) NOT NULL DEFAULT '0',
	`level4_type` TINYINT(4) NOT NULL DEFAULT '0',
	`level5_type` TINYINT(4) NOT NULL DEFAULT '0',
	`level6_type` TINYINT(4) NOT NULL DEFAULT '0',
	`time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
ROW_FORMAT=DYNAMIC
AUTO_INCREMENT=3
;
CREATE TABLE `yq_wheel_record` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`wheel_status` TINYINT(4) NOT NULL DEFAULT '0' COMMENT '0未使用1已抽奖',
	`user_id` INT(11) NOT NULL,
	`level_store` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`prize_type` TINYINT(4) NULL DEFAULT '0' COMMENT '0手动发奖1神秘红包',
	`send_status` TINYINT(4) NULL DEFAULT '0' COMMENT '0未发放1已发放',
	`send_time` INT(11) NULL DEFAULT NULL,
	`from_nickname` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`from_uid` INT(11) NULL DEFAULT NULL,
	`from_type` TINYINT(4) NULL DEFAULT '0' COMMENT '0来自系统1分享好友2做任务3升级年费4好友助力5浏览任务',
	`from_avatar` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`create_time` INT(11) NULL DEFAULT NULL COMMENT '获得机会时间',
	`wheel_time` INT(11) NULL DEFAULT NULL COMMENT '抽奖时间',
	`wheel_expire_time` INT(11) NULL DEFAULT NULL COMMENT '抽奖过期时间',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=147
;

<?php

namespace app\api\controller;

use app\common\enum\HbRecordFromEnum;
use app\common\service\HbEverydayService;
use app\common\service\WheelService;
use itholiday\util\AesUtil;
use think\db\Where;
use think\Loader;

/**
 * 天天领红包
 * Class HbEveryday
 * @package app\api\controller
 */
class HbEveryday extends Apibase
{
   
   
    private $config;

    public function initialize()
    {
   
   
        parent::initialize();
        $this->config = cmf_get_option('hb_setting');
        if (!$this->config['activity_switch']) $this->resultdata(['0', '活动未开启']);
    }

    /**
     * 进入活动页，初始化页面
     * 抽一次奖 需要约定生成秘钥，每个秘钥只能使用一次，每次抽奖机会由后台发送通知，前台凭后台发的秘钥进行验证、抽一次奖
     */
    public function pageinit()
    {
   
   
        try {
   
   
            $info = HbEverydayService::getHbsn($this->user);
        } catch (\Exception $e) {
   
   
            $this->resultdata(['0', $e->getMessage()]);
        }
        if ($info['code'] == 0) $this->resultdata(['0', $info['msg']]);
        $this->resultdata(['1', 'ok'], $info);
    }

    /**
     * 配置
     */
    public function pageconfig()
    {
   
   
        $hbsn = input('hbsn');
        if (empty($hbsn)) $this->resultdata(['0', '参数错误']);
        $data['read_task_sec'] = $this->config['read_task_sec'];
        $data['activity_explain'] = htmlspecialchars_decode($this->config['activity_explain']);
        $takeData = db(