65 lines
2.3 KiB
Go
65 lines
2.3 KiB
Go
|
package handler
|
|||
|
|
|
|||
|
|
import (
|
|||
|
|
"github.com/gin-gonic/gin"
|
|||
|
|
|
|||
|
|
"nl-game-api-gin/internal/database"
|
|||
|
|
"nl-game-api-gin/internal/middleware"
|
|||
|
|
"nl-game-api-gin/internal/model"
|
|||
|
|
"nl-game-api-gin/pkg/resp"
|
|||
|
|
)
|
|||
|
|
|
|||
|
|
// rankUser 排行榜条目
|
|||
|
|
type rankUser struct {
|
|||
|
|
UserID int `json:"user_id"` // 用户ID
|
|||
|
|
Nickname string `json:"nickname"` // 昵称
|
|||
|
|
Avatar string `json:"avatar"` // 头像
|
|||
|
|
TotalPoints int `json:"total_points"` // 累计积分
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// PointsRank 积分排行榜（前50） + 我的名次
|
|||
|
|
func PointsRank(c *gin.Context) {
|
|||
|
|
list := make([]rankUser, 0)
|
|||
|
|
database.DB.Table("users").
|
|||
|
|
Select("id AS user_id, nickname, avatar, total_points").
|
|||
|
|
Where("status = 1 AND deleted_at = 0").
|
|||
|
|
Order("total_points DESC, id ASC").Limit(50).Scan(&list)
|
|||
|
|
// 我的名次 = 比我累计积分高的人数 + 1
|
|||
|
|
uid := middleware.UID(c)
|
|||
|
|
var me model.User
|
|||
|
|
database.DB.First(&me, uid)
|
|||
|
|
var higher int64
|
|||
|
|
database.DB.Model(&model.User{}).
|
|||
|
|
Where("status = 1 AND (total_points > ? OR (total_points = ? AND id < ?))", me.TotalPoints, me.TotalPoints, uid).
|
|||
|
|
Count(&higher)
|
|||
|
|
resp.OK(c, gin.H{"list": list, "my_rank": higher + 1, "my_points": me.TotalPoints})
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// gameRankItem 单游戏排行条目
|
|||
|
|
type gameRankItem struct {
|
|||
|
|
UserID int `json:"user_id"` // 用户ID
|
|||
|
|
Nickname string `json:"nickname"` // 昵称
|
|||
|
|
Avatar string `json:"avatar"` // 头像
|
|||
|
|
Best int `json:"best"` // 该游戏最高分
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
// GameRank 指定游戏的最高分排行（每人取最高一条，前50）
|
|||
|
|
func GameRank(c *gin.Context) {
|
|||
|
|
var game model.Game
|
|||
|
|
if err := database.DB.Where("code = ?", c.Param("code")).First(&game).Error; err != nil {
|
|||
|
|
resp.Fail(c, "游戏不存在")
|
|||
|
|
return
|
|||
|
|
}
|
|||
|
|
list := make([]gameRankItem, 0)
|
|||
|
|
database.DB.Raw(`SELECT t.user_id, u.nickname, u.avatar, t.best
|
|||
|
|
FROM (SELECT user_id, MAX(score) AS best FROM game_records WHERE game_id = ? GROUP BY user_id) t
|
|||
|
|
JOIN users u ON u.id = t.user_id AND u.status = 1 AND u.deleted_at = 0
|
|||
|
|
ORDER BY t.best DESC, t.user_id ASC LIMIT 50`, game.ID).Scan(&list)
|
|||
|
|
// 我的最高分
|
|||
|
|
var myBest int
|
|||
|
|
database.DB.Model(&model.GameRecord{}).
|
|||
|
|
Where("user_id = ? AND game_id = ?", middleware.UID(c), game.ID).
|
|||
|
|
Select("COALESCE(MAX(score),0)").Scan(&myBest)
|
|||
|
|
resp.OK(c, gin.H{"game": game, "list": list, "my_best": myBest})
|
|||
|
|
}
|