package com.hibernate.dao.impl;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import com.hibernate.dao.VocationDao;
import com.hibernate.po.Vocation;
/*
 * 实现类
 */
public class VocationDaoImpl implements VocationDao {

	private SessionFactory sessionFactory;

	public SessionFactory getSessionFactory() {
		return sessionFactory;
	}

	public void setSessionFactory(SessionFactory sessionFactory) {
		this.sessionFactory = sessionFactory;
	}

	// 申请休假
	public Boolean insertVocation(Vocation vocation) {
		Session session = sessionFactory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			session.save(vocation);
			tx.commit();
			return true;
		} catch (HibernateException e) {
			if (tx != null) {
				tx.rollback();// 回滚事务
				return false;
			}
			e.printStackTrace();
		} finally {
			session.close();// 关闭Session,释放资源
		}
		return false;
	}

	// 修改审核状态
	public Boolean updateVocation(int id, String status) {
		Session session = sessionFactory.openSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			String hql = "update Vocation v set v.status='" + status
					+ "' where v.id=" + id;
			Query query = session.createQuery(hql);
			int i = query.executeUpdate();
			if (i == 1) {
				tx.commit();
				return true;
			}
		} catch (HibernateException e) {
			if (tx != null) {
				tx.rollback();// 回滚事务
				return false;
			}
			e.printStackTrace();
		} finally {
			session.close();// 关闭Session,释放资源
		}
		return false;
	}

	// 根据ID获取休假信息
	public Vocation queryVocation(int id) {
		Vocation vocation = null;
		Session session = sessionFactory.openSession();
		String hql = "from Vocation v where v.id=" + id;
		Query query = session.createQuery(hql);
		vocation = (Vocation) query.uniqueResult();
		session.close();// 关闭Session,释放资源
		return vocation;
	}

	// 根据当前用户昵称和权限获取休假信息列表
	public List<Vocation> getVocationsList(String auth, String nickname) {
		List<Vocation> vocationslist = null;
		Session session = sessionFactory.openSession();
		String hql = null;
		if (auth.equals("admin")) {
			hql = "from Vocation v where v.nickname='" + nickname
					+ "' or v.examname='" + nickname + "'";
		} else if (auth.equals("common")) {
			hql = "from Vocation v where v.nickname='" + nickname + "'";
		}
		Query query = session.createQuery(hql);
		vocationslist = query.list();
		session.close();// 关闭Session,释放资源
		return vocationslist;
	}

	// 获取审批人列表
	public List<String> getExamnamesList() {
		List<String> examnamelist = null;
		Session session = sessionFactory.openSession();
		String hql = "select u.nickname from User u where u.auth='admin'";
		Query query = session.createQuery(hql);
		examnamelist = query.list();
		session.close();// 关闭Session,释放资源
		return examnamelist;
	}
}