From f57a9de2dbe69e7f867b39c25abdab58b401a2df Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期六, 07 十一月 2026 16:01:32 +0800
Subject: [PATCH] fix(mes): 过滤异常未来遥测时间
---
yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/returnsales/MesWmReturnSalesController.java | 53 +++++++++++++++++++++++++++++++++++++++--------------
1 files changed, 39 insertions(+), 14 deletions(-)
diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/returnsales/MesWmReturnSalesController.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/returnsales/MesWmReturnSalesController.java
index d765f69..dd79c64 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/returnsales/MesWmReturnSalesController.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/controller/admin/wm/returnsales/MesWmReturnSalesController.java
@@ -8,15 +8,18 @@
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.crm.api.customer.CrmCustomerApi;
+import cn.iocoder.yudao.module.crm.api.customer.dto.CrmCustomerRespDTO;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.returnsales.vo.MesWmReturnSalesImportExcelVO;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.returnsales.vo.MesWmReturnSalesImportRespVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.returnsales.vo.MesWmReturnSalesPageReqVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.returnsales.vo.MesWmReturnSalesRespVO;
import cn.iocoder.yudao.module.mes.controller.admin.wm.returnsales.vo.MesWmReturnSalesSaveReqVO;
-import cn.iocoder.yudao.module.mes.dal.dataobject.md.client.MesMdClientDO;
import cn.iocoder.yudao.module.mes.dal.dataobject.wm.returnsales.MesWmReturnSalesDO;
-import cn.iocoder.yudao.module.mes.service.md.client.MesMdClientService;
import cn.iocoder.yudao.module.mes.service.wm.returnsales.MesWmReturnSalesService;
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;
@@ -24,6 +27,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;
@@ -34,11 +38,6 @@
import static cn.iocoder.yudao.framework.common.pojo.CommonResult.success;
import static cn.iocoder.yudao.framework.common.util.collection.CollectionUtils.convertSet;
-/**
- * 绠＄悊鍚庡彴 - MES 閿�鍞��璐у崟 Controller
- *
- * @author 鑺嬮亾婧愮爜
- */
@Tag(name = "绠＄悊鍚庡彴 - MES 閿�鍞��璐у崟")
@RestController
@RequestMapping("/mes/wm/return-sales")
@@ -48,7 +47,7 @@
@Resource
private MesWmReturnSalesService returnSalesService;
@Resource
- private MesMdClientService clientService;
+ private CrmCustomerApi crmCustomerApi;
@PostMapping("/create")
@Operation(summary = "鍒涘缓閿�鍞��璐у崟")
@@ -77,7 +76,6 @@
@GetMapping("/get")
@Operation(summary = "鑾峰緱閿�鍞��璐у崟")
@Parameter(name = "id", description = "缂栧彿", required = true, example = "1024")
- @PreAuthorize("@ss.hasPermission('mes:wm-return-sales:query')")
public CommonResult<MesWmReturnSalesRespVO> getReturnSales(@RequestParam("id") Long id) {
MesWmReturnSalesDO returnSales = returnSalesService.getReturnSales(id);
if (returnSales == null) {
@@ -88,7 +86,6 @@
@GetMapping("/page")
@Operation(summary = "鑾峰緱閿�鍞��璐у崟鍒嗛〉")
- @PreAuthorize("@ss.hasPermission('mes:wm-return-sales:query')")
public CommonResult<PageResult<MesWmReturnSalesRespVO>> getReturnSalesPage(
@Valid MesWmReturnSalesPageReqVO pageReqVO) {
PageResult<MesWmReturnSalesDO> pageResult = returnSalesService.getReturnSalesPage(pageReqVO);
@@ -146,9 +143,37 @@
@GetMapping("/check-quantity")
@Operation(summary = "鏍￠獙閿�鍞��璐у崟鏁伴噺", description = "鏍￠獙姣忚鏄庣粏鏁伴噺涔嬪拰鏄惁绛変簬琛岄��璐ф暟閲�")
@Parameter(name = "id", description = "缂栧彿", required = true)
- @PreAuthorize("@ss.hasPermission('mes:wm-return-sales:query')")
public CommonResult<Boolean> checkReturnSalesQuantity(@RequestParam("id") Long id) {
return success(returnSalesService.checkReturnSalesQuantity(id));
+ }
+
+ @GetMapping("/get-import-template")
+ @Operation(summary = "鑾峰緱閿�鍞��璐у崟瀵煎叆妯℃澘")
+ public void importTemplate(HttpServletResponse response) throws IOException {
+ // 鎵嬪姩鍒涘缓瀵煎嚭 demo
+ List<MesWmReturnSalesImportExcelVO> list = Collections.singletonList(
+ MesWmReturnSalesImportExcelVO.builder()
+ .code("RS202603010001").name("绀轰緥閿�鍞��璐у崟")
+ .salesOrderCode("SO202603010001")
+ .returnDate(java.time.LocalDate.of(2026, 3, 1))
+ .returnReason("璐ㄩ噺闂").remark("").build()
+ );
+ // 杈撳嚭
+ ExcelUtils.writeTemplate(response, "閿�鍞��璐у崟瀵煎叆妯℃澘.xls", "閿�鍞��璐у崟鍒楄〃", MesWmReturnSalesImportExcelVO.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:wm-return-sales:import')")
+ public CommonResult<MesWmReturnSalesImportRespVO> importExcel(@RequestParam("file") MultipartFile file,
+ @RequestParam(value = "updateSupport", required = false,
+ defaultValue = "false") Boolean updateSupport) throws Exception {
+ List<MesWmReturnSalesImportExcelVO> list = ExcelUtils.read(file, MesWmReturnSalesImportExcelVO.class);
+ return success(returnSalesService.importReturnSalesList(list, updateSupport));
}
// ==================== 鎷兼帴 VO ====================
@@ -158,12 +183,12 @@
return Collections.emptyList();
}
// 1. 鑾峰緱鍏宠仈鏁版嵁
- Map<Long, MesMdClientDO> clientMap = clientService.getClientMap(
+ Map<Long, CrmCustomerRespDTO> customerMap = crmCustomerApi.getCustomerMap(
convertSet(list, MesWmReturnSalesDO::getClientId));
// 2. 鏋勫缓缁撴灉
return BeanUtils.toBean(list, MesWmReturnSalesRespVO.class, vo ->
- MapUtils.findAndThen(clientMap, vo.getClientId(), client ->
- vo.setClientCode(client.getCode()).setClientName(client.getName()).setClientNickname(client.getNickname())));
+ MapUtils.findAndThen(customerMap, vo.getClientId(), customer ->
+ vo.setClientName(customer.getName())));
}
}
--
Gitblit v1.9.3