From d268f82d25c25ebdc7a1ea30614f6cda6d3a9ae3 Mon Sep 17 00:00:00 2001 From: fuliqi <fuliqi@qq.com> Date: 星期四, 10 十月 2024 16:31:41 +0800 Subject: [PATCH] win库+大屏考核指标查询bug --- ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 91 ++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 88 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 64d6023..a8b4676 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,9 +1,20 @@ 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.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.List; import java.util.Map; @@ -14,6 +25,7 @@ * @author ruoyi * @date 2024-03-04 */ +@Mapper public interface TMonitorMapper extends BaseMapper<TMonitor> { /** @@ -30,7 +42,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 +89,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); /** * 鑾峰彇鎭㈠寮傚父鎸佺画鍏虫敞璁惧 @@ -90,4 +110,69 @@ * @return 鏁版嵁 */ List<Map<String, Object>> home(HomeQuery monitorQuery); + + List<TMonitorVO> selectListByIds(List<String> list); + + /** + * 澶у睆璁惧鎬绘暟 + * @param dashboardQuery 鏌ヨ鏉′欢 + * @return 鏁版嵁 + */ + List<MonitorTotalVO> monitorTotal(DashboardQuery dashboardQuery); + + /** + * 澶у睆璁惧姝e父鐜� + * @return 鏁版嵁 + */ + List<MonitorRateVO> monitorRate(DashboardQuery dashboardQuery); + + /** + * 鏁版嵁涓績-璧勪骇绠$悊 + * + * @param query + */ + IPage assetManagement(IPage<TMonitorVO> page, @Param("query") DataCenterQuery query); + + + void deleteAll(); + + /** + * 鎵归噺淇敼璁惧鍘傚晢绫诲瀷 + * + * @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 updateOnline(@Param("onlineList") List<UpdateOnlineVO> onlineList); + + + /** + * 鐐逛綅鍦ㄧ嚎鐜� + * + * @param tMonitor 璁惧璧勪骇 + * @return 璁惧璧勪骇闆嗗悎 + */ + public List<TMonitorResult> selectMonitorResult(VideoExportForm exportForm); } -- Gitblit v1.8.0