From 74e3485e6bae63e73f5d3be8b36c671e30aa389d Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 20 十一月 2024 10:31:21 +0800
Subject: [PATCH] 1
---
src/main/java/com/yssh/service/WarningAnalyseService.java | 145 ++++++++++++++++++++++++++++++++++++++++++------
1 files changed, 127 insertions(+), 18 deletions(-)
diff --git a/src/main/java/com/yssh/service/WarningAnalyseService.java b/src/main/java/com/yssh/service/WarningAnalyseService.java
index 5c524c1..0a0aece 100644
--- a/src/main/java/com/yssh/service/WarningAnalyseService.java
+++ b/src/main/java/com/yssh/service/WarningAnalyseService.java
@@ -1,6 +1,5 @@
package com.yssh.service;
-import java.text.SimpleDateFormat;
import java.util.*;
import java.util.concurrent.CountDownLatch;
@@ -9,6 +8,7 @@
import com.yssh.mapper.QxshMapper;
import com.yssh.mapper.SuYuanMapper;
import com.yssh.mapper.WarningDetailMapper;
+import com.yssh.utils.CacheUtils;
import com.yssh.utils.CalculateUtils;
import com.yssh.utils.DateUtils;
import com.yssh.utils.StringUtils;
@@ -26,25 +26,28 @@
protected final Logger logger = LoggerFactory.getLogger(this.getClass());
@Resource
- private WarningDetailMapper warningDetailMapper;
+ WarningDetailMapper warningDetailMapper;
@Resource
- private CommonService commonService;
+ CommonService commonService;
@Resource
- private SuYuanMapper suYuanMapper;
+ SuYuanMapper suYuanMapper;
@Resource
- private DictRecordMapper dictRecordMapper;
+ DictRecordMapper dictRecordMapper;
@Resource
- private AsyncService asyncService;
+ AsyncService asyncService;
@Resource
- private QxshMapper qxshMapper;
+ QxshMapper qxshMapper;
@Resource
- private VocValsService vocValsService;
+ VocValsService vocValsService;
+
+ @Resource
+ SuYuanService suYuanService;
private static HashMap<String, String> filterMap = new HashMap<>();
@@ -63,14 +66,32 @@
* 鑾峰彇瀹炴椂鎶ヨ
*/
public List<Qxsh> getRunTimeAlarmAnalyse(Integer start, Integer end) {
- return qxshMapper.selectAlarmByBeginAndEnd(start, end);
+ //List<Qxsh> list = qxshMapper.selectAlarmByBeginAndEnd(start, end);
+ String key = "qxshMapper.selectAlarmByBeginAndEnd." + start + "." + end;
+ List<Qxsh> list = CacheUtils.getListByKey(key);
+ if (null == list) {
+ list = qxshMapper.selectAlarmByBeginAndEnd(start, end);
+ copeHasSuYuan(list);
+ CacheUtils.putListByKey(key, list);
+ }
+
+ return list;
}
/**
* 鑾峰彇瀹炴椂棰勮
*/
public List<Qxsh> getRunTimeWarningAnalyse(Integer start, Integer end) {
- return qxshMapper.selectWarnByBeginAndEnd(start, end);
+ //List<Qxsh> list = qxshMapper.selectWarnByBeginAndEnd(start, end);
+ String key = "qxshMapper.selectWarnByBeginAndEnd." + start + "." + end;
+ List<Qxsh> list = CacheUtils.getListByKey(key);
+ if (null == list) {
+ list = qxshMapper.selectWarnByBeginAndEnd(start, end);
+ copeHasSuYuan(list);
+ CacheUtils.putListByKey(key, list);
+ }
+
+ return list;
}
/**
@@ -82,12 +103,20 @@
Integer start = Integer.parseInt(DateUtils.getYyyyMmDdHh(startDate));
Integer end = Integer.parseInt(DateUtils.getYyyyMmDdHh(endDate));
+ String key = "WAS.monthCount." + start + "." + end;
+ Object obj = CacheUtils.get(key);
+ if (obj instanceof Map<?, ?>) {
+ return (Map<String, Integer>) obj;
+ }
+
Map<String, Integer> result = new HashMap<>();
Integer warnNum = qxshMapper.countMonthForWarn(start, end);
result.put("warningNumber", null == warnNum ? 0 : warnNum);
Integer alarmNum = qxshMapper.countMonthForAlarm(start, end);
result.put("alarmNumber", null == alarmNum ? 0 : alarmNum);
+
+ CacheUtils.put(key, result);
return result;
}
@@ -101,10 +130,22 @@
Integer start = Integer.parseInt(DateUtils.getYyyyMmDdHh(startDate));
Map<String, List<Map<String, Object>>> result = new HashMap<>();
- List<Map<String, Object>> warnList = qxshMapper.count7DayForWarn(start, end);
+ //List<Map<String, Object>> warnList = qxshMapper.count7DayForWarn(start, end);
+ String key = "qxshMapper.count7DayForWarn." + start + "." + end;
+ List<Map<String, Object>> warnList = CacheUtils.getListByKey(key);
+ if (null == warnList) {
+ warnList = qxshMapper.count7DayForWarn(start, end);
+ CacheUtils.putListByKey(key, warnList);
+ }
result.put("warningDayCount", warnList);
- List<Map<String, Object>> alarmList = qxshMapper.count7DayForAlarm(start, end);
+ //List<Map<String, Object>> alarmList = qxshMapper.count7DayForAlarm(start, end);
+ String key2 = "qxshMapper.count7DayForAlarm." + start + "." + end;
+ List<Map<String, Object>> alarmList = CacheUtils.getListByKey(key2);
+ if (null == alarmList) {
+ alarmList = qxshMapper.count7DayForAlarm(start, end);
+ CacheUtils.putListByKey(key2, alarmList);
+ }
result.put("alarmDayCount", alarmList);
return result;
@@ -119,9 +160,16 @@
Integer start = Integer.parseInt(DateUtils.getYyyyMmDdHh(startDate));
// List<String> times = DateUtils.get3Hours();
- List<Qxsh> list = qxshMapper.select3Hours(start, end);
- if (null == list || list.isEmpty()) {
- return null;
+ //List<Qxsh> list = qxshMapper.select3Hours(start, end);
+ //if (null == list || list.isEmpty()) {
+ // return null;
+ //}
+
+ String key = "qxshMapper.select3Hours." + start + "." + end;
+ List<Qxsh> list = CacheUtils.getListByKey(key);
+ if (null == list) {
+ list = qxshMapper.select3Hours(start, end);
+ CacheUtils.putListByKey(key, list);
}
/* Map<String, List<Double>> map = new LinkedHashMap<>();
@@ -139,7 +187,14 @@
*/
public List<Qxsh> selectMonthTop10() {
String time = DateUtils.getYyyyMm(new Date());
- List<Qxsh> list = qxshMapper.selectMonthTop10(time + "%");
+ //List<Qxsh> list = qxshMapper.selectMonthTop10(time + "%");
+
+ String key = "qxshMapper.selectMonthTop10." + time;
+ List<Qxsh> list = CacheUtils.getListByKey(key);
+ if (null == list) {
+ list = qxshMapper.selectMonthTop10(time + "%");
+ CacheUtils.putListByKey(key, list);
+ }
return list;
}
@@ -157,7 +212,13 @@
Integer intMon = Integer.parseInt(DateUtils.parseDateToStr(DateUtils.YYYYMMDD, mon) + "00"); // 2023080700
Integer intSun = Integer.parseInt(DateUtils.parseDateToStr(DateUtils.YYYYMMDD, sun) + "23"); // 2023081323
- List<Qxsh> list = qxshMapper.selectWeekTop10(intMon, intSun);
+ //List<Qxsh> list = qxshMapper.selectWeekTop10(intMon, intSun);
+ String key = "qxshMapper.selectWeekTop10." + intMon + "." + intSun;
+ List<Qxsh> list = CacheUtils.getListByKey(key);
+ if (null == list) {
+ list = qxshMapper.selectWeekTop10(intMon, intSun);
+ CacheUtils.putListByKey(key, list);
+ }
return list;
}
@@ -167,7 +228,14 @@
*/
public List<Qxsh> selectDayTop10() {
String time = DateUtils.getYyyyMmDd(new Date());
- List<Qxsh> list = qxshMapper.selectDayTop10(time + "%");
+ //List<Qxsh> list = qxshMapper.selectDayTop10(time + "%");
+
+ String key = "qxshMapper.selectDayTop10." + time;
+ List<Qxsh> list = CacheUtils.getListByKey(key);
+ if (null == list) {
+ list = qxshMapper.selectDayTop10(time + "%");
+ CacheUtils.putListByKey(key, list);
+ }
return list;
}
@@ -196,12 +264,20 @@
WarningDetail wd = new WarningDetail(0L, tab, suYuanId, qxsh.getName(), null, 0, qxsh.getValue());
DistanceSuYuan suYuan = suYuanMapper.getSuYuanById(tab, suYuanId);
+ if (null == suYuan) {
+ String[] strs = suYuanId.split("_");
+ suYuan = new DistanceSuYuan(null, null, 0.0, suYuanId, Integer.parseInt(strs[0]), Integer.parseInt(strs[1]), 0, 0, null, 0.0, 0.0, 0.0, 0.0);
+ }
//List<String> ids3d = CalculateUtils.aloneCrosswiseExtend(point, 50);
//DistanceSuYuan suMax = suYuanMapper.getSuYuan500Max(tab, ids3d);
//String filter = CalculateUtils.getFilterByExtend(point, 50);
String filter = getFilterByPoint(point, 50);
DistanceSuYuan suMax = suYuanMapper.getSuYuan500MaxByFilter(tab, filter);
+ if (null == suMax) {
+ String[] strs = suYuanId.split("_");
+ suMax = new DistanceSuYuan(null, null, 0.0, suYuanId, Integer.parseInt(strs[0]), Integer.parseInt(strs[1]), 0, 0, null, 0.0, 0.0, 0.0, 0.0);
+ }
suMax.setAddr(getAddr(suMax.getId()));
Report report = Report.calcReport(wd, suYuan, suMax);
@@ -317,4 +393,37 @@
return result;
}
+
+ /**
+ * 澶勭悊鏄惁鍚湁婧簮淇℃伅
+ */
+ private List<Qxsh> copeHasSuYuan(List<Qxsh> list) {
+ if (null == list || list.isEmpty()) {
+ return null;
+ }
+
+ Map<String, Integer> tabs = new HashMap<>();
+ for (Qxsh qxsh : list) {
+ String tab = "su_yuan_" + qxsh.getTime();
+ if (!tabs.containsKey(tab)) {
+ tabs.put(tab, suYuanMapper.isTableExists(tab));
+ }
+
+ int rows = tabs.get(tab);
+ if (0 == rows) {
+ continue;
+ }
+
+ String suYuanId = suYuanService.selectSuYuanIdByName(qxsh.getName());
+ String createTime = qxsh.getTime().substring(0, 4) + "-" + qxsh.getTime().substring(4, 6) + "-" + qxsh.getTime().substring(6, 8) + " " + qxsh.getTime().substring(8, 10) + ":00:00";
+
+ Integer isSuYuan = qxshMapper.hasSuYuan(suYuanId, createTime);
+ qxsh.setIsSuYuan(isSuYuan);
+
+ Integer isFast = qxshMapper.countFastSuYuan(suYuanId, createTime);
+ qxsh.setIsFast(isFast);
+ }
+
+ return list;
+ }
}
--
Gitblit v1.9.3