From cd9a3c446cff66e589cdb26163c3e2baf4bc6a1e Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期三, 30 八月 2023 13:37:19 +0800
Subject: [PATCH] fix

---
 service/salesDetails.go |   87 ++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 80 insertions(+), 7 deletions(-)

diff --git a/service/salesDetails.go b/service/salesDetails.go
index ba80cb1..fa497bf 100644
--- a/service/salesDetails.go
+++ b/service/salesDetails.go
@@ -1,13 +1,27 @@
 package service
 
 import (
+	"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
@@ -17,7 +31,7 @@
 }
 
 func (SalesDetailsService) DeleteSalesDetails(id int) int {
-	_, err := model.NewSalesDetailsSearch().SetId(id).Find()
+	_, err := model.NewSalesDetailsSearch().SetId(id).First()
 	if err != nil {
 		return ecode.SalesDetailsNotExist
 	}
@@ -29,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).Find()
+	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
 	}
@@ -44,11 +114,14 @@
 	return ecode.OK
 }
 
-func (SalesDetailsService) GetSalesDetailsList(page, pageSize int, keyword string) ([]*model.SalesDetails, int) {
+func (SalesDetailsService) GetSalesDetailsList(page, pageSize int, keywordType constvar.SalesDetailsKeywordType, keyword string) ([]*model.SalesDetails, int64, int) {
 	// get contact list
-	contacts, err := model.NewSalesDetailsSearch().SetKeyword(keyword).SetPage(page, pageSize).FindAll()
+	contacts, total, err := model.NewSalesDetailsSearch().
+		SetPreload(true).
+		SetKeywordType(keywordType).
+		SetKeyword(keyword).SetPage(page, pageSize).FindAll()
 	if err != nil {
-		return nil, ecode.SalesDetailsListErr
+		return nil, 0, ecode.SalesDetailsListErr
 	}
-	return contacts, ecode.OK
+	return contacts, total, ecode.OK
 }

--
Gitblit v1.8.0