From f2f153d71b37f0998e979de889fcb986f356a54f Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 13 Oct 2022 11:34:56 +0800 Subject: [PATCH] 修改浑南区图表季度PM2.5数据 --- screen-api/src/main/java/com/moral/api/service/impl/HnExcelServiceImpl.java | 52 +++++++++++++++++++++++++++++++++++++++------------- 1 files changed, 39 insertions(+), 13 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/service/impl/HnExcelServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/HnExcelServiceImpl.java index b03f176..b411222 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/HnExcelServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/HnExcelServiceImpl.java @@ -196,22 +196,19 @@ list1.add(0,"������������"); rsMap.put("hnq1",list1); } + + if (s.equals("������")){ + List<Integer> list = stringListMap.get(s); + if (list.size()>0){ + syExcelVo.setCode6(list.get(0).toString()); + }else { + syExcelVo.setCode6(""); + } + + } if (s.equals("PM2_5")){ ArrayList<String> list1 = new ArrayList<>(); List<Integer> list = stringListMap.get(s); - Integer sum =0; - if (data>=1 && data<=3){ - sum = list.get(0) + list.get(1) + list.get(2); - }else if (data>=4 &&data<=6){ - sum = list.get(3) + list.get(4) + list.get(5); - }else if (data>=7 &&data<=9){ - sum = list.get(6) + list.get(7) + list.get(8); - }else { - sum = list.get(9) + list.get(10) + list.get(11); - } - - Integer round = Math.round(sum / 3); - syExcelVo.setCode6(round.toString()); for (int i = 0; i < list.size()-1; i++) { if (list.get(i)==0){ list1.add(""); @@ -645,6 +642,34 @@ } } + + //������������pm2.5 + String ju = time.substring(5, 7); + int data = Integer.parseInt(ju); + ArrayList<Double> rsData = new ArrayList<>(); + if (data>=1 && data<=3){ + rsData.addAll(list1); + rsData.addAll(list2); + rsData.addAll(list3); + }else if (data>=4 &&data<=6){ + rsData.addAll(list4); + rsData.addAll(list5); + rsData.addAll(list6); + }else if (data>=7 &&data<=9){ + rsData.addAll(list7); + rsData.addAll(list8); + rsData.addAll(list9); + }else { + rsData.addAll(list10); + rsData.addAll(list11); + rsData.addAll(list12); + } + ArrayList<Integer> pmList = new ArrayList<>(); + if (rsData.size()>0){ + int pm = (int) AmendUtils.sciCal(rsData.stream().collect(Collectors.averagingDouble(Double::doubleValue)), 0); + pmList.add(pm); + } + int code1 =0; int code2 =0; int code3 =0; @@ -782,6 +807,7 @@ listPM.add(resPM25); listMap.put("PM2_5",listPM); listMap.put("������",integers); + listMap.put("������",pmList); return listMap; } -- Gitblit v1.8.0