From 0d16824a3fb24ee0540c110ee4500b501b310954 Mon Sep 17 00:00:00 2001
From: xufenglei <xufenglei>
Date: Mon, 22 Jul 2019 15:53:38 +0800
Subject: [PATCH] update

---
 src/main/java/com/moral/controller/ScreenController.java |  179 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 175 insertions(+), 4 deletions(-)

diff --git a/src/main/java/com/moral/controller/ScreenController.java b/src/main/java/com/moral/controller/ScreenController.java
index 99f35a6..61c46c2 100644
--- a/src/main/java/com/moral/controller/ScreenController.java
+++ b/src/main/java/com/moral/controller/ScreenController.java
@@ -7,6 +7,10 @@
 import java.io.ByteArrayInputStream;
 import java.io.InputStream;
 import java.io.InputStreamReader;
+import java.io.PrintWriter;
+import java.net.HttpURLConnection;
+import java.net.URL;
+import java.text.DecimalFormat;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.Collection;
@@ -22,6 +26,7 @@
 
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.commons.net.ftp.FTPClient;
+import org.apache.http.HttpResponse;
 import org.apache.log4j.Logger;
 import org.dom4j.Document;
 import org.dom4j.Element;
@@ -46,6 +51,8 @@
 import com.alibaba.fastjson.JSON;
 import com.alibaba.fastjson.JSONArray;
 import com.alibaba.fastjson.JSONObject;
+import com.googlecode.aviator.AviatorEvaluator;
+import com.googlecode.aviator.Expression;
 import com.moral.common.bean.Constants;
 import com.moral.common.bean.JsonData;
 import com.moral.common.bean.PageResult;
@@ -85,7 +92,9 @@
 import com.moral.service.OrganizationService;
 import com.moral.service.QualityDailyService;
 import com.moral.service.SensorService;
+import com.moral.service.SensorUnitService;
 import com.moral.service.WeatherService;
+import com.moral.util.TempAllocationUtils;
 
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiImplicitParam;
@@ -109,6 +118,8 @@
 
     @Resource
     SensorService sensorService;
+    @Resource
+    SensorUnitService sensorUnitService;
     @Resource
     MonitorPointService monitorPointService;
     @Resource
@@ -899,17 +910,19 @@
         String mac = parameters.get("mac").toString();
         String sensorKey = parameters.get("sensorKey").toString();
         String time = parameters.get("time").toString();
-        Long code = monitorPoint.getAreaCode().longValue();
-        String regionName = areaService.queryFullNameByCode(code);
-        Device device = deviceService.getDeviceByMac(mac, false);
         if (monitorPoint != null && mac != null && sensorKey != null && time != null) {
             Map<String, Double> resultMap = historyDailyService.getTraceabilityData(parameters);
             JSONObject params = new JSONObject();
+            Long code = monitorPoint.getAreaCode().longValue();
+            String regionName = areaService.queryFullNameByCode(code);
+            Device device = deviceService.getDeviceByMac(mac, false);
+            Device deviceSecond = deviceService.getDeviceByLongitudeAsc(mac);
             params.put("sensorInfo", resultMap);
             params.put("regionCode", code);
             params.put("regionName", regionName);
             params.put("monitorPoint", monitorPoint);
             params.put("device", device);
+            params.put("deviceSecond",deviceSecond);
             String paramsJson = params.toJSONString();
             model.addObject("traceabilityParams", paramsJson);
             model.setViewName("traceability");
@@ -917,7 +930,7 @@
         } else {
             StringBuilder msg = new StringBuilder();
             msg.append(" param[0] monitorPointId:");
-            msg.append(monitorPointId.toString());
+            msg.append(monitorPointId);
             msg.append(" param[0] mac:");
             msg.append(mac);
             msg.append(" param[0] sensorKey:");
@@ -929,5 +942,163 @@
             return model;
         }
     }
