From c2b226e7902dbb2b36f349612886ccc7333895e6 Mon Sep 17 00:00:00 2001
From: ZhuDongming <zdm773644075@hotmail.com>
Date: Mon, 19 Aug 2019 20:08:44 +0800
Subject: [PATCH] 合并查询无人机平均值,最小值和最大值

---
 src/main/java/com/moral/mapper/SensorMapper.java |   19 ++++++++++++++++++-
 1 files changed, 18 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/moral/mapper/SensorMapper.java b/src/main/java/com/moral/mapper/SensorMapper.java
index 52e6b30..f50008a 100644
--- a/src/main/java/com/moral/mapper/SensorMapper.java
+++ b/src/main/java/com/moral/mapper/SensorMapper.java
@@ -2,6 +2,7 @@
 
 import com.moral.common.mapper.BaseMapper;
 import com.moral.entity.Sensor;
+import org.apache.ibatis.annotations.Param;
 
 import java.util.List;
 import java.util.Map;
@@ -9,5 +10,21 @@
 public interface SensorMapper extends BaseMapper<Sensor> {
     List<Sensor> selectByVersionId(Integer deviceVersionId);
 
-	List<Map<String, Object>> getSensorsByDeviceVersionId(Integer deviceVersionId);
+    List<Sensor> selectByVersionNo(Integer deviceVersionNo);
+
+    List<Sensor> selectByVersionNos(@Param("versionNos") List<Integer> versionNos);
+
+    List<Sensor> selectByOrgId(Integer organizationId);
+
+	List<Map<String, Object>> getSensorsByDeviceVersionId(Map<String, Object> parameters);
+	
+    List<Sensor> getSensorsByCriteria(Map<String, Object> parameters);
+    
+    Map<String,Object> getSensorBySensorKey(@Param("sensor_key")String sensor_key);
+    
+    List<Map<String,Object>> getSensorByDeviceId(@Param("id")String id);
+
+    List<Map<String,Object>> getSensorByMonitorPointId(@Param("monitor_point_id")String monitor_point_id);
+
+    List<Sensor> getSensorsByMac(Map<String, Object> parameters);
 }
\ No newline at end of file

--
Gitblit v1.8.0