From fe794b385cc1fe28cb6d0731664a3023199843ac Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期一, 01 七月 2024 21:21:56 +0800
Subject: [PATCH] 增加月度统计出入库按类型汇总报表查询接口

---
 models/operation_details.go |   18 ++++++++++++++++++
 1 files changed, 18 insertions(+), 0 deletions(-)

diff --git a/models/operation_details.go b/models/operation_details.go
index 16f65f4..8269f76 100644
--- a/models/operation_details.go
+++ b/models/operation_details.go
@@ -29,6 +29,7 @@
 		AuxiliaryUnit    string          `json:"auxiliaryUnit" gorm:"type:varchar(191);comment:杈呭姪鍗曚綅"`
 		Remark           string          `gorm:"type:varchar(1024);comment:澶囨敞" json:"remark"`
 		IsInternalOutput bool            `json:"isInternalOutput"` //鏄惁璋冩嫧浜х敓鐨勫嚭搴�
+		DealerType       string          `json:"dealerType"`       //鍑哄叆搴撶被鍨�
 
 		Cost      decimal.Decimal `json:"cost" `      //鎴愭湰鍗曚环
 		SalePrice decimal.Decimal `json:"salePrice" ` //閿�鍞崟浠�
@@ -312,3 +313,20 @@
 	}
 	return result, nil
 }
+
+type GroupByDealerTypeWarehouse struct {
+	DealerType string
+	ProductID  string
+	Sum        decimal.Decimal
+}
+
+func (slf *OperationDetailsSearch) GroupMultiSumAmount() ([]*GroupByDealerTypeWarehouse, error) {
+	var (
+		db     = slf.build()
+		result = make([]*GroupByDealerTypeWarehouse, 0)
+	)
+	if err := db.Select("sum(amount) as sum, dealer_type, product_id").Group("product_id, dealer_type").Scan(&result).Error; err != nil {
+		return nil, fmt.Errorf("select group err: %v", err)
+	}
+	return result, nil
+}

--
Gitblit v1.8.0