From 889842eb8b64a0b72c449ce23ff21e4e8c935cae Mon Sep 17 00:00:00 2001
From: 田源 <lastanimals@163.com>
Date: 星期五, 26 七月 2024 16:06:49 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsEnumServiceImpl.java |  351 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 331 insertions(+), 20 deletions(-)

diff --git a/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsEnumServiceImpl.java b/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsEnumServiceImpl.java
index 2173b0a..97f5267 100644
--- a/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsEnumServiceImpl.java
+++ b/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/OsEnumServiceImpl.java
@@ -1,5 +1,6 @@
 package com.vci.web.service.impl;
 
+import com.alibaba.fastjson.JSON;
 import com.vci.corba.common.PLException;
 import com.vci.corba.omd.data.BusinessObject;
 import com.vci.corba.omd.etm.EnumItem;
@@ -7,19 +8,21 @@
 import com.vci.dto.OsEnumDTO;
 import com.vci.dto.OsEnumItemDTO;
 import com.vci.omd.utils.ObjectTool;
+import com.vci.pagemodel.*;
+import com.vci.po.OsEnumPO;
+import com.vci.starter.poi.bo.ReadExcelOption;
+import com.vci.starter.poi.bo.WriteExcelData;
+import com.vci.starter.poi.bo.WriteExcelOption;
+import com.vci.starter.poi.constant.ExcelLangCodeConstant;
+import com.vci.starter.poi.util.ExcelUtil;
 import com.vci.starter.web.annotation.log.VciUnLog;
 import com.vci.starter.web.enumpck.UserSecretEnum;
 import com.vci.starter.web.exception.VciBaseException;
+import com.vci.starter.web.pagemodel.BaseResult;
 import com.vci.starter.web.pagemodel.DataGrid;
 import com.vci.starter.web.pagemodel.PageHelper;
-import com.vci.starter.web.util.VciBaseUtil;
-import com.vci.starter.web.util.VciDateUtil;
+import com.vci.starter.web.util.*;
 import com.vci.constant.EnumIdConstant;
-import com.vci.pagemodel.KeyValue;
-import com.vci.pagemodel.OsEnumItemVO;
-import com.vci.pagemodel.OsEnumVO;
-import com.vci.pagemodel.OsStatusVO;
-import com.vci.starter.web.util.WebThreadLocalUtil;
 import com.vci.web.service.OsEnumServiceI;
 import com.vci.web.service.OsLifeCycleServiceI;
 import com.vci.web.service.WebBoServiceI;
@@ -27,6 +30,7 @@
 import com.vci.web.util.PlatformClientUtil;
 import com.vci.web.util.WebUtil;
 import org.apache.commons.lang3.StringUtils;
+import org.apache.poi.hssf.util.HSSFColor;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
@@ -35,6 +39,7 @@
 import org.springframework.util.CollectionUtils;
 import org.springframework.web.util.HtmlUtils;
 
+import java.io.File;
 import java.util.*;
 import java.util.stream.Collectors;
 
@@ -72,16 +77,21 @@
 	private WebBoServiceI boService;
 
 	/**
-	 * 鏃ュ織
-	 */
-	private Logger logger = LoggerFactory.getLogger(getClass());
-
-	/**
 	 * 鍔犺浇鑷韩
 	 */
 	@Autowired(required = false)
 	@Lazy
 	private OsEnumServiceI self;
+
+	/**
+	 * 蹇呭~鍒�
+	 */
+	private List<Integer> ColumnNameisRed = new ArrayList<Integer>();
+
+	/**
+	 * 鏃ュ織
+	 */
+	private Logger logger = LoggerFactory.getLogger(getClass());
 
 	/**
 	 * 浣跨敤缂栧彿鑾峰彇鏋氫妇鏄庣粏
@@ -231,13 +241,27 @@
 
 	/**
 	 * 鏌ョ湅鏋氫妇鐨勪娇鐢ㄨ寖鍥�
-	 * @param enumName
+	 * @param enumName 鏋氫妇鍚嶇О
 	 * @return
 	 * @throws PLException
 	 */
 	@Override
