|  |  | 
 |  |  |     */ | 
 |  |  |    @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; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |          logger.error("向数据库添加流代理失败:", e); | 
 |  |  |          dataSourceTransactionManager.rollback(transactionStatus); | 
 |  |  |       } | 
 |  |  |  | 
 |  |  |  | 
 |  |  |       return result; | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | 
 |  |  |    public StreamProxyItem getStreamProxyByAppAndStream(String app, String streamId) { | 
 |  |  |       return streamProxyMapper.selectOne(app, streamId); | 
 |  |  |    } | 
 |  |  |  | 
 |  |  | } |