From 8fb013a6d6707929799e9f7a8a82f311cbca29ae Mon Sep 17 00:00:00 2001 From: jinpengyong <jpy123456> Date: Wed, 23 Dec 2020 14:47:04 +0800 Subject: [PATCH] update大屏年,月数据查询接口 --- src/main/java/com/moral/controller/ScreenController.java | 593 ++++++++++++++++++++++++++++++++-------------------------- 1 files changed, 327 insertions(+), 266 deletions(-) diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java index 18d1dfb..6721bcf 100644 --- a/src/main/java/com/moral/controller/ScreenController.java +++ b/src/main/java/com/moral/controller/ScreenController.java @@ -714,8 +714,7 @@ ParameterUtils.getTimeType4Time(parameters); String time1 = (String) parameters.get("time"); time1 = time1.replaceAll(" ", ""); - parameters.put("time",time1); - + parameters.put("time", time1); String mac1 = (String) parameters.get("mac"); List<Map<String, Object>> list = null; if (mac1 != null && mac1.equals("p5dnd7a0392018") && time1.substring(0, 4).equals("2019")) { @@ -726,14 +725,20 @@ parameters.put("sensors", Arrays.asList(sensorKey)); // monitorPointService.isCompensateCalculation(parameters); list = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters); - - /* 0���������������������11������������0���������������������1-24������������������������0������������������������������������24������������ ������������������24���������������23-24���������24������������������������0��������������� */ /*������������start-------------------------------------------------------------------------*/ - list.remove(0); - //if (list.size() == 23) { + Object type = parameters.get("type"); + if ("day".equals(type)) { + Iterator<Map<String, Object>> iterator = list.iterator(); + while (iterator.hasNext()) { + Map<String, Object> next = iterator.next(); + String hour = next.get("time").toString().substring(11, 13); + if ("00".equals(hour)) { + iterator.remove(); + } + } SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); SimpleDateFormat sdf2 = new SimpleDateFormat("yyyy-MM-dd"); //���������������������yyyy-MM-dd HH:mm:ss @@ -745,16 +750,19 @@ parameters.put("time", time2); /*���������������0������������������24���������������������������*/ List<Map<String, Object>> nextDayList = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters); - if(!ObjectUtils.isEmpty(nextDayList)){ - time1=time1.replaceAll(" 00:00:00"," 24"); - Map<String, Object> datas = nextDayList.get(0); - datas.put("time",time1); - list.add(datas); + if (!ObjectUtils.isEmpty(nextDayList)) { + time1 = time1.replaceAll(" 00:00:00", " 24"); + for (Map<String, Object> map : nextDayList) { + String time = map.get("time").toString().substring(11, 13); + if ("00".equals(time)) { + map.put("time", time1); + list.add(map); + } + } } - //} + } + /*������������end-------------------------------------------------------------------------*/ - - for (Map<String, Object> map : list) { String time = map.get("time").toString(); time = time.substring(time.length() - 2); @@ -1505,7 +1513,7 @@ DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"); LocalDateTime timeLocalDateTime = LocalDateTime.parse(time, dateTimeFormatter); int month = timeLocalDateTime.getMonth().getValue(); - parameters.put("yearAndDay",yearAndDay); + parameters.put("yearAndDay", yearAndDay); Point dirPoint = historyHourlyService.getDirPoint(parameters); Map<String, Object> getPollutionSourceData = historyHourlyService.getPollutionSourceDataByHour(parameters); if (MapUtils.isEmpty(getPollutionSourceData)) { @@ -1615,6 +1623,50 @@ //System.out.println(paramsJson); model.addObject("carTrajectoryParams", paramsJson); model.setViewName("cartrajectory"); + return model; + } else { + StringBuilder msg = new StringBuilder(); + msg.append(" param[0] mac:"); + msg.append(mac); + log.warn(msg); + model.setViewName("403"); + return model; + } + } + + @GetMapping("/carTrajectoryNew") + @ApiOperation(value = "���������������������", notes = "���������������������") + @ApiImplicitParams(value = { + @ApiImplicitParam(name = "mac", value = "������mac������������p5dnd7a0392081���", required = true, paramType = "query", dataType = "String"), + @ApiImplicitParam(name = "startTime", value = "������������(���������2020-03-19-14)", required = true, paramType = "query", dataType = "String"), + @ApiImplicitParam(name = "endTime", value = "������������(���������2020-03-19-17)", required = true, paramType = "query", dataType = "String") + }) + public ModelAndView carTrajectoryNew(ModelAndView model, HttpServletRequest request) throws Exception { + Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); + String st = parameters.get("startTime").toString(); + String startYearAndDay = st.substring(0, st.lastIndexOf("-")); + String startHour = st.substring(st.lastIndexOf("-") + 1); + String startTime = startYearAndDay + " " + startHour + ":00:00"; + String et = parameters.get("endTime").toString(); + String endYearAndDay = et.substring(0, st.lastIndexOf("-")); + String endHour = et.substring(et.lastIndexOf("-") + 1); + String endTime = endYearAndDay + " " + endHour + ":00:00"; + parameters.put("startTime", startTime); + parameters.put("endTime", endTime); + String mac = parameters.get("mac").toString(); + if (mac != null && mac.length() != 0) { + List<List<Map<String, Object>>> sensorData = historyService.getCarSensorData(parameters); + Map<String, String> sensorsMap = sensorService.getSensorsMap(parameters); + List<Map<String, Object>> sensorList = new ArrayList<>(); + if (sensorData.size() == 3) { + sensorList = sensorData.get(0); + } + JSONObject params = new JSONObject(); + params.put("sensorInfo", sensorList); + params.put("sensorsMap", sensorsMap); + String paramsJson = params.toJSONString(); + model.addObject("carTrajectoryParams", paramsJson); + model.setViewName("cartrajectoryNew"); return model; } else { StringBuilder msg = new StringBuilder(); @@ -2117,9 +2169,9 @@ @ApiImplicitParam(name = "time", value = "������(���������2020-03-19)", required = true, paramType = "query", dataType = "String")}) public ResultBean<List<Map<String, Object>>> getWeatherNextDayDataByRegion(HttpServletRequest request) throws Exception { Map<String, Object> parameters = getParametersStartingWith(request, null); - List<String> sensorKeys=new ArrayList<>(); + List<String> sensorKeys = new ArrayList<>(); sensorKeys.add("e15"); - parameters.put("sensorKeys",sensorKeys); + parameters.put("sensorKeys", sensorKeys); List<Map<String, Object>> resultList = weatherService.getForecastAndReal(parameters); return new ResultBean<List<Map<String, Object>>>(resultList); } @@ -2132,10 +2184,10 @@ @ApiImplicitParam(name = "time", value = "������(���������2020-03-19)", required = true, paramType = "query", dataType = "String")}) public ResultBean<List<Map<String, Object>>> getForecastAndRealPM(HttpServletRequest request) throws Exception { Map<String, Object> parameters = getParametersStartingWith(request, null); - List<String> sensorKeys=new ArrayList<>(); + List<String> sensorKeys = new ArrayList<>(); sensorKeys.add("e1"); sensorKeys.add("e2"); - parameters.put("sensorKeys",sensorKeys); + parameters.put("sensorKeys", sensorKeys); List<Map<String, Object>> resultList = weatherService.getForecastAndReal(parameters); return new ResultBean<List<Map<String, Object>>>(resultList); } @@ -2641,26 +2693,26 @@ }*/ @PostMapping("insertAdjustValue") - public int insertAdjustValue(@RequestBody HashMap map){ - try{ + public int insertAdjustValue(@RequestBody HashMap map) { + try { int device_id = Integer.parseInt(map.get("id").toString()); String time = map.get("time").toString(); String[] arr = time.split(":"); - int seconds = Integer.parseInt(arr[0])*3600+Integer.parseInt(arr[1])*60+Integer.parseInt(arr[2]); + int seconds = Integer.parseInt(arr[0]) * 3600 + Integer.parseInt(arr[1]) * 60 + Integer.parseInt(arr[2]); //String t = URLEncoder.encode(������,"UTF-8") List list = (List) map.get("dataArray"); - String val=""; - for (int i = 0; i <list.size() ; i++) { - if (i==0){ - val=val+list.get(i); - }else { - val=val+","+list.get(i); + String val = ""; + for (int i = 0; i < list.size(); i++) { + if (i == 0) { + val = val + list.get(i); + } else { + val = val + "," + list.get(i); } } - String value = "{"+val+"}"; - deviceAdjustValueTimingService.insertData(device_id,seconds,value); + String value = "{" + val + "}"; + deviceAdjustValueTimingService.insertData(device_id, seconds, value); return 1; - }catch (Exception e){ + } catch (Exception e) { log.warn(e); } return 0; @@ -2668,34 +2720,34 @@ @RequestMapping("/biaozhun") @ResponseBody - public List<Device> queryDevice(String macOrName){ + public List<Device> queryDevice(String macOrName) { List<Device> deviceList = new ArrayList<>(); - if (!macOrName.equals("")){ - deviceList= deviceService.getDevice(macOrName); + if (!macOrName.equals("")) { + deviceList = deviceService.getDevice(macOrName); } return deviceList; } @RequestMapping("/getBiaoZhun") @ResponseBody - public List<DeviceAdjustValueTiming> getBiaoZhun(String id){ + public List<DeviceAdjustValueTiming> getBiaoZhun(String id) { List<DeviceAdjustValueTiming> dataByDeviceid = deviceAdjustValueTimingService.getDataByDeviceid(Integer.parseInt(id)); for (DeviceAdjustValueTiming deviceAdjustValueTiming : dataByDeviceid) { int seconds = Integer.parseInt(deviceAdjustValueTiming.getSeconds()); - String hour = String.valueOf(seconds/3600); - int millAndSeconds = seconds%3600; - String mill = String.valueOf(millAndSeconds/60); - String second = String.valueOf(millAndSeconds%60); - if (hour.length()<2){ - hour="0"+hour; + String hour = String.valueOf(seconds / 3600); + int millAndSeconds = seconds % 3600; + String mill = String.valueOf(millAndSeconds / 60); + String second = String.valueOf(millAndSeconds % 60); + if (hour.length() < 2) { + hour = "0" + hour; } - if (mill.length()<2){ - mill="0"+mill; + if (mill.length() < 2) { + mill = "0" + mill; } - if (second.length()<2){ - second="0"+second; + if (second.length() < 2) { + second = "0" + second; } - String time = hour+":"+mill+":"+second; + String time = hour + ":" + mill + ":" + second; Map<String, String> value = deviceAdjustValueTiming.getValue(); Collection<String> values = value.values(); deviceAdjustValueTiming.setSeconds(time); @@ -2706,15 +2758,15 @@ @RequestMapping("/getSensor") @ResponseBody - public List<Map<String, Object>> getSensor(String id){ + public List<Map<String, Object>> getSensor(String id) { List<Map<String, Object>> allSensors = sensorService.getSensorByDeviceId(id); return allSensors; } @RequestMapping("/deleteBiaoZhun") @ResponseBody - public int deleteBiaoZhun(String id){ - int i= deviceAdjustValueTimingService.delete(id); + public int deleteBiaoZhun(String id) { + int i = deviceAdjustValueTimingService.delete(id); return i; } @@ -2724,111 +2776,111 @@ @ApiImplicitParams(value = { @ApiImplicitParam(name = "monitorPointIds", value = "������monitorid", required = true, paramType = "query", dataType = "String"), @ApiImplicitParam(name = "time", value = "������(���������2020-03-19)", required = true, paramType = "query", dataType = "String")}) - public ResultBean<List<Map<String,Object>>> monitorAVGData(HttpServletRequest request) throws Exception { + public ResultBean<List<Map<String, Object>>> monitorAVGData(HttpServletRequest request) throws Exception { Map<String, Object> parameters = getParametersStartingWith(request, null); String monitorPointIds = (String) parameters.get("monitorPointIds"); String time = (String) parameters.get("time"); - time = time+" 00:00:00"; + time = time + " 00:00:00"; SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd mm:HH:ss");//���������������MM Date date = simpleDateFormat.parse(time); Calendar calendar = new GregorianCalendar(); calendar.setTime(date); - calendar.add(calendar.DATE,+1); - String date1= simpleDateFormat.format(date); - String date2= simpleDateFormat.format(calendar.getTime()); + calendar.add(calendar.DATE, +1); + String date1 = simpleDateFormat.format(date); + String date2 = simpleDateFormat.format(calendar.getTime()); String[] mIds = monitorPointIds.split(","); - List<List<Map<String,Object>>> lists = new ArrayList<>(); - if (mIds.length==1 && mIds.length!=0){ + List<List<Map<String, Object>>> lists = new ArrayList<>(); + if (mIds.length == 1 && mIds.length != 0) { String mId = mIds[0]; - List<Map<String,Object>> dataAvbByMIdAndTime = historyHourlyService.getDataAvbByMIdAndTime(mId, date1, date2); + List<Map<String, Object>> dataAvbByMIdAndTime = historyHourlyService.getDataAvbByMIdAndTime(mId, date1, date2); Double maxO3 = Double.parseDouble(dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 1).get("maxO3").toString()); - Map<String,Object> dailyAvgData =new HashMap<>(); - if (dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 2).get("data")!=""){ + Map<String, Object> dailyAvgData = new HashMap<>(); + if (dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 2).get("data") != "") { dailyAvgData = (Map<String, Object>) dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 2).get("data"); - dailyAvgData.put("maxO3_8h",new BigDecimal(maxO3).setScale(0,BigDecimal.ROUND_HALF_UP).doubleValue()); - }else { - dailyAvgData= historyHourlyService.getAvgDataByMId(mId, date1, date2); - if (dailyAvgData!=null){ - dailyAvgData.put("maxO3_8h",new BigDecimal(maxO3).setScale(0,BigDecimal.ROUND_HALF_UP).doubleValue()); - }else { + dailyAvgData.put("maxO3_8h", new BigDecimal(maxO3).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue()); + } else { + dailyAvgData = historyHourlyService.getAvgDataByMId(mId, date1, date2); + if (dailyAvgData != null) { + dailyAvgData.put("maxO3_8h", new BigDecimal(maxO3).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue()); + } else { dailyAvgData = new HashMap<>(); - dailyAvgData.put("PM2_5",""); - dailyAvgData.put("NO2",""); - dailyAvgData.put("SO2",""); - dailyAvgData.put("PM10",""); - dailyAvgData.put("O3_day",""); - dailyAvgData.put("CO",""); + dailyAvgData.put("PM2_5", ""); + dailyAvgData.put("NO2", ""); + dailyAvgData.put("SO2", ""); + dailyAvgData.put("PM10", ""); + dailyAvgData.put("O3_day", ""); + dailyAvgData.put("CO", ""); } } dataAvbByMIdAndTime.remove(dataAvbByMIdAndTime.size() - 1); dataAvbByMIdAndTime.remove(dataAvbByMIdAndTime.size() - 1); - Map<String,Object> dayMap = new HashMap<>(); - dayMap.put("data",dailyAvgData); - dayMap.put("time",date1.substring(0,11)); + Map<String, Object> dayMap = new HashMap<>(); + dayMap.put("data", dailyAvgData); + dayMap.put("time", date1.substring(0, 11)); dataAvbByMIdAndTime.add(dayMap); - for (int i = 0; i <dataAvbByMIdAndTime.size() ; i++) { - if (i!=dataAvbByMIdAndTime.size()-1){ + for (int i = 0; i < dataAvbByMIdAndTime.size(); i++) { + if (i != dataAvbByMIdAndTime.size() - 1) { Map<String, Object> map1 = AQICalculation2.hourlyAQI((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")); - if (Double.parseDouble(map1.get("AQI").toString())>50.0){ - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants",map1.get("maxSensor")); - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI",map1.get("AQI")); - }else { - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants","-"); - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI",map1.get("AQI")); + if (Double.parseDouble(map1.get("AQI").toString()) > 50.0) { + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants", map1.get("maxSensor")); + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI", map1.get("AQI")); + } else { + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants", "-"); + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI", map1.get("AQI")); } - }else { + } else { Map<String, Object> map1 = AQICalculation2.dayAQI((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")); - if (map1.get("AQI").toString().equals("")){ + if (map1.get("AQI").toString().equals("")) { break; } - if (Double.parseDouble(map1.get("AQI").toString())>50.0){ - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants",map1.get("maxSensor")); - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI",map1.get("AQI")); - }else { - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants","-"); - ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI",map1.get("AQI")); - } + if (Double.parseDouble(map1.get("AQI").toString()) > 50.0) { + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants", map1.get("maxSensor")); + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI", map1.get("AQI")); + } else { + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("primary_pollutants", "-"); + ((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data")).put("AQI", map1.get("AQI")); + } } } List timeList = new ArrayList(); for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) { timeList.add(dataAvbByMIdAndTime.get(q).get("time")); } - if (dataAvbByMIdAndTime.size()<25){ + if (dataAvbByMIdAndTime.size() < 25) { for (int j = 1; j < 25; j++) { - Map<String,Object> map = null; + Map<String, Object> map = null; for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) { - if (dataAvbByMIdAndTime.get(q).get("time").toString().length() > 2){ + if (dataAvbByMIdAndTime.get(q).get("time").toString().length() > 2) { continue; - }else { + } else { // System.out.println(Integer.parseInt(dataAvbByMIdAndTime.get(q).get("time").toString())+"==="+j); - String sj=""; - if (j<10){ - sj="0"+j; - }else { - if (j==24){ - sj="00"; - }else { - sj=""+j; + String sj = ""; + if (j < 10) { + sj = "0" + j; + } else { + if (j == 24) { + sj = "00"; + } else { + sj = "" + j; } } - if (!timeList.contains(sj)){ + if (!timeList.contains(sj)) { map = new HashMap<>(); - map.put("time",sj); + map.put("time", sj); Map map1 = new HashMap(); - map1.put("PM2_5",""); - map1.put("NO2",""); - map1.put("primary_pollutants","-"); - map1.put("SO2",""); - map1.put("O3",""); - map1.put("PM10",""); - map1.put("O3_8h",""); - map1.put("CO",""); - map1.put("AQI",""); - map.put("data",map1); + map1.put("PM2_5", ""); + map1.put("NO2", ""); + map1.put("primary_pollutants", "-"); + map1.put("SO2", ""); + map1.put("O3", ""); + map1.put("PM10", ""); + map1.put("O3_8h", ""); + map1.put("CO", ""); + map1.put("AQI", ""); + map.put("data", map1); dataAvbByMIdAndTime.add(map); break; - }else { + } else { break; } } @@ -2838,93 +2890,93 @@ /* for (int i1 = 0; i1 < dataAvbByMIdAndTime.size(); i1++) { System.out.println(dataAvbByMIdAndTime.get(i1)); }*/ - Collections.sort(dataAvbByMIdAndTime, new Comparator<Map<String, Object>>(){ + Collections.sort(dataAvbByMIdAndTime, new Comparator<Map<String, Object>>() { public int compare(Map<String, Object> o1, Map<String, Object> o2) { - String name1 =(String)o1.get("time");//name1���������list������������������������ - String name2= (String)o2.get("time"); //name1���������list���������������������������name + String name1 = (String) o1.get("time");//name1���������list������������������������ + String name2 = (String) o2.get("time"); //name1���������list���������������������������name return name1.compareTo(name2); } }); Map map1 = dataAvbByMIdAndTime.get(0); dataAvbByMIdAndTime.remove(0); dataAvbByMIdAndTime.add(map1); - for (int j = 0; j <dataAvbByMIdAndTime.size() ; j++) { - if (dataAvbByMIdAndTime.get(j).get("time").toString().length()>2){ + for (int j = 0; j < dataAvbByMIdAndTime.size(); j++) { + if (dataAvbByMIdAndTime.get(j).get("time").toString().length() > 2) { Map map2 = dataAvbByMIdAndTime.get(j); dataAvbByMIdAndTime.remove(j); dataAvbByMIdAndTime.add(map2); } } - if (dataAvbByMIdAndTime.size()==1){ - dataAvbByMIdAndTime=null; + if (dataAvbByMIdAndTime.size() == 1) { + dataAvbByMIdAndTime = null; } lists.add(dataAvbByMIdAndTime); //List<Device> devicesByMonitorPointId = deviceService.getDevicesByMonitorPointId(Integer.valueOf(mId)); - }else { - for (int i = 0; i <mIds.length ; i++) { - List<Map<String,Object>> dataAvbByMIdAndTime = historyHourlyService.getDataAvbByMIdAndTime(mIds[i], date1, date2); + } else { + for (int i = 0; i < mIds.length; i++) { + List<Map<String, Object>> dataAvbByMIdAndTime = historyHourlyService.getDataAvbByMIdAndTime(mIds[i], date1, date2); Double maxO3 = Double.parseDouble(dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 1).get("maxO3").toString()); - Map<String,Object> dailyAvgData =new HashMap<>(); - if (dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 2).get("data")!=""){ + Map<String, Object> dailyAvgData = new HashMap<>(); + if (dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 2).get("data") != "") { dailyAvgData = (Map<String, Object>) dataAvbByMIdAndTime.get(dataAvbByMIdAndTime.size() - 2).get("data"); - dailyAvgData.put("maxO3_8h",new BigDecimal(maxO3).setScale(0,BigDecimal.ROUND_HALF_UP).doubleValue()); - }else { - dailyAvgData= historyHourlyService.getAvgDataByMId(mIds[i], date1, date2); - if (dailyAvgData!=null){ - dailyAvgData.put("maxO3_8h",new BigDecimal(maxO3).setScale(0,BigDecimal.ROUND_HALF_UP).doubleValue()); - }else { + dailyAvgData.put("maxO3_8h", new BigDecimal(maxO3).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue()); + } else { + dailyAvgData = historyHourlyService.getAvgDataByMId(mIds[i], date1, date2); + if (dailyAvgData != null) { + dailyAvgData.put("maxO3_8h", new BigDecimal(maxO3).setScale(0, BigDecimal.ROUND_HALF_UP).doubleValue()); + } else { dailyAvgData = new HashMap<>(); - dailyAvgData.put("PM2_5",""); - dailyAvgData.put("NO2",""); - dailyAvgData.put("SO2",""); - dailyAvgData.put("PM10",""); - dailyAvgData.put("O3_day",""); - dailyAvgData.put("CO",""); + dailyAvgData.put("PM2_5", ""); + dailyAvgData.put("NO2", ""); + dailyAvgData.put("SO2", ""); + dailyAvgData.put("PM10", ""); + dailyAvgData.put("O3_day", ""); + dailyAvgData.put("CO", ""); } } dataAvbByMIdAndTime.remove(dataAvbByMIdAndTime.size() - 1); dataAvbByMIdAndTime.remove(dataAvbByMIdAndTime.size() - 1); - Map<String,Object> dayMap = new HashMap<>(); - dayMap.put("data",dailyAvgData); - dayMap.put("time",date1.substring(0,11)); + Map<String, Object> dayMap = new HashMap<>(); + dayMap.put("data", dailyAvgData); + dayMap.put("time", date1.substring(0, 11)); dataAvbByMIdAndTime.add(dayMap); List timeList = new ArrayList(); for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) { timeList.add(dataAvbByMIdAndTime.get(q).get("time")); } - if (dataAvbByMIdAndTime.size()<25){ + if (dataAvbByMIdAndTime.size() < 25) { for (int j = 1; j < 25; j++) { - Map<String,Object> map = null; + Map<String, Object> map = null; for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) { - if (dataAvbByMIdAndTime.get(q).get("time").toString().length() > 2){ + if (dataAvbByMIdAndTime.get(q).get("time").toString().length() > 2) { continue; - }else { - // System.out.println(Integer.parseInt(dataAvbByMIdAndTime.get(q).get("time").toString())+"==="+j); - String sj=""; - if (j<10){ - sj="0"+j; - }else { - if (j==24){ - sj="00"; - }else { - sj=""+j; + } else { + // System.out.println(Integer.parseInt(dataAvbByMIdAndTime.get(q).get("time").toString())+"==="+j); + String sj = ""; + if (j < 10) { + sj = "0" + j; + } else { + if (j == 24) { + sj = "00"; + } else { + sj = "" + j; } } - if (!timeList.contains(sj)){ + if (!timeList.contains(sj)) { map = new HashMap<>(); - map.put("time",sj); + map.put("time", sj); Map map1 = new HashMap(); - map1.put("PM2_5",""); - map1.put("NO2",""); - map1.put("SO2",""); - map1.put("O3",""); - map1.put("PM10",""); - map1.put("O3_8h",""); - map1.put("CO",""); - map.put("data",map1); + map1.put("PM2_5", ""); + map1.put("NO2", ""); + map1.put("SO2", ""); + map1.put("O3", ""); + map1.put("PM10", ""); + map1.put("O3_8h", ""); + map1.put("CO", ""); + map.put("data", map1); dataAvbByMIdAndTime.add(map); break; - }else { + } else { break; } } @@ -2932,18 +2984,18 @@ } } - Collections.sort(dataAvbByMIdAndTime, new Comparator<Map<String, Object>>(){ + Collections.sort(dataAvbByMIdAndTime, new Comparator<Map<String, Object>>() { public int compare(Map<String, Object> o1, Map<String, Object> o2) { - String name1 =(String)o1.get("time");//name1���������list������������������������ - String name2= (String)o2.get("time"); //name1���������list���������������������������name + String name1 = (String) o1.get("time");//name1���������list������������������������ + String name2 = (String) o2.get("time"); //name1���������list���������������������������name return name1.compareTo(name2); } }); Map map1 = dataAvbByMIdAndTime.get(0); dataAvbByMIdAndTime.remove(0); dataAvbByMIdAndTime.add(map1); - for (int j = 0; j <dataAvbByMIdAndTime.size() ; j++) { - if (dataAvbByMIdAndTime.get(j).get("time").toString().length()>2){ + for (int j = 0; j < dataAvbByMIdAndTime.size(); j++) { + if (dataAvbByMIdAndTime.get(j).get("time").toString().length() > 2) { Map map2 = dataAvbByMIdAndTime.get(j); dataAvbByMIdAndTime.remove(j); dataAvbByMIdAndTime.add(map2); @@ -2954,20 +3006,20 @@ List<Map<String, Object>> dataByMonitorPoints = historyHourlyService.getDataByMonitorPoints(mIds, date1, date2); lists.add(dataByMonitorPoints); } - List<Map<String, Object>> rList =new ArrayList<>(); - if (lists.size()==1 && lists.get(0)!=null){ + List<Map<String, Object>> rList = new ArrayList<>(); + if (lists.size() == 1 && lists.get(0) != null) { for (int i = 0; i < lists.get(0).size(); i++) { List list = new ArrayList(); list.add(lists.get(0).get(i).get("data")); Map map = new HashMap(); - map.put("data",list); - map.put("time",lists.get(0).get(i).get("time")); + map.put("data", list); + map.put("time", lists.get(0).get(i).get("time")); rList.add(map); } - } else if (lists.size()==1 && lists.get(0)==null){ + } else if (lists.size() == 1 && lists.get(0) == null) { rList.add(null); - }else { + } else { for (int j = 0; j < lists.get(0).size(); j++) { Map<String, Object> listMap = new HashMap(); List<Map> mapList = new ArrayList<>(); @@ -2991,12 +3043,12 @@ rList.add(listMap); } } - return new ResultBean<List<Map<String,Object>>>(rList); + return new ResultBean<List<Map<String, Object>>>(rList); } @PostMapping("byAccountGetDevices") public List<Device> byAccountGetDevices(@RequestBody Map<String, Object> parameters) { - String id =parameters.get("id").toString(); + String id = parameters.get("id").toString(); List<Device> devicesList = deviceService.getDevicesByAccountId(id); return devicesList; } @@ -3006,6 +3058,7 @@ @ApiImplicitParams(value = { @ApiImplicitParam(name = "monitorPointId", value = "������Id", required = true, paramType = "query", dataType = "String"), @ApiImplicitParam(name = "sensorKey", value = "������", required = true, paramType = "query", dataType = "String"), + @ApiImplicitParam(name = "realTime", value = "������", required = true, paramType = "query", dataType = "String"), @ApiImplicitParam(name = "accountId", value = "������id", required = false, paramType = "query", dataType = "String")}) public ModelAndView unorganizedEmissionsBackupsV2(HttpServletRequest request, ModelAndView model) { Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null); @@ -3015,156 +3068,164 @@ //��������������������������� List<Device> deviceList = deviceService.getDevicesByMonitorPointId(539); //��������������������� - Map<String,Object> pa = new HashMap<>(); + Map<String, Object> pa = new HashMap<>(); + //��������������������������������� + SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + Calendar beforeTime = Calendar.getInstance(); + Date newTime = beforeTime.getTime(); + beforeTime.add(Calendar.MINUTE, -5); + Date startTime = beforeTime.getTime(); + beforeTime.add(Calendar.MINUTE, 6); + Date endTime = beforeTime.getTime(); //pa.put("sensorKey","e1"); - pa.put("yearAndMonth","202012"); - pa.put("time","2020-12-03 10:10:00"); + pa.put("yearAndMonth", sdf.format(newTime).substring(0, 7).replace("-", "")); + pa.put("startTime", startTime); + pa.put("endTime", endTime); List<String> macs = new ArrayList<>(); List<String> sensorKeys = new ArrayList<>(); - for (Device device:deviceList) { + for (Device device : deviceList) { macs.add(device.getMac()); } sensorKeys.add(sensorKey); sensorKeys.add("e18"); sensorKeys.add("e23"); - pa.put("macs",macs); - pa.put("sensorKeys",sensorKeys); - List<Map<String, Object>> fiveMinuteDataList = historyFiveMinutelyService.getFiveMinutesSersorDataByMacsAndTime(pa); + pa.put("macs", macs); + pa.put("sensorKeys", sensorKeys); + pa.put("macNumber", macs.size()); + List<Map<String, Object>> fiveMinuteDataList = historyFiveMinutelyService.getFiveMinutesDataByMacsAndTimeSolt(pa); //������������������������������������������ double[] allDeviceData = new double[fiveMinuteDataList.size()]; - System.out.println(fiveMinuteDataList); int i = 0; //������������ - List<Map<String,Object>> windList = new ArrayList<>(); - for (Map map:fiveMinuteDataList) { + List<Map<String, Object>> windList = new ArrayList<>(); + for (Map map : fiveMinuteDataList) { String[] wind_speed = map.get("e18").toString().split(","); + if (!map.containsKey("e23")) { + continue; + } String[] wind_direction = map.get("e23").toString().split(","); - Map<String,Object> windMap = new HashMap<>(); - windMap.put("wind_speed",wind_speed[0].substring(1,wind_speed[0].length())); - windMap.put("wind_direction",wind_direction[0].substring(1,wind_direction[0].length())); + Map<String, Object> windMap = new HashMap<>(); + windMap.put("wind_speed", wind_speed[0].substring(1, wind_speed[0].length())); + windMap.put("wind_direction", wind_direction[0].substring(1, wind_direction[0].length())); windList.add(windMap); String[] sensorArr = map.get(sensorKey).toString().split(","); - double sensorData = Double.parseDouble(sensorArr[0].substring(1,sensorArr[0].length())); + double sensorData = Double.parseDouble(sensorArr[0].substring(1, sensorArr[0].length())); allDeviceData[i] = sensorData; - i = i+1; + i = i + 1; } //��������������������������� - Map<String,Double> res = WindUtils.getWind_direction_speed(windList); + Map<String, Double> res = WindUtils.getWind_direction_speed(windList); //��������������������������������������������� - Map<String,Double> angleMap = new HashMap(); - MyLatLng pollutionSourcePoint_log_lat = new MyLatLng(pollutionSourcePoint.getLongitude(),pollutionSourcePoint.getLatitude()); - for (Device device:deviceList) { - MyLatLng device_log_lat = new MyLatLng(device.getLongitude(),device.getLatitude()); + Map<String, Double> angleMap = new HashMap(); + MyLatLng pollutionSourcePoint_log_lat = new MyLatLng(pollutionSourcePoint.getLongitude(), pollutionSourcePoint.getLatitude()); + for (Device device : deviceList) { + MyLatLng device_log_lat = new MyLatLng(device.getLongitude(), device.getLatitude()); //������������������������������������������������������ - double angle = mapUtils.getAngle(device_log_lat,pollutionSourcePoint_log_lat); - angleMap.put(device.getMac(),angle); + double angle = mapUtils.getAngle(device_log_lat, pollutionSourcePoint_log_lat); + angleMap.put(device.getMac(), angle); } - Map<String,Double> disparityMap = new HashMap<>(); - for (String key:angleMap.keySet()) { - double angleDisparity = Math.abs(angleMap.get(key)-res.get("wind_direction")); - if (angleDisparity>180){ - angleDisparity = 360-angleDisparity; + Map<String, Double> disparityMap = new HashMap<>(); + for (String key : angleMap.keySet()) { + double angleDisparity = Math.abs(angleMap.get(key) - res.get("wind_direction")); + if (angleDisparity > 180) { + angleDisparity = 360 - angleDisparity; } - disparityMap.put(key,angleDisparity); + disparityMap.put(key, angleDisparity); } Optional<Map.Entry<String, Double>> minDisparity = disparityMap.entrySet() .stream() .min(Map.Entry.comparingByValue()); //������������������������disparityMap������������minDisparity���������������key������������������������������������������ List<String> minAngleDisparityMacList = new ArrayList<>(); - for (String key:disparityMap.keySet()) { - if (disparityMap.get(key) == minDisparity.get().getValue()){ + for (String key : disparityMap.keySet()) { + if (disparityMap.get(key) == minDisparity.get().getValue()) { minAngleDisparityMacList.add(minDisparity.get().getKey()); } } //������������map������������������ - Map<String,Object> fiveMinuteDataMap = new HashMap(); - if (minAngleDisparityMacList.size()<2){//��������������� - for (Map fiveMinuteData:fiveMinuteDataList) { - if (fiveMinuteData.get("mac").toString().equals(minAngleDisparityMacList.get(0))){ + Map<String, Object> fiveMinuteDataMap = new HashMap(); + if (minAngleDisparityMacList.size() < 2) {//��������������� + for (Map fiveMinuteData : fiveMinuteDataList) { + if (fiveMinuteData.get("mac").toString().equals(minAngleDisparityMacList.get(0))) { fiveMinuteDataMap.putAll(fiveMinuteData); break; } } - }else { + } else { } Device referenceDevice = new Device(); - for (Device device:deviceList) { - if (device.getMac().equals(fiveMinuteDataMap.get("mac"))){ + for (Device device : deviceList) { + if (device.getMac().equals(fiveMinuteDataMap.get("mac"))) { referenceDevice = device; } } //��������������������� double sum = 0; - for (int j=0;j<allDeviceData.length;j++) { - sum = sum+allDeviceData[j]; + for (int j = 0; j < allDeviceData.length; j++) { + sum = sum + allDeviceData[j]; } - double deviceDataAvg = sum/allDeviceData.length; + double deviceDataAvg = sum / allDeviceData.length; //��������������������������������������������� - double distance = mapUtils.getDistance(pollutionSourcePoint.getLongitude(),pollutionSourcePoint.getLatitude(),referenceDevice.getLongitude(),referenceDevice.getLatitude()); + double distance = mapUtils.getDistance(pollutionSourcePoint.getLongitude(), pollutionSourcePoint.getLatitude(), referenceDevice.getLongitude(), referenceDevice.getLatitude()); //���������������������������x,y - double x = Math.cos(minDisparity.get().getValue())*distance; - double y = Math.sin(minDisparity.get().getValue())*distance; + double x = Math.cos(Math.toRadians(minDisparity.get().getValue())) * distance; + double y = Math.sin(Math.toRadians(minDisparity.get().getValue())) * distance; //��������������������� - String[] fiveMinuteData = fiveMinuteDataMap.get("e21").toString().split(","); - double c = Double.parseDouble(fiveMinuteData[0].substring(1,fiveMinuteData[0].length()))-deviceDataAvg; - System.out.println(c); + String[] fiveMinuteData = fiveMinuteDataMap.get(sensorKey).toString().split(","); + double c = Double.parseDouble(fiveMinuteData[0].substring(1, fiveMinuteData[0].length())) - deviceDataAvg; //������������ - double pollutionSourceIntensity = EmissionDataUtil.getPollutionSourceIntensity(c,x,y,res.get("wind_speed")); - System.out.println(pollutionSourceIntensity); + double pollutionSourceIntensity = EmissionDataUtil.getPollutionSourceIntensity(c, x, y, res.get("wind_speed")); //��������������������� - Map<String,Object> center = new HashMap<>(); - center.put("lng",120.997119); - center.put("lat",31.451714); + Map<String, Object> center = new HashMap<>(); + center.put("lng", 120.997119); + center.put("lat", 31.451714); //������������������������������������ - List<Map<String,Double>> numericalValueList = new ArrayList<>(); - Map<String,Double> numericalValueMap = new HashMap<>(); - numericalValueMap.put("lng",120.997119); - numericalValueMap.put("lat",31.451714); - numericalValueMap.put("count",0.027); + List<Map<String, Double>> numericalValueList = new ArrayList<>(); + Map<String, Double> numericalValueMap = new HashMap<>(); + numericalValueMap.put("lng", 120.997119); + numericalValueMap.put("lat", 31.451714); + numericalValueMap.put("count", 0.027); numericalValueList.add(numericalValueMap); - Map<String,Double> numericalValueMap2 = new HashMap<>(); - numericalValueMap2.put("lng",120.99516); - numericalValueMap2.put("lat",31.448664); - numericalValueMap2.put("count",0.029); + Map<String, Double> numericalValueMap2 = new HashMap<>(); + numericalValueMap2.put("lng", 120.99516); + numericalValueMap2.put("lat", 31.448664); + numericalValueMap2.put("count", 0.029); numericalValueList.add(numericalValueMap2); - Map<String,Double> numericalValueMap3 = new HashMap<>(); - numericalValueMap3.put("lng",120.998538); - numericalValueMap3.put("lat",31.449289); - numericalValueMap3.put("count",0.033); + Map<String, Double> numericalValueMap3 = new HashMap<>(); + numericalValueMap3.put("lng", 120.998538); + numericalValueMap3.put("lat", 31.449289); + numericalValueMap3.put("count", 0.033); numericalValueList.add(numericalValueMap3); - Map<String,Double> numericalValueMap4 = new HashMap<>(); - numericalValueMap4.put("lng",120.998628); - numericalValueMap4.put("lat",31.452027); - numericalValueMap4.put("count",0.025); + Map<String, Double> numericalValueMap4 = new HashMap<>(); + numericalValueMap4.put("lng", 120.998628); + numericalValueMap4.put("lat", 31.452027); + numericalValueMap4.put("count", 0.025); numericalValueList.add(numericalValueMap4); - Map<String,Double> numericalValueMap5 = new HashMap<>(); - numericalValueMap5.put("lng",121.000383); - numericalValueMap5.put("lat",31.451469); - numericalValueMap5.put("count",0.05); + Map<String, Double> numericalValueMap5 = new HashMap<>(); + numericalValueMap5.put("lng", 121.000383); + numericalValueMap5.put("lat", 31.451469); + numericalValueMap5.put("count", 0.05); numericalValueList.add(numericalValueMap5); - Map<String,Double> numericalValueMap6 = new HashMap<>(); - numericalValueMap6.put("lng",120.999908); - numericalValueMap6.put("lat",31.449389); - numericalValueMap6.put("count",0.04); + Map<String, Double> numericalValueMap6 = new HashMap<>(); + numericalValueMap6.put("lng", 120.999908); + numericalValueMap6.put("lat", 31.449389); + numericalValueMap6.put("count", 0.04); numericalValueList.add(numericalValueMap6); - Map<String,Double> numericalValueMap7 = new HashMap<>(); - numericalValueMap7.put("lng",120.998519); - numericalValueMap7.put("lat",31.450588); - numericalValueMap7.put("count",0.10); + Map<String, Double> numericalValueMap7 = new HashMap<>(); + numericalValueMap7.put("lng", 120.998519); + numericalValueMap7.put("lat", 31.450588); + numericalValueMap7.put("count", 0.10); numericalValueList.add(numericalValueMap7); - System.out.println(numericalValueList.toString()); JSONObject params = new JSONObject(); - params.put("accountId",190); - params.put("level",17); - params.put("center",center); - params.put("points",numericalValueList); - + params.put("accountId", 190); + params.put("level", 17); + params.put("center", center); + params.put("points", numericalValueList); //������������������ -- Gitblit v1.8.0