package com.cnpoint.myspaces.user.dao.hibernate;



import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.HibernateCallback;

import com.cnpoint.myspaces.common.util.BaseDAOHibernate;

import com.cnpoint.myspaces.user.dao.UserDAO;
import com.cnpoint.myspaces.user.model.UserInfo;

public class UserDAOHibernateImpl extends BaseDAOHibernate implements UserDAO{
	private static final String LOAD_BY_USERNAME = "from UserInfo ui where ui.username = ?";
	private static final String LOAD_BY_PASSWD = "from UserInfo ui where ui.username = ? and ui.password = ?";
	private static final String LOAD_ALL_COUNT = " select count(*) from UserInfo ui";
	public void saveUserInfo(UserInfo obj) {
		// TODO Auto-generated method stub
		getHibernateTemplate().save(obj);
	}

	public void updateUserInfo(UserInfo obj) {
		// TODO Auto-generated method stub
		getHibernateTemplate().update(obj);
	}	
	public UserInfo findUserInfoByPasswd(String username, String passwd) {
		Object[] values = {username, passwd};
	    List l = getHibernateTemplate().find(LOAD_BY_PASSWD, values);
	    if (l.size() == 0) {
	      return null;
	    }
	    else {
	      return (UserInfo) l.get(0);
	    }
	}

	public List findUserInfoList(final int offset,final int length) {
		// TODO Auto-generated method stub
		 return getHibernateTemplate().executeFind(new HibernateCallback() {
		      public Object doInHibernate(Session s) throws HibernateException, SQLException {
		          String q = "from UserInfo" +
		          " userinfo ";

		          Query query = s.createQuery(q);
		          query.setFirstResult(offset);
		          query.setMaxResults(length);
		          List list = query.list();
		          return list;

		      }
		    });
	}
	public UserInfo findUserInfoById(Long id) {
	    try {
	      return (UserInfo) getHibernateTemplate().get(UserInfo.class, id);
	    }
	    catch (DataAccessException ex) {
	      return null;
	    }
	  }

	  /**
	   *
	   * @param username String
	   * @return UserInfo
	   * @todo Implement this com.laoer.bbscs.dao.IUserInfoDAO method
	   */
	  public UserInfo findUserInfoByUserName(String username) {
	    List l = getHibernateTemplate().find(LOAD_BY_USERNAME, username);
	    if (l.size() == 0) {
	      return null;
	    }
	    else {
	      return (UserInfo) l.get(0);
	    }
	  }


	public int getAllUserNum() {
		// TODO Auto-generated method stub
		try {
		      List l = getHibernateTemplate().find(LOAD_ALL_COUNT);
		      if (!l.isEmpty()) {
		        return ( (Integer) l.get(0)).intValue();
		      }
		      else {
		        return 0;
		      }
		    }
		    catch (DataAccessException ex) {
		      logger.error(ex);
		      return 0;
		    }
	}

   // return value =1 不可以刪除 value=0 可以刪除
	public int delete(String username,String id) {
		// TODO Auto-generated method stub
		UserInfo u = new UserInfo();
		u.setId(id);
		u.setUsername(username);
		
		int value = 0;
		String hsql = "from Document doc where doc.beginUser='"+username+"' or doc.endUser='"+username+"' ";
		List l = getHibernateTemplate().find(hsql);
		if(!l.isEmpty()){
			value = 1;
		}else{
			getHibernateTemplate().delete(u);
			value = 0;
		}
		return value;

	}

}