Example usage for org.hibernate.criterion Restrictions ge

Introduction

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

Prototype

public static SimpleExpression ge(String propertyName, Object value) 

Source Link

Document

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

Usage

From source file:au.org.theark.phenotypic.model.dao.PhenotypicDao.java

License:Open Source License

public List<PhenoDataSetCollection> getSubjectMatchingPhenoCollections(LinkSubjectStudy subject,
        PhenoDataSetGroup phenoDataSetGroup, Date recordDate) {
    log.info("subject " + subject.getSubjectUID());
    log.info("phenoDataSetGroup " + phenoDataSetGroup.getName());
    log.info("date: " + recordDate);
    Criteria criteria = getSession().createCriteria(PhenoDataSetCollection.class);
    criteria.add(Restrictions.eq("linkSubjectStudy", subject));
    criteria.add(Restrictions.eq("questionnaire", phenoDataSetGroup));
    Calendar cal = Calendar.getInstance();
    cal.setTime(recordDate);//  w  ww  .j  a v a2  s . c  o  m

    //Removing the "Time" section of the Dates as that's not important in this context
    cal.set(Calendar.HOUR_OF_DAY, 0);
    cal.set(Calendar.MINUTE, 0);
    cal.set(Calendar.SECOND, 0);
    cal.set(Calendar.MILLISECOND, 0);

    Date low = cal.getTime();
    cal.add(Calendar.DATE, 1);
    Date high = cal.getTime();
    criteria.add(Restrictions.lt("recordDate", high));
    criteria.add(Restrictions.ge("recordDate", low));

    return criteria.list();
}

---

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

License:Open Source License

public List<ResearcherCostDataRow> getResearcherBillableItemTypeCostData(
        final ResearcherCostResportVO researcherCostResportVO) {
    List<ResearcherCostDataRow> results = new ArrayList<ResearcherCostDataRow>();
    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("bit.billableItemTypeStatus", "bitst", JoinType.LEFT_OUTER_JOIN);
    criteria.createAlias("wr.researcher", "re", JoinType.LEFT_OUTER_JOIN);

    criteria.add(Restrictions.eq("re.id", researcherCostResportVO.getResearcherId()));
    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()));
    criteria.add(Restrictions.eq("bitst.name", "ACTIVE"));

    ProjectionList projectionList = Projections.projectionList();
    projectionList.add(Projections.groupProperty("bit.id"));
    projectionList.add(Projections.property("bit.itemName"), "costType");
    projectionList.add(Projections.sum("bi.totalCost"), "totalCost");
    projectionList.add(Projections.sum("bi.totalGST"), "totalGST");

    criteria.setProjection(projectionList); // only return fields required for report
    criteria.setResultTransformer(Transformers.aliasToBean(ResearcherCostDataRow.class));

    criteria.addOrder(Order.asc("bit.itemName"));
    results = criteria.list();/*from w w  w .j ava  2s . co  m*/
    return results;
}

---

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  www . j  a  v  a  2 s.c  om

    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));
    }/*from   w ww  .  jav  a2 s.  c om*/

    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.financeiro.dao.LancamentoDAOHibernate.java

