BillFacade.java

package fi.insomnia.bortal.facade;

import java.util.List;

import javax.ejb.EJB;
import javax.ejb.LocalBean;
import javax.ejb.Stateless;
import javax.persistence.criteria.CriteriaBuilder;
import javax.persistence.criteria.CriteriaQuery;
import javax.persistence.criteria.Root;

import fi.insomnia.bortal.beans.EventBeanLocal;
import fi.insomnia.bortal.model.Bill;
import fi.insomnia.bortal.model.Bill_;
import fi.insomnia.bortal.model.EventUser;

@Stateless
@LocalBean
public class BillFacade extends IntegerPkGenericFacade<Bill> {

	@EJB
	private EventBeanLocal eventbean;

	public BillFacade() {
		super(Bill.class);

	}

	// @Override
	// public void create(Bill entity) {
	// super.create(entity);
	// userfacade.evict(entity.getUser());
	//
	// }

	public Integer getBiggestBillNumber() {
		// SELECT max(b.billNumber) from Bill b where b.event = :event
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Integer> cq = cb.createQuery(Integer.class);
		Root<Bill> root = cq.from(Bill.class);
		cq.select(cb.max(root.get(Bill_.billNumber)));

		cq.where(cb.equal(root.get(Bill_.event), eventbean.getCurrentEvent()));

		return getSingleNullableResult(getEm().createQuery(cq));
	}

	public List<Bill> findAll() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Bill> cq = cb.createQuery(Bill.class);
		Root<Bill> root = cq.from(Bill.class);
		cq.where(cb.equal(root.get(Bill_.event), eventbean.getCurrentEvent()));
		cq.orderBy(cb.desc(root.get(Bill_.id)));
		return getEm().createQuery(cq).getResultList();
	}

	public List<Bill> find(EventUser user) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Bill> cq = cb.createQuery(Bill.class);
		Root<Bill> root = cq.from(Bill.class);
		cq.where(cb.equal(root.get(Bill_.event), eventbean.getCurrentEvent()),
				cb.equal(root.get(Bill_.user), user)
				);
		return getEm().createQuery(cq).getResultList();

	}

}