From 46aaf9e30acf14a777cda37fe761b3b39e53f568 Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期二, 03 九月 2024 15:51:21 +0800 Subject: [PATCH] 数据中心优化 --- ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 84 +++++++++++++++++++++++++++++++++++++++++- 1 files changed, 82 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 6b1267f..0f5bf2e 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,19 @@ 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.query.DashboardQuery; +import com.ycl.platform.domain.query.DataCenterQuery; +import com.ycl.platform.domain.query.HomeQuery; import com.ycl.platform.domain.vo.TMonitorVO; +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.List; +import java.util.Map; /** * 璁惧璧勪骇Mapper鎺ュ彛 @@ -11,7 +21,8 @@ * @author ruoyi * @date 2024-03-04 */ -public interface TMonitorMapper +@Mapper +public interface TMonitorMapper extends BaseMapper<TMonitor> { /** * 鏌ヨ璁惧璧勪骇 @@ -27,8 +38,15 @@ * @param tMonitor 璁惧璧勪骇 * @return 璁惧璧勪骇闆嗗悎 */ - public List<TMonitorVO> selectTMonitorList(TMonitor tMonitor); + public List<TMonitorVO> selectTMonitorList(TMonitorVO tMonitor); + /** + * 鏌ヨ璁惧璧勪骇鍒楄〃 + * + * @param tMonitor 璁惧璧勪骇 + * @return 璁惧璧勪骇闆嗗悎 + */ + public List<TMonitorVO> selectMonitorVOList(); /** * 鏂板璁惧璧勪骇 * @@ -60,4 +78,66 @@ * @return 缁撴灉 */ public int deleteTMonitorByIds(Long[] ids); + + /** + * 鑾峰彇瑙嗛缁熻 + * @param tMonitor 鏉′欢 + * @return 缁熻鏁� + */ + Map<String, String> getVideoCount(TMonitor tMonitor); + + /** + * 鑾峰彇鎭㈠寮傚父璁惧 + * @param time 鏃堕棿 + * @return 鏁版嵁 + */ + Map<String, String> recoveryException(String time); + + /** + * 鑾峰彇鎭㈠寮傚父鎸佺画鍏虫敞璁惧 + * @return 璁惧 + */ + List<TMonitorVO> selectRecoveryMonitor(String time); + + /** + * 棣栭〉鎶樼嚎鍥� + * @param monitorQuery 鏌ヨ鏉′欢 + * @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); } -- Gitblit v1.8.0