DefaultProductSoldsDao.java

package fr.mch.mdo.restaurant.dao.products.hibernate;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;

import fr.mch.mdo.logs.ILogger;
import fr.mch.mdo.restaurant.beans.IMdoBean;
import fr.mch.mdo.restaurant.beans.IMdoDaoBean;
import fr.mch.mdo.restaurant.dao.beans.Locale;
import fr.mch.mdo.restaurant.dao.beans.ProductSold;
import fr.mch.mdo.restaurant.dao.hibernate.DefaultDaoServices;
import fr.mch.mdo.restaurant.dao.hibernate.TransactionSession;
import fr.mch.mdo.restaurant.dao.products.IProductSoldsDao;
import fr.mch.mdo.restaurant.exception.MdoDataBeanException;
import fr.mch.mdo.restaurant.services.logs.LoggerServiceImpl;

public class DefaultProductSoldsDao extends DefaultDaoServices implements IProductSoldsDao 
{
	private static class LazyHolder {
		private static IProductSoldsDao instance = new DefaultProductSoldsDao(LoggerServiceImpl.getInstance().getLogger(DefaultProductSoldsDao.class.getName()), new ProductSold());
	}

	private DefaultProductSoldsDao(ILogger logger, IMdoDaoBean bean) {
		super(true);
		this.setLogger(logger);
		this.setBean(bean);
	}

	public static IProductSoldsDao getInstance() {
		return LazyHolder.instance;
	}

	public DefaultProductSoldsDao() {
	}

	@Override
	public IMdoBean findByUniqueKey(Object[] propertyValues, boolean... isLazy) throws MdoDataBeanException {
		// Checking exception
		super.findByUniqueKey(propertyValues, isLazy);

		if (propertyValues.length != 2) {
			super.getLogger().error("message.error.dao.unique.fields.2");
			throw new MdoDataBeanException("message.error.dao.unique.fields.2");
		}

		Date date = (Date) propertyValues[0];
		Calendar calendar = Calendar.getInstance();
		calendar.setTime(date);
		Map<String, Object> propertyValueMap = new HashMap<String, Object>();
		propertyValueMap.put("soldYear", new Integer(calendar.get(Calendar.YEAR)));
		propertyValueMap.put("soldMonth", new Integer(calendar.get(Calendar.MONTH) + 1));
		propertyValueMap.put("soldDay", new Integer(calendar.get(Calendar.DAY_OF_MONTH)));
		propertyValueMap.put("product.id", propertyValues[1]);

		return (IMdoBean) super.findByUniqueKey(propertyValueMap, isLazy);
	}

	@Override
	public IMdoBean findByUniqueKey(Date soldDate, Long productId) throws MdoDataBeanException {
		return this.findByUniqueKey(new Object[] { soldDate, productId });
	}
	
	@SuppressWarnings("unchecked")
	public List<ProductSold> findByYear(int year) throws MdoDataBeanException {
		List<ProductSold> result = new ArrayList<ProductSold>();
		try {
			TransactionSession transactionSession = super.beginTransaction();
	
			Session session = transactionSession.getSession();
			//result = session.createQuery("FROM ProductSold pds WHERE extract(year FROM pds.soldDate)="+year).list();
			Criteria criteria = session.createCriteria(this.getBean().getClass());
			criteria.add(Restrictions.eq("soldYear", new Integer(year)));
			result = criteria.list();
	
			super.endTransaction(transactionSession, result, true);
		} finally {
			try {
				super.closeSession();
			} catch (HibernateException e) {
				super.getLogger().error("message.error.dao.session.close", e);
				throw new MdoDataBeanException("message.error.dao.session.close", e);
			}
		}
		return result;
	}
}