648540858
2023-06-20 fa62ab9a0143433a5d058ab3229a37e4a9a0f696
src/main/java/com/genersoft/iot/vmp/storager/dao/DeviceChannelMapper.java
@@ -451,10 +451,18 @@
    @Select("select count(1) from wvp_device_channel")
    int getAllChannelCount();
    /*=================设备主子码流逻辑START==============*/
    // 设备主子码流逻辑START
    @Update(value = {"UPDATE wvp_device_channel SET stream_id=null WHERE device_id=#{deviceId}"})
    void clearPlay(String deviceId);
    /*=================设备主子码流逻辑END==============*/
    // 设备主子码流逻辑END
    @Select(value = {" <script>" +
            "select * " +
            "from device_channel " +
            "where device_id=#{deviceId}" +
            " <if test='parentId != null '> and parent_id = #{parentId} </if>" +
            " <if test='parentId == null '> and parent_id is null </if>" +
            " <if test='onlyCatalog == true '> and parental = 1 </if>" +
            " </script>"})
    List<DeviceChannel> getSubChannelsByDeviceId(String deviceId, String parentId, boolean onlyCatalog);
}