From 8ea24dd5fb6e1b24d3a7ef62a0060ef516f8f759 Mon Sep 17 00:00:00 2001
From: xufenglei <xufenglei>
Date: Thu, 24 May 2018 08:58:16 +0800
Subject: [PATCH] 更新 监测点 数据

---
 src/main/resources/mapper/HistoryMinutelyMapper.xml                  |   17 ++++++++++++++++-
 src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java |   12 +++++-------
 2 files changed, 21 insertions(+), 8 deletions(-)

diff --git a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
index 648b3cc..4fd39e3 100644
--- a/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/HistoryMinutelyServiceImpl.java
@@ -69,7 +69,7 @@
 
 	@Override
 	public Map<String, Object> getDayAQIByDevice(Map<String, Object> parameters) {
-		ValidateUtil.notNull(parameters.get("mac"), "param.is.null");
+		//ValidateUtil.notNull(parameters.get("mac"), "param.is.null");
 		LocalDate localDate = LocalDate.now();
 		// ������00:00:00
 		parameters.put("start", localDate.minusDays(1));
@@ -352,8 +352,9 @@
 
 	@Override
 	public Map<String, Object> getMonthAverageBySensor(Map<String, Object> parameters) {
-		ValidateUtil.notNull(parameters.get("mac"), "param.is.null");
-		ValidateUtil.notNull(parameters.get("macKey"), "param.is.null");
+		//ValidateUtil.notNull(parameters.get("mac"), "param.is.null");
+		Object sensorKey = parameters.remove("macKey");
+		ValidateUtil.notNull(sensorKey, "param.is.null");
 		Map<String, Object> result = new HashMap<String, Object>();
 		LocalDate end = LocalDate.now(),start;
 		// ���������������������������������������
@@ -366,10 +367,7 @@
 		}
 		parameters.put("start", start);
 		parameters.put("end", end);
-		String sensorKey = (String) parameters.remove("macKey");
-		List<String> sensorKeys = new ArrayList<String>();
-		sensorKeys.add(sensorKey);
-		parameters.put("sensorKeys", sensorKeys);
+		parameters.put("sensorKeys", Arrays.asList(sensorKey));
 
 		Map<String, Double> average = historyMinutelyMapper.getSersionAvgByDevice(parameters);
 		if (isEmpty(average)) {
diff --git a/src/main/resources/mapper/HistoryMinutelyMapper.xml b/src/main/resources/mapper/HistoryMinutelyMapper.xml
index 2688dd2..70c57d3 100644
--- a/src/main/resources/mapper/HistoryMinutelyMapper.xml
+++ b/src/main/resources/mapper/HistoryMinutelyMapper.xml
@@ -13,7 +13,22 @@
 		FROM
 			history_minutely
 		WHERE
-			mac = #{mac}
+			mac IN
+				(SELECT
+					d.mac 
+				FROM
+					device d,
+					monitor_point mp 
+				WHERE
+					d.is_delete = 0 
+					AND d.monitor_point_id = mp.id 
+					<if test="monitorPointId != null">
+					AND mp.id =	#{monitorPointId}
+					</if>
+					<if test="mac != null">
+					AND d.mac = #{mac}
+					</if>
+				)	
 		AND time >= #{start}
 		AND time &lt; #{end}
 	</select>

--
Gitblit v1.8.0