From 34d36a15f339d331d668d4063cfdff50cffa5800 Mon Sep 17 00:00:00 2001
From: zhou zhou <zozhouo3o@gmail.com>
Date: 星期五, 17 四月 2026 15:11:32 +0800
Subject: [PATCH] #导出服务
---
rsf-server/src/main/java/com/vincent/rsf/server/manager/controller/StockStatisticController.java | 237 ++++++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 208 insertions(+), 29 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 8b549ac..33f0949 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
@@ -10,23 +10,31 @@
import com.vincent.rsf.server.common.domain.BaseParam;
import com.vincent.rsf.server.common.domain.KeyValVo;
import com.vincent.rsf.server.common.domain.PageParam;
+import com.vincent.rsf.server.common.service.ListExportHandler;
+import com.vincent.rsf.server.common.service.ListExportService;
import com.vincent.rsf.server.manager.entity.StockStatistic;
+import com.vincent.rsf.server.manager.enums.TaskStsType;
import com.vincent.rsf.server.manager.enums.TaskType;
import com.vincent.rsf.server.manager.service.StockStatisticService;
import com.vincent.rsf.server.manager.utils.buildPageRowsUtils;
import com.vincent.rsf.server.system.controller.BaseController;
+import org.springframework.beans.BeanWrapper;
+import org.springframework.beans.BeanWrapperImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import jakarta.servlet.http.HttpServletResponse;
import java.util.*;
+import java.util.function.Function;
@RestController
public class StockStatisticController extends BaseController {
@Autowired
private StockStatisticService stockStatisticService;
+ @Autowired
+ private ListExportService listExportService;
@PreAuthorize("hasAuthority('manager:stockStatistic:list')")
@PostMapping("/stockStatistic/page")
@@ -42,11 +50,7 @@
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("MIN(id) AS id, day_time, task_type, task_status, " +
- "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, " +
- "SUM(anfme) AS anfme, MAX(unit) AS unit");
- wrapper.groupBy("day_time, task_type, task_status, matnr_code");
+ QueryWrapper<StockStatistic> wrapper = buildStatisticSummaryWrapper(pageParam);
PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper);
return R.ok().add(buildPageRowsUtils.rowsMap(page));
}
@@ -56,11 +60,7 @@
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("MIN(id) AS id, day_time, task_type, task_status, " +
- "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, " +
- "SUM(anfme) AS anfme, MAX(unit) AS unit");
- wrapper.groupBy("day_time, task_type, task_status, matnr_code");
+ QueryWrapper<StockStatistic> wrapper = buildStatisticSummaryWrapper(pageParam);
PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper);
return R.ok().add(buildPageRowsUtils.rowsMap(page));
}
@@ -70,11 +70,7 @@
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("MIN(id) AS id, loc_code, day_time, task_type, task_status, barcode, " +
- "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, SUM(anfme) AS anfme, " +
- "MAX(unit) AS unit, create_by, update_by, create_time, update_time");
- wrapper.groupBy("loc_code, day_time, task_type, task_status, barcode, matnr_code, create_by, update_by, create_time, update_time");
+ QueryWrapper<StockStatistic> wrapper = buildStatisticItemWrapper(pageParam);
PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper);
return R.ok().add(buildPageRowsUtils.rowsMap(page));
}
@@ -84,11 +80,7 @@
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("MIN(id) AS id, loc_code, day_time, task_type, task_status, barcode, " +
- "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, SUM(anfme) AS anfme, " +
- "MAX(unit) AS unit, create_by, update_by, create_time, update_time");
- wrapper.groupBy("loc_code, day_time, task_type, task_status, barcode, matnr_code, create_by, update_by, create_time, update_time");
+ QueryWrapper<StockStatistic> wrapper = buildStatisticItemWrapper(pageParam);
PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper);
return R.ok().add(buildPageRowsUtils.rowsMap(page));
}
@@ -98,14 +90,7 @@
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("MIN(id) AS id, day_time, COUNT(barcode) AS `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.in("task_type", Arrays.asList(TaskType.TASK_TYPE_IN.type, TaskType.TASK_TYPE_OUT.type)).groupBy("day_time");
+ QueryWrapper<StockStatistic> wrapper = buildStatisticNumWrapper(pageParam);
PageParam<StockStatistic, BaseParam> page = stockStatisticService.page(pageParam, wrapper);
return R.ok().add(buildPageRowsUtils.rowsMap(page));
}
@@ -119,6 +104,36 @@
@PreAuthorize("hasAuthority('manager:stockStatistic:list')")
@PostMapping({"/stockStatistic/many/{ids}", "/stockStatistics/many/{ids}"})
public R many(@PathVariable Long[] ids) {
+ return R.ok().add(buildPageRowsUtils.rowsMap(stockStatisticService.listByIds(Arrays.asList(ids))));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/outStatistic/many/{ids}")
+ public R outStatisticMany(@PathVariable Long[] ids) {
+ return R.ok().add(buildPageRowsUtils.rowsMap(stockStatisticService.listByIds(Arrays.asList(ids))));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/inStatistic/many/{ids}")
+ public R inStatisticMany(@PathVariable Long[] ids) {
+ return R.ok().add(buildPageRowsUtils.rowsMap(stockStatisticService.listByIds(Arrays.asList(ids))));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/inStatisticItem/many/{ids}")
+ public R inStatisticItemMany(@PathVariable Long[] ids) {
+ return R.ok().add(buildPageRowsUtils.rowsMap(stockStatisticService.listByIds(Arrays.asList(ids))));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/outStatisticItem/many/{ids}")
+ public R outStatisticItemMany(@PathVariable Long[] ids) {
+ return R.ok().add(buildPageRowsUtils.rowsMap(stockStatisticService.listByIds(Arrays.asList(ids))));
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/statistic/num/many/{ids}")
+ public R statisticNumMany(@PathVariable Long[] ids) {
return R.ok().add(buildPageRowsUtils.rowsMap(stockStatisticService.listByIds(Arrays.asList(ids))));
}
@@ -175,7 +190,171 @@
@PreAuthorize("hasAuthority('manager:stockStatistic:list')")
@PostMapping("/stockStatistic/export")
public void export(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
- ExcelUtil.build(ExcelUtil.create(buildPageRowsUtils.rowsMap(stockStatisticService.list()), StockStatistic.class), response);
+ listExportService.export(
+ map,
+ exportMap -> buildParam(exportMap, BaseParam.class),
+ createStockStatisticExportHandler("鏃ュ簱瀛樼粺璁℃姤琛�", pageParam -> pageParam.buildWrapper(true)),
+ response
+ );
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/inStatistic/export")
+ public void inStatisticExport(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+ listExportService.export(
+ map,
+ exportMap -> buildParam(exportMap, BaseParam.class),
+ createStockStatisticExportHandler("鏃ュ叆搴撴眹鎬绘煡璇�", this::buildStatisticSummaryWrapper),
+ response
+ );
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/outStatistic/export")
+ public void outStatisticExport(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+ listExportService.export(
+ map,
+ exportMap -> buildParam(exportMap, BaseParam.class),
+ createStockStatisticExportHandler("鏃ュ嚭搴撴眹鎬绘煡璇�", this::buildStatisticSummaryWrapper),
+ response
+ );
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/inStatisticItem/export")
+ public void inStatisticItemExport(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+ listExportService.export(
+ map,
+ exportMap -> buildParam(exportMap, BaseParam.class),
+ createStockStatisticExportHandler("鏃ュ叆搴撴槑缁嗘煡璇�", this::buildStatisticItemWrapper),
+ response
+ );
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/outStatisticItem/export")
+ public void outStatisticItemExport(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+ listExportService.export(
+ map,
+ exportMap -> buildParam(exportMap, BaseParam.class),
+ createStockStatisticExportHandler("鏃ュ嚭搴撴槑缁嗘煡璇�", this::buildStatisticItemWrapper),
+ response
+ );
+ }
+
+ @PreAuthorize("hasAuthority('manager:stockStatistic:list')")
+ @PostMapping("/statistic/num/export")
+ public void statisticNumExport(@RequestBody Map<String, Object> map, HttpServletResponse response) throws Exception {
+ listExportService.export(
+ map,
+ exportMap -> buildParam(exportMap, BaseParam.class),
+ createStockStatisticExportHandler("鏃ュ嚭鍏ュ簱姹囨�荤粺璁�", this::buildStatisticNumWrapper),
+ response
+ );
+ }
+
+ private QueryWrapper<StockStatistic> buildStatisticSummaryWrapper(PageParam<StockStatistic, BaseParam> pageParam) {
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("MIN(id) AS id, day_time, task_type, task_status, " +
+ "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, " +
+ "SUM(anfme) AS anfme, MAX(unit) AS unit");
+ wrapper.groupBy("day_time, task_type, task_status, matnr_code");
+ return wrapper;
+ }
+
+ private QueryWrapper<StockStatistic> buildStatisticItemWrapper(PageParam<StockStatistic, BaseParam> pageParam) {
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("MIN(id) AS id, loc_code, day_time, task_type, task_status, barcode, " +
+ "MAX(maktx) AS maktx, matnr_code, MAX(batch) AS batch, SUM(anfme) AS anfme, " +
+ "MAX(unit) AS unit, create_by, update_by, create_time, update_time");
+ wrapper.groupBy("loc_code, day_time, task_type, task_status, barcode, matnr_code, create_by, update_by, create_time, update_time");
+ return wrapper;
+ }
+
+ private QueryWrapper<StockStatistic> buildStatisticNumWrapper(PageParam<StockStatistic, BaseParam> pageParam) {
+ QueryWrapper<StockStatistic> wrapper = pageParam.buildWrapper(true);
+ wrapper.select("MIN(id) AS id, day_time, COUNT(barcode) AS `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.in("task_type", Arrays.asList(TaskType.TASK_TYPE_IN.type, TaskType.TASK_TYPE_OUT.type)).groupBy("day_time");
+ return wrapper;
+ }
+
+ private ListExportHandler<StockStatistic, BaseParam> createStockStatisticExportHandler(
+ String reportTitle,
+ Function<PageParam<StockStatistic, BaseParam>, QueryWrapper<StockStatistic>> wrapperBuilder
+ ) {
+ return new ListExportHandler<>() {
+ @Override
+ public List<StockStatistic> listByIds(List<Long> ids) {
+ return stockStatisticService.listByIds(ids);
+ }
+
+ @Override
+ public List<StockStatistic> listByFilter(Map<String, Object> sanitizedMap, BaseParam baseParam) {
+ PageParam<StockStatistic, BaseParam> pageParam = new PageParam<>(baseParam, StockStatistic.class);
+ return stockStatisticService.list(wrapperBuilder.apply(pageParam));
+ }
+
+ @Override
+ public void fillExportFields(List<StockStatistic> records) {
+ buildPageRowsUtils.rowsMap(records);
+ }
+
+ @Override
+ public Map<String, Object> toExportRow(StockStatistic record, List<ExcelUtil.ExportColumn> columns) {
+ return buildStockStatisticExportRow(record, columns);
+ }
+
+ @Override
+ public String defaultReportTitle() {
+ return reportTitle;
+ }
+ };
+ }
+
+ private Map<String, Object> buildStockStatisticExportRow(StockStatistic record, List<ExcelUtil.ExportColumn> columns) {
+ BeanWrapper beanWrapper = new BeanWrapperImpl(record);
+ Map<String, Object> row = new LinkedHashMap<>();
+ row.put("dayTimeText", record.getDayTime());
+ row.put("taskTypeText", record.getTaskType$());
+ row.put("taskStatusText", getTaskStatusText(record.getTaskStatus()));
+ row.put("locCode", record.getLocCode());
+ row.put("barcode", record.getBarcode());
+ row.put("matnrCode", record.getMatnrCode());
+ row.put("maktx", record.getMaktx());
+ row.put("batch", record.getBatch());
+ row.put("unit", record.getUnit());
+ row.put("anfme", record.getAnfme());
+ row.put("createByText", record.getCreateBy$());
+ row.put("createTimeText", record.getCreateTime$());
+ row.put("updateByText", record.getUpdateBy$());
+ row.put("updateTimeText", record.getUpdateTime$());
+
+ for (ExcelUtil.ExportColumn column : columns) {
+ if (row.containsKey(column.getSource())) {
+ continue;
+ }
+ if (beanWrapper.isReadableProperty(column.getSource())) {
+ row.put(column.getSource(), beanWrapper.getPropertyValue(column.getSource()));
+ }
+ }
+ return row;
+ }
+
+ private String getTaskStatusText(Integer taskStatus) {
+ if (taskStatus == null) {
+ return "";
+ }
+ for (TaskStsType type : TaskStsType.values()) {
+ if (Objects.equals(type.id, taskStatus)) {
+ return type.desc;
+ }
+ }
+ return String.valueOf(taskStatus);
}
}
--
Gitblit v1.9.1