From 67fb3bd7367fdf8a5b2186d4ff1c0f4d572c6d91 Mon Sep 17 00:00:00 2001
From: 1 <1>
Date: 星期三, 24 一月 2024 17:39:55 +0800
Subject: [PATCH] 更新计量单位解析功能
---
src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java | 52 +++++++++++++++++++++++++-
src/main/java/com/itstyle/mdm/utils/MdmUtils.java | 6 +-
src/main/java/com/itstyle/mdm/service/MdmService.java | 9 ++++
src/main/java/com/itstyle/mdm/job/MdmJob.java | 2
4 files changed, 62 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/itstyle/mdm/job/MdmJob.java b/src/main/java/com/itstyle/mdm/job/MdmJob.java
index a754a98..e220859 100644
--- a/src/main/java/com/itstyle/mdm/job/MdmJob.java
+++ b/src/main/java/com/itstyle/mdm/job/MdmJob.java
@@ -64,7 +64,7 @@
public String obtainMdmUnitData(){
mdmUtils = (MdmUtils) applicationContext.getBean("mdmUtils");
logger.info("MDM璁￠噺鍗曚綅鏁版嵁鑾峰彇寮�濮�");
- mdmUtils.queryMaterial();
+ mdmUtils.queryUnit();
return "";
}
diff --git a/src/main/java/com/itstyle/mdm/service/MdmService.java b/src/main/java/com/itstyle/mdm/service/MdmService.java
index 8ba3c8e..9656c1a 100644
--- a/src/main/java/com/itstyle/mdm/service/MdmService.java
+++ b/src/main/java/com/itstyle/mdm/service/MdmService.java
@@ -15,7 +15,14 @@
* @param
* @return 杩斿洖鍒嗗彂json
*/
- JSONArray saveMdmData(JSONArray recordArray);
+ JSONArray saveMdmData(JSONArray recordArray,String name);
+
+ /**
+ * 灏嗚幏鍙栫殑MDM鏁版嵁杩涜鍌ㄥ瓨
+ * @param
+ * @return 杩斿洖鍒嗗彂json
+ */
+ JSONArray saveMdmUnitData(JSONArray recordArray,String name);
/**
* 鑾峰彇闇�瑕佸垎鍙戠殑寮傛瀯绯荤粺
diff --git a/src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java b/src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java
index cec9ff3..25ea4b3 100644
--- a/src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java
+++ b/src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java
@@ -29,7 +29,7 @@
@Override
@Transactional
- public JSONArray saveMdmData(JSONArray recordArray) {
+ public JSONArray saveMdmData(JSONArray recordArray,String name) {
JSONArray newJsonArray = new JSONArray();
int size = recordArray.size();
Object[] params = new Object[]{};
@@ -43,7 +43,7 @@
String updatedat = jsonObj.getString("updatedat");
String updatetime = jsonObj.getString("updatetime");
mdmData = new MdmData();
- mdmData.setType("灞�鍩熺墿鏂欏悕绉扮紪鐮佹暟鎹幏鍙�");
+ mdmData.setType(name);
mdmData.setId(id);
mdmData.setTgcoriginalCode(tgcoriginalcode);
mdmData.setUpdatedat(updatedat);
@@ -76,6 +76,54 @@
}
@Override
+ @Transactional
+ public JSONArray saveMdmUnitData(JSONArray recordArray, String name) {
+ JSONArray newJsonArray = new JSONArray();
+ int size = recordArray.size();
+ Object[] params = new Object[]{};
+ MdmData mdmData = null;
+ if(size != 0){
+ for (int i = 0; i < size; i++) {
+ String json = recordArray.get(i).toString();
+ JSONObject jsonObj = JSON.parseObject(json);
+ String id = jsonObj.getString("code");
+ String tgcoriginalcode = jsonObj.getString("originalcode");
+ //String updatedat = jsonObj.getString("updatedat");
+ String updatetime = jsonObj.getString("updatetime");
+ mdmData = new MdmData();
+ mdmData.setType(name);
+ mdmData.setId(id);
+ mdmData.setTgcoriginalCode(tgcoriginalcode);
+ mdmData.setUpdatedat("");
+ mdmData.setUpdatetime(updatetime);
+ String countSql = "SELECT mdm.uuid,mdm.id,mdm.tgcoriginalCode,mdm.updatedat,mdm.updatetime FROM mdm_data AS mdm where mdm.tgcoriginalCode='"+tgcoriginalcode+"' ";
+ List<MdmData> list = dynamicQuery.nativeQueryList(MdmData.class,countSql,params);
+ if(list.size()>0){
+ //璇存槑瀛樺湪鏁版嵁
+ for (MdmData mdm : list) {
+ String updatetime1 = mdm.getUpdatetime();
+ if(updatetime1.equals(updatetime)){
+ //鏁版嵁鏃犲彉鍖�
+ continue;
+ }
+ jsonObj.put("renewstatus","update");
+ newJsonArray.add(jsonObj);
+ //鏁版嵁瀛樺湪鍙樺寲
+ dynamicQuery.update(mdm);//鏇存柊鏁版嵁
+ }
+ }else {
+ jsonObj.put("renewstatus","new");
+ newJsonArray.add(jsonObj);
+ //璇存槑璇ユ暟鎹负鏂版暟鎹�
+ mdmData.setUuid(UUID.randomUUID().toString());
+ dynamicQuery.save(mdmData);
+ }
+ }
+ }
+ return newJsonArray;
+ }
+
+ @Override
public List<SysConfigEntity> querySysConfigs(String interfaceName) {
Object[] params = new Object[]{interfaceName};
String countSql = "select id,ADDRESS as address,DESCRIPTION as description,cronExpression,isEnable,sysName,association from sys_config where isEnable='鍚敤' and association=?";
diff --git a/src/main/java/com/itstyle/mdm/utils/MdmUtils.java b/src/main/java/com/itstyle/mdm/utils/MdmUtils.java
index e71cd99..8e5f4da 100644
--- a/src/main/java/com/itstyle/mdm/utils/MdmUtils.java
+++ b/src/main/java/com/itstyle/mdm/utils/MdmUtils.java
@@ -53,7 +53,7 @@
records = jsonObj.getString("records");
JSONArray recordArray = JSON.parseArray(records);//鐗╂枡鏁版嵁淇℃伅
//灏嗘暟鎹繚瀛樿嚦鏁版嵁搴�
- JSONArray newJson = mdmService.saveMdmData(recordArray);
+ JSONArray newJson = mdmService.saveMdmData(recordArray,"灞�鍩熺墿鏂欏悕绉扮紪鐮佹暟鎹幏鍙�");
if(newJson.size()!=0){
//瀹氫箟杩斿洖json鏍煎紡
returnJson.append("{\n" +
@@ -98,10 +98,10 @@
String records = httpClientResult.getContent();
records = records.replaceAll("\\p{Z}", "");
JSONObject jsonObj = JSON.parseObject(records);
- records = jsonObj.getString("records");
+ records = jsonObj.getString("data");
JSONArray recordArray = JSON.parseArray(records);//鐗╂枡鏁版嵁淇℃伅
//灏嗘暟鎹繚瀛樿嚦鏁版嵁搴�
- JSONArray newJson = mdmService.saveMdmData(recordArray);
+ JSONArray newJson = mdmService.saveMdmUnitData(recordArray,"璁￠噺鍗曚綅涓氬姟鍩虹鏁版嵁缂栫爜鑾峰彇");
if(newJson.size()!=0){
//瀹氫箟杩斿洖json鏍煎紡
returnJson.append("{\n" +
--
Gitblit v1.8.0