From 7d5ea3631d163343b652bd6bd40b94b34c4194eb Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期二, 10 九月 2024 17:32:05 +0800
Subject: [PATCH] 点位在线率调整
---
ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 33 ++++++++++++++++++++++++++++++++-
1 files changed, 32 insertions(+), 1 deletions(-)
diff --git a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java
index f46e204..266054a 100644
--- a/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java
+++ b/ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java
@@ -6,7 +6,9 @@
import com.ycl.platform.domain.query.DashboardQuery;
import com.ycl.platform.domain.query.DataCenterQuery;
import com.ycl.platform.domain.query.HomeQuery;
+import com.ycl.platform.domain.result.SYS.TMonitorResult;
import com.ycl.platform.domain.vo.TMonitorVO;
+import com.ycl.platform.domain.vo.UpdateOnlineVO;
import com.ycl.platform.domain.vo.screen.MonitorRateVO;
import com.ycl.platform.domain.vo.screen.MonitorTotalVO;
import org.apache.ibatis.annotations.Mapper;
@@ -22,7 +24,7 @@
* @date 2024-03-04
*/
@Mapper
-public interface TMonitorMapper
+public interface TMonitorMapper extends BaseMapper<TMonitor>
{
/**
* 鏌ヨ璁惧璧勪骇
@@ -140,4 +142,33 @@
int batchUpdateDeviceType(@Param("numbers") List<String> list,@Param("deviceType") Integer deviceType);
List<TMonitor> selectByNumbers(@Param("numbers")List<String> numbers);
+
+ /**
+ * 鍥芥爣鐮佹煡鍥芥爣鐮�
+ *
+ * @param gbList
+ * @return
+ */
+ List<String> getGBbyGB(@Param("gbList") List<String> gbList);
+
+ /**
+ * 鏌ュ嚭璁惧ip闆嗗悎
+ *
+ * @return
+ */
+ List<String> getDistinctIP();
+
+ /**
+ * 鏍规嵁ip淇敼鐐逛綅琛ㄧ殑鏄惁鍦ㄧ嚎瀛楁
+ * @param online
+ */
+ void updateOnline(@Param("online") UpdateOnlineVO online);
+
+ /**
+ * 鐐逛綅鍦ㄧ嚎鐜�
+ *
+ * @param tMonitor 璁惧璧勪骇
+ * @return 璁惧璧勪骇闆嗗悎
+ */
+ public List<TMonitorResult> selectMonitorResult(Short cameraFunType);
}
--
Gitblit v1.8.0