From 5f612ab2f67b2c6f6894c624a7780799526d566d Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期四, 05 十一月 2026 20:20:05 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_business_新高电力' into dev_business_新高电力

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/workorder/MesProWorkOrderController.java |   36 ++++++++++++++++++++++++++++++++----
 1 files changed, 32 insertions(+), 4 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/workorder/MesProWorkOrderController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/workorder/MesProWorkOrderController.java
index b6233cd..fe36c14 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/workorder/MesProWorkOrderController.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/pro/workorder/MesProWorkOrderController.java
@@ -29,6 +29,7 @@
 import cn.iocoder.yudao.module.srm.api.supplier.dto.SrmSupplierRespDTO;
 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;
@@ -36,6 +37,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.math.BigDecimal;
@@ -96,7 +98,6 @@
     @GetMapping("/get")
     @Operation(summary = "鑾峰緱鐢熶骇宸ュ崟")
     @Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
-    @PreAuthorize("@ss.hasPermission('mes:pro-work-order:query')")
     public CommonResult<MesProWorkOrderRespVO> getWorkOrder(@RequestParam("id") Long id) {
         MesProWorkOrderDO workOrder = workOrderService.getWorkOrder(id);
         if (workOrder == null) {
@@ -107,7 +108,6 @@
 
     @GetMapping("/page")
     @Operation(summary = "鑾峰緱鐢熶骇宸ュ崟鍒嗛〉")
-    @PreAuthorize("@ss.hasPermission('mes:pro-work-order:query')")
     public CommonResult<PageResult<MesProWorkOrderRespVO>> getWorkOrderPage(@Valid MesProWorkOrderPageReqVO pageReqVO) {
         PageResult<MesProWorkOrderDO> pageResult = workOrderService.getWorkOrderPage(pageReqVO);
         return success(new PageResult<>(buildWorkOrderRespVOList(pageResult.getList()), pageResult.getTotal()));
@@ -115,7 +115,6 @@
 
     @GetMapping("/schedule-page")
     @Operation(summary = "鑾峰緱鐢熶骇宸ュ崟璋冨害鐘舵�佸垎椤�")
-    @PreAuthorize("@ss.hasPermission('mes:pro-work-order:query')")
     public CommonResult<PageResult<MesProWorkOrderRespVO>> getWorkOrderSchedulePage(@Valid MesProWorkOrderPageReqVO pageReqVO) {
         PageResult<MesProWorkOrderDO> pageResult = workOrderService.getWorkOrderSchedulePage(pageReqVO);
         return success(new PageResult<>(buildWorkOrderRespVOList(pageResult.getList()), pageResult.getTotal()));
@@ -131,6 +130,36 @@
         List<MesProWorkOrderDO> list = workOrderService.getWorkOrderPage(pageReqVO).getList();
         List<MesProWorkOrderRespVO> voList = buildWorkOrderRespVOList(list);
         ExcelUtils.write(response, "鐢熶骇宸ュ崟.xls", "鏁版嵁", MesProWorkOrderRespVO.class, voList);
+    }
+
+    @GetMapping("/get-import-template")
+    @Operation(summary = "鑾峰緱鐢熶骇宸ュ崟瀵煎叆妯℃澘")
+    public void importTemplate(HttpServletResponse response) throws IOException {
+        // 鎵嬪姩鍒涘缓瀵煎嚭 demo
+        List<MesProWorkOrderImportExcelVO> list = Collections.singletonList(
+                MesProWorkOrderImportExcelVO.builder()
+                        .code("WO-001").name("绀轰緥鐢熶骇宸ュ崟").type(1).orderSourceType(1)
+                        .orderSourceCode("").productCode("").quantity(new BigDecimal("100"))
+                        .clientName("").saleOrderNo("").batchCode("")
+                        .requestDate(java.time.LocalDateTime.of(2026, 10, 16, 9, 0, 0))
+                        .remark("").build()
+        );
+        // 杈撳嚭
+        ExcelUtils.writeTemplate(response, "鐢熶骇宸ュ崟瀵煎叆妯℃澘.xls", "鐢熶骇宸ュ崟鍒楄〃", MesProWorkOrderImportExcelVO.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-work-order:import')")
+    public CommonResult<MesProWorkOrderImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
+                                                                 @RequestParam(value = "updateSupport", required = false,
+                                                                         defaultValue = "false") Boolean updateSupport) throws Exception {
+        List<MesProWorkOrderImportExcelVO> list = ExcelUtils.read(file, MesProWorkOrderImportExcelVO.class);
+        return success(workOrderService.importWorkOrderList(list, updateSupport));
     }
 
     @PutMapping("/confirm")
@@ -163,7 +192,6 @@
     @GetMapping("/progress/{id}")
     @Operation(summary = "鑾峰彇宸ュ崟杩涘害璇︽儏")
     @Parameter(name = "id", description = "缂栧彿", required = true)
-    @PreAuthorize("@ss.hasPermission('mes:pro-work-order:query')")
     public CommonResult<MesProWorkOrderProgressRespVO> getWorkOrderProgress(@PathVariable("id") Long id) {
         return success(workOrderService.getWorkOrderProgress(id));
     }

--
Gitblit v1.9.3