package com.genersoft.iot.vmp.storager.impl;

import java.util.*;

import com.genersoft.iot.vmp.common.PageResult;
import com.genersoft.iot.vmp.common.StreamInfo;
import com.genersoft.iot.vmp.conf.MediaServerConfig;
import com.genersoft.iot.vmp.gb28181.bean.DeviceChannel;
import com.genersoft.iot.vmp.storager.dao.DeviceChannelMapper;
import com.genersoft.iot.vmp.storager.dao.DeviceMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import com.genersoft.iot.vmp.common.VideoManagerConstants;
import com.genersoft.iot.vmp.gb28181.bean.Device;
import com.genersoft.iot.vmp.storager.IVideoManagerStorager;
import com.genersoft.iot.vmp.utils.redis.RedisUtil;
import org.springframework.util.StringUtils;

/**    
 * @Description:视频设备数据存储-jdbc实现
 * @author: swwheihei
 * @date:   2020年5月6日 下午2:31:42
 */
@Component
public class VideoManagerStoragerImpl implements IVideoManagerStorager {

	@Autowired
    private DeviceMapper deviceMapper;

	@Autowired
    private DeviceChannelMapper deviceChannelMapper;


	/**
	 * 根据设备ID判断设备是否存在
	 *
	 * @param deviceId 设备ID
	 * @return true:存在  false：不存在
	 */
	@Override
	public boolean exists(String deviceId) {
		return deviceMapper.getDeviceByDeviceId(deviceId) != null;
	}

	/**
	 * 视频设备创建
	 *
	 * @param device 设备对象
	 * @return true：创建成功  false：创建失败
	 */
	@Override
	public boolean create(Device device) {
		return deviceMapper.add(device) > 0;
	}



	/**
	 * 视频设备更新
	 *
	 * @param device 设备对象
	 * @return true：更新成功  false：更新失败
	 */
	@Override
	public boolean updateDevice(Device device) {
//		if (deviceMap.get(device.getDeviceId()) == null) {
//			deviceMap.put(device.getDeviceId(), new HashMap<String, HashSet<String>>());
//		}
		// 更新device中的通道数量
//		device.setChannelCount(deviceMap.get(device.getDeviceId()).size());
		int result = deviceMapper.update(device);
		// 存储device
		return result > 0;


	}

	@Override
	public void updateChannel(String deviceId, DeviceChannel channel) {
		String channelId = channel.getChannelId();
		channel.setDeviceId(deviceId);
		deviceChannelMapper.update(channel);

//		HashMap<String, HashSet<String>> channelMap = deviceMap.get(deviceId);
//		if (channelMap == null) return;
//		// 作为父设备, 确定自己的子节点数
//		if (channelMap.get(channelId) == null) {
//			channelMap.put(channelId, new HashSet<String>());
//		}else if (channelMap.get(channelId).size() > 0) {
//			channel.setSubCount(channelMap.get(channelId).size());
//		}
//
//		// 存储通道
//		redis.set(VideoManagerConstants.CACHEKEY_PREFIX + deviceId +
//						"_" + channel.getChannelId() +
//						"_" + (channel.getStatus() == 1 ? "on":"off") +
//						"_" + (channelMap.get(channelId).size() > 0)+
//						"_" + (StringUtils.isEmpty(channel.getParentId())?null:channel.getParentId()),
//				channel);
//		// 更新device中的通道数量
//		Device device = (Device)redis.get(VideoManagerConstants.DEVICE_PREFIX+deviceId);
//		device.setChannelCount(deviceMap.get(deviceId).size());
//		redis.set(VideoManagerConstants.DEVICE_PREFIX+device.getDeviceId(), device);
//
//
//		// 如果有父设备,更新父设备内子节点数
//		String parentId = channel.getParentId();
//		if (!StringUtils.isEmpty(parentId) && !parentId.equals(deviceId)) {
//
//			if (channelMap.get(parentId) == null) {
//				channelMap.put(parentId, new HashSet<String>());
//			}
//			channelMap.get(parentId).add(channelId);
//
//			DeviceChannel deviceChannel = queryChannel(deviceId, parentId);
//			if (deviceChannel != null) {
//				deviceChannel.setSubCount(channelMap.get(parentId).size());
//				redis.set(VideoManagerConstants.CACHEKEY_PREFIX + deviceId +
//								"_" + deviceChannel.getChannelId() +
//								"_" + (deviceChannel.getStatus() == 1 ? "on":"off") +
//								"_" + (channelMap.get(deviceChannel.getChannelId()).size() > 0)+
//								"_" + (StringUtils.isEmpty(deviceChannel.getParentId())?null:deviceChannel.getParentId()),
//						deviceChannel);
//
//			}
//		}

	}

