From e36d33b5789cc098898af42fdce6cab057db3cc6 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Thu, 06 Aug 2020 16:33:57 +0800 Subject: [PATCH] update --- src/main/java/com/moral/service/impl/WeatherServiceImpl.java | 547 ++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 441 insertions(+), 106 deletions(-) diff --git a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java index 8470077..3eae89e 100644 --- a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java +++ b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java @@ -5,9 +5,9 @@ import java.util.ArrayList; import java.util.Calendar; import java.util.Collection; +import java.util.Collections; import java.util.Date; import java.util.HashMap; -import java.util.LinkedHashMap; import java.util.List; import java.util.Map; @@ -18,18 +18,25 @@ import org.springframework.util.ObjectUtils; import org.springframework.web.client.RestTemplate; +import com.alibaba.fastjson.JSONObject; import com.moral.common.util.Dom4jUtils; import com.moral.common.util.ValidateUtil; import com.moral.entity.Area; import com.moral.entity.AreaNames; import com.moral.entity.City; +import com.moral.entity.Device; import com.moral.entity.MonitorPoint; import com.moral.entity.Organization; +import com.moral.entity.Province; import com.moral.mapper.AreaMapper; import com.moral.mapper.CityMapper; +import com.moral.mapper.DeviceMapper; +import com.moral.mapper.ForecastWeatherMapper; import com.moral.mapper.HangzhouAqiMapper; +import com.moral.mapper.HistoryHourlyMapper; import com.moral.mapper.MonitorPointMapper; import com.moral.mapper.ProvinceMapper; +import com.moral.mapper.RealWeatherMapper; import com.moral.service.OrganizationService; import com.moral.service.WeatherService; @@ -46,6 +53,9 @@ private MonitorPointMapper monitorPointMapper; @Resource + private ForecastWeatherMapper forecastWeatherMapper; + + @Resource private AreaMapper areaMapper; @Resource @@ -53,6 +63,15 @@ @Resource private ProvinceMapper provinceMapper; + + @Resource + private RealWeatherMapper realWeatherMapper; + + @Resource + private DeviceMapper deviceMapper; + + @Resource + private HistoryHourlyMapper historyHourlyMapper; @Override public Map<String, Object> getWeatherDataByRegion(Map<String, Object> parameters) { @@ -156,125 +175,441 @@ } @Override - public List<Map<String, Object>> getNextDayWeatherDataByRegion(Map<String, Object> parameters) throws ParseException { + public List<Map<String, Object>> getForecastAndReal(Map<String, Object> parameters) throws ParseException { String monitorPointId = parameters.get("monitorPointId").toString(); - MonitorPoint monitorPoint = monitorPointMapper.selectByPrimaryKey(Integer.valueOf(monitorPointId)); - Integer cityCode = monitorPoint.getCityCode(); - Integer areaCode = monitorPoint.getAreaCode(); - String name1 = ""; - String parentName = ""; - if (areaCode != null) { - Area area = areaMapper.selectByPrimaryKey(areaCode); - name1 = area.getAreaName(); - City city = cityMapper.selectByPrimaryKey(area.getCityCode()); - parentName = city.getCityName(); - if ("���������".equals(area.getAreaName())) { - name1 = parentName; - parentName = provinceMapper.selectByPrimaryKey(city.getProvinceCode()).getProvinceName(); - } - } else { - City city = cityMapper.selectByPrimaryKey(cityCode); - name1 = city.getCityName(); - parentName = provinceMapper.selectByPrimaryKey(city.getProvinceCode()).getProvinceName(); - } - List<Element> elements = Dom4jUtils.readDocument(); - String cityID = "101190404"; - for (Element element : elements) { - String name2 = element.element("name").getText(); - if (name1.equals(name2)) { - cityID = element.element("Fweathercn").getText(); - break; - } - if (name2.endsWith(name1)) { - if (name2.startsWith(parentName)) { - cityID = element.element("Fweathercn").getText(); - break; - } - } - } - RestTemplate restTemplate = new RestTemplate(); + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + String time = parameters.get("time").toString() + " 00:00:00"; Calendar c = Calendar.getInstance(); - SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); - SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH"); - String now = sdf.format(c.getTime()); - String selectTime = parameters.get("time").toString(); - Date t1 = sdf.parse(selectTime); - Date t2 = sdf.parse(now); + c.setTime(sdf.parse(time)); + c.add(Calendar.HOUR_OF_DAY, 1); + time = sdf.format(c.getTime()); + c.add(Calendar.DAY_OF_MONTH, 1); + String nextDay = sdf.format(c.getTime()); + parameters.put("start", sdf.parse(time)); + parameters.put("end", sdf.parse(nextDay)); + List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecastHour(parameters); + MonitorPoint monitorPoint = monitorPointMapper.selectByPrimaryKey(Integer.valueOf(monitorPointId)); + parameters.put("areaCode", monitorPoint.getAreaCode()); + String sensors = "O3C"; + String sensor1 = "O3"; + parameters.put("sensors", sensors); + parameters.put("sensors1", sensor1); + parameters.put("sensors2", sensor1); + List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters); + if (aqiList.size() == 0) { + parameters.put("areaCode", monitorPoint.getCityCode()); + aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters); + } + for (Map<String, Object> map : aqiList) { + String O3 = map.get("O3").toString().replace("\"", ""); + map.put("O3", O3); + } + List<Map<String, Object>> resultList = new ArrayList<>(); - if (t1.getTime() > t2.getTime()) { - parameters.put("now", now); - Map<String, Object> map = restTemplate.getForObject("https://yiketianqi.com/api?version=v9&appid=68884517&appsecret=St9sFnvi&cityid={1}", Map.class, cityID); - ArrayList<Map<String, Object>> dataList = (ArrayList<Map<String, Object>>) map.get("data"); - ArrayList<Map<String, Object>> arrayList = new ArrayList<>(); - String start = parameters.get("now").toString(); - String end = parameters.get("time").toString(); - for (Map<String, Object> dataMap : dataList) { - String date = dataMap.get("date").toString(); - ArrayList<Map<String, Object>> list = (ArrayList<Map<String, Object>>) dataMap.get("hours"); - if (date.equals(start)) { - for (int i = list.size() - 7; i < list.size(); i++) { - Map<String, Object> resultMap = list.get(i); - arrayList.add(resultMap); - } + if (forecastList.size() == 0 && aqiList.size() == 0) { + return new ArrayList<>(); + } else if (forecastList.size() == 0) { + for (Map<String, Object> aqiMap : aqiList) { + Map<String, Object> map = new HashMap<>(); + List<String> values = new ArrayList<>(); + String hour = aqiMap.get("time").toString().split(" ")[1].split(":")[0]; + if (hour.equals("00")) { + hour = "24"; } - if (date.equals(end)) { - for (int i = 0; i < 17; i++) { - Map<String, Object> resultMap = list.get(i); - arrayList.add(resultMap); - } - } + map.put("time", Integer.valueOf(hour)); + values.add(""); + values.add(aqiMap.get(sensor1).toString()); + map.put("values", values); + resultList.add(map); } - for (Map<String, Object> resultMap : arrayList) { - Map<String, Object> hashMap = new LinkedHashMap<>(); + } else if (aqiList.size() == 0) { + for (Map<String, Object> forecastMap : forecastList) { + Map<String, Object> map = new HashMap<>(); List<String> values = new ArrayList<>(); - String hour = resultMap.get("hours").toString().replaceAll("[\u4e00-\u9fa5]+", ""); - values.add(resultMap.get("tem").toString()); - values.add(""); - hashMap.put("values", values); - hashMap.put("time", Integer.valueOf(hour)); - if (Integer.valueOf(hour) == 0) { - hashMap.put("time", 24); + String hour = forecastMap.get("time").toString().split(" ")[1].split(":")[0]; + if (hour.equals("00")) { + hour = "24"; } - resultList.add(hashMap); + map.put("time", Integer.valueOf(hour)); + if (forecastMap.get("result") != null) { + values.add(forecastMap.get("result").toString().replace("\"", "")); + } else { + values.add(""); + } + values.add(""); + map.put("values", values); + resultList.add(map); } } else { - parameters.put("start", selectTime); - c.setTime(sdf.parse(selectTime)); - c.add(Calendar.DAY_OF_MONTH, 1); - c.add(Calendar.HOUR_OF_DAY, 1); - String end = sdf1.format(c.getTime()); - parameters.put("end", end); - parameters.put("sensors", "O3C"); - parameters.put("sensors1", "O3"); - parameters.put("sensors2", parameters.get("sensors1").toString()); - List<Map<String, Object>> areaList = new ArrayList<>(); - if (areaCode == null) { - parameters.put("areaCode", cityCode); - areaList = hangzhouAqiMapper.getAreaAvgDataByAreaCode(parameters); - } else { - parameters.put("areaCode", areaCode); - areaList = hangzhouAqiMapper.getAreaAvgDataByAreaCode(parameters); - if (areaList.size() == 0) { - parameters.put("areaCode", cityCode); - areaList = hangzhouAqiMapper.getAreaAvgDataByAreaCode(parameters); - } - } - areaList.remove(0); - for (Map<String, Object> areaMap : areaList) { - Map<String, Object> hashMap = new LinkedHashMap<>(); + for (Map<String, Object> forecastMap : forecastList) { + Map<String, Object> map = new HashMap<>(); List<String> values = new ArrayList<>(); - values.add(""); - values.add(areaMap.get("O3").toString()); - hashMap.put("values", values); - String hour = areaMap.get("time").toString().split(" ")[1]; - hashMap.put("time", Integer.valueOf(hour)); - if (Integer.valueOf(hour) == 0) { - hashMap.put("time", 24); + String hour = forecastMap.get("time").toString().split(" ")[1].split(":")[0]; + if (hour.equals("00")) { + hour = "24"; } - resultList.add(hashMap); + map.put("time", Integer.valueOf(hour)); + if (forecastMap.get("result") != null) { + values.add(forecastMap.get("result").toString().replace("\"", "")); + } else { + values.add(""); + } + for (Map<String, Object> aqiMap : aqiList) { + if (forecastMap.get("time").equals(aqiMap.get("time"))) { + values.add(aqiMap.get(sensor1).toString()); + } + } + map.put("values", values); + resultList.add(map); + } + } + for (Map<String, Object> resultMap : resultList) { + ArrayList<String> values = (ArrayList<String>) resultMap.get("values"); + if (values.size() == 1) { + values.add(""); } } return resultList; } + + @Override + public List<Map<String, Object>> getWeatherData(Map<String, Object> parameters) throws ParseException { + String cityName = parameters.get("city").toString(); + Area area = areaMapper.getAreaByName(cityName); + MonitorPoint monitorPoint; + Integer areaCode = 0; + Integer cityCode = 0; + if (area == null) { + City city = cityMapper.getCityByName(cityName); + if (city == null) { + Province province = provinceMapper.getProvinceByName(cityName); + Integer provinceCode = province.getProvinceCode(); + monitorPoint = monitorPointMapper.getFirstMonitorPointByProvinceCode(provinceCode); + parameters.put("areaCode", provinceCode); + parameters.put("city", province.getProvinceName()); + } else { + cityCode = city.getCityCode(); + monitorPoint = monitorPointMapper.getFirstMonitorPointByCityCode(cityCode); + parameters.put("areaCode", cityCode); + parameters.put("city", city.getCityName()); + } + } else { + areaCode = area.getAreaCode(); + monitorPoint = monitorPointMapper.getFirstMonitorPointByAreaCode(areaCode); + cityCode = area.getCityCode(); + parameters.put("areaCode", areaCode); + parameters.put("city", area.getAreaName()); + } + if (monitorPoint == null) { + return new ArrayList<>(); + } + parameters.put("monitorPointId", monitorPoint.getId()); + String time = parameters.get("time").toString(); + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); + SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + Date now = new Date(); + Date selectTime = sdf1.parse(time + " 00:00:00"); + Calendar c1 = Calendar.getInstance(); + c1.setTime(selectTime); + c1.add(Calendar.DAY_OF_MONTH, -1); + Date beforeDay = c1.getTime(); + String format = sdf.format(beforeDay); + Calendar c = Calendar.getInstance(); + c.setTime(sdf.parse(time)); + c.add(Calendar.HOUR_OF_DAY, 1); + Date start = c.getTime(); + c.add(Calendar.DAY_OF_MONTH, 1); + Date end = c.getTime(); + parameters.put("start", start); + parameters.put("end", end); + List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecast(parameters); + List<Map<String, Object>> foreList = new ArrayList<>(); + for (Map<String, Object> map : forecastList) { + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("time", map.get("time").toString()); + hashMap.put("type", "������"); + hashMap.put("TVOC", ""); + hashMap.put("altitude", ""); + hashMap.put("vegetation", ""); + hashMap.put("AQI", ""); + hashMap.put("SO2C", ""); + hashMap.put("NO2C", ""); + hashMap.put("COC", ""); + hashMap.put("O3C", ""); + hashMap.put("PM25C", ""); + hashMap.put("PM10C", ""); + hashMap.put("city", parameters.get("city").toString()); + + if (selectTime.getTime() <= now.getTime()) { + hashMap.put("fxTime", (format + " 15:00").substring(5, 16)); + } else { + String s = sdf1.format(now).split(" ")[1].split(":")[0]; + Integer hour = Integer.valueOf(s); + if (hour > 15) { + hashMap.put("fxTime", (format + " 15:00").substring(5, 16)); + } else if (hour > 7 && hour < 15) { + hashMap.put("fxTime", (format + " 07:00").substring(5, 16)); + } + } + Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(map.get("json").toString()); + hashMap.putAll(jsonMap); + foreList.add(hashMap); + } + + for (Map<String, Object> foreMap : foreList) { + String ftime = foreMap.get("time").toString(); + Calendar calendar = Calendar.getInstance(); + Date endTime = sdf1.parse(ftime); + calendar.setTime(endTime); + calendar.add(Calendar.HOUR, -6); + Date startTime = calendar.getTime(); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString())); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + hashMap.put("monitorPointId", Integer.valueOf(parameters.get("monitorPointId").toString())); + Map<String, Object> precip6HourMap = forecastWeatherMapper.getPrecip6Hour(hashMap); + if (precip6HourMap != null) { + foreMap.put("precip6", precip6HourMap.get("precip6").toString()); + } + } + + List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters); + if (aqiList.size() == 0) { + parameters.put("areaCode", cityCode); + aqiList = hangzhouAqiMapper.getAqi(parameters); + } + + 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()); + hashMap.putAll(jsonMap); + hashMap.put("city", parameters.get("city").toString()); + realAqilist.add(hashMap); + } + + for (Map<String, Object> map : realAqilist) { + Date endTime = sdf1.parse(map.get("time").toString()); + c.setTime(endTime); + c.add(Calendar.HOUR, -8); + Date startTime = c.getTime(); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString())); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + Map<String, Object> O3Map = hangzhouAqiMapper.getAvgO3EightHours(hashMap); + map.put("O3_8H", O3Map.get("O3_8H").toString()); + if (O3Map.get("O3C_8H") != null) { + map.put("O3C_8H", O3Map.get("O3C_8H").toString()); + } + } + + //������ + String code = parameters.get("areaCode").toString(); + Map<String, Object> params = new HashMap<>(); + if (code.endsWith("00")) { + params.put("cityCode", Integer.valueOf(code)); + } else { + params.put("areaCode", Integer.valueOf(code)); + } + + List<MonitorPoint> monitorList = monitorPointMapper.getMonitorList(params); + + List<Integer> pointList = new ArrayList<>(); + for (MonitorPoint point : monitorList) { + Integer pointId = point.getId(); + pointList.add(pointId); + } + + List<Device> deviceList = deviceMapper.getDeviceListByMonitorPointIds(pointList); + List<String> macList = new ArrayList<>(); + List<Map<String, Object>> beamList = new ArrayList<>(); + if (deviceList.size() != 0) { + for (Device device : deviceList) { + String mac = device.getMac(); + macList.add(mac); + } + + parameters.put("macs", macList); + beamList = historyHourlyMapper.getBeamByMacs(parameters); + } + + + List<Map<String, Object>> realList = realWeatherMapper.getRealWeather(parameters); + 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 = (Map<String, Object>) JSONObject.parse(realMap.get("json").toString()); + hashMap.putAll(jsonMap); + hashMap.put("city", parameters.get("city").toString()); + realWeatherList.add(hashMap); + } + + for (Map<String, Object> realMap : realWeatherList) { + String rtime = realMap.get("time").toString(); + for (Map<String, Object> beamMap : beamList) { + String btime = beamMap.get("time").toString(); + if (btime.equals(rtime)) { + realMap.put("beam", beamMap.get("beam").toString().split("\\.")[0]); + } + } + Calendar calendar = Calendar.getInstance(); + Date endTime = sdf1.parse(rtime); + calendar.setTime(endTime); + calendar.add(Calendar.HOUR, -6); + Date startTime = calendar.getTime(); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString())); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + hashMap.put("monitorPointId", Integer.valueOf(parameters.get("monitorPointId").toString())); + Map<String, Object> precip6HourMap = realWeatherMapper.getPrecip6Hour(hashMap); + realMap.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); + } + } + } + + + list.removeAll(Collections.singleton(null)); + + + for (Map<String, Object> map : list) { + map.put("type", "������"); + map.put("city", parameters.get("city").toString()); + } + + List<Map<String, Object>> resultList = new ArrayList<>(); + + for (Map<String, Object> foreMap : foreList) { + for (Map<String, Object> realMap : list) { + if (foreMap.get("time").equals(realMap.get("time"))) { + resultList.add(foreMap); + resultList.add(realMap); + } + } + } + + for (int i = list.size(); i < foreList.size(); i++) { + Map<String, Object> map = foreList.get(i); + resultList.add(map); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("time", map.get("time").toString()); + hashMap.put("type", "������"); + hashMap.put("city", parameters.get("city").toString()); + resultList.add(hashMap); + } + + for (Map<String, Object> map : resultList) { + String date = map.get("time").toString().substring(0, 16); + map.put("time", date); + if (map.get("AQI") != null) { + String aqi = map.get("AQI").toString().split("\\.")[0]; + map.put("AQI", aqi); + } + if (map.get("precip") != null) { + String aqi = map.get("precip").toString(); + if (aqi.equals("0.0")) { + map.put("precip", ""); + } + } + if (map.get("precip6") != null) { + String aqi = map.get("precip6").toString(); + if (aqi.equals("0.0")) { + map.put("precip6", ""); + } + } + } + return resultList; + } + + @Override + public void updateForecastWeather(Map<String, Object> parameters) { + List<Integer> list = new ArrayList<>(); + List<Map<String, Object>> resultList = new ArrayList<>(); + for (int i = 0; i < 48; i++) { + list.add(i); + resultList.add(null); + } + for (Integer s : list) { + Map<String, Object> map = new HashMap<>(); + for (String key : parameters.keySet()) { + String replace = key.split("\\[")[0]; + if (replace.equals(s + "")) { + String ss = key.split("\\[")[1].replace("]", ""); + map.put(ss, parameters.get(key).toString()); + } + } + resultList.set(s, map); + } + for (Map<String, Object> map : resultList) { + if (map.get("type").equals("������")) { + String time = map.get("time").toString() + ":00"; + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("time", time); + String city = map.get("city").toString(); + Area area = areaMapper.getAreaByName(city); + Map<String, Object> idMap = new HashMap<>(); + if (area == null) { + Integer cityCode = cityMapper.getCityByName(city).getCityCode(); + idMap.put("cityCode", cityCode); + } else { + Integer areaCode = area.getAreaCode(); + idMap.put("areaCode", areaCode); + } + + List<MonitorPoint> monitorList = monitorPointMapper.getMonitorList(idMap); + Map<String, Object> jsonMap = new HashMap<>(); + for (String key : map.keySet()) { + if (!key.equals("city") && !key.equals("time") && !key.equals("type") && !key.equals("fxTime")) { + String value = map.get(key).toString(); + jsonMap.put(key, value); + } + } + + String json = JSONObject.toJSONString(jsonMap); + hashMap.put("json", json); + for (MonitorPoint monitorPoint : monitorList) { + hashMap.put("monitorPointId", monitorPoint.getId()); + forecastWeatherMapper.updateForecastWeather(hashMap); + } + } + } + } } -- Gitblit v1.8.0