新增、删除、修改改收款单时若收款源单是收款计划，更新收款单状态和应收、已收金额

zhangqian

2023-08-11 6285cf3f366b0da28ba7bddbb3bb4c7ec4585d25

 service/receipt.go

@@ -17,22 +17,45 @@

func (ReceiptService) AddReceipt(receipt *model.Receipt) int {
   var moneyAdder model.MoneyAdder
   var sourceId int
   var collection *model.ServiceCollectionPlan
   var err error
   switch receipt.SourceType {
   case constvar.ReceiptSourceTypeSalesDetails:
      moneyAdder = model.NewSalesDetailsSearch()
      sourceId = receipt.SourceId
   case constvar.ReceiptSourceTypeServiceContract:
      moneyAdder = model.NewServiceContractSearch()
      sourceId = receipt.SourceId
   case constvar.ReceiptSourceTypeCollectionPlan:
      collection, err = model.NewServiceCollectionPlanSearch().SetId(receipt.SourceId).First()
      if err != nil {
         return ecode.DBErr
      }
      sourceId = collection.SourceId
      switch collection.SourceType {
      case constvar.CollectionSourceTypeSaleDetails:
         moneyAdder = model.NewSalesDetailsSearch()
      case constvar.CollectionSourceTypeServiceContract:
         moneyAdder = model.NewServiceContractSearch()
      }
   }
   err := model.WithTransaction(func(db *gorm.DB) error {
   err = model.WithTransaction(func(db *gorm.DB) error {
      err := model.NewReceiptSearch().SetOrm(db).Create(receipt)
      if err != nil {
         return err
      }
      err = moneyAdder.AmountReceivableAdd(db, receipt.SourceId, decimal.Zero.Sub(receipt.Amount).Round(2))
      if receipt.SourceType == constvar.ReceiptSourceTypeCollectionPlan {
         err = model.NewServiceCollectionPlanSearch().SetOrm(db).UpdateStatusAndAmount(collection, receipt.Amount)
         if err != nil {
            return err
         }
      }
      err = moneyAdder.AmountReceivableAdd(db, sourceId, decimal.Zero.Sub(receipt.Amount).Round(2))
      if err != nil {
         return err
      }
      err = moneyAdder.AmountReceivedAdd(db, receipt.SourceId, receipt.Amount.Round(2))
      err = moneyAdder.AmountReceivedAdd(db, sourceId, receipt.Amount.Round(2))
      if err != nil {
         return err
      }
@@ -50,23 +73,46 @@
      return ecode.DBErr
   }
   var moneyAdder model.MoneyAdder
   var sourceId int
   var collection *model.ServiceCollectionPlan
   switch receipt.SourceType {
   case constvar.ReceiptSourceTypeSalesDetails:
      moneyAdder = model.NewSalesDetailsSearch()
      sourceId = receipt.SourceId
   case constvar.ReceiptSourceTypeServiceContract:
      moneyAdder = model.NewServiceContractSearch()
      sourceId = receipt.SourceId
   case constvar.ReceiptSourceTypeCollectionPlan:
      collection, err = model.NewServiceCollectionPlanSearch().SetId(receipt.SourceId).First()
      if err != nil {
         return ecode.DBErr
      }
      sourceId = collection.SourceId
      switch collection.SourceType {
      case constvar.CollectionSourceTypeSaleDetails:
         moneyAdder = model.NewSalesDetailsSearch()
      case constvar.CollectionSourceTypeServiceContract:
         moneyAdder = model.NewServiceContractSearch()
      }
   }
   err = model.WithTransaction(func(db *gorm.DB) error {
      err := model.NewReceiptSearch().SetId(id).Delete()
      err := model.NewReceiptSearch().SetOrm(db).SetId(id).Delete()
      if err != nil {
         return err
      }

      err = moneyAdder.AmountReceivableAdd(db, receipt.SourceId, receipt.Amount.Round(2))
      if receipt.SourceType == constvar.ReceiptSourceTypeCollectionPlan {
         err = model.NewServiceCollectionPlanSearch().SetOrm(db).UpdateStatusAndAmount(collection, decimal.Zero.Sub(receipt.Amount))
         if err != nil {
            return err
         }
      }

      err = moneyAdder.AmountReceivableAdd(db, sourceId, receipt.Amount.Round(2))
      if err != nil {
         return err
      }
      err = moneyAdder.AmountReceivedAdd(db, receipt.SourceId, decimal.Zero.Sub(receipt.Amount).Round(2))
      err = moneyAdder.AmountReceivedAdd(db, sourceId, decimal.Zero.Sub(receipt.Amount).Round(2))
      if err != nil {
         return err
      }
@@ -110,23 +156,45 @@
      return ecode.DBErr
   }
   var moneyAdder model.MoneyAdder
   var sourceId int
   var collection *model.ServiceCollectionPlan
   switch receipt.SourceType {
   case constvar.ReceiptSourceTypeSalesDetails:
      moneyAdder = model.NewSalesDetailsSearch()
      sourceId = receipt.SourceId
   case constvar.ReceiptSourceTypeServiceContract:
      moneyAdder = model.NewServiceContractSearch()
      sourceId = receipt.SourceId
   case constvar.ReceiptSourceTypeCollectionPlan:
      collection, err = model.NewServiceCollectionPlanSearch().SetId(receipt.SourceId).First()
      if err != nil {
         return ecode.DBErr
      }
      sourceId = collection.SourceId
      switch collection.SourceType {
      case constvar.CollectionSourceTypeSaleDetails:
         moneyAdder = model.NewSalesDetailsSearch()
      case constvar.CollectionSourceTypeServiceContract:
         moneyAdder = model.NewServiceContractSearch()
      }
   }
   err = model.WithTransaction(func(db *gorm.DB) error {
      err := model.NewReceiptSearch().SetId(receipt.Id).Save(receipt)
      err = model.NewReceiptSearch().SetId(receipt.Id).Save(receipt)
      if err != nil {
         return err
      }
      diffAmount := receipt.Amount.Sub(old.Amount)
      err = moneyAdder.AmountReceivedAdd(db, receipt.SourceId, diffAmount.Round(2))
      if receipt.SourceType == constvar.ReceiptSourceTypeCollectionPlan {
         err = model.NewServiceCollectionPlanSearch().SetOrm(db).UpdateStatusAndAmount(collection, diffAmount)
         if err != nil {
            return err
         }
      }
      err = moneyAdder.AmountReceivedAdd(db, sourceId, diffAmount.Round(2))
      if err != nil {
         return err
      }
      err = moneyAdder.AmountReceivableAdd(db, receipt.SourceId, decimal.Zero.Sub(diffAmount).Round(2))
      err = moneyAdder.AmountReceivableAdd(db, sourceId, decimal.Zero.Sub(diffAmount).Round(2))
      if err != nil {
         return err
      }