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 | 43 ++++++++++++++++++++++++++++++++++++++++--- 1 files changed, 40 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 239924e..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 @@ -3,14 +3,18 @@ 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; @@ -47,6 +51,7 @@ * @return 璁惧璧勪骇闆嗗悎 */ public List<TMonitorVO> selectMonitorVOList(); + /** * 鏂板璁惧璧勪骇 * @@ -84,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); /** * 鑾峰彇鎭㈠寮傚父鎸佺画鍏虫敞璁惧 @@ -137,5 +142,37 @@ * @param list * @return */ - int batchUpdateDeviceType(@Param("list") List<TMonitor> list); + 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