From 0a107debd7676141376a59bd3d4472912b24f7dc Mon Sep 17 00:00:00 2001
From: 于紫祥_1901 <email@yuzixiang_1910>
Date: Thu, 13 Aug 2020 09:37:43 +0800
Subject: [PATCH] 风场图update
---
src/main/java/com/moral/service/impl/WeatherServiceImpl.java | 454 ++++++++++++++++++++++++++++++++++++++++++++++----------
1 files changed, 368 insertions(+), 86 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java
index 66b3245..7687544 100644
--- a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java
@@ -5,6 +5,7 @@
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.List;
@@ -12,6 +13,7 @@
import javax.annotation.Resource;
+import org.apache.jasper.compiler.JspUtil;
import org.dom4j.Element;
import org.springframework.stereotype.Service;
import org.springframework.util.ObjectUtils;
@@ -23,16 +25,19 @@
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.RealTimeWeatherMapper;
+import com.moral.mapper.RealWeatherMapper;
import com.moral.service.OrganizationService;
import com.moral.service.WeatherService;
@@ -61,7 +66,13 @@
private ProvinceMapper provinceMapper;
@Resource
- private RealTimeWeatherMapper realTimeWeatherMapper;
+ private RealWeatherMapper realWeatherMapper;
+
+ @Resource
+ private DeviceMapper deviceMapper;
+
+ @Resource
+ private HistoryHourlyMapper historyHourlyMapper;
@Override
public Map<String, Object> getWeatherDataByRegion(Map<String, Object> parameters) {
@@ -166,6 +177,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";
@@ -177,21 +189,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);
@@ -210,7 +220,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);
}
@@ -224,7 +234,11 @@
hour = "24";
}
map.put("time", Integer.valueOf(hour));
- values.add(forecastMap.get("result").toString().replace("\"", ""));
+ if (forecastMap.get("result") != null) {
+ values.add(forecastMap.get("result").toString().replace("\"", ""));
+ } else {
+ values.add("");
+ }
values.add("");
map.put("values", values);
resultList.add(map);
@@ -238,10 +252,14 @@
hour = "24";
}
map.put("time", Integer.valueOf(hour));
- values.add(forecastMap.get("result").toString().replace("\"", ""));
+ 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());
+ values.add(aqiMap.get("O3").toString());
}
}
map.put("values", values);
@@ -259,115 +277,379 @@
@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));
+ 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);
- List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters);
- if (aqiList.size() == 0) {
- parameters.put("areaCode", cityCode);
- aqiList = hangzhouAqiMapper.getAqi(parameters);
- }
- List<Map<String, Object>> list1 = new ArrayList<>();
- for (Map<String, Object> map : aqiList) {
- Map<String, Object> hashMap = new HashMap<>();
- hashMap.put("time", map.get("time"));
- Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(map.get("json").toString());
- hashMap.putAll(jsonMap);
- hashMap.put("city", parameters.get("city").toString());
- list1.add(hashMap);
- }
-
- List<Map<String, Object>> realTimeList = realTimeWeatherMapper.getRealTimeWeather(parameters);
- List<Map<String, Object>> realList = new ArrayList<>();
- for (Map<String, Object> map : realTimeList) {
- Map<String, Object> hashMap = new HashMap<>();
- hashMap.put("time", map.get("time"));
- hashMap.put("type", "������");
- hashMap.put("city", parameters.get("city").toString());
- Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(map.get("json").toString());
- hashMap.putAll(jsonMap);
- realList.add(hashMap);
- }
-
- for (Map<String, Object> realTimeMap : realList) {
- for (Map<String, Object> aqiMap : list1) {
- if (aqiMap.get("time").equals(realTimeMap.get("time"))) {
- realTimeMap.putAll(aqiMap);
+ 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> forecastMap : forecastList) {
- Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(forecastMap.get("json").toString());
Map<String, Object> hashMap = new HashMap<>();
- hashMap.put("temp", jsonMap.get("tem"));
- hashMap.put("windDir", jsonMap.get("win"));
- hashMap.put("windLevel", jsonMap.get("win_speed"));
- hashMap.put("condition", jsonMap.get("wea"));
hashMap.put("time", forecastMap.get("time").toString());
hashMap.put("type", "������");
- hashMap.put("city", parameters.get("city").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", "");
+ 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>> resultList = new ArrayList<>();
for (Map<String, Object> foreMap : foreList) {
- for (Map<String, Object> realMap : realList) {
+ 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());
+ }
+ }
+
+ String ac = parameters.get("cityCode").toString();
+ List<Map<String, Object>> aqiList = hangzhouAqiMapper.getAqi(parameters);
+ if (aqiList.size() == 0) {
+ parameters.put("cityCode", code);//320500
+ 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;
+ }
+ }
+ }
+ }
+ }
+ 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("name").toString());
+ realAqilist.add(hashMap);
+ }
+ for (Map<String, Object> map : realAqilist) {
+ 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 = hangzhouAqiMapper.getAvgO3EightHours(hashMap);
+ 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) {
+ 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("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)) {
+ realMap.put("TVOC", tvocMap.get("TVOC").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("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"))) {
resultList.add(foreMap);
resultList.add(realMap);
}
}
}
-
- for (int i = realList.size(); i < forecastList.size(); i++) {
+ 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("type", "������");
+ 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());
+ }
+
+ }
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);
+ 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