From 64efb660b2c119c00432434c0f651f8996483f18 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期五, 21 二月 2025 15:51:13 +0800
Subject: [PATCH] OSD大华数据格式+数据中心重点标签统计数

---
 ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java |   64 ++++++++++++++++++++++++++++++-
 1 files changed, 61 insertions(+), 3 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..0bde409 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.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;
 
@@ -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 鏃堕棿
+     * @param monitor 鏃堕棿
      * @return 鏁版嵁
      */
-    Map<String, String> recoveryException(String time);
+    Map<String, String> recoveryException(TMonitorVO monitor);
 
     /**
      * 鑾峰彇鎭㈠寮傚父鎸佺画鍏虫敞璁惧
@@ -140,4 +147,55 @@
     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