|  |  | 
 |  |  | package com.genersoft.iot.vmp.storager.dao; | 
 |  |  |  | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.DeviceChannel; | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.ParentPlatform; | 
 |  |  | import com.genersoft.iot.vmp.vmanager.platform.bean.ChannelReduce; | 
 |  |  | import com.genersoft.iot.vmp.vmanager.gb28181.platform.bean.ChannelReduce; | 
 |  |  | import org.apache.ibatis.annotations.*; | 
 |  |  | import org.springframework.stereotype.Repository; | 
 |  |  |  | 
 |  |  | 
 |  |  |             " WHERE 1=1 " + | 
 |  |  |             " <if test=\"hasSubChannel == true\" >  AND subCount >0</if>" + | 
 |  |  |             " <if test=\"hasSubChannel == false\" >  AND subCount=0</if>" + | 
 |  |  |             " ORDER BY channelId ASC" + | 
 |  |  |             " </script>"}) | 
 |  |  |     List<DeviceChannel> queryChannelsByDeviceId(String deviceId, String parentChannelId, String query, Boolean hasSubChannel, Boolean online); | 
 |  |  |  | 
 |  |  | 
 |  |  |             " <if test=\"hasSubChannel!= null and hasSubChannel == false\" >  AND subCount=0</if> " + | 
 |  |  |             " <if test=\"platformId != null and inPlatform == true \" >  AND platformId='${platformId}'</if> " + | 
 |  |  |             " <if test=\"platformId != null and inPlatform == false \" >  AND (platformId != '${platformId}' OR platformId is NULL )  </if> " + | 
 |  |  |             " ORDER BY deviceId, channelId ASC" + | 
 |  |  |             " </script>"}) | 
 |  |  |  | 
 |  |  |     List<ChannelReduce> queryChannelListInAll(String query, Boolean online, Boolean hasSubChannel, String platformId, Boolean inPlatform); |