-	public List<OsEnumVO> getUsedEnumList(String enumName) throws PLException {
-		return null;
+	public List<Map<String,String>> getUsedEnumList(String enumName) throws PLException {
+		if(Func.isBlank(enumName)){
+			throw new PLException("500",new String[]{"璇烽�夋嫨瑕佹煡璇㈠簲鐢ㄨ寖鍥寸殑鏋氫妇!"});
+		}
+		String[] attrubuteNames = platformClientUtil.getAttributeService().getAttrubyteNamesByEMName(enumName);
+		if(Func.isEmpty(attrubuteNames)){
+			return new ArrayList<>();
+		}
+		List<Map<String,String>> attrubuteMapList = new ArrayList<>();
+		Arrays.stream(attrubuteNames).forEach(attrName->{
+			Map<String, String> itemMap = new HashMap<>();
+			itemMap.put("enumName",enumName);
+			itemMap.put("source",attrName);
+			attrubuteMapList.add(itemMap);
+		});
+		return attrubuteMapList;
 	}
 
 	/**
@@ -279,8 +303,10 @@
 		//鏋氫妇椤瑰悕绉板垽閲嶇瓑鎿嶄綔
 		checkOsEnumItem(osEnumDTO);
 		//榛樿鍊煎鐞�
-		String userId = "developer";//WebThreadLocalUtil.getCurrentUserSessionInfoInThread().getUserId();
+		String userId = WebThreadLocalUtil.getCurrentUserSessionInfoInThread().getUserId();
 		osEnumDTO.setCreator(userId);
+		//鎵嬪姩璁剧疆涓婚敭锛屽惁鍒欏钩鍙扮洿鎺ョ敤娌℃湁涓婚敭鐨勬灇涓炬斁杩涗簡缂撳瓨涓紝瀵艰嚧鍚庣画鏌ヨ鐨勬暟鎹病鏈塷id
+		osEnumDTO.setOid(VciBaseUtil.getPk().toUpperCase(Locale.ROOT));
 		osEnumDTO.setLastModifier(userId);
 		return platformClientUtil.getEnumService().addEnumType(this.osEnumDTO2EnumType(osEnumDTO));
 	}
@@ -308,7 +334,7 @@
 		//3銆佹灇涓鹃」鍒ら噸锛屽拰闀垮害绛夋牎楠�
 		checkOsEnumItem(osEnumDTO);
 		//灏唎sEnumVO涓殑榛樿鍊艰祴鍊肩粰osEnumDTO瀵硅薄
-		String userId = "developer";//WebThreadLocalUtil.getCurrentUserSessionInfoInThread().getUserId();
+		String userId = WebThreadLocalUtil.getCurrentUserSessionInfoInThread().getUserId();
 		osEnumDTO.setLastModifier(userId);
 		osEnumDTO.setCreator(osEnumVO.getCreator());
 		osEnumDTO.setCreateTime(osEnumVO.getCreateTime());
@@ -333,7 +359,12 @@
 			String name = osEnumDTO.getName();
 			Date ts = osEnumDTO.getTs();
 			if(Func.isBlank(oid) || Func.isBlank(name) || Func.isEmpty(ts)){
-				throw new PLException("500",new String[]{"寰呭垹闄ょ殑鏋氫妇鍒楄〃涓富閿�恛id銆戝拰璋冩暣鏃堕棿銆恡s銆戜笉鑳戒负绌猴紒"});
+				throw new PLException("500",new String[]{"寰呭垹闄ょ殑鏋氫妇鍒楄〃涓富閿�恛id銆戙�佽皟鏁存椂闂淬�恡s銆戙�佸睘鎬у悕銆恘ame銆戜笉鑳戒负绌猴紒"});
+			}
+			//鍒ゆ柇鏋氫妇鏄惁鏈夎寮曠敤
+			List<Map<String, String>> usedEnumList = this.getUsedEnumList(name);
+			if(Func.isNotEmpty(usedEnumList)){
+				throw new PLException("500",new String[]{"鍒犻櫎鐨勬灇涓句腑锛屾灇涓惧悕绉颁负锛氥��" + name + "銆�,宸茶寮曠敤锛�"});
 			}
 			EnumType enumType = new EnumType();
 			enumType.oid = oid;
@@ -348,6 +379,252 @@
 	}
 
 	/**
+	 * 瀵煎嚭鏋氫妇绫诲瀷
+	 * @param exportFileName 瀵煎嚭鐨勬枃浠跺悕
+	 * @param enumNames 闇�瑕佸鍑虹殑鏋氫妇鍚嶇О
+	 * @return
+	 */
+	@Override
+	public String exportEnumTypes(String exportFileName,String enumNames) throws PLException {
+		if(Func.isBlank(enumNames)){
+			throw new PLException("500",new String[]{"璇峰嬀閫夎瀵煎嚭鐨勬灇涓�!"});
+		}
+		//鐣岄潰娌′紶鍚嶇О锛屼娇鐢ㄩ粯璁ゅ鍑哄悕绉�
+		exportFileName = Func.isBlank(exportFileName) ?  "鏋氫妇绫诲瀷瀵煎嚭_" + Func.format(new Date(),"yyyy-MM-dd HHmmss.sss"):exportFileName;
+		//璁剧疆鍒楀悕
+		List<String> columns = new ArrayList<>(Arrays.asList("鏋氫妇鍚嶇О", "鏍囩", "杩斿洖绫诲瀷", "闀垮害", "鏋氫妇椤瑰悕绉�", "鏋氫妇鍊�", "鎻忚堪"));
+
+		//鍐檈xcel
+		String excelPath = LocalFileUtil.getDefaultTempFolder() + File.separator + exportFileName +  ".xls";
+		try {
+			new File(excelPath).createNewFile();
+		} catch (Throwable e) {
+			throw new VciBaseException(LangBaseUtil.getErrorMsg(e), new String[]{excelPath}, e);
+		}
+		//璁剧疆鍒�
+		List<WriteExcelData> excelDataList = new ArrayList<>();
+		//璁剧疆鍒楀ご
+		for (int index = 0; index < columns.size(); index++) {
+			excelDataList.add(new WriteExcelData(0,index, columns.get(index)));
+		}
+		//鎸夌収鏋氫妇鍚嶆煡璇㈡灇涓撅紝鐒跺悗澶勭悊鏋氫妇瀵煎嚭
+		List<String> enumNameList = Func.toStrList(enumNames);
+		int startRow = 1;
+		for (int i = 0; i < enumNameList.size(); i++) {
+			//鏍规嵁鏋氫妇鍚嶇О鏌ヨ鏋氫妇鍜屾灇涓鹃」
+			OsEnumVO osEnumVO = this.getEnumTypeById(enumNameList.get(i));
+			//OsEnumVO osEnumVO = getTestJson(i);
+			//鏌ヨ缁撴灉涓嶅簲璇ヤ负绌�
+			if(Func.isEmpty(osEnumVO) && Func.isBlank(osEnumVO.getOid())){
+				throw new PLException("500",new String[]{"鏈煡璇㈠埌鏋氫妇鍚嶄负銆�" + enumNameList.get(i) + "銆戠殑鏋氫妇锛岃鍒锋柊鍚庨噸鏂板鍑�!"});
+			}
+			//鏋氫妇椤逛笉涓虹┖鏃堕渶瑕佽�冭檻鍚堝苟琛岄棶棰�
+			List<OsEnumItemVO> enumVOItems = osEnumVO.getItems();
+			//鏋氫妇椤逛笉涓虹┖鏃堕渶瑕佽繘琛屽悎骞惰澶勭悊
+			if(Func.isNotEmpty(enumVOItems) || enumVOItems.size() > 1){
+				//excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,0, osEnumVO.getOid()));
+				excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,0, osEnumVO.getId()));
+				excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,1, osEnumVO.getName()));
+				excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,2, osEnumVO.getEnumValueDataType()+"("+osEnumVO.getEnumValueDataTypeText()+")"));
+				excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,3, osEnumVO.getLength()));
+				//excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,5, osEnumVO.getCreator()));
+				excelDataList.add(new WriteExcelData(startRow,(enumVOItems.size()+startRow)-1,true,true,4, Func.format(osEnumVO.getCreateTime(),"yyyy骞碝M鏈坉d鏃� hh:mm:ss")));
+
+				//澶勭悊鏋氫妇椤瑰啓鍏�
+				for (int j = 0; j < enumVOItems.size(); j++) {
+					OsEnumItemVO osEnumItemVO = enumVOItems.get(j);
+					excelDataList.add(new WriteExcelData(startRow+j,7, true,osEnumItemVO.getName()));
+					excelDataList.add(new WriteExcelData(startRow+j,8, true, osEnumItemVO.getValue()));
+					excelDataList.add(new WriteExcelData(startRow+j,9, true, osEnumItemVO.getDescription()));
+				}
+
+				startRow += enumVOItems.size();
+			}else{
+				//鏋氫妇椤逛负绌烘椂灏变笉闇�瑕佸悎骞惰
+				//excelDataList.add(new WriteExcelData(startRow,0, true,osEnumVO.getOid()));
+				excelDataList.add(new WriteExcelData(startRow,0, true, osEnumVO.getId()));
+				excelDataList.add(new WriteExcelData(startRow,1, true, osEnumVO.getName()));
+				excelDataList.add(new WriteExcelData(startRow,1, true, osEnumVO.getEnumValueDataType()+"("+osEnumVO.getEnumValueDataTypeText()+")"));
+				excelDataList.add(new WriteExcelData(startRow,3, true, osEnumVO.getLength()));
+				//excelDataList.add(new WriteExcelData(startRow,5, true, osEnumVO.getCreator()));
+				excelDataList.add(new WriteExcelData(startRow,4, true, Func.format(osEnumVO.getCreateTime(),"yyyy骞碝M鏈坉d鏃� hh:mm:ss")));
+			}
+			//璁板綍涓嬩笂涓�缁勬暟鎹粨鏉熸椂鐨勮鍙凤紝鏂逛究鐢ㄥ仛鍚堝苟琛岀殑璧峰琛�
+			startRow += 1;
+		}
+		WriteExcelOption excelOption = new WriteExcelOption(excelDataList);
+		ExcelUtil.writeDataToFile(excelPath, excelOption);
+		return excelPath;
+	}
+
+	/**
+	 * 涓嬭浇瀵煎叆妯℃澘
+	 * @param exportFileName
+	 * @return
+	 */
+	@Override
+	public String downloadEnumTemplate(String exportFileName) {
+		//鐣岄潰娌′紶鍚嶇О锛屼娇鐢ㄩ粯璁ゅ鍑哄悕绉�
+		exportFileName = Func.isBlank(exportFileName) ?  "鏋氫妇瀵煎叆妯℃澘_" + Func.format(new Date(),"yyyy-MM-dd HHmmss.sss"):exportFileName;
+		//璁剧疆鍒楀悕
+		List<String> columns = new ArrayList<>(Arrays.asList("鏋氫妇鍚嶇О", "鏍囩", "杩斿洖绫诲瀷", "闀垮害", "鏋氫妇椤瑰悕绉�(褰撳墠鏋氫妇涓嬫湁鏋氫妇椤规椂蹇呭~)", "鏋氫妇鍊�(褰撳墠鏋氫妇涓嬫湁鏋氫妇椤规椂蹇呭~)", "鎻忚堪","*娉ㄦ剰*:绗簩琛屽紑濮嬬殑鏁版嵁涓虹ず渚嬫暟鎹紝瀵煎叆鍓嶈灏嗗叾鍒犻櫎锛屽綋瀵煎叆鐨勬灇涓句笅鍏峰澶氫釜鏋氫妇椤规椂锛屽簲鎸夌収绀轰緥enum2鐨勫啓娉�"));
+		//鍐檈xcel
+		String excelPath = LocalFileUtil.getDefaultTempFolder() + File.separator + exportFileName +  ".xls";
+		//璁剧疆蹇呭~鍒�
+		ColumnNameisRed.clear();
+		ColumnNameisRed.add(0);
+		ColumnNameisRed.add(2);
+		ColumnNameisRed.add(3);
+		ColumnNameisRed.add(4);
+		ColumnNameisRed.add(5);
+		try {
+			new File(excelPath).createNewFile();
+		} catch (Throwable e) {
+			throw new VciBaseException(LangBaseUtil.getErrorMsg(e), new String[]{excelPath}, e);
+		}
+		//璁剧疆鍒�
+		List<WriteExcelData> excelDataList = new ArrayList<>();
+		//璁剧疆鍒楀ご
+		for (int index = 0; index < columns.size(); index++) {
+			//鍒ゆ柇鏄惁涓哄繀濉垪锛岀粰蹇呭~鍒楄缃鑹�
+			if(ColumnNameisRed.contains(index)){
+				WriteExcelData excelData = new WriteExcelData(0, index, columns.get(index));
+				excelData.setFontColor(String.valueOf(HSSFColor.HSSFColorPredefined.RED.getIndex()));
+				excelDataList.add(excelData);
+			}else{
+				excelDataList.add(new WriteExcelData(0,index, columns.get(index)));
+			}
+		}
+		List<OsEnumVO> exportEnumTempExample = this.getExportEnumTempExample();
+		for (int i = 0; i < exportEnumTempExample.size(); i++) {
+			OsEnumVO osEnumVO = exportEnumTempExample.get(i);
+			List<OsEnumItemVO> enumVOItems = osEnumVO.getItems();
+			for (int j = 0; j < enumVOItems.size(); j++) {
+				OsEnumItemVO osEnumItemVO = enumVOItems.get(j);
+				excelDataList.add(new WriteExcelData(i+j+1,0, osEnumVO.getId()));
+				excelDataList.add(new WriteExcelData(i+j+1,1, osEnumVO.getName()));
+				excelDataList.add(new WriteExcelData(i+j+1,2, osEnumVO.getEnumValueDataType()));
+				excelDataList.add(new WriteExcelData(i+j+1,3, osEnumVO.getLength()));
+
+				excelDataList.add(new WriteExcelData(i+j+1,4,osEnumItemVO.getName()));
+				excelDataList.add(new WriteExcelData(i+j+1,5, osEnumItemVO.getValue()));
+				excelDataList.add(new WriteExcelData(i+j+1,6, osEnumItemVO.getDescription()));
+			}
+		}
+		WriteExcelOption excelOption = new WriteExcelOption(excelDataList);
+		ExcelUtil.writeDataToFile(excelPath, excelOption);
+		return excelPath;
+	}
+
+	/**
+	 * 瀵煎叆鏋氫妇
+	 * @param file
+	 * @return
+	 * @throws Exception
+	 */
+	@Override
+	public BaseResult importEnumTypes(File file) throws Exception {
+		VciBaseUtil.alertNotNull(file,"excel鏂囦欢");
+		if(!file.exists()){
+			throw new VciBaseException("瀵煎叆鐨別xcel鏂囦欢涓嶅瓨鍦�,{0}",new String[]{file.getPath()});
+		}
+		try{
+			//1銆佽鍙杄xcel涓殑鏁版嵁锛岀粍鎴愬璞�
+			ReadExcelOption excelOption = new ReadExcelOption();
+			List<OsEnumPO> poList = ExcelUtil.readDataObjectFromExcel(file, OsEnumPO.class,excelOption,(value, po, fieldName)->{});
+			//鍘婚櫎閮芥槸绌虹殑鎯呭喌
+			if(CollectionUtils.isEmpty(poList)){
+				return BaseResult.fail(ExcelLangCodeConstant.IMPORT_CONTENT_NULL,new String[]{});
+			}
+			//灏嗘灇涓惧拰鏋氫妇椤瑰鐞嗘垚涓�瀵瑰鍏崇郴鐨勫璞�
+			Map<String, OsEnumPO> groupPOMap = new HashMap<>();
+			for (OsEnumPO po : poList) {
+				//鎷兼帴鐢ㄦ潵浣滀负鍒嗙粍鐨刱ey
+				String key = po.getId() + "_" + po.getName() + "_" + po.getEnumValueDataType() + "_" + po.getLength();
+				OsEnumPO group = groupPOMap.get(key);
+				if (group == null) {
+					group = new OsEnumPO();
+					//鎷垮嚭鐜扮殑棣栬鍋氬悗缁殑鎻愮ず琛�
+					group.setRowIndex(po.getRowIndex());
+					group.setId(po.getId());
+					group.setName(po.getName());
+					group.setEnumValueDataType(po.getEnumValueDataType());
+					group.setLength(po.getLength());
+					groupPOMap.put(key, group);
+				}
+
+				OsEnumItemDTO itemDTO = new OsEnumItemDTO();
+				itemDTO.setName(po.getEnumItemName());
+				itemDTO.setValue(po.getValue());
+				itemDTO.setDescription(po.getDescription());
+
+				group.getItems().add(itemDTO);
+			}
+			Collection<OsEnumPO> newPOList = groupPOMap.values();
+			//鏁版嵁搴撴煡璇㈡槸鍚︽湁宸插瓨鍦ㄧ殑鏋氫妇鍚嶏紝鏂逛究鍚庣画鍋氬垽閲嶅鐞�
+			List<OsEnumVO> osEnumVOList = this.listEnumByIdCollection(poList.stream().map(OsEnumPO::getId).collect(Collectors.toSet()));
+			List<String> repeatEnumId = new ArrayList<>();
+			if(Func.isNotEmpty(osEnumVOList)){
+				repeatEnumId = osEnumVOList.stream().map(OsEnumVO::getId).collect(Collectors.toList());
+			}
+			//褰撳墠excel涓槸鍚﹂噸澶嶇敤鐨勫垽閲峂ap:锛坘ey锛氬垽閲嶅睘鎬э紝value锛氳鍙凤級
+			Map<String, String> excelReapeat = new HashMap<>();
+			//鍒ゆ柇蹇呭~灞炴�ф槸鍚︿负绌猴紝鐢ㄦ埛鏄惁宸插瓨鍦紝浠ュ強閮ㄩ棬鏄惁濉敊绛夋牎楠岄�昏緫
+			List<String> finalRepeatEnumId = repeatEnumId;
+			newPOList.stream().forEach(osEnumPO -> {
+				if(Func.isBlank(osEnumPO.getId())){//鏋氫妇鍚�
+					throw new VciBaseException("绗��"+osEnumPO.getRowIndex()+"銆戣锛宔numnameerror");
+				}else if(Func.isBlank(osEnumPO.getEnumValueDataType())){
+					throw new VciBaseException("绗��"+osEnumPO.getRowIndex()+"銆戣锛宼ypeerror");
+				}else if(Func.isEmpty(osEnumPO.getLength())){
+					throw new VciBaseException("绗��"+osEnumPO.getRowIndex()+"銆戣锛宭engtherror");
+				}else if(!osEnumPO.getId().matches("^[A-Za-z]+$")){
+					throw new VciBaseException("绗��"+osEnumPO.getRowIndex()+"銆戣鏁版嵁锛屾灇涓惧悕绉板彧鑳戒负鑻辨枃瀛楁瘝");
+				}else if(excelReapeat.containsKey(osEnumPO.getId())){//鏋氫妇鍚嶈〃鏍间腑鍒ら噸
+					throw new VciBaseException("绗��"+excelReapeat.get(osEnumPO.getId())+"銆戣鍜岀銆�"+osEnumPO.getRowIndex()+"銆戣鏁版嵁锛屾灇涓惧悕閲嶅");
+				}else if (Func.isNotEmpty(osEnumVOList) && finalRepeatEnumId.contains(osEnumPO.getId())){//2銆佸垽鏂灇涓惧悕鏄惁涓庣郴缁熶腑閲嶅
+					throw new VciBaseException("绗��"+osEnumPO.getRowIndex()+"銆戣锛屾灇涓惧悕鍦ㄧ郴缁熶腑宸茬粡瀛樺湪,璇蜂慨鏀�!");
+				}
+				//鍏堝鏋氫妇鍚峞xcel涓渶瑕佸垽閲嶅鐞�
+				excelReapeat.put(osEnumPO.getId(),osEnumPO.getRowIndex());
+			});
+			//淇濆瓨閫昏緫
+			for (OsEnumPO osEnumPO : newPOList) {
+				OsEnumDTO osEnumDTO = new OsEnumDTO();
+				//鐢熸垚瀛樺偍鐨凞TO瀵硅薄
+				osEnumDTO.setId(osEnumPO.getId());
+				osEnumDTO.setName(osEnumPO.getName());
+				osEnumDTO.setEnumValueDataType(osEnumPO.getEnumValueDataType());
+				osEnumDTO.setLength(osEnumPO.getLength());
+				osEnumDTO.setItems(osEnumPO.getItems());
+
+				//璋冪敤鏂板鏋氫妇鏂规硶
+				boolean addBoolean = this.addEnumType(osEnumDTO);
+				if(!addBoolean){
+					throw new PLException("500",new String[]{"淇濆瓨鏋氫妇鍚嶄负銆�" + osEnumDTO.getId() + "銆戠殑鏁版嵁鏃跺嚭鐜伴敊璇�!"});
+				}
+			}
+		}catch (Exception e){
+			if(logger.isErrorEnabled()){
+				logger.error("璇诲彇excel鍐呭鏃舵垨淇濆瓨鐢ㄦ埛淇℃伅鏃跺嚭鐜颁簡閿欒锛屽叿浣撳師鍥狅細",VciBaseUtil.getExceptionMessage(e));
+			}
+			e.printStackTrace();
+			return BaseResult.fail(VciBaseUtil.getExceptionMessage(e),new String[]{},e);
+		}
+		return BaseResult.success("鏋氫妇瀵煎叆鎴愬姛锛�");
+	}
+
+	/**
+	 * 鑾峰彇瀵煎叆妯℃澘鐨勭ず渚嬫暟鎹�
+	 * @return
+	 */
+	private List<OsEnumVO> getExportEnumTempExample(){
+		String testJosn = "[{\"enumValueDataType\":\"String\",\"id\":\"enum1\",\"items\":[{\"description\":\"enumitem1.1\",\"name\":\"enumitem1.1\",\"value\":\"1\"},{\"description\":\"enumitem1.2\",\"name\":\"enumitem1.2\",\"value\":\"2\"}],\"length\":2,\"name\":\"enum1\"},{\"enumValueDataType\":\"String\",\"id\":\"enum2\",\"items\":[{\"description\":\"enumitem2.1\",\"name\":\"enumitem2.1\",\"value\":\"1\"},{\"description\":\"enumitem2.2\",\"name\":\"enumitem2.2\",\"value\":\"2\"},{\"description\":\"enumitem2.3\",\"name\":\"enumitem2.3\",\"value\":\"3\"}],\"length\":6,\"name\":\"enum2\"}]";
+		List<OsEnumVO> OsEnumVOs = JSON.parseArray(testJosn,OsEnumVO.class);
+		return OsEnumVOs;
+	}
+
+	/**
 	 * 鏋氫妇椤规牎楠�
 	 * @param osEnumDTO
 	 * @return 鏍¢獙澶辫触鐩存帴鎶涘嚭寮傚父锛屽惁鍒欎笉浼氬仛浠讳綍杩斿洖
@@ -356,7 +633,7 @@
 		List<OsEnumItemDTO> items = osEnumDTO.getItems();
 		if (Func.isNotEmpty(items)) {
 			//鑾峰彇姝e垯锛屼富瑕佹槸閽堝Integer绫诲瀷鐨勬椂鍊�
-			String regular = "Integer".equals(osEnumDTO.getEnumValueDataType()) ? "^[0-9]+$" : "";
+			String regular = "Integer".equals(osEnumDTO.getEnumValueDataType()) ? "^-?\\d+$" : "";
 			//鍒╃敤set鐨刟dd杩斿洖鍊艰繘琛宯ame鍒ら噸
 			Set<String> uniqueNames = new HashSet<>();
 			for (OsEnumItemDTO item : items) {
@@ -385,7 +662,8 @@
 	private EnumType osEnumDTO2EnumType(OsEnumDTO osEnumDTO){
 		EnumType enumType = new EnumType();
 		enumType.oid = osEnumDTO.getOid();
-		enumType.name = osEnumDTO.getId();
+		//鏋氫妇鍚嶇粺涓�杞垚灏忓啓锛岄伩鍏嶅悗鏈熷嚭鐜板叾浠栭棶棰�
+		enumType.name = osEnumDTO.getId().toLowerCase(Locale.ROOT);
 		enumType.label = osEnumDTO.getName();
 		enumType.length = osEnumDTO.getLength();
 		enumType.creator = osEnumDTO.getCreator();
@@ -651,6 +929,39 @@
 	}
 
 	/**
+	 * 鏍规嵁鏋氫妇绫诲瀷鏌ヨ鏋氫妇锛氭灇涓惧悕 , 鏋氫妇
+	 * @param enumType锛歋tring, Integer
+	 * @return
+	 */
+	public List<Map<String,List<String>>> getEnumMapByType(String enumType){
+		List<Map<String,List<String>>> enumMapList = new ArrayList<>();
+		EnumType[] emArray = null;
+		try {
+			emArray = platformClientUtil.getEnumService().getEnumTypesByType(enumType);
+		} catch (PLException e) {
+			e.printStackTrace();
+		}
+		if(emArray == null || emArray.length == 0){
+			return null;
+		}
+		EnumType emItem;
+		for(int i = 0; i < emArray.length; i++){
+			emItem = emArray[i];
+			EnumItem[] emChildren = emItem.items;
+			ArrayList<String> valueList = new ArrayList<String>();
+			for(int k = 0; k < emChildren.length; k++){
+				EnumItem emChild = emChildren[k];
+				String value = emChild.value;
+				valueList.add(value);
+			}
+			Map<String, List<String>> enumMap = new HashMap<>();
+			enumMap.put(emItem.name, valueList);
+			enumMapList.add(enumMap);
+		}
+		return enumMapList;
+	}
+
+	/**
 	 * 娓呴櫎缂撳瓨
 	 */
 	@Override

--
Gitblit v1.9.3