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/MesWmWarehouseServiceImpl.java |  111 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 111 insertions(+), 0 deletions(-)

diff --git a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseServiceImpl.java b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseServiceImpl.java
index bd85c14..3acfece 100644
--- a/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseServiceImpl.java
+++ b/yudao-module-mes/src/main/java/cn/iocoder/yudao/module/mes/service/wm/warehouse/MesWmWarehouseServiceImpl.java
@@ -2,8 +2,11 @@
 
 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.MesWmWarehouseImportExcelVO;
+import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.MesWmWarehouseImportRespVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.MesWmWarehousePageReqVO;
 import cn.iocoder.yudao.module.mes.controller.admin.wm.warehouse.vo.MesWmWarehouseSaveReqVO;
 import cn.iocoder.yudao.module.mes.dal.dataobject.wm.warehouse.MesWmWarehouseDO;
@@ -12,14 +15,20 @@
 import cn.iocoder.yudao.module.mes.service.md.workstation.MesMdWorkstationService;
 import cn.iocoder.yudao.module.mes.service.wm.barcode.MesWmBarcodeService;
 import cn.iocoder.yudao.module.mes.service.wm.materialstock.MesWmMaterialStockService;
+import cn.iocoder.yudao.module.system.api.user.AdminUserApi;
+import cn.iocoder.yudao.module.system.api.user.dto.AdminUserRespDTO;
 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.*;
@@ -33,6 +42,9 @@
 
     @Resource
     private MesWmWarehouseMapper warehouseMapper;
+
+    @Resource
+    private AdminUserApi adminUserApi;
 
     @Resource
     private MesWmWarehouseLocationService locationService;
@@ -183,4 +195,103 @@
         return null;
     }
 
+    @Override
+    @Transactional(rollbackFor = Exception.class)
+    public MesWmWarehouseImportRespVO importWarehouseList(List<MesWmWarehouseImportExcelVO> importList, boolean updateSupport) {
+        // 鏍¢獙瀵煎叆鏁版嵁涓嶈兘涓虹┖
+        if (CollUtil.isEmpty(importList)) {
+            throw exception(WM_WAREHOUSE_IMPORT_LIST_IS_EMPTY);
+        }
+        MesWmWarehouseImportRespVO respVO = MesWmWarehouseImportRespVO.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 (MesWmWarehouseDO.WIP_VIRTUAL_WAREHOUSE.equals(code)) {
+                respVO.getFailureCodes().put(key, "铏氭嫙浠撳簱涓嶅厑璁稿鍏�");
+                return;
+            }
+            // 鎸夊悕绉拌В鏋愯礋璐d汉
+            Long chargeUserId = null;
+            if (StrUtil.isNotBlank(importItem.getChargeUserName())) {
+                chargeUserId = resolveChargeUserId(importItem.getChargeUserName());
+                if (chargeUserId == null) {
+                    respVO.getFailureCodes().put(key, "璐熻矗浜轰笉瀛樺湪锛�" + importItem.getChargeUserName());
+                    return;
+                }
+            }
+            MesWmWarehouseDO existingByCode = warehouseMapper.selectByCode(code);
+            MesWmWarehouseDO existingByName = warehouseMapper.selectByName(importItem.getName());
+            if (existingByCode != null && updateSupport) {
+                // 鍚嶇О鍞竴鏍¢獙锛堟帓闄よ嚜宸憋級
+                if (existingByName != null && !existingByCode.getId().equals(existingByName.getId())) {
+                    respVO.getFailureCodes().put(key, "浠撳簱鍚嶇О宸插瓨鍦細" + importItem.getName());
+                    return;
+                }
+                // 鏇存柊
+                MesWmWarehouseDO updateObj = new MesWmWarehouseDO();
+                updateObj.setId(existingByCode.getId());
+                updateObj.setName(importItem.getName());
+                updateObj.setType(importItem.getType());
+                updateObj.setAddress(importItem.getAddress());
+                updateObj.setArea(importItem.getArea());
+                updateObj.setChargeUserId(chargeUserId);
+                updateObj.setFrozen(importItem.getFrozen());
+                updateObj.setRemark(importItem.getRemark());
+                warehouseMapper.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;
+                }
+                // 鍒涘缓
+                MesWmWarehouseDO createObj = new MesWmWarehouseDO();
+                createObj.setId(null);
+                createObj.setCode(code);
+                createObj.setName(importItem.getName());
+                createObj.setType(importItem.getType());
+                createObj.setAddress(importItem.getAddress());
+                createObj.setArea(importItem.getArea());
+                createObj.setChargeUserId(chargeUserId);
+                createObj.setFrozen(ObjUtil.defaultIfNull(importItem.getFrozen(), Boolean.FALSE));
+                createObj.setRemark(importItem.getRemark());
+                warehouseMapper.insert(createObj);
+                // 鑷姩鐢熸垚鏉$爜
+                barcodeService.autoGenerateBarcode(BarcodeBizTypeEnum.WAREHOUSE.getValue(),
+                        createObj.getId(), createObj.getCode(), createObj.getName());
+                respVO.getCreateCodes().add(code);
+            }
+        });
+        return respVO;
+    }
+
+    private Long resolveChargeUserId(String chargeUserName) {
+        List<AdminUserRespDTO> users = adminUserApi.getUserListByNickname(chargeUserName);
+        for (AdminUserRespDTO user : users) {
+            if (chargeUserName.equals(user.getNickname())) {
+                return user.getId();
+            }
+        }
+        return null;
+    }
+
 }

--
Gitblit v1.9.3