跟进记录简单数据权限

zhangqian

2023-10-13 5f815df137f6edaaaddf869097b7e2718324acc6

 service/salesDetails.go

@@ -4,11 +4,24 @@
   "aps_crm/constvar"
   "aps_crm/model"
   "aps_crm/pkg/ecode"
   "github.com/shopspring/decimal"
   "gorm.io/gorm"
)

type SalesDetailsService struct{}

func (SalesDetailsService) AddSalesDetails(salesDetails *model.SalesDetails) int {
   salesDetails.AmountReceivable = decimal.Zero.Round(2)
   salesDetails.AmountInvoiced = decimal.Zero.Round(2)
   salesDetails.AmountReceived = decimal.Zero.Round(2)
   salesDetails.AmountUnInvoiced = decimal.Zero.Round(2)
   salesDetails.AmountTotal = decimal.Zero.Round(2)
   for _, product := range salesDetails.Products {
      salesDetails.AmountTotal = salesDetails.AmountTotal.Add(product.Amount.Mul(product.Price))
   }
   salesDetails.AmountTotal = salesDetails.AmountTotal.Round(2)
   salesDetails.AmountReceivable = salesDetails.AmountTotal
   salesDetails.AmountUnInvoiced = salesDetails.AmountTotal
   err := model.NewSalesDetailsSearch().Create(salesDetails)
   if err != nil {
      return ecode.SalesDetailsExist
@@ -30,14 +43,70 @@
   return ecode.OK
}

func (SalesDetailsService) BatchDeleteSalesDetails(ids []int) int {
   err := model.NewSalesDetailsSearch().DeleteByIds(ids)
   if err != nil {
      return ecode.DBErr
   }
   return ecode.OK
}

func (SalesDetailsService) UpdateSalesDetails(salesDetails *model.SalesDetails) int {
   // check salesDetails exist
   _, err := model.NewSalesDetailsSearch().SetId(salesDetails.Id).First()
   old, err := model.NewSalesDetailsSearch().SetId(salesDetails.Id).SetPreload(true).First()
   if err != nil {
      return ecode.SalesDetailsNotExist
   }
   var totalAmount decimal.Decimal
   totalAmount = salesDetails.AmountTotal
   for _, product := range salesDetails.Products {
      totalAmount = totalAmount.Add(product.Amount.Mul(product.Price))
   }
   salesDetails.AmountTotal = totalAmount.Round(2)
   salesDetails.AmountReceivable = salesDetails.AmountTotal.Sub(salesDetails.AmountReceived)
   salesDetails.AmountUnInvoiced = salesDetails.AmountTotal.Sub(salesDetails.AmountInvoiced)

   err = model.NewSalesDetailsSearch().SetId(salesDetails.Id).Update(salesDetails)
   newProducts, removedProducts := NewProductsService().PickDiffProducts(salesDetails.Products, old.Products)
   err = model.WithTransaction(func(db *gorm.DB) error {
      err = model.NewSalesDetailsSearch().SetId(salesDetails.Id).Update(salesDetails)
      if err != nil {
         return err
      }
      if len(removedProducts) > 0 {
         removedProductIds := make([]uint, 0, len(removedProducts))
         for _, product := range removedProducts {
            totalAmount = totalAmount.Sub(product.Amount.Mul(product.Price))
            removedProductIds = append(removedProductIds, product.Id)
         }
         err = model.NewProductSearch(db).SetIds(removedProductIds).Delete()
         if err != nil {
            return err
         }
      }
      if len(newProducts) > 0 {
         for _, p := range newProducts {
            p.Id = 0
         }
         err = model.NewProductSearch(db).CreateBatch(newProducts)
         if err != nil {
            return err
         }
         var rel []*model.SalesDetailsProduct
         for _, p := range newProducts {
            rel = append(rel, &model.SalesDetailsProduct{
               SalesDetailsId: salesDetails.Id,
               ProductId:      p.Id,
            })
         }
         err = model.NewSalesDetailsProductSearch().CreateBatch(rel)
         if err != nil {
            return err
         }
      }
      return nil

   })

   if err != nil {
      return ecode.SalesDetailsSetErr
   }