From 9be861abcc9361d714192fe2a233bb2c09213665 Mon Sep 17 00:00:00 2001
From: 648540858 <648540858@qq.com>
Date: 星期二, 18 一月 2022 16:37:11 +0800
Subject: [PATCH] 修复bug与修改通道名

---
 src/main/java/com/genersoft/iot/vmp/storager/dao/PlatformChannelMapper.java |    2 +-
 src/main/java/com/genersoft/iot/vmp/common/VideoManagerConstants.java       |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/main/java/com/genersoft/iot/vmp/common/VideoManagerConstants.java b/src/main/java/com/genersoft/iot/vmp/common/VideoManagerConstants.java
index 7f659ab..ffbed50 100644
--- a/src/main/java/com/genersoft/iot/vmp/common/VideoManagerConstants.java
+++ b/src/main/java/com/genersoft/iot/vmp/common/VideoManagerConstants.java
@@ -64,7 +64,7 @@
 
 	//************************** redis 娑堟伅*********************************
 	public static final String WVP_MSG_STREAM_CHANGE_PREFIX = "WVP_MSG_STREAM_CHANGE_";
-	public static final String WVP_MSG_GPS_PREFIX = "WVP_MSG_GPS_";
+	public static final String WVP_MSG_GPS_PREFIX = "VM_MSG_GPS";
 
 	//**************************    绗笁鏂�  ****************************************
 	public static final String WVP_STREAM_GB_ID_PREFIX = "memberNo_";
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