Example usage for org.hibernate.criterion Restrictions gt

Introduction

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

Prototype

public static SimpleExpression gt(String propertyName, Object value) 

Source Link

Document

Apply a "greater than" constraint to the named property

Usage

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

License:Open Source License

@Override
public PickedPhenoDataSetCategory getSwapOverPickedPhenoDataSetCategoryForDownButton(
        PickedPhenoDataSetCategory pickedPhenoDataSetCategory) {
    Criteria criteria = getSession().createCriteria(PickedPhenoDataSetCategory.class);
    criteria.add(Restrictions.eq("arkFunction", pickedPhenoDataSetCategory.getArkFunction()));
    criteria.add(Restrictions.eq("study", pickedPhenoDataSetCategory.getStudy()));
    criteria.add(Restrictions.eq("arkUser", pickedPhenoDataSetCategory.getArkUser()));
    if (pickedPhenoDataSetCategory.getParentPickedPhenoDataSetCategory() != null) {
        criteria.add(Restrictions.eq("parentPickedPhenoDataSetCategory",
                pickedPhenoDataSetCategory.getParentPickedPhenoDataSetCategory()));
    } else {//from w  ww .  j av  a 2  s .  c  o  m
        criteria.add(Restrictions.isNull("parentPickedPhenoDataSetCategory"));
    }
    criteria.add(Restrictions.gt("orderNumber", pickedPhenoDataSetCategory.getOrderNumber()));
    criteria.addOrder(Order.asc("orderNumber"));
    criteria.setFirstResult(0);
    criteria.setMaxResults(1);
    List<PickedPhenoDataSetCategory> pickedPhenoDataSetCategories = (List<PickedPhenoDataSetCategory>) criteria
            .list();
    if (pickedPhenoDataSetCategories.size() > 0) {
        return pickedPhenoDataSetCategories.get(0);
    } else {
        return null;
    }
}

---

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

License:Open Source License

@Override
public LinkPhenoDataSetCategoryField getSwapOverPhenoDataSetFieldForDownButton(
        LinkPhenoDataSetCategoryField linkPhenoDataSetCategoryField) {
    Criteria criteria = getSession().createCriteria(LinkPhenoDataSetCategoryField.class);
    criteria.add(Restrictions.eq("arkFunction", linkPhenoDataSetCategoryField.getArkFunction()));
    criteria.add(Restrictions.eq("study", linkPhenoDataSetCategoryField.getStudy()));
    criteria.add(Restrictions.eq("arkUser", linkPhenoDataSetCategoryField.getArkUser()));
    criteria.add(/* w  w  w  .  ja v a2s. co  m*/
            Restrictions.eq("phenoDataSetCategory", linkPhenoDataSetCategoryField.getPhenoDataSetCategory()));
    criteria.add(Restrictions.gt("orderNumber", linkPhenoDataSetCategoryField.getOrderNumber()));
    criteria.addOrder(Order.asc("orderNumber"));
    criteria.setFirstResult(0);
    criteria.setMaxResults(1);
    List<LinkPhenoDataSetCategoryField> linkPhenoDataSetCategoryFields = (List<LinkPhenoDataSetCategoryField>) criteria
            .list();
    if (linkPhenoDataSetCategoryFields.size() > 0) {
        return linkPhenoDataSetCategoryFields.get(0);
    } else {
        return null;
    }
}

---

From source file:br.com.muranodesign.dao.impl.CalendarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listarEvento(int id) throws ParseException {

    Date data = Calendar.getInstance().getTime();

    Criteria criteria = getSession().createCriteria(Calendario.class);
    criteria.createAlias("tipoEvento", "tipoEvento");
    criteria.add(Restrictions.eq("tipoEvento.idtipoEvento", id));
    criteria.add(Restrictions.gt("dataInicio", data));
    criteria.addOrder(Order.asc("dataInicio"));
    List<Calendario> result = criteria.list();
    return result;
}

---

