package com.laoer.bbscs.dao.hibernate;

import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.laoer.bbscs.dao.IFriendDAO;
import com.laoer.bbscs.bean.Friend;
import com.laoer.bbscs.sys.*;
import java.util.*;
import org.springframework.dao.*;
import net.sf.hibernate.*;
import net.sf.hibernate.type.*;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.orm.hibernate.HibernateCallback;
import java.sql.SQLException;

/**
 * <p>Title: TianYi BBS</p>
 * <p>Description: TianYi BBS System</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: LAOER.COM/TIANYISOFT.NET</p>
 * @author laoer
 * @version 6.0
 */

public class FriendHibernateDAO
    extends HibernateDaoSupport implements IFriendDAO {

  private static final Log logger = LogFactory.getLog(FriendHibernateDAO.class);

  public FriendHibernateDAO() {
    super();
  }

  /**
   *
   * @param f Friend
   * @return Friend
   * @todo Implement this com.laoer.bbscs.dao.IFriendDAO method
   */
  public Friend saveFriend(Friend f) {
    try {
      getHibernateTemplate().saveOrUpdate(f);
      return f;
    }
    catch (DataAccessException ex) {
      logger.error("saveFriend(Friend f):" + ex);
      return null;
    }
  }

  /**
   *
   * @param fname String
   * @param ownId long
   * @return Friend
   * @todo Implement this com.laoer.bbscs.dao.IFriendDAO method
   */
  public Friend findMyFriendByName(String fname, long ownId) {
    String q = "from Friend" + SysUtil.getTableID(ownId, Constant.MODNUM10) +
        " f where f.userID = ? and f.fname = ?";
    Object[] o = {
        new Long(ownId), fname};
    List l = getHibernateTemplate().find(q, o);
    if (l.size() == 0) {
      return null;
    }
    else {
      return (Friend) l.get(0);
    }
  }

  public int getMyFriendNum(long ownId, short isBlack) {
    String q = "select count(f.id) from Friend" + SysUtil.getTableID(ownId, Constant.MODNUM10) +
        " f where f.userID = ? and f.isBlack = ?";
    Object[] o = {
        new Long(ownId), new Short(isBlack)};
    try {
      List l = getHibernateTemplate().find(q, o);
      return ( (Integer) l.get(0)).intValue();
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return 0;
    }
  }

  /**
   *
   * @param ownId long
   * @param isBlack short
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.IFriendDAO method
   */
  public List findFriends(long ownId, short isBlack) {
    String q = "from Friend" + SysUtil.getTableID(ownId, Constant.MODNUM10) +
        " f where f.userID = ? and f.isBlack = ?";
    Object[] o = {
        new Long(ownId), new Short(isBlack)};
    try {
      return getHibernateTemplate().find(q, o);
    }
    catch (DataAccessException ex) {
      logger.error("findFriends(long ownId, short isBlack):" + ex);
      return new ArrayList();
    }
  }

  /**
   *
   * @param id long
   * @param ownId long
   * @todo Implement this com.laoer.bbscs.dao.IFriendDAO method
   */
  public void removeFriend(final long id, final long ownId) {
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException, SQLException {
        String q = "from Friend" + SysUtil.getTableID(ownId, Constant.MODNUM10) +
            " f where f.id = ? and f.userID = ?";
        Object[] o = {
            new Long(id), new Long(ownId)};
        Type[] t = {
            Hibernate.LONG, Hibernate.LONG};

        s.delete(q, o, t);
        return null;
      }
    });
  }

}