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