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:cn.dayuanzi.dao.BaseDao.java

License:Apache License

/**
 * id?.
 */
public List<T> get(final Collection<PK> ids) {
    return find(Restrictions.in(getIdName(), ids));
}

---

From source file:cn.hxh.springside.orm.hibernate.SimpleHibernateDao.java

License:Apache License

/**
 * id?.
 */
public List<T> get(final Collection<ID> ids) {
    return find(Restrictions.in(getIdName(), ids));
}

---

From source file:cn.trymore.core.dao.impl.DAOGenericImpl.java

License:Open Source License

public PaginationSupport<T> queryFieldsListForPaging(final Class<?> objectClass,
        Map<String, List<Object>> params, int pageSize, int startIndex) throws DAOException {

    DetachedCriteria criteria = DetachedCriteria.forClass(objectClass);

    if (params != null && params.size() > 0) {
        for (Map.Entry<String, List<Object>> entry : params.entrySet()) {
            String keyName = entry.getKey();
            List<Object> keyValues = entry.getValue();
            criteria.add(Restrictions.in(keyName, keyValues));
        }//from www .j  a  v  a  2 s.c o  m
    }

    return findPageByCriteria(criteria, pageSize, startIndex);
}

---

From source file:co.com.codesoftware.logic.ParametrosLogic.java

/**
 * metodo que consulta los parametros de correo de envio
 *
 * @return//from  ww  w.jav  a2  s  .c  o  m
 */
