邹方成
16e2ede037
refactor(orders): 重构订单列表查询逻辑，支持按消耗状态筛选 feat(orders): 订单列表返回新增活动分类与玩法类型信息 fix(orders): 修复订单支付时间空指针问题 docs(swagger): 更新订单相关接口文档 test(matching): 添加对对碰奖励匹配测试用例 chore: 清理无用脚本文件
62 lines
2.4 KiB
SQL
62 lines
2.4 KiB
SQL
-- 对对碰奖励测试数据
|
||
-- 前提：需要先有一个活动和期次
|
||
-- 假设期次ID为 ? (请根据实际情况替换)
|
||
|
||
-- 查看现有期次
|
||
-- SELECT id, activity_id, issue_number FROM activity_issues ORDER BY id DESC LIMIT 10;
|
||
|
||
-- 设置期次ID (请替换为实际的期次ID)
|
||
SET @issue_id = 1;
|
||
|
||
-- 清理该期次下的旧奖励数据（谨慎使用）
|
||
-- DELETE FROM activity_reward_settings WHERE issue_id = @issue_id;
|
||
|
||
-- 插入对对碰奖励测试数据
|
||
-- 每个 min_score 对应一个奖品，精确匹配
|
||
INSERT INTO activity_reward_settings
|
||
(issue_id, product_id, name, weight, quantity, original_qty, level, sort, is_boss, min_score, created_at, updated_at)
|
||
VALUES
|
||
-- 0-10对：参与奖
|
||
(@issue_id, 0, '参与奖-5对', 0, 100, 100, 10, 1, 0, 5, NOW(), NOW()),
|
||
(@issue_id, 0, '参与奖-10对', 0, 100, 100, 9, 2, 0, 10, NOW(), NOW()),
|
||
|
||
-- 10-20对：铜奖
|
||
(@issue_id, 0, '铜奖-15对', 0, 50, 50, 8, 3, 0, 15, NOW(), NOW()),
|
||
(@issue_id, 0, '铜奖-20对', 0, 50, 50, 7, 4, 0, 20, NOW(), NOW()),
|
||
|
||
-- 20-30对：银奖
|
||
(@issue_id, 0, '银奖-25对', 0, 30, 30, 6, 5, 0, 25, NOW(), NOW()),
|
||
(@issue_id, 0, '银奖-30对', 0, 30, 30, 5, 6, 0, 30, NOW(), NOW()),
|
||
|
||
-- 30-40对：金奖
|
||
(@issue_id, 0, '金奖-35对', 0, 20, 20, 4, 7, 0, 35, NOW(), NOW()),
|
||
(@issue_id, 0, '金奖-40对', 0, 20, 20, 3, 8, 0, 40, NOW(), NOW()),
|
||
|
||
-- 40-45对：特等奖
|
||
(@issue_id, 0, '特等奖-42对', 0, 10, 10, 2, 9, 0, 42, NOW(), NOW()),
|
||
(@issue_id, 0, '特等奖-44对', 0, 5, 5, 1, 10, 0, 44, NOW(), NOW()),
|
||
|
||
-- 45对以上：大奖（理论最大45-49对）
|
||
(@issue_id, 0, '终极大奖-45对', 0, 3, 3, 0, 11, 1, 45, NOW(), NOW());
|
||
|
||
-- 验证插入的数据
|
||
SELECT id, issue_id, name, min_score, quantity, level, sort
|
||
FROM activity_reward_settings
|
||
WHERE issue_id = @issue_id
|
||
ORDER BY min_score ASC;
|
||
|
||
-- ================================================================
|
||
-- 使用说明:
|
||
-- 1. 将 @issue_id 替换为实际用于对对碰测试的期次ID
|
||
-- 2. 执行此脚本插入测试数据
|
||
-- 3. 通过APP或接口测试对对碰游戏
|
||
-- 4. 验证不同对子数是否匹配到正确的奖品
|
||
--
|
||
-- 测试用例:
|
||
-- - 消除5对 → 获得 "参与奖-5对"
|
||
-- - 消除10对 → 获得 "参与奖-10对"
|
||
-- - 消除15对 → 获得 "铜奖-15对"
|
||
-- - 消除12对 → 无匹配（因为是精确匹配）
|
||
-- - 消除45对 → 获得 "终极大奖-45对"
|
||
-- ================================================================
|