From d734647a726a0fc1e693619ad6b1b112f2ff0997 Mon Sep 17 00:00:00 2001
From: skyouc
Date: 星期五, 08 八月 2025 16:32:46 +0800
Subject: [PATCH] 日出入库汇总统计报表

---
 rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/StockStatisticController.java |    7 ++++++-
 1 files changed, 6 insertions(+), 1 deletions(-)

diff --git a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/StockStatisticController.java b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/StockStatisticController.java
index c4bf3c7..19f0baf 100644
--- a/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/StockStatisticController.java
+++ b/rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/StockStatisticController.java
@@ -84,7 +84,12 @@
         BaseParam baseParam = buildParam(map, BaseParam.class);
         PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class);
         QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
-        wrapper.select("id, day_time, COUNT( barcode ) `count`, SUM( anfme ) anfme, COUNT(IF (task_type = 1, 0, NULL)) in_anfme_count, COUNT(IF ( task_type = 101, 0, NULL)) out_anfme_count, SUM(CASE WHEN task_type = 1 THEN)");
+        wrapper.select("id, day_time, COUNT( barcode ) `count`, " +
+                "SUM( anfme ) anfme," +
+                "COUNT(IF (task_type = 1, 0, NULL)) in_anfme_count, " +
+                "COUNT(IF ( task_type = 101, 0, NULL)) out_anfme_count, " +
+                "SUM( CASE WHEN task_type = 1 THEN anfme ELSE 0 END ) in_anfme," +
+                "SUM( CASE WHEN task_type = 101 THEN anfme ELSE 0 END ) out_anfme");
         wrapper.groupBy("barcode, day_time");
         return R.ok().add(stockStatisticService.page(pageParam, wrapper));
     }

--
Gitblit v1.9.1