package com.newvideo.util;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

import org.hibernate.Session;

import com.newvideo.dao.BaseDao;
import com.newvideo.domain.VideoBanQuan;
import com.newvideo.domain.VideoBanQuanVideo;
import com.newvideo.domain.VideoInfo;
import com.newvideo.domain.VideoType;

public class BanQuanUtil {
	static HibernateSessionFactory hibernateSessionFactory;
	public static void addBanQuan(VideoBanQuan banquan) {
		BaseDao<VideoBanQuan> dao = new BaseDao<VideoBanQuan>();
		List<VideoBanQuan> list = dao.list(
				"from VideoBanQuan v where v.name=? and v.videoResource.id=? and v.videoType="
						+ banquan.getVideoType(),
				new String[] { banquan.getName(),
						banquan.getVideoResource().getId() });
		if (list == null || list.size() == 0)
			dao.create(banquan);
	}

	public static void addBanQuan(List<VideoBanQuan> banquanList) {
		BaseDao<VideoBanQuan> dao = new BaseDao<VideoBanQuan>();
		for (VideoBanQuan banquan : banquanList) {
			List<VideoBanQuan> list = dao.list(
					"from VideoBanQuan v where v.name=? and v.videoResource.id=? and v.videoType="
							+ banquan.getVideoType(),
					new String[] { banquan.getName(),
							banquan.getVideoResource().getId() });
			if (list == null || list.size() == 0)
				dao.create(banquan);
		}
	}

	public static void updateBanQuan(VideoBanQuan video) {
		BaseDao<VideoBanQuan> dao = new BaseDao<VideoBanQuan>();
		dao.update(video);
	}

	/**
	 * 是否可以显示视频
	 * 
	 * @param videoInfo
	 * @return
	 */
	public static List<Serializable> filterShowVideo(String detailSystem,
			List<Serializable> vlist, Session session) {
		List<Serializable> videoList = new ArrayList<Serializable>();
		for (Serializable videoInfo : vlist) {
			@SuppressWarnings("unchecked")
			List<VideoBanQuan> list = session
					.createQuery(
							"from VideoBanQuan v where v.name=? and v.show>0 and v.detailSystem.id="
									+ detailSystem)
					.setParameter(0, ((VideoInfo) videoInfo).getName()).list();
			if (list == null || list.size() == 0)
				videoList.add((VideoInfo) videoInfo);
		}
		return videoList;
	}

	public static List<Serializable> filterShowVideo(List<Serializable> vlist,
			Session session) {
		List<Serializable> videoList = new ArrayList<Serializable>();
		for (Serializable videoInfo : vlist) {
			@SuppressWarnings("unchecked")
			List<VideoBanQuan> list = session
					.createQuery(
							"from VideoBanQuan v where v.name=? and v.show>0")
					.setParameter(0, ((VideoInfo) videoInfo).getName()).list();
			if (list == null || list.size() == 0)
				videoList.add((VideoInfo) videoInfo);
		}
		return videoList;
	}

	public static void hiddenVideo() {
		BaseDao<VideoBanQuan> dao = new BaseDao<VideoBanQuan>();
		BaseDao<VideoInfo> videoDao = new BaseDao<VideoInfo>();
		List<VideoBanQuan> list = dao
				.list("from VideoBanQuan v where v.show=1");
		for (VideoBanQuan video : list) {
			List<VideoInfo> li = videoDao.list(
					"from VideoInfo info where info.name=?",
					new String[] { video.getName() });
			for (VideoInfo vi : li) {
				if (getRootType(vi.getVideoType()).getId() == video
						.getVideoType()) {
					vi.setShow("0");
					videoDao.update(vi);
				}
			}
		}
	}

	public static void addBanQuanVideo() {
		BaseDao<VideoBanQuan> dao = new BaseDao<VideoBanQuan>();
		BaseDao<VideoBanQuanVideo> banquanDao = new BaseDao<VideoBanQuanVideo>();
		BaseDao<VideoInfo> videoDao = new BaseDao<VideoInfo>();
		List<VideoBanQuan> list = dao
				.list("from VideoBanQuan v where v.show=1");
		for (VideoBanQuan video : list) {
			List<VideoInfo> li = videoDao.list(
					"from VideoInfo info where info.name=? and info.show=1",
					new String[] { video.getName() });
			for (VideoInfo vi : li) {
				if (getRootType(vi.getVideoType()).getId() == video
						.getVideoType()) {
					VideoBanQuanVideo vb = new VideoBanQuanVideo();
					vb.setCreatetime(System.currentTimeMillis() + "");
					vb.setInfo(vi);
					banquanDao.create(vb);
				}
			}
		}
	}

	public static void showVideo() {
		BaseDao<VideoBanQuan> dao = new BaseDao<VideoBanQuan>();
		BaseDao<VideoInfo> videoDao = new BaseDao<VideoInfo>();
		List<VideoBanQuan> list = dao
				.list("from VideoBanQuan v where v.show=true");
		for (VideoBanQuan video : list) {
			List<VideoInfo> li = videoDao.list(
					"from VideoInfo info where info.name=?",
					new String[] { video.getName() });
			for (VideoInfo vi : li) {
				if (getRootType(vi.getVideoType()).getId() == video
						.getVideoType()) {
					vi.setShow("0");
					videoDao.update(vi);
				}
			}
		}
	}

	@SuppressWarnings("rawtypes")
	public static boolean isContainsBanquanKey(String name,
			String detailSsystemId) {
		Session session = hibernateSessionFactory.getSession();
		List list = null;
		try {
			list = session
					.createSQLQuery(
							"select * from wk_video_banquan b where b.detailsystem=? and b.name=? and b.show>0")
					.setParameter(0, detailSsystemId).setParameter(1, name)
					.list();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			session.close();
		}
		if (list == null || list.size() == 0) {
			return false;
		} else
			return true;
	}

	public static VideoType getRootType(VideoType type) {
		while (type.getParent() != null)
			type = type.getParent();
		return type;
	}

}