admin.go 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351
  1. package service
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "log"
  7. "regexp"
  8. "strconv"
  9. "strings"
  10. "time"
  11. "github.com/gin-gonic/gin"
  12. "github.com/mhaya/game/game_cluster/internal/constant"
  13. "github.com/mhaya/game/game_cluster/internal/mdb"
  14. "github.com/mhaya/game/game_cluster/internal/mdb/models"
  15. "github.com/mhaya/game/game_cluster/nodes/webadmin/entity"
  16. "github.com/mhaya/game/game_cluster/nodes/webadmin/model"
  17. "go.mongodb.org/mongo-driver/bson"
  18. "go.mongodb.org/mongo-driver/bson/primitive"
  19. "go.mongodb.org/mongo-driver/mongo"
  20. "go.mongodb.org/mongo-driver/mongo/options"
  21. "golang.org/x/crypto/bcrypt"
  22. )
  23. type Admin struct {
  24. db *mongo.Database
  25. }
  26. func NewAdmin() *Admin {
  27. return &Admin{
  28. db: mdb.MDB,
  29. }
  30. }
  31. func (a *Admin) GetDB() *mongo.Database {
  32. return a.db
  33. }
  34. func (a *Admin) GetDBName() string {
  35. return "admin"
  36. }
  37. func CheckPasswordHash(password, hash string) bool {
  38. err := bcrypt.CompareHashAndPassword([]byte(hash), []byte(password))
  39. return err == nil
  40. }
  41. // HashPassword 加密密码
  42. func HashPassword(password string) (string, error) {
  43. bytes, err := bcrypt.GenerateFromPassword([]byte(password), 14)
  44. return string(bytes), err
  45. }
  46. // Login 登录
  47. func (a *Admin) Login(ctx *gin.Context, username string, password string) (*entity.AdminResp, error) {
  48. user, err := a.QueryUserByUsername(ctx, username)
  49. if err != nil {
  50. log.Printf("Failed to query user: %s", err)
  51. return nil, fmt.Errorf("failed to query user: %s", err)
  52. }
  53. // 判断用户状态
  54. if user.Status == 0 {
  55. log.Println("User is disabled")
  56. return nil, errors.New("user is disabled")
  57. }
  58. // 判断密码
  59. if !CheckPasswordHash(password, user.Password) {
  60. log.Println("Invalid username or password")
  61. return nil, errors.New("invalid username or password")
  62. }
  63. // 创建token
  64. generateToken, err := user.GenerateToken()
  65. if err != nil {
  66. return nil, err
  67. }
  68. // 保存token 到 redis 中 过期时间为1天
  69. err = mdb.RDB.Set(ctx, generateToken, user.Username, 24*time.Hour).Err()
  70. if err != nil {
  71. return nil, err
  72. }
  73. err = a.loginAuthSetRoleRedis(user.RoleId, generateToken)
  74. if err != nil {
  75. return nil, err
  76. }
  77. // 更新用户登录时间
  78. _, err = mdb.MDB.Collection(a.GetDBName()).UpdateOne(ctx, bson.M{"username": username}, bson.M{"$set": bson.M{"last_login_time": time.Now().Unix()}})
  79. log.Printf("Login successful for user: %s", username)
  80. if err != nil {
  81. return nil, err
  82. }
  83. // 更新用户IP
  84. ip := ctx.ClientIP()
  85. _, err = mdb.MDB.Collection(a.GetDBName()).UpdateOne(ctx, bson.M{"username": username}, bson.M{"$set": bson.M{"last_login_ip": ip}})
  86. // 返回用户信息
  87. log.Printf("Returning user: %s", username)
  88. return &entity.AdminResp{
  89. ToKen: generateToken,
  90. }, nil
  91. }
  92. // LoginAuthSetRoleRedis 登录时写入该用户的权限
  93. func (a *Admin) loginAuthSetRoleRedis(roleID, generateToken string) error {
  94. if roleID == constant.AdminAccess {
  95. mdb.RDB.HSet(context.Background(), "admin::token::"+generateToken, constant.AdminAccess, 1)
  96. return nil
  97. }
  98. // 写入redis
  99. role := models.Roles{}
  100. collection := mdb.MDB.Collection(role.TableName())
  101. roleIdObj, _ := primitive.ObjectIDFromHex(roleID)
  102. filter := bson.M{"_id": roleIdObj, "status": 1}
  103. err := collection.FindOne(context.TODO(), filter).Decode(&role)
  104. if err != nil {
  105. return err
  106. }
  107. roleAccess := models.RoleAccess{}
  108. collection = mdb.MDB.Collection(roleAccess.TableName())
  109. roleAccessFilter := bson.M{"role_id": roleID}
  110. err = collection.FindOne(context.TODO(), roleAccessFilter).Decode(&roleAccess)
  111. if err != nil {
  112. return err
  113. }
  114. // 写入redis
  115. var accessIDS []primitive.ObjectID
  116. for _, v := range roleAccess.AccessID {
  117. accessIdObj, _ := primitive.ObjectIDFromHex(v)
  118. accessIDS = append(accessIDS, accessIdObj)
  119. }
  120. access := models.Access{}
  121. var accessList []models.Access
  122. collection = mdb.MDB.Collection(access.TableName())
  123. accessFilter := bson.M{"_id": bson.M{"$in": accessIDS}}
  124. cursor, err := collection.Find(context.Background(), accessFilter)
  125. if err != nil {
  126. return err
  127. }
  128. if err = cursor.All(context.Background(), &accessList); err != nil {
  129. return err
  130. }
  131. for _, v := range accessList {
  132. mdb.RDB.HSet(context.Background(), "admin::token::"+generateToken, v.URL, 1)
  133. }
  134. return nil
  135. }
  136. // QueryUserByUsername 根据用户名查询用户
  137. func (a *Admin) QueryUserByUsername(ctx context.Context, username string) (*model.Admin, error) {
  138. admin := &model.Admin{}
  139. err := mdb.MDB.Collection(a.GetDBName()).FindOne(ctx, bson.M{"username": username}).Decode(&admin)
  140. if errors.Is(err, mongo.ErrNoDocuments) && username == "admin" {
  141. // 如果是admin 登录的话 创建一个初始的admin并且存入数据库
  142. pwd, err := HashPassword("123456")
  143. if err != nil {
  144. return nil, err
  145. }
  146. admin = &model.Admin{
  147. Username: constant.AdminAccess,
  148. Password: pwd,
  149. RealName: constant.AdminAccess,
  150. Pid: 0,
  151. RoleId: constant.AdminAccess,
  152. ManagerAuth: 0,
  153. Status: 1,
  154. CreatedAt: 0,
  155. UpdatedAt: 0,
  156. DeletedAt: 0,
  157. LastLoginIp: "",
  158. LastLoginTime: 0,
  159. }
  160. _, err = mdb.MDB.Collection(a.GetDBName()).InsertOne(ctx, bson.M{
  161. "username": constant.AdminAccess,
  162. "password": pwd,
  163. "real_name": constant.AdminAccess,
  164. "pid": 0,
  165. "role_id": constant.AdminAccess,
  166. "status": 1,
  167. })
  168. if err != nil {
  169. return nil, err
  170. }
  171. return admin, nil
  172. }
  173. if err != nil {
  174. return nil, err
  175. }
  176. return admin, nil
  177. }
  178. // ChangePassword 修改管理员密码
  179. func (a *Admin) ChangePassword(ctx context.Context, username string, password string) error {
  180. // 更新密码
  181. password, _ = HashPassword(password)
  182. _, err := mdb.MDB.Collection(a.GetDBName()).UpdateOne(ctx, bson.M{"username": username}, bson.M{"$set": bson.M{"password": password}})
  183. if err != nil {
  184. return err
  185. }
  186. return nil
  187. }
  188. // Add 添加管理员
  189. func (a *Admin) Add(ctx context.Context, username string, password string, realName string, pid int64, roleId int64, status int) error {
  190. // 判断账号是否重复
  191. admin := model.Admin{}
  192. err := mdb.MDB.Collection(a.GetDBName()).FindOne(ctx, bson.M{"username": username}).Decode(&admin)
  193. if errors.Is(err, mongo.ErrNoDocuments) {
  194. password, _ = HashPassword(password)
  195. _, err := mdb.MDB.Collection(a.GetDBName()).InsertOne(ctx, &model.Admin{
  196. Username: username,
  197. Password: password,
  198. RealName: realName,
  199. Pid: pid,
  200. RoleId: strconv.FormatInt(roleId, 10),
  201. Status: status,
  202. CreatedAt: time.Now().Unix(),
  203. UpdatedAt: time.Now().Unix(),
  204. DeletedAt: 0,
  205. LastLoginIp: "",
  206. LastLoginTime: 0,
  207. })
  208. if err != nil {
  209. return err
  210. }
  211. return nil
  212. }
  213. return fmt.Errorf("账号已存在")
  214. }
  215. // Delete 删除管理员
  216. func (a *Admin) Delete(ctx context.Context, username string) error {
  217. _, err := mdb.MDB.Collection(a.GetDBName()).DeleteOne(ctx, bson.M{"username": username})
  218. if err != nil {
  219. return err
  220. }
  221. return nil
  222. }
  223. // UpdateStatus updateStatus
  224. func (a *Admin) UpdateStatus(ctx context.Context, username string, status int) error {
  225. _, err := mdb.MDB.Collection(a.GetDBName()).UpdateOne(ctx, bson.M{"username": username}, bson.M{"$set": bson.M{"status": status}})
  226. if err != nil {
  227. return err
  228. }
  229. return nil
  230. }
  231. // FindAll 查找所有管理员信息
  232. func (a *Admin) FindAll(ctx context.Context, page int, pageSize int, username string) ([]*model.Admin, int64, error) {
  233. // 日志记录
  234. log.Printf("Finding admins with page %d and page size %d, username: %s", page, pageSize, maskUsername(username))
  235. // 验证参数
  236. if page <= 0 {
  237. page = 1
  238. }
  239. if pageSize <= 0 {
  240. pageSize = 10
  241. }
  242. // 构建查询条件
  243. filter := bson.M{}
  244. if username != "" {
  245. filter["username"] = bson.M{"$regex": escapeRegex(username), "$options": "i"}
  246. }
  247. // 查询总数
  248. count, err := mdb.MDB.Collection("admin").CountDocuments(ctx, filter)
  249. if err != nil {
  250. return nil, 0, err
  251. }
  252. // 设置分页选项
  253. skip := (page - 1) * pageSize
  254. limit := pageSize
  255. findOptions := options.Find().SetSkip(int64(skip)).SetLimit(int64(limit))
  256. // 执行查询
  257. cursor, err := mdb.MDB.Collection("admin").Find(ctx, filter, findOptions)
  258. if err != nil {
  259. return nil, 0, err
  260. }
  261. defer func() {
  262. if closeErr := cursor.Close(ctx); closeErr != nil {
  263. log.Printf("Error closing cursor: %v", closeErr)
  264. }
  265. }()
  266. // 解析结果
  267. admins := make([]*model.Admin, 0)
  268. for cursor.Next(ctx) {
  269. var admin model.Admin
  270. err := cursor.Decode(&admin)
  271. if err != nil {
  272. return nil, 0, err
  273. }
  274. admins = append(admins, &admin)
  275. }
  276. if err := cursor.Err(); err != nil {
  277. return nil, 0, err
  278. }
  279. return admins, count, nil
  280. }
  281. // GetServerStatus 获取服务器状态
  282. func (a *Admin) GetServerStatus(ctx context.Context) ([]*models.PlayerServerLoadStat, error) {
  283. // 执行查询
  284. cursor, err := mdb.MDB.Collection(constant.CNameServerLoadStat).Find(ctx, bson.M{})
  285. if err != nil {
  286. return nil, err
  287. }
  288. defer func() {
  289. if closeErr := cursor.Close(ctx); closeErr != nil {
  290. log.Printf("Error closing cursor: %v", closeErr)
  291. }
  292. }()
  293. // 解析结果
  294. admins := make([]*models.PlayerServerLoadStat, 0)
  295. for cursor.Next(ctx) {
  296. var admin models.PlayerServerLoadStat
  297. err := cursor.Decode(&admin)
  298. if err != nil {
  299. return nil, err
  300. }
  301. admins = append(admins, &admin)
  302. }
  303. if err := cursor.Err(); err != nil {
  304. return nil, err
  305. }
  306. return admins, nil
  307. }
  308. // 辅助函数:对 username 进行脱敏处理
  309. func maskUsername(username string) string {
  310. if username == "" {
  311. return ""
  312. }
  313. return strings.Repeat("*", len(username))
  314. }
  315. // 辅助函数:对正则表达式进行转义
  316. func escapeRegex(s string) string {
  317. return regexp.QuoteMeta(s)
  318. }