From 507d193d16bc32a7cacfd2bf2c19e1db24390414 Mon Sep 17 00:00:00 2001
From: 倪影Alone <8315454+ni-ying-alone@user.noreply.gitee.com>
Date: 星期二, 03 九月 2024 18:13:12 +0800
Subject: [PATCH] 物料业务数据分发功能实现
---
src/main/java/com/itstyle/mdm/service/impl/MdmServiceImpl.java | 55 ++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 52 insertions(+), 3 deletions(-)
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..f84d827 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[]{};
@@ -38,12 +38,12 @@
for (int i = 0; i < size; i++) {
String json = recordArray.get(i).toString();
JSONObject jsonObj = JSON.parseObject(json);
- String id = jsonObj.getString("id");
+ String id = jsonObj.getString("tgctwoclasscode");
String tgcoriginalcode = jsonObj.getString("tgcoriginalcode");
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);
@@ -68,6 +68,55 @@
newJsonArray.add(jsonObj);
//璇存槑璇ユ暟鎹负鏂版暟鎹�
mdmData.setUuid(UUID.randomUUID().toString());
+ System.out.println(mdmData.toString());
+ dynamicQuery.save(mdmData);
+ }
+ }
+ }
+ return newJsonArray;
+ }
+
+ @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);
}
}
--
Gitblit v1.8.0