package com.laoer.bbscs.dao.hibernate;

import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.laoer.bbscs.dao.IBoardsDAO;
import com.laoer.bbscs.bean.*;
import java.util.*;
import org.springframework.dao.*;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

/**
 * <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 BoardsHibernateDAO
    extends HibernateDaoSupport
    implements IBoardsDAO {

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

  private static final String LOAD_ORDERBYNUM =
      "from Boards bs where bs.attrib3 = 0 order by bs.mainPostNum,bs.postNum";
  private static final String LOAD_NEXT_ORDERS =
      "select max(bs.orders) from Boards bs where bs.board = ?";
  private static final String LOAD_MAINPOST_SUM =
      "select sum(bs.mainPostNum) from Boards bs where bs.useStat = 1";
  private static final String LOAD_POST_SUM =
      "select sum(bs.postNum) from Boards bs where bs.useStat = 1";

  public BoardsHibernateDAO() {
    super();
  }

  /**
   *
   * @param boards Boards
   * @return Boards
   * @todo Implement this com.laoer.bbscs.dao.IBoardsDAO method
   */
  public Boards saveBoards(Boards boards) {
    try {
      getHibernateTemplate().saveOrUpdate(boards);
      return boards;
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return null;
    }
  }

  public Boards getBoards(long id) {
    return (Boards) getHibernateTemplate().get(Boards.class, new Long(id));
  }

  /**
   *
   * @return List
   * @todo Implement this com.laoer.bbscs.dao.IBoardsDAO method
   */
  public List findOrderByNum() {
    try {
      return getHibernateTemplate().find(LOAD_ORDERBYNUM);
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return new ArrayList();
    }
  }

  /**
   *
   * @return short
   * @todo Implement this com.laoer.bbscs.dao.IBoardsDAO method
   */
  public short getNextOrders(Board board) {
    try {
      List l = getHibernateTemplate().find(LOAD_NEXT_ORDERS, board);
      if (l != null && !l.isEmpty()) {
        if (l.get(0) == null) {
          return (short) 5;
        }
        else {
          return (short) ( ( (Short) l.get(0)).shortValue() + 5);
        }
      }
      else {
        return (short) 5;
      }
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return (short) 0;
    }
  }

  /**
   *
   * @param baords Boards
   * @return boolean
   * @todo Implement this com.laoer.bbscs.dao.IBoardsDAO method
   */
  public boolean removeBoards(Boards boards) {
    try {
      boards.getBoard().getBoards().remove(boards.getBoard().getId());
      getHibernateTemplate().delete(boards);
      return true;
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return false;
    }
  }

  public int getPostSumNum(int mainorall) {
    List l = null;
    try {
      if (mainorall == 0) {
        l = getHibernateTemplate().find(LOAD_MAINPOST_SUM);
      }
      if (mainorall == 1) {
        l = getHibernateTemplate().find(LOAD_POST_SUM);
      }
      if (l != null && !l.isEmpty()) {
        return ( (Integer) l.get(0)).intValue();
      }
      else {
        return 0;
      }
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return 0;
    }
  }

}