From dbf1793b62b69f824a401242cfd5430dd4992fa8 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期一, 18 十一月 2024 12:01:14 +0800
Subject: [PATCH] 运行监控导出
---
ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 47 +++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 45 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..ecfd274 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
@@ -3,15 +3,21 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.ycl.platform.domain.entity.TMonitor;
+import com.ycl.platform.domain.excel.TMonitorExp;
+import com.ycl.platform.domain.form.VideoExportForm;
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.Date;
import java.util.List;
import java.util.Map;
@@ -47,6 +53,7 @@
* @return 璁惧璧勪骇闆嗗悎
*/
public List<TMonitorVO> selectMonitorVOList();
+
/**
* 鏂板璁惧璧勪骇
*
@@ -84,14 +91,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 +147,40 @@
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<TMonitorResult> getDistinctIP();
+
+ /**
+ * 鏍规嵁ip淇敼鐐逛綅琛ㄧ殑鏄惁鍦ㄧ嚎瀛楁
+ * @param onlineList
+ */
+ void updateOnline(@Param("onlineList") List<UpdateOnlineVO> onlineList);
+
+
+ /**
+ * 鐐逛綅鍦ㄧ嚎鐜�
+ *
+ * @param tMonitor 璁惧璧勪骇
+ * @return 璁惧璧勪骇闆嗗悎
+ */
+ public List<TMonitorResult> selectMonitorResult(VideoExportForm exportForm);
+
+ void batchUpdateOnline(@Param("ipList")List<String> ipList,@Param("date") Date date,@Param("online")Integer online);
+
+ List<TMonitor> selectCarOrFace();
+
+ List<TMonitorExp> exportTMonitorList(TMonitorVO tMonitor);
}
--
Gitblit v1.8.0