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