AccountEventFacade.java

package fi.insomnia.bortal.facade;

import java.util.List;

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.AccountEvent;
import fi.insomnia.bortal.model.AccountEvent_;
import fi.insomnia.bortal.model.EventPk;
import fi.insomnia.bortal.model.LanEvent;
import fi.insomnia.bortal.model.Product_;
import fi.insomnia.bortal.model.Role;
import fi.insomnia.bortal.model.Role_;
import fi.insomnia.bortal.model.User;

@Stateless
@LocalBean
public class AccountEventFacade extends GenericFacade<EventPk, AccountEvent> {

	@PersistenceContext
	private EntityManager em;

	public AccountEventFacade() {
		super(AccountEvent.class);
	}

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

	// @Override
	// public void create(AccountEvent event) {
	// user = userfacade
	//
	// userfacade.evict(event.getUser());
	// }

	public List<Role> findProvidedRoles(LanEvent event, User u) {
		CriteriaBuilder cb = em.getCriteriaBuilder();

		CriteriaQuery<Role> cq = cb.createQuery(Role.class);
		Root<Role> root = cq.from(Role.class);

		cq.where(
				cb.equal(root.get(Role_.event), event),
				cb.equal(root.join(Role_.productsProvide).join(Product_.accountEvents).get(AccountEvent_.user), u)
				);

		// TypedQuery<Role> q =
		// em.createQuery("select distinct ac.product.provides from AccountEvent ac where ac.id.eventId = :eventid and ac.user = :user and ac.product.provides is not null",
		// Role.class);
		// q.setParameter("eventid", event.getId());
		// q.setParameter("user", u);
		return em.createQuery(cq).getResultList();
	}
}