From d54fbc9d4f8981fa0f7f613b33a28a8cd4f764ea Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期日, 25 十月 2026 16:29:53 +0800
Subject: [PATCH] feat(system): 优化用户搜索功能并完善ERP和MES模块验证逻辑

---
 yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseLocationServiceImpl.java |   98 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 98 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseLocationServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseLocationServiceImpl.java
index b2f7617..9ea766c 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseLocationServiceImpl.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseLocationServiceImpl.java
@@ -2,13 +2,17 @@
 
 import cn.hutool.core.collection.CollUtil;
 import cn.hutool.core.util.ObjUtil;
+import cn.hutool.core.util.StrUtil;
 import cn.iocoder.yudao.framework.common.pojo.PageResult;
 import cn.iocoder.yudao.framework.common.util.object.BeanUtils;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationImportExcelVO;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationImportRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationPageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.location.MesWmWarehouseLocationSaveReqVO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseDO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseLocationDO;
 import cn.iocoder.yudao.module.mes.dal.mysql.wm.warehouse.MesWmWarehouseLocationMapper;
+import cn.iocoder.yudao.module.mes.dal.mysql.wm.warehouse.MesWmWarehouseMapper;
 import cn.iocoder.yudao.module.mes.enums.wm.BarcodeBizTypeEnum;
 import cn.iocoder.yudao.module.mes.service.md.workstation.MesMdWorkstationService;
 import cn.iocoder.yudao.module.mes.service.wm.barcode.MesWmBarcodeService;
@@ -16,11 +20,15 @@
 import jakarta.annotation.Resource;
 import org.springframework.context.annotation.Lazy;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 import org.springframework.validation.annotation.Validated;
 
+import java.util.ArrayList;
 import java.util.Collection;
 import java.util.Collections;
+import java.util.LinkedHashMap;
 import java.util.List;
+import java.util.concurrent.atomic.AtomicInteger;
 
 import static cn.iocoder.yudao.framework.common.exception.util.ServiceExceptionUtil.exception;
 import static cn.iocoder.yudao.module.mes.enums.ErrorCodeConstants.*;
@@ -34,6 +42,9 @@
 
     @Resource
     private MesWmWarehouseLocationMapper locationMapper;
+
+    @Resource
+    private MesWmWarehouseMapper warehouseMapper;
 
     @Resource
     private MesWmWarehouseAreaService areaService;
@@ -198,4 +209,91 @@
         return null;
     }
 
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public MesWmWarehouseLocationImportRespVO importWarehouseLocationList(List<MesWmWarehouseLocationImportExcelVO> importList, boolean updateSupport) {
+        // 鏍¢獙瀵煎叆鏁版嵁涓嶈兘涓虹┖
+        if (CollUtil.isEmpty(importList)) {
+            throw exception(WM_WAREHOUSE_LOCATION_IMPORT_LIST_IS_EMPTY);
+        }
+        MesWmWarehouseLocationImportRespVO respVO = MesWmWarehouseLocationImportRespVO.builder()
+                .createCodes(new ArrayList<>()).updateCodes(new ArrayList<>())
+                .failureCodes(new LinkedHashMap<>()).build();
+        // 绱㈠紩锛岀敤浜庨敊璇彁绀�
+        AtomicInteger index = new AtomicInteger(1);
+        importList.forEach(importItem -> {
+            int currentIndex = index.getAndIncrement();
+            String code = importItem.getCode();
+            String key = StrUtil.blankToDefault(code, "绗� " + currentIndex + " 琛�");
+            // 鏍¢獙缂栫爜蹇呭~
+            if (StrUtil.isBlank(code)) {
+                respVO.getFailureCodes().put(key, "搴撳尯缂栫爜涓嶈兘涓虹┖");
+                return;
+            }
+            // 鏍¢獙鍚嶇О蹇呭~
+            if (StrUtil.isBlank(importItem.getName())) {
+                respVO.getFailureCodes().put(key, "搴撳尯鍚嶇О涓嶈兘涓虹┖");
+                return;
+            }
+            // 鏍¢獙铏氭嫙搴撳尯涓嶅厑璁稿鍏�
+            if (MesWmWarehouseLocationDO.WIP_VIRTUAL_LOCATION.equals(code)) {
+                respVO.getFailureCodes().put(key, "铏氭嫙搴撳尯涓嶅厑璁稿鍏�");
+                return;
+            }
+            // 鎸夊悕绉拌В鏋愭墍灞炰粨搴�
+            if (StrUtil.isBlank(importItem.getWarehouseName())) {
+                respVO.getFailureCodes().put(key, "鎵�灞炰粨搴撲笉鑳戒负绌�");
+                return;
+            }
+            MesWmWarehouseDO warehouse = warehouseMapper.selectByName(importItem.getWarehouseName());
+            if (warehouse == null) {
+                respVO.getFailureCodes().put(key, "浠撳簱涓嶅瓨鍦細" + importItem.getWarehouseName());
+                return;
+            }
+            Long warehouseId = warehouse.getId();
+            MesWmWarehouseLocationDO existingByCode = locationMapper.selectByCode(warehouseId, code);
+            MesWmWarehouseLocationDO existingByName = locationMapper.selectByName(warehouseId, importItem.getName());
+            if (existingByCode != null && updateSupport) {
+                // 鍚嶇О鍞竴鏍¢獙锛堟帓闄よ嚜宸憋級
+                if (existingByName != null && !existingByCode.getId().equals(existingByName.getId())) {
+                    respVO.getFailureCodes().put(key, "搴撳尯鍚嶇О宸插瓨鍦細" + importItem.getName());
+                    return;
+                }
+                // 鏇存柊
+                MesWmWarehouseLocationDO updateObj = new MesWmWarehouseLocationDO();
+                updateObj.setId(existingByCode.getId());
+                updateObj.setName(importItem.getName());
+                updateObj.setWarehouseId(warehouseId);
+                updateObj.setArea(importItem.getArea());
+                updateObj.setFrozen(importItem.getFrozen());
+                updateObj.setRemark(importItem.getRemark());
+                locationMapper.updateById(updateObj);
+                respVO.getUpdateCodes().add(code);
+            } else if (existingByCode != null) {
+                respVO.getFailureCodes().put(key, "搴撳尯缂栫爜宸插瓨鍦細" + code);
+            } else {
+                // 鍚嶇О鍞竴鏍¢獙
+                if (existingByName != null) {
+                    respVO.getFailureCodes().put(key, "搴撳尯鍚嶇О宸插瓨鍦細" + importItem.getName());
+                    return;
+                }
+                // 鍒涘缓
+                MesWmWarehouseLocationDO createObj = new MesWmWarehouseLocationDO();
+                createObj.setId(null);
+                createObj.setCode(code);
+                createObj.setName(importItem.getName());
+                createObj.setWarehouseId(warehouseId);
+                createObj.setArea(importItem.getArea());
+                createObj.setFrozen(ObjUtil.defaultIfNull(importItem.getFrozen(), Boolean.FALSE));
+                createObj.setRemark(importItem.getRemark());
+                locationMapper.insert(createObj);
+                // 鑷姩鐢熸垚鏉$爜
+                barcodeService.autoGenerateBarcode(BarcodeBizTypeEnum.LOCATION.getValue(),
+                        createObj.getId(), createObj.getCode(), createObj.getName());
+                respVO.getCreateCodes().add(code);
+            }
+        });
+        return respVO;
+    }
+
 }

--
Gitblit v1.9.3