From 262ce70998fa52dec3120589f51c47e96fb96df4 Mon Sep 17 00:00:00 2001
From: 905086 <k2049@qq.com>
Date: Tue, 03 Nov 2026 17:04:19 +0800
Subject: [PATCH] feat: 完成游戏盒子前后端基础功能开发
---
server/handlers/admin.go | 299 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 299 insertions(+), 0 deletions(-)
diff --git a/server/handlers/admin.go b/server/handlers/admin.go
new file mode 100644
index 0000000..0dfba1c
--- /dev/null
+++ b/server/handlers/admin.go
@@ -0,0 +1,299 @@
+package handlers
+
+import (
+ "fmt"
+ "io"
+ "net/http"
+ "os"
+ "path/filepath"
+ "strconv"
+ "strings"
+ "time"
+
+ "gamebox-server/config"
+ "gamebox-server/models"
+ "gamebox-server/utils"
+
+ "github.com/gin-gonic/gin"
+ "golang.org/x/crypto/bcrypt"
+)
+
+// ---------- 管理员登录 ----------
+
+func AdminLogin(c *gin.Context) {
+ var req struct {
+ Username string `json:"username"`
+ Password string `json:"password"`
+ }
+ if err := c.ShouldBindJSON(&req); err != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "参数错误"})
+ return
+ }
+ var admin models.Admin
+ if err := config.DB.Where("username = ?", req.Username).First(&admin).Error; err != nil ||
+ bcrypt.CompareHashAndPassword([]byte(admin.Password), []byte(req.Password)) != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "用户名或密码错误"})
+ return
+ }
+ token, _ := utils.GenerateToken(admin.ID, admin.Username, "admin")
+ c.JSON(http.StatusOK, gin.H{"code": 0, "data": gin.H{"token": token}})
+}
+
+// ---------- 密钥管理 ----------
+
+// GenerateKeys 批量生成密钥
+func GenerateKeys(c *gin.Context) {
+ var req struct {
+ CardType string `json:"card_type"` // day/month/year
+ Count int `json:"count"`
+ }
+ if err := c.ShouldBindJSON(&req); err != nil || cardDuration(req.CardType) == 0 {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "卡密类型错误"})
+ return
+ }
+ if req.Count < 1 || req.Count > 100 {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "生成数量需在1-100之间"})
+ return
+ }
+ codes := make([]string, 0, req.Count)
+ for i := 0; i < req.Count; i++ {
+ key := models.MemberKey{Code: utils.GenerateKeyCode(), CardType: req.CardType}
+ if err := config.DB.Create(&key).Error; err == nil {
+ codes = append(codes, key.Code)
+ }
+ }
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": fmt.Sprintf("成功生成 %d 个密钥", len(codes)), "data": codes})
+}
+
+// ListKeys 密钥列表
+func ListKeys(c *gin.Context) {
+ keyword := c.Query("keyword")
+ status := c.Query("status") // ""全部 0未使用 1已使用 2已过期
+ query := config.DB.Model(&models.MemberKey{})
+ if keyword != "" {
+ query = query.Where("code LIKE ?", "%"+keyword+"%")
+ }
+ switch status {
+ case "0":
+ query = query.Where("status = ?", 0)
+ case "1":
+ query = query.Where("status = ? AND expired_at > ?", 1, time.Now())
+ case "2":
+ query = query.Where("status = ? AND expired_at <= ?", 1, time.Now())
+ }
+ var total int64
+ query.Count(&total)
+ page, _ := strconv.Atoi(c.DefaultQuery("page", "1"))
+ if page < 1 {
+ page = 1
+ }
+ var keys []models.MemberKey
+ query.Order("id DESC").Offset((page - 1) * 20).Limit(20).Find(&keys)
+ // 附带用户手机号
+ userIDs := make([]uint, 0)
+ for _, k := range keys {
+ if k.UserID > 0 {
+ userIDs = append(userIDs, k.UserID)
+ }
+ }
+ phoneMap := map[uint]string{}
+ if len(userIDs) > 0 {
+ var users []models.User
+ config.DB.Where("id IN ?", userIDs).Find(&users)
+ for _, u := range users {
+ phoneMap[u.ID] = u.Phone
+ }
+ }
+ type keyVO struct {
+ models.MemberKey
+ CardName string `json:"card_name"`
+ Phone string `json:"phone"`
+ Expired bool `json:"expired"`
+ ExpiredAtStr *string `json:"expired_at_str"`
+ }
+ list := make([]keyVO, 0, len(keys))
+ for _, k := range keys {
+ vo := keyVO{MemberKey: k, CardName: k.CardName(), Phone: phoneMap[k.UserID]}
+ if k.ExpiredAt != nil {
+ vo.Expired = k.ExpiredAt.Before(time.Now())
+ s := k.ExpiredAt.Format("2006-01-02 15:04:05")
+ vo.ExpiredAtStr = &s
+ }
+ list = append(list, vo)
+ }
+ c.JSON(http.StatusOK, gin.H{"code": 0, "data": gin.H{"list": list, "total": total, "page": page}})
+}
+
+// ResetKey 管理员重置密钥(解绑机器,可再次使用)
+func ResetKey(c *gin.Context) {
+ id := c.Param("id")
+ var key models.MemberKey
+ if err := config.DB.First(&key, id).Error; err != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "密钥不存在"})
+ return
+ }
+ config.DB.Model(&key).Updates(map[string]interface{}{
+ "status": 0,
+ "user_id": 0,
+ "machine_code": "",
+ "activated_at": nil,
+ "expired_at": nil,
+ })
+ config.DB.Model(&key).UpdateColumn("reset_count", key.ResetCount+1)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "密钥已重置,可重新使用"})
+}
+
+// DeleteKey 删除密钥
+func DeleteKey(c *gin.Context) {
+ config.DB.Delete(&models.MemberKey{}, c.Param("id"))
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "已删除"})
+}
+
+// ---------- 游戏管理 ----------
+
+func AdminListGames(c *gin.Context) {
+ var games []models.Game
+ config.DB.Order("id DESC").Find(&games)
+ fillCategoryName(&games)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "data": games})
+}
+
+func AdminSaveGame(c *gin.Context) {
+ var game models.Game
+ if err := c.ShouldBindJSON(&game); err != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "参数错误: " + err.Error()})
+ return
+ }
+ if game.Title == "" {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "请填写游戏名称"})
+ return
+ }
+ if game.Screenshots == "" {
+ game.Screenshots = "[]"
+ }
+ if game.Files == "" {
+ game.Files = "[]"
+ }
+ if game.ID == 0 {
+ config.DB.Create(&game)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "添加成功", "data": game})
+ } else {
+ config.DB.Model(&models.Game{}).Where("id = ?", game.ID).Updates(map[string]interface{}{
+ "title": game.Title, "category_id": game.CategoryID, "platform": game.Platform,
+ "tags": game.Tags, "size": game.Size, "install_size": game.InstallSize,
+ "os_req": game.OSReq, "cpu_req": game.CPUReq, "gpu_req": game.GPUReq, "ram_req": game.RAMReq,
+ "version_note": game.VersionNote, "cover": game.Cover, "video": game.Video,
+ "screenshots": game.Screenshots, "description": game.Description, "files": game.Files,
+ "is_banner": game.IsBanner,
+ })
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "修改成功"})
+ }
+}
+
+func AdminDeleteGame(c *gin.Context) {
+ config.DB.Delete(&models.Game{}, c.Param("id"))
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "已删除"})
+}
+
+// ---------- 类别管理 ----------
+
+func AdminListCategories(c *gin.Context) {
+ var cats []models.Category
+ config.DB.Order("sort ASC").Find(&cats)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "data": cats})
+}
+
+func AdminSaveCategory(c *gin.Context) {
+ var cat models.Category
+ if err := c.ShouldBindJSON(&cat); err != nil || cat.Name == "" {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "请填写类别名称"})
+ return
+ }
+ if cat.ID == 0 {
+ if err := config.DB.Create(&cat).Error; err != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "该类别已存在"})
+ return
+ }
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "添加成功"})
+ } else {
+ config.DB.Model(&models.Category{}).Where("id = ?", cat.ID).Update("name", cat.Name)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "修改成功"})
+ }
+}
+
+func AdminDeleteCategory(c *gin.Context) {
+ id := c.Param("id")
+ var count int64
+ config.DB.Model(&models.Game{}).Where("category_id = ?", id).Count(&count)
+ if count > 0 {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": fmt.Sprintf("该类别下还有 %d 个游戏,请先移出或删除", count)})
+ return
+ }
+ config.DB.Delete(&models.Category{}, id)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "msg": "已删除"})
+}
+
+// ---------- 上传 ----------
+
+var allowedExts = map[string]bool{
+ ".png": true, ".jpg": true, ".jpeg": true, ".gif": true, ".webp": true,
+ ".mp4": true, ".mkv": true, ".avi": true, ".webm": true,
+ ".zip": true, ".rar": true, ".7z": true, ".exe": true, ".iso": true, ".torrent": true,
+}
+
+// UploadFile 通用文件上传 type: cover/video/image/file
+func UploadFile(c *gin.Context) {
+ file, err := c.FormFile("file")
+ if err != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "请选择文件"})
+ return
+ }
+ ext := strings.ToLower(filepath.Ext(file.Filename))
+ if !allowedExts[ext] {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "不支持的文件类型: " + ext})
+ return
+ }
+ fType := c.DefaultPostForm("type", "file")
+ dir := filepath.Join("uploads", fType)
+ os.MkdirAll(dir, 0755)
+ filename := fmt.Sprintf("%d%s", time.Now().UnixNano(), ext)
+ dst := filepath.Join(dir, filename)
+ if err := c.SaveUploadedFile(file, dst); err != nil {
+ c.JSON(http.StatusOK, gin.H{"code": 1, "msg": "保存文件失败"})
+ return
+ }
+ sizeStr := formatSize(file.Size)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "data": gin.H{
+ "url": "/static/" + fType + "/" + filename,
+ "name": file.Filename,
+ "size": sizeStr,
+ }})
+}
+
+func formatSize(n int64) string {
+ f := float64(n)
+ if f > 1024*1024*1024 {
+ return fmt.Sprintf("%.2f GB", f/1024/1024/1024)
+ }
+ if f > 1024*1024 {
+ return fmt.Sprintf("%.2f MB", f/1024/1024)
+ }
+ return fmt.Sprintf("%.2f KB", f/1024)
+}
+
+// ---------- 统计 ----------
+
+func AdminStats(c *gin.Context) {
+ var users, games, keys, unusedKeys, usedKeys int64
+ config.DB.Model(&models.User{}).Count(&users)
+ config.DB.Model(&models.Game{}).Count(&games)
+ config.DB.Model(&models.MemberKey{}).Count(&keys)
+ config.DB.Model(&models.MemberKey{}).Where("status = ?", 0).Count(&unusedKeys)
+ config.DB.Model(&models.MemberKey{}).Where("status = ?", 1).Count(&usedKeys)
+ c.JSON(http.StatusOK, gin.H{"code": 0, "data": gin.H{
+ "users": users, "games": games, "keys": keys,
+ "unused_keys": unusedKeys, "used_keys": usedKeys,
+ }})
+}
+
+var _ = io.Discard
--
Gitblit v1.10.0