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.TypedQuery;

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

import fi.insomnia.bortal.model.User;

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

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

	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. Username is converted to lowercase before
	 * searching.
	 * 
	 * @param login
	 * @return
	 */
	public User findByLogin(String login) {
		TypedQuery<User> q = em.createNamedQuery("User.findByLogin", User.class);
		q.setParameter("login", login.toLowerCase());
		return getSingleNullableResult(q);
	}

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

	public List<User> searchForName(String name) {
		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 List<User> searchUser(int page, int pagesize, String sort, String search) {
		String query = null;
		if (sort == null || sort.isEmpty()) {
			sort = "nick";
		}
		if (search != null) {
			query = new StringBuilder().append("%").append(search).append('%').toString();
		}
		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) {
		TypedQuery<User> q = em.createQuery("SELECT u from User u where u.email = :usr", User.class);
		q.setParameter("usr", email);
		return q.getResultList();
	}

}