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