From a74a763d8efdda779b4c5e340f850c20a7f4ca9d Mon Sep 17 00:00:00 2001
From: ‘liusuyi’ <1951119284@qq.com>
Date: 星期六, 02 九月 2023 14:07:20 +0800
Subject: [PATCH] 优化
---
ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarMoveMapper.xml | 4 ++--
ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarFireMapper.xml | 2 +-
ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarPumpMapper.xml | 2 +-
3 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarFireMapper.xml b/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarFireMapper.xml
index dba411b..d1b6d2c 100644
--- a/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarFireMapper.xml
+++ b/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarFireMapper.xml
@@ -140,7 +140,7 @@
aar.create_time >= ( CURRENT_TIMESTAMP - INTERVAL '%${refreshTime}%' MINUTE )
GROUP BY aar.NAME
) r
- INNER JOIN ard_alarm_radar aaar ON r.create_time1 = aaar.create_time
+ INNER JOIN ard_alarm_radar_fire aaar ON r.create_time1 = aaar.create_time
</select>
<update id="updateViewTimeByCondition" parameterType="String">
update ard_alarm_radar_fire
diff --git a/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarMoveMapper.xml b/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarMoveMapper.xml
index e6704b4..cc89f3d 100644
--- a/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarMoveMapper.xml
+++ b/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarMoveMapper.xml
@@ -139,12 +139,12 @@
count(case when aar.view_time is null THEN 1 END) as count,
count(aar.id) as total
FROM
- ard_alarm_radar aar
+ ard_alarm_radar_move aar
WHERE
aar.create_time >= ( CURRENT_TIMESTAMP - INTERVAL '%${refreshTime}%' MINUTE )
GROUP BY aar.NAME
) r
- INNER JOIN ard_alarm_radar aaar ON r.create_time1 = aaar.create_time
+ INNER JOIN ard_alarm_radar_move aaar ON r.create_time1 = aaar.create_time
</select>
<update id="updateViewTimeByCondition" parameterType="String">
update ard_alarm_radar_move
diff --git a/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarPumpMapper.xml b/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarPumpMapper.xml
index f76655f..6c9cec1 100644
--- a/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarPumpMapper.xml
+++ b/ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarPumpMapper.xml
@@ -140,7 +140,7 @@
aar.create_time >= ( CURRENT_TIMESTAMP - INTERVAL '%${refreshTime}%' MINUTE )
GROUP BY aar.NAME
) r
- INNER JOIN ard_alarm_radar aaar ON r.create_time1 = aaar.create_time
+ INNER JOIN ard_alarm_radar_pump aaar ON r.create_time1 = aaar.create_time
</select>
<update id="updateViewTimeByCondition" parameterType="String">
update ard_alarm_radar_pump
--
Gitblit v1.9.3