/* * Vige, Home of Professional Open Source * Copyright 2010, Vige, and individual contributors * by the @authors tag. See the copyright.txt in the distribution for a * full listing of individual contributors. * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * http://www.apache.org/licenses/LICENSE-2.0 * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package it.vige.magazzino.inventory; import it.vige.magazzino.log.CustomerLog; import it.vige.magazzino.model.Customer; import it.vige.magazzino.model.Customer_; import java.util.ArrayList; import java.util.List; import javax.ejb.Stateful; import javax.enterprise.context.SessionScoped; import javax.enterprise.inject.Produces; import javax.inject.Inject; import javax.inject.Named; import javax.persistence.EntityManager; import javax.persistence.PersistenceContext; import javax.persistence.criteria.CriteriaBuilder; import javax.persistence.criteria.CriteriaQuery; import javax.persistence.criteria.Root; import org.jboss.solder.logging.TypedCategory; /** * @author <a href="http://www.vige.it">Luca Stancapiano</a> */ @Named @Stateful @SessionScoped public class CustomerSearch { @Inject @TypedCategory(CustomerSearch.class) private CustomerLog log; @PersistenceContext private EntityManager em; @Inject private SearchCriteria criteria; private boolean nextPageAvailable = false; private List<Customer> customers = new ArrayList<Customer>(); public void find() { criteria.firstPage(); queryCustomers(criteria); } public void nextPage() { criteria.nextPage(); queryCustomers(criteria); } public void previousPage() { criteria.previousPage(); queryCustomers(criteria); } public void currentPage() { queryCustomers(criteria); } @Produces @Named public List<Customer> getCustomers() { return customers; } public boolean isNextPageAvailable() { return nextPageAvailable; } public boolean isPreviousPageAvailable() { return criteria.getPage() > 0; } private void queryCustomers(final SearchCriteria criteria) { CriteriaBuilder builder = em.getCriteriaBuilder(); CriteriaQuery<Customer> cquery = builder.createQuery(Customer.class); Root<Customer> customer = cquery.from(Customer.class); // QUESTION can like create the pattern for us? cquery.select(customer).where( builder.or(builder.like( builder.lower(customer.get(Customer_.name)), criteria.getSearchPattern()), builder.like( builder.lower(customer.get(Customer_.ragSocial)), criteria.getSearchPattern()), builder.like( builder.lower(customer.get(Customer_.iva)), criteria.getSearchPattern()))); List<Customer> results = em.createQuery(cquery) .setMaxResults(criteria.getFetchSize()) .setFirstResult(criteria.getFetchOffset()).getResultList(); nextPageAvailable = results.size() > criteria.getPageSize(); if (nextPageAvailable) { // NOTE create new ArrayList since subList creates unserializable // list customers = new ArrayList<Customer>(results.subList(0, criteria.getPageSize())); } else { customers = results; } log.searchExecuted(customers); } }