From dcb98a36af4ad7823edd61a9c3388bd024db740f Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Mon, 21 Aug 2023 14:33:13 +0800 Subject: [PATCH] chore:测试提交 --- screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java | 86 ++++++++++++++++++++++++++++++++++++++---- 1 files changed, 77 insertions(+), 9 deletions(-) diff --git a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java index 2075a95..10d5f6d 100644 --- a/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java +++ b/screen-api/src/main/java/com/moral/api/service/impl/CityAqiServiceImpl.java @@ -1,5 +1,6 @@ package com.moral.api.service.impl; +import com.alibaba.excel.util.StringUtils; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; @@ -14,6 +15,7 @@ import com.moral.api.pojo.dto.cityAQI.ConcentrationAndPercent; import com.moral.api.pojo.form.aqi.AirQualityComparisonForm; import com.moral.api.pojo.vo.cityAQI.AirQualityComparisonVO; +import com.moral.api.pojo.vo.cityAQI.CityAreaRangeVO; import com.moral.api.service.*; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.moral.constant.Constants; @@ -85,6 +87,9 @@ private HistoryHourlyService historyHourlyService; @Autowired + SpecialCitiesProperties citiesProperties; + + @Autowired private SysAreaMapper sysAreaMapper; @Override @@ -142,6 +147,34 @@ } return result; } + + + @Override + public List<Map<String, Object>> measuredCompareForecastOfO3_8H(Map<String, Object> params) { + String regionCode = params.get("regionCode").toString(); + String time = params.get("time").toString(); + Date endTime = DateUtils.getDate(time+" "+"23:00:00",DateUtils.yyyy_MM_dd_HH_mm_ss_EN); + Date startDate = DateUtils.getDate(time+" "+"00:00:00",DateUtils.yyyy_MM_dd_HH_mm_ss_EN); + Date startTime = DateUtils.addHours(startDate,-7); + //������������ + QueryWrapper<Forecast> forecastQueryWrapper = new QueryWrapper<>(); + forecastQueryWrapper.select("time", "value") + .eq("city_code", regionCode) + .between("time",startTime,endTime) + .orderByAsc("time"); + List<Map<String, Object>> forecastData = forecastMapper.selectMaps(forecastQueryWrapper); + //������������ + QueryWrapper<CityAqi> cityAqiQueryWrapper = new QueryWrapper<>(); + cityAqiQueryWrapper.select("time", "value") + .eq("city_code", regionCode) + .between("time",startTime,endTime).orderByAsc("time"); + List<Map<String, Object>> measuredData = cityAqiMapper.selectMaps(cityAqiQueryWrapper); + + List<Map<String, Object>> result = getO3_8H(forecastData,0,time); + result.addAll(getO3_8H(measuredData,1,time)); + return result; + } + @Override public Map<String, Object> queryCityAqiByRegionCode(Integer regionCode) { @@ -372,7 +405,7 @@ } }); - //������������O3_8H������,������������O3_8H��������� + //������������O3_8H������,������������O3������8H��������� if (!ObjectUtils.isEmpty(doubles)) { dataMap.put("O3_8H", Collections.max(doubles)); } @@ -634,7 +667,7 @@ /** * @Description: ������������������������ * @Param: [regionCode] - * @return: java.util.Map<java.lang.String, java.lang.Object> + * @return: java.util.Map<java.lang.String , java.lang.Object> * @Author: ��������� * @Date: 2021/10/28 */ @@ -1191,15 +1224,15 @@ */ private ConcentrationAndPercent contrastParam(Double data, Double comparisonData, String sensor) { double percentD = MathUtils.division(data - comparisonData, comparisonData, 4); - String percent = MathUtils.mul(percentD, 100d) + "%"; + String percent = MathUtils.mul(percentD,100d) + "%"; ConcentrationAndPercent concentrationAndPercent = new ConcentrationAndPercent(); concentrationAndPercent.setPercent(percent); if (sensor.equals("CO")) {//CO��������������������� Double CO = AmendUtils.sciCal(data, 1); concentrationAndPercent.setConcentration(CO.toString()); - } else if (sensor.equals("compositeIndex")) { + }else if (sensor.equals("compositeIndex")){ concentrationAndPercent.setConcentration(data.toString()); - } else { + }else{ Double sensorD = AmendUtils.sciCal(data, 0); Integer sensorI = new Double(sensorD).intValue(); concentrationAndPercent.setConcentration(sensorI.toString()); @@ -1225,7 +1258,7 @@ /** * @Description: ���������������������������������6������������������������������������������������������������������������ * @Param: [comparisonType, startDate, endDate, regionCode] - * @return: java.util.Map<java.lang.String, java.lang.Object> + * @return: java.util.Map<java.lang.String , java.lang.Object> * @Author: ��������� * @Date: 2022/1/17 */ @@ -1309,8 +1342,7 @@ private List<SysArea> getSysAreasByRegionType(String regionType, Integer regionCode) { List<SysArea> areas; if (regionType.equals(Constants.TWENTY_EIGHT_CITIES)) { - SpecialCitiesProperties properties = new SpecialCitiesProperties(); - areas = properties.getTwentyEightCities(); + areas = citiesProperties.getTwentyEightCities(); } else { areas = sysAreaService.getChildren(regionCode); } @@ -1320,7 +1352,7 @@ /** * @Description: ������6������������ * @Param: [cityAqiList] - * @return: java.util.Map<java.lang.String, java.lang.Double> + * @return: java.util.Map<java.lang.String , java.lang.Double> * ���������key���sensorCode,value������ * @Author: ��������� * @Date: 2021/11/2 @@ -1383,4 +1415,40 @@ } return s; } + + public List<Map<String, Object>> getO3_8H(List<Map<String, Object>> data , int type,String day) { + List<Map<String, Object>> list = new ArrayList<>(); + for(int i = 0 ;i<=23;i++){ + Map<String, Object> map = new HashMap<>(); + if(type == 0){ + map.put("type","������"); + }else { + map.put("type","������"); + } + String times = day+" "+i; + Date endDate = DateUtils.getDate(times,DateUtils.yyyy_MM_dd_HH_EN); + Date startDate = DateUtils.addHours(DateUtils.getDate(day+" "+i,DateUtils.yyyy_MM_dd_HH_EN),-7); + List<Double> value = new ArrayList<>(); + for(Map<String, Object> m : data){ + Date time = (Date) m.get("time"); + if(DateUtils.isTimeBeforE(time,startDate) && DateUtils.isTimeBeforE(endDate,time)){ + Map<String, Object> sensorValue = JSONObject.parseObject((String) m.get("value"), Map.class); + Double o3 = Double.parseDouble(sensorValue.get("O3").toString()); + value.add(o3); + + } + } + if (value.size() < 6) { + continue; + } + double average = value.stream().mapToDouble(aDouble -> aDouble).summaryStatistics().getAverage(); + map.put("O3", new BigDecimal(average).setScale(3, BigDecimal.ROUND_HALF_UP).doubleValue()); + map.put("time",times); + list.add(map); + } + + return list; + + } + } -- Gitblit v1.8.0