小程序·刮刮卡抽奖简单设计

刮刮卡&幸运大转盘抽奖的流程：

用户获取刮刮卡上的抽奖码
在小程序上录入抽奖码获取抽奖机会（可累加多次抽奖机会后再抽奖）
用户点击幸运大转盘进行抽奖
用户中奖后进行兑奖
到期不兑奖则视为过期

支持设置某个奖品为兜底奖品，如果有奖品被设置为兜底奖品，则视为100%中奖。

如果设置了多个奖品的总中奖概率为100%，则必须设置其中一个奖品为兜底奖品，否则其中一个奖品数量变为0时，无法继续抽奖，这种属于运营操作错误

微信小程序SDK

使用 PowerWeChat SDK

PowerWeChat是一款简单易用的WeChat SDK for Golang，目前已经覆盖微信公众号、微信小程序、微信支付、企业微信。

对标PHP版的easywechat，优点：由Artisan Cloud团队长期维护、文档详细等

数据库表设计

CREATE TABLE `mini_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '微信小程序用户表id',
  `unionid` varchar(50) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '用户在开放平台的唯一标识',
  `openid` varchar(50) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '用户在某个小程序的唯一标识',
  `session_key` varchar(50) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '小程序会话密钥',
  `nickname` varchar(30) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '用户昵称',
  `avatar_url` varchar(255) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '用户头像',
  `handset` varchar(30) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '手机号（国外手机号会有区号）',
  `country_code` varchar(10) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '手机区号,',
  `last_login_at` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '最后登录IP',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invite_staff_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '最新邀请员工ID',
  `invite_at` datetime DEFAULT NULL COMMENT '最新邀请时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_unionid` (`unionid`),
  KEY `index_created_at` (`created_at`),
  KEY `i_openid` (`openid`),
  KEY `i_handset` (`handset`),
  KEY `idx_mini_user_invite_staff_id` (`invite_staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_callback` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '微信小程序回调记录表id',
  `msg_type` varchar(20) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '',
  `event` varchar(50) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '',
  `change_type` varchar(50) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '',
  `data` text COLLATE utf8mb4_0900_as_cs COMMENT 'query body',
  `query_string` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_as_cs COMMENT 'URL query string',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `i_me` (`msg_type`,`event`),
  KEY `i_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lottery_activity` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '活动表id',
  `name` varchar(256) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '活动名称',
  `start_at` datetime DEFAULT NULL COMMENT '开始时间，null则是没时间限制',
  `end_at` datetime DEFAULT NULL COMMENT '结束时间，null则是没时间限制',
  `rule` text COLLATE utf8mb4_0900_as_cs NOT NULL COMMENT '活动规则',
  `staff_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '操作员工ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lottery_prize` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '奖品表ID',
  `activity_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '归属活动ID',
  `name` varchar(100) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '奖品名称',
  `image` json DEFAULT NULL COMMENT '奖品图片',
  `probability` bigint NOT NULL DEFAULT '0' COMMENT '中奖概率（百分号前面的数字*100）',
  `is_default` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否作为兜底奖品，0-否，1-是',
  `total` bigint NOT NULL DEFAULT '0' COMMENT '奖品总数',
  `surplus` bigint NOT NULL DEFAULT '0' COMMENT '剩余奖品数量',
  `is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否上架',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_mini_lottery_prize_activity_id` (`activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lucky_code_all` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '全量抽奖码表id，方便表mini_lucky_code生成不连串的抽奖码',
  `code` char(6) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '抽奖码，如AA1234',
  `is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可用，0-已被用过，1-可用',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lucky_code` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '抽奖码表id',
  `activity_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '归属活动ID',
  `code` char(6) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '抽奖码',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `batch` varchar(30) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '批次',
  `is_enable` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否可用，0-已被用过，1-可用',
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_code` (`code`),
  KEY `i_batch` (`batch`),
  KEY `i_ac` (`activity_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lottery_record` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '用户抽奖记录表id',
  `activity_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '归属活动ID',
  `user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'mini_user表ID',
  `prize_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '中奖奖品ID',
  `lucky_code` varchar(256) COLLATE utf8mb4_0900_as_cs NOT NULL DEFAULT '' COMMENT '抽奖码',
  `status` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '抽奖状态，0-未抽奖，1-未中奖，2-待兑奖，3-已兑奖，4-已过期',
  `draw_at` datetime DEFAULT NULL COMMENT '抽奖时间',
  `remark` varchar(200) COLLATE utf8mb4_0900_as_cs DEFAULT '' COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '获取抽奖机会时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `invite_staff_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '邀请员工ID',
  PRIMARY KEY (`id`),
  KEY `idx_mini_lottery_record_user_id` (`user_id`),
  KEY `idx_mini_lottery_record_lucky_code` (`lucky_code`),
  KEY `idx_mini_lottery_record_out_id` (`out_id`),
  KEY `i_au` (`activity_id`,`user_id`),
  KEY `idx_mini_lottery_record_invite_staff_id` (`invite_staff_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lottery_user` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '抽奖用户统计表id',
  `activity_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '归属活动ID',
  `user_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT 'mini_user表ID',
  `surplus_num` bigint NOT NULL DEFAULT '0' COMMENT '剩余抽奖次数(总抽奖机会=抽奖次数+剩余抽奖次数)',
  `draw_num` bigint NOT NULL DEFAULT '0' COMMENT '抽奖次数',
  `win_num` bigint NOT NULL DEFAULT '0' COMMENT '中奖次数',
  `award_num` bigint NOT NULL DEFAULT '0' COMMENT '兑奖次数',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_au` (`activity_id`,`user_id`),
  KEY `idx_mini_lottery_user_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

CREATE TABLE `mini_lottery_report` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '抽奖数据统计报表ID',
  `activity_id` bigint unsigned NOT NULL DEFAULT '0' COMMENT '活动ID',
  `report_at` date DEFAULT NULL COMMENT '统计日期',
  `player_num` bigint NOT NULL DEFAULT '0' COMMENT '参与人数',
  `draw_num` bigint NOT NULL DEFAULT '0' COMMENT '抽奖次数',
  `winner_num` bigint NOT NULL DEFAULT '0' COMMENT '中奖人数',
  `win_num` bigint NOT NULL DEFAULT '0' COMMENT '中奖次数',
  `awarder_num` bigint NOT NULL DEFAULT '0' COMMENT '兑奖人数',
  `award_num` bigint NOT NULL DEFAULT '0' COMMENT '兑奖次数',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_ar` (`activity_id`,`report_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_as_cs;

抽奖代码逻辑

var activityId uint64 = 1 // 抽奖活动ID，支持多个抽奖活动的代码复用

// 抽奖参与状态
type LotteryStatus uint8
const (
    LotteryStatusDefault LotteryStatus = iota // 未抽奖
    LotteryStatusLose                         // 未中奖
    LotteryStatusWait                         // 已中奖-待兑奖
    LotteryStatusSuccess                      // 已中奖-已兑奖
    LotteryStatusExpired                      // 已中奖-已过期
)

// 最大概率值，百分号前面的数字*100，兼容2位小数，如30.22%）
const MaxPrizeProbability = 10000

// 未中奖设置
const (
    LosePrizeId       uint64 = 0                                  // 未中奖奖品ID
    LosePrizeName            = "未中奖"                              // 名称
    LosePrizeImageUrl        = "https://xxx/weizhongjiangtmp.jpg" // 未中奖图片
)

// 奖品概率范围
type PrizeProbabilityRange struct {
    Min int
    Max int
}

// 获取抽奖结果
func Result() (uint64, error) {
    // 奖品判断
    var (
        currentProbabilityTotal  int                                      // 当前奖品总概率
        originalProbabilityTotal int                                      // 初始奖品总概率
        isDefault                bool                                     // 是否有兜底奖品
        defaultPrizeId           = LosePrizeId                            // 兜底奖品ID或未中奖ID
        surplusTotal             int64                                    // 总剩余奖品数量
        prizeMap                 = make(map[uint64]PrizeProbabilityRange) // 奖品概率范围
        winPrizeId               uint64                                   // 中奖奖品ID
    )
    prizes := dao.MiniLotteryPrizeDao.GetList(activityId) // 获取活动的所有上架奖品列表
    if len(prizes) == 0 {
        return winPrizeId, errors.New("尚未配置奖池")
    }
    for _, v := range prizes {
        // 兜底奖品设置的 奖品概率 和 奖品数量 直接忽略，当做未中奖项处理
        if v.IsDefault {
            isDefault = true
            defaultPrizeId = v.Id
            continue
        }

        originalProbabilityTotal += v.Probability

        // 数量为零的奖品不参与抽奖
        if v.Surplus <= 0 {
            continue
        }

        surplusTotal += v.Surplus
        min := currentProbabilityTotal
        currentProbabilityTotal += v.Probability
        max := currentProbabilityTotal - 1
        prizeMap[v.Id] = PrizeProbabilityRange{
            Min: min,
            Max: max,
        }
    }
    if currentProbabilityTotal > MaxPrizeProbability {
        return winPrizeId, errors.New("奖池设置异常，暂无法抽奖")
    }
    if originalProbabilityTotal == MaxPrizeProbability && currentProbabilityTotal != originalProbabilityTotal {
        // 如果设置了多个奖品的总中奖概率为100%，则必须设置其中一个奖品为兜底奖品，否则其中一个奖品数量变为0时，无法继续抽奖，这种属于运营操作错误
        return winPrizeId, errors.New("奖池设置异常，暂无法抽奖哟")
    }
    if currentProbabilityTotal < MaxPrizeProbability {
        prizeMap[defaultPrizeId] = PrizeProbabilityRange{
            Min: currentProbabilityTotal,
            Max: MaxPrizeProbability - 1,
        }
    }
    if !isDefault && surplusTotal <= 0 {
        return winPrizeId, errors.New("来的太晚啦，奖品已经派完")
    }

    // 抽奖
    rand.Seed(time.Now().UnixNano())
    random := rand.Intn(MaxPrizeProbability)
    for prizeId, v := range prizeMap {
        if v.Min <= random && v.Max >= random {
            winPrizeId = prizeId
            break
        }
    }

    // 再次确认中奖奖品是否有库存，没有库存则设置为兜底奖品或未中奖
    if winPrizeId > 0 && winPrizeId != defaultPrizeId {
        prize := dao.MiniLotteryPrizeDao.GetById(winPrizeId)
        if prize.Surplus <= 0 || !prize.IsEnable {
            winPrizeId = defaultPrizeId
        }
    }
    return winPrizeId, nil
}

// 获取所有奖品
type (
    MiniLotteryPrizeImage struct {
        Win  string `json:"win"`  // 获奖展示图片
        Word string `json:"word"` // 带文字的图片
    }

    MiniLotteryActivityPrize struct {
        Id    uint64                 `json:"id"`
        Name  string                 `json:"name"`
        Image *MiniLotteryPrizeImage `json:"image"`
    }
)
func GetPrizes(activityId uint64) (MiniLotteryActivityPrize, error) {
    var (
        isDefault        bool // 是否有兜底奖品
        probabilityTotal int // 奖品中奖总概率
        resp = make([]MiniLotteryActivityPrize, 0)
    )
    prizes := dao.MiniLotteryPrizeDao.GetList(activityId)
    if len(prizes) == 0 {
        return resp, errors.New("尚未配置奖池")
    }
    for _, v := range prizes {
        probabilityTotal += v.Probability
        if v.IsDefault {
            isDefault = true
        }
        resp = append(resp, MiniLotteryActivityPrize{
            Id:    v.Id,
            Name:  v.Name,
            Image: v.Image,
        })
    }
    // 判断是否有未中奖的情况，有则追加上未中奖数据
    if !isDefault && probabilityTotal < MaxPrizeProbability {
        resp = append(resp, MiniLotteryActivityPrize{
            Id:   LosePrizeId,
            Name: LosePrizeName,
            Image: &MiniLotteryPrizeImage{
                Win:  LosePrizeImageUrl,
                Word: LosePrizeImageUrl,
            },
        })
    }
    return resp, nil
}

生成抽奖码代码

type MiniLuckyCodeAll struct {
    Id        uint64          `gorm:"comment:全量抽奖码表id;" json:"id"`
    Code      string          `gorm:"type:char(6);not null;default:'';comment:抽奖码;uniqueIndex:u_code;" json:"code"`
    IsEnable  bool            `gorm:"not null;default:1;comment:是否可用，0-已被用过，1-可用" json:"is_use"`
}

// 脚本一次性生成所需抽奖码入库
func GenerateLotteryLuckyCode() {
    var (
        prefix        = "AA" // 抽奖码总共6位，预先设定前两位数
        str           = "ABCDEFGHIJKLMNPQRSTUVWXYZ123456789" // 去掉容易混淆的字母O和数字0
        bytes         = []byte(str)
        luckCodeSlice = make([]MiniLuckyCodeAll, 0)
        startAt       = time.Now()
    )
    for _, v1 := range bytes {
        for _, v2 := range bytes {
            for _, v3 := range bytes {
                for _, v4 := range bytes {
                    var code = []byte{v1, v2, v3, v4}
                    luckCodeSlice = append(luckCodeSlice, MiniLuckyCodeAll{
                        Code:     prefix + string(code),
                        IsEnable: true,
                    })
                }
            }

            // 一次性入库一千多个抽奖码
            if err := dao.MiniLuckyCodeDao.BatchCreateLuckyCodeAll(luckCodeSlice); err != nil {
                logger.Sugar.Error(err)
                break
            }

            luckCodeSlice = luckCodeSlice[:0]
        }
    }
    logger.Sugar.Infof("开始时间：%s", startAt.Format("2006-01-02 15:04:05"))
    logger.Sugar.Infof("结束时间：%s", time.Now().Format("2006-01-02 15:04:05"))
}

微信小程序SDK

数据库表设计

抽奖代码逻辑

生成抽奖码代码

Recommend

《百萬同居計劃》全集无广告免费观看-热播电视剧-雷神影院

让游戏公司震惊！可微调效果，AI画出高品质游戏美术素材了

Many EA games are borked on Steam Deck, but fixes are on the way

快过年了，要买酒回家了，自己家喝，也买给大伯、小叔家喝，太贵的买不起，泸州老窖 6...

ChatGPT 还没有大家想象的那么恐怖，不要慌

FDA表示培养肉可以安全食用，但它是否健康？

有没有可能在 ios 查看/控制 mac 锁屏？

《双面狐》免费观看在线完整版播放-高分电影-雷神影院

Best Apps To Buy Bitcoin

Question - modded gcam? | XDA Forums

About Joyk