Example usage for org.hibernate.criterion Restrictions 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:com.cai310.lottery.web.controller.lottery.SchemeBaseController.java

/**
 * ?//from w  w  w  . jav  a 2 s.  c om
 */
protected XDetachedCriteria buildListDetachedCriteria() {
    XDetachedCriteria criteria = new XDetachedCriteria(this.schemeClass, "m");

    criteria.add(Restrictions.eq("m.periodId", this.period.getId()));

    criteria.add(Restrictions.eq("m.shareType", ShareType.TOGETHER));

    if (queryForm != null) {
        if (StringUtils.isNotBlank(queryForm.getSponsorName())) {
            if (!"???".equals(queryForm.getSponsorName().trim())) {
                criteria.add(Restrictions.or(Restrictions.eq("m.sponsorName", queryForm.getSponsorName()),
                        Restrictions.eq("m.sponsorName", queryForm.getSponsorName())));
            }
        }
        if (StringUtils.isNotBlank(queryForm.getSchemeNumber())) {
            Long schemeId = this.period.getLotteryType().getSchemeId(queryForm.getSchemeNumber());
            if (schemeId != null)
                criteria.add(Restrictions.eq("m.id", schemeId));
        }
        if (null != queryForm.getCostType()) {
            queryForm.setMinMaxCost();
        }
        if (null != queryForm.getChooseType()) {
            if (Integer.valueOf(1).equals(queryForm.getChooseType())) {
                // ?
                criteria.add(Restrictions.eq("m.sendToPrint", true));
            } else if (Integer.valueOf(2).equals(queryForm.getChooseType())) {
                // 
                User user = this.getLoginUser();
                if (user != null) {
                    criteria.add(Restrictions.eq("m.sponsorId", user.getId()));
                }
            }
        }
        if (queryForm.getMinSchemeCost() != null)
            criteria.add(Restrictions.ge("m.schemeCost", queryForm.getMinSchemeCost()));

        if (queryForm.getMaxSchemeCost() != null)
            criteria.add(Restrictions.le("m.schemeCost", queryForm.getMaxSchemeCost()));

        if (queryForm.getSchemeState() != null)
            criteria.add(Restrictions.eq("m.state", queryForm.getSchemeState()));

        if (queryForm.getOrderType() != null) {
            criteria.addOrder(Order.desc("m.orderPriority"));
            switch (queryForm.getOrderType()) {
            case CREATE_TIME_DESC:
                criteria.addOrder(Order.desc("m.id"));
                break;
            case CREATE_TIME_ASC:
                criteria.addOrder(Order.asc("m.id"));
                break;
            case PROCESS_RATE_DESC:
                criteria.addOrder(Order.desc("m.progressRate"));
                break;
            case PROCESS_RATE_ASC:
                criteria.addOrder(Order.asc("m.progressRate"));
                break;
            case SCHEME_COST_DESC:
                criteria.addOrder(Order.desc("m.schemeCost"));
                break;
            case SCHEME_COST_ASC:
                criteria.addOrder(Order.asc("m.schemeCost"));
                break;
            }
            criteria.addOrder(Order.asc("m.state"));
        } else {
            criteria.addOrder(Order.asc("m.state"));
            criteria.addOrder(Order.desc("m.orderPriority"));
            criteria.addOrder(Order.desc("m.progressRate"));
            criteria.addOrder(Order.desc("m.id"));
        }
    } else {
        criteria.addOrder(Order.asc("m.state"));
        criteria.addOrder(Order.desc("m.orderPriority"));
        criteria.addOrder(Order.desc("m.progressRate"));
        criteria.addOrder(Order.desc("m.id"));
    }

    return criteria;
}

---

From source file:com.cai310.lottery.web.controller.lottery.SchemeBaseController.java

/**
 * ? ???//from   w  w  w  . j  a va 2s  .  c  om
 */