	/**
	 * 获取设备
	 *
	 * @param deviceId 设备ID
	 * @return Device 设备对象
	 */
	@Override
	public Device queryVideoDevice(String deviceId) {
		return deviceMapper.getDeviceByDeviceId(deviceId);
	}

	@Override
	public PageResult queryChannelsByDeviceId(String deviceId, String query, Boolean hasSubChannel, String online, int page, int count) {
		// 获取到所有正在播放的流
		List<DeviceChannel> result = new ArrayList<>();
		PageResult pageResult = new PageResult<DeviceChannel>();

		deviceChannelMapper.queryChannelsByDeviceId(deviceId);
//		String queryContent = "*";
//		if (!StringUtils.isEmpty(query)) queryContent = String.format("*%S*",query);
//		String queryHasSubChannel = "*";
//		if (hasSubChannel != null) queryHasSubChannel = hasSubChannel?"true":"false";
//		String queryOnline = "*";
//		if (!StringUtils.isEmpty(online)) queryOnline = online;
//		String queryStr = VideoManagerConstants.CACHEKEY_PREFIX + deviceId +
//				"_" + queryContent + // 搜索编号和名称
//				"_" + queryOnline + // 搜索是否在线
//				"_" + queryHasSubChannel + // 搜索是否含有子节点
//				"_" + "*";
//		List<Object> deviceChannelList = redis.scan(queryStr);
//		//对查询结果排序，避免出现通道排列顺序乱序的情况
//		Collections.sort(deviceChannelList,new Comparator<Object>(){
//			@Override
//			public int compare(Object o1, Object o2) {
//				return o1.toString().compareToIgnoreCase(o2.toString());
//			}
//		});
//		pageResult.setPage(page);
//		pageResult.setCount(count);
//		pageResult.setTotal(deviceChannelList.size());
//		int maxCount = (page + 1 ) * count;
//		if (deviceChannelList != null && deviceChannelList.size() > 0 ) {
//			for (int i = page * count; i < (pageResult.getTotal() > maxCount ? maxCount : pageResult.getTotal() ); i++) {
//				DeviceChannel deviceChannel = (DeviceChannel)redis.get((String)deviceChannelList.get(i));
//				StreamInfo streamInfo = stringStreamInfoMap.get(deviceId + "_" + deviceChannel.getChannelId());
//				deviceChannel.setPlay(streamInfo != null);
//				if (streamInfo != null) deviceChannel.setStreamId(streamInfo.getStreamId());
//				result.add(deviceChannel);
//			}
//			pageResult.setData(result);
//		}

		return pageResult;
	}



	@Override
	public List<DeviceChannel> queryChannelsByDeviceId(String deviceId) {
//		List<DeviceChannel> result = new ArrayList<>();
////		List<Object> deviceChannelList = redis.keys(VideoManagerConstants.CACHEKEY_PREFIX + deviceId + "_" + "*");
//		List<Object> deviceChannelList = redis.scan(VideoManagerConstants.CACHEKEY_PREFIX + deviceId + "_" + "*");
//
//		if (deviceChannelList != null && deviceChannelList.size() > 0 ) {
//			for (int i = 0; i < deviceChannelList.size(); i++) {
//				result.add((DeviceChannel)redis.get((String) deviceChannelList.get(i)));
//			}
//		}
		return deviceChannelMapper.queryChannelsByDeviceId(deviceId);
	}

