From bf5b01b14dc7bfc214e646425a62f5593890d7e3 Mon Sep 17 00:00:00 2001
From: jinlin <jinlin>
Date: 星期六, 08 十一月 2025 22:05:37 +0800
Subject: [PATCH] 清洗数据库日期错误，并且导入日期通用化处理
---
src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel1Service.java | 66 +++++++++++++++++++++++++++++++--
1 files changed, 62 insertions(+), 4 deletions(-)
diff --git a/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel1Service.java b/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel1Service.java
index 90b163a..21ddecb 100644
--- a/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel1Service.java
+++ b/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel1Service.java
@@ -2,9 +2,12 @@
import com.example.client.dto.JComboBoxItem;
import com.example.client.service.BaseService;
+import com.example.server.progressTrack.Dto.DiagramNodeDto;
import com.example.server.progressTrack.Dto.NetworkNodeStatusDto;
import com.example.server.progressTrack.Dto.ProjectDto;
import com.example.server.progressTrack.dao.DjJdgzNetworkLevel1Dao;
+import com.example.server.progressTrack.dao.DjJdgzNetworkLevel1ListDao;
+import com.example.server.progressTrack.dao.DjJdgzNetworkLevel2ListDao;
import com.example.server.progressTrack.model.DjJdgzNetworkLevel1;
import org.apache.ibatis.session.ExecutorType;
import org.apache.ibatis.session.SqlSession;
@@ -12,19 +15,30 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
-import java.util.List;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import java.util.stream.Collectors;
/**
* dj_jdgz_network_level1
*
- * @author zt generator
+ * @author zt generator
* @since 1.0.0 2024-12-17
*/
@Service
public class DjJdgzNetworkLevel1Service extends BaseService<DjJdgzNetworkLevel1Dao, DjJdgzNetworkLevel1> {
@Autowired
NetWorkDiagramService netWorkDiagramService;
+ @Autowired
+ private DjJdgzNetworkLevel1ListService djJdgzNetworkLevel1ListService;
+ @Autowired
+ private DjJdgzNetworkLevel1ListDao djJdgzNetworkLevel1ListDao;
+ @Autowired
+ private DjJdgzNetworkLevel2ListDao djJdgzNetworkLevel2ListDao;
+ @Autowired
+ private DjJdgzNetworkLevel2Service djJdgzNetworkLevel2Service;
/**
* 鍒嗛〉鏌ヨ
*
@@ -38,7 +52,6 @@
/**
* 鑾峰彇鑺傜偣鐘舵�佹暟鎹�
- *
*/
public List<NetworkNodeStatusDto> getNodeStatusData(Long id) {
baseDao.setLevel1StatusNull(id);
@@ -49,7 +62,7 @@
return list;
}
- public JComboBoxItem[] getProjectList(){
+ public JComboBoxItem[] getProjectList() {
JComboBoxItem[] list = baseDao.getProjectList();
return list;
}
@@ -97,4 +110,49 @@
String statusDiagram = netWorkDiagramService.getStatusDiagram(json, null, nodeStatusData);
return statusDiagram;
}
+
+ public List<DiagramNodeDto> getNodeList(Long id) {
+ List<DiagramNodeDto> nodeList = djJdgzNetworkLevel1ListDao.getNodeList(id);
+
+ JComboBoxItem[] level2List = djJdgzNetworkLevel2Service.getLevel2List(id);
+ for (JComboBoxItem item : level2List) {
+ List<DiagramNodeDto> nodeList2 = djJdgzNetworkLevel2ListDao.getNodeList(item.getId());
+ nodeList.addAll(nodeList2);
+ }
+ Collections.sort(nodeList, new Comparator<DiagramNodeDto>() {
+ @Override
+ public int compare(DiagramNodeDto n1, DiagramNodeDto n2) {
+ try {
+ SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
+ Date date1 = sdf.parse(n1.getRequiredCompletion());
+ Date date2 = sdf.parse(n2.getRequiredCompletion());
+ return date1.compareTo(date2);
+ } catch (ParseException e) {
+ throw new IllegalArgumentException("Invalid date format. Please use the format 'yyMMdd'.", e);
+ }
+ }
+ });
+
+ return nodeList;
+
+ }
+
+ public List<NetworkNodeStatusDto> getNodeStatus(Long id) {
+ List<NetworkNodeStatusDto> nodeStatusList = this.getNodeStatusData(id);
+ JComboBoxItem[] level2List = djJdgzNetworkLevel2Service.getLevel2List(id);
+ for (JComboBoxItem item : level2List) {
+ List<NetworkNodeStatusDto> nodeStatusList2 = djJdgzNetworkLevel2Service.getNodeStatusData(item.getId());
+ nodeStatusList.addAll(nodeStatusList2);
+ }
+ return nodeStatusList;
+ }
+
+ public List<DiagramNodeDto> getNodeList2(Long id) {
+ List<DiagramNodeDto> nodeList2 =new ArrayList<>();
+ JComboBoxItem[] level2List = djJdgzNetworkLevel2Service.getLevel2List(id);
+ for (JComboBoxItem item : level2List) {
+ nodeList2.addAll(djJdgzNetworkLevel2ListDao.getNodeList(item.getId()));
+ }
+ return nodeList2;
+ }
}
--
Gitblit v1.9.1