From source file:br.com.muranodesign.dao.impl.CalendarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<Calendario> listarFeriadosSemana(int dia, int mes) {
    Criteria criteria = getSession().createCriteria(Calendario.class);

    Calendar dataInicio = Calendar.getInstance();
    dataInicio.set(Calendar.MONTH, mes);
    dataInicio.set(Calendar.DATE, dia);
    dataInicio.set(Calendar.WEEK_OF_MONTH, dataInicio.get(Calendar.WEEK_OF_MONTH));
    dataInicio.set(Calendar.DAY_OF_WEEK, dataInicio.getFirstDayOfWeek());
    Calendar dataFim = Calendar.getInstance();
    dataFim.set(Calendar.MONTH, mes);
    dataFim.set(Calendar.DATE, dataInicio.get(Calendar.DATE) + 6);

    criteria.add(Restrictions.or(Restrictions.ge("feriado", 1), Restrictions.eq("aula", 0)));

    criteria.add(Restrictions.or(// w w w .j  a  va2s.c o m
            (Restrictions.or(Restrictions.between("dataInicio", dataInicio.getTime(), dataFim.getTime()),
                    Restrictions.between("dataFim", dataInicio.getTime(), dataFim.getTime()))),
            Restrictions.and(Restrictions.lt("dataInicio", dataInicio.getTime()),
                    Restrictions.gt("dataFim", dataFim.getTime()))));
    criteria.addOrder(Order.asc("dataInicio"));

    List<Calendario> result = criteria.list();

    return result;

}

---

From source file:br.com.muranodesign.dao.impl.ChamadaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public long countFaltas(int id) {
    short t = 0;/* w w  w  . ja va 2  s .co  m*/
    Criteria criteria = getSession().createCriteria(Chamada.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.gt("data", cal.getTime()));
    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", id));
    criteria.add(Restrictions.eq("presenca", t));
    List<Chamada> result = criteria.list();
    long r = result.size();
    return r;
}

---

From source file:br.com.muranodesign.dao.impl.ChamadaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public long countPresencas(int id) {
    Criteria criteria = getSession().createCriteria(Chamada.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.gt("data", cal.getTime()));
    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", id));
    criteria.add(Restrictions.eq("presenca", (short) 1));
    List<Chamada> result = criteria.list();
    long r = result.size();
    return r;//from www  .j a  v  a 2s.c  o  m
}

---

From source file:br.com.muranodesign.dao.impl.ChamadaDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public long countCompensacao(Integer idAluno) {
    Criteria criteria = getSession().createCriteria(Chamada.class);
    Calendar cal = Calendar.getInstance();
    cal.set(Calendar.DAY_OF_YEAR, 1);
    criteria.add(Restrictions.gt("data", cal.getTime()));
    criteria.createAlias("aluno", "aluno");
    criteria.add(Restrictions.eq("aluno.idAluno", idAluno));
    criteria.add(Restrictions.eq("presenca", (short) 3));
    List<Chamada> result = criteria.list();
    long r = result.size();
    return r;//from w ww  . ja  va2s.com
}

---

From source file:br.gov.jfrj.siga.ex.bl.ExBL.java

License:Open Source License

public void numerarTudo(int aPartirDe) {
    List<ExDocumento> list = new ArrayList<ExDocumento>();

    final Criteria countCrit = dao().getSessao().createCriteria(ExDocumento.class)
            .add(Restrictions.gt("idDoc", new Long(aPartirDe)));
    countCrit.setProjection(Projections.rowCount());
    Integer totalDocs = ((Long) countCrit.uniqueResult()).intValue();

    final Criteria crit = dao().getSessao().createCriteria(ExDocumento.class)
            .add(Restrictions.gt("idDoc", new Long(aPartirDe)));
    crit.setMaxResults(60);/*from  w  w w  .ja v a 2s . c  o m*/
    crit.addOrder(Order.asc("idDoc"));

    int index = 0;

    do {
        long inicio = System.currentTimeMillis();
        //System.gc();
        iniciarAlteracao();
        crit.setFirstResult(index);
        list = crit.list();
        for (ExDocumento doc : list) {
            index++;
            try {
                for (ExMovimentacao m : doc.getExMovimentacaoSet()) {
                    m.setNumPaginas(m.getContarNumeroDePaginas());
                    dao().gravar(m);
                }
            } catch (Throwable e) {
                System.out.println("Erro ao marcar o doc " + doc);
                e.printStackTrace();
            }
            if (index % 50 == 0) {
                //               System.gc();
            }
            System.out.print(doc.getIdDoc() + " ok - ");
        }
        ExDao.commitTransacao();
        dao().getSessao().clear();
        long duracao = System.currentTimeMillis() - inicio;
        System.out.println();
        System.out.println(new SimpleDateFormat("HH:mm:ss").format(new Date()) + " " + String.valueOf(index)
                + " numerados de " + totalDocs);
    } while (list.size() > 0);

    //System.gc();
}

