From 581aae987e17d99f9e62275b22502ad08d748696 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 21 八月 2026 09:31:00 +0800
Subject: [PATCH] 物料管理/物料分类/计量单位增加Excel导入功能
---
yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/unit/MdmUnitMeasureServiceImpl.java | 72 ++++++++++++++++++++++++++++++++++++
1 files changed, 72 insertions(+), 0 deletions(-)
diff --git a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/unit/MdmUnitMeasureServiceImpl.java b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/unit/MdmUnitMeasureServiceImpl.java
index 3b393d3..8660a6a 100644
--- a/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/unit/MdmUnitMeasureServiceImpl.java
+++ b/yudao-module-mdm/src/main/java/cn/iocoder/yudao/module/mdm/service/unit/MdmUnitMeasureServiceImpl.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.mdm.controller.admin.unit.vo.MdmUnitMeasureImportExcelVO;
+import cn.iocoder.yudao.module.mdm.controller.admin.unit.vo.MdmUnitMeasureImportRespVO;
import cn.iocoder.yudao.module.mdm.controller.admin.unit.vo.MdmUnitMeasurePageReqVO;
import cn.iocoder.yudao.module.mdm.controller.admin.unit.vo.MdmUnitMeasureSaveReqVO;
import cn.iocoder.yudao.module.mdm.dal.dataobject.unit.MdmUnitMeasureDO;
@@ -125,4 +128,73 @@
return unitMeasureMapper.selectByCode(code);
}
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public MdmUnitMeasureImportRespVO importUnitMeasureList(List<MdmUnitMeasureImportExcelVO> importList, Boolean isUpdateSupport) {
+ if (CollUtil.isEmpty(importList)) {
+ throw exception(MDM_UNIT_MEASURE_IMPORT_LIST_IS_EMPTY);
+ }
+ MdmUnitMeasureImportRespVO respVO = MdmUnitMeasureImportRespVO.builder()
+ .createList(new ArrayList<>()).updateList(new ArrayList<>())
+ .failureList(new LinkedHashMap<>()).build();
+
+ // 1. 寤虹珛缂栫爜 -> ID 鏄犲皠锛堝厛鍔犺浇鐜版湁鍗曚綅锛屽啀鍙犲姞鏈鏂板缓鐨勫崟浣嶏級锛岀敤浜庤В鏋�"涓诲崟浣嶇紪鐮�"鍒�
+ Map<String, Long> codeIdMap = new HashMap<>();
+ for (MdmUnitMeasureDO unit : unitMeasureMapper.selectList()) {
+ codeIdMap.put(unit.getCode(), unit.getId());
+ }
+ // 璁板綍鏈瀵煎叆宸插鐞嗚繃鐨勭紪鐮侊紝閬垮厤鍚屼竴鏂囦欢鍐呭悗缁鎵句笉鍒板垰瀵煎叆鐨勪富鍗曚綅
+ Map<String, Long> importedCodeIdMap = new HashMap<>();
+
+ // 2. 閬嶅巻瀵煎叆
+ for (MdmUnitMeasureImportExcelVO importVO : importList) {
+ // 2.1 鍩虹鏍￠獙
+ if (StrUtil.isBlank(importVO.getCode()) || StrUtil.isBlank(importVO.getName())) {
+ respVO.getFailureList().put(StrUtil.blankToDefault(importVO.getName(), importVO.getCode()), "鍗曚綅缂栫爜鍜屽崟浣嶅悕绉颁笉鑳戒负绌�");
+ continue;
+ }
+ // 2.2 瑙ｆ瀽涓诲崟浣� ID锛堥潪涓诲崟浣嶆椂蹇呭～涓诲崟浣嶇紪鐮侊級
+ Long primaryId = null;
+ if (StrUtil.isNotBlank(importVO.getPrimaryCode())) {
+ primaryId = importedCodeIdMap.get(importVO.getPrimaryCode()) != null
+ ? importedCodeIdMap.get(importVO.getPrimaryCode())
+ : codeIdMap.get(importVO.getPrimaryCode());
+ if (primaryId == null) {
+ respVO.getFailureList().put(importVO.getName(), "涓诲崟浣嶇紪鐮佷笉瀛樺湪锛�" + importVO.getPrimaryCode());
+ continue;
+ }
+ }
+
+ // 2.3 宸插瓨鍦紙鎸夌紪鐮佸垽鏂級
+ MdmUnitMeasureDO existByCode = unitMeasureMapper.selectByCode(importVO.getCode());
+ if (existByCode != null) {
+ if (!Boolean.TRUE.equals(isUpdateSupport)) {
+ respVO.getFailureList().put(importVO.getName(), "鍗曚綅缂栫爜宸插瓨鍦�");
+ continue;
+ }
+ // 鏀寔鏇存柊锛氫互缂栫爜涓哄噯鏇存柊
+ MdmUnitMeasureDO updateObj = BeanUtils.toBean(importVO, MdmUnitMeasureDO.class);
+ updateObj.setId(existByCode.getId());
+ updateObj.setPrimaryId(primaryId);
+ unitMeasureMapper.updateById(updateObj);
+ respVO.getUpdateList().add(importVO.getName());
+ } else {
+ // 2.4 鏍￠獙鍚嶇О鍞竴锛堟柊澧炲満鏅級
+ MdmUnitMeasureDO existByName = unitMeasureMapper.selectByName(importVO.getName());
+ if (existByName != null) {
+ respVO.getFailureList().put(importVO.getName(), "鍗曚綅鍚嶇О宸插瓨鍦�");
+ continue;
+ }
+ // 2.5 鏂板
+ MdmUnitMeasureDO newObj = BeanUtils.toBean(importVO, MdmUnitMeasureDO.class);
+ newObj.setPrimaryId(primaryId);
+ unitMeasureMapper.insert(newObj);
+ respVO.getCreateList().add(importVO.getName());
+ // 璁板綍鏈鏂板缓鐨勭紪鐮侊紝渚涘悓鏂囦欢鍚庣画琛屽紩鐢�
+ importedCodeIdMap.put(importVO.getCode(), newObj.getId());
+ }
+ }
+ return respVO;
+ }
+
}
--
Gitblit v1.9.3