From 381e02b9eccbe953b31d09f2af1c2ce77c816140 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期六, 07 十一月 2026 14:51:05 +0800
Subject: [PATCH] fix(mes): 隔离设备物料并支持销售产品映射

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/mps/MesProMpsController.java |   34 +++++++++++++++++++++++++++++++---
 1 files changed, 31 insertions(+), 3 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/mps/MesProMpsController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/mps/MesProMpsController.java
index b174b5a..32c9bad 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/mps/MesProMpsController.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/mps/MesProMpsController.java
@@ -9,6 +9,8 @@
 import cn.iocoder.yudao.framework.common.util.collection.MapUtils;
 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.mps.vo.MesProMpsImportExcelVO;
+import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsImportRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsPageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.pro.mps.vo.MesProMpsSaveReqVO;
@@ -20,6 +22,7 @@
 import cn.iocoder.yudao.module.mes.service.pro.mps.MesProMpsService;
 import io.swagger.v3.oas.annotations.Operation;
 import io.swagger.v3.oas.annotations.Parameter;
+import io.swagger.v3.oas.annotations.Parameters;
 import io.swagger.v3.oas.annotations.tags.Tag;
 import jakarta.annotation.Resource;
 import jakarta.servlet.http.HttpServletResponse;
@@ -27,6 +30,7 @@
 import org.springframework.security.access.prepost.PreAuthorize;
 import org.springframework.validation.annotation.Validated;
 import org.springframework.web.bind.annotation.*;
+import org.springframework.web.multipart.MultipartFile;
 
 import java.io.IOException;
 import java.util.Collections;
@@ -77,7 +81,6 @@
     @GetMapping("/get")
     @Operation(summary = "鑾峰緱鐢熶骇涓昏鍒�")
     @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
-    @PreAuthorize("@ss.hasPermission('mes:pro-mps:query')")
     public CommonResult<MesProMpsRespVO> getMps(@RequestParam("id") Long id) {
         MesProMpsDO mps = mpsService.getMps(id);
         if (mps == null) {
@@ -88,7 +91,6 @@
 
     @GetMapping("/page")
     @Operation(summary = "鑾峰緱鐢熶骇涓昏鍒掑垎椤�")
-    @PreAuthorize("@ss.hasPermission('mes:pro-mps:query')")
     public CommonResult<PageResult<MesProMpsRespVO>> getMpsPage(@Valid MesProMpsPageReqVO pageReqVO) {
         PageResult<MesProMpsDO> pageResult = mpsService.getMpsPage(pageReqVO);
         return success(new PageResult<>(buildMpsRespVOList(pageResult.getList()), pageResult.getTotal()));
@@ -104,6 +106,32 @@
         List<MesProMpsDO> list = mpsService.getMpsPage(pageReqVO).getList();
         List<MesProMpsRespVO> voList = buildMpsRespVOList(list);
         ExcelUtils.write(response, "鐢熶骇涓昏鍒�.xls", "鏁版嵁", MesProMpsRespVO.class, voList);
+    }
+
+    @GetMapping("/get-import-template")
+    @Operation(summary = "鑾峰緱鐢熶骇涓昏鍒掑鍏ユā鏉�")
+    public void importTemplate(HttpServletResponse response) throws IOException {
+        List<MesProMpsImportExcelVO> list = Collections.singletonList(
+                MesProMpsImportExcelVO.builder()
+                        .code("MPS-001").saleOrderNo("").productCode("").quantity(new java.math.BigDecimal("100"))
+                        .clientName("").requestDate(java.time.LocalDateTime.of(2026, 10, 16, 9, 0, 0))
+                        .remark("").build()
+        );
+        ExcelUtils.writeTemplate(response, "鐢熶骇涓昏鍒掑鍏ユā鏉�.xls", "鐢熶骇涓昏鍒掑垪琛�", MesProMpsImportExcelVO.class, list);
+    }
+
+    @PostMapping("/import")
+    @Operation(summary = "瀵煎叆鐢熶骇涓昏鍒�")
+    @Parameters({
+            @Parameter(name = "file", description = "Excel 鏂囦欢", required = true),
+            @Parameter(name = "updateSupport", description = "鏄惁鏀寔鏇存柊锛岄粯璁や负 false", example = "true")
+    })
+    @PreAuthorize("@ss.hasPermission('mes:pro-mps:import')")
+    public CommonResult<MesProMpsImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
+                                                           @RequestParam(value = "updateSupport", required = false,
+                                                                   defaultValue = "false") Boolean updateSupport) throws Exception {
+        List<MesProMpsImportExcelVO> list = ExcelUtils.read(file, MesProMpsImportExcelVO.class);
+        return success(mpsService.importMpsList(list, updateSupport));
     }
 
     @PostMapping("/issue")
@@ -153,4 +181,4 @@
         });
     }
 
-}
\ No newline at end of file
+}

--
Gitblit v1.9.3