|  |  | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.Device; | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.DeviceChannel; | 
 |  |  | import com.genersoft.iot.vmp.gb28181.bean.DeviceChannelInPlatform; | 
 |  |  | import com.genersoft.iot.vmp.vmanager.bean.ResourceBaceInfo; | 
 |  |  | import com.genersoft.iot.vmp.vmanager.gb28181.platform.bean.ChannelReduce; | 
 |  |  | import org.apache.ibatis.annotations.*; | 
 |  |  | import org.springframework.stereotype.Repository; | 
 |  |  | 
 |  |  |  | 
 |  |  |     @Select("select * from device_channel where deviceId = #{deviceId}") | 
 |  |  |     List<DeviceChannel> queryAllChannels(String deviceId); | 
 |  |  |  | 
 |  |  |  | 
 |  |  |     @Select("select count(1) as total, sum(status) as online from device_channel") | 
 |  |  |     ResourceBaceInfo getOverview(); | 
 |  |  | } |