From e301d5c4e6de0aca423c54481d100e6ca2886b01 Mon Sep 17 00:00:00 2001
From: jinlin <jinlin>
Date: 星期六, 08 十一月 2025 22:57:12 +0800
Subject: [PATCH] 清洗数据库日期错误，并且导入日期通用化处理
---
src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3ListDao.xml | 4 ++++
src/main/resources/mapper/progressTrack/DjJdgzDismantTrackDao.xml | 4 ++++
src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java | 15 ++++++++++-----
src/main/java/com/example/server/progressTrack/dao/DjJdgzNetworkLevel3ListDao.java | 2 ++
src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel3ListService.java | 4 ++++
src/main/java/com/example/server/utils/NumToDate.java | 6 +++---
src/main/java/com/example/server/progressTrack/service/DjJdgzDismantTrackService.java | 3 +++
src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java | 2 ++
src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml | 4 ++++
src/main/java/com/example/server/progressTrack/dao/DjJdgzDismantTrackDao.java | 2 ++
10 files changed, 38 insertions(+), 8 deletions(-)
diff --git a/src/main/java/com/example/server/progressTrack/dao/DjJdgzDismantTrackDao.java b/src/main/java/com/example/server/progressTrack/dao/DjJdgzDismantTrackDao.java
index 0698dd9..ad66f6f 100644
--- a/src/main/java/com/example/server/progressTrack/dao/DjJdgzDismantTrackDao.java
+++ b/src/main/java/com/example/server/progressTrack/dao/DjJdgzDismantTrackDao.java
@@ -30,4 +30,6 @@
Boolean getStatus(Long level3NetworkId);
List<StatistDismantDto> getStatist2(Long level1Id, Long id);
+
+ List<DjJdgzDismantTrack> getAll();
}
diff --git a/src/main/java/com/example/server/progressTrack/dao/DjJdgzNetworkLevel3ListDao.java b/src/main/java/com/example/server/progressTrack/dao/DjJdgzNetworkLevel3ListDao.java
index 0338ae1..2a1e98c 100644
--- a/src/main/java/com/example/server/progressTrack/dao/DjJdgzNetworkLevel3ListDao.java
+++ b/src/main/java/com/example/server/progressTrack/dao/DjJdgzNetworkLevel3ListDao.java
@@ -37,4 +37,6 @@
List<NetworkNodeStatusDto> getNodeStatusData(Long level1NetworkId);
JComboBoxItem[] getListBothItem(Long networkId);
+
+ List<DjJdgzNetworkLevel3List> getAll();
}
diff --git a/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java b/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java
index 79ff9e5..6afeb3b 100644
--- a/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java
+++ b/src/main/java/com/example/server/progressTrack/dao/DjJdgzTrackRecordDao.java
@@ -47,4 +47,6 @@
DjJdgzNetworkLevel3List isExistTrackRecord(Integer sort, Long level3NetworkId);
List<DjJdgzTrackRecord> getRecordById(Long id);
+
+ List<DjJdgzTrackRecord> getAll();
}
diff --git a/src/main/java/com/example/server/progressTrack/service/DjJdgzDismantTrackService.java b/src/main/java/com/example/server/progressTrack/service/DjJdgzDismantTrackService.java
index 10a1939..b72e13c 100644
--- a/src/main/java/com/example/server/progressTrack/service/DjJdgzDismantTrackService.java
+++ b/src/main/java/com/example/server/progressTrack/service/DjJdgzDismantTrackService.java
@@ -41,6 +41,9 @@
public List<DjJdgzDismantTrack> getList(Long level3Id, Long cabinId) {
return baseDao.getList(level3Id, cabinId);
}
+ public List<DjJdgzDismantTrack> getAll() {
+ return baseDao.getAll();
+ }
public void save(List<DjJdgzDismantTrack> list) {
for (DjJdgzDismantTrack data : list) {
diff --git a/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel3ListService.java b/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel3ListService.java
index 8ec2288..54a4328 100644
--- a/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel3ListService.java
+++ b/src/main/java/com/example/server/progressTrack/service/DjJdgzNetworkLevel3ListService.java
@@ -39,6 +39,10 @@
return baseDao.getList(networkId);
}
+ public List<DjJdgzNetworkLevel3List> getAll() {
+ return baseDao.getAll();
+ }
+
/**
* 鍒犻櫎
*
diff --git a/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java b/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java
index 6339b3b..e01c126 100644
--- a/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java
+++ b/src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java
@@ -76,11 +76,16 @@
return list;
}
- /**
- * 鍒犻櫎
- *
- * @param ids
- */
+ public List<DjJdgzTrackRecord> getAll() {
+ List<DjJdgzTrackRecord> list = baseDao.getAll();
+ return list;
+ }
+
+ /**
+ * 鍒犻櫎
+ *
+ * @param ids
+ */
public void delete(Long[] ids) {
super.deleteLogic(ids);
}
diff --git a/src/main/java/com/example/server/utils/NumToDate.java b/src/main/java/com/example/server/utils/NumToDate.java
index 807b554..a2cf117 100644
--- a/src/main/java/com/example/server/utils/NumToDate.java
+++ b/src/main/java/com/example/server/utils/NumToDate.java
@@ -32,9 +32,9 @@
public void numDate() {
Pattern numPattern = Pattern.compile("^\\d+$");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
- List<DjJdgzNetworkLevel3List> list = level3ListService.getList(null);
- List<DjJdgzTrackRecord> list1 = recordService.getList(null, null, null, null, null, null, null, null);
- List<DjJdgzDismantTrack> list2 = dismantTrackService.getList(null, null);
+ List<DjJdgzNetworkLevel3List> list = level3ListService.getAll();
+ List<DjJdgzTrackRecord> list1 = recordService.getAll();
+ List<DjJdgzDismantTrack> list2 = dismantTrackService.getAll();
for (DjJdgzNetworkLevel3List item : list) {
String requiredCompletionTime = item.getRequiredCompletionTime();
String actualCompletion = item.getActualCompletion();
diff --git a/src/main/resources/mapper/progressTrack/DjJdgzDismantTrackDao.xml b/src/main/resources/mapper/progressTrack/DjJdgzDismantTrackDao.xml
index f03847a..88fabe2 100644
--- a/src/main/resources/mapper/progressTrack/DjJdgzDismantTrackDao.xml
+++ b/src/main/resources/mapper/progressTrack/DjJdgzDismantTrackDao.xml
@@ -141,4 +141,8 @@
group by b.cabin_id
order by a.id
</select>
+ <select id="getAll" resultType="com.example.server.progressTrack.model.DjJdgzDismantTrack">
+ select *
+ from dj_jdgz_dismant_track
+ </select>
</mapper>
diff --git a/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3ListDao.xml b/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3ListDao.xml
index aba92a8..66631b9 100644
--- a/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3ListDao.xml
+++ b/src/main/resources/mapper/progressTrack/DjJdgzNetworkLevel3ListDao.xml
@@ -100,5 +100,9 @@
and a.network_id = ${networkId}
ORDER BY sort
</select>
+ <select id="getAll" resultType="com.example.server.progressTrack.model.DjJdgzNetworkLevel3List">
+ select a.*
+ from dj_jdgz_network_level3_list a
+ </select>
</mapper>
diff --git a/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml b/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml
index 5f49518..c7e0e53 100644
--- a/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml
+++ b/src/main/resources/mapper/progressTrack/DjJdgzTrackRecordDao.xml
@@ -559,5 +559,9 @@
where level3_network_id = ${id}
and is_delete = 0
</select>
+ <select id="getAll" resultType="com.example.server.progressTrack.model.DjJdgzTrackRecord">
+ select *
+ from dj_jdgz_track_record
+ </select>
</mapper>
--
Gitblit v1.9.1