protected XDetachedCriteria buildFilterListDetachedCriteria() {
    XDetachedCriteria criteria = new XDetachedCriteria(this.schemeClass, "m");
    criteria.add(Restrictions.eq("m.periodId", this.period.getId()));

    criteria.add(Restrictions.eq("m.shareType", ShareType.TOGETHER));
    if (queryForm != null) {
        // ??
        if (queryForm != null && queryForm.getSecretType() != null) {
            if (queryForm.getSecretType() != SecretType.FULL_PUBLIC) {
                // 
                criteria.add(Restrictions.ne("m.secretType", SecretType.FULL_PUBLIC));
                Struts2Utils.setAttribute("flag", 1);
            }

        } else {
            Struts2Utils.setAttribute("flag", 0);
        }
        if (StringUtils.isNotBlank(queryForm.getSponsorName())) {
            ///?
            if (!"???".equals(queryForm.getSponsorName().trim())) {
                Long schemeId = this.period.getLotteryType().getSchemeId(queryForm.getSponsorName().trim());
                if (schemeId != null) {
                    criteria.add(Restrictions.eq("m.id", schemeId));
                } else {
                    criteria.add(Restrictions.eq("m.sponsorName", queryForm.getSponsorName().trim()));
                }
            }
        }
        if (null != queryForm.getCostType()) {
            queryForm.setMinMaxCost();
        }
        if (null != queryForm.getChooseType()) {
            if (Integer.valueOf(1).equals(queryForm.getChooseType())) {
                // ?
                criteria.add(Restrictions.eq("m.sendToPrint", true));
            } else if (Integer.valueOf(2).equals(queryForm.getChooseType())) {
                // 
                User user = this.getLoginUser();
                if (user != null) {
                    criteria.add(Restrictions.eq("m.sponsorId", user.getId()));
                }
            }
        }
        if (queryForm.getMinSchemeCost() != null)
            criteria.add(Restrictions.ge("m.schemeCost", queryForm.getMinSchemeCost()));

        if (queryForm.getMaxSchemeCost() != null)
            criteria.add(Restrictions.le("m.schemeCost", queryForm.getMaxSchemeCost()));

        if (queryForm.getSchemeState() != null) {
            criteria.add(Restrictions.eq("m.state", queryForm.getSchemeState()));
        }
    }
    if (queryForm != null && queryForm.getOrderType() != null) {
        switch (queryForm.getOrderType()) {
        case CREATE_TIME_DESC:
            criteria.addOrder(Order.desc("m.id"));
            break;
        case CREATE_TIME_ASC:
            criteria.addOrder(Order.asc("m.id"));
            break;
        case PROCESS_RATE_DESC:
            criteria.addOrder(Order.desc("m.progressRate"));
            break;
        case PROCESS_RATE_ASC:
            criteria.addOrder(Order.asc("m.progressRate"));
            break;
        case SCHEME_COST_DESC:
            criteria.addOrder(Order.desc("m.schemeCost"));
            break;
        case SCHEME_COST_ASC:
            criteria.addOrder(Order.asc("m.schemeCost"));
            break;
        }
    } else {
        criteria.addOrder(Order.desc("m.orderPriority"));
        criteria.addOrder(Order.asc("m.state"));
        criteria.addOrder(Order.desc("m.progressRate"));
    }

    Calendar c = Calendar.getInstance();
    c.add(Calendar.HOUR_OF_DAY, 0);
    c.add(Calendar.MINUTE, 0);
    c.add(Calendar.SECOND, 0);
    c.add(Calendar.DAY_OF_MONTH, -10);
    criteria.add(Restrictions.gt("m.createTime", c.getTime()));

    criteria.setMaxResults(50);
    criteria.addOrder(Order.desc("m.id"));
    return criteria;
}

---

From source file:com.callcenter.controller.command.Till.java

License:Apache License

public void addSearchFilter(DetachedCriteria criteria) {
    Calendar tillDate = Calendar.getInstance();
    if (type == Type.DATE_AND_TIME) {
        tillDate = dateAndTime;// ww  w . j  a v a 2 s .c o  m
    }
    criteria.add(Restrictions.le(Constants.CallRecord.CALL_TIME_PROPERTY_NAME, tillDate));
}

---

From source file:com.cimmyt.model.dao.impl.AbstractDAO.java

License:Apache License

