| | |
|---|
| | | "where dc.channel_id = #{channelId} and pgc.platform_id=#{platformId}") |
|---|
| | | List<Device> queryDeviceInfoByPlatformIdAndChannelId(@Param("platformId") String platformId, @Param("channelId") String channelId); |
|---|
| | | |
|---|
| | | @Select("SELECT pgc.platform_id from wvp_platform_gb_channel pgc left join wvp_device_channel dc on dc.id = pgc.device_channel_id WHERE dc.channel_id='${channelId}'") |
|---|
| | | List<String> queryParentPlatformByChannelId(String channelId); |
|---|
| | | @Select("SELECT pgc.platform_id from wvp_platform_gb_channel pgc left join wvp_device_channel dc on dc.id = pgc.device_channel_id WHERE dc.channel_id=#{channelId}") |
|---|
| | | List<String> queryParentPlatformByChannelId(@Param("channelId") String channelId); |
|---|
| | | } |
|---|
