userDetailsLoader.go 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359
  1. package loaders
  2. import (
  3. "context"
  4. "encoding/json"
  5. "fmt"
  6. "math"
  7. "perms-system-server/internal/consts"
  8. "perms-system-server/internal/model"
  9. "perms-system-server/internal/model/productmember"
  10. "github.com/zeromicro/go-zero/core/logx"
  11. "github.com/zeromicro/go-zero/core/stores/redis"
  12. "golang.org/x/sync/singleflight"
  13. )
  14. const defaultCacheTTL = 300 // 5 分钟
  15. // -------- UserDetails 及子结构 --------
  16. // UserDetails 用户完整信息,包含用户、部门、产品、成员、角色、权限等所有有效字段。
  17. // 由 UserDetailsLoader 一次性加载,可用于中间件 context 注入、login/userInfo 响应、Claims 构造等。
  18. type UserDetails struct {
  19. // 用户基本信息 (sys_user)
  20. UserId int64 `json:"userId"`
  21. Username string `json:"username"`
  22. Nickname string `json:"nickname"`
  23. Avatar string `json:"avatar"`
  24. Email string `json:"email"`
  25. Phone string `json:"phone"`
  26. Remark string `json:"remark"`
  27. IsSuperAdmin bool `json:"isSuperAdmin"`
  28. IsSuperAdminRaw int64 `json:"isSuperAdminRaw"`
  29. MustChangePassword bool `json:"mustChangePassword"`
  30. MustChangePwdRaw int64 `json:"mustChangePwdRaw"`
  31. Status int64 `json:"status"`
  32. // 部门信息 (sys_dept)
  33. DeptId int64 `json:"deptId"`
  34. DeptName string `json:"deptName"`
  35. DeptPath string `json:"deptPath"`
  36. DeptType string `json:"deptType"`
  37. // 产品上下文 (sys_product)
  38. ProductCode string `json:"productCode"`
  39. ProductName string `json:"productName"`
  40. // 成员信息 (sys_product_member)
  41. MemberType string `json:"memberType"`
  42. // 角色列表 (sys_role,当前产品下已启用的角色)
  43. Roles []RoleInfo `json:"roles"`
  44. // 权限列表 (计算后的权限 code 集合)
  45. Perms []string `json:"perms"`
  46. // 当前产品下最小 permsLevel(无角色时为 math.MaxInt64)
  47. MinPermsLevel int64 `json:"minPermsLevel"`
  48. }
  49. // RoleInfo 角色摘要信息。
  50. type RoleInfo struct {
  51. Id int64 `json:"id"`
  52. Name string `json:"name"`
  53. Remark string `json:"remark"`
  54. PermsLevel int64 `json:"permsLevel"`
  55. }
  56. // -------- UserDetailsLoader --------
  57. // UserDetailsLoader 负责加载、缓存、失效用户详细信息。
  58. // 优先从 Redis 读取完整 UserDetails,miss 时查 DB 并回填。
  59. type UserDetailsLoader struct {
  60. rds *redis.Redis
  61. keyPrefix string
  62. ttl int
  63. models *model.Models
  64. sf singleflight.Group
  65. }
  66. func NewUserDetailsLoader(rds *redis.Redis, keyPrefix string, models *model.Models) *UserDetailsLoader {
  67. return &UserDetailsLoader{
  68. rds: rds,
  69. keyPrefix: keyPrefix,
  70. ttl: defaultCacheTTL,
  71. models: models,
  72. }
  73. }
  74. func (l *UserDetailsLoader) cacheKey(userId int64, productCode string) string {
  75. return fmt.Sprintf("%s:ud:%d:%s", l.keyPrefix, userId, productCode)
  76. }
  77. // Load 根据 userId 和 productCode 加载完整的 UserDetails。
  78. func (l *UserDetailsLoader) Load(ctx context.Context, userId int64, productCode string) *UserDetails {
  79. key := l.cacheKey(userId, productCode)
  80. if val, err := l.rds.GetCtx(ctx, key); err == nil && val != "" {
  81. var ud UserDetails
  82. if err := json.Unmarshal([]byte(val), &ud); err == nil {
  83. return &ud
  84. }
  85. }
  86. v, _, _ := l.sf.Do(key, func() (interface{}, error) {
  87. ud := l.loadFromDB(ctx, userId, productCode)
  88. if val, err := json.Marshal(ud); err == nil {
  89. if err := l.rds.SetexCtx(ctx, key, string(val), l.ttl); err != nil {
  90. logx.WithContext(ctx).Errorf("set user details cache failed: %v", err)
  91. }
  92. }
  93. return ud, nil
  94. })
  95. return v.(*UserDetails)
  96. }
  97. // Del 删除指定用户在指定产品下的缓存。
  98. func (l *UserDetailsLoader) Del(ctx context.Context, userId int64, productCode string) {
  99. key := l.cacheKey(userId, productCode)
  100. if _, err := l.rds.DelCtx(ctx, key); err != nil {
  101. logx.WithContext(ctx).Errorf("del user details cache [%s] failed: %v", key, err)
  102. }
  103. }
  104. // Clean 清除指定用户所有产品下的缓存。
  105. func (l *UserDetailsLoader) Clean(ctx context.Context, userId int64) {
  106. pattern := fmt.Sprintf("%s:ud:%d:*", l.keyPrefix, userId)
  107. l.cleanByPattern(ctx, pattern)
  108. }
  109. // CleanByProduct 清除指定产品下所有用户的缓存。
  110. func (l *UserDetailsLoader) CleanByProduct(ctx context.Context, productCode string) {
  111. pattern := fmt.Sprintf("%s:ud:*:%s", l.keyPrefix, productCode)
  112. l.cleanByPattern(ctx, pattern)
  113. }
  114. // BatchDel 批量删除多个用户在指定产品下的缓存。
  115. func (l *UserDetailsLoader) BatchDel(ctx context.Context, userIds []int64, productCode string) {
  116. if len(userIds) == 0 {
  117. return
  118. }
  119. keys := make([]string, 0, len(userIds))
  120. for _, uid := range userIds {
  121. keys = append(keys, l.cacheKey(uid, productCode))
  122. }
  123. if _, err := l.rds.DelCtx(ctx, keys...); err != nil {
  124. logx.WithContext(ctx).Errorf("batch del user details cache failed: %v", err)
  125. }
  126. }
  127. func (l *UserDetailsLoader) cleanByPattern(ctx context.Context, pattern string) {
  128. var cursor uint64
  129. for {
  130. keys, cur, err := l.rds.ScanCtx(ctx, cursor, pattern, 100)
  131. if err != nil {
  132. logx.WithContext(ctx).Errorf("scan keys [%s] failed: %v", pattern, err)
  133. return
  134. }
  135. if len(keys) > 0 {
  136. if _, err := l.rds.DelCtx(ctx, keys...); err != nil {
  137. logx.WithContext(ctx).Errorf("del keys failed: %v", err)
  138. }
  139. }
  140. if cur == 0 {
  141. return
  142. }
  143. cursor = cur
  144. }
  145. }
  146. // -------- 内部加载逻辑 --------
  147. func (l *UserDetailsLoader) loadFromDB(ctx context.Context, userId int64, productCode string) *UserDetails {
  148. ud := &UserDetails{
  149. UserId: userId,
  150. ProductCode: productCode,
  151. MinPermsLevel: math.MaxInt64,
  152. }
  153. l.loadUser(ctx, ud)
  154. l.loadDept(ctx, ud)
  155. l.loadProduct(ctx, ud)
  156. l.loadMembership(ctx, ud)
  157. l.loadRoles(ctx, ud)
  158. l.loadPerms(ctx, ud)
  159. return ud
  160. }
  161. func (l *UserDetailsLoader) loadUser(ctx context.Context, ud *UserDetails) {
  162. u, err := l.models.SysUserModel.FindOne(ctx, ud.UserId)
  163. if err != nil {
  164. logx.WithContext(ctx).Errorf("userDetailsLoader: query user %d failed: %v", ud.UserId, err)
  165. return
  166. }
  167. ud.Username = u.Username
  168. ud.Nickname = u.Nickname
  169. ud.Avatar = u.Avatar.String
  170. ud.Email = u.Email
  171. ud.Phone = u.Phone
  172. ud.Remark = u.Remark
  173. ud.DeptId = u.DeptId
  174. ud.IsSuperAdminRaw = u.IsSuperAdmin
  175. ud.IsSuperAdmin = u.IsSuperAdmin == consts.IsSuperAdminYes
  176. ud.MustChangePwdRaw = u.MustChangePassword
  177. ud.MustChangePassword = u.MustChangePassword == consts.MustChangePasswordYes
  178. ud.Status = u.Status
  179. }
  180. func (l *UserDetailsLoader) loadDept(ctx context.Context, ud *UserDetails) {
  181. if ud.DeptId == 0 {
  182. return
  183. }
  184. d, err := l.models.SysDeptModel.FindOne(ctx, ud.DeptId)
  185. if err != nil {
  186. logx.WithContext(ctx).Errorf("userDetailsLoader: query dept %d failed: %v", ud.DeptId, err)
  187. return
  188. }
  189. ud.DeptName = d.Name
  190. ud.DeptPath = d.Path
  191. ud.DeptType = d.DeptType
  192. }
  193. func (l *UserDetailsLoader) loadProduct(ctx context.Context, ud *UserDetails) {
  194. if ud.ProductCode == "" {
  195. return
  196. }
  197. p, err := l.models.SysProductModel.FindOneByCode(ctx, ud.ProductCode)
  198. if err != nil {
  199. logx.WithContext(ctx).Errorf("userDetailsLoader: query product %s failed: %v", ud.ProductCode, err)
  200. return
  201. }
  202. ud.ProductName = p.Name
  203. }
  204. func (l *UserDetailsLoader) loadMembership(ctx context.Context, ud *UserDetails) {
  205. if ud.IsSuperAdmin {
  206. ud.MemberType = consts.MemberTypeSuperAdmin
  207. }
  208. if ud.ProductCode == "" {
  209. return
  210. }
  211. if ud.IsSuperAdmin {
  212. return
  213. }
  214. member, err := l.models.SysProductMemberModel.FindOneByProductCodeUserId(ctx, ud.ProductCode, ud.UserId)
  215. if err != nil {
  216. if err != productmember.ErrNotFound {
  217. logx.WithContext(ctx).Errorf("userDetailsLoader: query member failed: %v", err)
  218. }
  219. return
  220. }
  221. ud.MemberType = member.MemberType
  222. }
  223. func (l *UserDetailsLoader) loadRoles(ctx context.Context, ud *UserDetails) {
  224. if ud.ProductCode == "" {
  225. return
  226. }
  227. roleIds, err := l.models.SysUserRoleModel.FindRoleIdsByUserId(ctx, ud.UserId)
  228. if err != nil || len(roleIds) == 0 {
  229. return
  230. }
  231. roles, err := l.models.SysRoleModel.FindByIds(ctx, roleIds)
  232. if err != nil {
  233. logx.WithContext(ctx).Errorf("userDetailsLoader: query roles failed: %v", err)
  234. return
  235. }
  236. ud.Roles = make([]RoleInfo, 0)
  237. minLevel := int64(math.MaxInt64)
  238. for _, r := range roles {
  239. if r.ProductCode == ud.ProductCode && r.Status == consts.StatusEnabled {
  240. ud.Roles = append(ud.Roles, RoleInfo{
  241. Id: r.Id,
  242. Name: r.Name,
  243. Remark: r.Remark,
  244. PermsLevel: r.PermsLevel,
  245. })
  246. if r.PermsLevel < minLevel {
  247. minLevel = r.PermsLevel
  248. }
  249. }
  250. }
  251. if minLevel < math.MaxInt64 {
  252. ud.MinPermsLevel = minLevel
  253. }
  254. }
  255. func (l *UserDetailsLoader) loadPerms(ctx context.Context, ud *UserDetails) {
  256. if ud.ProductCode == "" {
  257. return
  258. }
  259. // 超管 / ADMIN / DEVELOPER / 研发部门成员 → 全量权限
  260. if ud.IsSuperAdmin ||
  261. ud.MemberType == consts.MemberTypeAdmin ||
  262. ud.MemberType == consts.MemberTypeDeveloper ||
  263. ud.DeptType == consts.DeptTypeDev {
  264. codes, err := l.models.SysPermModel.FindAllCodesByProductCode(ctx, ud.ProductCode)
  265. if err != nil {
  266. logx.WithContext(ctx).Errorf("userDetailsLoader: query all perms failed: %v", err)
  267. }
  268. ud.Perms = codes
  269. return
  270. }
  271. // 普通成员:角色权限 + 用户附加权限 - 用户拒绝权限
  272. rolePermIds := make([]int64, 0)
  273. if len(ud.Roles) > 0 {
  274. roleIds := make([]int64, 0, len(ud.Roles))
  275. for _, r := range ud.Roles {
  276. roleIds = append(roleIds, r.Id)
  277. }
  278. ids, err := l.models.SysRolePermModel.FindPermIdsByRoleIds(ctx, roleIds)
  279. if err == nil {
  280. rolePermIds = ids
  281. }
  282. }
  283. allowIds, _ := l.models.SysUserPermModel.FindPermIdsByUserIdAndEffect(ctx, ud.UserId, consts.PermEffectAllow)
  284. denyIds, _ := l.models.SysUserPermModel.FindPermIdsByUserIdAndEffect(ctx, ud.UserId, consts.PermEffectDeny)
  285. denySet := make(map[int64]bool, len(denyIds))
  286. for _, id := range denyIds {
  287. denySet[id] = true
  288. }
  289. permIdSet := make(map[int64]bool)
  290. for _, id := range rolePermIds {
  291. if !denySet[id] {
  292. permIdSet[id] = true
  293. }
  294. }
  295. for _, id := range allowIds {
  296. if !denySet[id] {
  297. permIdSet[id] = true
  298. }
  299. }
  300. finalIds := make([]int64, 0, len(permIdSet))
  301. for id := range permIdSet {
  302. finalIds = append(finalIds, id)
  303. }
  304. if len(finalIds) > 0 {
  305. perms, err := l.models.SysPermModel.FindByIds(ctx, finalIds)
  306. if err == nil {
  307. codes := make([]string, 0, len(perms))
  308. for _, p := range perms {
  309. if p.Status == consts.StatusEnabled {
  310. codes = append(codes, p.Code)
  311. }
  312. }
  313. ud.Perms = codes
  314. }
  315. }
  316. }