24小时报警兴趣点前十

aijinhui

2023-10-09 fe81b5844ad478a1b909026c9a0b1da6aacfc78f

24小时报警兴趣点前十

 ard-work/src/main/java/com/ruoyi/alarm/radar/mapper/ArdAlarmRadarMoveMapper.java

@@ -6,6 +6,7 @@
import com.ruoyi.alarm.radar.domain.ArdAlarmRadarMove;
import com.ruoyi.statistical.param.ESParam;
import com.ruoyi.statistical.vo.CountVo;
import com.ruoyi.statistical.vo.TenVo;
import org.apache.ibatis.annotations.Param;

/**
@@ -75,4 +76,6 @@
    List<CountVo> moveYear(ESParam esParam);
    //根据天份统计数量
    List<CountVo> moveMonth(ESParam esParam);
    //24小时报警兴趣点前十
    List<TenVo> ten();
}

 ard-work/src/main/java/com/ruoyi/statistical/controller/StatisticalController.java

@@ -192,4 +192,13 @@
        return Results.succeed(numVo);
    }

    /**
     * 24小时报警兴趣点前十
     */
    @ApiOperation("24小时报警兴趣点前十")
    @GetMapping("alarm/ten")
    public Results ten(){
        return Results.succeed(statisticalService.ten());
    }

}

 ard-work/src/main/java/com/ruoyi/statistical/service/StatisticalService.java

@@ -4,6 +4,7 @@
import com.alibaba.fastjson2.JSONArray;
import com.ruoyi.statistical.param.ESParam;
import com.ruoyi.statistical.vo.CountVo;
import com.ruoyi.statistical.vo.TenVo;
import com.ruoyi.statistical.vo.UnitVo;
import com.ruoyi.utils.result.Results;
import org.springframework.stereotype.Service;
@@ -56,4 +57,6 @@
    int wallNum();
    int digitizationNum();
    int tubeNum();

    List<TenVo> ten();
}

 ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java

@@ -25,6 +25,7 @@
import com.ruoyi.statistical.param.Para;
import com.ruoyi.statistical.service.StatisticalService;
import com.ruoyi.statistical.vo.CountVo;
import com.ruoyi.statistical.vo.TenVo;
import com.ruoyi.statistical.vo.UnitVo;
import com.ruoyi.system.mapper.SysConfigMapper;
import com.ruoyi.utils.result.Results;
@@ -367,6 +368,11 @@
        return tubeMapper.selectCount(null);
    }

    @Override
    public List<TenVo> ten() {
        return moveMapper.ten();
    }

    public List<CountVo> es(List<CountVo> list){
        for (int i = 1; i <= 12 ; i++) {
            String month;

 ard-work/src/main/java/com/ruoyi/statistical/vo/TenVo.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,9 @@
package com.ruoyi.statistical.vo;

import lombok.Data;

@Data
public class TenVo {
    private String name;
    private String num;
}

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

@@ -178,4 +178,8 @@
        from ard_alarm_radar_move
        where alarm_time &gt;= #{start} and  alarm_time &lt;= #{end}  group by date order by date
    </select>
    <select id="ten" resultType="com.ruoyi.statistical.vo.TenVo">
        SELECT name,count(name) num from ard_alarm_radar_move
        where (current_timestamp - interval '1024 hour') &lt;= alarm_time GROUP BY name ORDER BY num desc LIMIT 10
    </select>
</mapper>