EventMapFacade.java

package fi.insomnia.bortal.facade;

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

import fi.insomnia.bortal.model.EventMap;
import fi.insomnia.bortal.model.Place;
import fi.insomnia.bortal.model.Place_;

@Stateless
@LocalBean
public class EventMapFacade extends GenericFacade<Integer, EventMap> {

	@PersistenceContext
	private EntityManager em;

	public EventMapFacade() {
		super(EventMap.class);
	}

	@Override
	protected EntityManager getEm() {
		return em;
	}

	public Long countAvailable(EventMap map) {
		CriteriaBuilder cb = em.getCriteriaBuilder();
		CriteriaQuery<Long> cq = cb.createQuery(Long.class);

		Root<Place> root = cq.from(Place.class);

		cq.select(cb.count(root));

		cq.where(
				cb.equal(root.get(Place_.map), map),
				cb.isFalse(root.get(Place_.disabled))
				);

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

	public Long countSelectable(EventMap map) {

		if (map == null) {
			return null;
		}

		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Long> cq = cb.createQuery(Long.class);

		Root<Place> root = cq.from(Place.class);

		cq.select(cb.count(root));

		cq.where(
				cb.equal(root.get(Place_.map), map),
				cb.isNull(root.get(Place_.releaseTime)),
				cb.isNull(root.get(Place_.group)),
				cb.isFalse(root.get(Place_.disabled))
				);

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