addressBook.go 11 KB

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