/**
 * adds a criterion to a Junction(conjunction/disjunction), based on the meta-data passed.
 * /*from   w  w  w. j  a  v a 2  s .  co m*/
 * @param junction The Junction to conditionally add a criterion
 * @param condition The type of criterion: like, equals, etc.
 * @param dataType Indicates if its a numeric or character value for a filter
 * @param qualifiedParam the qualified parameter for a query
 * @param value The string value to use in the criterion
 */
public void addDynamicCriterion(Junction junction, Operator condition, DataType dataType, String qualifiedParam,
        String value) {
    if (!qualifiedParam.equals("sample.studysampleid")) {

        if (dataType == DataType.STRING) {
            if (condition == Operator.TypeString.LIKE) {
                junction.add(Restrictions.like(qualifiedParam, value, MatchMode.ANYWHERE));
            } else if (condition == Operator.TypeString.EQUAL) {
                junction.add(Restrictions.like(qualifiedParam, value, MatchMode.EXACT));
            } else if (condition == Operator.TypeString.NOT_EQUAL) {
                junction.add(Restrictions.ne(qualifiedParam, value));
            } else if (condition == Operator.TypeString.NOT_LIKE) {
                junction.add(Restrictions.not(Restrictions.like(qualifiedParam, value, MatchMode.ANYWHERE)));
            }

        } else if (dataType == DataType.NUMBER) {
            if (condition == Operator.TypeNumber.EQUALS) {
                junction.add(Restrictions.eq(qualifiedParam, Integer.valueOf(value)));
            } else if (condition == Operator.TypeNumber.GREATER) {
                junction.add(Restrictions.ge(qualifiedParam, Integer.valueOf(value)));
            }
            if (condition == Operator.TypeNumber.LESS) {
                junction.add(Restrictions.le(qualifiedParam, Integer.valueOf(value)));
            } else if (condition == Operator.TypeNumber.NOT_EQUALS) {
                junction.add(Restrictions.ne(qualifiedParam, Integer.valueOf(value)));
            } else if (condition == Operator.TypeNumber.IN) {
                List<Integer> listStr = new ArrayList<Integer>();
                String[] arr = value.split(",");
                for (int i = 0; i < arr.length; i++) {
                    try {
                        if (!arr[i].trim().equals(""))
                            listStr.add(Integer.parseInt(arr[i]));
                    } catch (Exception ex) {
                        ex.printStackTrace();
                    }
                }
                junction.add(Restrictions.in(qualifiedParam, listStr));
            }

        }
    } else {
        String prefix = StrUtils.getPrefixSampleFindString(value);
        int id = StrUtils.getSampleIDFindString(value);
        if (prefix.trim().equals(""))
            prefix = value;
        if (condition == Operator.TypeString.LIKE) {
            junction.add(Restrictions.like("study.prefix", prefix, MatchMode.ANYWHERE));
            if (id > 0)
                junction.add(Restrictions.eq("sample.samplegid", id));
        } else if (condition == Operator.TypeString.EQUAL) {
            junction.add(Restrictions.eq("study.prefix", prefix));
            if (id > 0)
                junction.add(Restrictions.eq("sample.samplegid", id));
        } else if (condition == Operator.TypeString.NOT_EQUAL) {
            junction.add(Restrictions.ne("study.prefix", prefix));
            if (id > 0)
                junction.add(Restrictions.ne("sample.samplegid", id));
        } else if (condition == Operator.TypeString.NOT_LIKE) {
            junction.add(Restrictions.not(Restrictions.like("study.prefix", prefix, MatchMode.ANYWHERE)));
            if (id > 0)
                junction.add(Restrictions.not(Restrictions.eq("sample.samplegid", id)));
        }
    }
}

---

From source file:com.cimmyt.model.dao.impl.LogDAOImpl.java

License:Apache License

