UserFacade.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 javax.persistence.metamodel.SingularAttribute;

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

import fi.insomnia.bortal.facade.callbacks.OrderCallback;
import fi.insomnia.bortal.facade.callbacks.StringPredicateField;
import fi.insomnia.bortal.facade.callbacks.StringSearchPredicateCreator;
import fi.insomnia.bortal.model.User;
import fi.insomnia.bortal.model.User_;
import fi.insomnia.bortal.utilities.SearchResult;

@Stateless
@LocalBean
public class UserFacade extends GenericFacade<Integer, User> {

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

	private enum Userfields implements StringPredicateField<User> {
		nick(User_.nick), login(User_.login), firstnames(User_.firstnames), lastname(User_.lastname), email(User_.email);
		private SingularAttribute<User, String> field;

		Userfields(SingularAttribute<User, String> f) {
			field = f;
		}

		@Override
		public SingularAttribute<User, String> getField() {
			return field;
		}
	}

	// final String[] NAMEFIELDS = { "nick", "login", "firstnames", "lastname",
	// "email" };

	//
	// public enum UserField {
	// id, nick, login, firstname, lastname
	// }

	@PersistenceContext
	private EntityManager em;

	public UserFacade() {
		super(User.class);
	}

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

	/**
	 * Find user by username.
	 * 
	 * @param login
	 * @return
	 */
	public User findByLogin(String login) {
		CriteriaBuilder cb = em.getCriteriaBuilder();
		CriteriaQuery<User> cq = cb.createQuery(User.class);
		Root<User> root = cq.from(User.class);
		cq.where(cb.equal(root.get(User_.login), login));

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

	// public SearchResult<User> searchForName(String name) {
	// return super.searcher(0, 0,
	// new StringSearchPredicateCreator<User>(name, Userfields.values()),
	// new OrderCallback<User>(true, User_.login)
	// );
	// // return this.search(name, NAMEFIELDS, "login");
	// }

	@Override
	public void create(User user) {
		user.setLogin(user.getLogin().toLowerCase().trim());
		super.create(user);
	}

	@Override
	public User merge(User user) {
		user.setLogin(user.getLogin().toLowerCase().trim());
		return super.merge(user);
	}

	public SearchResult<User> searchUser(int page, int pagesize, String sort, String search) {

		if (sort == null || sort.isEmpty()) {
			sort = "nick";
		}

		return super.searcher(page, pagesize,
				new StringSearchPredicateCreator<User>(search, Userfields.values()),
				new OrderCallback<User>(true, sort)
				);

		// return this.search(page, pagesize, query, NAMEFIELDS, sort);
	}

	// public long searchUserCount(String search) {
	// String query = null;
	// if (search != null) {
	// query = new
	// StringBuilder().append("%").append(search).append('%').toString();
	// }
	// return this.searchCount(query, NAMEFIELDS);
	// }

	public List<User> findByEmail(String email) {
		CriteriaBuilder cb = em.getCriteriaBuilder();
		CriteriaQuery<User> cq = cb.createQuery(User.class);
		Root<User> root = cq.from(User.class);
		cq.where(cb.equal(root.get(User_.email), email));

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

}