| | |
|---|
| | | package com.genersoft.iot.vmp.storager.dao; |
|---|
| | | |
|---|
| | | import com.genersoft.iot.vmp.media.zlm.dto.StreamProxyItem; |
|---|
| | | import com.genersoft.iot.vmp.vmanager.bean.ResourceBaceInfo; |
|---|
| | | import org.apache.ibatis.annotations.*; |
|---|
| | | import org.springframework.stereotype.Repository; |
|---|
| | | |
|---|
| | |
|---|
| | | |
|---|
| | | @Select("SELECT st.*, pgs.gbId, pgs.name, pgs.longitude, pgs.latitude FROM stream_proxy st LEFT JOIN gb_stream pgs on st.app = pgs.app AND st.stream = pgs.stream WHERE st.enable_remove_none_reader=true AND st.mediaServerId=#{mediaServerId} order by st.createTime desc") |
|---|
| | | List<StreamProxyItem> selecAutoRemoveItemByMediaServerId(String mediaServerId); |
|---|
| | | |
|---|
| | | @Select("select count(1) as total, sum(status) as online from stream_proxy") |
|---|
| | | ResourceBaceInfo getOverview(); |
|---|
| | | } |
|---|