---

From source file:br.gov.jfrj.siga.hibernate.ExDao.java

License:Open Source License

public void listarNaoIndexados(int aPartir, boolean irIndexando) throws Exception {

    long tempoIni = System.currentTimeMillis();
    FullTextSession fullTextSession = Search.getFullTextSession(getSessao());
    QueryParser parser = new QueryParser(Version.LUCENE_36, "idDoc", new StandardAnalyzer(Version.LUCENE_36));

    final Criteria crit = getSessao().createCriteria(ExDocumento.class)
            .add(Restrictions.gt("idDoc", new Long(aPartir)));
    crit.setMaxResults(300);/*w w  w  .jav a2  s. co  m*/
    crit.addOrder(Order.asc("idDoc"));
    List<ExDocumento> list = new ArrayList<ExDocumento>();
    int firstResult = 0;
    do {
        crit.setFirstResult(firstResult);
        list = crit.list();
        for (ExDocumento doc : list) {
            firstResult++;
            if (doc.isIndexavel() && (fullTextSession
                    .createFullTextQuery(new TermQuery(new Term("idDoc", String.valueOf(doc.getIdDoc()))),
                            ExDocumento.class)
                    .getResultSize() == 0)) {

                if (irIndexando) {
                    System.out.println("listarNaoIndexados - indexando " + doc.getCodigo());
                    indexar(doc);
                } else {
                    System.out.println("listarNaoIndexados - nao indexar " + doc.getCodigo());
                }
            }
        }
        System.out.println("listarNaoIndexados - " + firstResult + " varridos");
        getSessao().clear();
    } while (list.size() > 0);
    System.out.println(
            "listarNaoIndexados - FIM    " + (System.currentTimeMillis() - tempoIni) / 3600000 + " minutos");
}

---

From source file:br.gov.jfrj.siga.hibernate.ExDao.java

License:Open Source License

public void indexarUltimas(int desde) throws Exception {

    System.out.println("Indexando documentos...");
    long inicio = new Date().getTime();

    Calendar cal = Calendar.getInstance();
    cal.add(Calendar.MINUTE, desde);
    Date dtIni = cal.getTime();//  ww  w  . ja  v a 2s  . c  o  m

    Criteria crit = getSessao().createCriteria(ExDocumento.class);
    crit.createCriteria("exMovimentacaoSet").add(Restrictions.gt("dtIniMov", dtIni));
    crit.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    /*
     * Query indexQuery = getSessao() .createQuery( "from ExDocumento as doc
     * inner join doc.exMovimentacaoSet as mov where mov.dtIniMov >=
     * :dtIni"); indexQuery.setParameter("dtIni", dtIni);
     */

    FullTextSession fullTextSession = Search.getFullTextSession(getSessao());
    // List<ExDocumento> list = indexQuery.list();
    List<ExDocumento> list = crit.list();
    Transaction tx = fullTextSession.beginTransaction();
    for (ExDocumento doc : list) {
        System.out.println(" . " + doc.getIdDoc());
        fullTextSession.purge(ExDocumento.class, doc);
        if (doc.isIndexavel())
            fullTextSession.index(doc);
    }
    tx.commit();
    fullTextSession.clear();
    getSessao().clear();
    //System.gc();

    // fullTextSession.close();
    System.out.println("Durao da indexao de documentos: " + (new Date().getTime() - inicio));

}

---

• «
• 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
• »