| | |
|---|
| | | package com.genersoft.iot.vmp.storager.dao; |
|---|
| | | |
|---|
| | | import com.genersoft.iot.vmp.gb28181.bean.Device; |
|---|
| | | import com.genersoft.iot.vmp.gb28181.bean.DeviceChannel; |
|---|
| | | import com.genersoft.iot.vmp.vmanager.platform.bean.ChannelReduce; |
|---|
| | | import org.apache.ibatis.annotations.Delete; |
|---|
| | |
|---|
| | | @Select("SELECT * FROM device_channel WHERE deviceId = (SELECT deviceId FROM platform_gb_channel WHERE " + |
|---|
| | | "platformId='${platformId}' AND channelId='${channelId}' ) AND channelId='${channelId}'") |
|---|
| | | DeviceChannel queryChannelInParentPlatform(String platformId, String channelId); |
|---|
| | | |
|---|
| | | @Select("SELECT * FROM device WHERE deviceId = (SELECT deviceId FROM platform_gb_channel WHERE platformId='${platformId}' AND channelId='${channelId}')") |
|---|
| | | Device queryVideoDeviceByPlatformIdAndChannelId(String platformId, String channelId); |
|---|
| | | } |
|---|
