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

---
 controllers/report_forms_controller.go |   68 ++++++++++++++++++++++++++++++++++
 1 files changed, 68 insertions(+), 0 deletions(-)

diff --git a/controllers/report_forms_controller.go b/controllers/report_forms_controller.go
index 660ebee..49e8fca 100644
--- a/controllers/report_forms_controller.go
+++ b/controllers/report_forms_controller.go
@@ -437,3 +437,71 @@
 	task.MonthStats()
 	util.ResponseFormat(c, code.Success, nil)
 }
+
+// WarehouseMonthStats
+// @Tags      鎶ヨ〃
+// @Summary   浠撳簱鏈堝害缁熻搴撳瓨鎶ヨ〃
+// @Produce   application/json
+// @Param     object  body  request.GetMonthStats true  "鏌ヨ鍙傛暟"
+// @Param     Authorization	header string true "token"
+// @Success   200 {object} util.ResponseList{data=[]models.MonthStats}	"鎴愬姛"
+// @Router    /api-wms/v1/forms/warehouseMonthStats [post]
+func (slf ReportFormsController) WarehouseMonthStats(c *gin.Context) {
+	var params request.GetMonthStats
+	if err := c.BindJSON(&params); err != nil {
+		util.ResponseFormat(c, code.RequestParamError, "鍙傛暟瑙ｆ瀽澶辫触锛屾暟鎹被鍨嬮敊璇�")
+		return
+	}
+
+	if params.WarehouseID == 0 {
+		util.ResponseFormat(c, code.RequestParamError, "浠撳簱ID鍙傛暟缂哄け")
+		return
+	}
+
+	monthFormsService := service.NewWarehouseMonthFormsService()
+	total, err := monthFormsService.Count(params)
+	if err != nil {
+		logx.Errorf("MonthStats count err:%v", err)
+		util.ResponseFormat(c, code.InternalError, "鏌ヨ鎬绘暟澶辫触")
+		return
+	}
+
+	result, err := monthFormsService.Query(params)
+	if err != nil {
+		logx.Errorf("MonthStats query err:%v", err)
+		util.ResponseFormat(c, code.InternalError, "鏌ヨ澶辫触")
+		return
+	}
+
+	now := time.Now().Local()
+	today := now.Day()
+	nowMonth := now.Format("2006-01")
+
+	day, dateStr, _ := service.NewSystemConfigService().GetInventoryCutOffPoint()
+	if nowMonth == params.Date && today < day || today == day && now.Format("15:04") < dateStr { //鏈湀鏈嚦缁撶畻鏃堕棿鐐�
+		productIds := make([]string, 0, len(result))
+		for _, item := range result {
+			productIds = append(productIds, item.ProductId)
+		}
+		statsRecords, err := service.GetCurrentWarehouseStats(params.Date, params.WarehouseID, productIds)
+		if err != nil {
+			util.ResponseFormat(c, code.InternalError, "鍐呴儴閿欒")
+			return
+		}
+		statsMap := models.WarehouseMonthStatsMap(statsRecords)
+		for k, v := range result {
+			if statsMap[v.ProductId] == nil {
+				continue
+			}
+
+			result[k].OutputAmount = statsMap[v.ProductId].OutputAmount
+			result[k].EndAmount = statsMap[v.ProductId].EndAmount
+			result[k].InputAmount = statsMap[v.ProductId].InputAmount
+			result[k].InputItems = statsMap[v.ProductId].InputItems
+			result[k].OutputItems = statsMap[v.ProductId].OutputItems
+		}
+
+	}
+
+	util.ResponseFormatList(c, code.Success, result, int(total))
+}

--
Gitblit v1.8.0