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.repository.movement; import br.com.webbudget.domain.entity.card.Card; import br.com.webbudget.domain.entity.card.CardInvoice; import br.com.webbudget.domain.entity.card.CardType; import br.com.webbudget.domain.entity.movement.CostCenter; import br.com.webbudget.domain.entity.movement.FinancialPeriod; import br.com.webbudget.domain.entity.movement.Movement; import br.com.webbudget.domain.entity.movement.MovementClass; import br.com.webbudget.domain.entity.movement.MovementClassType; import br.com.webbudget.domain.entity.movement.MovementStateType; import br.com.webbudget.domain.entity.movement.MovementType; import br.com.webbudget.domain.repository.GenericRepository; import java.math.BigDecimal; import java.util.Date; import java.util.List; import org.hibernate.Criteria; import org.hibernate.criterion.Order; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.springframework.stereotype.Repository; /** * * @author Arthur Gregorio * * @version 1.0 * @since 1.0, 18/10/2013 */ @Repository public class MovementRepository extends GenericRepository<Movement, Long> implements IMovementRepository { /** * * @return */ @Override public List<Movement> listByActiveFinancialPeriod() { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.closed", false)); criteria.add(Restrictions.isNull("fp.closing")); criteria.addOrder(Order.desc("inclusion")); return criteria.list(); } /** * * @param cardInvoice * @return */ @Override public List<Movement> listByCardInvoice(CardInvoice cardInvoice) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("cardInvoice", "ci"); criteria.add(Restrictions.eq("ci.id", cardInvoice.getId())); return criteria.list(); } /** * * @param filter * @param paid * @return */ @Override public List<Movement> listByFilter(String filter, Boolean paid) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); if (paid != null && paid.equals(Boolean.TRUE)) { criteria.add(Restrictions.isNotNull("payment")); } criteria.createAlias("apportionments", "ap"); criteria.createAlias("ap.movementClass", "mc"); criteria.createAlias("ap.costCenter", "cc"); criteria.createAlias("financialPeriod", "fp"); // se conseguir castar para bigdecimal trata como um filtro try { final BigDecimal value = new BigDecimal(filter); criteria.add(Restrictions.or(Restrictions.eq("code", filter), Restrictions.eq("value", value), Restrictions.ilike("description", filter + "%"), Restrictions.ilike("mc.name", filter + "%"), Restrictions.ilike("cc.name", filter + "%"), Restrictions.ilike("fp.identification", filter + "%"))); } catch (NumberFormatException ex) { criteria.add(Restrictions.or(Restrictions.eq("code", filter), Restrictions.ilike("description", filter + "%"), Restrictions.ilike("mc.name", filter + "%"), Restrictions.ilike("cc.name", filter + "%"), Restrictions.ilike("fp.identification", filter + "%"))); } criteria.addOrder(Order.desc("inclusion")); criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); return criteria.list(); } /** * * @param dueDate * @param showOverdue * @return */ @Override public List<Movement> listByDueDate(Date dueDate, boolean showOverdue) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); if (showOverdue) { criteria.add(Restrictions.le("dueDate", dueDate)); criteria.add(Restrictions.eq("movementStateType", MovementStateType.OPEN)); } else { criteria.add(Restrictions.eq("dueDate", dueDate)); } criteria.addOrder(Order.asc("dueDate")); return criteria.list(); } /** * * @param financialPeriod * @param type * @return */ @Override public List<Movement> listByPeriodAndCardType(FinancialPeriod financialPeriod, CardType type) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", financialPeriod.getId())); criteria.createAlias("payment", "py").createAlias("py.card", "cc"); criteria.add(Restrictions.eq("cc.cardType", type)); return criteria.list(); } /** * * @param period * @param direction * @return */ @Override public List<Movement> listByPeriodAndDirection(FinancialPeriod period, MovementClassType direction) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", period.getId())); criteria.createAlias("apportionments", "ap"); criteria.createAlias("ap.movementClass", "mc"); criteria.add(Restrictions.eq("mc.movementClassType", direction)); return criteria.list(); } /** * * @param financialPeriod * @param state * @return */ @Override public List<Movement> listByPeriodAndState(FinancialPeriod financialPeriod, MovementStateType state) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", financialPeriod.getId())); if (state != null) { criteria.add(Restrictions.eq("movementStateType", state)); } return criteria.list(); } /** * * @param financialPeriod * @param card * @return */ @Override public List<Movement> listPaidWithoutInvoiceByPeriodAndCard(FinancialPeriod financialPeriod, Card card) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.add(Restrictions.isNull("cardInvoice")); criteria.add(Restrictions.eq("cardInvoicePaid", Boolean.FALSE)); criteria.add(Restrictions.eq("movementStateType", MovementStateType.PAID)); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", financialPeriod.getId())); criteria.createAlias("payment", "py").createAlias("py.card", "cc"); criteria.add(Restrictions.eq("cc.id", card.getId())); return criteria.list(); } /** * * @param period * @param movementClass * @return */ @Override public BigDecimal countTotalByPeriodAndMovementClass(FinancialPeriod period, MovementClass movementClass) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", period.getId())); criteria.createAlias("apportionments", "ap"); criteria.createAlias("ap.movementClass", "mc"); criteria.add(Restrictions.eq("mc.id", movementClass.getId())); criteria.setProjection(Projections.sum("value")); return (BigDecimal) criteria.uniqueResult(); } /** * * @param period * @param state * @param type * @return */ @Override public List<Movement> listByPeriodAndStateAndType(FinancialPeriod period, MovementStateType state, MovementType type) { return this.listByPeriodAndStateAndTypeAndDirection(period, state, type, null); } /** * * @param period * @param costCenter * @return */ @Override public List<Movement> listByPeriodAndCostCenterAndDirection(FinancialPeriod period, CostCenter costCenter, MovementClassType direction) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", period.getId())); criteria.createAlias("apportionments", "ap"); criteria.createAlias("ap.movementClass", "mc"); criteria.createAlias("mc.costCenter", "cc"); criteria.add(Restrictions.eq("mc.movementClassType", direction)); criteria.add(Restrictions.eq("cc.id", costCenter.getId())); return criteria.list(); } /** * * @param period * @param state * @param type * @param direction * @return */ @Override public List<Movement> listByPeriodAndStateAndTypeAndDirection(FinancialPeriod period, MovementStateType state, MovementType type, MovementClassType direction) { final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass()); if (type != null) { criteria.add(Restrictions.eq("movementType", type)); } if (state != null) { criteria.add(Restrictions.eq("movementStateType", state)); } criteria.createAlias("financialPeriod", "fp"); criteria.add(Restrictions.eq("fp.id", period.getId())); if (direction != null) { criteria.createAlias("apportionments", "ap"); criteria.createAlias("ap.movementClass", "mc"); criteria.add(Restrictions.eq("mc.movementClassType", direction)); } return criteria.list(); } }