朱俊杰
2022-01-25 40657033175bbecb983654f43208d9c2c3e37bb6
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> ")