package com.laoer.bbscs.dao.hibernate;

import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.laoer.bbscs.dao.IBoardDAO;
import com.laoer.bbscs.bean.Board;
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 BoardHibernateDAO
    extends HibernateDaoSupport
    implements IBoardDAO {

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

  private static final String LOAD_ALL = "from Board b order by b.orders";
  private static final String LOAD_NEXT_ORDERS =
      "select max(b.orders) from Board b";

  public BoardHibernateDAO() {
    super();
  }

  /**
   *
   * @param board Board
   * @return Board
   * @todo Implement this com.laoer.bbscs.dao.IBoardDAO method
   */
  public Board saveBoard(Board board) {
    try {
      getHibernateTemplate().saveOrUpdate(board);
      return board;
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return null;
    }
  }

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

  /**
   *
   * @param id Long
   * @return Board
   * @todo Implement this com.laoer.bbscs.dao.IBoardDAO method
   */
  public Board findBoardById(Long id) {
    try {
      return (Board) getHibernateTemplate().get(Board.class, id);
    }
    catch (DataAccessException ex) {
      logger.error(ex);
      return null;
    }
  }

  /**
   *
   * @param board Board
   * @todo Implement this com.laoer.bbscs.dao.IBoardDAO method
   */
  public void removeBoard(Board board) {
    this.getHibernateTemplate().delete(board);
  }

  /**
   *
   * @return short
   */
  public short getNextOrders() {
    try {
      //Query q = getHibernateTemplate().createQuery(getSession(),LOAD_NEXT_ORDERS);
      //List l = q.list();
      List l = this.getHibernateTemplate().find(LOAD_NEXT_ORDERS);
      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;
    }
    catch (IllegalStateException ex) {
      logger.error(ex);
      return (short) 0;
    }
  }

}