@Override
protected void buildCriteria(DetachedCriteria _criteria, Log filter, Integer id) {
    this.criteria = _criteria;
    try {//w w w. j  ava2 s.com
        if (initDate != null && endDate != null) {
            criteria.add(Restrictions.between("operationDate", StrUtils.getDateStandarFromStr(initDate),
                    StrUtils.getDateStandarFromStr(endDate)));
        } else if (initDate != null && endDate == null) {
            criteria.add(Restrictions.ge("operationDate", StrUtils.getDateStandarFromStr(initDate)));
        } else if (endDate != null && initDate == null) {
            criteria.add(Restrictions.le("operationDate", StrUtils.getDateStandarFromStr(endDate)));
        }
    } catch (ParseException pEx) {
        pEx.printStackTrace();
    }

    switch (id) {
    case ConstantsDNA.ROLE_ADMINISTRATOR:
        validateRoleResearcher(filter);
        break;
    case ConstantsDNA.ROLE_DATA_MANAGER:
        addCriteriaNotAdministrator();
        validateRoleResearcher(filter);
        break;
    case ConstantsDNA.ROLE_RESEARCHER:
        addCriteriaNotAdministrator();
        criteria.add(Restrictions.sqlRestriction(
                "this_.user_version_id not in (Select  u.user_version_id from st_user_version u where u.idst_rol ="
                        + ConstantsDNA.ROLE_DATA_MANAGER + ")"));
        validateRoleResearcher(filter);
        break;
    }
    if (filter.getLogTyperOperation() != null && filter.getLogTyperOperation().getIdLogTypeOperation() != null)
        criteria.add(Restrictions.eq("logTyperOperation.idLogTypeOperation",
                filter.getLogTyperOperation().getIdLogTypeOperation()));
    criteria.addOrder(Order.asc("operationDate"));

}

---

From source file:com.codefupanda.persistor.util.HibernateUtil.java

License:Open Source License

private static Criterion convert(PropertyValueExpressionCriteria criteria) {
    Criterion criterion = null;/*from   w  w  w.j  a v a2  s  .c o m*/
    String property = criteria.getProperty();
    Object value = criteria.getValue();

    if (criteria.getOp().equals("=")) {
        criterion = Restrictions.eq(property, value);
    } else if (criteria.getOp().equals(">")) {
        criterion = Restrictions.gt(property, value);
    } else if (criteria.getOp().equals("<")) {
        criterion = Restrictions.lt(property, value);
    } else if (criteria.getOp().equals(">=")) {
        criterion = Restrictions.ge(property, value);
    } else if (criteria.getOp().equals("<=")) {
        criterion = Restrictions.le(property, value);
    } else if (criteria.getOp().equals("in")) {
        criterion = Restrictions.in(property, (Object[]) value);
    } else if (criteria.getOp().equals("like")) {
        criterion = Restrictions.like(property, value);
    } else if (criteria.getOp().equals("ilike")) {
        criterion = Restrictions.ilike(property, value);
    }
    return criterion;
}

---

From source file:com.creativity.repository.Fichas.java

