EventMapFacade.java

package fi.insomnia.bortal.facade;

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.model.EventMap;
import fi.insomnia.bortal.model.Place;
import fi.insomnia.bortal.model.Place_;

@Stateless
@LocalBean
public class EventMapFacade extends IntegerPkGenericFacade<EventMap> {

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

	public Long countAvailable(EventMap map) {
		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.isFalse(root.get(Place_.disabled))
				);

		return getSingleNullableResult(getEm().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(getEm().createQuery(cq));
	}
}