@Override
public List<Lancamento> listar(Conta conta, Date dataInicio, Date dataFim) {
    Criteria criteria = this.session.createCriteria(Lancamento.class);

    if (dataInicio != null && dataFim != null) {
        criteria.add(Restrictions.between("data", dataInicio, dataFim));
    } else if (dataInicio != null) {
        criteria.add(Restrictions.ge("data", dataInicio));
    } else if (dataFim != null) {
        criteria.add(Restrictions.ge("data", dataFim));
    }/*from   ww  w  .  j  a  v  a  2 s . com*/

    criteria.add(Restrictions.eq("conta", conta));
    criteria.addOrder(Order.asc("data"));
    return criteria.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 w w  w.ja  v a  2 s .c  o  m

        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.gerenciapessoal.repository.Lancamentos.java

@SuppressWarnings("UnusedAssignment")
public Map<Date, BigDecimal> valoresTotaisPorData(Integer numeroDeDias, Conta conta) {
    Session session = manager.unwrap(Session.class);

    Calendar dataInicial = Calendar.getInstance();
    dataInicial = DateUtils.truncate(dataInicial, Calendar.DAY_OF_MONTH);
    dataInicial.add(Calendar.DAY_OF_MONTH, numeroDeDias * -1);

    Map<Date, BigDecimal> resultado = criarMapaVazio(numeroDeDias, dataInicial);

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

    criteria.setProjection(Projections.projectionList()
            .add(Projections.sqlGroupProjection("date(data_emissao) as data", "date(data_emissao)",
                    new String[] { "data" }, new Type[] { StandardBasicTypes.DATE }))
            .add(Projections.sum("valorLanca").as("valor")))
            .add(Restrictions.ge("dataEmissao", dataInicial.getTime()));

    if (conta != null) {
        criteria.add(Restrictions.eq("c.id", conta.getId()));
    }/*from   w  w w  . ja v  a 2s .  c o  m*/
    List<DataValor> valoresPorData = criteria.setResultTransformer(Transformers.aliasToBean(DataValor.class))
            .list();

    for (DataValor dataValor : valoresPorData) {
        resultado.put(dataValor.getData(), dataValor.getValor());
    }

    return resultado;
}

---

From source file:br.com.hslife.catu.dao.AtendimentoDao.java

License:Open Source License

@SuppressWarnings("unchecked")
public List<Atendimento> listaTodosPorCodigoDataAberturaEStatus(Long codAtend, Date dataAbertura,
        Status status) {/*from   w ww.jav  a  2 s . c o m*/
    List<Atendimento> resultado = new ArrayList<Atendimento>();
    try {
        Criteria criteria = HibernateUtil.getSession().createCriteria(Atendimento.class);
        if (codAtend != null) {
            criteria.add(Restrictions.eq("id", codAtend));
        }
        if (dataAbertura != null) {
            criteria.add(Restrictions.ge("dataAbertura", dataAbertura));
        }
        if (status != null) {
            criteria.add(Restrictions.eq("idStatus.id", status.getId()));
        }
        resultado = criteria.list();
    } catch (Exception e) {
        errorMessage = e.getMessage();
        stackTrace = e.getStackTrace().toString();
        e.printStackTrace();
    }
    return resultado;
}

---

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  w  w .  j a v  a 2  s .c o  m
    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.imobiliaria.dao.impl.ImovelDao.java

License:Open Source License

@Override
public List listByExample(Object example) {
    Imovel i = (Imovel) example;//from  ww w  . j a  va  2s  .  c  o m
    List<Criterion> restricoes = new ArrayList<Criterion>();
    if (i.getNumRegistro() != null && !i.getNumRegistro().isEmpty()) {
        restricoes.add(Restrictions.ilike("numRegistro", i.getNumRegistro(), MatchMode.ANYWHERE));
    }
    if (i.getLocador() != null && i.getLocador().getId() != null && i.getLocador().getId() > 0) {
        restricoes.add(Restrictions.eq("locador.id", i.getLocador().getId()));
    }
    if (i.getValor() != null) {
        restricoes.add(Restrictions.ge("valor", i.getValor()));
    }
    if (i.getTipoImovel() != null && !i.getTipoImovel().isEmpty()) {
        restricoes.add(Restrictions.ilike("tipoImovel", i.getTipoImovel(), MatchMode.ANYWHERE));
    }
    if (i.getSituacaoImovel() != null && !i.getSituacaoImovel().isEmpty()) {
        restricoes.add(Restrictions.ilike("situacaoImovel", i.getSituacaoImovel(), MatchMode.ANYWHERE));
    }
    if (i.getSite() != null) {
        restricoes.add(Restrictions.eq("site", i.getSite()));
    }
    if (i.getAtivo() != null) {
        restricoes.add(Restrictions.eq("ativo", i.getAtivo()));
    }
    return super.listByCriteria(Imovel.class, restricoes);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• 50
• »