public List<ParametrosEntity> consultaParametrosCorreoEnvio() {
    List<ParametrosEntity> rta = null;
    try {
        Object[] datos = { "CORREOENVIO", "CLAVECORRENV", "PUERTOENV", "SERVSMTP" };
        initOperation();
        Criteria crit = sesion.createCriteria(ParametrosEntity.class);
        crit.add(Restrictions.in("clave", datos));
        rta = crit.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return rta;

}

---

From source file:co.com.codesoftware.logic.SubCuentaLogic.java

/**
 * metodo en el cual se consulta las subcuentas mediante unos filtros y el campo en especifico
 * @param nombreFiltro: campo con el cual se desea filtrar
 * @param datos: datos de tipo Entero//from ww w  .  j  av a 2 s  .  co  m
 * @return lista de tipo subcuenta
 */
public List<SubCuentaEntity> consultaSubCuentaFiltros(ArrayList<PucEntity> datos) {
    List<SubCuentaEntity> resultado = new ArrayList<>();
    try {
        initOperation();
        Criteria crit = sesion.createCriteria(SubCuentaEntity.class);
        for (PucEntity item : datos) {
            crit.add(Restrictions.in(item.getClave(), item.getValor()));
        }
        resultado = crit.list();

    } catch (Exception e) {
        e.printStackTrace();
    }
    return resultado;
}

---

From source file:co.com.codesoftware.logica.facturacion.FacturacionLogica.java

/**
 * metodo que consulta las facturas por fecha y por sede
 *
 * @param fechaInicial/*from   w w  w  .  j av  a  2 s  .  co  m*/
 * @param fechaFinal
 * @param sede
 * @param estado
 * @return
 */
public List<FacturaEntity> obtieneFacturasXSede(Date fechaInicial, Date fechaFinal, Integer sede,
        String estado) {
    List<FacturaEntity> rta = null;
    try {
        initOperation();
        Criteria crit = this.sesion.createCriteria(FacturaEntity.class);
        crit.setFetchMode("idSede", FetchMode.JOIN).setFetchMode("cliente", FetchMode.JOIN)
                .createAlias("idSede", "sed").add(Restrictions.eq("sed.id", sede))
                .add(Restrictions.between("fecha", fechaInicial, fechaFinal)).addOrder(Order.desc("id"));
        if (estado == null) {
            estado = "";
        }
        if (!"".equalsIgnoreCase(estado.trim())) {
            if ("R".equalsIgnoreCase(estado.trim())) {
                crit.add(Restrictions.sqlRestriction("fact_fact in (select remi_fact from in_tremi)"));
            } else if ("PC".equalsIgnoreCase(estado.trim())) {
                String[] valores = new String[] { "S", "A", "R" };
                crit.add(Restrictions.in("estado", valores));
            } else if ("P".equalsIgnoreCase(estado.trim())) {
                crit.add(Restrictions.eq("estado", estado.trim()));
            } else if ("C".equalsIgnoreCase(estado.trim())) {
                crit.add(Restrictions.eq("estado", estado.trim()));
            }
        }
        rta = crit.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return rta;

}

---

From source file:co.com.codesoftware.logica.facturacion.FacturacionLogica.java

/**
 * Funcion con la cual obtengo facturas por medio de una serie de filtros
 *
 * @param fechaInicial/*from w  w  w.j ava 2 s  . c o m*/
 * @param fechaFinal
 * @param idFactura
 * @param idCliente
 * @param codExterno
 * @return
 */
public List<FacturaEntity> obtieneFacturasXFiltros(Date fechaInicial, Date fechaFinal, Integer idFactura,
        Integer idCliente, String codExterno) {
    List<FacturaEntity> facturas = null;
    try {
        this.initOperation();
        Criteria crit = sesion.createCriteria(FacturaEntity.class);
        crit.setFetchMode("idSede", FetchMode.JOIN);
        crit.setFetchMode("cliente", FetchMode.JOIN);
        //Numero desde el cual se inicio la facturacion
        Integer iniFact = this.buscaConcecutivoFactura();
        if (idFactura == null) {
            idFactura = 0;
        }
        //idFactura = idFactura - iniFact;
        if (idFactura > 0) {
            crit.add(Restrictions.eq("id", idFactura));
        } else {
            if (idCliente != null && idCliente > 0) {
                crit.createAlias("cliente", "cli");
                crit.add(Restrictions.eq("cli.id", idCliente));
            }
            if (codExterno != null && !"".equalsIgnoreCase(codExterno)) {
                Integer idProducto = this.buscaIdProductoXCodigoExterno(codExterno);
                if (idProducto != null && idProducto != 0) {
                    ArrayList<Integer> idFacturas = this.obtieneFacturasXCodigoProducto(idProducto);
                    if (idFacturas != null) {
                        crit.add(Restrictions.in("id", idFacturas));
                    }
                }
            }
            if (fechaInicial != null && fechaFinal != null) {
                fechaFinal.setHours(23);
                fechaFinal.setMinutes(59);
                fechaFinal.setSeconds(59);
                crit.add(Restrictions.between("fecha", fechaInicial, fechaFinal));
            }
        }
        crit.addOrder(Order.desc("id"));
        facturas = crit.list();
    } catch (Exception e) {
        e.printStackTrace();
    }
    return facturas;
}

---

From source file:co.id.pegadaian.pasg2.util.SusunTree.java

public void susunTree(Session session, BigInteger parentId, String jarak, Set<BigDecimal> menuIdSet) {
    /*menu by user */

    String j = jarak;/*w w w .  jav a2s. c  om*/
    jarak = j + "   ";
    Criteria criteria = session.createCriteria(TblMenu.class);
    criteria.add(Restrictions.eq("parentId", new BigDecimal(parentId)));
    criteria.add(Restrictions.in("menuId", l));
    criteria.addOrder(Order.asc("noUrut"));
    List<TblMenu> list = criteria.list();
    PriviledgeCek pv = new PriviledgeCek();
    for (TblMenu tblmenu : list) {
        //juka punya child
        if (tblmenu.getHaveChild() == '0') {
            //tambahkan parameter menu_id
            //               prililedge
            pv.cekPriveldge(user, (tblmenu.getMenuId() + ""));//, isAdd, isEdit, isDelete, isView);
            String priv = "&isAdd=" + pv.getIsAdd() + "&isEdit=" + pv.getIsEdit() + "&isDelete="
                    + pv.getIsDelete() + "&isView=" + pv.getIsView();
            sb.append(
                    jarak + "<li " + "onclick=" + '"' + "window.open(" + "'" + tblmenu.getMenuPage() + "?param="
                            + tblmenu.getMenuId() + priv + "'" + "," + "'" + "MAIN" + "'" + ")" + '"' + ">");
            sb.append(tblmenu.getMenuName());
            SusunTree susunTree = new SusunTree();
            susunTree(session, BigInteger.valueOf(tblmenu.getMenuId().longValue()), jarak, l);
        } else {
            sb.append(jarak + "<li>");
            sb.append(tblmenu.getMenuName());
            sb.append("\r\n" + jarak + "<ul>\r\n");
            SusunTree susunTree = new SusunTree();
            susunTree(session, BigInteger.valueOf(tblmenu.getMenuId().longValue()), jarak, l);
            sb.append(jarak + "</ul>\r\n");
        }
        sb.append("</li>\r\n");
    }
}

---

From source file:co.id.pegadaian.pasg2.util.SusunTree.java

public Set<BigDecimal> listMenuByUser(Session session, String userId) {

    /* Ambil gropu by user */
    Criteria critGroup = session.createCriteria(TblUserGroup.class);
    critGroup.add(Restrictions.eq("id.userId", userId));
    critGroup.setProjection(Projections.projectionList().add(Projections.property("id.groupId")));//"id.groupId"
    List<BigDecimal> l = critGroup.list();
    if (l.size() > 0) {
        //        for(BigDecimal x :l){System.out.println(x);        }
        /*Menu berdasarkan Priviledge */
        Criteria c = session.createCriteria(TblPriviledge.class);
        c.add(Restrictions.in("id.groupId", l));
        c.setProjection(Projections.projectionList().add(Projections.property("id.menuId")));
        Set<BigDecimal> lMenuId = new HashSet();
        List<BigDecimal> k = c.list();
        for (BigDecimal x : k) {
            lMenuId.add(x);//new BigDecimal(x));
            //            System.out.println(x.getid().getMenuId());
            //                  System.out.println(k);
        }//from  w  ww .  j  a va2s . c  o  m
        return lMenuId;
    } else {
        return null;
    }

}

---

From source file:co.id.pegadaian.pasg2.util.SusunTreeJeasyUI.java

public void susunTree(Session session, BigInteger parentId, String jarak, Set<BigDecimal> menuIdSet) {
    /*menu by user */
    String j = jarak;//from w w w. j  a  v  a  2s.  c om
    jarak = j + "   ";
    Criteria criteria = session.createCriteria(TblMenu.class);
    criteria.add(Restrictions.eq("parentId", new BigDecimal(parentId)));
    criteria.add(Restrictions.in("menuId", l));
    criteria.addOrder(Order.asc("noUrut"));
    List<TblMenu> list = criteria.list();
    for (TblMenu tblmenu : list) {
        //juka punya child
        PriviledgeCek pv = new PriviledgeCek();
        pv.cekPriveldge(user, (tblmenu.getMenuId() + ""));//, isAdd, isEdit, isDelete, isView);
        String Enc = crypto.encrypt(tblmenu.getMenuId() + "");
        //String x ="isAdd="+crypto.encrypt(pv.getIsAdd())+"isEdit="+crypto.encrypt(pv.getIsEdit())+"isDelete="+crypto.encrypt(pv.getIsDelete())+"isView="+crypto.encrypt(pv.getIsView());
        String x = "&isAdd=" + (pv.getIsAdd()) + "&isEdit=" + (pv.getIsEdit()) + "&isDelete="
                + (pv.getIsDelete()) + "&isView=" + (pv.getIsView());

        String priv = crypto.encrypt(x);
        String dec = "";// crypto.decrypt(priv);
        String usrEnc = crypto.encrypt(this.user);

        if (tblmenu.getHaveChild() == '0') {
            //tambahkan parameter menu_id//               prililedge
            sb.append(jarak + "<li" + " id='" + tblmenu.getMenuPage() + "?param=" + priv + "&" + "param2="
                    + this.sKey + "&UID=" + /*this.user*/usrEnc + "'" + ">");
            x = null;
            sb.append(tblmenu.getMenuName() + " (" + tblmenu.getMenuId() + ")");//===TAMBAHHIN MENU ID
            SusunTreeJeasyUI susunTree = new SusunTreeJeasyUI();
            susunTree(session, BigInteger.valueOf(tblmenu.getMenuId().longValue()), jarak, l);
        } else {
            sb.append(jarak + "<li " + " id='" + "utamaMain.htm" + "?param=" + priv + "&" + "param2="
                    + this.sKey + "&UID=" + /*this.user*/usrEnc + "'" + "><span>");
            sb.append(tblmenu.getMenuName() + " (" + tblmenu.getMenuId() + ")" + "</span>");//===TAMBAHHIN MENU ID
            sb.append("\r\n" + jarak + "<ul" + " id='" + "utamaMain.htm" + "?param=" + priv + "&" + "param2="
                    + this.sKey + "&UID=" + /*this.user*/usrEnc + "'" + ">\r\n");
            SusunTreeJeasyUI susunTree = new SusunTreeJeasyUI();
            susunTree(session, BigInteger.valueOf(tblmenu.getMenuId().longValue()), jarak, l);
            sb.append(jarak + "</ul>\r\n");
        }
        sb.append("</li>\r\n");
    }
}

---

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