| | |
| | | " <if test='hasSubChannel == false' > AND dc.subCount = 0 </if>" + |
| | | "GROUP BY dc.channelId " + |
| | | " </script>"}) |
| | | List<DeviceChannel> queryChannelsCar(String deviceId, String parentChannelId, String query,String type, Boolean hasSubChannel, Boolean online); |
| | | List<DeviceChannel> queryChannelsCar(String deviceId, String parentChannelId, String query, String type, Boolean hasSubChannel, Boolean online); |
| | | @Select(value = {" <script>" + |
| | | "SELECT " + |
| | | "dc.id,\n" + |
| | |
| | | List<ChannelReduce> queryChannelListInAll(String query, Boolean online, Boolean hasSubChannel, String platformId, String catalogId); |
| | | |
| | | @Select("SELECT * FROM device_channel_police_camera WHERE channelId=#{channelId}") |
| | | List<DeviceChannel> queryChannelByChannelId( String channelId); |
| | | List<DeviceChannel> queryChannelByChannelId(String channelId); |
| | | |
| | | @Update(value = {"UPDATE device_channel_police_camera SET status=0 WHERE deviceId=#{deviceId} AND channelId=#{channelId}"}) |
| | | void offline(String deviceId, String channelId); |