Java tutorial
/* * Copyright (C) 2015 Arthur Gregorio, AG.Software * * This program is free software: you can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation, either version 3 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ package br.com.webbudget.domain.model.repository.entries; import br.com.webbudget.domain.model.entity.entries.Card; import br.com.webbudget.domain.model.entity.entries.CardType; import br.com.webbudget.application.component.table.Page; import br.com.webbudget.application.component.table.PageRequest; import br.com.webbudget.domain.model.repository.GenericRepository; import java.util.List; import org.hibernate.Criteria; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; /** * * @author Arthur Gregorio * * @version 1.0.0 * @since 1.0.0, 18/10/2013 */ public class CardRepository extends GenericRepository<Card, Long> implements ICardRepository { /** * * @param isBlocked * @return */ @Override public List<Card> listDebit(Boolean isBlocked) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); if (isBlocked != null) { criteria.add(Restrictions.eq("blocked", isBlocked)); } criteria.add(Restrictions.eq("cardType", CardType.DEBIT)); criteria.addOrder(Order.desc("inclusion")); return criteria.list(); } /** * * @param isBlocked * @return */ @Override public List<Card> listCredit(Boolean isBlocked) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); if (isBlocked != null) { criteria.add(Restrictions.eq("blocked", isBlocked)); } criteria.add(Restrictions.eq("cardType", CardType.CREDIT)); criteria.addOrder(Order.desc("inclusion")); return criteria.list(); } /** * * @param isBlocked * @return */ @Override public List<Card> listByStatus(Boolean isBlocked) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); if (isBlocked != null) { criteria.add(Restrictions.eq("blocked", isBlocked)); } criteria.addOrder(Order.desc("inclusion")); return criteria.list(); } /** * * @param number * @param cardType * @return */ @Override public Card findByNumberAndType(String number, CardType cardType) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.add(Restrictions.eq("number", number)); criteria.add(Restrictions.eq("cardType", cardType)); return (Card) criteria.uniqueResult(); } /** * * @param isBlocked * @param pageRequest * @return */ @Override public Page<Card> listByStatus(Boolean isBlocked, PageRequest pageRequest) { final Criteria criteria = this.createCriteria(); if (isBlocked != null) { criteria.add(Restrictions.eq("blocked", isBlocked)); } // projetamos para pegar o total de paginas possiveis criteria.setProjection(Projections.count("id")); final Long totalRows = (Long) criteria.uniqueResult(); // limpamos a projection para que a criteria seja reusada criteria.setProjection(null); criteria.setResultTransformer(Criteria.ROOT_ENTITY); // paginamos criteria.setFirstResult(pageRequest.getFirstResult()); criteria.setMaxResults(pageRequest.getPageSize()); if (pageRequest.getSortDirection() == PageRequest.SortDirection.ASC) { criteria.addOrder(Order.asc(pageRequest.getSortField())); } else if (pageRequest.getSortDirection() == PageRequest.SortDirection.DESC) { criteria.addOrder(Order.desc(pageRequest.getSortField())); } // montamos o resultado paginado return new Page<>(criteria.list(), totalRows); } }