From fe81b5844ad478a1b909026c9a0b1da6aacfc78f Mon Sep 17 00:00:00 2001
From: aijinhui <aijinhui>
Date: 星期一, 09 十月 2023 14:52:01 +0800
Subject: [PATCH] 24小时报警兴趣点前十

---
 ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java |  338 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 336 insertions(+), 2 deletions(-)

diff --git a/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java b/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java
index a5fd639..3920294 100644
--- a/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java
+++ b/ard-work/src/main/java/com/ruoyi/statistical/service/impl/StatisticalServiceImpl.java
@@ -2,18 +2,38 @@
 
 import com.alibaba.fastjson.JSONObject;
 import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.ruoyi.alarm.access.mapper.ArdAlarmAccessMapper;
+import com.ruoyi.alarm.apponekey.mapper.ArdAlarmApponekeyMapper;
+import com.ruoyi.alarm.camera.mapper.ArdAlarmCameraMapper;
+import com.ruoyi.alarm.digitization3.mapper.ArdAlarmDigitization3Mapper;
+import com.ruoyi.alarm.external.mapper.ArdAlarmExternalMapper;
+import com.ruoyi.alarm.radar.mapper.ArdAlarmRadarFireMapper;
+import com.ruoyi.alarm.radar.mapper.ArdAlarmRadarMoveMapper;
+import com.ruoyi.alarm.radar.mapper.ArdAlarmRadarPumpMapper;
+import com.ruoyi.alarm.steal.mapper.ArdAlarmStealelecMapper;
+import com.ruoyi.alarm.tube.mapper.ArdAlarmTubeMapper;
+import com.ruoyi.alarm.wall.mapper.ArdAlarmWallMapper;
 import com.ruoyi.alarmpoints.well.domain.ArdAlarmpointsWell;
 import com.ruoyi.alarmpoints.well.mapper.ArdAlarmpointsWellMapper;
 import com.ruoyi.common.core.domain.entity.SysConfig;
 import com.ruoyi.common.utils.SecurityUtils;
