username.go 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. /**
  2. * @Author: zou.yingbin
  3. * @Create : 2021/1/13 10:51
  4. * @Modify : 2021/1/13 10:51
  5. */
  6. package mtpcache
  7. import (
  8. "mtp2_if/db"
  9. "mtp2_if/logger"
  10. "mtp2_if/utils"
  11. "sync"
  12. "time"
  13. )
  14. var vUser userName
  15. type userName struct {
  16. mtx sync.RWMutex // 锁
  17. data map[int64]userData // 数据[loginId]userData
  18. last time.Time
  19. }
  20. type userData struct {
  21. USERID int64 `json:"userid" xorm:"'USERID'"` // 用户id
  22. RELATEDUSERID int64 `json:"relateduserid" xorm:"'RELATEDUSERID'"` // 关联用户id
  23. LOGINID int64 `json:"LOGINID" xorm:"'LOGINID'"` // 登录ID
  24. LOGINCODE string `json:"LOGINCODE" xorm:"'LOGINCODE'"` // 登录代码
  25. ACCOUNTNAME string `json:"accountname" xorm:"'ACCOUNTNAME'"` // 用户名字
  26. }
  27. // 加载数据
  28. func (r *userName) load() {
  29. now := time.Now()
  30. // 间隔3秒以上才重新加载
  31. if d := now.Sub(r.last); d.Seconds() < 3 {
  32. return
  33. }
  34. r.mtx.Lock()
  35. defer r.mtx.Unlock()
  36. e := db.GetEngine()
  37. if e == nil {
  38. return
  39. }
  40. var sqlId utils.SQLVal = "select t.userid, t.relateduserid, t.loginid, t.logincode, t.accountname" +
  41. " from loginaccount t" +
  42. " where 1 = 1"
  43. sData := make([]userData, 0)
  44. s := e.SQL(sqlId)
  45. if err := s.Find(&sData); err != nil {
  46. logger.GetLogger().Errorf("cache load usrname, %v", err)
  47. } else {
  48. r.data = make(map[int64]userData)
  49. for i := range sData {
  50. r.data[sData[i].LOGINID] = sData[i]
  51. }
  52. r.last = time.Now()
  53. }
  54. }
  55. func (r *userName) name(loginId int64) string {
  56. r.mtx.RLock()
  57. defer r.mtx.RUnlock()
  58. if r.data == nil {
  59. return ""
  60. }
  61. if v, ok := r.data[loginId]; ok {
  62. return v.ACCOUNTNAME
  63. }
  64. return ""
  65. }
  66. func (r *userName) loginCode(loginId int64) string {
  67. r.mtx.RLock()
  68. defer r.mtx.RUnlock()
  69. if r.data == nil {
  70. return ""
  71. }
  72. if v, ok := r.data[loginId]; ok {
  73. return v.LOGINCODE
  74. }
  75. return ""
  76. }
  77. func (r *userName) logincodeByUserId(userId int64) string {
  78. // 只取一个
  79. r.mtx.RLock()
  80. defer r.mtx.RUnlock()
  81. for _, v := range r.data {
  82. if v.USERID == userId {
  83. return v.LOGINCODE
  84. }
  85. }
  86. return ""
  87. }
  88. // GetLoginCodeByLoginId 根据登录ID获取登录代码
  89. func GetLoginCodeByLoginId(loginId int64) string {
  90. if v := vUser.loginCode(loginId); v != "" {
  91. return v
  92. } else {
  93. vUser.load()
  94. }
  95. return vUser.loginCode(loginId)
  96. }
  97. // GetLoginCodeByUserId 获取登录代码
  98. func GetLoginCodeByUserId(userId int64) string {
  99. if v := vUser.logincodeByUserId(userId); v != "" {
  100. return v
  101. } else {
  102. vUser.load()
  103. }
  104. return vUser.logincodeByUserId(userId)
  105. }