peer.go 3.7 KB

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