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