public List<Ficha> filtradosAdmin(FichaFilter filtro) {

    Session session = this.manager.unwrap(Session.class);

    Criteria criteria = session.createCriteria(Ficha.class)
            // fazemos uma associao (join) com cliente e nomeamos como "c"

            // fazemos uma associao (join) com vendedor e nomeamos como "v"
            .createAlias("gestor", "v");

    if (filtro.getNumeroDe() != null) {
        // id deve ser maior ou igual (ge = greater or equals) a filtro.numeroDe
        criteria.add(Restrictions.ge("id", filtro.getNumeroDe()));
    }/*ww  w.  jav  a  2 s . c  om*/

    if (filtro.getNumeroAte() != null) {
        // id deve ser menor ou igual (le = lower or equal) a filtro.numeroDe
        criteria.add(Restrictions.le("id", filtro.getNumeroAte()));
    }

    if (filtro.getDataCriacaoDe() != null) {
        criteria.add(Restrictions.ge("dataCriacao", filtro.getDataCriacaoDe()));
    }

    if (filtro.getDataCriacaoAte() != null) {
        criteria.add(Restrictions.le("dataCriacao", filtro.getDataCriacaoAte()));
    }

    if (filtro.getDataAprovacaoDe() != null) {
        criteria.add(Restrictions.ge("dataAprovacao", filtro.getDataAprovacaoDe()));
    }

    if (filtro.getDataAprovacaoAte() != null) {
        criteria.add(Restrictions.le("dataAprovacao", filtro.getDataAprovacaoAte()));
    }

    if (StringUtils.isNotBlank(filtro.getNomeVendedor())) {
        // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
        criteria.add(Restrictions.ilike("v.nome", filtro.getNomeVendedor(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotBlank(filtro.getNomeCliente())) {
        // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
        criteria.add(Restrictions.ilike("nomeRazao", filtro.getNomeCliente(), MatchMode.ANYWHERE));
    }
    if (filtro.getStatuses() != null && filtro.getStatuses().length > 0) {
        // adicionamos uma restrio "in", passando um array de constantes da enum StatusPedido
        criteria.add(Restrictions.in("statusFicha", filtro.getStatuses()));
    }

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

---

From source file:com.creativity.repository.Fichas.java

public List<Ficha> filtrados(FichaFilter filtro) {
    String nome = null;//from w w w . j ava2s .c  om

    UsuarioSistema usuarioLogado = getUsuarioLogado();

    if (usuarioLogado != null) {
        nome = usuarioLogado.getUsuario().getNome();

    }

    Session session = this.manager.unwrap(Session.class);

    Criteria criteria = session.createCriteria(Ficha.class)
            // fazemos uma associao (join) com cliente e nomeamos como "c"

            // fazemos uma associao (join) com vendedor e nomeamos como "v"
            .createAlias("gestor", "v");

    if (filtro.getNumeroDe() != null) {
        // id deve ser maior ou igual (ge = greater or equals) a filtro.numeroDe
        criteria.add(Restrictions.ge("id", filtro.getNumeroDe()));
    }

    if (filtro.getNumeroAte() != null) {
        // id deve ser menor ou igual (le = lower or equal) a filtro.numeroDe
        criteria.add(Restrictions.le("id", filtro.getNumeroAte()));
    }

    if (filtro.getDataCriacaoDe() != null) {
        criteria.add(Restrictions.ge("dataCriacao", filtro.getDataCriacaoDe()));
    }

    if (filtro.getDataCriacaoAte() != null) {
        criteria.add(Restrictions.le("dataCriacao", filtro.getDataCriacaoAte()));
    }

    if (filtro.getDataAprovacaoDe() != null) {
        criteria.add(Restrictions.ge("dataAprovacao", filtro.getDataAprovacaoDe()));
    }

    if (filtro.getDataAprovacaoAte() != null) {
        criteria.add(Restrictions.le("dataAprovacao", filtro.getDataAprovacaoAte()));
    }

    if (StringUtils.isNotBlank(filtro.getCpf())) {
        criteria.add(Restrictions.ilike("cpf", filtro.getCpf()));
    }

    if (StringUtils.isNotBlank(filtro.getCnpj())) {
        criteria.add(Restrictions.ilike("cnpj", filtro.getCnpj()));
    }

    if (StringUtils.isNotBlank(nome)) {
        // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
        criteria.add(Restrictions.ilike("v.nome", nome, MatchMode.ANYWHERE));
    }
    if (StringUtils.isNotBlank(filtro.getNomeCliente())) {
        criteria.add(Restrictions.ilike("nomeRazao", filtro.getNomeCliente(), MatchMode.ANYWHERE));
    }

    /* if (StringUtils.isNotBlank(filtro.getNomeVendedor())) {
    // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
    criteria.add(Restrictions.ilike("v.nome", filtro.getNomeVendedor(), MatchMode.ANYWHERE));
    }*/
    if (filtro.getStatuses() != null && filtro.getStatuses().length > 0) {
        // adicionamos uma restrio "in", passando um array de constantes da enum StatusPedido
        criteria.add(Restrictions.in("statusFicha", filtro.getStatuses()));
    }

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

---

From source file:com.creativity.repository.LancamentosFinanceiros.java

public List<Financeiro> filtradosAguardandoPagamento(FinanceiroFilter filtro) {

    Session session = this.manager.unwrap(Session.class);

    Criteria criteria = session.createCriteria(Financeiro.class)
            // fazemos uma associao (join) com cliente e nomeamos como "c"

            // fazemos uma associao (join) com vendedor e nomeamos como "v"
            .createAlias("ficha", "f");

    if (filtro.getNumeroDe() != null) {
        // id deve ser maior ou igual (ge = greater or equals) a filtro.numeroDe
        criteria.add(Restrictions.ge("id", filtro.getNumeroDe()));
    }/*from w w  w  . j a va  2s .  co m*/

    if (filtro.getNumeroAte() != null) {
        // id deve ser menor ou igual (le = lower or equal) a filtro.numeroDe
        criteria.add(Restrictions.le("id", filtro.getNumeroAte()));
    }

    if (filtro.getDataCriacaoDe() != null) {
        criteria.add(Restrictions.ge("dataLancamento", filtro.getDataCriacaoDe()));
    }

    if (filtro.getDataCriacaoAte() != null) {
        criteria.add(Restrictions.le("dataLancamento", filtro.getDataCriacaoAte()));
    }

    if (StringUtils.isNotBlank(filtro.getNomeCliente())) {
        // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
        criteria.add(Restrictions.ilike("f.nomeRazao", filtro.getNomeCliente(), MatchMode.ANYWHERE));
    }

    if (StringUtils.isNotBlank(filtro.getNomeCliente())) {
        // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
        criteria.add(Restrictions.ilike("f.nomeRazao", filtro.getNomeCliente(), MatchMode.ANYWHERE));
    }

    if (filtro.getStatusDocFinanceiro() != null && filtro.getStatusDocFinanceiro().length > 0) {
        // adicionamos uma restrio "in", passando um array de constantes da enum StatusPedido
        criteria.add(Restrictions.in("statusFinanceiro", filtro.getStatusDocFinanceiro()));
    }

    if (filtro.getGestor() != null) {
        // id deve ser maior ou igual (ge = greater or equals) a filtro.numeroDe
        criteria.add(Restrictions.eq("f.gestor.id", filtro.getGestor()));
    }

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

---

From source file:com.creativity.repository.LancamentosFinanceiros.java

public List<Financeiro> filtradosAguardandoPagamentoPorGestor(FinanceiroFilter filtro) {

    Long usuarioGestorLogado = null;

    UsuarioSistema usuarioLogado = getUsuarioLogado();

    if (usuarioLogado != null) {
        usuarioGestorLogado = usuarioLogado.getUsuario().getId();

    }/*w ww  . j  a  v  a2  s  .co m*/

    Session session = this.manager.unwrap(Session.class);

    Criteria criteria = session.createCriteria(Financeiro.class)
            // fazemos uma associao (join) com cliente e nomeamos como "c"

            // fazemos uma associao (join) com vendedor e nomeamos como "v"
            .createAlias("ficha", "f").add(Restrictions.eq("f.gestor.id", usuarioGestorLogado));

    if (filtro.getNumeroDe() != null) {
        // id deve ser maior ou igual (ge = greater or equals) a filtro.numeroDe
        criteria.add(Restrictions.ge("id", filtro.getNumeroDe()));
    }

    if (filtro.getNumeroAte() != null) {
        // id deve ser menor ou igual (le = lower or equal) a filtro.numeroDe
        criteria.add(Restrictions.le("id", filtro.getNumeroAte()));
    }

    if (filtro.getDataCriacaoDe() != null) {
        criteria.add(Restrictions.ge("dataLancamento", filtro.getDataCriacaoDe()));
    }

    if (filtro.getDataCriacaoAte() != null) {
        criteria.add(Restrictions.le("dataLancamento", filtro.getDataCriacaoAte()));
    }

    if (filtro.getStatusDocFinanceiro() != null && filtro.getStatusDocFinanceiro().length > 0) {
        // adicionamos uma restrio "in", passando um array de constantes da enum StatusPedido
        criteria.add(Restrictions.in("statusFinanceiro", filtro.getStatusDocFinanceiro()));
    }

    if (StringUtils.isNotBlank(filtro.getNomeCliente())) {
        // acessamos o nome do vendedor associado ao pedido pelo alias "v", criado anteriormente
        criteria.add(Restrictions.ilike("f.nomeRazao", filtro.getNomeCliente(), MatchMode.ANYWHERE));
    }

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

---

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