From 3baa9f07477107d66bc15611eb04c6927c56d27d Mon Sep 17 00:00:00 2001 From: zhangnaisong <2434969829@qq.com> Date: 星期二, 23 七月 2024 16:44:59 +0800 Subject: [PATCH] 异常停车记录初始化清楚修改提交 --- ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankAbnormalParkAlarmMapper.java | 2 ++ ard-work/src/main/resources/mapper/sy/ArdTankAbnormalParkAlarmMapper.xml | 5 +++++ ard-work/src/main/java/com/ruoyi/sy/controller/ArdSyCarController.java | 2 +- ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLoadLogMapper.java | 2 ++ ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankAbnormalParkAlarmServiceImpl.java | 11 ++++++++--- ard-work/src/main/java/com/ruoyi/sy/service/IArdTankAbnormalParkAlarmService.java | 2 +- ard-work/src/main/resources/mapper/sy/ArdTankLoadLogMapper.xml | 4 ++++ 7 files changed, 23 insertions(+), 5 deletions(-) diff --git a/ard-work/src/main/java/com/ruoyi/sy/controller/ArdSyCarController.java b/ard-work/src/main/java/com/ruoyi/sy/controller/ArdSyCarController.java index 28f36b3..ed0c2b9 100644 --- a/ard-work/src/main/java/com/ruoyi/sy/controller/ArdSyCarController.java +++ b/ard-work/src/main/java/com/ruoyi/sy/controller/ArdSyCarController.java @@ -204,7 +204,7 @@ thread.start(); } }; - lockStateTimer.scheduleAtFixedRate(lockStateTask,date,2500); + lockStateTimer.scheduleAtFixedRate(lockStateTask,date,1000); } /** diff --git a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankAbnormalParkAlarmMapper.java b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankAbnormalParkAlarmMapper.java index 2e01bc5..f7d67fa 100644 --- a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankAbnormalParkAlarmMapper.java +++ b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankAbnormalParkAlarmMapper.java @@ -62,4 +62,6 @@ public List<ArdTankAbnormalParkAlarm> selectArdTankAbnormalParkAlarmByCarIdNoEndTime(String carId); public int deleteArdTankAbnormalParkAlarmByCarIdAndEndTimeIsNull(String carId); + + public int deleteArdTankAbnormalParkAlarmByEndTime(); } diff --git a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLoadLogMapper.java b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLoadLogMapper.java index bc0ce9f..1b99685 100644 --- a/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLoadLogMapper.java +++ b/ard-work/src/main/java/com/ruoyi/sy/mapper/ArdTankLoadLogMapper.java @@ -67,4 +67,6 @@ public int deleteArdTankLoadLogByCarId(String carId); public List<ArdTankLoadLog> selectArdTankLoadLogByCarIdAndEndTimeIsNotNull(String carId); + + public int deleteArdTankLoadLogByEndTime(); } diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankAbnormalParkAlarmService.java b/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankAbnormalParkAlarmService.java index 577cb4b..b2a5403 100644 --- a/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankAbnormalParkAlarmService.java +++ b/ard-work/src/main/java/com/ruoyi/sy/service/IArdTankAbnormalParkAlarmService.java @@ -56,5 +56,5 @@ */ public int deleteArdTankAbnormalParkAlarmById(String id); - //public int deleteArdTankAbnormalParkAlarmByEndTime(); + public int deleteArdTankAbnormalParkAlarmByEndTime(); } diff --git a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankAbnormalParkAlarmServiceImpl.java b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankAbnormalParkAlarmServiceImpl.java index 03146fe..5cc3611 100644 --- a/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankAbnormalParkAlarmServiceImpl.java +++ b/ard-work/src/main/java/com/ruoyi/sy/service/impl/ArdTankAbnormalParkAlarmServiceImpl.java @@ -375,9 +375,14 @@ return ardTankAbnormalParkAlarmMapper.deleteArdTankAbnormalParkAlarmById(id); } - /*@Override + @Override public int deleteArdTankAbnormalParkAlarmByEndTime() { int result = ardTankAbnormalParkAlarmMapper.deleteArdTankAbnormalParkAlarmByEndTime(); - return result; - }*/ + try{ + return result; + }finally { + ardTankLoadLogMapper.deleteArdTankLoadLogByEndTime(); + } + + } } diff --git a/ard-work/src/main/resources/mapper/sy/ArdTankAbnormalParkAlarmMapper.xml b/ard-work/src/main/resources/mapper/sy/ArdTankAbnormalParkAlarmMapper.xml index 7fcb444..82c0e8f 100644 --- a/ard-work/src/main/resources/mapper/sy/ArdTankAbnormalParkAlarmMapper.xml +++ b/ard-work/src/main/resources/mapper/sy/ArdTankAbnormalParkAlarmMapper.xml @@ -90,4 +90,9 @@ delete from ard_tank_abnormal_park_alarm atapa where atapa.car_id = #{carId} and atapa.end_time is null </delete> + + <delete id="deleteArdTankAbnormalParkAlarmByEndTime" > + delete from ard_tank_abnormal_park_alarm atapa + where atapa.end_time is null + </delete> </mapper> \ No newline at end of file diff --git a/ard-work/src/main/resources/mapper/sy/ArdTankLoadLogMapper.xml b/ard-work/src/main/resources/mapper/sy/ArdTankLoadLogMapper.xml index 0a44fbb..9741ff3 100644 --- a/ard-work/src/main/resources/mapper/sy/ArdTankLoadLogMapper.xml +++ b/ard-work/src/main/resources/mapper/sy/ArdTankLoadLogMapper.xml @@ -87,4 +87,8 @@ <select id="selectArdTankLoadLogByCarIdAndEndTimeIsNotNull" parameterType="java.lang.String" resultMap="ArdTankLoadLogResult"> select * from ard_tank_load_log atll where atll.car_id = #{carId} and atll.end_time is not null </select> + + <delete id="deleteArdTankLoadLogByEndTime" > + delete from ard_tank_load_log atll where atll.end_time is not null + </delete> </mapper> \ No newline at end of file -- Gitblit v1.9.3