fix:升级语句优化

cjl

2023-09-12 ea1373d4e1511b620bb87872e692643e2edb81f8

 screen-api/src/main/java/com/moral/api/service/impl/HnExcelServiceImpl.java

@@ -246,7 +246,7 @@
                        Integer integer1 = list.get(13);
                        double i  = integer - integer1;

                        double i1 = AmendUtils.sciCal((i / integer1)*100,1);
                        double i1 = AmendUtils.sciCal((Math.abs(i) / integer1)*100,1);
                        String code  = "";
                        if (i<0){
                            code = "改善"+i1+"%";
@@ -631,6 +631,9 @@
                continue;
            }
            short lastCellNum = row.getLastCellNum();
            if (lastCellNum<=0){
                continue;
            }

            Object[] objects = new Object[lastCellNum];
            for (int j = 0; j < lastCellNum; j++) {
@@ -644,7 +647,7 @@

            HashMap<String, Object> map1 = new HashMap<>();
            HashMap<String, Object> map2 = new HashMap<>();
            if (objects.length == 8) {
            if (objects.length == 8 || objects.length == 9) {
                if (objects[0]!=null){
                    if (!objects[1].toString().contains("H")
                            && !objects[2].toString().contains("H")
@@ -1624,12 +1627,20 @@
            if (i < 10) {
                Object o = hnMap1.get(s + "-" + month + "-0" + i);
                String s1 = JSON.toJSONString(o);
                if (s1.equals("null")){
                    list2.add(0.0);
                    continue;
                }
                Map map1 = JSON.parseObject(s1, Map.class);
                String pm2_5 = map1.get("PM2_5").toString();
                list2.add(Double.parseDouble(pm2_5));
            } else {
                Object o = hnMap1.get(s + "-" + month + "-" + i);
                String s1 = JSON.toJSONString(o);
                if (s1.equals("null")){
                    list2.add(0.0);
                    continue;
                }
                Map map1 = JSON.parseObject(s1, Map.class);
                String pm2_5 = map1.get("PM2_5").toString();
                list2.add(Double.parseDouble(pm2_5));