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 | 64 ++++++++++++++++++++++++++++++++
1 files changed, 64 insertions(+), 0 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 c9058d5..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
@@ -1,6 +1,7 @@
package com.vincent.rsf.server.manager.controller;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.vincent.rsf.framework.common.Cools;
import com.vincent.rsf.framework.common.R;
@@ -34,6 +35,69 @@
}
@PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/outStatistic/page")
+ public R outStatisticPage(@RequestBody Map<String, Object> map) {
+ BaseParam baseParam = buildParam(map, BaseParam.class);
+ PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class);
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("id, loc_code, day_time, task_type, task_status, barcode, maktx, matnr_code, batch, SUM(anfme) AS anfme, unit, fields_index, create_time, update_time");
+ wrapper.groupBy("matnr_code, day_time");
+ return R.ok().add(stockStatisticService.page(pageParam, wrapper));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/inStatistic/page")
+ public R inStatisticPage(@RequestBody Map<String, Object> map) {
+ BaseParam baseParam = buildParam(map, BaseParam.class);
+ PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class);
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("id, loc_code, day_time, task_type, task_status, barcode, maktx, matnr_code, batch, SUM(anfme) AS anfme, unit, fields_index, create_time, update_time");
+ wrapper.groupBy("matnr_code, day_time");
+ return R.ok().add(stockStatisticService.page(pageParam, wrapper));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/inStatisticItem/page")
+ public R inStockItemPage(@RequestBody Map<String, Object> map) {
+ BaseParam baseParam = buildParam(map, BaseParam.class);
+ PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class);
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("id, loc_code, day_time, task_type, task_status, barcode, maktx, matnr_code, batch, SUM(anfme) anfme, unit, fields_index, create_by, update_by, create_time, update_time");
+ wrapper.groupBy("matnr_code, day_time, task_type, task_status");
+ return R.ok().add(stockStatisticService.page(pageParam, wrapper));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/outStatisticItem/page")
+ public R outStockItemPage(@RequestBody Map<String, Object> map) {
+ BaseParam baseParam = buildParam(map, BaseParam.class);
+ PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class);
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("id, loc_code, day_time, task_type, task_status, barcode, maktx, matnr_code, batch, SUM(anfme) anfme, unit, fields_index, create_by, update_by, create_time, update_time");
+ wrapper.groupBy("matnr_code, day_time, task_type, task_status");
+ return R.ok().add(stockStatisticService.page(pageParam, wrapper));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/statistic/num/page")
+ public R statisticNumPage(@RequestBody Map<String, Object> map) {
+ 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 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));
+ }
+
+
+
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
@PostMapping("/stockStatistic/list")
public R list(@RequestBody Map<String, Object> map) {
return R.ok().add(stockStatisticService.list());
--
Gitblit v1.9.1