From 3b0516a2959e25576e4f3fda697a3b025d06c8c9 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期二, 24 六月 2025 14:09:07 +0800
Subject: [PATCH] 每日录像可用指标添加日志，修改大屏为查看当前月平均
---
ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 118 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 114 insertions(+), 4 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 64d6023..1a13b60 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
@@ -1,10 +1,23 @@
package com.ycl.platform.mapper;
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.WorkOrderVO;
+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 java.util.Date;
import java.util.List;
import java.util.Map;
@@ -14,6 +27,7 @@
* @author ruoyi
* @date 2024-03-04
*/
+@Mapper
public interface TMonitorMapper extends BaseMapper<TMonitor>
{
/**
@@ -30,7 +44,15 @@
* @param tMonitor 璁惧璧勪骇
* @return 璁惧璧勪骇闆嗗悎
*/
- public List<TMonitorVO> selectTMonitorList(TMonitor tMonitor);
+ public List<TMonitorVO> selectTMonitorList(TMonitorVO tMonitor);
+
+ /**
+ * 鏌ヨ璁惧璧勪骇鍒楄〃
+ *
+ * @param tMonitor 璁惧璧勪骇
+ * @return 璁惧璧勪骇闆嗗悎
+ */
+ public List<TMonitorVO> selectMonitorVOList();
/**
* 鏂板璁惧璧勪骇
@@ -69,14 +91,14 @@
* @param tMonitor 鏉′欢
* @return 缁熻鏁�
*/
- Map<String, String> getVideoCount(TMonitor tMonitor);
+ Map<String, String> getVideoCount(TMonitorVO tMonitor);
/**
* 鑾峰彇鎭㈠寮傚父璁惧
- * @param time 鏃堕棿
+ * @param monitor 鏃堕棿
* @return 鏁版嵁
*/
- Map<String, String> recoveryException(String time);
+ Map<String, String> recoveryException(TMonitorVO monitor);
/**
* 鑾峰彇鎭㈠寮傚父鎸佺画鍏虫敞璁惧
@@ -90,4 +112,92 @@
* @return 鏁版嵁
*/
List<Map<String, Object>> home(HomeQuery monitorQuery);
+
+ List<TMonitorVO> selectListByIds(List<String> list);
+
+ /**
+ * 澶у睆璁惧鎬绘暟
+ * @param dashboardQuery 鏌ヨ鏉′欢
+ * @return 鏁版嵁
+ */
+ List<MonitorTotalVO> monitorTotal(DashboardQuery dashboardQuery);
+
+ /**
+ * 澶у睆璁惧姝ｅ父鐜�
+ * @return 鏁版嵁
+ */
+ List<MonitorRateVO> monitorRate(DashboardQuery dashboardQuery);
+
+ /**
+ * 鏁版嵁涓績-璧勪骇绠＄悊
+ *
+ * @param query
+ */
+ IPage assetManagement(IPage<TMonitorVO> page, @Param("query") DataCenterQuery query);
+
+
+ void deleteAll();
+ Long getAllVideo();
+ List<String> getIdListVideo();
+
+ /**
+ * 鎵归噺淇敼璁惧鍘傚晢绫诲瀷
+ *
+ * @param list
+ * @return
+ */
+ 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 updateOnlineFromUyOrHk(@Param("onlineList") List<UpdateOnlineVO> onlineList);
+
+ /**
+ * 鏍规嵁鍥芥爣淇敼
+ * @param onlineList
+ */
+ void updateOnlineFromHk(@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);
+
+ List<TMonitorResult> getByIp(@Param("ipList")List<String> ips);
+
+ void clearMonitor();
+
+ List<String> getVideoIds();
+
+ Map<String, String> assetManagementCount();
+
}
--
Gitblit v1.8.0