+    
+    /*@GetMapping("getSensor")
+	@ApiOperation(value = "������������", notes = "������������")
+	@ApiImplicitParams(value = {
+			@ApiImplicitParam(name = "mac", value = "������MN���", required = true, paramType = "query", dataType = "String")
+	})
+	public ResultBean<Map<String, Object>> getSensor(HttpServletRequest request) throws Exception {
+		Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+		String mac = (String) parameters.get("mac");
+		//System.out.println("ScreenController-----getSensor-----mac:"+mac);
+		Map<String, Object> map = sensorUnitService.getSensorByMac(mac);
+		System.out.println("ScreenController-----getSensor-----map:"+map);
+		return new ResultBean<Map<String, Object>>(map);
+	}*/
+	
+	@GetMapping("getSensorByMonitorPointId")
+	@ApiOperation(value = "������������", notes = "������������")
+	@ApiImplicitParams(value = {
+			@ApiImplicitParam(name = "monitor_point_id", value = "������������id", required = true, paramType = "query", dataType = "String")
+	})
+	public ResultBean<List<Map<String, Object>>> getSensorByMonitorPointId(HttpServletRequest request) throws Exception {
+		Map<String, Object> parameters = WebUtils.getParametersStartingWith(request, null);
+		String monitor_point_id = (String) parameters.get("monitor_point_id");
+		List<Map<String, Object>> map = sensorUnitService.getSensorsByMonitPointId2(monitor_point_id);
+		return new ResultBean<List<Map<String, Object>>>(map);
+	}
+	
+	@GetMapping("AIForecast")
+	@ApiOperation(value = "AI������", notes = "AI������")
+	@ApiImplicitParams(value = {
+			@ApiImplicitParam(name = "monitorPoint", value = "���������id", required = true, paramType = "query", dataType = "String"),
+			@ApiImplicitParam(name = "mac", value = "������mac", required = false, paramType = "query", dataType = "String"),
+			@ApiImplicitParam(name = "sensorKey", value = "���������key,���������������������������", required = true, paramType = "query", dataType = "String"), 
+			@ApiImplicitParam(name = "time", value = "������,���(���������2018-03-06)", required = true, paramType = "query", dataType = "String"), 
+	})
+	public ResultBean<List<Map<String, Object>>> AIForecast (HttpServletRequest request) throws Exception {
+		Map<String, Object> parameters = getParametersStartingWith(request, null);
+		//System.out.println(parameters);
+		String monitorPoint = (String) parameters.get("monitorPoint");
+		String intoTime = parameters.get("time").toString();
+		String[] timeArray = intoTime.split("-");
+		//System.out.println(timeArray);
+		Integer year = Integer.parseInt(timeArray[0]);
+		Integer mon = Integer.parseInt(timeArray[1]);
+		if(mon>1) {
+			mon = mon-1;
+		}else {
+			mon = 12;
+			year = year-1;
+		}
+		String alterTime = year.toString()+"-"+mon.toString()+"-"+timeArray[2];
+		//System.out.println(alterTime);
+		parameters.put("time", alterTime);
+        ParameterUtils.getTimeType4Time(parameters);
+		String monitor_point_id = (String) parameters.get("monitorPoint");
+        parameters.put("monitorPointId", parameters.remove("monitorPoint"));
+        String[] sensorKeys = parameters.remove("sensorKey").toString().split(",");
+        parameters.put("sensors", Arrays.asList(sensorKeys));
+        // monitorPointService.isCompensateCalculation(parameters);
+        List<Map<String, Object>> list = historyMinutelyService.getMonitorPointOrDeviceAvgData(parameters);
+        
+        Map<String, Object> mpMap = new HashMap<>();
+        mpMap = monitorPointService.selectAllById(monitorPoint);
+        //������������map���������������������������������������������������
+        Map<String, Object> weatherParameters = new HashMap<>();
+        weatherParameters.put("organizationId", mpMap.get("organization_id"));
+        weatherParameters.put("time", intoTime);
+        //������������������
+        Map<String, Object> weatherMap = weatherService.get15DayWeatherDataByRegion(weatherParameters);
+        Map<String, Object> tempMap = TempAllocationUtils.tempAllocation(weatherMap);
+        //������������������
+      	Map<String, Map<String, Object>> sensorUnitMap = sensorUnitService.getSensorsByMonitPointId(monitor_point_id);
+
+        for (Map<String, Object> map : list) {
+            String time = map.get("time").toString();
+            time = time.substring(time.length() - 2);
+            map.put("time", Integer.valueOf(time));
+            map.put("temp", tempMap.get(map.get("time").toString()));
+            List<Number> values = new ArrayList<Number>();
+            List<String> units = new ArrayList<String>();
+            for (String string : sensorKeys) {
+            	if(sensorUnitMap!=null && !sensorUnitMap.isEmpty()) {
+            		if(sensorUnitMap.get(string)!=null) {
+            			units.add(sensorUnitMap.get(string).get("name").toString());
+            			String rules = sensorUnitMap.get(string).get("rules").toString();
+            			rules = rules.replace("{0}", "a");
+            			rules = rules.replace("d", "");
+            			Expression expression = AviatorEvaluator.compile(rules);
+            			Double value;
+            			Map<String, Object> ev = new HashMap<>();
+            			ev.put("a", map.get(string));
+            			value = (Double) expression.execute(ev);
+            			//������������������
+            			DecimalFormat df = new DecimalFormat("#.00");
+            			value = Double.parseDouble(df.format(value));
+            			values.add(value);
+            		}else {
+            			Map<String, Object> sensorMap = sensorService.getSensorBySensorKey(string);
+            			units.add(sensorMap.get("unit").toString());
+            			values.add((Number) map.remove(string));
+            		}
+            	}else {
+            		Map<String, Object> sensorMap = sensorService.getSensorBySensorKey(string);
+        			units.add(sensorMap.get("unit").toString());
+        			values.add((Number) map.remove(string));
+            	}
+                //values.add((Number) map.remove(string));
+            }
+            map.put("values", values);
+            map.put("units", units);
+        }
+		return new ResultBean<List<Map<String, Object>>>(list);
+	}
+	
+	@GetMapping("getWeather")
+	@ApiOperation(value = "������������������", notes = "������������������")
+	@ApiImplicitParams(value = {
+			@ApiImplicitParam(name = "organizationId", defaultValue = "5", value = "���������������������id", required = true, paramType = "query", dataType = "String"),
+			@ApiImplicitParam(name = "time", value = "������,���(���������2018-03-06)", required = true, paramType = "query", dataType = "String"),
+	})
+	public ResultBean<Map<String, Object>> getWeather(HttpServletRequest request) throws Exception {
+		Map<String, Object> parameters = getParametersStartingWith(request, null);
+        Map<String, Object> map = weatherService.get15DayWeatherDataByRegion(parameters);
+        /*Map<String, Object> tempMap = new HashMap<>();
+        Double tempDay = Double.parseDouble(map.get("tempDay").toString());
+        Double tempNight = Double.parseDouble(map.get("tempNight").toString());
+        Double time5 = tempNight;
+        Double time13 = tempDay;
+        Double difference = tempDay-tempNight;
+        Double dif_8 = difference/8;
+        Double dif_16 = difference/16;
+        tempMap.put("5", time5);
+        tempMap.put("13", time13);
+        String time = null;
+        Double t = time5;
+        for(int i=4;i>=0;i--) {
+        	time = ""+i;
+        	t = t+dif_16;
+        	String tempLast = ""+Math.round(t);
+        	tempMap.put(time, tempLast);
+        }
+        Double y = time5;
+        for(int i=6;i<13;i++) {
+        	time = ""+i;
+        	y = y+dif_8;
+        	String tempLast = ""+Math.round(y);
+        	tempMap.put(time, tempLast);
+        }
+        Double z = time13;
+        for(int i=14;i<=23;i++) {
+        	time = ""+i;
+        	z = z-dif_16;
+        	String tempLast = ""+Math.round(z);
+        	tempMap.put(time, tempLast);
+        }*/
+        Map<String, Object> tempMap = TempAllocationUtils.tempAllocation(map);
+        return new ResultBean<Map<String, Object>>(tempMap);
+	}
 
 }

--
Gitblit v1.8.0