addressBook.go 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340
  1. package service
  2. import (
  3. "encoding/json"
  4. "github.com/google/uuid"
  5. "github.com/lejianwen/rustdesk-api/v2/model"
  6. "gorm.io/gorm"
  7. "strings"
  8. )
  9. type AddressBookService struct {
  10. }
  11. func (s *AddressBookService) Info(id string) *model.AddressBook {
  12. p := &model.AddressBook{}
  13. DB.Where("id = ?", id).First(p)
  14. return p
  15. }
  16. func (s *AddressBookService) InfoByUserIdAndId(userid uint, id string) *model.AddressBook {
  17. p := &model.AddressBook{}
  18. DB.Where("user_id = ? and id = ?", userid, id).First(p)
  19. return p
  20. }
  21. func (s *AddressBookService) InfoByUserIdAndIdAndCid(userid uint, id string, cid uint) *model.AddressBook {
  22. p := &model.AddressBook{}
  23. DB.Where("user_id = ? and id = ? and collection_id = ?", userid, id, cid).First(p)
  24. return p
  25. }
  26. func (s *AddressBookService) InfoByRowId(id uint) *model.AddressBook {
  27. p := &model.AddressBook{}
  28. DB.Where("row_id = ?", id).First(p)
  29. return p
  30. }
  31. func (s *AddressBookService) ListByUserId(userId, page, pageSize uint) (res *model.AddressBookList) {
  32. res = s.List(page, pageSize, func(tx *gorm.DB) {
  33. tx.Where("user_id = ?", userId)
  34. })
  35. return
  36. }
  37. func (s *AddressBookService) ListByUserIds(userIds []uint, page, pageSize uint) (res *model.AddressBookList) {
  38. res = s.List(page, pageSize, func(tx *gorm.DB) {
  39. tx.Where("user_id in (?)", userIds)
  40. })
  41. return
  42. }
  43. // AddAddressBook
  44. func (s *AddressBookService) AddAddressBook(ab *model.AddressBook) error {
  45. return DB.Create(ab).Error
  46. }
  47. // UpdateAddressBook
  48. func (s *AddressBookService) UpdateAddressBook(abs []*model.AddressBook, userId uint) error {
  49. //比较peers和数据库中的数据,如果peers中的数据在数据库中不存在,则添加,如果存在则更新,如果数据库中的数据在peers中不存在,则删除
  50. // 开始事务
  51. tx := DB.Begin()
  52. //1. 获取数据库中的数据
  53. var dbABs []*model.AddressBook
  54. tx.Where("user_id = ?", userId).Find(&dbABs)
  55. //2. 比较peers和数据库中的数据
  56. //2.1 获取peers中的id
  57. aBIds := make(map[string]*model.AddressBook)
  58. for _, ab := range abs {
  59. aBIds[ab.Id] = ab
  60. }
  61. //2.2 获取数据库中的id
  62. dbABIds := make(map[string]*model.AddressBook)
  63. for _, dbAb := range dbABs {
  64. dbABIds[dbAb.Id] = dbAb
  65. }
  66. //2.3 比较peers和数据库中的数据
  67. for id, ab := range aBIds {
  68. dbAB, ok := dbABIds[id]
  69. ab.UserId = userId
  70. if !ok {
  71. //添加
  72. if ab.Platform == "" || ab.Username == "" || ab.Hostname == "" {
  73. peer := AllService.PeerService.FindById(ab.Id)
  74. if peer.RowId != 0 {
  75. ab.Platform = AllService.AddressBookService.PlatformFromOs(peer.Os)
  76. ab.Username = peer.Username
  77. ab.Hostname = peer.Hostname
  78. }
  79. }
  80. tx.Create(ab)
  81. } else {
  82. //更新
  83. tx.Model(&model.AddressBook{}).Where("row_id = ?", dbAB.RowId).Updates(ab)
  84. }
  85. }
  86. //2.4 删除
  87. for id, dbAB := range dbABIds {
  88. _, ok := aBIds[id]
  89. if !ok {
  90. tx.Delete(dbAB)
  91. }
  92. }
  93. tx.Commit()
  94. return nil
  95. }
  96. func (s *AddressBookService) List(page, pageSize uint, where func(tx *gorm.DB)) (res *model.AddressBookList) {
  97. res = &model.AddressBookList{}
  98. res.Page = int64(page)
  99. res.PageSize = int64(pageSize)
  100. tx := DB.Model(&model.AddressBook{})
  101. if where != nil {
  102. where(tx)
  103. }
  104. tx.Count(&res.Total)
  105. tx.Scopes(Paginate(page, pageSize))
  106. tx.Find(&res.AddressBooks)
  107. return
  108. }
  109. func (s *AddressBookService) FromPeer(peer *model.Peer) (a *model.AddressBook) {
  110. a = &model.AddressBook{}
  111. a.Id = peer.Id
  112. a.Username = peer.Username
  113. a.Hostname = peer.Hostname
  114. a.UserId = peer.UserId
  115. a.Platform = s.PlatformFromOs(peer.Os)
  116. return a
  117. }
  118. // Create 创建
  119. func (s *AddressBookService) Create(u *model.AddressBook) error {
  120. res := DB.Create(u).Error
  121. return res
  122. }
  123. func (s *AddressBookService) Delete(u *model.AddressBook) error {
  124. return DB.Delete(u).Error
  125. }
  126. // Update 更新
  127. func (s *AddressBookService) Update(u *model.AddressBook) error {
  128. return DB.Model(u).Updates(u).Error
  129. }
  130. // UpdateByMap 更新
  131. func (s *AddressBookService) UpdateByMap(u *model.AddressBook, data map[string]interface{}) error {
  132. return DB.Model(u).Updates(data).Error
  133. }
  134. // UpdateAll 更新
  135. func (s *AddressBookService) UpdateAll(u *model.AddressBook) error {
  136. return DB.Model(u).Select("*").Omit("created_at").Updates(u).Error
  137. }
  138. // ShareByWebClient 分享
  139. func (s *AddressBookService) ShareByWebClient(m *model.ShareRecord) error {
  140. m.ShareToken = uuid.New().String()
  141. return DB.Create(m).Error
  142. }
  143. // SharedPeer
  144. func (s *AddressBookService) SharedPeer(shareToken string) *model.ShareRecord {
  145. m := &model.ShareRecord{}
  146. DB.Where("share_token = ?", shareToken).First(m)
  147. return m
  148. }
  149. // PlatformFromOs
  150. func (s *AddressBookService) PlatformFromOs(os string) string {
  151. if strings.Contains(os, "Android") || strings.Contains(os, "android") {
  152. return "Android"
  153. }
  154. if strings.Contains(os, "Windows") || strings.Contains(os, "windows") {
  155. return "Windows"
  156. }
  157. if strings.Contains(os, "Linux") || strings.Contains(os, "linux") {
  158. return "Linux"
  159. }
  160. if strings.Contains(os, "mac") || strings.Contains(os, "Mac") {
  161. return "Mac OS"
  162. }
  163. return ""
  164. }
  165. func (s *AddressBookService) ListByUserIdAndCollectionId(userId, cid, page, pageSize uint) (res *model.AddressBookList) {
  166. res = s.List(page, pageSize, func(tx *gorm.DB) {
  167. tx.Where("user_id = ? and collection_id = ?", userId, cid)
  168. })
  169. return
  170. }
  171. func (s *AddressBookService) ListCollection(page, pageSize uint, where func(tx *gorm.DB)) (res *model.AddressBookCollectionList) {
  172. res = &model.AddressBookCollectionList{}
  173. res.Page = int64(page)
  174. res.PageSize = int64(pageSize)
  175. tx := DB.Model(&model.AddressBookCollection{})
  176. if where != nil {
  177. where(tx)
  178. }
  179. tx.Count(&res.Total)
  180. tx.Scopes(Paginate(page, pageSize))
  181. tx.Find(&res.AddressBookCollection)
  182. return
  183. }
  184. func (s *AddressBookService) ListCollectionByIds(ids []uint) (res []*model.AddressBookCollection) {
  185. DB.Where("id in ?", ids).Find(&res)
  186. return res
  187. }
  188. func (s *AddressBookService) ListCollectionByUserId(userId uint) (res *model.AddressBookCollectionList) {
  189. res = s.ListCollection(1, 100, func(tx *gorm.DB) {
  190. tx.Where("user_id = ?", userId)
  191. })
  192. return
  193. }
  194. func (s *AddressBookService) CollectionInfoById(id uint) *model.AddressBookCollection {
  195. p := &model.AddressBookCollection{}
  196. DB.Where("id = ?", id).First(p)
  197. return p
  198. }
  199. func (s *AddressBookService) CollectionReadRules(user *model.User) (res []*model.AddressBookCollectionRule) {
  200. // personalRules
  201. var personalRules []*model.AddressBookCollectionRule
  202. tx2 := DB.Model(&model.AddressBookCollectionRule{})
  203. tx2.Where("type = ? and to_id = ? and rule > 0", model.ShareAddressBookRuleTypePersonal, user.Id).Find(&personalRules)
  204. res = append(res, personalRules...)
  205. //group
  206. var groupRules []*model.AddressBookCollectionRule
  207. tx3 := DB.Model(&model.AddressBookCollectionRule{})
  208. tx3.Where("type = ? and to_id = ? and rule > 0", model.ShareAddressBookRuleTypeGroup, user.GroupId).Find(&groupRules)
  209. res = append(res, groupRules...)
  210. return
  211. }
  212. func (s *AddressBookService) UserMaxRule(user *model.User, uid, cid uint) int {
  213. // ismy?
  214. if user.Id == uid {
  215. return model.ShareAddressBookRuleRuleFullControl
  216. }
  217. max := 0
  218. personalRules := &model.AddressBookCollectionRule{}
  219. tx := DB.Model(personalRules)
  220. tx.Where("type = ? and collection_id = ? and to_id = ?", model.ShareAddressBookRuleTypePersonal, cid, user.Id).First(&personalRules)
  221. if personalRules.Id != 0 {
  222. max = personalRules.Rule
  223. if max == model.ShareAddressBookRuleRuleFullControl {
  224. return max
  225. }
  226. }
  227. groupRules := &model.AddressBookCollectionRule{}
  228. tx2 := DB.Model(groupRules)
  229. tx2.Where("type = ? and collection_id = ? and to_id = ?", model.ShareAddressBookRuleTypeGroup, cid, user.GroupId).First(&groupRules)
  230. if groupRules.Id != 0 {
  231. if groupRules.Rule > max {
  232. max = groupRules.Rule
  233. }
  234. if max == model.ShareAddressBookRuleRuleFullControl {
  235. return max
  236. }
  237. }
  238. return max
  239. }
  240. func (s *AddressBookService) CheckUserReadPrivilege(user *model.User, uid, cid uint) bool {
  241. return s.UserMaxRule(user, uid, cid) >= model.ShareAddressBookRuleRuleRead
  242. }
  243. func (s *AddressBookService) CheckUserWritePrivilege(user *model.User, uid, cid uint) bool {
  244. return s.UserMaxRule(user, uid, cid) >= model.ShareAddressBookRuleRuleReadWrite
  245. }
  246. func (s *AddressBookService) CheckUserFullControlPrivilege(user *model.User, uid, cid uint) bool {
  247. return s.UserMaxRule(user, uid, cid) >= model.ShareAddressBookRuleRuleFullControl
  248. }
  249. func (s *AddressBookService) CreateCollection(t *model.AddressBookCollection) error {
  250. return DB.Create(t).Error
  251. }
  252. func (s *AddressBookService) UpdateCollection(t *model.AddressBookCollection) error {
  253. return DB.Model(t).Updates(t).Error
  254. }
  255. func (s *AddressBookService) DeleteCollection(t *model.AddressBookCollection) error {
  256. //删除集合下的所有规则、地址簿,再删除集合
  257. tx := DB.Begin()
  258. tx.Where("collection_id = ?", t.Id).Delete(&model.AddressBookCollectionRule{})
  259. tx.Where("collection_id = ?", t.Id).Delete(&model.AddressBook{})
  260. tx.Delete(t)
  261. return tx.Commit().Error
  262. }
  263. func (s *AddressBookService) RuleInfoById(u uint) *model.AddressBookCollectionRule {
  264. p := &model.AddressBookCollectionRule{}
  265. DB.Where("id = ?", u).First(p)
  266. return p
  267. }
  268. func (s *AddressBookService) RulePersonalInfoByToIdAndCid(toid, cid uint) *model.AddressBookCollectionRule {
  269. p := &model.AddressBookCollectionRule{}
  270. DB.Where("type = ? and to_id = ? and collection_id = ?", model.ShareAddressBookRuleTypePersonal, toid, cid).First(p)
  271. return p
  272. }
  273. func (s *AddressBookService) CreateRule(t *model.AddressBookCollectionRule) error {
  274. return DB.Create(t).Error
  275. }
  276. func (s *AddressBookService) ListRules(page uint, size uint, f func(tx *gorm.DB)) *model.AddressBookCollectionRuleList {
  277. res := &model.AddressBookCollectionRuleList{}
  278. res.Page = int64(page)
  279. res.PageSize = int64(size)
  280. tx := DB.Model(&model.AddressBookCollectionRule{})
  281. if f != nil {
  282. f(tx)
  283. }
  284. tx.Count(&res.Total)
  285. tx.Scopes(Paginate(page, size))
  286. tx.Find(&res.AddressBookCollectionRule)
  287. return res
  288. }
  289. func (s *AddressBookService) UpdateRule(t *model.AddressBookCollectionRule) error {
  290. return DB.Model(t).Updates(t).Error
  291. }
  292. func (s *AddressBookService) DeleteRule(t *model.AddressBookCollectionRule) error {
  293. return DB.Delete(t).Error
  294. }
  295. // CheckCollectionOwner 检查Collection的所有者
  296. func (s *AddressBookService) CheckCollectionOwner(uid uint, cid uint) bool {
  297. p := s.CollectionInfoById(cid)
  298. return p.UserId == uid
  299. }
  300. func (s *AddressBookService) BatchUpdateTags(abs []*model.AddressBook, tags []string) error {
  301. ids := make([]uint, 0)
  302. for _, ab := range abs {
  303. ids = append(ids, ab.RowId)
  304. }
  305. tagsv, _ := json.Marshal(tags)
  306. return DB.Model(&model.AddressBook{}).Where("row_id in ?", ids).Update("tags", tagsv).Error
  307. }