+import com.ruoyi.device.camera.domain.ArdCameras;
+import com.ruoyi.device.camera.mapper.ArdCamerasMapper;
+import com.ruoyi.device.radar.domain.ArdEquipRadar;
+import com.ruoyi.device.radar.mapper.ArdEquipRadarMapper;
+import com.ruoyi.statistical.param.ESParam;
+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;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 
-import java.util.List;
-import java.util.Map;
+import java.net.Socket;
+import java.util.*;
 
 /**
  * @author Administrator
@@ -25,6 +45,33 @@
     private SysConfigMapper sysConfigMapper;
     @Autowired
     private ArdAlarmpointsWellMapper wellMapper;
+    @Autowired
+    private ArdAlarmStealelecMapper stealelecMapper;
+    @Autowired
+    private ArdAlarmCameraMapper cameraMapper;
+    @Autowired
+    private ArdAlarmRadarMoveMapper moveMapper;
+    @Autowired
+    private ArdAlarmRadarFireMapper fireMapper;
+    @Autowired
+    private ArdAlarmExternalMapper externalMapper;
+    @Autowired
+    private ArdAlarmAccessMapper accessMapper;
+    @Autowired
+    private ArdAlarmApponekeyMapper apponekeyMapper;
+    @Autowired
+    private ArdAlarmRadarPumpMapper pumpMapper;
+    @Autowired
+    private ArdAlarmWallMapper wallMapper;
+    @Autowired
+    private ArdAlarmDigitization3Mapper digitization3Mapper;
+    @Autowired
+    private ArdAlarmTubeMapper tubeMapper;
+    @Autowired
+    private ArdEquipRadarMapper radarMapper;
+    @Autowired
+    private ArdCamerasMapper camerasMapper;
+
 
     @Override
     public Results factorySave(Map<String, String> map) {
@@ -91,4 +138,291 @@
         jsonObject.put("well",String.valueOf(num));
         return Results.succeed(jsonObject);
     }
+
+    @Override
+    public List<CountVo> stealelecYear(ESParam esParam) {
+        List<CountVo> list = stealelecMapper.stealelecYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> cameraYear(ESParam esParam) {
+        List<CountVo> list = cameraMapper.cameraYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> moveYear(ESParam esParam) {
+        List<CountVo> list = moveMapper.moveYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> fireYear(ESParam esParam) {
+        List<CountVo> list = fireMapper.fileYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> externalYear(ESParam esParam) {
+        List<CountVo> list = externalMapper.externalYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> accessYear(ESParam esParam) {
+        List<CountVo> list = accessMapper.accessYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> apponekeyYear(ESParam esParam) {
+        List<CountVo> list = apponekeyMapper.apponekeyYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> pumpYear(ESParam esParam) {
+        List<CountVo> list = pumpMapper.pumpYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> wallYear(ESParam esParam) {
+        List<CountVo> list = wallMapper.wallYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> digitizationYear(ESParam esParam) {
+        List<CountVo> list = digitization3Mapper.digitizationYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> tubeYear(ESParam esParam) {
+        List<CountVo> list = tubeMapper.tubeYear(esParam);
+        return es(list);
+    }
+
+    @Override
+    public List<CountVo> stealelecMonth(ESParam esParam) {
+        List<CountVo> list = stealelecMapper.stealelecMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> cameraMonth(ESParam esParam) {
+        List<CountVo> list = cameraMapper.cameraMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> moveMonth(ESParam esParam) {
+        List<CountVo> list = moveMapper.moveMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> fireMonth(ESParam esParam) {
+        List<CountVo> list = fireMapper.fileMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> externalMonth(ESParam esParam) {
+        List<CountVo> list = externalMapper.externalMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> accessMonth(ESParam esParam) {
+        List<CountVo> list = accessMapper.accessMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> apponekeyMonth(ESParam esParam) {
+        List<CountVo> list = apponekeyMapper.apponekeyMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> pumpMonth(ESParam esParam) {
+        List<CountVo> list = pumpMapper.pumpMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> wallMonth(ESParam esParam) {
+        List<CountVo> list = wallMapper.wallMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> digitizationMonth(ESParam esParam) {
+        List<CountVo> list = digitization3Mapper.digitizationMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public List<CountVo> tubeMonth(ESParam esParam) {
+        List<CountVo> list = tubeMapper.tubeMonth(esParam);
+        return esMonth(list,esParam.getEnd());
+    }
+
+    @Override
+    public UnitVo unit() {
+        UnitVo unitVo = new UnitVo();
+        //闆疯揪鍦ㄧ嚎鏁伴噺
+        List<ArdEquipRadar> radarList = radarMapper.selectList(null);
+        Timer timer = new Timer();
+        TimerTask timerTask =new TimerTask(){
+            @Override
+            public void run(){
+                Para.setI(0);
+               for (int i = 0; i < radarList.size(); i++) {
+                   ArdEquipRadar radar = radarList.get(i);
+                   String host = radar.getIp();
+                   String port = radar.getPort();
+                    Thread thread = new Thread(){
+                        @Override
+                        public void run(){
+                            try {
+                                Socket socket = new Socket(host,Integer.valueOf(port));
+                            } catch (Exception e) {
+                                int num = Para.getI();
+                                num++;
+                            }
+                        }
+                    };
+                    thread.start();
+                }
+                int n = Para.getI();
+                Para.setJ(radarList.size() - Para.getI());
+            }
+        };
+        Date date = new Date();
+        timer.scheduleAtFixedRate(timerTask,date,5000);
+        unitVo.setRadar(Para.getJ());
+        //鍏夌數鏁伴噺
+        QueryWrapper<ArdCameras> queryWrapper = new QueryWrapper<>();
+        queryWrapper.select("id").eq("gdtype","0").eq("state","1");
+        List<ArdCameras> ardCameras = camerasMapper.selectList(queryWrapper);
+        unitVo.setCamera(ardCameras.size());
+        return unitVo;
+    }
+
+    @Override
+    public int stealelecNum() {
+        return stealelecMapper.selectCount(null);
+    }
+
+    @Override
+    public int cameraNum() {
+        return cameraMapper.selectCount(null);
+    }
+
+    @Override
+    public int moveNum() {
+        return moveMapper.selectCount(null);
+    }
+
+    @Override
+    public int fireNum() {
+        return fireMapper.selectCount(null);
+    }
+
+    @Override
+    public int externalNum() {
+        return externalMapper.selectCount(null);
+    }
+
+    @Override
+    public int accessNum() {
+        return accessMapper.selectCount(null);
+    }
+
+    @Override
+    public int apponekeyNum() {
+        return apponekeyMapper.selectCount(null);
+    }
+
+    @Override
+    public int pumpNum() {
+        return pumpMapper.selectCount(null);
+    }
+
+    @Override
+    public int wallNum() {
+        return wallMapper.selectCount(null);
+    }
+
+    @Override
+    public int digitizationNum() {
+        return digitization3Mapper.selectCount(null);
+    }
+
+    @Override
+    public int tubeNum() {
+        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;
+            if(i<=10){
+                month = "0"+i;
+            }else {
+                month = String.valueOf(i);
+            }
+            Boolean bo = false;
+            for (int j = 0; j < list.size(); j++) {
+                CountVo countVo = list.get(j);
+                String mon = countVo.getDate();
+                if(mon.equals(month)){
+                    bo = true;
+                }
+            }
+            if(!bo){
+                CountVo countVo = new CountVo();
+                countVo.setDate(month);
+                countVo.setCount(0);
+                list.add(countVo);
+            }
+        }
+        return list;
+    }
+
+    public List<CountVo> esMonth(List<CountVo> list,String end){
+        Integer day = Integer.valueOf(end.substring(end.length() - 2));
+        for (int i = 1; i <= day ; i++) {
+            String d;
+            if(i<=10){
+                d = "0"+i;
+            }else {
+                d = String.valueOf(i);
+            }
+            Boolean bo = false;
+            for (int j = 0; j < list.size(); j++) {
+                CountVo countVo = list.get(j);
+                String mon = countVo.getDate();
+                if(mon.equals(d)){
+                    bo = true;
+                }
+            }
+            if(!bo){
+                CountVo countVo = new CountVo();
+                countVo.setDate(d);
+                countVo.setCount(0);
+                list.add(countVo);
+            }
+        }
+        return list;
+    }
 }

--
Gitblit v1.9.3