peer.go 3.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154
  1. package service
  2. import (
  3. "github.com/lejianwen/rustdesk-api/v2/model"
  4. "gorm.io/gorm"
  5. )
  6. type PeerService struct {
  7. }
  8. // FindById 根据id查找
  9. func (ps *PeerService) FindById(id string) *model.Peer {
  10. p := &model.Peer{}
  11. DB.Where("id = ?", id).First(p)
  12. return p
  13. }
  14. func (ps *PeerService) FindByUuid(uuid string) *model.Peer {
  15. p := &model.Peer{}
  16. DB.Where("uuid = ?", uuid).First(p)
  17. return p
  18. }
  19. func (ps *PeerService) InfoByRowId(id uint) *model.Peer {
  20. p := &model.Peer{}
  21. DB.Where("row_id = ?", id).First(p)
  22. return p
  23. }
  24. // FindByUserIdAndUuid 根据用户id和uuid查找peer
  25. func (ps *PeerService) FindByUserIdAndUuid(uuid string, userId uint) *model.Peer {
  26. p := &model.Peer{}
  27. DB.Where("uuid = ? and user_id = ?", uuid, userId).First(p)
  28. return p
  29. }
  30. // UuidBindUserId 绑定用户id
  31. func (ps *PeerService) UuidBindUserId(deviceId string, uuid string, userId uint) {
  32. peer := ps.FindByUuid(uuid)
  33. // 如果存在则更新
  34. if peer.RowId > 0 {
  35. peer.UserId = userId
  36. ps.Update(peer)
  37. } else {
  38. // 不存在则创建
  39. /*if deviceId != "" {
  40. DB.Create(&model.Peer{
  41. Id: deviceId,
  42. Uuid: uuid,
  43. UserId: userId,
  44. })
  45. }*/
  46. }
  47. }
  48. // UuidUnbindUserId 解绑用户id, 用于用户注销
  49. func (ps *PeerService) UuidUnbindUserId(uuid string, userId uint) {
  50. peer := ps.FindByUserIdAndUuid(uuid, userId)
  51. if peer.RowId > 0 {
  52. DB.Model(peer).Update("user_id", 0)
  53. }
  54. }
  55. // EraseUserId 清除用户id, 用于用户删除
  56. func (ps *PeerService) EraseUserId(userId uint) error {
  57. return DB.Model(&model.Peer{}).Where("user_id = ?", userId).Update("user_id", 0).Error
  58. }
  59. // ListByUserIds 根据用户id取列表
  60. func (ps *PeerService) ListByUserIds(userIds []uint, page, pageSize uint) (res *model.PeerList) {
  61. res = &model.PeerList{}
  62. res.Page = int64(page)
  63. res.PageSize = int64(pageSize)
  64. tx := DB.Model(&model.Peer{})
  65. tx.Where("user_id in (?)", userIds)
  66. tx.Count(&res.Total)
  67. tx.Scopes(Paginate(page, pageSize))
  68. tx.Find(&res.Peers)
  69. return
  70. }
  71. func (ps *PeerService) List(page, pageSize uint, where func(tx *gorm.DB)) (res *model.PeerList) {
  72. res = &model.PeerList{}
  73. res.Page = int64(page)
  74. res.PageSize = int64(pageSize)
  75. tx := DB.Model(&model.Peer{})
  76. if where != nil {
  77. where(tx)
  78. }
  79. tx.Count(&res.Total)
  80. tx.Scopes(Paginate(page, pageSize))
  81. tx.Find(&res.Peers)
  82. return
  83. }
  84. // ListFilterByUserId 根据用户id过滤Peer列表
  85. func (ps *PeerService) ListFilterByUserId(page, pageSize uint, where func(tx *gorm.DB), userId uint) (res *model.PeerList) {
  86. userWhere := func(tx *gorm.DB) {
  87. tx.Where("user_id = ?", userId)
  88. // 如果还有额外的筛选条件,执行它
  89. if where != nil {
  90. where(tx)
  91. }
  92. }
  93. return ps.List(page, pageSize, userWhere)
  94. }
  95. // Create 创建
  96. func (ps *PeerService) Create(u *model.Peer) error {
  97. res := DB.Create(u).Error
  98. return res
  99. }
  100. // Delete 删除, 同时也应该删除token
  101. func (ps *PeerService) Delete(u *model.Peer) error {
  102. uuid := u.Uuid
  103. err := DB.Delete(u).Error
  104. if err != nil {
  105. return err
  106. }
  107. // 删除token
  108. return AllService.UserService.FlushTokenByUuid(uuid)
  109. }
  110. // GetUuidListByIDs 根据ids获取uuid列表
  111. func (ps *PeerService) GetUuidListByIDs(ids []uint) ([]string, error) {
  112. var uuids []string
  113. err := DB.Model(&model.Peer{}).
  114. Where("row_id in (?)", ids).
  115. Pluck("uuid", &uuids).Error
  116. //过滤uuids中的空字符串
  117. var newUuids []string
  118. for _, uuid := range uuids {
  119. if uuid != "" {
  120. newUuids = append(newUuids, uuid)
  121. }
  122. }
  123. return newUuids, err
  124. }
  125. // BatchDelete 批量删除, 同时也应该删除token
  126. func (ps *PeerService) BatchDelete(ids []uint) error {
  127. uuids, err := ps.GetUuidListByIDs(ids)
  128. err = DB.Where("row_id in (?)", ids).Delete(&model.Peer{}).Error
  129. if err != nil {
  130. return err
  131. }
  132. // 删除token
  133. return AllService.UserService.FlushTokenByUuids(uuids)
  134. }
  135. // Update 更新
  136. func (ps *PeerService) Update(u *model.Peer) error {
  137. return DB.Model(u).Updates(u).Error
  138. }