From 9ca86187d65db0180f6d23b8efd13136b6db394c Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期五, 20 九月 2024 11:45:40 +0800
Subject: [PATCH] 考核成绩导出优化
---
ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 38 ++++++++++++++++++++++++++++++++++++--
1 files changed, 36 insertions(+), 2 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 0f5bf2e..d3d00c5 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,11 +6,14 @@
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;
import org.apache.ibatis.annotations.Param;
+import org.springframework.security.core.parameters.P;
import java.util.List;
import java.util.Map;
@@ -47,6 +50,7 @@
* @return 璁惧璧勪骇闆嗗悎
*/
public List<TMonitorVO> selectMonitorVOList();
+
/**
* 鏂板璁惧璧勪骇
*
@@ -84,14 +88,14 @@
* @param tMonitor 鏉′欢
* @return 缁熻鏁�
*/
- Map<String, String> getVideoCount(TMonitor tMonitor);
+ Map<String, String> getVideoCount(TMonitorVO tMonitor);
/**
* 鑾峰彇鎭㈠寮傚父璁惧
* @param time 鏃堕棿
* @return 鏁版嵁
*/
- Map<String, String> recoveryException(String time);
+ Map<String, String> recoveryException(TMonitorVO monitor);
/**
* 鑾峰彇鎭㈠寮傚父鎸佺画鍏虫敞璁惧
@@ -140,4 +144,34 @@
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<TMonitor> getDistinctIP();
+
+ /**
+ * 鏍规嵁ip淇敼鐐逛綅琛ㄧ殑鏄惁鍦ㄧ嚎瀛楁
+ * @param onlineList
+ */
+ void updateOnline(@Param("onlineList") List<UpdateOnlineVO> onlineList);
+
+
+ /**
+ * 鐐逛綅鍦ㄧ嚎鐜�
+ *
+ * @param tMonitor 璁惧璧勪骇
+ * @return 璁惧璧勪骇闆嗗悎
+ */
+ public List<TMonitorResult> selectMonitorResult(@Param("cameraFunType") Short cameraFunType,@Param("deptIds") List<Integer> deptIds);
}
--
Gitblit v1.8.0