优化雷达报警汇聚sql

liusuyi

2024-05-20 be9c7a2f692b19c319bce50b613600c22c1d38cd

优化雷达报警汇聚sql

 ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarFireMapper.xml

@@ -150,7 +150,7 @@
                 aar.create_time >= ( CURRENT_TIMESTAMP - INTERVAL '%${refreshTime}%' MINUTE )
             GROUP BY aar.NAME
            ) r
                INNER JOIN ard_alarm_radar_fire aaar ON r.create_time1 = aaar.create_time
                INNER JOIN ard_alarm_radar_fire aaar ON aaar.NAME = r.NAME AND r.create_time1 = aaar.create_time
    </select>
    <update id="updateViewTimeByCondition" parameterType="String">
        update ard_alarm_radar_fire

 ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarMoveMapper.xml

@@ -150,7 +150,7 @@
                 aar.create_time >= ( CURRENT_TIMESTAMP - INTERVAL '%${refreshTime}%' MINUTE )
             GROUP BY aar.NAME
            ) r
                INNER JOIN ard_alarm_radar_move aaar ON r.create_time1 = aaar.create_time
                INNER JOIN ard_alarm_radar_move aaar ON aaar.NAME = r.NAME AND r.create_time1 = aaar.create_time
        ORDER BY aaar.create_time desc
    </select>
    <update id="updateViewTimeByCondition" parameterType="String">

 ard-work/src/main/resources/mapper/alarm/ArdAlarmRadarPumpMapper.xml

@@ -150,7 +150,7 @@
                 aar.create_time >= ( CURRENT_TIMESTAMP - INTERVAL '%${refreshTime}%' MINUTE )
             GROUP BY aar.NAME
            ) r
                INNER JOIN ard_alarm_radar_pump aaar ON r.create_time1 = aaar.create_time
                INNER JOIN ard_alarm_radar_pump aaar ON aaar.NAME = r.NAME AND r.create_time1 = aaar.create_time
    </select>
    <update id="updateViewTimeByCondition" parameterType="String">
        update ard_alarm_radar_pump