package us.gaits.hawk.session;

import us.gaits.hawk.entity.*;
import org.jboss.seam.annotations.Name;
import org.jboss.seam.framework.EntityQuery;
import java.util.List;
import java.util.Arrays;

@Name("usersList")
public class UsersList extends EntityQuery {

	private static final String[] RESTRICTIONS = {
			"lower(users.username) like concat(lower(#{usersList.users.username}),'%')",
			"lower(users.passwordhash) like concat(lower(#{usersList.users.passwordhash}),'%')",
			"lower(users.lastname) like concat(lower(#{usersList.users.lastname}),'%')",
			"lower(users.firstname) like concat(lower(#{usersList.users.firstname}),'%')",
			"lower(users.secretanswer) like concat(lower(#{usersList.users.secretanswer}),'%')",
			"lower(users.secretquestion) like concat(lower(#{usersList.users.secretquestion}),'%')",};

	private Users users = new Users();

	@Override
	public String getEjbql() {
		return "select users from Users users";
	}

	@Override
	public Integer getMaxResults() {
		return 25;
	}

	public Users getUsers() {
		return users;
	}

	@Override
	public List<String> getRestrictions() {
		return Arrays.asList(RESTRICTIONS);
	}

}