	@Override
	public PageResult querySubChannels(String deviceId, String parentChannelId, String query, Boolean hasSubChannel, String online, int page, int count) {

		deviceChannelMapper.queryChannelsByDeviceId(deviceId, parentChannelId);

//		List<DeviceChannel> allDeviceChannels = new ArrayList<>();
//		String queryContent = "*";
//		if (!StringUtils.isEmpty(query)) queryContent = String.format("*%S*",query);
//		String queryHasSubChannel = "*";
//		if (hasSubChannel != null) queryHasSubChannel = hasSubChannel?"true":"false";
//		String queryOnline = "*";
//		if (!StringUtils.isEmpty(online)) queryOnline = online;
//		String queryStr = VideoManagerConstants.CACHEKEY_PREFIX + deviceId +
//				"_" + queryContent + // 搜索编号和名称
//				"_" + queryOnline + // 搜索是否在线
//				"_" + queryHasSubChannel + // 搜索是否含有子节点
//				"_" + parentChannelId;
//
////		List<Object> deviceChannelList = redis.keys(queryStr);
//		List<Object> deviceChannelList = redis.scan(queryStr);
//
//		if (deviceChannelList != null && deviceChannelList.size() > 0 ) {
//			for (int i = 0; i < deviceChannelList.size(); i++) {
//				DeviceChannel deviceChannel = (DeviceChannel)redis.get((String)deviceChannelList.get(i));
//				if (deviceChannel.getParentId() != null && deviceChannel.getParentId().equals(parentChannelId)) {
//					allDeviceChannels.add(deviceChannel);
//				}
//			}
//		}
//		int maxCount = (page + 1 ) * count;
		PageResult pageResult = new PageResult<DeviceChannel>();
//		pageResult.setPage(page);
//		pageResult.setCount(count);
//		pageResult.setTotal(allDeviceChannels.size());
//
//		if (allDeviceChannels.size() > 0) {
//			pageResult.setData(allDeviceChannels.subList(
//					page * count, pageResult.getTotal() > maxCount ? maxCount : pageResult.getTotal()
//			));
//		}
		return pageResult;
	}

	public List<DeviceChannel> querySubChannels(String deviceId, String parentChannelId) {
		List<DeviceChannel> allDeviceChannels = new ArrayList<>();
//		List<Object> deviceChannelList = redis.keys(VideoManagerConstants.CACHEKEY_PREFIX + deviceId + "_" + "*");
//		List<Object> deviceChannelList = redis.scan(VideoManagerConstants.CACHEKEY_PREFIX + deviceId + "_" + "*");
//
//		if (deviceChannelList != null && deviceChannelList.size() > 0 ) {
//			for (int i = 0; i < deviceChannelList.size(); i++) {
//				DeviceChannel deviceChannel = (DeviceChannel)redis.get((String)deviceChannelList.get(i));
//				if (deviceChannel.getParentId() != null && deviceChannel.getParentId().equals(parentChannelId)) {
//					allDeviceChannels.add(deviceChannel);
//				}
//			}
//		}

		return allDeviceChannels;
	}

	@Override
	public DeviceChannel queryChannel(String deviceId, String channelId) {
		DeviceChannel deviceChannel = null;
		return deviceChannelMapper.queryChannel(deviceId, channelId);
////		List<Object> deviceChannelList = redis.keys(VideoManagerConstants.CACHEKEY_PREFIX + deviceId +
//		List<Object> deviceChannelList = redis.scan(VideoManagerConstants.CACHEKEY_PREFIX + deviceId +
//				"_" + channelId  + "*");
//		if (deviceChannelList != null && deviceChannelList.size() > 0 ) {
//			deviceChannel = (DeviceChannel)redis.get((String)deviceChannelList.get(0));
//		}
//		return deviceChannel;
	}


