清洗数据库日期错误，并且导入日期通用化处理

jinlin

1 天以前 e301d5c4e6de0aca423c54481d100e6ca2886b01

清洗数据库日期错误，并且导入日期通用化处理

 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();
}

 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();
}

 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();
}

 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) {

 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();
    }

    /**
     * 删除
     *

 src/main/java/com/example/server/progressTrack/service/DjJdgzTrackRecordService.java

@@ -76,6 +76,11 @@
        return list;
    }

    public List<DjJdgzTrackRecord> getAll() {
        List<DjJdgzTrackRecord> list = baseDao.getAll();
        return list;
    }

    /**
     * 删除
     *

 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();

 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>

 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>

 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>