优化

‘liusuyi’

2023-09-02 a74a763d8efdda779b4c5e340f850c20a7f4ca9d

优化

 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

 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

 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