	/**
	 * 获取多个设备
	 *
	 * @param deviceIds 设备ID数组
	 * @return List<Device> 设备对象数组
	 */
	@Override
	public PageResult<Device> queryVideoDeviceList(String[] deviceIds, int page, int count) {
		List<Device> devices = new ArrayList<>();
		PageResult pageResult = new PageResult<Device>();
//		pageResult.setPage(page);
//		pageResult.setCount(count);
//		Device device = null;
//
//		if (deviceIds == null || deviceIds.length == 0) {
//
////			List<Object> deviceIdList = redis.keys(VideoManagerConstants.DEVICE_PREFIX+"*");
//			List<Object> deviceIdList = redis.scan(VideoManagerConstants.DEVICE_PREFIX+"*");
//			pageResult.setTotal(deviceIdList.size());
//			int maxCount = (page + 1)* count;
//			for (int i = page * count; i < (pageResult.getTotal() > maxCount ? maxCount : pageResult.getTotal() ); i++) {
//				// devices.add((Device)redis.get((String)deviceIdList.get(i)));
//				device =(Device)redis.get((String)deviceIdList.get(i));
//				if (redis.scan(VideoManagerConstants.KEEPLIVEKEY_PREFIX+device.getDeviceId()).size() == 0){
//					// outline(device.getDeviceId());
//				}
//				devices.add(device);
//			}
//		} else {
//			for (int i = 0; i < deviceIds.length; i++) {
//				// devices.add((Device)redis.get(VideoManagerConstants.DEVICE_PREFIX+deviceIds[i]));
//				device = (Device)redis.get(VideoManagerConstants.DEVICE_PREFIX+deviceIds[i]);
//				if (redis.scan(VideoManagerConstants.KEEPLIVEKEY_PREFIX+device.getDeviceId()).size() == 0){
//					// outline(device.getDeviceId());
//				}
//				devices.add(device);
//			}
//		}
//		pageResult.setData(devices);
		return pageResult;
	}

	/**
	 * 获取多个设备
	 *
	 * @return List<Device> 设备对象数组
	 */
	@Override
	public List<Device> queryVideoDeviceList() {

//		if (deviceIds == null || deviceIds.length == 0) {
////			List<Object> deviceIdList = redis.keys(VideoManagerConstants.DEVICE_PREFIX+"*");
//			List<Object> deviceIdList = redis.scan(VideoManagerConstants.DEVICE_PREFIX+"*");
//			for (int i = 0; i < deviceIdList.size(); i++) {
//				device =(Device)redis.get((String)deviceIdList.get(i));
//				if (redis.scan(VideoManagerConstants.KEEPLIVEKEY_PREFIX+device.getDeviceId()).size() == 0){
//					outline(device.getDeviceId());
//				}
//				devices.add(device);
//			}
//		} else {
//			for (int i = 0; i < deviceIds.length; i++) {
//				device = (Device)redis.get(VideoManagerConstants.DEVICE_PREFIX+deviceIds[i]);
//				if (redis.scan(VideoManagerConstants.KEEPLIVEKEY_PREFIX+device.getDeviceId()).size() == 0){
//					outline(device.getDeviceId());
//				}
//				devices.add(device);
//			}
//		}

		List<Device> deviceList =  deviceMapper.getDevices();
		return deviceList;
	}

	/**
	 * 删除设备
	 *
	 * @param deviceId 设备ID
	 * @return true：删除成功  false：删除失败
	 */
	@Override
	public boolean delete(String deviceId) {
		int result = deviceMapper.del(deviceId);

		return result > 0;
	}

	/**
	 * 更新设备在线
	 *
	 * @param deviceId 设备ID
	 * @return true：更新成功  false：更新失败
	 */
	@Override
	public boolean online(String deviceId) {
		Device device = deviceMapper.getDeviceByDeviceId(deviceId);
		device.setOnline(1);
		return deviceMapper.update(device) > 0;
	}

	/**
	 * 更新设备离线
	 *
	 * @param deviceId 设备ID
	 * @return true：更新成功  false：更新失败
	 */
	@Override
	public boolean outline(String deviceId) {
//		Device device = (Device)redis.get(VideoManagerConstants.DEVICE_PREFIX+deviceId);
//		if (device == null) return false;
//		device.setOnline(0);
//		return redis.set(VideoManagerConstants.DEVICE_PREFIX+device.getDeviceId(), device);

		Device device = deviceMapper.getDeviceByDeviceId(deviceId);
		device.setOnline(0);
		return deviceMapper.update(device) > 0;
	}


	@Override
	public void cleanChannelsForDevice(String deviceId) {
		int result = deviceChannelMapper.cleanChannelsByDeviceId(deviceId);
	}


}