From 11dc24b3492b034a4c40e122d08b3ceeeaa57cb6 Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Mon, 24 Aug 2020 16:32:56 +0800 Subject: [PATCH] 根据城市名,获取sh_area表中经纬度并显示 --- src/main/java/com/moral/service/impl/WeatherServiceImpl.java | 489 ++++++++++++++++++++++++++++++++++++++++++++---------- 1 files changed, 396 insertions(+), 93 deletions(-) diff --git a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java index 62d3544..d7bef3b 100644 --- a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java +++ b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java @@ -1,5 +1,7 @@ package com.moral.service.impl; +import java.math.BigDecimal; +import java.text.DecimalFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; @@ -24,16 +26,20 @@ 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.mapper.ShAreaMapper; import com.moral.service.OrganizationService; import com.moral.service.WeatherService; @@ -63,6 +69,15 @@ @Resource private RealWeatherMapper realWeatherMapper; + + @Resource + private DeviceMapper deviceMapper; + + @Resource + private HistoryHourlyMapper historyHourlyMapper; + + @Resource + private ShAreaMapper shAreaMapper; @Override public Map<String, Object> getWeatherDataByRegion(Map<String, Object> parameters) { @@ -167,6 +182,7 @@ @Override public List<Map<String, Object>> getForecastAndReal(Map<String, Object> parameters) throws ParseException { + 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"); String time = parameters.get("time").toString() + " 00:00:00"; @@ -178,21 +194,19 @@ String nextDay = sdf.format(c.getTime()); parameters.put("start", sdf.parse(time)); parameters.put("end", sdf.parse(nextDay)); + MonitorPoint monitorPoint = monitorPointMapper.selectByPrimaryKey(Integer.valueOf(monitorPointId)); + if (monitorPoint.getAreaCode() == null) { + parameters.put("cityCode", monitorPoint.getCityCode()); + } else { + parameters.put("cityCode", monitorPoint.getAreaCode()); + } + List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters); 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()); + parameters.put("cityCode", monitorPoint.getCityCode()); aqiList = hangzhouAqiMapper.getAqiDataByAreaCode(parameters); } - for (Map<String, Object> map : aqiList) { String O3 = map.get("O3").toString().replace("\"", ""); map.put("O3", O3); @@ -211,7 +225,7 @@ } map.put("time", Integer.valueOf(hour)); values.add(""); - values.add(aqiMap.get(sensor1).toString()); + values.add(aqiMap.get("O3").toString()); map.put("values", values); resultList.add(map); } @@ -225,7 +239,11 @@ hour = "24"; } map.put("time", Integer.valueOf(hour)); - values.add(forecastMap.get("result").toString().replace("\"", "")); + if (forecastMap.get("O3") != null) { + values.add(forecastMap.get("O3").toString().replace("\"", "")); + } else { + values.add(""); + } values.add(""); map.put("values", values); resultList.add(map); @@ -239,10 +257,14 @@ hour = "24"; } map.put("time", Integer.valueOf(hour)); - values.add(forecastMap.get("result").toString().replace("\"", "")); + if (forecastMap.get("O3") != null) { + values.add(forecastMap.get("O3").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()); + values.add(aqiMap.get("O3").toString()); } } map.put("values", values); @@ -260,94 +282,219 @@ @Override public List<Map<String, Object>> getWeatherData(Map<String, Object> parameters) throws ParseException { + parameters.put("typeFormat", "%Y-%m-%d %H:%i:%s"); String cityName = parameters.get("city").toString(); Area area = areaMapper.getAreaByName(cityName); - MonitorPoint monitorPoint; - Integer areaCode = 0; - Integer cityCode = 0; + Integer code = 0; + String name = ""; 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()); + code = province.getProvinceCode(); + name = province.getProvinceName(); } else { - cityCode = city.getCityCode(); - monitorPoint = monitorPointMapper.getFirstMonitorPointByCityCode(cityCode); - parameters.put("areaCode", cityCode); - parameters.put("city", city.getCityName()); + code = city.getCityCode(); + name = city.getCityName(); } } else { - areaCode = area.getAreaCode(); - monitorPoint = monitorPointMapper.getFirstMonitorPointByAreaCode(areaCode); - cityCode = area.getCityCode(); - parameters.put("areaCode", areaCode); - parameters.put("city", area.getAreaName()); + code = area.getAreaCode(); + name = area.getAreaName(); } - if (monitorPoint == null) { - return new ArrayList<>(); - } - parameters.put("monitorPointId", monitorPoint.getId()); + + parameters.put("cityCode", code); + parameters.put("name", name); String time = parameters.get("time").toString(); SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); - 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); + SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + Date now = new Date(); + Date selectTime = sdf1.parse(time + " 01:00:00"); + Calendar cal = Calendar.getInstance(); + cal.setTime(selectTime); + cal.add(Calendar.DAY_OF_MONTH, 1); + Date end = cal.getTime(); + cal.setTime(sdf.parse(time)); + Date time1 = cal.getTime(); + cal.add(Calendar.DAY_OF_MONTH, -1); + String beforeDay = sdf.format(cal.getTime()); + parameters.put("start", selectTime); parameters.put("end", end); + Integer fcode = 0; List<Map<String, Object>> forecastList = forecastWeatherMapper.getForecast(parameters); + if (forecastList.size() == 0) { + List<Area> areaList = areaMapper.getAreaByCityCode(code); + for (Area area1 : areaList) { + if (area1 != null) { + parameters.put("cityCode", area1.getAreaCode()); + fcode = area1.getAreaCode(); + forecastList = forecastWeatherMapper.getForecast(parameters); + if (forecastList.size() != 0) { + break; + } + } + } + } else { + fcode = Integer.valueOf(parameters.get("cityCode").toString()); + } List<Map<String, Object>> foreList = new ArrayList<>(); - - for (Map<String, Object> map : forecastList) { + for (Map<String, Object> forecastMap : forecastList) { Map<String, Object> hashMap = new HashMap<>(); - hashMap.put("time", map.get("time").toString()); + String ftime = forecastMap.get("time").toString(); + hashMap.put("time", ftime); hashMap.put("type", "������"); - hashMap.put("city", parameters.get("city").toString()); - Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(map.get("json").toString()); + hashMap.put("TVOC", ""); + hashMap.put("altitude", ""); + hashMap.put("vegetation", ""); + hashMap.put("river", ""); + hashMap.put("AQI", ""); + hashMap.put("SO2C", ""); + hashMap.put("NO2C", ""); + hashMap.put("COC", ""); + if (forecastMap.get("O3C") == null) { + hashMap.put("O3C", ""); + } + hashMap.put("PM25C", ""); + hashMap.put("PM10C", ""); + hashMap.put("city", parameters.get("name").toString()); + hashMap.put("code", fcode); + if (sdf.parse(time).getTime() <= now.getTime()) { + hashMap.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)); + } else if (now.getTime() > date1.getTime() && (now.getTime() < date2.getTime() || now.getTime() == date2.getTime())) { + hashMap.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); } - List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters); - if (aqiList.size() == 0) { - parameters.put("areaCode", cityCode); - aqiList = hangzhouAqiMapper.getAqi(parameters); + //������6��������������� + for (Map<String, Object> foreMap : foreList) { + String ftime = foreMap.get("time").toString(); + Date endTime = sdf1.parse(ftime); + cal.setTime(endTime); + cal.add(Calendar.HOUR, -6); + Date startTime = cal.getTime(); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString())); + Map<String, Object> precip6HourMap = forecastWeatherMapper.getPrecip6Hour(hashMap); + foreMap.put("precip6", ""); + if (precip6HourMap != null) { + foreMap.put("precip6", precip6HourMap.get("precip6").toString()); + } } + //������O3C_8H + for (Map<String, Object> map : foreList) { + Date endTime = sdf1.parse(map.get("time").toString()); + cal.setTime(endTime); + cal.add(Calendar.HOUR, -8); + Date startTime = cal.getTime(); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString())); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + Map<String, Object> O3Map = forecastWeatherMapper.getO38Hours(hashMap); + if (O3Map != null) { + Double O3C_8H = Double.valueOf(O3Map.get("O3C_8H").toString()); + map.put("O3C_8H", String.valueOf(Math.round(O3C_8H))); + } + } + + String ac = parameters.get("cityCode").toString(); + List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters); + if (aqiList.size() == 0) { + parameters.put("cityCode", code); + aqiList = hangzhouAqiMapper.getAqi(parameters); + if (aqiList.size() == 0) { + List<Area> areaList = areaMapper.getAreaByCityCode(code); + for (Area area1 : areaList) { + if (area1 != null) { + parameters.put("cityCode", area1.getAreaCode()); + aqiList = hangzhouAqiMapper.getAqi(parameters); + if (aqiList.size() != 0) { + break; + } + } + } + } + } + DecimalFormat df = 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()); hashMap.putAll(jsonMap); - hashMap.put("city", parameters.get("city").toString()); + hashMap.put("city", parameters.get("name").toString()); realAqilist.add(hashMap); } - SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); - 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(); + String rtime = map.get("time").toString(); + Date endTime = sdf1.parse(rtime); + cal.setTime(endTime); + cal.add(Calendar.HOUR, -8); + Date startTime = cal.getTime(); Map<String, Object> hashMap = new HashMap<>(); - hashMap.put("areaCode", Integer.valueOf(parameters.get("areaCode").toString())); + hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString())); hashMap.put("start", startTime); hashMap.put("end", endTime); Map<String, Object> O3Map = hangzhouAqiMapper.getAvgO3EightHours(hashMap); - map.put("O3������8������", O3Map.get("O3������8������").toString()); - if (O3Map.get("O3������8������") != null) { - map.put("O3������8������", O3Map.get("O3������8������").toString()); - } + map.put("O3C_8H", O3Map.get("O3C_8H").toString()); } + //������ + Map<String, Object> params = new HashMap<>(); + if (ac.endsWith("00")) { + params.put("cityCode", Integer.valueOf(ac)); + } else { + params.put("areaCode", Integer.valueOf(ac)); + } + 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<String> macList1 = new ArrayList<>(); + List<Map<String, Object>> beamList = new ArrayList<>(); + List<Map<String, Object>> tvocList = new ArrayList<>(); + if (deviceList.size() != 0) { + for (Device device : deviceList) { + macList.add(device.getMac()); + } + parameters.put("macs", macList); + beamList = historyHourlyMapper.getBeamByMacs(parameters); + Map<String, Object> map = new HashMap<>(); + if (name.equals("���������")) { + List<Integer> list = new ArrayList<>(); + list.add(48); + List<Device> pointIds = deviceMapper.getDeviceListByMonitorPointIds(list); + for (Device device : pointIds) { + if (device.getId() != 1075) { + macList1.add(device.getMac()); + } + } + } else { + macList1 = macList; + } + map.put("macs", macList1); + map.put("start", parameters.get("start")); + map.put("end", parameters.get("end")); + tvocList = historyHourlyMapper.getTVOCByMacs(map); + } List<Map<String, Object>> realList = realWeatherMapper.getRealWeather(parameters); List<Map<String, Object>> realWeatherList = new ArrayList<>(); for (Map<String, Object> realMap : realList) { @@ -355,8 +502,44 @@ 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()); + hashMap.put("city", parameters.get("name").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", Math.floor((Double) beamMap.get("beam"))); + } + } + + Date endTime = sdf1.parse(rtime); + cal.setTime(endTime); + cal.add(Calendar.HOUR, -6); + Date startTime = cal.getTime(); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString())); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + + Map<String, Object> precip6HourMap = realWeatherMapper.getPrecip6Hour(hashMap); + + if (precip6HourMap != null) { + realMap.put("precip6", precip6HourMap.get("precip6").toString()); + } + + for (Map<String, Object> tvocMap : tvocList) { + String ttime = tvocMap.get("time").toString(); + if (ttime.equals(rtime)) { + Double tvoc = Double.valueOf(tvocMap.get("TVOC").toString()); + BigDecimal bd = new BigDecimal(tvoc); + tvoc = bd.setScale(3,BigDecimal.ROUND_HALF_UP).doubleValue(); + realMap.put("TVOC", tvoc); + } + } + } List<Map<String, Object>> list = new ArrayList<>(); @@ -393,13 +576,15 @@ } } } + list.removeAll(Collections.singleton(null)); for (Map<String, Object> map : list) { map.put("type", "������"); - map.put("city", parameters.get("city").toString()); + map.put("city", parameters.get("name").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"))) { @@ -408,49 +593,167 @@ } } } - 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()); + hashMap.put("city", parameters.get("name").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", ""); + } + } + if ((!map.containsKey("SO2C")) && map.containsKey("SO2")) { + map.put("SO2C", map.get("SO2").toString()); + } + if ((!map.containsKey("NO2C")) && map.containsKey("NO2")) { + map.put("NO2C", map.get("NO2").toString()); + } + if ((!map.containsKey("O3C")) && map.containsKey("O3")) { + map.put("O3C", map.get("O3").toString()); + } + if ((!map.containsKey("COC")) && map.containsKey("CO")) { + map.put("COC", map.get("CO").toString()); + } + if ((!map.containsKey("PM25C")) && map.containsKey("PM2_5")) { + map.put("PM25C", map.get("PM2_5").toString()); + } + if ((!map.containsKey("PM10C")) && map.containsKey("PM10")) { + map.put("PM10C", map.get("PM10").toString()); + } + if (map.get("windScale") != null) { + String windScale = map.get("windScale").toString().replace("-", "~"); + map.put("windScale", windScale); + } + } + + //���4��������������� + double value = 160.0 * 8; + int nowHour = Integer.valueOf(sdf1.format(now).substring(11, 13)); + String format = sdf1.format(now).substring(0, 13) + ":00:00"; + if (nowHour < 8) { + return resultList; + } + for (Map<String, Object> resultMap : resultList) { + if (resultMap.get("type").equals("������")) { + if (sdf.parse(time).getTime() == sdf.parse(sdf.format(now)).getTime()) { + String rtime = resultMap.get("time").toString() + ":00"; + int rhour = Integer.valueOf(rtime.substring(11, 13)); + cal.setTime(sdf1.parse(rtime)); + cal.add(Calendar.HOUR_OF_DAY, -7); + Date startTime = cal.getTime(); + Date endTime = sdf1.parse(format); + Map<String, Object> hashMap = new HashMap<>(); + hashMap.put("cityCode", Integer.valueOf(parameters.get("cityCode").toString())); + hashMap.put("start", startTime); + hashMap.put("end", endTime); + if (rhour == 0) { + rhour = 24; + } + if (rhour == nowHour) { + Map<String, Object> sumO3Map = hangzhouAqiMapper.getSumO3(hashMap); + 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))); + } 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))); + } 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 (resultMap.get("O3C_8H") != null && !resultMap.get("O3C_8H").equals("")) { + Double O3C_8H = Double.valueOf(resultMap.get("O3C_8H").toString()); + resultMap.put("O3C_8H", String.valueOf(Math.round(O3C_8H))); + } + + if (resultMap.get("PM25C") != null && !resultMap.get("PM25C").equals("")) { + Double PM25C = Double.valueOf(resultMap.get("PM25C").toString()); + resultMap.put("PM25C", String.valueOf(Math.round(PM25C))); + } + + if (resultMap.get("PM10C") != null && !resultMap.get("PM10C").equals("")) { + Double PM10C = Double.valueOf(resultMap.get("PM10C").toString()); + resultMap.put("PM10C", String.valueOf(Math.round(PM10C))); + } + + if (resultMap.get("O3C") != null && !resultMap.get("O3C").equals("")) { + Double O3C = Double.valueOf(resultMap.get("O3C").toString()); + resultMap.put("O3C", String.valueOf(Math.round(O3C))); + } + } + + Map<String, Object> point = shAreaMapper.getLngAndLat(name); + for (Map<String, Object> map : resultList) { + double longitude = Double.valueOf(point.get("lng").toString()); + double latitude = Double.valueOf(point.get("lat").toString()); + map.put("longitude",df.format(longitude)); + map.put("latitude",df.format(latitude)); } return resultList; } @Override - public void updateForecastWeather(List<Map<String, Object>> list) { - for (Map<String, Object> map : list) { - String time = map.get("time").toString(); - Map<String, Object> parameters = new HashMap<>(); - parameters.put("time", time); - Integer monitorPointId; - String city = map.get("city").toString(); - Area area = areaMapper.getAreaByName(city); - if (area == null) { - Integer cityCode = cityMapper.getCityByName(city).getCityCode(); - monitorPointId = monitorPointMapper.getFirstMonitorPointByCityCode(cityCode).getId(); - } else { - Integer areaCode = area.getAreaCode(); - monitorPointId = monitorPointMapper.getFirstMonitorPointByAreaCode(areaCode).getId(); - } - parameters.put("monitorPointId", monitorPointId); - - Map<String, Object> jsonMap = new HashMap<>(); - for (String key : map.keySet()) { - if (!key.equals("city") && !key.equals("time") && !key.equals("type")) { - String value = map.get(key).toString(); - jsonMap.put(key, value); + 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()); } } - - String json = JSONObject.toJSONString(jsonMap); - parameters.put("json", json); - - forecastWeatherMapper.updateForecastWeather(parameters); + 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); + hashMap.put("cityCode", Integer.valueOf(map.get("code").toString())); + Map<String, Object> jsonMap = new HashMap<>(); + for (String key : map.keySet()) { + if (!key.equals("city") && !key.equals("time") && !key.equals("type") && !key.equals("fxTime") && !key.equals("code")) { + String value = map.get(key).toString(); + jsonMap.put(key, value); + } + } + hashMap.put("json", JSONObject.toJSONString(jsonMap)); + forecastWeatherMapper.updateForecastWeather(hashMap); + } } } } -- Gitblit v1.8.0