OrgRoleRequestFacade.java 2.07 KB
/*
 * Copyright Codecrew Ry
 * 
 * All rights reserved.
 * 
 * This license applies to any software containing a notice placed by the 
 * copyright holder. Such software is herein referred to as the Software. 
 * This license covers modification, distribution and use of the Software. 
 * 
 * Any distribution and use in source and binary forms, with or without 
 * modification is not permitted without explicit written permission from the 
 * copyright owner. 
 * 
 * A non-exclusive royalty-free right is granted to the copyright owner of the 
 * Software to use, modify and distribute all modifications to the Software in 
 * future versions of the Software. 
 * 
 */
package fi.codecrew.moya.facade;

import java.util.ArrayList;
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.Predicate;
import javax.persistence.criteria.Root;

import fi.codecrew.moya.beans.EventBeanLocal;
import fi.codecrew.moya.model.OrgRoleRequest;
import fi.codecrew.moya.model.OrgRoleRequest_;
import fi.codecrew.moya.model.OrgRole_;

/**
 * Session Bean implementation class OrgRoleFacade
 */
@Stateless
@LocalBean
public class OrgRoleRequestFacade extends IntegerPkGenericFacade<OrgRoleRequest> {

	@EJB
	EventBeanLocal eventBean;

	public OrgRoleRequestFacade() {
		super(OrgRoleRequest.class);
	}

	public List<OrgRoleRequest> findForOrganiser(boolean showAll) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<OrgRoleRequest> cq = cb.createQuery(OrgRoleRequest.class);
		Root<OrgRoleRequest> root = cq.from(OrgRoleRequest.class);

		ArrayList<Predicate> preds = new ArrayList<>();
		preds.add(cb.equal(root.get(OrgRoleRequest_.requestedRole).get(OrgRole_.eventOrganisation), eventBean.getCurrentEvent().getOrganiser()));
		if (!showAll) {
			preds.add(cb.isNull(root.get(OrgRoleRequest_.requestHandled)));
		}

		cq.where(preds.toArray(new Predicate[preds.size()]));
		return getEm().createQuery(cq).getResultList();
	}
}