From 0a1af1f220a6b47db08bc6d2e2b9660d08fe59ed Mon Sep 17 00:00:00 2001 From: xiangpei <xiangpei@timesnew.cn> Date: 星期五, 16 八月 2024 13:38:47 +0800 Subject: [PATCH] leftjoin --- ycl-server/src/main/java/com/ycl/platform/mapper/TMonitorMapper.java | 61 +++++++++++++++++++++++++++++- 1 files changed, 58 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 0132e86..922d206 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,8 +1,15 @@ 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.Param; import java.util.List; import java.util.Map; @@ -29,8 +36,15 @@ * @param tMonitor 璁惧璧勪骇 * @return 璁惧璧勪骇闆嗗悎 */ - public List<TMonitorVO> selectTMonitorList(TMonitor tMonitor); + public List<TMonitorVO> selectTMonitorList(TMonitorVO tMonitor); + /** + * 鏌ヨ璁惧璧勪骇鍒楄〃 + * + * @param tMonitor 璁惧璧勪骇 + * @return 璁惧璧勪骇闆嗗悎 + */ + public List<TMonitorVO> selectMonitorVOList(); /** * 鏂板璁惧璧勪骇 * @@ -65,10 +79,51 @@ /** * 鑾峰彇瑙嗛缁熻 - * @param cameraFunType 绫诲瀷 + * @param tMonitor 鏉′欢 * @return 缁熻鏁� */ Map<String, String> getVideoCount(TMonitor tMonitor); - Map<String, String> recoveryException(); + /** + * 鑾峰彇鎭㈠寮傚父璁惧 + * @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 page + * @param query + */ + void assetManagement(IPage<TMonitorVO> page, @Param("query") DataCenterQuery query); } -- Gitblit v1.8.0