From 883f5e73fbe7458fd760dbe8560dd5d8757e04cd Mon Sep 17 00:00:00 2001
From: xiaoyi <908147524@qq.com>
Date: 星期三, 04 十一月 2026 13:56:29 +0800
Subject: [PATCH] refactor: 按需求表收敛范围,撤销非需求模块,补齐售后回访闭环

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/route/MesProRouteController.java |   51 ++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 50 insertions(+), 1 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/route/MesProRouteController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/route/MesProRouteController.java
index cca2c02..74882f8 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/route/MesProRouteController.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/route/MesProRouteController.java
@@ -8,11 +8,20 @@
 import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
 import cn.iocoder.yudao.framework.excel.core.util.ExcelUtils;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo.MesProRouteImportExcelVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo.MesProRouteFullExcelVO;
+import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteFullExcelService;
+import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteFullImportService;
+import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteWorkbookService;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo.MesProRouteImportRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo.MesProRoutePageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo.MesProRouteRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.route.vo.MesProRouteSaveReqVO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.pro.route.MesProRouteDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.pro.route.MesProRouteProductDO;
+import cn.iocoder.yudao.module.mes.dal.dataobject.md.item.MesMdItemDO;
+import cn.iocoder.yudao.module.mes.dal.mysql.pro.route.MesProRouteProductMapper;
+import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX;
+import cn.iocoder.yudao.module.mes.service.md.item.MesMdItemService;
 import cn.iocoder.yudao.module.mes.service.pro.route.MesProRouteService;
 import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.Parameter;
@@ -42,6 +51,16 @@
 
     @Resource
     private MesProRouteService routeService;
+    @Resource
+    private MesProRouteFullExcelService fullExcelService;
+    @Resource
+    private MesProRouteFullImportService fullImportService;
+    @Resource
+    private MesProRouteWorkbookService routeWorkbookService;
+    @Resource
+    private MesProRouteProductMapper routeProductMapper;
+    @Resource
+    private MesMdItemService itemService;
 
     @PostMapping("/create")
     @Operation(summary = "鍒涘缓宸ヨ壓璺嚎")
@@ -92,7 +111,21 @@
     @Operation(summary = "鑾峰緱宸ヨ壓璺嚎鍒嗛〉")
     public CommonResult<PageResult<MesProRouteRespVO>> getRoutePage(@Valid MesProRoutePageReqVO pageReqVO) {
         PageResult<MesProRouteDO> pageResult = routeService.getRoutePage(pageReqVO);
-        return success(BeanUtils.toBean(pageResult, MesProRouteRespVO.class));
+        PageResult<MesProRouteRespVO> response = BeanUtils.toBean(pageResult, MesProRouteRespVO.class);
+        if (!pageResult.getList().isEmpty()) {
+            var routeIds = pageResult.getList().stream().map(MesProRouteDO::getId).toList();
+            var references = routeProductMapper.selectList(new LambdaQueryWrapperX<MesProRouteProductDO>()
+                    .in(MesProRouteProductDO::getRouteId, routeIds).eq(MesProRouteProductDO::getTemplateReference, true));
+            var items = itemService.getItemMap(references.stream().map(MesProRouteProductDO::getItemId).toList());
+            var byRoute = references.stream().collect(java.util.stream.Collectors.toMap(
+                    MesProRouteProductDO::getRouteId, r -> r, (first, ignored) -> first));
+            response.getList().forEach(vo -> {
+                var reference = byRoute.get(vo.getId());
+                MesMdItemDO item = reference == null ? null : items.get(reference.getItemId());
+                if (item != null) { vo.setReferenceProductCode(item.getCode()); vo.setReferenceProductName(item.getName()); }
+            });
+        }
+        return success(response);
     }
 
     @GetMapping("/simple-list")
@@ -115,6 +148,22 @@
         ExcelUtils.write(response, "宸ヨ壓璺嚎.xls", "鏁版嵁", MesProRouteRespVO.class, data);
     }
 
+    @GetMapping("/get-full-import-template")
+    @Operation(summary = "涓嬭浇鎸囧畾宸ヨ壓璺嚎鍙傝�冧骇鍝併�佸伐搴忋�佷骇鍑哄拰鎶曟枡鐨勫畬鏁存ā鏉�")
+    @PreAuthorize("@ss.hasPermission('mes:pro-route:import')")
+    public void fullImportTemplate(@RequestParam("routeId") Long routeId, HttpServletResponse response) throws IOException {
+        List<MesProRouteFullExcelVO> rows = fullExcelService.exportRouteReference(routeId);
+        routeWorkbookService.write(response, rows);
+    }
+
+    @PostMapping("/import-full")
+    @Operation(summary = "鎸夎矾绾夸簨鍔″鍏ュ畬鏁村伐鑹烘祦绋�")
+    @PreAuthorize("@ss.hasPermission('mes:pro-route:import')")
+    public CommonResult<MesProRouteImportRespVO> importFull(@RequestParam("file") MultipartFile file,
+            @RequestParam(value = "updateSupport", required = false, defaultValue = "false") Boolean updateSupport) throws IOException {
+        return success(fullImportService.importRows(routeWorkbookService.read(file), updateSupport));
+    }
+
     @GetMapping("/get-import-template")
     @Operation(summary = "鑾峰緱宸ヨ壓璺嚎瀵煎叆妯℃澘")
     public void importTemplate(HttpServletResponse response) throws IOException {

--
Gitblit v1.9.3