UserFacade.java

package fi.insomnia.bortal.facade;

import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

import javax.ejb.LocalBean;
import javax.ejb.Stateless;
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.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 IntegerPkGenericFacade<User> {

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

	private static List<SingularAttribute<User, String>> SEARCHATTRS;

	private List<SingularAttribute<User, String>> getAttrlist() {
		if (SEARCHATTRS == null)
		{
			ArrayList<SingularAttribute<User, String>> buildAttrs = new ArrayList<SingularAttribute<User, String>>();

			buildAttrs.add(User_.nick);
			buildAttrs.add(User_.login);
			buildAttrs.add(User_.firstnames);
			buildAttrs.add(User_.lastname);
			buildAttrs.add(User_.email);
			buildAttrs.add(User_.phone);
			logger.warn("Initiating attrlist {}", buildAttrs);

			SEARCHATTRS = Collections.unmodifiableList(buildAttrs);
		}
		return SEARCHATTRS;
	}

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

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

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

	/**
	 * Find user by username.
	 * 
	 * @param login
	 */
	public User findByLogin(String login) {
		CriteriaBuilder cb = getEm().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(getEm().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) {

		OrderCallback<User> orderCall = null;
		if (sort == null || sort.isEmpty()) {
			orderCall = new OrderCallback<User>(false, User_.id);
		}
		else
		{
			orderCall = new OrderCallback<User>(false, sort);

		}

		for (SingularAttribute<User, String> attr : getAttrlist())
		{
			logger.info("Looping attrs: {}", attr);

		}

		return super.searcher(page, pagesize,
				new StringSearchPredicateCreator<User>(search, getAttrlist()),
				orderCall
				);

		// 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 = getEm().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 getEm().createQuery(cq).getResultList();
	}

	public void evict() {
		getEm().getEntityManagerFactory().getCache().evictAll();
	}

	public List<User> findAll()
	{
		CriteriaBuilder cb = getEm().getCriteriaBuilder();
		CriteriaQuery<User> cq = cb.createQuery(User.class);
		return getEm().createQuery(cq).getResultList();

	}

}