From af2ff6353abb09500ff08293490446a4d40d8e87 Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Fri, 31 Jul 2020 17:03:19 +0800
Subject: [PATCH] 更换天气预测接口，根据城市名获取预测与实测数据对比
---
src/main/java/com/moral/service/impl/WeatherServiceImpl.java | 482 ++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 433 insertions(+), 49 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java
index 2b0b4ae..62d3544 100644
--- a/src/main/java/com/moral/service/impl/WeatherServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/WeatherServiceImpl.java
@@ -1,5 +1,13 @@
package com.moral.service.impl;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+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;
import java.util.Map;
@@ -10,63 +18,439 @@
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.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.ForecastWeatherMapper;
+import com.moral.mapper.HangzhouAqiMapper;
+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;
@Service
public class WeatherServiceImpl implements WeatherService {
-
- @Resource
- private OrganizationService organizationService;
-
- @Override
- public Map<String, Object> getWeatherDataByRegion(Map<String, Object> parameters) {
- Object organizationId = parameters.get("organizationId");
- ValidateUtil.notNull(organizationId, "param.is.null");
- String areaName = "���������";
- String parentName = "";
- Organization organization = organizationService.getOrganizationById(Integer.valueOf(parameters.get("organizationId").toString()));
- if(organization.getAreaNames()!=null){
- AreaNames areaNames = organization.getAreaNames();
- if (ObjectUtils.isEmpty(areaNames.getAreaName())) {
- if (ObjectUtils.isEmpty(areaNames.getCityName())) {
- areaName = areaNames.getProvinceName();
- } else {
- areaName = areaNames.getCityName();
- }
- } else {
- areaName = areaNames.getAreaName();
- parentName = areaNames.getCityName();
- if ("���������".equals(areaName)) {
- areaName = parentName;
- }
- }
- }
- List<Element> elements = Dom4jUtils.readDocument();
- String cityID = "1102";
- for (Element element : elements) {
- String name = element.element("name").getText();
- if (areaName.equals(name)) {
- cityID = element.element("Fid").getText();
- break;
- }
- if (name.endsWith(areaName)) {
- if (name.startsWith(parentName)) {
- cityID = element.element("Fid").getText();
- break;
- }
- }
- }
- RestTemplate restTemplate = new RestTemplate();
- Map<String, Object> map = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=aqi", Map.class,cityID);
- Map<String, Object> result = (Map<String, Object>) ((Map)map.get("data")).get("aqi");
- map = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=condition", Map.class,cityID);
- result.putAll((Map<? extends String, ? extends Object>) ((Map)map.get("data")).get("condition"));
- return result;
- }
+ @Resource
+ private OrganizationService organizationService;
+
+ @Resource
+ private HangzhouAqiMapper hangzhouAqiMapper;
+
+ @Resource
+ private MonitorPointMapper monitorPointMapper;
+
+ @Resource
+ private ForecastWeatherMapper forecastWeatherMapper;
+
+ @Resource
+ private AreaMapper areaMapper;
+
+ @Resource
+ private CityMapper cityMapper;
+
+ @Resource
+ private ProvinceMapper provinceMapper;
+
+ @Resource
+ private RealWeatherMapper realWeatherMapper;
+
+ @Override
+ public Map<String, Object> getWeatherDataByRegion(Map<String, Object> parameters) {
+ Object organizationId = parameters.get("organizationId");
+ ValidateUtil.notNull(organizationId, "param.is.null");
+ String areaName = "���������";
+ String parentName = "";
+ Organization organization = organizationService.getOrganizationById(Integer.valueOf(parameters.get("organizationId").toString()));
+ if (organization.getAreaNames() != null) {
+ AreaNames areaNames = organization.getAreaNames();
+ if (ObjectUtils.isEmpty(areaNames.getAreaName())) {
+ if (ObjectUtils.isEmpty(areaNames.getCityName())) {
+ areaName = areaNames.getProvinceName();
+ } else {
+ areaName = areaNames.getCityName();
+ }
+ } else {
+ areaName = areaNames.getAreaName();
+ parentName = areaNames.getCityName();
+ if ("���������".equals(areaName)) {
+ areaName = parentName;
+ }
+ }
+ }
+ List<Element> elements = Dom4jUtils.readDocument();
+ String cityID = "1102";
+ for (Element element : elements) {
+ String name = element.element("name").getText();
+ if (areaName.equals(name)) {
+ cityID = element.element("Fid").getText();
+ break;
+ }
+ if (name.endsWith(areaName)) {
+ if (name.startsWith(parentName)) {
+ cityID = element.element("Fid").getText();
+ break;
+ }
+ }
+ }
+ RestTemplate restTemplate = new RestTemplate();
+ Map<String, Object> map = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=aqi", Map.class, cityID);
+ Map<String, Object> result = (Map<String, Object>) ((Map) map.get("data")).get("aqi");
+ map = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=condition", Map.class, cityID);
+ result.putAll((Map<? extends String, ? extends Object>) ((Map) map.get("data")).get("condition"));
+ return result;
+ }
+
+ @Override
+ public Map<String, Object> get15DayWeatherDataByRegion(Map<String, Object> parameters) {
+ Object organizationId = parameters.get("organizationId");
+ ValidateUtil.notNull(organizationId, "param.is.null");
+ String areaName = "���������";
+ String parentName = "";
+ Organization organization = organizationService.getOrganizationById(Integer.valueOf(parameters.get("organizationId").toString()));
+ if (organization.getAreaNames() != null) {
+ AreaNames areaNames = organization.getAreaNames();
+ if (ObjectUtils.isEmpty(areaNames.getAreaName())) {
+ if (ObjectUtils.isEmpty(areaNames.getCityName())) {
+ areaName = areaNames.getProvinceName();
+ } else {
+ areaName = areaNames.getCityName();
+ }
+ } else {
+ areaName = areaNames.getAreaName();
+ parentName = areaNames.getCityName();
+ if ("���������".equals(areaName)) {
+ areaName = parentName;
+ }
+ }
+ }
+ List<Element> elements = Dom4jUtils.readDocument();
+ String cityID = "1102";
+ for (Element element : elements) {
+ String name = element.element("name").getText();
+ if (areaName.equals(name)) {
+ cityID = element.element("Fid").getText();
+ break;
+ }
+ if (name.endsWith(areaName)) {
+ if (name.startsWith(parentName)) {
+ cityID = element.element("Fid").getText();
+ break;
+ }
+ }
+ }
+ RestTemplate restTemplate = new RestTemplate();
+ Map<String, Object> map = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=aqi", Map.class, cityID);
+ List<Map<String, Object>> result = new ArrayList<>();
+ map = restTemplate.getForObject("http://sapi.7drlb.com/api/mj?cityID={1}&apiKey=forecast15days", Map.class, cityID);
+ result.addAll((Collection<? extends Map<String, Object>>) ((Map) map.get("data")).get("forecast"));
+ for (Map<String, Object> map2 : result) {
+ Map<String, Object> returnMap = new HashMap<>();
+ String predictDate = map2.get("predictDate").toString();
+ String time = parameters.get("time").toString();
+ if (predictDate.equals(time)) {
+ returnMap = map2;
+ return returnMap;
+ }
+ }
+ return null;
+ }
+
+ @Override
+ public List<Map<String, Object>> getForecastAndReal(Map<String, Object> parameters) throws ParseException {
+ 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";
+ Calendar c = Calendar.getInstance();
+ 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 (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";
+ }
+ map.put("time", Integer.valueOf(hour));
+ values.add("");
+ values.add(aqiMap.get(sensor1).toString());
+ map.put("values", values);
+ resultList.add(map);
+ }
+
+ } else if (aqiList.size() == 0) {
+ for (Map<String, Object> forecastMap : forecastList) {
+ Map<String, Object> map = new HashMap<>();
+ List<String> values = new ArrayList<>();
+ String hour = forecastMap.get("time").toString().split(" ")[1].split(":")[0];
+ if (hour.equals("00")) {
+ hour = "24";
+ }
+ map.put("time", Integer.valueOf(hour));
+ values.add(forecastMap.get("result").toString().replace("\"", ""));
+ values.add("");
+ map.put("values", values);
+ resultList.add(map);
+ }
+ } else {
+ for (Map<String, Object> forecastMap : forecastList) {
+ Map<String, Object> map = new HashMap<>();
+ List<String> values = new ArrayList<>();
+ String hour = forecastMap.get("time").toString().split(" ")[1].split(":")[0];
+ if (hour.equals("00")) {
+ hour = "24";
+ }
+ map.put("time", Integer.valueOf(hour));
+ values.add(forecastMap.get("result").toString().replace("\"", ""));
+ 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");
+ 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("city", parameters.get("city").toString());
+ Map<String, Object> jsonMap = (Map<String, Object>) JSONObject.parse(map.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);
+ }
+
+ 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);
+ }
+
+ 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();
+ 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������8������", O3Map.get("O3������8������").toString());
+ if (O3Map.get("O3������8������") != null) {
+ map.put("O3������8������", O3Map.get("O3������8������").toString());
+ }
+ }
+
+ 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);
+ }
+
+ 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);
+ }
+ 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);
+ }
+ }
+
+ String json = JSONObject.toJSONString(jsonMap);
+ parameters.put("json", json);
+
+ forecastWeatherMapper.updateForecastWeather(parameters);
+ }
+ }
}
--
Gitblit v1.8.0