Example usage for org.hibernate.criterion Restrictions in

Introduction

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

Prototype

public static Criterion in(String propertyName, Collection values)

Source Link

Document

Apply an "in" constraint to the named property.

Usage

From source file:com.cmweb.orm.hibernate.SimpleHibernateDao.java

License:Apache License

public List<T> findByIds(List<PK> ids) {
    return find(Restrictions.in(getIdName(), ids));
}

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

License:Open Source License

private static Criterion convert(PropertyValueExpressionCriteria criteria) {
    Criterion criterion = null;// w w w.  ja  va 2s. c  om
    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.court.controller.AssignNewLoanFxmlController.java

private Set<Member> getAvailableGuarantors() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria c1 = session.createCriteria(MemberLoan.class);
    c1.setProjection(Projections.projectionList().add(Projections.property("isComplete"), "isComplete")
            .add(Projections.property("guarantors"), "guarantors")
            .add(Projections.property("member"), "member"));
    c1.setResultTransformer(Transformers.aliasToBean(MemberLoan.class));
    List<MemberLoan> ml = c1.list();
    //GET ALL GUARANTORS OF ONGOING LOANS
    List<String> guarantors = ml.stream().filter(p -> !p.isIsComplete())
            .map(m -> m.getGuarantors() + "-" + m.getMember().getMemberId()).collect(Collectors.toList());

    Set<String> lkm = new HashSet<>(guarantors);
    List<String> guarantor_filtered = lkm.stream().map(r -> r = r.split("-")[0]).collect(Collectors.toList());

    //GET ALREADY GUARANTED MEMBERS OF THE GARNTOR
    List<String> alreadyGurantedMembers = ml.stream().filter(p -> !p.isIsComplete())
            .filter(p -> p.getMember().getMemberId().equalsIgnoreCase(getMember().getMemberId()))
            .map(MemberLoan::getGuarantors).collect(Collectors.toList());

    //========================
    Set<Member> set = new HashSet<>();
    //========================

    //GET ALL MEMBERS EXCEPT THE LOAN GRANTOR
    Criteria c2 = session.createCriteria(Member.class);
    c2.add(Restrictions.ne("memberId", getMember().getMemberId()));
    c2.add(Restrictions.eq("status", true));
    c2.setProjection(Projections.projectionList().add(Projections.property("memberId"), "memberId")
            .add(Projections.property("fullName"), "fullName"));
    c2.setResultTransformer(Transformers.aliasToBean(Member.class));

    //IF NO GURANTORS FOUND THEN ALL MEMBERS CAN GUARANT FOR THE LOAN EXCEPT THE LOAN GRANTOR
    if (getUniqueGuarantors(guarantor_filtered, UNIQUE_GUR_FRQUENCY).isEmpty()) {
        List<Member> list = c2.list();
        set.addAll(list);//from w  ww  .java 2  s . com
        //
    } else {
        List<Member> list = c2.add(Restrictions
                .not(Restrictions.in("memberId", getUniqueGuarantors(guarantor_filtered, UNIQUE_GUR_FRQUENCY))))
                .list();
        set.addAll(list);
    }

    //IF NO GUARANTORS AVAILABLE THEY CAN GURANT THE GRANTOR ULTIMATELY UNTIL ALL GUARANTED LOANS END
    if (!alreadyGurantedMembers.isEmpty()) {
        Set<Member> arlm = getAlreadyGurantedMembers(alreadyGurantedMembers, session);
        set.addAll(arlm);
    }

    session.close();
    return set;
}

From source file:com.court.controller.AssignNewLoanFxmlController.java

private Set<Member> getAlreadyGurantedMembers(List<String> agm, Session s) {
    Set<String> ug = new HashSet<>();
    for (String string : agm) {
        Type type = new TypeToken<List<String>>() {
        }.getType();//  w ww . jav  a 2  s .c  om
        List<String> yourList = new Gson().fromJson(string, type);
        for (String yl : yourList) {
            ug.add(yl);
        }
    }
    Criteria cc2 = s.createCriteria(Member.class);
    cc2.add(Restrictions.in("memberId", ug));
    cc2.setProjection(Projections.projectionList().add(Projections.property("memberId"), "memberId")
            .add(Projections.property("fullName"), "fullName"));
    cc2.setResultTransformer(Transformers.aliasToBean(Member.class));
    List<Member> list = cc2.list();
    Set<Member> mbrs = new HashSet(list);
    return mbrs;
}

From source file:com.court.controller.GeneralSettingsFxmlController.java

private List<DocSequnce> getAllUpdatableFormatsAsList(List<String> keys) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria c = session.createCriteria(DocSequnce.class);
    c.add(Restrictions.not(Restrictions.in("tableName", keys)));
    List<DocSequnce> list = c.list();
    session.close();/*from   w  w  w . ja  v a  2  s .c o  m*/
    return list;
}

From source file:com.court.controller.MemberfxmlController.java

private List<Member> getSignedGuarantors(String guarantors, Session session) {
    List<String> lst = new Gson().fromJson(guarantors, new TypeToken<List<String>>() {
    }.getType());/* www  . j a  v  a 2s  .  c  o  m*/

    if (!lst.isEmpty()) {
        List<Member> grts = session.createCriteria(Member.class).add(Restrictions.in("memberId", lst)).list();

        return grts;
    }

    return null;

}

From source file:com.court.controller.MemberfxmlController.java

private List<Member> getSignedGuarantorsActive(String guarantors, Session session) {
    List<String> lst = new Gson().fromJson(guarantors, new TypeToken<List<String>>() {
    }.getType());//from  w w  w. j  a  va  2s. c  om
    List<Member> grts = session.createCriteria(Member.class).add(Restrictions.in("memberId", lst))
            .add(Restrictions.eq("status", true)).list();
    //   session.close();
    return grts;
}

From source file:com.court.controller.MemberfxmlController.java

private Double getTotalAmtOfLpIds(Session s, List<Integer> lpIds) {
    System.out.println("LPDS - " + lpIds);
    Criteria c = s.createCriteria(LoanPayment.class);
    List<LoanPayment> lpList = c.add(Restrictions.in("id", lpIds)).list();
    return lpList.stream().mapToDouble(LoanPayment::getPaidAmt).sum();
}

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 .  j a va 2s  .c o 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("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 ww  .  ja  v a  2 s.c  o m

    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();
}