From 0a44eb89654ebed5809675211e69c816b1dacf92 Mon Sep 17 00:00:00 2001 From: 648540858 <648540858@qq.com> Date: 星期日, 20 二月 2022 17:33:17 +0800 Subject: [PATCH] 增加配置将国标录像与其他录像分开 --- src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformChannelMapper.java | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformChannelMapper.java b/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformChannelMapper.java index 0991c84..4f5de2b 100644 --- a/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformChannelMapper.java +++ b/src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformChannelMapper.java @@ -83,7 +83,7 @@ "left join platform_gb_channel pgc on " + "pp.serverGBId = pgc.platformId " + "WHERE " + - "pgc.channelId = #{channelId} pp.status = true " + + "pgc.channelId = #{channelId} and pp.status = true " + "AND pp.serverGBId IN" + "<foreach collection='platforms' item='item' open='(' separator=',' close=')' > #{item}</foreach>" + "</script> ") -- Gitblit v1.8.0