From a3d41aaa84c64dd296a2bd89198682276ef7b1d3 Mon Sep 17 00:00:00 2001 From: 13693261870 <252740454@qq.com> Date: 星期三, 26 四月 2023 14:05:32 +0800 Subject: [PATCH] 1 --- src/main/java/com/yssh/service/impl/WarningAnalyseServiceImpl.java | 48 ++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 38 insertions(+), 10 deletions(-) diff --git a/src/main/java/com/yssh/service/impl/WarningAnalyseServiceImpl.java b/src/main/java/com/yssh/service/impl/WarningAnalyseServiceImpl.java index eccd472..79b1a49 100644 --- a/src/main/java/com/yssh/service/impl/WarningAnalyseServiceImpl.java +++ b/src/main/java/com/yssh/service/impl/WarningAnalyseServiceImpl.java @@ -253,28 +253,29 @@ Map<String, List<Double>> result = new LinkedHashMap<>(); List<MonitorPointPosition> checkPoints = commonService.getCheckPoints3d(); - Date nowDate = DateUtils.getNowDate(); Long endTime = Long.parseLong(DateUtils.parseDateToStr(DateUtils.YYYYMMDDHH, nowDate)); Long startTime = Long.parseLong(DateUtils.parseDateToStr(DateUtils.YYYYMMDDHH, DateUtils.getAPeriodOfTime(nowDate, -3, Calendar.HOUR_OF_DAY))); List<DictRecord> recordList = dictRecordMapper.selectByTimeDictRecordList(startTime, endTime); List<String> tableNames = new ArrayList<>(); - for(DictRecord dr : recordList){ - if (suYuanMapper.isTableExists(dr.getTableName())>0){ + for (DictRecord dr : recordList) { + if (suYuanMapper.isTableExists(dr.getTableName()) > 0) { tableNames.add(dr.getTableName()); } } - if (tableNames.isEmpty()){ + if (tableNames.isEmpty()) { return result; } - for(MonitorPointPosition c : checkPoints){ + for (MonitorPointPosition c : checkPoints) { List<Double> values = new ArrayList<>(); List<SuYuanMonitorData> data = suYuanMapper.getMonitorData(tableNames, c.getId()); - data.forEach(v -> { - values.add(v.getValue()); - }); + if (null != data && data.size() > 0) { + for (SuYuanMonitorData v : data) { + values.add(v.getValue()); + } + } result.put(c.getName(), values); } return result; @@ -282,7 +283,7 @@ @Override public List<Map<String, Object>> selectThisMonthLocationValueDataTop10() { - List<Map<String, Object>> result = new ArrayList<>(); + /*List<Map<String, Object>> result = new ArrayList<>(); List<MonitorPointPosition> checkPoints = commonService.getCheckPoints3d(); Long startTime = Long.parseLong(DateUtils.parseDateToStr(DateUtils.YYYYMMDDHH, DateUtils.getMonthStart())); Long endTime = Long.parseLong(DateUtils.parseDateToStr(DateUtils.YYYYMMDDHH, DateUtils.getMonthEnd())); @@ -300,7 +301,34 @@ } result.add(map); }); + return CalculateUtils.sort(result, "value", true).subList(0, 10);*/ + + List<Map<String, Object>> result = new ArrayList<>(); + List<MonitorPointPosition> checkPoints = commonService.getCheckPoints3d(); + Long startTime = Long.parseLong(DateUtils.parseDateToStr(DateUtils.YYYYMMDDHH, DateUtils.getMonthStart())); + Long endTime = Long.parseLong(DateUtils.parseDateToStr(DateUtils.YYYYMMDDHH, DateUtils.getMonthEnd())); + List<DictRecord> recordList = dictRecordMapper.selectByTimeDictRecordList(startTime, endTime); + + List<String> tableNames = new ArrayList<>(); + for (DictRecord dr : recordList) { + if (suYuanMapper.isTableExists(dr.getTableName()) > 0) { + tableNames.add(dr.getTableName()); + } + } + if (tableNames.isEmpty()) { + return result; + } + + for (MonitorPointPosition c : checkPoints) { + Map<String, Object> map = suYuanMapper.getMonthValueDataMax(tableNames, c.getId()); + if (null != map && map.size() > 0) { + String suYuanId = map.get("id").toString(); + map.put("name", commonService.select3dCheckPointById(suYuanId).getName()); + map.remove("id"); + } + result.add(map); + } + return CalculateUtils.sort(result, "value", true).subList(0, 10); } - } -- Gitblit v1.9.3