| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321 |
- package service
- import (
- "Gwen/global"
- "Gwen/model"
- "github.com/google/uuid"
- "gorm.io/gorm"
- "strings"
- )
- type AddressBookService struct {
- }
- func (s *AddressBookService) Info(id string) *model.AddressBook {
- p := &model.AddressBook{}
- global.DB.Where("id = ?", id).First(p)
- return p
- }
- func (s *AddressBookService) InfoByUserIdAndId(userid uint, id string) *model.AddressBook {
- p := &model.AddressBook{}
- global.DB.Where("user_id = ? and id = ?", userid, id).First(p)
- return p
- }
- func (s *AddressBookService) InfoByUserIdAndIdAndCid(userid uint, id string, cid uint) *model.AddressBook {
- p := &model.AddressBook{}
- global.DB.Where("user_id = ? and id = ? and collection_id = ?", userid, id, cid).First(p)
- return p
- }
- func (s *AddressBookService) InfoByRowId(id uint) *model.AddressBook {
- p := &model.AddressBook{}
- global.DB.Where("row_id = ?", id).First(p)
- return p
- }
- func (s *AddressBookService) ListByUserId(userId, page, pageSize uint) (res *model.AddressBookList) {
- res = s.List(page, pageSize, func(tx *gorm.DB) {
- tx.Where("user_id = ?", userId)
- })
- return
- }
- func (s *AddressBookService) ListByUserIds(userIds []uint, page, pageSize uint) (res *model.AddressBookList) {
- res = s.List(page, pageSize, func(tx *gorm.DB) {
- tx.Where("user_id in (?)", userIds)
- })
- return
- }
- // AddAddressBook
- func (s *AddressBookService) AddAddressBook(ab *model.AddressBook) error {
- return global.DB.Create(ab).Error
- }
- // UpdateAddressBook
- func (s *AddressBookService) UpdateAddressBook(abs []*model.AddressBook, userId uint) error {
- //比较peers和数据库中的数据,如果peers中的数据在数据库中不存在,则添加,如果存在则更新,如果数据库中的数据在peers中不存在,则删除
- // 开始事务
- tx := global.DB.Begin()
- //1. 获取数据库中的数据
- var dbABs []*model.AddressBook
- tx.Where("user_id = ?", userId).Find(&dbABs)
- //2. 比较peers和数据库中的数据
- //2.1 获取peers中的id
- aBIds := make(map[string]*model.AddressBook)
- for _, ab := range abs {
- aBIds[ab.Id] = ab
- }
- //2.2 获取数据库中的id
- dbABIds := make(map[string]*model.AddressBook)
- for _, dbAb := range dbABs {
- dbABIds[dbAb.Id] = dbAb
- }
- //2.3 比较peers和数据库中的数据
- for id, ab := range aBIds {
- dbAB, ok := dbABIds[id]
- ab.UserId = userId
- if !ok {
- //添加
- if ab.Platform == "" || ab.Username == "" || ab.Hostname == "" {
- peer := AllService.PeerService.FindById(ab.Id)
- if peer.RowId != 0 {
- ab.Platform = AllService.AddressBookService.PlatformFromOs(peer.Os)
- ab.Username = peer.Username
- ab.Hostname = peer.Hostname
- }
- }
- tx.Create(ab)
- } else {
- //更新
- tx.Model(&model.AddressBook{}).Where("row_id = ?", dbAB.RowId).Updates(ab)
- }
- }
- //2.4 删除
- for id, dbAB := range dbABIds {
- _, ok := aBIds[id]
- if !ok {
- tx.Delete(dbAB)
- }
- }
- tx.Commit()
- return nil
- }
- func (s *AddressBookService) List(page, pageSize uint, where func(tx *gorm.DB)) (res *model.AddressBookList) {
- res = &model.AddressBookList{}
- res.Page = int64(page)
- res.PageSize = int64(pageSize)
- tx := global.DB.Model(&model.AddressBook{})
- if where != nil {
- where(tx)
- }
- tx.Count(&res.Total)
- tx.Scopes(Paginate(page, pageSize))
- tx.Find(&res.AddressBooks)
- return
- }
- // Create 创建
- func (s *AddressBookService) Create(u *model.AddressBook) error {
- res := global.DB.Create(u).Error
- return res
- }
- func (s *AddressBookService) Delete(u *model.AddressBook) error {
- return global.DB.Delete(u).Error
- }
- // Update 更新
- func (s *AddressBookService) Update(u *model.AddressBook) error {
- return global.DB.Model(u).Updates(u).Error
- }
- // UpdateByMap 更新
- func (s *AddressBookService) UpdateByMap(u *model.AddressBook, data map[string]interface{}) error {
- return global.DB.Model(u).Updates(data).Error
- }
- // UpdateAll 更新
- func (s *AddressBookService) UpdateAll(u *model.AddressBook) error {
- return global.DB.Model(u).Select("*").Omit("created_at").Updates(u).Error
- }
- // ShareByWebClient 分享
- func (s *AddressBookService) ShareByWebClient(m *model.ShareRecord) error {
- m.ShareToken = uuid.New().String()
- return global.DB.Create(m).Error
- }
- // SharedPeer
- func (s *AddressBookService) SharedPeer(shareToken string) *model.ShareRecord {
- m := &model.ShareRecord{}
- global.DB.Where("share_token = ?", shareToken).First(m)
- return m
- }
- // PlatformFromOs
- func (s *AddressBookService) PlatformFromOs(os string) string {
- if strings.Contains(os, "Android") || strings.Contains(os, "android") {
- return "Android"
- }
- if strings.Contains(os, "Windows") || strings.Contains(os, "windows") {
- return "Windows"
- }
- if strings.Contains(os, "Linux") || strings.Contains(os, "linux") {
- return "Linux"
- }
- if strings.Contains(os, "mac") || strings.Contains(os, "Mac") {
- return "Mac OS"
- }
- return ""
- }
- func (s *AddressBookService) ListByUserIdAndCollectionId(userId, cid, page, pageSize uint) (res *model.AddressBookList) {
- res = s.List(page, pageSize, func(tx *gorm.DB) {
- tx.Where("user_id = ? and collection_id = ?", userId, cid)
- })
- return
- }
- func (s *AddressBookService) ListCollection(page, pageSize uint, where func(tx *gorm.DB)) (res *model.AddressBookCollectionList) {
- res = &model.AddressBookCollectionList{}
- res.Page = int64(page)
- res.PageSize = int64(pageSize)
- tx := global.DB.Model(&model.AddressBookCollection{})
- if where != nil {
- where(tx)
- }
- tx.Count(&res.Total)
- tx.Scopes(Paginate(page, pageSize))
- tx.Find(&res.AddressBookCollection)
- return
- }
- func (s *AddressBookService) ListCollectionByIds(ids []uint) (res []*model.AddressBookCollection) {
- global.DB.Where("id in ?", ids).Find(&res)
- return res
- }
- func (s *AddressBookService) ListCollectionByUserId(userId uint) (res *model.AddressBookCollectionList) {
- res = s.ListCollection(1, 100, func(tx *gorm.DB) {
- tx.Where("user_id = ?", userId)
- })
- return
- }
- func (s *AddressBookService) CollectionInfoById(id uint) *model.AddressBookCollection {
- p := &model.AddressBookCollection{}
- global.DB.Where("id = ?", id).First(p)
- return p
- }
- func (s *AddressBookService) CollectionReadRules(user *model.User) (res []*model.AddressBookCollectionRule) {
- // personalRules
- var personalRules []*model.AddressBookCollectionRule
- tx2 := global.DB.Model(&model.AddressBookCollectionRule{})
- tx2.Where("type = ? and to_id = ? and rule > 0", model.ShareAddressBookRuleTypePersonal, user.Id).Find(&personalRules)
- res = append(res, personalRules...)
- //group
- var groupRules []*model.AddressBookCollectionRule
- tx3 := global.DB.Model(&model.AddressBookCollectionRule{})
- tx3.Where("type = ? and to_id = ? and rule > 0", model.ShareAddressBookRuleTypeGroup, user.GroupId).Find(&groupRules)
- res = append(res, groupRules...)
- return
- }
- func (s *AddressBookService) UserMaxRule(user *model.User, uid, cid uint) int {
- // ismy?
- if user.Id == uid {
- return model.ShareAddressBookRuleRuleFullControl
- }
- max := 0
- personalRules := &model.AddressBookCollectionRule{}
- tx := global.DB.Model(personalRules)
- tx.Where("type = ? and collection_id = ? and to_id = ?", model.ShareAddressBookRuleTypePersonal, cid, user.Id).First(&personalRules)
- if personalRules.Id != 0 {
- max = personalRules.Rule
- if max == model.ShareAddressBookRuleRuleFullControl {
- return max
- }
- }
- groupRules := &model.AddressBookCollectionRule{}
- tx2 := global.DB.Model(groupRules)
- tx2.Where("type = ? and collection_id = ? and to_id = ?", model.ShareAddressBookRuleTypeGroup, cid, user.GroupId).First(&groupRules)
- if groupRules.Id != 0 {
- if groupRules.Rule > max {
- max = groupRules.Rule
- }
- if max == model.ShareAddressBookRuleRuleFullControl {
- return max
- }
- }
- return max
- }
- func (s *AddressBookService) CheckUserReadPrivilege(user *model.User, uid, cid uint) bool {
- return s.UserMaxRule(user, uid, cid) >= model.ShareAddressBookRuleRuleRead
- }
- func (s *AddressBookService) CheckUserWritePrivilege(user *model.User, uid, cid uint) bool {
- return s.UserMaxRule(user, uid, cid) >= model.ShareAddressBookRuleRuleReadWrite
- }
- func (s *AddressBookService) CheckUserFullControlPrivilege(user *model.User, uid, cid uint) bool {
- return s.UserMaxRule(user, uid, cid) >= model.ShareAddressBookRuleRuleFullControl
- }
- func (s *AddressBookService) CreateCollection(t *model.AddressBookCollection) error {
- return global.DB.Create(t).Error
- }
- func (s *AddressBookService) UpdateCollection(t *model.AddressBookCollection) error {
- return global.DB.Model(t).Updates(t).Error
- }
- func (s *AddressBookService) DeleteCollection(t *model.AddressBookCollection) error {
- //删除集合下的所有规则、地址簿,再删除集合
- tx := global.DB.Begin()
- tx.Where("collection_id = ?", t.Id).Delete(&model.AddressBookCollectionRule{})
- tx.Where("collection_id = ?", t.Id).Delete(&model.AddressBook{})
- tx.Delete(t)
- return tx.Commit().Error
- }
- func (s *AddressBookService) RuleInfoById(u uint) *model.AddressBookCollectionRule {
- p := &model.AddressBookCollectionRule{}
- global.DB.Where("id = ?", u).First(p)
- return p
- }
- func (s *AddressBookService) RulePersonalInfoByToIdAndCid(toid, cid uint) *model.AddressBookCollectionRule {
- p := &model.AddressBookCollectionRule{}
- global.DB.Where("type = ? and to_id = ? and collection_id = ?", model.ShareAddressBookRuleTypePersonal, toid, cid).First(p)
- return p
- }
- func (s *AddressBookService) CreateRule(t *model.AddressBookCollectionRule) error {
- return global.DB.Create(t).Error
- }
- func (s *AddressBookService) ListRules(page uint, size uint, f func(tx *gorm.DB)) *model.AddressBookCollectionRuleList {
- res := &model.AddressBookCollectionRuleList{}
- res.Page = int64(page)
- res.PageSize = int64(size)
- tx := global.DB.Model(&model.AddressBookCollectionRule{})
- if f != nil {
- f(tx)
- }
- tx.Count(&res.Total)
- tx.Scopes(Paginate(page, size))
- tx.Find(&res.AddressBookCollectionRule)
- return res
- }
- func (s *AddressBookService) UpdateRule(t *model.AddressBookCollectionRule) error {
- return global.DB.Model(t).Updates(t).Error
- }
- func (s *AddressBookService) DeleteRule(t *model.AddressBookCollectionRule) error {
- return global.DB.Delete(t).Error
- }
- // CheckCollectionOwner 检查Collection的所有者
- func (s *AddressBookService) CheckCollectionOwner(uid uint, cid uint) bool {
- p := s.CollectionInfoById(cid)
- return p.UserId == uid
- }
|