From 115bd9b51f5d8eade4658f844de37516486c60e7 Mon Sep 17 00:00:00 2001
From: liujiandao <274878379@qq.com>
Date: 星期六, 18 十一月 2023 17:25:25 +0800
Subject: [PATCH] crm获取aps项目模块信息
---
service/salesDetails.go | 90 ++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 85 insertions(+), 5 deletions(-)
diff --git a/service/salesDetails.go b/service/salesDetails.go
index 8c0b0a2..dec2d36 100644
--- a/service/salesDetails.go
+++ b/service/salesDetails.go
@@ -2,12 +2,29 @@
import (
"aps_crm/model"
+ "aps_crm/model/request"
"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
+ for _, product := range salesDetails.Products {
+ product.Id = 0
+ }
err := model.NewSalesDetailsSearch().Create(salesDetails)
if err != nil {
return ecode.SalesDetailsExist
@@ -17,7 +34,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 +46,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,9 +117,16 @@
return ecode.OK
}
-func (SalesDetailsService) GetSalesDetailsList(page, pageSize int, keyword string) ([]*model.SalesDetails, int64, int) {
+func (SalesDetailsService) GetSalesDetailsList(params request.GetSalesDetailsList, memberIds []int) ([]*model.SalesDetails, int64, int) {
// get contact list
- contacts, total, err := model.NewSalesDetailsSearch().SetKeyword(keyword).SetPage(page, pageSize).FindAll()
+ contacts, total, err := model.NewSalesDetailsSearch().
+ SetPreload(true).
+ SetMemberIds(memberIds).
+ SetKeywordType(params.KeywordType).
+ SetSaleChanceId(params.SaleChanceId).
+ SetClientId(params.ClientId).
+ SetNumber(params.Number).
+ SetKeyword(params.Keyword).SetPage(params.Page, params.PageSize).FindAll()
if err != nil {
return nil, 0, ecode.SalesDetailsListErr
}
--
Gitblit v1.8.0