admin.go 10 KB

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