/*
* 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.ReceiptLog;
import it.vige.magazzino.model.Receipt;
import it.vige.magazzino.model.Receipt_;
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 ReceiptSearch {
@Inject
@TypedCategory(ReceiptSearch.class)
private ReceiptLog log;
@PersistenceContext
private EntityManager em;
@Inject
private SearchCriteria criteria;
private boolean nextPageAvailable = false;
private List<Receipt> receipts = new ArrayList<Receipt>();
public void find() {
criteria.firstPage();
queryReceipts(criteria);
}
public void nextPage() {
criteria.nextPage();
queryReceipts(criteria);
}
public void previousPage() {
criteria.previousPage();
queryReceipts(criteria);
}
public void currentPage() {
queryReceipts(criteria);
}
@Produces
@Named
public List<Receipt> getReceipts() {
return receipts;
}
public boolean isNextPageAvailable() {
return nextPageAvailable;
}
public boolean isPreviousPageAvailable() {
return criteria.getPage() > 0;
}
private void queryReceipts(final SearchCriteria criteria) {
CriteriaBuilder builder = em.getCriteriaBuilder();
CriteriaQuery<Receipt> cquery = builder.createQuery(Receipt.class);
Root<Receipt> receipt = cquery.from(Receipt.class);
// QUESTION can like create the pattern for us?
cquery.select(receipt).where(
builder.or(builder.like(builder.lower(receipt.get(Receipt_.cause)), criteria.getSearchPattern()),
builder.like(builder.lower(receipt.get(Receipt_.date)), criteria.getSearchPattern()),
builder.like(builder.lower(receipt.get(Receipt_.description)), criteria.getSearchPattern())));
List<Receipt> 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
receipts = new ArrayList<Receipt>(results.subList(0, criteria.getPageSize()));
} else {
receipts = results;
}
log.searchExecuted(receipts);
}
}