Example usage for org.hibernate.criterion Restrictions le

List of usage examples for org.hibernate.criterion Restrictions le

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. le

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions le.

Prototype

public static SimpleExpression le(String propertyName, Object value)

Source Link

Document

Apply a "less than or equal" constraint to the named property

Usage

From source file:au.org.theark.report.model.dao.ReportDao.java

License:Open Source License

public List<ResearcherDetailCostDataRow> getBillableItemDetailCostData(
        ResearcherCostResportVO researcherCostResportVO) {
    List<ResearcherDetailCostDataRow> results = new ArrayList<ResearcherDetailCostDataRow>();
    Criteria criteria = getSession().createCriteria(BillableItem.class, "bi");
    criteria.createAlias("workRequest", "wr", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("billableItemType", "bit", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("wr.researcher", "re", JoinType.LEFT_OUTER_JOIN);

    if (researcherCostResportVO.getResearcherId() != null) {
        criteria.add(Restrictions.eq("re.id", researcherCostResportVO.getResearcherId()));
    }//from w w  w.java  2 s . c  o m

    criteria.add(Restrictions.eq("bi.studyId", researcherCostResportVO.getStudyId()));
    criteria.add(Restrictions.eq("bi.invoice", researcherCostResportVO.getInvoice()));
    criteria.add(Restrictions.le("bi.commenceDate", researcherCostResportVO.getToDate()));
    criteria.add(Restrictions.ge("bi.commenceDate", researcherCostResportVO.getFromDate()));

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.property("bi.description"), "description");
    projectionList.add(Projections.property("bi.commenceDate"), "commencedDate");
    projectionList.add(Projections.property("bi.invoice"), "invoice");
    projectionList.add(Projections.property("bi.quantity"), "quantity");
    projectionList.add(Projections.property("bi.totalCost"), "totalAmount");
    projectionList.add(Projections.property("bi.totalGST"), "totalGST");
    projectionList.add(Projections.property("bit.itemName"), "itemType");
    projectionList.add(Projections.property("bit.id"), "typeId");
    projectionList.add(Projections.property("bit.quantityType"), "quantityType");
    projectionList.add(Projections.property("wr.gstAllow"), "gstAllowed");

    projectionList.add(Projections.property("wr.name"), "requestName");

    criteria.setProjection(projectionList); // only return fields required for report
    criteria.setResultTransformer(Transformers.aliasToBean(ResearcherDetailCostDataRow.class));
    criteria.addOrder(Order.asc("bit.id"));
    criteria.addOrder(Order.asc("bi.commenceDate"));
    results = criteria.list();
    return results;
}

From source file:au.org.theark.study.model.dao.StudyDao.java

License:Open Source License

public List<StudyCalendar> searchStudyCalenderList(StudyCalendar studyCalendar) {
    List<StudyCalendar> list = new ArrayList<StudyCalendar>();
    Criteria criteria = getSession().createCriteria(StudyCalendar.class);

    criteria.add(Restrictions.eq("study", studyCalendar.getStudy()));

    if (studyCalendar.getName() != null) {
        criteria.add(Restrictions.ilike("name", studyCalendar.getName(), MatchMode.ANYWHERE));
    }/*  w  w w. ja  v a2s  . c  o m*/

    if (studyCalendar.getStartDate() != null) {
        criteria.add(Restrictions.ge("startDate", studyCalendar.getStartDate()));
    }

    if (studyCalendar.getEndDate() != null) {
        criteria.add(Restrictions.le("endDate", studyCalendar.getEndDate()));
    }

    criteria.setFetchMode("studyComp", FetchMode.JOIN);

    list = criteria.list();

    return list;
}

From source file:br.com.gerenciapessoal.repository.Lancamentos.java

public List<Lancamento> lancamentoFiltrados(LancamentoFilter filterLanc) {

    Session session = manager.unwrap(Session.class);
    Criteria criteria = session.createCriteria(Lancamento.class).createAlias("conta", "c");

    if (filterLanc.getConta() != null) {
        criteria.add(Restrictions.eq("c.id", filterLanc.getConta().getId()));

        if (filterLanc.getEmissaode() != null) {
            criteria.add(Restrictions.ge("dataEmissao", filterLanc.getEmissaode()));
        }/*from   ww w.j  a va2 s.  c om*/

        if (filterLanc.getEmissaoate() != null) {
            criteria.add(Restrictions.le("dataEmissao", filterLanc.getEmissaoate()));
        }
    } else {
        throw new NegocioException("Voc deve selecionar uma conta\n" + "antes de proceguir!");
    }
    return criteria.addOrder(Order.asc("dataEmissao")).list();
}

From source file:br.com.hslife.imobiliaria.dao.impl.AluguelDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override// www  .j ava 2 s.c  o  m
public List<Aluguel> listByContratoOrPeriodoOrAnoBeforeDataAndPago(Long idContrato, Integer periodo,
        Integer ano, Date data, Boolean pago) {
    List<Criterion> criterios = new ArrayList<Criterion>();
    if (idContrato != null) {
        criterios.add(Restrictions.eq("contrato.id", idContrato));
    }
    if (periodo != null) {
        criterios.add(Restrictions.eq("periodo", periodo));
    }
    if (ano != null) {
        criterios.add(Restrictions.eq("ano", ano));
    }
    if (data != null) {
        criterios.add(Restrictions.le("vencimento", data));
    }
    if (pago != null) {
        if (pago) {
            criterios.add(Restrictions.isNotNull("pagamento"));
        } else {
            criterios.add(Restrictions.isNull("pagamento"));
        }
    }
    return listByCriteria(Aluguel.class, criterios);
}

From source file:br.com.hslife.imobiliaria.dao.impl.AluguelDao.java

License:Open Source License

@SuppressWarnings("unchecked")
@Override/*  ww w .  java2 s.c o m*/
public List<Aluguel> listByNomeLocatarioOrContratoOrPeriodoOrAnoBeforeDataAndPago(String nomeLocatario,
        Long idContrato, Integer periodo, Integer ano, Date data, Boolean pago) {
    Criteria criteria = HibernateUtility.getSession().createCriteria(Aluguel.class, "aluguel")
            .createAlias("aluguel.contrato", "contrato").createAlias("contrato.locatario", "locatario");
    if (nomeLocatario != null && !nomeLocatario.trim().isEmpty()) {
        criteria.add(Restrictions.ilike("locatario.nome", nomeLocatario, MatchMode.ANYWHERE));
    }
    if (idContrato != null) {
        criteria.add(Restrictions.eq("contrato.id", idContrato));
    }
    if (periodo != null) {
        criteria.add(Restrictions.eq("aluguel.periodo", periodo));
    }
    if (ano != null) {
        criteria.add(Restrictions.eq("aluguel.ano", ano));
    }
    if (data != null) {
        criteria.add(Restrictions.le("aluguel.vencimento", data));
    }
    if (pago != null) {
        if (pago) {
            criteria.add(Restrictions.isNotNull("aluguel.pagamento"));
        } else {
            criteria.add(Restrictions.isNull("aluguel.pagamento"));
        }
    }
    criteria.addOrder(Order.asc("aluguel.vencimento"));
    return criteria.list();
}

From source file:br.com.hslife.imobiliaria.dao.impl.ContratoDao.java

License:Open Source License

@Override
public List listByExample(Object example) {
    Contrato c = (Contrato) example;//from  w  ww  .  jav  a  2  s .c  om
    List<Criterion> restricoes = new ArrayList<Criterion>();
    if (c.getNumContrato() != null && !c.getNumContrato().isEmpty()) {
        restricoes.add(Restrictions.ilike("numContrato", c.getNumContrato(), MatchMode.ANYWHERE));
    }
    if (c.getInicioContrato() != null) {
        restricoes.add(Restrictions.ge("inicioContrato", c.getInicioContrato()));
    }
    if (c.getTerminoContrato() != null) {
        restricoes.add(Restrictions.le("terminoContrato", c.getTerminoContrato()));
    }
    if (c.getImovel() != null && c.getImovel().getId() != null && c.getImovel().getId() > 0) {
        restricoes.add(Restrictions.eq("imovel.id", c.getImovel().getId()));
    }
    if (c.getLocatario() != null && c.getLocatario().getId() != null && c.getLocatario().getId() > 0) {
        restricoes.add(Restrictions.eq("locatario.id", c.getLocatario().getId()));
    }
    if (c.getLocatarioPJ() != null && c.getLocatarioPJ().getId() != null && c.getLocatarioPJ().getId() > 0) {
        restricoes.add(Restrictions.eq("locatarioPJ.id", c.getLocatarioPJ().getId()));
    }
    if (c.getFiador() != null && c.getFiador().getId() != null && c.getFiador().getId() > 0) {
        restricoes.add(Restrictions.eq("fiador.id", c.getFiador().getId()));
    }
    if (c.getSituacao() != null && c.getSituacao() > 0) {
        restricoes.add(Restrictions.eq("situacao", c.getSituacao()));
    }
    return super.listByCriteria(Contrato.class, restricoes);
}

From source file:br.com.hslife.orcamento.model.CriterioAuditoria.java

License:Open Source License

public void setFim(Date fim) {
    this.fim = fim;

    hibernateCriterions.remove("fim");

    if (fim != null) {
        hibernateCriterions.put("fim", Restrictions.le("data", fim));
    }/*w  w w . java2 s  .  co  m*/
}

From source file:br.com.hslife.orcamento.model.CriterioBuscaLancamentoConta.java

License:Open Source License

public void setDataFim(Date dataFim) {
    this.dataFim = dataFim;

    // Remove a data final anteriormente setada
    hibernateCriterions.remove("dataFim");

    if (dataFim != null)
        hibernateCriterions.put("dataFim", Restrictions.le("lancamento.dataPagamento", dataFim));
}

From source file:br.com.hslife.orcamento.model.CriterioLog.java

License:Open Source License

@SuppressWarnings("deprecation")
public void setFim(Date fim) {
    this.fim = fim;

    hibernateCriterions.remove("fim");

    if (fim != null) {
        // Seta a data de fim para 23:59:59
        fim.setHours(23);//from   w w  w  . j a  v a2  s  .  com
        fim.setMinutes(59);
        fim.setSeconds(59);

        hibernateCriterions.put("fim", Restrictions.le("logDate", fim));
    }
}

From source file:br.com.hslife.orcamento.repository.AgendaRepository.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Agenda> findByCriterioAgendamento(CriterioAgendamento criterioBusca) {
    Criteria criteria = getSession().createCriteria(Agenda.class);

    if (criterioBusca.getDescricao() != null && !criterioBusca.getDescricao().trim().isEmpty()) {
        criteria.add(Restrictions.ilike("descricao", criterioBusca.getDescricao(), MatchMode.ANYWHERE));
    }//from  w ww  . ja va  2s.co  m

    if (criterioBusca.getInicio() != null) {
        criteria.add(Restrictions.ge("inicio", criterioBusca.getInicio()));
    }

    if (criterioBusca.getFim() != null) {
        criteria.add(Restrictions.le("fim", criterioBusca.getFim()));
    }

    if (criterioBusca.getTipo() != null) {
        criteria.add(Restrictions.eq("tipoAgendamento", criterioBusca.getTipo()));
    }

    if (criterioBusca.getUsuario() != null) {
        criteria.add(Restrictions.eq("usuario.id", criterioBusca.getUsuario().getId()));
    }

    return criteria.addOrder(Order.asc("descricao")).list();
}