partner_company.go 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171
  1. package partner
  2. import (
  3. "context"
  4. "database/sql"
  5. "fmt"
  6. dao "dashoo.cn/micro/app/dao/partner"
  7. model "dashoo.cn/micro/app/model/partner"
  8. "dashoo.cn/opms_libary/micro_srv"
  9. "dashoo.cn/opms_libary/myerrors"
  10. "dashoo.cn/opms_libary/request"
  11. "github.com/gogf/gf/database/gdb"
  12. "github.com/gogf/gf/frame/g"
  13. "github.com/gogf/gf/os/gtime"
  14. "github.com/gogf/gf/util/gvalid"
  15. )
  16. type PartnerCompanyService struct {
  17. Dao *dao.PartnerCompanyDao
  18. ContactDao *dao.PartnerCompanyContactDao
  19. Tenant string
  20. userInfo request.UserInfo
  21. DataScope g.Map `json:"dataScope"`
  22. }
  23. func NewPartnerCompanyService(ctx context.Context) (*PartnerCompanyService, error) {
  24. tenant, err := micro_srv.GetTenant(ctx)
  25. if err != nil {
  26. err = myerrors.TipsError(fmt.Sprintf("获取租户码异常:%s", err.Error()))
  27. return nil, err
  28. }
  29. // 获取用户信息
  30. userInfo, err := micro_srv.GetUserInfo(ctx)
  31. if err != nil {
  32. return nil, fmt.Errorf("获取用户信息异常:%s", err.Error())
  33. }
  34. return &PartnerCompanyService{
  35. Dao: dao.NewPartnerCompanyDao(tenant),
  36. ContactDao: dao.NewPartnerCompanyContactDao(tenant),
  37. Tenant: tenant,
  38. userInfo: userInfo,
  39. DataScope: userInfo.DataScope,
  40. }, nil
  41. }
  42. func (s PartnerCompanyService) Get(ctx context.Context, id int) (*model.PartnerCompanyGetRsp, error) {
  43. ent, err := s.Dao.Where("Id = ?", id).One()
  44. if err != nil {
  45. return nil, err
  46. }
  47. if ent == nil {
  48. return nil, myerrors.TipsError("合作伙伴不存在")
  49. }
  50. contact, err := s.ContactDao.Where("partner_id = ?", id).All()
  51. if err != nil {
  52. return nil, err
  53. }
  54. if contact == nil {
  55. contact = []*model.PartnerCompanyContact{}
  56. }
  57. return &model.PartnerCompanyGetRsp{
  58. PartnerCompany: *ent,
  59. Contact: contact,
  60. }, nil
  61. }
  62. func (s PartnerCompanyService) List(ctx context.Context, req *model.PartnerCompanyListReq) (int, []*model.PartnerCompany, error) {
  63. dao := &s.Dao.PartnerCompanyDao
  64. if req.PartnerName != "" {
  65. likestr := fmt.Sprintf("%%%s%%", req.PartnerName)
  66. dao = dao.Where("partner_name like ?", likestr)
  67. }
  68. total, err := dao.Count()
  69. if err != nil {
  70. return 0, nil, err
  71. }
  72. if req.PageNum != 0 {
  73. dao = dao.Page(req.GetPage())
  74. }
  75. orderby := "created_time desc"
  76. if req.OrderBy != "" {
  77. orderby = req.OrderBy
  78. }
  79. dao = dao.Order(orderby)
  80. ents := []*model.PartnerCompany{}
  81. err = dao.Structs(&ents)
  82. if err != nil && err != sql.ErrNoRows {
  83. return 0, nil, err
  84. }
  85. return total, ents, err
  86. }
  87. func (s PartnerCompanyService) Add(ctx context.Context, req *model.PartnerCompanyAddReq) (int, error) {
  88. validErr := gvalid.CheckStruct(ctx, req, nil)
  89. if validErr != nil {
  90. return 0, myerrors.TipsError(validErr.Current().Error())
  91. }
  92. var id int
  93. txerr := s.Dao.DB.Transaction(ctx, func(ctx context.Context, tx *gdb.TX) error {
  94. var err error
  95. cid, err := tx.InsertAndGetId("partner_company", model.PartnerCompany{
  96. PartnerName: req.PartnerName,
  97. Remark: req.Remark,
  98. CreatedBy: int(s.userInfo.Id),
  99. CreatedName: s.userInfo.NickName,
  100. CreatedTime: gtime.Now(),
  101. UpdatedBy: int(s.userInfo.Id),
  102. UpdatedName: s.userInfo.NickName,
  103. UpdatedTime: gtime.Now(),
  104. })
  105. if err != nil {
  106. return err
  107. }
  108. id = int(cid)
  109. return nil
  110. })
  111. return id, txerr
  112. }
  113. func (s PartnerCompanyService) Update(ctx context.Context, req *model.PartnerCompanyUpdateReq) error {
  114. validErr := gvalid.CheckStruct(ctx, req, nil)
  115. if validErr != nil {
  116. return myerrors.TipsError(validErr.Current().Error())
  117. }
  118. ent, err := s.Dao.Where("id = ?", req.Id).One()
  119. if err != nil {
  120. return err
  121. }
  122. if ent == nil {
  123. return myerrors.TipsError(fmt.Sprintf("合作伙伴不存在: %d", req.Id))
  124. }
  125. toupdate := map[string]interface{}{}
  126. if req.PartnerName != "" {
  127. toupdate["partner_name"] = req.PartnerName
  128. }
  129. if req.Remark != nil {
  130. toupdate["remark"] = *req.Remark
  131. }
  132. if len(toupdate) != 0 {
  133. toupdate["updated_by"] = int(s.userInfo.Id)
  134. toupdate["updated_name"] = s.userInfo.NickName
  135. toupdate["updated_time"] = gtime.Now()
  136. txerr := s.Dao.DB.Transaction(ctx, func(ctx context.Context, tx *gdb.TX) error {
  137. _, err = tx.Update("partner_company", toupdate, "id = ?", req.Id)
  138. if err != nil {
  139. return err
  140. }
  141. return nil
  142. })
  143. if txerr != nil {
  144. return txerr
  145. }
  146. }
  147. return nil
  148. }
  149. func (s PartnerCompanyService) Delete(ctx context.Context, id []int) error {
  150. if len(id) == 0 {
  151. return nil
  152. }
  153. _, err := s.Dao.Where("Id IN (?)", id).Delete()
  154. return err
  155. }