| | |
| | | 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+"%"; |
| | |
| | | continue; |
| | | } |
| | | short lastCellNum = row.getLastCellNum(); |
| | | if (lastCellNum<=0){ |
| | | continue; |
| | | } |
| | | |
| | | Object[] objects = new Object[lastCellNum]; |
| | | for (int j = 0; j < lastCellNum; j++) { |
| | |
| | | |
| | | 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") |
| | |
| | | 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)); |