大屏O3预测与实测对比更新

jinpengyong

2020-11-19 e4478db5cb30396bf862fdab12ffecbc574a72e6

 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;