From e4478db5cb30396bf862fdab12ffecbc574a72e6 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 19 Nov 2020 16:02:27 +0800 Subject: [PATCH] 大屏O3预测与实测对比更新 --- src/main/java/com/moral/service/impl/WeatherServiceImpl.java | 315 ++++++++++++++++++++++++++++----------------------- 1 files changed, 172 insertions(+), 143 deletions(-) diff --git a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java index 0184499..b584f82 100644 --- a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java +++ b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java @@ -197,31 +197,40 @@ parameters.put("start", sdf.parse(time)); parameters.put("end", sdf.parse(nextDay)); MonitorPoint monitorPoint = monitorPointMapper.selectByPrimaryKey(Integer.valueOf(monitorPointId)); + int cityCode; + int parentCode; if (monitorPoint.getAreaCode() == null) { - parameters.put("cityCode", monitorPoint.getCityCode()); + cityCode = monitorPoint.getCityCode(); + parentCode = monitorPoint.getProvinceCode(); } else { - parameters.put("cityCode", monitorPoint.getAreaCode()); + cityCode = monitorPoint.getAreaCode(); + parentCode = monitorPoint.getCityCode(); } + parameters.put("cityCode", cityCode); + //������O3 List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters); - List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecastHour(parameters); - - String timeUnits=time.substring(5,7); - if(aqiList.size() == 0){ + String timeUnits = time.substring(0, 4); + if (aqiList.size() == 0) { parameters.put("timeUnits", timeUnits); aqiList = hangzhouAqiMapper.getHistoryO3(parameters); if (aqiList.size() == 0) { - parameters.put("cityCode", monitorPoint.getCityCode()); + parameters.put("cityCode", parentCode); aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters); - if(aqiList.size() == 0){ - parameters.put("cityCode", monitorPoint.getAreaCode()); + if (aqiList.size() == 0) { aqiList = hangzhouAqiMapper.getHistoryO3(parameters); } } } - + //������O3 + parameters.put("cityCode", cityCode); + List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecastHour(parameters); + if (forecastList.size() == 0) { + parameters.put("cityCode", parentCode); + forecastList = forecastWeatherMapper.getForecastHour(parameters); + } for (Map<String, Object> map : aqiList) { - String O3 = map.get("O3").toString().replace("\"", ""); - map.put("O3", O3); + int s = (int)Double.parseDouble(map.get("O3").toString().replace("\"", "")); + map.put("O3", String.valueOf(s)); } List<Map<String, Object>> resultList = new ArrayList<>(); @@ -372,6 +381,9 @@ City city = cityMapper.getCityByName(cityName); if (city == null) { Province province = provinceMapper.getProvinceByName(cityName); + if (province == null) { + return new ArrayList<>(); + } code = province.getProvinceCode(); name = province.getProvinceName(); parentCode = 0; @@ -409,6 +421,7 @@ Date end = cal.getTime(); cal.setTime(sdf.parse(time)); cal.add(Calendar.DAY_OF_MONTH, -1); + //������������������������������������������������������������������ String beforeDay = sdf.format(cal.getTime()); parameters.put("start", selectTime); parameters.put("end", end); @@ -418,46 +431,40 @@ if (!String.valueOf(code).endsWith("0000")) { parameters.put("cityCode", parentCode); forecastList = forecastWeatherMapper.getForecast(parameters); + } else { + return new ArrayList<>(); } } - - //���������������������������07,15��������������� - List<Map<String, Object>> foreList = new ArrayList<>(); + //���������������������������07,15������������������ for (Map<String, Object> forecastMap : forecastList) { - Map<String, Object> hashMap = new HashMap<>(); - hashMap.put("time", forecastMap.get("time").toString()); - hashMap.put("type", "������"); - hashMap.put("city", name); + forecastMap.put("type", "������"); + forecastMap.put("city", name); if (sdf.parse(time).getTime() <= now.getTime()) { - hashMap.put("fxTime", (beforeDay + " 15:00").substring(5, 16)); + forecastMap.put("fxTime", (beforeDay + " 15:00").substring(5, 16)); } else { String format = sdf1.format(now).split(" ")[0]; Date date1 = sdf1.parse(format + " 07:00:00"); Date date2 = sdf1.parse(format + " 15:00:00"); if (now.getTime() > date2.getTime()) { - hashMap.put("fxTime", (beforeDay + " 15:00").substring(5, 16)); + forecastMap.put("fxTime", (beforeDay + " 15:00").substring(5, 16)); } else if (now.getTime() > date1.getTime()) { - hashMap.put("fxTime", (beforeDay + " 07:00").substring(5, 16)); + forecastMap.put("fxTime", (beforeDay + " 07:00").substring(5, 16)); } } - Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(forecastMap.get("json").toString()); - hashMap.putAll(jsonMap); - foreList.add(hashMap); - } - - for (Map<String, Object> foreMap : foreList) { + Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(forecastMap.remove("json").toString()); + forecastMap.putAll(jsonMap); + //������������������6������������������ Map<String, Object> hashMap = new HashMap<>(); hashMap.put("cityCode", parameters.get("cityCode").toString()); - Date endTime = sdf1.parse(foreMap.get("time").toString()); + Date endTime = sdf1.parse(forecastMap.get("time").toString()); hashMap.put("end", endTime); - //������6������������������(������) cal.setTime(endTime); cal.add(Calendar.HOUR, -6); Date startTime = cal.getTime(); hashMap.put("start", startTime); Map<String, Object> precip6HourMap = forecastWeatherMapper.getPrecip6Hour(hashMap); if (precip6HourMap != null) { - foreMap.put("precip6", precip6HourMap.get("precip6").toString()); + forecastMap.put("precip6", precip6HourMap.get("precip6").toString()); } //������8������O3���������(������) cal.setTime(endTime); @@ -466,19 +473,21 @@ hashMap.put("start", startTime); Map<String, Object> O3Map = forecastWeatherMapper.getO38Hours(hashMap); if (O3Map != null) { - foreMap.put("O3C_8H", O3Map.get("O3_8H").toString()); + forecastMap.put("O3C_8H", O3Map.get("O3_8H").toString()); } + } + //������������aqi parameters.put("cityCode", code); - //���hangzhou_aqi���������������������history_aqi_��������������� + //���hangzhou_aqi���������������������history_aqi��������������� int p = 0; - String timeUnits1 = time.substring(5, 7); - String timeUnits2 = sdf1.format(end).substring(5, 7); + String timeUnits1 = time.substring(0, 4); + String timeUnits2 = sdf1.format(end).substring(0, 4); List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters); if (aqiList.size() == 0) { p = 1; - //1-23��������������������������������������������������������������������� + //1-23���������������������������00������������������ parameters.put("timeUnits", timeUnits1); List<Map<String, Object>> aqiList1 = hangzhouAqiMapper.getHistoryAqi(parameters); parameters.put("timeUnits", timeUnits2); @@ -501,14 +510,12 @@ } } } - DecimalFormat df = new DecimalFormat(".####"); DecimalFormat df1 = new DecimalFormat("#.#"); - List<Map<String, Object>> realAqilist = new ArrayList<>(); for (Map<String, Object> aqiMap : aqiList) { - Map<String, Object> hashMap = new HashMap<>(); - hashMap.put("time", aqiMap.get("time")); - Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(aqiMap.get("json").toString()); + aqiMap.put("type", "������"); + aqiMap.put("city", name); + Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(aqiMap.remove("json").toString()); for (String key : jsonMap.keySet()) { if ("NO2".equals(key) || "NO2C".equals(key) || "O3".equals(key) || "O3C".equals(key) || "SO2".equals(key) || "SO2C".equals(key) || "PM2_5".equals(key) || "PM25C".equals(key) || "PM10".equals(key) || "PM10C".equals(key)) { @@ -521,16 +528,11 @@ long AQI = Math.round(Double.valueOf(jsonMap.get(key).toString())); jsonMap.put(key, String.valueOf(AQI)); } - } - hashMap.putAll(jsonMap); - hashMap.put("city", name); - realAqilist.add(hashMap); - } + aqiMap.putAll(jsonMap); - //������o3_8H(������) - for (Map<String, Object> map : realAqilist) { - String s = map.get("time").toString(); + //������O3_8H(������) + String s = aqiMap.get("time").toString(); Date endTime = sdf1.parse(s); cal.setTime(endTime); cal.add(Calendar.HOUR, -8); @@ -539,15 +541,16 @@ hashMap.put("cityCode", parameters.get("cityCode").toString()); hashMap.put("start", startTime); hashMap.put("end", endTime); - Map<String, Object> O3Map = new HashMap<>(); + Map<String, Object> O3Map; if (p == 0) { O3Map = hangzhouAqiMapper.getAvgO3EightHours(hashMap); } else { hashMap.put("time", endTime); - hashMap.put("timeUnits", s.substring(5, 7)); + hashMap.put("timeUnits", s.substring(0, 4)); O3Map = hangzhouAqiMapper.getHistoryO3EightHours(hashMap); } - map.put("O3C_8H", O3Map.get("O3_8H").toString().replace("\"", "")); + aqiMap.put("O3C_8H", O3Map.get("O3_8H").toString().replace("\"", "")); + } //������������������������������������������������������tvoc Map<String, Object> params = new HashMap<>(); @@ -570,12 +573,13 @@ //������������ int x = 0; + parameters.put("cityCode", code); List<Map<String, Object>> realList = realWeatherMapper.getRealWeather(parameters); if (realList.size() == 0) { - //1-23��������������������������������������������������������������������� + //1-23���������������������������00������������������ x = 1; - timeUnits1 = time.substring(5, 7); - timeUnits2 = sdf1.format(end).substring(5, 7); + timeUnits1 = time.substring(0, 4); + timeUnits2 = sdf1.format(end).substring(0, 4); parameters.put("timeUnits", timeUnits1); List<Map<String, Object>> realList1 = realWeatherMapper.getHistoryWeather(parameters); parameters.put("timeUnits", timeUnits2); @@ -598,37 +602,58 @@ } } } - List<Map<String, Object>> realWeatherList = new ArrayList<>(); for (Map<String, Object> realMap : realList) { - Map<String, Object> hashMap = new HashMap<>(); - hashMap.put("time", realMap.get("time")); - Map<String, Object> jsonMap = new HashMap<>(); + Map<String, Object> jsonMap; if (x == 0) { - jsonMap = (Map<String, Object>) JSONObject.parse(realMap.get("json").toString()); + jsonMap = (Map<String, Object>) JSONObject.parse(realMap.remove("json").toString()); } else { - jsonMap = (Map<String, Object>) JSONObject.parse(realMap.get("value").toString()); + jsonMap = (Map<String, Object>) JSONObject.parse(realMap.remove("value").toString()); } - hashMap.putAll(jsonMap); - hashMap.put("city", name); - realWeatherList.add(hashMap); + realMap.putAll(jsonMap); + realMap.put("city", name); + realMap.put("type", "������"); } - for (Map<String, Object> realMap : realWeatherList) { - String rtime = realMap.get("time").toString(); - //������������ - for (Map<String, Object> beamMap : beamList) { - if (beamMap.get("time").equals(rtime)) { - realMap.put("beam", beamMap.get("beam").toString()); - } - } - //TVOC + //TVOC,������������ + for (Map<String, Object> beamMap : beamList) { for (Map<String, Object> tvocMap : tvocList) { - if (tvocMap.get("time").equals(rtime)) { - realMap.put("TVOC", tvocMap.get("TVOC").toString()); + Object bTime = beamMap.get("time"); + Object Ttime = tvocMap.get("time"); + if (bTime.equals(Ttime)) { + beamMap.putAll(tvocMap); } } + } + + List<Map<String, Object>> list = new ArrayList<>(); + for (int i = 0; i < 24; i++) { + Map<String, Object> map = new HashMap<>(); + String tt = time + " " + (i + 1) + ":00:00"; + if ((i + 1) < 10) { + tt = time + " 0" + (i + 1) + ":00:00"; + } else if (i == 23) { + tt = sdf.format(end) + " 00:00:00"; + } + map.put("time", tt); + list.add(map); + } + + for (Map<String, Object> map1 : list) { + String time1 = map1.get("time").toString(); + for (Map<String, Object> map2 : beamList) { + if (time1.equals(map2.get("time"))) { + map1.putAll(map2); + } + } + + for (Map<String, Object> realMap : realList) { + if (time1.equals(realMap.get("time"))) { + map1.putAll(realMap); + } + } + //������6���������������(������) - Date endTime = sdf1.parse(rtime); + Date endTime = sdf1.parse(time1); cal.setTime(endTime); cal.add(Calendar.HOUR, -6); Date startTime = cal.getTime(); @@ -638,66 +663,36 @@ hashMap.put("end", endTime); Map<String, Object> precip6HourMap = realWeatherMapper.getPrecip6Hour(hashMap); if (precip6HourMap != null) { - realMap.put("precip6", precip6HourMap.get("precip6").toString()); + map1.put("precip6", precip6HourMap.get("precip6").toString()); } } - List<Map<String, Object>> list = new ArrayList<>(); - for (int i = 0; i < 24; i++) { - list.add(null); - } - - for (Map<String, Object> map : realWeatherList) { - Integer t1 = Integer.valueOf(map.get("time").toString().split(" ")[1].split(":")[0]); - if (t1 == 0) { - list.set(list.size() - 1, map); - } else { - list.set(t1 - 1, map); - } - } - - for (Map<String, Object> map : realAqilist) { - Integer t1 = Integer.valueOf(map.get("time").toString().split(" ")[1].split(":")[0]); - if (t1 == 0) { - Map<String, Object> map1 = list.get(list.size() - 1); - if (map1 == null) { - list.set(list.size() - 1, map); - } else { - map1.putAll(map); - list.set(list.size() - 1, map1); - } - } else { - Map<String, Object> map1 = list.get(t1 - 1); - if (map1 == null) { - list.set(t1 - 1, map); - } else { - map1.putAll(map); - list.set(t1 - 1, map1); + for (Map<String, Object> listMap : list) { + listMap.put("type", "������"); + listMap.put("city", name); + String time1 = listMap.get("time").toString(); + for (Map<String, Object> aqiMap : aqiList) { + if (time1.equals(aqiMap.get("time"))) { + listMap.putAll(aqiMap); } } - } - list.removeAll(Collections.singleton(null)); - for (Map<String, Object> map : list) { - map.put("type", "������"); - map.put("city", name); } List<Map<String, Object>> resultList = new ArrayList<>(); - - if (foreList.size() == 0) { + if (forecastList.size() == 0) { cal.setTime(selectTime); - for (long d = cal.getTimeInMillis(); d <= end.getTime(); + for (long d = cal.getTimeInMillis(); d < end.getTime(); cal.set(Calendar.HOUR_OF_DAY, cal.get(Calendar.HOUR_OF_DAY) + 1), d = cal.getTimeInMillis()) { Map<String, Object> hashMap = new LinkedHashMap<>(); hashMap.put("type", "������"); hashMap.put("city", name); hashMap.put("time", sdf1.format(d)); - foreList.add(hashMap); + forecastList.add(hashMap); } } - for (Map<String, Object> foreMap : foreList) { + for (Map<String, Object> foreMap : forecastList) { for (Map<String, Object> realMap : list) { if (foreMap.get("time").equals(realMap.get("time"))) { resultList.add(foreMap); @@ -705,8 +700,8 @@ } } } - for (int i = list.size(); i < foreList.size(); i++) { - Map<String, Object> map = foreList.get(i); + for (int i = list.size(); i < forecastList.size(); i++) { + Map<String, Object> map = forecastList.get(i); resultList.add(map); Map<String, Object> hashMap = new HashMap<>(); hashMap.put("time", map.get("time").toString()); @@ -744,9 +739,15 @@ map.put("COC", map.get("CO").toString()); map.remove("CO"); } - if ((!map.containsKey("PM25C")) && map.containsKey("PM2_5")) { - map.put("PM25C", map.get("PM2_5").toString().replace("\\.", "")); - map.remove("PM2_5"); + if ((!map.containsKey("PM25C")) && (map.containsKey("PM2_5") || map.containsKey("PM25"))) { + if (map.get("PM2_5") != null) { + map.put("PM25C", map.get("PM2_5").toString().replace("\\.", "")); + map.remove("PM2_5"); + } + if (map.get("PM25") != null) { + map.put("PM25C", map.get("PM25").toString().replace("\\.", "")); + map.remove("PM25"); + } } if ((!map.containsKey("PM10C")) && map.containsKey("PM10")) { map.put("PM10C", map.get("PM10").toString().replace("\\.", "")); @@ -798,20 +799,28 @@ if (rhour == nowHour) { Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap); - double v = value - Double.valueOf(sumO3Map.get("O3Sum").toString()); - resultMap.put("goodValue", v); + if (sumO3Map != null) { + double v = value - Double.valueOf(sumO3Map.get("O3Sum").toString()); + resultMap.put("goodValue", v); + } } else if (rhour == nowHour + 1) { Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap); - double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 2; - resultMap.put("goodValue", String.valueOf(Math.round(v))); + if (sumO3Map != null) { + double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 2; + resultMap.put("goodValue", String.valueOf(Math.round(v))); + } } else if (rhour == nowHour + 2) { Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap); - double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 3; - resultMap.put("goodValue", String.valueOf(Math.round(v))); + if (sumO3Map != null) { + double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 3; + resultMap.put("goodValue", String.valueOf(Math.round(v))); + } } else if (rhour == nowHour + 3) { Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap); - double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 4; - resultMap.put("goodValue", String.valueOf(Math.round(v))); + if (sumO3Map != null) { + double v = (value - Double.valueOf(sumO3Map.get("O3Sum").toString())) / 4; + resultMap.put("goodValue", String.valueOf(Math.round(v))); + } } } } @@ -819,19 +828,39 @@ //������������ Map<String, Object> geographyMap = shAreaMapper.getGeography(name); - for (Map<String, Object> map : resultList) { - double longitude = Double.valueOf(geographyMap.get("lng").toString()); - double latitude = Double.valueOf(geographyMap.get("lat").toString()); - map.put("longitude", df.format(longitude)); - map.put("latitude", df.format(latitude)); - if (geographyMap.get("altitude") != null) { - map.put("altitude", geographyMap.get("altitude").toString()); + if (geographyMap != null) { + for (Map<String, Object> map : resultList) { + if (geographyMap.get("lng") != null) { + double longitude = Double.valueOf(geographyMap.get("lng").toString()); + map.put("longitude", df.format(longitude)); + } + if (geographyMap.get("lat") != null) { + double latitude = Double.valueOf(geographyMap.get("lat").toString()); + map.put("latitude", df.format(latitude)); + } + if (geographyMap.get("altitude") != null) { + map.put("altitude", geographyMap.get("altitude").toString()); + } + if (geographyMap.get("vegetation") != null) { + map.put("vegetation", geographyMap.get("vegetation").toString()); + } + if (geographyMap.get("river") != null) { + map.put("river", geographyMap.get("river").toString()); + } } - if (geographyMap.get("vegetation") != null) { - map.put("vegetation", geographyMap.get("vegetation").toString()); - } - if (geographyMap.get("river") != null) { - map.put("river", geographyMap.get("river").toString()); + } + + for (int i = 0; i < resultList.size(); i = i + 2) { + Map<String, Object> foreMap = resultList.get(i); + Map<String, Object> realMap = resultList.get(i + 1); + if (foreMap.get("O3C") != null && realMap.get("O3C") != null) { + Double foreO3 = Double.valueOf(foreMap.get("O3C").toString()); + Double realO3 = Double.valueOf(realMap.get("O3C").toString()); + int round = (int) Math.round((realO3 - foreO3) / realO3 * 100); + if (round < 0) { + round = -round; + } + realMap.put("errorRate", round + "%"); } } return resultList; -- Gitblit v1.8.0