GroupMembershipFacade.java

/*
 * 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.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.Path;
import javax.persistence.criteria.Root;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import fi.codecrew.moya.beans.EventBeanLocal;
import fi.codecrew.moya.model.EventUser;
import fi.codecrew.moya.model.GroupMembership;
import fi.codecrew.moya.model.GroupMembership_;
import fi.codecrew.moya.model.PlaceGroup;
import fi.codecrew.moya.model.PlaceGroup_;
import fi.codecrew.moya.model.Place_;
import fi.codecrew.moya.model.Product;
import fi.codecrew.moya.utilities.PasswordFunctions;

@Stateless
@LocalBean
public class GroupMembershipFacade extends IntegerPkGenericFacade<GroupMembership> {

	private static final Logger logger = LoggerFactory.getLogger(GroupMembershipFacade.class);

	@EJB
	private EventBeanLocal eventbean;

	public GroupMembershipFacade() {

		super(GroupMembership.class);
	}

	public String createInviteToken() {
		String token = null;
		GroupMembership gm = null;
		do {
			if (token != null) {
				logger.info("Generated token {} found from GoupMembership: {} Generating new!", token, gm);
			}
			token = eventbean.getCurrentEvent().getId().toString();
			token += PasswordFunctions.generateRandomString(15);
			gm = findByToken(token);
		} while (gm != null);
		return token;
	}

	public GroupMembership findByToken(String token) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<GroupMembership> cq = cb.createQuery(GroupMembership.class);
		Root<GroupMembership> root = cq.from(GroupMembership.class);

		cq.where(cb.equal(root.get(GroupMembership_.inviteToken), token),
				cb.equal(root.get(GroupMembership_.placeGroup).get(PlaceGroup_.event), eventbean.getCurrentEvent())
				);

		// TypedQuery<GroupMembership> q =
		// em.createQuery("Select gm from GroupMembership gm where gm.inviteToken = :token ",
		// GroupMembership.class);
		// q.setParameter("token", token);
		return getSingleNullableResult(getEm().createQuery(cq));
	}

	public List<GroupMembership> matchByToken(String token) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<GroupMembership> cq = cb.createQuery(GroupMembership.class);
		Root<GroupMembership> root = cq.from(GroupMembership.class);

		cq.where(cb.like(root.get(GroupMembership_.inviteToken), "%" + token + "%"),
				cb.equal(root.get(GroupMembership_.placeGroup).get(PlaceGroup_.event), eventbean.getCurrentEvent())
				);

		// TypedQuery<GroupMembership> q =
		// em.createQuery("Select gm from GroupMembership gm where gm.inviteToken = :token ",
		// GroupMembership.class);
		// q.setParameter("token", token);
		return getEm().createQuery(cq).getResultList();
	}

	public List<GroupMembership> findMemberOrCreator(EventUser user) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<GroupMembership> cq = cb.createQuery(GroupMembership.class);
		Root<GroupMembership> root = cq.from(GroupMembership.class);
		Path<PlaceGroup> pg = root.get(GroupMembership_.placeGroup);

		cq.where(
				cb.or(cb.equal(root.get(GroupMembership_.user), user),
						cb.equal(pg.get(PlaceGroup_.creator), user)
						),
				cb.equal(pg.get(PlaceGroup_.event), eventbean.getCurrentEvent())
				);
		cq.orderBy(cb.asc(root.get(GroupMembership_.placeReservation).get(Place_.name)), cb.asc(root.get(GroupMembership_.id)));

		// TypedQuery<GroupMembership> p =
		// em.createQuery("select gm from GroupMembership gm where gm.id.eventId = :eventid and (gm.placeGroup.creator = :user or gm.user = :user) order by gm.placeReservation.name",
		// GroupMembership.class);
		// p.setParameter("eventid", event.getId());
		// p.setParameter("user", user);
		return getEm().createQuery(cq).getResultList();
	}

	public List<GroupMembership> findMemberships(EventUser user) {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<GroupMembership> cq = cb.createQuery(GroupMembership.class);
		Root<GroupMembership> root = cq.from(GroupMembership.class);

		Path<PlaceGroup> pg = root.get(GroupMembership_.placeGroup);

		cq.where(cb.equal(root.get(GroupMembership_.user), user),
				cb.equal(pg.get(PlaceGroup_.event), eventbean.getCurrentEvent())
				);
		return getEm().createQuery(cq).getResultList();

		// TypedQuery<GroupMembership> p =
		// em.createQuery("select gm from GroupMembership gm where gm.id.eventId = :eventid and gm.user = :user",
		// GroupMembership.class);
		// p.setParameter("eventid", event.getId());
		// p.setParameter("user", user);
		// return p.getResultList();
	}

	public List<GroupMembership> findAllWithoutUser() {
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<GroupMembership> cq = cb.createQuery(GroupMembership.class);
		Root<GroupMembership> root = cq.from(GroupMembership.class);

		Path<PlaceGroup> pg = root.get(GroupMembership_.placeGroup);

		cq.where(cb.isNull(root.get(GroupMembership_.user)),
				cb.equal(pg.get(PlaceGroup_.event), eventbean.getCurrentEvent())
				);
		return getEm().createQuery(cq).getResultList();
	}

	public Long findPlaceProductCount(Product product) {

		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<Long> cq = cb.createQuery(Long.class);
		Root<GroupMembership> root = cq.from(GroupMembership.class);
		cq.select(cb.count(root));
		cq.where(cb.equal(root.get(GroupMembership_.placeProduct), product));

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

	}

}