kaiyu
2020-11-24 1d7e1b771160dd8b7f25765e402ce25cac676641
src/main/java/com/moral/service/impl/WeatherServiceImpl.java
@@ -184,6 +184,50 @@
    @Override
    public List<Map<String, Object>> getForecastAndReal(Map<String, Object> parameters) throws ParseException {
        ArrayList<String> sensorKeys = (ArrayList<String>) parameters.get("sensorKeys");
        List<Map<String, Object>> resultList = new ArrayList<>();
        for (int i = 0; i < 24; i++) {
            Map<String, Object> map = new HashMap<>();
            List<String> arrayList = new ArrayList<>();
            map.put("values", arrayList);
            map.put("time", i + 1);
            resultList.add(map);
        }
        for (String sensorKey : sensorKeys) {
            parameters.put("sensorKey", sensorKey);
            List<Map<String, Object>> list = forecastAndReal(parameters);
            for (Map<String, Object> map : list) {
                Object time = map.get("time");
                ArrayList<String> values = (ArrayList<String>) map.get("values");
                for (Map<String, Object> resultMap : resultList) {
                    if (time.equals(resultMap.get("time"))) {
                        ArrayList<String> resultValues = (ArrayList<String>) resultMap.get("values");
                        resultValues.addAll(values);
                        resultMap.put("values", resultValues);
                    }
                }
            }
        }
        return resultList;
    }
    public List<Map<String, Object>> forecastAndReal(Map<String, Object> parameters) throws ParseException {
        Object sensorKey = parameters.remove("sensorKey");
        String sensor1;
        String sensor2;
        if ("e1".equals(sensorKey)) {
            sensor1 = "PM25C";
            sensor2 = "PM2_5";
        } else if ("e2".equals(sensorKey)) {
            sensor1 = "PM10C";
            sensor2 = "PM10";
        } else {
            sensor1 = "O3C";
            sensor2 = "O3";
        }
        parameters.put("sensor1", sensor1);
        parameters.put("sensor2", sensor2);
        parameters.put("typeFormat", "%Y-%m-%d %H:%i:%s");
        String monitorPointId = parameters.get("monitorPointId").toString();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
@@ -197,31 +241,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(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());
                    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(sensor2).toString().replace("\"", ""));
            map.put(sensor2, String.valueOf(s));
        }
        List<Map<String, Object>> resultList = new ArrayList<>();
@@ -237,7 +290,7 @@
                }
                map.put("time", Integer.valueOf(hour));
                values.add("");
                values.add(aqiMap.get("O3").toString());
                values.add(aqiMap.get(sensor2).toString());
                map.put("values", values);
                resultList.add(map);
            }
@@ -251,8 +304,8 @@
                    hour = "24";
                }
                map.put("time", Integer.valueOf(hour));
                if (forecastMap.get("O3") != null) {
                    values.add(forecastMap.get("O3").toString().replace("\"", ""));
                if (forecastMap.get(sensor2) != null) {
                    values.add(forecastMap.get(sensor2).toString().replace("\"", ""));
                } else {
                    values.add("");
                }
@@ -269,14 +322,14 @@
                    hour = "24";
                }
                map.put("time", Integer.valueOf(hour));
                if (forecastMap.get("O3") != null) {
                    values.add(forecastMap.get("O3").toString().replace("\"", ""));
                if (forecastMap.get(sensor2) != null) {
                    values.add(forecastMap.get(sensor2).toString().replace("\"", ""));
                } else {
                    values.add("");
                }
                for (Map<String, Object> aqiMap : aqiList) {
                    if (forecastMap.get("time").equals(aqiMap.get("time"))) {
                        values.add(aqiMap.get("O3").toString());
                        values.add(aqiMap.get(sensor2).toString());
                    }
                }
                map.put("values", values);
@@ -372,6 +425,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 +465,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 +475,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 +517,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);
@@ -503,11 +556,10 @@
        }
        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)) {
@@ -520,16 +572,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);
@@ -538,15 +585,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<>();
@@ -572,10 +620,10 @@
        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,22 +646,19 @@
                }
            }
        }
        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;
            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", "实测");
        }
        //Tvoc,光照合并
        //TVOC,光照合并
        for (Map<String, Object> beamMap : beamList) {
            for (Map<String, Object> tvocMap : tvocList) {
                Object bTime = beamMap.get("time");
@@ -645,7 +690,7 @@
                }
            }
            for (Map<String, Object> realMap : realWeatherList) {
            for (Map<String, Object> realMap : realList) {
                if (time1.equals(realMap.get("time"))) {
                    map1.putAll(realMap);
                }
@@ -670,7 +715,7 @@
            listMap.put("type", "实测");
            listMap.put("city", name);
            String time1 = listMap.get("time").toString();
            for (Map<String, Object> aqiMap : realAqilist) {
            for (Map<String, Object> aqiMap : aqiList) {
                if (time1.equals(aqiMap.get("time"))) {
                    listMap.putAll(aqiMap);
                }
@@ -678,7 +723,7 @@
        }
        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();
                 cal.set(Calendar.HOUR_OF_DAY, cal.get(Calendar.HOUR_OF_DAY) + 1),
@@ -687,11 +732,11 @@
                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);
@@ -699,8 +744,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());