异常停车记录初始化清楚修改提交

zhangnaisong

2024-07-23 3baa9f07477107d66bc15611eb04c6927c56d27d

异常停车记录初始化清楚修改提交

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

    /**

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

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

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

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

    }
}

 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>

 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>