|  |  | 
 |  |  | import com.genersoft.iot.vmp.media.zlm.dto.MediaServerItem; | 
 |  |  | import com.genersoft.iot.vmp.media.zlm.dto.StreamProxyItem; | 
 |  |  | import com.genersoft.iot.vmp.media.zlm.dto.StreamPushItem; | 
 |  |  | import com.genersoft.iot.vmp.service.IGbStreamService; | 
 |  |  | import com.genersoft.iot.vmp.storager.IRedisCatchStorage; | 
 |  |  | import com.genersoft.iot.vmp.storager.IVideoManagerStorager; | 
 |  |  | import com.genersoft.iot.vmp.storager.dao.*; | 
 |  |  | 
 |  |  | import org.springframework.transaction.TransactionDefinition; | 
 |  |  | import org.springframework.transaction.TransactionStatus; | 
 |  |  | import org.springframework.transaction.annotation.Transactional; | 
 |  |  | import org.springframework.util.StringUtils; | 
 |  |  |  | 
 |  |  | import java.text.SimpleDateFormat; | 
 |  |  | import java.util.ArrayList; | 
 |  |  | 
 |  |  |  | 
 |  |  |    @Autowired | 
 |  |  |     private GbStreamMapper gbStreamMapper; | 
 |  |  | ; | 
 |  |  |  | 
 |  |  |    @Autowired | 
 |  |  |     private PlatformGbStreamMapper platformGbStreamMapper; | 
 |  |  |  | 
 |  |  |    @Autowired | 
 |  |  |     private IGbStreamService gbStreamService; | 
 |  |  |  | 
 |  |  |    @Autowired | 
 |  |  |     private ParentPlatformMapper parentPlatformMapper; | 
 |  |  |  | 
 |  |  |    @Autowired | 
 |  |  |     private VideoStreamSessionManager streamSession; | 
 |  |  | 
 |  |  |     */ | 
 |  |  |    @Override | 
 |  |  |    public synchronized boolean create(Device device) { | 
 |  |  |       redisCatchStorage.updateDevice(device); | 
 |  |  |       return deviceMapper.add(device) > 0; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |       Device deviceByDeviceId = deviceMapper.getDeviceByDeviceId(device.getDeviceId()); | 
 |  |  |       if (deviceByDeviceId == null) { | 
 |  |  |          device.setCreateTime(now); | 
 |  |  |          redisCatchStorage.updateDevice(device); | 
 |  |  |          return deviceMapper.add(device) > 0; | 
 |  |  |       }else { | 
 |  |  |          redisCatchStorage.updateDevice(device); | 
 |  |  |          return deviceMapper.update(device) > 0; | 
 |  |  |       } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |          deviceChannelMapper.add(channel); | 
 |  |  |       }else { | 
 |  |  |          deviceChannelMapper.update(channel); | 
 |  |  |       } | 
 |  |  |    } | 
 |  |  |  | 
 |  |  |    @Override | 
 |  |  |    public void updateChannels(String deviceId, List<DeviceChannel> channels) { | 
 |  |  |       List<DeviceChannel> addChannels = new ArrayList<>(); | 
 |  |  |       List<DeviceChannel> updateChannels = new ArrayList<>(); | 
 |  |  |       HashMap<String, DeviceChannel> channelsInStore = new HashMap<>(); | 
 |  |  |       if (channels != null && channels.size() > 0) { | 
 |  |  |          List<DeviceChannel> channelList = deviceChannelMapper.queryChannelsByDeviceId(deviceId); | 
 |  |  |          if (channelList.size() == 0) { | 
 |  |  |             for (DeviceChannel channel : channels) { | 
 |  |  |                channel.setDeviceId(deviceId); | 
 |  |  |                channel.setStreamId(streamSession.getStreamId(deviceId, channel.getChannelId())); | 
 |  |  |                String now = this.format.format(System.currentTimeMillis()); | 
 |  |  |                channel.setUpdateTime(now); | 
 |  |  |                channel.setCreateTime(now); | 
 |  |  |                addChannels.add(channel); | 
 |  |  |             } | 
 |  |  |          }else { | 
 |  |  |             for (DeviceChannel deviceChannel : channelList) { | 
 |  |  |                channelsInStore.put(deviceChannel.getChannelId(), deviceChannel); | 
 |  |  |             } | 
 |  |  |             for (DeviceChannel channel : channels) { | 
 |  |  |                String channelId = channel.getChannelId(); | 
 |  |  |                channel.setDeviceId(deviceId); | 
 |  |  |                channel.setStreamId(streamSession.getStreamId(deviceId, channel.getChannelId())); | 
 |  |  |                String now = this.format.format(System.currentTimeMillis()); | 
 |  |  |                channel.setUpdateTime(now); | 
 |  |  |                if (channelsInStore.get(channel.getChannelId()) != null) { | 
 |  |  |                   updateChannels.add(channel); | 
 |  |  |                }else { | 
 |  |  |                   addChannels.add(channel); | 
 |  |  |                   channel.setCreateTime(now); | 
 |  |  |                } | 
 |  |  |             } | 
 |  |  |          } | 
 |  |  |          int limitCount = 300; | 
 |  |  |          if (addChannels.size() > 0) { | 
 |  |  |             if (addChannels.size() > limitCount) { | 
 |  |  |                for (int i = 0; i < addChannels.size(); i += limitCount) { | 
 |  |  |                   int toIndex = i + limitCount; | 
 |  |  |                   if (i + limitCount > addChannels.size()) { | 
 |  |  |                      toIndex = addChannels.size(); | 
 |  |  |                   } | 
 |  |  |                   deviceChannelMapper.batchAdd(addChannels.subList(i, toIndex)); | 
 |  |  |                } | 
 |  |  |             }else { | 
 |  |  |                deviceChannelMapper.batchAdd(addChannels); | 
 |  |  |             } | 
 |  |  |          } | 
 |  |  |          if (updateChannels.size() > 0) { | 
 |  |  |             if (updateChannels.size() > limitCount) { | 
 |  |  |                for (int i = 0; i < updateChannels.size(); i += limitCount) { | 
 |  |  |                   int toIndex = i + limitCount; | 
 |  |  |                   if (i + limitCount > updateChannels.size()) { | 
 |  |  |                      toIndex = updateChannels.size(); | 
 |  |  |                   } | 
 |  |  |                   deviceChannelMapper.batchAdd(updateChannels.subList(i, toIndex)); | 
 |  |  |                } | 
 |  |  |             }else { | 
 |  |  |                deviceChannelMapper.batchUpdate(updateChannels); | 
 |  |  |             } | 
 |  |  |          } | 
 |  |  |       } | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |    public PageInfo queryChannelsByDeviceId(String deviceId, String query, Boolean hasSubChannel, Boolean online, int page, int count) { | 
 |  |  |       // 获取到所有正在播放的流 | 
 |  |  |       PageHelper.startPage(page, count); | 
 |  |  |       List<DeviceChannel> all = deviceChannelMapper.queryChannelsByDeviceId(deviceId, null, query, hasSubChannel, online); | 
 |  |  |       List<DeviceChannel> all = deviceChannelMapper.queryChannels(deviceId, null, query, hasSubChannel, online); | 
 |  |  |       return new PageInfo<>(all); | 
 |  |  |    } | 
 |  |  |  | 
 |  |  |    @Override | 
 |  |  |    public List<DeviceChannel> queryChannelsByDeviceId(String deviceId) { | 
 |  |  |       return deviceChannelMapper.queryChannelsByDeviceId(deviceId, null,null, null, null); | 
 |  |  |       return deviceChannelMapper.queryChannels(deviceId, null,null, null, null); | 
 |  |  |    } | 
 |  |  |  | 
 |  |  |    @Override | 
 |  |  |    public PageInfo<DeviceChannel> querySubChannels(String deviceId, String parentChannelId, String query, Boolean hasSubChannel, String online, int page, int count) { | 
 |  |  |       PageHelper.startPage(page, count); | 
 |  |  |       List<DeviceChannel> all = deviceChannelMapper.queryChannelsByDeviceId(deviceId, parentChannelId, null, null, null); | 
 |  |  |       List<DeviceChannel> all = deviceChannelMapper.queryChannels(deviceId, parentChannelId, null, null, null); | 
 |  |  |       return new PageInfo<>(all); | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |       } | 
 |  |  |       device.setOnline(1); | 
 |  |  |       logger.info("更新设备在线: " + deviceId); | 
 |  |  |       redisCatchStorage.updateDevice(device); | 
 |  |  |       return deviceMapper.update(device) > 0; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |       Device device = deviceMapper.getDeviceByDeviceId(deviceId); | 
 |  |  |       if (device == null) return false; | 
 |  |  |       device.setOnline(0); | 
 |  |  |       redisCatchStorage.updateDevice(device); | 
 |  |  |       return deviceMapper.update(device) > 0; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |       // 更新缓存 | 
 |  |  |       parentPlatformCatch.setParentPlatform(parentPlatform); | 
 |  |  |       redisCatchStorage.updatePlatformCatchInfo(parentPlatformCatch); | 
 |  |  |       // 共享所有视频流,需要将现有视频流添加到此平台 | 
 |  |  |       List<GbStream> gbStreams = gbStreamMapper.selectAll(); | 
 |  |  |       if (gbStreams.size() > 0) { | 
 |  |  |          if (parentPlatform.isShareAllLiveStream()) { | 
 |  |  |             gbStreamService.addPlatformInfo(gbStreams, parentPlatform.getServerGBId()); | 
 |  |  |          }else { | 
 |  |  |             gbStreamService.delPlatformInfo(gbStreams); | 
 |  |  |          } | 
 |  |  |       } | 
 |  |  |       return result > 0; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |          logger.error("向数据库添加流代理失败:", e); | 
 |  |  |          dataSourceTransactionManager.rollback(transactionStatus); | 
 |  |  |       } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |       return result; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |     * @return | 
 |  |  |     */ | 
 |  |  |    @Override | 
 |  |  |    public GbStream queryStreamInParentPlatform(String platformId, String gbId) { | 
 |  |  |    public List<GbStream> queryStreamInParentPlatform(String platformId, String gbId) { | 
 |  |  |       return gbStreamMapper.queryStreamInPlatform(platformId, gbId); | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |       streamPushMapper.del(streamPushItem.getApp(), streamPushItem.getStream()); | 
 |  |  |       streamPushMapper.add(streamPushItem); | 
 |  |  |       gbStreamMapper.setStatus(streamPushItem.getApp(), streamPushItem.getStream(), true); | 
 |  |  |       if(!StringUtils.isEmpty(streamPushItem.getGbId() )){ | 
 |  |  |          // 查找开启了全部直播流共享的上级平台 | 
 |  |  |          List<ParentPlatform> parentPlatforms = parentPlatformMapper.selectAllAhareAllLiveStream(); | 
 |  |  |          if (parentPlatforms.size() > 0) { | 
 |  |  |             for (ParentPlatform parentPlatform : parentPlatforms) { | 
 |  |  |                streamPushItem.setPlatformId(parentPlatform.getServerGBId()); | 
 |  |  |                String stream = streamPushItem.getStream(); | 
 |  |  |                StreamProxyItem streamProxyItems = platformGbStreamMapper.selectOne(streamPushItem.getApp(), stream, parentPlatform.getServerGBId()); | 
 |  |  |                if (streamProxyItems == null) { | 
 |  |  |                   platformGbStreamMapper.add(streamPushItem); | 
 |  |  |                } | 
 |  |  |  | 
 |  |  |             } | 
 |  |  |          } | 
 |  |  |       } | 
 |  |  |  | 
 |  |  |    } | 
 |  |  |  | 
 |  |  |    @Override | 
 |  |  | 
 |  |  |    public StreamProxyItem getStreamProxyByAppAndStream(String app, String streamId) { | 
 |  |  |       return streamProxyMapper.selectOne(app, streamId); | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | } |