From b6b10b7d89092147ebd5ae1d3cc318205206ab8a Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Fri, 18 Dec 2020 14:48:03 +0800
Subject: [PATCH] 走航车轨迹区域数据显示
---
src/main/java/com/moral/controller/ScreenController.java | 1208 ++++++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 1,109 insertions(+), 99 deletions(-)
diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java
index 7ed77d4..e34c786 100644
--- a/src/main/java/com/moral/controller/ScreenController.java
+++ b/src/main/java/com/moral/controller/ScreenController.java
@@ -2,8 +2,11 @@
import java.io.*;
import java.lang.reflect.Array;
+import java.math.BigDecimal;
+import java.net.URLEncoder;
import java.text.DateFormat;
import java.text.DecimalFormat;
+import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
@@ -17,6 +20,7 @@
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
+import com.fasterxml.jackson.databind.ObjectMapper;
import com.googlecode.aviator.AviatorEvaluator;
import com.googlecode.aviator.Expression;
import com.moral.common.bean.Constants;
@@ -34,17 +38,21 @@
import com.moral.entity.alarm.AlarmSensorLevel;
import com.moral.entity.charts.DataSortCondition;
import com.moral.entity.layout.RealTimeDeviceLayout;
+import com.moral.mapper.HistoryMapper;
import com.moral.service.*;
import com.moral.util.*;
import com.rabbitmq.client.*;
import com.rabbitmq.client.Channel;
+
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
+import io.swagger.models.auth.In;
import jdk.nashorn.internal.runtime.regexp.joni.Regex;
import net.sf.json.JSONString;
+
import org.apache.commons.collections.CollectionUtils;
import org.apache.commons.collections.MapUtils;
import org.apache.commons.net.ftp.FTPClient;
@@ -69,6 +77,7 @@
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;
import org.xml.sax.InputSource;
+
import static com.moral.common.util.ResourceUtil.getValue;
import static com.moral.common.util.WebUtils.getParametersStartingWith;
import static java.util.Calendar.*;
@@ -83,6 +92,9 @@
@Api(tags = "Screen", description = "������������")
public class ScreenController {
public static Logger log = Logger.getLogger(ScreenController.class);
+
+ @Resource
+ private HistoryMapper historyMapper;
@Resource
AlarmConfigService alarmConfigService;
@Resource
@@ -159,6 +171,20 @@
@Resource
private QualityDailyService qualityDailyService;
+ @Resource
+ private DeviceRoadService deviceRoadService;
+
+ @Resource
+ private ScreenVersionService screenVersionService;
+
+ @Resource
+ private DeviceAdjustValueTimingService deviceAdjustValueTimingService;
+
+ @Resource
+ private PollutioSourcePointService pollutioSourcePointService;
+
+ @Resource
+ private HistoryFiveMinutelyService historyFiveMinutelyService;
/**
* Screen login. ������������
@@ -677,37 +703,78 @@
/*
- * ���������monitorPoint=368&mac=p5dnd7a0392018&sensorKey=e92&time=2020-08-11
- * ���������������������������
- * */
+ * ���������monitorPoint=368&mac=p5dnd7a0392018&sensorKey=e92&time=2020-08-11
+ * ���������������������������
+ * */
@GetMapping("report_avg_datas")
public ResultBean<List<Map<String, Object>>> getMonitorPointOrDeviceAvgData(HttpServletRequest request)
throws Exception {
Map<String, Object> parameters = getParametersStartingWith(request, null);
+ //������������������������������������������������
ParameterUtils.getTimeType4Time(parameters);
- String time1= (String) parameters.get("time");
- String mac1= (String) parameters.get("mac");
- List<Map<String, Object>> list=null;
- if (mac1.equals("p5dnd7a0392018") && time1.substring(0,4).equals("2019") ){
- list=null;
- }else {
+ String time1 = (String) parameters.get("time");
+ time1 = time1.replaceAll(" ", "");
+ 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")) {
+ list = null;
+ } else {
parameters.put("monitorPointId", parameters.remove("monitorPoint"));
Object sensorKey = parameters.remove("sensorKey");
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-------------------------------------------------------------------------*/
+ 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
+ time1 = time1 + " 00:00:00";
+ Date date = sdf.parse(time1);
+ date = DateUtil.rollDay(date, 1);
+ //������������������������
+ String time2 = sdf2.format(date);
+ 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");
+ 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);
map.put("time", Integer.valueOf(time));
- if (parameters.get("type").equals("day")) {
+ /* if (parameters.get("type").equals("day")) {
map.put("time", Integer.valueOf(time) + 1);
- }
+ }*/
map.put("value", map.remove(sensorKey));
}
}
return new ResultBean<List<Map<String, Object>>>(list);
}
+
@GetMapping("report_alarm_datas")
public ResultBean<List<Map<String, Object>>> getAlarmData(HttpServletRequest request) throws Exception {
@@ -855,7 +922,6 @@
List<Map<String, Object>> monitorList = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters);
List<Map<String, Object>> areaList = hangzhouAqiService.getAreaAvgDataByAreaCode(parameters);
-
if (areaList.isEmpty() && monitorList.isEmpty()) {
return new ResultBean<List<Map<String, Object>>>(resultList);
} else if (areaList.isEmpty()) {
@@ -1052,7 +1118,41 @@
public ResultBean<List<MonitorPoint>> getMonitorPointsAndDevicesByRegion(HttpServletRequest request)
throws Exception {
Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ String regionCode = parameters.get("regionCode").toString();
List<MonitorPoint> monitorPoints = monitorPointService.getMonitorPointsAndDevicesByRegion(parameters);
+
+ //������������������������������
+ if (regionCode.startsWith("1309")) {
+ List<Integer> orgIds = new ArrayList<>();
+ Collections.addAll(orgIds, 60, 65, 159, 165, 166);
+ Iterator<MonitorPoint> iter = monitorPoints.iterator();
+ while (iter.hasNext()) {
+ MonitorPoint next = iter.next();
+ Integer mpId = next.getId();
+ Integer orgId = next.getOrganizationId();
+ if (!orgIds.contains(orgId)) {
+ iter.remove();
+ } else {
+ if (orgId == 60) {
+ if (mpId != 56) {
+ iter.remove();
+ }
+ } else if (orgId == 65) {
+ if (mpId != 83 && mpId != 84) {
+ iter.remove();
+ }
+ }
+ }
+ }
+ }
+
+ //������������monitorPoint������������������device.getName()������������
+ for (MonitorPoint monitorPoint : monitorPoints) {
+ List<Device> deviceList = monitorPoint.getDevices();
+ deviceList.sort((Device o1, Device o2) -> {
+ return o1.getName().compareTo(o2.getName());
+ });
+ }
return new ResultBean<List<MonitorPoint>>(monitorPoints);
}
@@ -1406,12 +1506,13 @@
public ModelAndView pollutionSource(ModelAndView model, HttpServletRequest request) throws Exception {
Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
String timeStr = parameters.get("time").toString();
- String YearAndDay = timeStr.substring(0, timeStr.lastIndexOf("-"));
+ String yearAndDay = timeStr.substring(0, timeStr.lastIndexOf("-"));
String Hour = timeStr.substring(timeStr.lastIndexOf("-") + 1);
- String time = YearAndDay + " " + Hour + ":00:00";
+ String time = yearAndDay + " " + Hour + ":00:00";
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);
Point dirPoint = historyHourlyService.getDirPoint(parameters);
Map<String, Object> getPollutionSourceData = historyHourlyService.getPollutionSourceDataByHour(parameters);
if (MapUtils.isEmpty(getPollutionSourceData)) {
@@ -1497,7 +1598,7 @@
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";
+ String endTime = endYearAndDay + " " + endHour + ":00:00";
/* int endHourValue = Integer.valueOf(endHour);
int startHourValue = Integer.valueOf(startHour);
if (endHourValue <= startHourValue) {
@@ -1521,6 +1622,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();
@@ -1610,6 +1755,7 @@
@RequestMapping(value = "/newMap-page", method = RequestMethod.GET)
public ModelAndView newMap(ModelAndView model, @RequestParam("areaCode") long code,
@RequestParam("accountId") int accountId) {
+
Account account = accountService.getAccountById(accountId);
List<MonitorPoint> monitorPointList = monitorPointService.getMonitorPointListByAccountId(accountId);
String regionName = areaService.queryFullNameByCode(code);
@@ -1908,8 +2054,8 @@
if (minAngle > (Double) longAndLatiList.get(j).get("angle")) {
minAngle = (Double) longAndLatiList.get(j).get("angle");
indexAngle = j;
- }else {
- indexAngle=indexAngle;
+ } else {
+ indexAngle = indexAngle;
}
}
preAngleDeviceList.add(deviceList.get((Integer) longAndLatiList.get(indexAngle).get("h")));
@@ -1947,32 +2093,31 @@
@GetMapping("/allDevice")
@ResponseBody
- public Map<String,List> getAllDevice() {
- List<String> macList=deviceService.getAllMac();
- Map<String,List> latlngMap=new HashMap<String,List>();
- Map devMap=null;
- List list=new ArrayList();
+ public Map<String, List> getAllDevice() {
+ List<String> macList = deviceService.getAllMac();
+ Map<String, List> latlngMap = new HashMap<String, List>();
+ Map devMap = null;
+ List list = new ArrayList();
for (String mac : macList) {
- devMap=new HashMap();
- if (mac!=null){
- Device device=deviceService.byMacGetDevice(mac);
- List list1= LatLngTransformation.Convert_BD09_To_GCJ02(device.getLatitude(),device.getLongitude());
- if (device.getState()!=4+""){
- devMap.put("state",device.getState());
+ devMap = new HashMap();
+ if (mac != null) {
+ Device device = deviceService.byMacGetDevice(mac);
+ List list1 = LatLngTransformation.Convert_BD09_To_GCJ02(device.getLatitude(), device.getLongitude());
+ if (device.getState() != 4 + "") {
+ devMap.put("state", device.getState());
}
- devMap.put("lat",list1.get(1));
- devMap.put("lng",list1.get(0));
- devMap.put("monitorPointId",device.getMonitorPointId());
+ devMap.put("lat", list1.get(1));
+ devMap.put("lng", list1.get(0));
+ devMap.put("monitorPointId", device.getMonitorPointId());
//System.out.println(device);
list.add(devMap);
- }else {
+ } else {
continue;
}
}
- latlngMap.put("latlng",list);
+ latlngMap.put("latlng", list);
return latlngMap;
}
-
@GetMapping("/windAndDeviceData")
@@ -1981,17 +2126,17 @@
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.MINUTE, (calendar.get(Calendar.MINUTE) - 2));
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");
- String time = df.format(calendar.getTime())+":00";
+ //String time = df.format(calendar.getTime()) + ":00";
int year = calendar.get(Calendar.YEAR);
int month = calendar.get(Calendar.MONTH) + 1;
String mon;
- if (month<10){
- mon="0"+month;
- }else {
- mon=""+month;
+ if (month < 10) {
+ mon = "0" + month;
+ } else {
+ mon = "" + month;
}
- String table="history_minutely_"+year+mon;
- List list=deviceService.byMonitorIdGetDeviceAndWind(monitorPointId,time,table);
+ String table = "history_five_minutely_" + year + mon;
+ List list = deviceService.byMonitorIdGetDeviceAndWind(monitorPointId, table);
return list;
}
@@ -2002,17 +2147,17 @@
Calendar calendar = Calendar.getInstance();
calendar.set(Calendar.MINUTE, (calendar.get(Calendar.MINUTE) - 2));
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");
- String time = df.format(calendar.getTime())+":00";
+ String time = df.format(calendar.getTime()) + ":00";
int year = calendar.get(Calendar.YEAR);
int month = calendar.get(Calendar.MONTH) + 1;
String mon;
- if (month<10){
- mon="0"+month;
- }else {
- mon=""+month;
+ if (month < 10) {
+ mon = "0" + month;
+ } else {
+ mon = "" + month;
}
- String table="history_minutely_"+year+mon;
- List list=deviceService.byMonitorIdGetDeviceAndWindSpecial(monitorPointId,time,table);
+ String table = "history_five_minutely_" + year + mon;
+ List list = deviceService.byMonitorIdGetDeviceAndWindSpecial(monitorPointId, table);
return list;
}
@@ -2020,9 +2165,28 @@
@ApiOperation(value = "���������������������������", notes = "���������������������������")
@ApiImplicitParams(value = {
@ApiImplicitParam(name = "monitorPointId", defaultValue = "1", value = "���������id", required = true, paramType = "query", dataType = "String"),
- @ApiImplicitParam(name = "time", value = "���6���(���������2020-03-19)", 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>>> getWeatherNextDayDataByRegion(HttpServletRequest request) throws Exception {
Map<String, Object> parameters = getParametersStartingWith(request, null);
+ List<String> sensorKeys = new ArrayList<>();
+ sensorKeys.add("e15");
+ parameters.put("sensorKeys", sensorKeys);
+ List<Map<String, Object>> resultList = weatherService.getForecastAndReal(parameters);
+ return new ResultBean<List<Map<String, Object>>>(resultList);
+ }
+
+
+ @GetMapping("forecastPM")
+ @ApiOperation(value = "������������������������������", notes = "������������������������������")
+ @ApiImplicitParams(value = {
+ @ApiImplicitParam(name = "monitorPointId", defaultValue = "1", value = "���������id", 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>>> getForecastAndRealPM(HttpServletRequest request) throws Exception {
+ Map<String, Object> parameters = getParametersStartingWith(request, null);
+ List<String> sensorKeys = new ArrayList<>();
+ sensorKeys.add("e1");
+ sensorKeys.add("e2");
+ parameters.put("sensorKeys", sensorKeys);
List<Map<String, Object>> resultList = weatherService.getForecastAndReal(parameters);
return new ResultBean<List<Map<String, Object>>>(resultList);
}
@@ -2063,7 +2227,7 @@
}
@PostMapping("updateForecastWeather")
- public void updateForecastWeather(HttpServletRequest request){
+ public void updateForecastWeather(HttpServletRequest request) {
Map<String, Object> parameters = getParametersStartingWith(request, null);
weatherService.updateForecastWeather(parameters);
}
@@ -2088,10 +2252,10 @@
List<Map<String, Object>> device_sensorList = sensorService.getSensorByDeviceId(device.get("id").toString());
Map<String, Object> device_sensorUnit_map = new HashMap<>();
for (Map<String, Object> device_sensorMap : device_sensorList) {
- device_sensorUnit_map.put(device_sensorMap.get("sensor_key").toString(),device_sensorMap.get("unit"));
+ device_sensorUnit_map.put(device_sensorMap.get("sensor_key").toString(), device_sensorMap.get("unit"));
}
Map<String, String> sensorMap = sensorService.getSensorsMap(parameters);
- if (startTime.length()==10&&endTime.length()==10){
+ if (startTime.length() == 10 && endTime.length() == 10) {
//������������������
Date dd = new Date();
//���������
@@ -2100,7 +2264,7 @@
String nowTime = sim.format(dd);
int days = endTime.compareTo(nowTime);
//System.out.println(days);
- List<String> dayList = DatesUtil.findDaysStr(startTime,endTime);
+ List<String> dayList = DatesUtil.findDaysStr(startTime, endTime);
//System.out.println("dayList:"+dayList);
/*if (days<0){
Date date=null;
@@ -2116,86 +2280,88 @@
endTime=new SimpleDateFormat("yyyy-MM-dd").format(calendar.getTime());
}*/
List<Map<String, Object>> sameDayHourlyList = null;
- if (days>=0){
+ if (days >= 0) {
SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//������������������������
String currentTime = df.format(dd);
- sameDayHourlyList = historyHourlyService.getDataByTimeSlot(mac,nowTime,currentTime);
+ sameDayHourlyList = historyHourlyService.getDataByTimeSlot(mac, nowTime, currentTime);
}
- List<Map<String, Object>> dataList = historyDailyService.getDataByTimeSlot(mac,startTime,endTime);
- if (dataList.isEmpty()){
+ List<Map<String, Object>> dataList = historyDailyService.getDataByTimeSlot(mac, startTime, endTime);
+ if (dataList.isEmpty()) {
return null;
}
Set<String> keys = sensorMap.keySet();
- for (String key:keys) {
- Map<String,Object> oneSensorMap = new LinkedHashMap<>();
- oneSensorMap.put("monitorPointName",monitorPointMap.get("name"));
- oneSensorMap.put("deviceName",device.get("name"));
- oneSensorMap.put("sersorKey",sensorMap.get(key)+"���"+device_sensorUnit_map.get(key)+"���");
- for (String day:dayList) {
- for (Map<String, Object> dataMap: dataList) {
+ for (String key : keys) {
+ Map<String, Object> oneSensorMap = new LinkedHashMap<>();
+ oneSensorMap.put("monitorPointName", monitorPointMap.get("name"));
+ oneSensorMap.put("deviceName", device.get("name"));
+ oneSensorMap.put("sersorKey", sensorMap.get(key) + "���" + device_sensorUnit_map.get(key) + "���");
+ for (String day : dayList) {
+ for (Map<String, Object> dataMap : dataList) {
JSONObject dataJson = JSONObject.parseObject(dataMap.get("json").toString());
- if (dataMap.get("time").toString().equals(day+" 00:00:00.0")){
- oneSensorMap.put(dataMap.get("time").toString().substring(0,10),dataJson.getJSONArray(key).get(2));
+ if (dataMap.get("time").toString().equals(day + " 00:00:00.0")) {
+ oneSensorMap.put(dataMap.get("time").toString().substring(0, 10), dataJson.getJSONArray(key).get(0));
break;
- }else {
+ } else {
continue;
}
}
- if(!oneSensorMap.containsKey(day)){
- oneSensorMap.put(day,"");
+ if (!oneSensorMap.containsKey(day)) {
+ oneSensorMap.put(day, "");
}
}
Double avg = 0.0;
- if (sameDayHourlyList != null){
- for (Map sameDayHourlyMap:sameDayHourlyList){
+ if (sameDayHourlyList != null) {
+ for (Map sameDayHourlyMap : sameDayHourlyList) {
List<Double> arr = new ArrayList<>();
JSONObject hourlyJson = JSONObject.parseObject(sameDayHourlyMap.get("json").toString());
- arr.add(Double.parseDouble(hourlyJson.getJSONArray(key).get(2).toString()));
+ arr.add(Double.parseDouble(hourlyJson.getJSONArray(key).get(0).toString()));
Double sum = 0.0;
- for (int i=0;i<arr.size();i++){
+ for (int i = 0; i < arr.size(); i++) {
sum += arr.get(i);
}
avg = sum / arr.size();
}
- oneSensorMap.put(nowTime,avg);
+ oneSensorMap.put(nowTime, avg);
}
list.add(oneSensorMap);
}
- }else if (startTime.length()==13&&endTime.length()==13){
+ } else if (startTime.length() == 13 && endTime.length() == 13) {
StringBuilder startTime_sb = new StringBuilder(startTime);
- startTime_sb.replace(10,11," ");
- startTime = startTime_sb.toString()+":00:00";
+ startTime_sb.replace(10, 11, " ");
+ startTime = startTime_sb.toString() + ":00:00";
StringBuilder endTime_sb = new StringBuilder(endTime);
- endTime_sb.replace(10,11," ");
- endTime = endTime_sb.toString()+":00:00";
+ endTime_sb.replace(10, 11, " ");
+ endTime = endTime_sb.toString() + ":00:00";
- List<String> hoursList = DatesUtil.findHoursStr(startTime,endTime);
+ List<String> hoursList = DatesUtil.findHoursStr(startTime, endTime);
//System.out.println("hoursList:"+hoursList);
- List<Map<String, Object>> hourlyList = historyHourlyService.getDataByTimeSlot(mac,startTime,endTime);
- if (hourlyList.isEmpty()){
+ List<Map<String, Object>> hourlyList = historyHourlyService.getDataByTimeSlot(mac, startTime, endTime);
+ if (hourlyList.isEmpty()) {
return null;
}
Set<String> keys = sensorMap.keySet();
- for (String key:keys) {
- Map<String,Object> oneSensorMap = new LinkedHashMap<>();
- oneSensorMap.put("monitorPointName",monitorPointMap.get("name"));
- oneSensorMap.put("deviceName",device.get("name"));
- oneSensorMap.put("sersorKey",sensorMap.get(key)+"���"+device_sensorUnit_map.get(key)+"���");
- for (String hour:hoursList) {
- for (Map<String, Object> hourlyMap: hourlyList) {
+ for (String key : keys) {
+ Map<String, Object> oneSensorMap = new LinkedHashMap<>();
+ oneSensorMap.put("monitorPointName", monitorPointMap.get("name"));
+ oneSensorMap.put("deviceName", device.get("name"));
+ oneSensorMap.put("sersorKey", sensorMap.get(key) + "���" + device_sensorUnit_map.get(key) + "���");
+ for (String hour : hoursList) {
+ for (Map<String, Object> hourlyMap : hourlyList) {
JSONObject dataJson = JSONObject.parseObject(hourlyMap.get("json").toString());
- if (hourlyMap.get("time").toString().equals(hour+".0")){
- oneSensorMap.put(hourlyMap.get("time").toString().substring(0,19),dataJson.getJSONArray(key).get(2));
- break;
- }else {
+ if (hourlyMap.get("time").toString().equals(hour + ".0")) {
+ if (dataJson.getJSONArray(key) != null) {
+ oneSensorMap.put(hourlyMap.get("time").toString().substring(0, 19), dataJson.getJSONArray(key).get(0));
+ break;
+ }
+ } else {
continue;
}
}
- if(!oneSensorMap.containsKey(hour)){
- oneSensorMap.put(hour,"");
+ if (!oneSensorMap.containsKey(hour)) {
+ oneSensorMap.put(hour, "");
}
}
/*for (Map<String, Object> hourlyMap: hourlyList) {
@@ -2205,12 +2371,11 @@
}*/
list.add(oneSensorMap);
}
- }else {
+ } else {
return null;
}
return new ResultBean<List<Map<String, Object>>>(list);
}
-
@GetMapping("/contrastFactor")
@@ -2221,8 +2386,853 @@
@ApiImplicitParam(name = "time", value = "������(���������2020-03-19���20���21)", required = true, paramType = "query", dataType = "String")})
public ResultBean<List<Map<String, Object>>> contrastFactor(HttpServletRequest request) throws Exception {
Map<String, Object> parameters = getParametersStartingWith(request, null);
- List list=historyHourlyService.getDataByMacAndTime(parameters);
+ List list = historyHourlyService.getDataByMacAndTime(parameters);
//System.out.println(list);
return new ResultBean<List<Map<String, Object>>>(list);
}
-}
+
+ @GetMapping("/getAlarm")
+ @ResponseBody
+ public List<DeviceRoad> getAlarm(@Param("windData") String windData, @Param("code") String code, @Param("mac") String mac, @Param("speedLevel") String speedLevel) {
+ List<DeviceRoad> alarmData = deviceRoadService.getAlarmData(windData, code, mac, speedLevel);
+ return alarmData;
+ }
+
+ @GetMapping("multiDeviceContrast")
+ @ApiOperation(value = "���������������������", notes = "���������������������")
+ @ApiImplicitParams(value = {
+ @ApiImplicitParam(name = "macs", value = "������mac,���������������������������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "sensorKey", value = "���������key", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "time", value = "������,������(���������2018-03-12)", required = true, paramType = "query", dataType = "String"),})
+ public ResultBean<List<Map<String, Object>>> multiDeviceSensor(HttpServletRequest request) throws Exception {
+ Map<String, Object> parameters = getParametersStartingWith(request, null);
+ ParameterUtils.getTimeType4Time(parameters);
+ List<Map<String, Object>> list = historyMinutelyService.getMultiDeviceSensorData(parameters);
+ return new ResultBean<List<Map<String, Object>>>(list);
+ }
+
+
+ @PostMapping("/tellAlarm")
+ @ResponseBody
+ public List<List> tellAlarm(String states, String orgId, String accountId, String states1, String regionCode) {
+ JSONArray stateList = JSONArray.parseArray(states);//���������������������
+ JSONArray stateList1 = JSONArray.parseArray(states1);//���10������������������
+ List<List> lookList = new ArrayList<>();
+ Map params = new HashMap();
+ String lookString = "";
+ //������������������������������������������������������������������������������
+ //���������������������������������������null
+ if (stateList1 != null && !states.equals(states1)) {
+ List<Map> listDevice = JSONObject.parseArray(stateList.toJSONString(), Map.class);
+ List<Map> listDevice1 = JSONObject.parseArray(stateList1.toJSONString(), Map.class);
+ //���������������������������������������
+ List<Map> deviceList = new ArrayList<Map>();
+ List<Map> deviceList1 = new ArrayList<Map>();
+ //���������������������id
+ List orgList = new ArrayList();
+ for (Map devices : listDevice) {
+ int monitorId = Integer.parseInt((String) devices.get("id"));
+ MonitorPoint monitorPoint = monitorPointService.byIdGetMonitorPoint(monitorId);
+ int org_id = monitorPoint.getOrganizationId();
+ orgList.add(org_id);
+ List<Map> devicesList = (List<Map>) devices.get("devices");
+ if (!devicesList.isEmpty()) {
+ if (devicesList.size() > 1) {
+ for (Map map : devicesList) {
+ deviceList.add(map);
+ }
+ } else {
+ deviceList.add((Map) ((List) devices.get("devices")).get(0));
+ }
+ }
+ }
+ for (Map devices1 : listDevice1) {
+ int monitorId = Integer.parseInt((String) devices1.get("id"));
+ MonitorPoint monitorPoint = monitorPointService.byIdGetMonitorPoint(monitorId);
+ int org_id = monitorPoint.getOrganizationId();
+ List<Map> devicesList = (List<Map>) devices1.get("devices");
+ if (!devicesList.isEmpty()) {
+ if (devicesList.size() > 1) {
+ for (Map map : devicesList) {
+ deviceList1.add(map);
+ }
+ } else {
+ deviceList1.add((Map) ((List) devices1.get("devices")).get(0));
+ }
+ }
+ }
+ List<String> macList = new ArrayList<String>();
+ //������������������������������������������mac���
+ for (Map map : deviceList) {
+ String state = (String) map.get("state");
+ String mac = (String) map.get("mac");
+ for (Map map1 : deviceList1) {
+ String state1 = (String) map1.get("state");
+ String mac1 = (String) map1.get("mac");
+ if (mac.equals(mac1)) {
+ if (Integer.parseInt(state) > Integer.parseInt(state1) && Integer.parseInt(state) != 4 /*&& Integer.parseInt(state1) == 0*/) {
+ macList.add(mac + "-" + state + "-" + state1);
+ }
+ }
+ }
+ }
+ //������������������������
+ LinkedHashSet<Integer> orgS = new LinkedHashSet<Integer>(orgList);
+ SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
+ Date date = new Date(System.currentTimeMillis());
+ Date date1 = new Date(System.currentTimeMillis() - 1000);
+ //������������������
+ String time = formatter.format(date);
+ //������������������������������
+ String time1 = formatter.format(date1);
+ List<Map> alarmList = new ArrayList<Map>();
+ for (Integer org : orgS) {
+ int orgNum = alarmConfigService.containOrgId(org);
+ Map<String, Object> eMap = new HashMap<String, Object>();
+ if (orgNum == 1) {
+ String alarmConfig = alarmConfigService.getValueByOrganizationId(Integer.parseInt(String.valueOf(org)));
+ Map hashMap = JSON.parseObject(alarmConfig, HashMap.class);
+ Map alarmLevels = (Map) hashMap.get("alarmLevels");
+ //������������������������106���������
+ for (int i = 1; i < 106; i++) {
+ if (alarmLevels.containsKey("e" + i)) {
+ Map map = (Map) alarmLevels.get("e" + i);
+ if (!map.isEmpty()) {
+ Integer enable = (Integer) map.get("enable");
+ List increment = (List) map.get("increment");
+ if (enable == 1) {
+ if (!(increment.get(0).toString().equals("0") && increment.get(1).toString().equals("0"))) {
+ eMap.put("e" + i, increment);
+ } else {
+ continue;
+ }
+ } else {
+ continue;
+ }
+ }
+ }
+ }
+ } else {
+ String defultAlarm = dictionaryDataService.getDefultAlarm();
+ Map hashMap = JSON.parseObject(defultAlarm, HashMap.class);
+ Map alarmLevels = (Map) hashMap.get("alarmLevels");
+ //������������������������106���������
+ for (int i = 1; i < 106; i++) {
+ if (alarmLevels.containsKey("e" + i)) {
+ Map map = (Map) alarmLevels.get("e" + i);
+ if (!map.isEmpty()) {
+ Integer enable = (Integer) map.get("enable");
+ List increment = (List) map.get("increment");
+ if (enable == 1) {
+ if (!(increment.get(0).toString().equals("0") && increment.get(1).toString().equals("0"))) {
+ eMap.put("e" + i, increment);
+ } else {
+ continue;
+ }
+ } else {
+ continue;
+ }
+ }
+ }
+ }
+ }
+ Map map = new HashMap();
+ map.put("eMap", eMap);
+ map.put("org", org);
+ alarmList.add(map);
+ }
+ for (Map aEMap : alarmList) {
+ List<Map> values = new ArrayList<Map>();
+ if (macList.size() > 0) {
+ for (String sMac : macList) {
+ String[] aMac = sMac.split("-");
+ String mac = aMac[0];
+ //������������������������������������������������������������������������������������������������������������������������������������������������
+ String value = historyService.getValueByMacAndTime(mac, time, time1);
+ Map<String, String> map = new HashMap<String, String>();
+ if (value == null) {
+ Date date2 = new Date(System.currentTimeMillis() - 2000);
+ //������������������������������
+ String time2 = formatter.format(date1);
+ value = historyService.getValueByMacAndTime(mac, time, time2);
+ if (value == null) {
+ Date date3 = new Date(System.currentTimeMillis() - 3000);
+ //������������������������������
+ String time3 = formatter.format(date1);
+ value = historyService.getValueByMacAndTime(mac, time, time3);
+ }
+ }
+ if (value != null) {
+ map.put("mac", mac);
+ map.put("value", value);
+ map.put("state", aMac[1]);
+ map.put("state1", aMac[2]);
+ values.add(map);
+ } else {
+ continue;
+ }
+ }
+ }
+
+ if (values.size() > 0 && values.size() == macList.size()) {
+ for (Map dataMap : values) {
+ String oId = deviceService.byMacGetOrgId((String) dataMap.get("mac"));
+ if (!(aEMap.get("org").toString()).equals(oId)) {
+ continue;
+ }
+ List<String> list = new ArrayList<String>();
+ Map sensorMap = JSONObject.parseObject((String) dataMap.get("value"));
+ Iterator<String> iter = sensorMap.keySet().iterator();
+ while (iter.hasNext()) {
+ String key = iter.next();
+ list.add(key);
+ }
+ String state = (String) dataMap.get("state");
+ String state1 = (String) dataMap.get("state1");
+ List<Map> mapList = new ArrayList();
+ for (String key : list) {
+ if (((Map) aEMap.get("eMap")).containsKey(key)) {
+ Double val = Double.valueOf(sensorMap.get(key).toString());
+ List valueList = (List) ((Map) aEMap.get("eMap")).get(key);
+ Device device = deviceService.byMacGetDevice((String) dataMap.get("mac"));
+ Map<String, Object> sensors = sensorService.getSensorBySensorKey(key);
+ if (key.equals("e1") || key.equals("e2") || key.equals("e10") || key.equals("e11") || key.equals("e15") || key.equals("e16")) {
+ //������������������������
+ if ((state1.equals("0") || state1.equals("1")) && Integer.parseInt(state) > 1) {
+ if (val > Double.valueOf(String.valueOf(valueList.get(1)))) {
+ Map lookMap = new HashMap();
+ lookMap.put("time", time);
+ lookMap.put("name", device.getName());
+ lookMap.put("sensor", sensors.get("description"));
+ lookMap.put("value", val + "" + sensors.get("unit"));
+ mapList.add(lookMap);
+ //lookString = time+" "+device.getName()+sensors.get("description")+"="+val + sensors.get("unit")+"������";
+ //System.out.println(time + "====" + device.getName() + "=====" + sensors.get("description") + "======" + val + sensors.get("unit"));
+ }
+ }
+ } else {//���������������������������
+ if (state1.equals("0")) {
+ if (val > Double.valueOf(String.valueOf(valueList.get(0)))) {
+ Map lookMap = new HashMap();
+ lookMap.put("time", time);
+ lookMap.put("name", device.getName());
+ lookMap.put("sensor", sensors.get("description"));
+ lookMap.put("value", val + "" + sensors.get("unit"));
+ mapList.add(lookMap);
+ }
+ }
+ }
+
+ }
+ }
+ if (mapList.size() > 0) {
+ lookList.add(mapList);
+ } else {
+ continue;
+ }
+ }
+ }
+ }
+ }
+ return lookList;
+ }
+
+ /* @GetMapping("/lianxian")
+ @ApiOperation(value = "������", notes = "������" )
+ @GetMapping("multiDeviceContrast")
+ @ApiOperation(value = "���������������������", notes = "���������������������")
+ @ApiImplicitParams(value = {
+ @ApiImplicitParam(name = "macs", value = "������mac,���������������������������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "sensorKey", value = "���������key", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "time", value = "������,������(���������2018-03-12)", required = true, paramType = "query", dataType = "String"),})
+ public ResultBean<List<Map<String, Object>>> multiDeviceSensor(HttpServletRequest request) throws Exception {
+ Map<String, Object> parameters = getParametersStartingWith(request, null);
+ ParameterUtils.getTimeType4Time(parameters);
+ List<Map<String, Object>> list = historyMinutelyService.getMultiDeviceSensorData(parameters);
+ return new ResultBean<List<Map<String, Object>>>(list);
+ }
+
+ /*
+ * ���������������������������������������������
+ */
+ @GetMapping("screenVersion")
+ public Map<String, Object> getScreenVersion(HttpServletRequest request) {
+ Map<String, Object> parameters = getParametersStartingWith(request, null);
+ String version = parameters.get("version").toString();
+ return screenVersionService.getScreenVersion(version);
+ }
+
+ @GetMapping("allDeviceExcel")
+ @ApiOperation(value = "���������������������������������", notes = "���������������������������������")
+ @ApiImplicitParams(value = {
+ @ApiImplicitParam(name = "monitorPoint", value = "������������id", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "sensorKey", value = "���������key,������������������", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "startTime", value = "������������(���������2020-08-03)", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "endTime", value = "������������(���������2020-08-04)", required = false, paramType = "query", dataType = "String")})
+ public ResultBean<List<Map<String, Object>>> getAllDeviceDataToExcel(HttpServletRequest request) throws Exception {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ List<Map<String, Object>> list = historyMinutelyService.getAllDeviceDataToExcel(parameters);
+ return new ResultBean<List<Map<String, Object>>>(list);
+ }
+
+ /*@PostMapping("insertAdjustValue")
+ @ApiOperation(value = "���������������������������������", notes = "���������������������������������")
+ @ApiImplicitParams(value = {
+ @ApiImplicitParam(name = "id", value = "������id", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "time", value = "���������������08:30:00���", required = true, paramType = "query", dataType = "String"),
+ @ApiImplicitParam(name = "dataArray", value = "������", required = false, paramType = "query", dataType = "String")})
+ public void insertAdjustValue(HttpServletRequest request) throws Exception {
+ Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+ int device_id = Integer.parseInt(parameters.get("id").toString());
+ String hour_minute_second = parameters.get("time").toString();
+ String[] arr = hour_minute_second.split(":");
+ int seconds = Integer.parseInt(arr[0])*3600+Integer.parseInt(arr[1])*60+Integer.parseInt(arr[2]);
+ String value = parameters.get("dataArray").toString();
+ deviceAdjustValueTimingService.insertData(device_id,seconds,value);;
+ }*/
+
+ @PostMapping("insertAdjustValue")
+ 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]);
+ //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 value = "{" + val + "}";
+ deviceAdjustValueTimingService.insertData(device_id, seconds, value);
+ return 1;
+ } catch (Exception e) {
+ log.warn(e);
+ }
+ return 0;
+ }
+
+ @RequestMapping("/biaozhun")
+ @ResponseBody
+ public List<Device> queryDevice(String macOrName) {
+ List<Device> deviceList = new ArrayList<>();
+ if (!macOrName.equals("")) {
+ deviceList = deviceService.getDevice(macOrName);
+ }
+ return deviceList;
+ }
+
+ @RequestMapping("/getBiaoZhun")
+ @ResponseBody
+ 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;
+ }
+ if (mill.length() < 2) {
+ mill = "0" + mill;
+ }
+ if (second.length() < 2) {
+ second = "0" + second;
+ }
+ String time = hour + ":" + mill + ":" + second;
+ Map<String, String> value = deviceAdjustValueTiming.getValue();
+ Collection<String> values = value.values();
+ deviceAdjustValueTiming.setSeconds(time);
+ }
+ return dataByDeviceid;
+ }
+
+
+ @RequestMapping("/getSensor")
+ @ResponseBody
+ 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);
+ return i;
+ }
+
+
+ @GetMapping("/monitorAVGData")
+ @ApiOperation(value = "monitor������������������", notes = "monitor������������������")
+ @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 {
+ Map<String, Object> parameters = getParametersStartingWith(request, null);
+ String monitorPointIds = (String) parameters.get("monitorPointIds");
+ String time = (String) parameters.get("time");
+ 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());
+ String[] mIds = monitorPointIds.split(",");
+ 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);
+ 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") != "") {
+ 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 = new HashMap<>();
+ 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));
+ dataAvbByMIdAndTime.add(dayMap);
+ 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"));
+ }
+ } else {
+ Map<String, Object> map1 = AQICalculation2.dayAQI((Map<String, Object>) dataAvbByMIdAndTime.get(i).get("data"));
+ 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"));
+ }
+ }
+ }
+ List timeList = new ArrayList();
+ for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) {
+ timeList.add(dataAvbByMIdAndTime.get(q).get("time"));
+ }
+ if (dataAvbByMIdAndTime.size() < 25) {
+ for (int j = 1; j < 25; j++) {
+ Map<String, Object> map = null;
+ for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) {
+ 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;
+ }
+ }
+ if (!timeList.contains(sj)) {
+ map = new HashMap<>();
+ 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);
+ dataAvbByMIdAndTime.add(map);
+ break;
+ } else {
+ break;
+ }
+ }
+ }
+ }
+ }
+ /* for (int i1 = 0; i1 < dataAvbByMIdAndTime.size(); i1++) {
+ System.out.println(dataAvbByMIdAndTime.get(i1));
+ }*/
+ 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
+ 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) {
+ Map map2 = dataAvbByMIdAndTime.get(j);
+ dataAvbByMIdAndTime.remove(j);
+ dataAvbByMIdAndTime.add(map2);
+ }
+ }
+ 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);
+ 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") != "") {
+ 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 = new HashMap<>();
+ 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));
+ 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) {
+ for (int j = 1; j < 25; j++) {
+ Map<String, Object> map = null;
+ for (int q = 0; q < dataAvbByMIdAndTime.size(); q++) {
+ 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;
+ }
+ }
+ if (!timeList.contains(sj)) {
+ map = new HashMap<>();
+ 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);
+ dataAvbByMIdAndTime.add(map);
+ break;
+ } else {
+ break;
+ }
+ }
+ }
+
+ }
+ }
+ 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
+ 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) {
+ Map map2 = dataAvbByMIdAndTime.get(j);
+ dataAvbByMIdAndTime.remove(j);
+ dataAvbByMIdAndTime.add(map2);
+ }
+ }
+ lists.add(dataAvbByMIdAndTime);
+ }
+ 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) {
+ 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"));
+ rList.add(map);
+ }
+
+ } else if (lists.size() == 1 && lists.get(0) == null) {
+ rList.add(null);
+ } else {
+ for (int j = 0; j < lists.get(0).size(); j++) {
+ Map<String, Object> listMap = new HashMap();
+ List<Map> mapList = new ArrayList<>();
+ if (lists.get(0).size() == 1) {
+ mapList.add(null);
+ } else {
+ mapList.add((Map) lists.get(0).get(j).get("data"));
+ }
+ for (int i = 1; i < lists.size(); i++) {
+ if (lists.get(i).size() == 1) {
+ mapList.add(null);
+ listMap.put("data", mapList);
+ } else {
+ if (lists.get(0).get(j).get("time").equals(lists.get(i).get(j).get("time"))) {
+ mapList.add((Map) lists.get(i).get(j).get("data"));
+ }
+ listMap.put("time", lists.get(0).get(j).get("time"));
+ listMap.put("data", mapList);
+ }
+ }
+ rList.add(listMap);
+ }
+ }
+ 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();
+ List<Device> devicesList = deviceService.getDevicesByAccountId(id);
+ return devicesList;
+ }
+
+ @GetMapping("/unorganizedEmissionsFiveMinute")
+ @ApiOperation(value = "������������������������", notes = "������������������������")
+ @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);
+ String sensorKey = parameters.get("sensorKey").toString();
+ //������������������������������
+ PollutionSourcePoint pollutionSourcePoint = pollutioSourcePointService.selectByMonitorPointId(539);
+ //���������������������������
+ List<Device> deviceList = deviceService.getDevicesByMonitorPointId(539);
+ //���������������������
+ 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",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) {
+ macs.add(device.getMac());
+ }
+ sensorKeys.add(sensorKey);
+ sensorKeys.add("e18");
+ sensorKeys.add("e23");
+ 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()];
+ int i = 0;
+ //������������
+ 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()));
+ windList.add(windMap);
+ String[] sensorArr = map.get(sensorKey).toString().split(",");
+ double sensorData = Double.parseDouble(sensorArr[0].substring(1,sensorArr[0].length()));
+ allDeviceData[i] = sensorData;
+ i = i+1;
+ }
+ //���������������������������
+ 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());
+ //������������������������������������������������������
+ 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;
+ }
+ 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()){
+ 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))){
+ fiveMinuteDataMap.putAll(fiveMinuteData);
+ break;
+ }
+ }
+ }else {
+
+ }
+ Device referenceDevice = new Device();
+ 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];
+ }
+ double deviceDataAvg = sum/allDeviceData.length;
+ //���������������������������������������������
+ double distance = mapUtils.getDistance(pollutionSourcePoint.getLongitude(),pollutionSourcePoint.getLatitude(),referenceDevice.getLongitude(),referenceDevice.getLatitude());
+ //���������������������������x,y
+ double x = Math.cos(Math.toRadians(minDisparity.get().getValue()))*distance;
+ double y = Math.sin(Math.toRadians(minDisparity.get().getValue()))*distance;
+ //���������������������
+ 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"));
+
+ //���������������������
+ 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);
+ numericalValueList.add(numericalValueMap);
+ 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);
+ numericalValueList.add(numericalValueMap3);
+ 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);
+ numericalValueList.add(numericalValueMap5);
+ 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);
+ numericalValueList.add(numericalValueMap7);
+
+
+ JSONObject params = new JSONObject();
+ params.put("accountId",190);
+ params.put("level",17);
+ params.put("center",center);
+ params.put("points",numericalValueList);
+
+
+
+ //������������������
+ //JSONObject params=monitorPointService.getMonitorPointById(monitPointId,Time,3,sensor);
+ // model.addObject("params",params);
+ model.addObject("params", params);
+ model.setViewName("unorganizedMapV2");
+ return model;
+ }
+}
\ No newline at end of file
--
Gitblit v1.8.0