From f694728af353dcf32e270c0b1b27d81ba76fecd8 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Mon, 21 Sep 2020 10:51:51 +0800
Subject: [PATCH] update
---
src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java | 328 ++++++++++++++++++++++++++++++++++++++++++-----------
1 files changed, 257 insertions(+), 71 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java b/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java
index 5f4b537..e87aa6a 100644
--- a/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java
@@ -7,7 +7,6 @@
import java.util.Date;
import java.util.HashMap;
import java.util.HashSet;
-import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Set;
@@ -18,16 +17,20 @@
import org.springframework.stereotype.Service;
import org.springframework.web.client.RestTemplate;
-import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONObject;
import com.moral.entity.Area;
import com.moral.entity.City;
import com.moral.entity.MonitorPoint;
+import com.moral.entity.Province;
+import com.moral.mapper.AQIMapper;
import com.moral.mapper.AreaMapper;
import com.moral.mapper.CityMapper;
+import com.moral.mapper.DeviceMapper;
import com.moral.mapper.ForecastWeatherMapper;
+import com.moral.mapper.HistoryHourlyMapper;
import com.moral.mapper.MonitorPointMapper;
import com.moral.mapper.ProvinceMapper;
+import com.moral.mapper.RealWeatherMapper;
import com.moral.service.ForecastWeatherService;
import com.moral.util.Dom4jUtils;
@@ -49,136 +52,319 @@
@Resource
private ProvinceMapper provinceMapper;
+ @Resource
+ private RealWeatherMapper realWeatherMapper;
+
+ @Resource
+ private AQIMapper aqiMapper;
+
+ @Resource
+ private DeviceMapper deviceMapper;
+
+ @Resource
+ private HistoryHourlyMapper historyHourlyMapper;
+
@Override
- public void insertForecastWeather() throws ParseException {
+ public int insertForecastWeather() throws ParseException {
Calendar c = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat sdf1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
- String now = sdf.format(c.getTime());
c.add(Calendar.DAY_OF_MONTH, 1);
String nextDay = sdf.format(c.getTime());
+ c.setTime(c.getTime());
+ Date start = sdf1.parse(nextDay + " 01:00:00");
c.add(Calendar.DAY_OF_MONTH, 1);
- String nextNextDay = sdf.format(c.getTime());
-
+ String nextNextDay = sdf.format(c.getTime()) + " 00";
+ Date end = sdf1.parse(sdf.format(c.getTime()) + " 01:00:00");
RestTemplate restTemplate = new RestTemplate();
List<MonitorPoint> monitorPointList = monitorPointMapper.getMonitorPointList();
-
Set<Map<String, Object>> hashSet = new HashSet<>();
- List<Map<String, Object>> resultList = new ArrayList<>();
for (MonitorPoint monitorPoint : monitorPointList) {
- Map<String, Object> hashMap1 = new HashMap<>();
Map<String, Object> hashMap = new HashMap<>();
Integer areaCode = monitorPoint.getAreaCode();
Integer cityCode = monitorPoint.getCityCode();
Integer provinceCode = monitorPoint.getProvinceCode();
String parentName = "";
String name1 = "";
+ Integer code = 0;
+ Integer parentCode = 0;
if (areaCode != null) {
Area area = areaMapper.getAreaByAreaCode(areaCode);
City city = cityMapper.getCityByCityCode(cityCode);
name1 = area.getAreaName();
parentName = city.getCityName();
+ parentCode = city.getCityCode();
+ code = areaCode;
if ("���������".equals(name1)) {
name1 = parentName;
- parentName = provinceMapper.getProvinceByProvinceCode(provinceCode).getProvinceName();
+ Province province = provinceMapper.getProvinceByProvinceCode(provinceCode);
+ parentName = province.getProvinceName();
+ parentCode = province.getProvinceCode();
+ code = cityCode;
}
} else {
City city = cityMapper.getCityByCityCode(cityCode);
name1 = city.getCityName();
- parentName = provinceMapper.getProvinceByProvinceCode(provinceCode).getProvinceName();
+ Province province = provinceMapper.getProvinceByProvinceCode(provinceCode);
+ parentName = province.getProvinceName();
+ code = cityCode;
+ parentCode = province.getProvinceCode();
+ if ("���������".equals(name1)) {
+ name1 = parentName;
+ parentName = "";
+ code = provinceCode;
+ }
}
hashMap.put("name1", name1);
hashMap.put("parentName", parentName);
+ hashMap.put("cityCode", code);
+ hashMap.put("parentCode", parentCode);
hashSet.add(hashMap);
- hashMap1.put("monitorPointId", monitorPoint.getId());
- hashMap1.put("name", name1);
- resultList.add(hashMap1);
}
List<Element> elements = Dom4jUtils.readDocument();
String cityID = "101190404";
- List<Map<String, Object>> insertList = new ArrayList<>();
for (Map<String, Object> map : hashSet) {
- Map<String, Object> hashMap = new HashMap<>();
String name1 = map.get("name1").toString();
- hashMap.put("name", name1);
for (Element element : elements) {
String name2 = element.element("name").getText();
String parentName = map.get("parentName").toString();
+ if (name2.equals("���������")) {
+ name2 = "���������";
+ }
if (name1.equals(name2)) {
- cityID = element.element("Fid").getText();
+ cityID = element.element("Fweathercn").getText();
+ map.put("cityID", cityID);
break;
}
if (name2.endsWith(name1)) {
if (name2.startsWith(parentName)) {
- cityID = element.element("Fid").getText();
+ cityID = element.element("Fweathercn").getText();
+ map.put("cityID", cityID);
break;
}
}
}
- Map<String, Object> map1 = restTemplate.getForObject("https://yiketianqi.com/api?version=v9&appid=68884517&appsecret=kqUYTBk3&cityid={1}", Map.class, cityID);
- if (map1 == null) {
- map1=new HashMap<>();
+ }
+
+ c.setTime(new Date());
+ Date endTime = sdf.parse(sdf.format(c.getTime()));
+ c.add(Calendar.MONTH, -2);
+ Date startTime = sdf.parse(sdf.format(c.getTime()));
+ int count = 0;
+ for (Map<String, Object> map : hashSet) {
+ String id = map.get("cityID").toString();
+ Map<String, Object> dataMap = restTemplate.getForObject("https://api.heweather.net/v7/weather/72h?key=da05c6c4852d4f7aa3364a9236ee9e26&gzip=n&location={1}", Map.class, id);
+ if (dataMap == null) {
+ return count;
}
+ String json = JSONObject.toJSONString(dataMap);
+ dataMap = (Map<String, Object>) JSONObject.parse(json);
+ List<Map<String, Object>> nextDayList = new ArrayList<>();
+ String string = dataMap.get("hourly").toString();
+ List<Map<String, Object>> hourlyList = (List<Map<String, Object>>) JSONObject.parse(string);
+ for (Map<String, Object> hourlyMap : hourlyList) {
+ String hour = hourlyMap.get("fxTime").toString().split("T")[0];
+ String hour1 = hourlyMap.get("fxTime").toString().split("\\+")[0].split(":")[0].replace("T", " ");
+ if (hour.equals(nextDay)) {
+ nextDayList.add(hourlyMap);
+ }
+ if (hour1.equals(nextNextDay)) {
+ nextDayList.add(hourlyMap);
+ }
+ }
+ nextDayList.remove(0);
+ for (Map<String, Object> nextDayMap : nextDayList) {
+ String text = nextDayMap.get("text").toString();
+ String condition = "";
+ if ("���".equals(text)) {
+ condition = "100";
+ } else if ("������".equals(text)) {
+ condition = "80";
+ } else if ("���".equals(text)) {
+ condition = "60";
+ } else if ("���������".equals(text) || "������".equals(text)) {
+ condition = "40";
+ } else if ("������".equals(text)) {
+ condition = "20";
+ } else if ("���".equals(text)) {
+ condition = "0";
+ }else {
+ condition = "50";
+ }
+ nextDayMap.put("condition", condition);
+ }
+ map.put("data", nextDayList);
+ }
- List<Map<String, Object>> dataList = (ArrayList<Map<String, Object>>) map1.get("data");
- List<Map<String, Object>> arrayList = new ArrayList<>();
-
+ for (Map<String, Object> map : hashSet) {
+ List<Map<String, Object>> resultList = new ArrayList<>();
+ String cityCode = map.get("cityCode").toString();
+ map.put("startTime", startTime);
+ map.put("endTime", endTime);
+ map.put("typeFormat", "%Y-%m-%d %H:%i:%s");
+ Map<String, Object> map1 = new HashMap<>();
+ map1.put("typeFormat", "%Y-%m-%d %H:%i:%s");
+ map1.put("cityCode", Integer.valueOf(cityCode));
+ //������city_code������������monitorPoint
+ Map<String, Object> params = new HashMap<>();
+ if (cityCode.endsWith("0000")) {
+ params.put("provinceCode", Integer.valueOf(cityCode));
+ } else if (cityCode.endsWith("00")) {
+ params.put("cityCode", Integer.valueOf(cityCode));
+ } else {
+ params.put("areaCode", Integer.valueOf(cityCode));
+ }
+ List<Integer> pointList = new ArrayList<>();
+ if (cityCode.equals("130900")) {
+ pointList.add(48);
+ } else {
+ pointList = monitorPointMapper.getMonitorList(params);
+ }
+ List<String> macList = deviceMapper.getMacsByMonitorPointIds(pointList);
+ if (macList.size() != 0) {
+ map.put("macs", macList);
+ }
+ ArrayList<Map<String, Object>> dataList = (ArrayList<Map<String, Object>>) map.get("data");
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(now)) {
- for (int i = list.size() - 7; i < list.size(); i++) {
- Map<String, Object> resultMap = list.get(i);
- arrayList.add(resultMap);
- }
+ Map<String, Object> hashMap = new HashMap<>();
+ hashMap.put("cityCode", cityCode);
+ String time = dataMap.get("fxTime").toString().split("\\+")[0].replace("T", " ") + ":00";
+ int hour = Integer.valueOf(time.substring(11, 13));
+ map.put("time", hour);
+ hashMap.put("time", sdf1.parse(time));
+ String nextDayTemp = dataMap.get("temp").toString();
+ String nextDayCloud = dataMap.get("cloud").toString();
+ Integer condition = Integer.valueOf(dataMap.get("condition").toString());
+ Integer value=0;
+ if (condition >= 80) {
+ value = 80;
+ } else if (condition >= 40) {
+ value = 40;
+ } else if (condition >= 0) {
+ value = 0;
}
- if (date.equals(nextDay)) {
- for (int i = 0; i < 17; i++) {
- Map<String, Object> resultMap = list.get(i);
- arrayList.add(resultMap);
- }
+ map.put("condition", value);
+ List<Map<String, Object>> tempAndCloudList = realWeatherMapper.getTempAndCloud(map);
+ List<String> times = new ArrayList<>();
+ for (Map<String, Object> tempAndCloudMap : tempAndCloudList) {
+ times.add(tempAndCloudMap.get("time").toString());
}
- }
- hashMap.put("data", arrayList);
- insertList.add(hashMap);
- }
-
- for (Map<String, Object> resultMap : resultList) {
- List<Map<String, Object>> list = new ArrayList<>();
- String monitorPointId = resultMap.get("monitorPointId").toString();
- for (Map<String, Object> insertMap : insertList) {
- if (resultMap.get("name").equals(insertMap.get("name"))) {
- ArrayList<Map<String, Object>> dataList = (ArrayList<Map<String, Object>>) insertMap.get("data");
- for (Map<String, Object> dataMap : dataList) {
- dataMap.remove("wea_img");
- Map<String, Object> map = new HashMap<>();
- map.put("monitorPointId", Integer.valueOf(monitorPointId));
- String hour = dataMap.get("hours").toString().replaceAll("[\u4e00-\u9fa5]+", "");
- Date date = sdf1.parse(nextDay + " " + hour + ":00:00");
- if (hour.equals("00")) {
- date = sdf1.parse(nextNextDay + " 00:00:00");
+ map.put("times", times);
+ map1.put("times", times);
+ map1.put("time", hour);
+ List<Map<String, Object>> O3List = aqiMapper.getO3(map1);
+ if (O3List.size() == 0) {
+ map1.put("cityCode", Integer.valueOf(map.get("parentCode").toString()));
+ O3List = aqiMapper.getO3(map1);
+ }
+ List<Map<String, Object>> beamList = new ArrayList<>();
+ if (map.get("macs") != null) {
+ beamList = historyHourlyMapper.getBeamByMacs(map);
+ }
+ for (Map<String, Object> tempAndCloudMap : tempAndCloudList) {
+ String time1 = tempAndCloudMap.get("time").toString();
+ for (Map<String, Object> beamMap : beamList) {
+ if (beamList.size() != 0) {
+ String time2 = beamMap.get("time").toString();
+ if (time1.equals(time2)) {
+ tempAndCloudMap.putAll(beamMap);
+ }
}
- map.put("time", date);
- String json = JSONObject.toJSONString(dataMap);
- map.put("json", json);
- list.add(map);
}
}
- }
- for (Map<String, Object> map : list) {
- String json = map.get("json").toString();
- Map<String, Object> jsonMap = JSON.parseObject(json, Map.class);
- Iterator<String> iterator = jsonMap.keySet().iterator();
- while (iterator.hasNext()) {
- if (iterator.next().equals("hours")) {
- iterator.remove();
- json = JSONObject.toJSONString(jsonMap);
- map.put("json",json);
+ for (Map<String, Object> tempAndCloudMap : tempAndCloudList) {
+ String time1 = tempAndCloudMap.get("time").toString();
+ for (Map<String, Object> O3Map : O3List) {
+ if (O3List.size() != 0) {
+ String time3 = O3Map.get("time").toString();
+ if (time1.equals(time3)) {
+ tempAndCloudMap.putAll(O3Map);
+ }
+ }
}
}
+
+ double tempSum = 0.0;//���������
+ double O3Sum = 0.0;//O3���
+ double sum1 = 0.0;//
+ double sum2 = 0.0;
+
+ double cloudSum = 0.0;//���������
+ double beamSum = 0.0;//O3���
+ double sum3 = 0.0;//
+ double sum4 = 0.0;
+ int size = tempAndCloudList.size();
+ Map<String, Object> cmap = new HashMap<>();
+ cmap.put("time", hour);
+ for (Map<String, Object> listMap : tempAndCloudList) {
+ //O3
+ double temp = Double.valueOf(listMap.get("temp").toString().replace("\"", "").split("\\.")[0]);
+ if (listMap.get("O3") != null) {
+ double O3 = Double.valueOf(listMap.get("O3").toString().replace("\"", "").split("\\.")[0]);
+ tempSum = tempSum + temp;
+ O3Sum = O3Sum + O3;
+ sum1 = sum1 + temp * O3;
+ sum2 = sum2 + temp * temp;
+ }
+ //������
+ double cloud = Double.valueOf(listMap.get("cloud").toString().replace("\"", "").split("\\.")[0]);
+ if (listMap.get("beam") != null) {
+ double beam = Double.valueOf(listMap.get("beam").toString().replace("\"", "").split("\\.")[0]);
+ cloudSum = cloudSum + cloud;
+ beamSum = beamSum + beam;
+ sum3 = sum3 + cloud * beam;
+ sum4 = sum4 + cloud * cloud;
+ }
+ }
+
+ if (tempSum != 0.0) {
+ double tempAvg = tempSum / size;
+ double O3Avg = O3Sum / size;
+ double b = (sum1 - size * tempAvg * O3Avg) / (sum2 - size * tempAvg * tempAvg);
+ double a = O3Avg - (b * tempAvg);
+ cmap.put("a", a);
+ cmap.put("b", b);
+ }
+
+ if (cloudSum != 0.0) {
+ double cloudAvg = cloudSum / size;
+ double beamAvg = beamSum / size;
+ double n = (sum3 - size * cloudAvg * beamAvg) / (sum4 - size * cloudAvg * cloudAvg);
+ double m = beamAvg - (n * cloudAvg);
+ cmap.put("m", m);
+ cmap.put("n", n);
+ }
+ if (cmap.get("a") != null) {
+ Double a = Double.valueOf(cmap.get("a").toString());
+ Double b = Double.valueOf(cmap.get("b").toString());
+ double O3C = b * Double.valueOf(nextDayTemp) + a;
+ if (O3C < 1.0) {
+ O3C=1.0;
+ }
+ dataMap.put("O3C", String.valueOf(Math.round(O3C)));
+ }
+ if (cmap.get("m") != null) {
+ Double m = Double.valueOf(cmap.get("m").toString());
+ Double n = Double.valueOf(cmap.get("n").toString());
+ double beam = n * Double.valueOf(nextDayCloud) + m;
+ if (beam < 1.0) {
+ beam=0.0;
+ }
+ dataMap.put("beam", String.valueOf(Math.round(beam)));
+ }
+ dataMap.remove("icon");
+ dataMap.remove("fxTime");
+ hashMap.put("json", JSONObject.toJSONString(dataMap));
+ resultList.add(hashMap);
}
- forecastWeatherMapper.insertForecastWeather(list);
+ Map<String, Object> parameters = new HashMap<>();
+ parameters.put("start", start);
+ parameters.put("end", end);
+ parameters.put("cityCode", cityCode);
+ forecastWeatherMapper.deleteByTime(parameters);
+ count = count + forecastWeatherMapper.insertForecastWeather(resultList);
}
+ return count;
}
}
--
Gitblit v1.8.0