jinpengyong
2022-10-13 f2f153d71b37f0998e979de889fcb986f356a54f
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;
    }