Example usage for org.hibernate.criterion Restrictions isNotNull

List of usage examples for org.hibernate.criterion Restrictions isNotNull

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. isNotNull

Introduction

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

Prototype

public static Criterion isNotNull(String propertyName)

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

From source file:kltn.dao.ATMLocationDAO.java

public List<AtmLocation> listByName(String type, String name) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    List<AtmLocation> list = new ArrayList();
    Transaction tx = null;//from www . j a v a2  s  . c  o  m
    try {

        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(AtmLocation.class);
        cr.addOrder(Order.asc("id"));
        cr.add(Restrictions.isNotNull("latd"));
        if (type.equals("1")) {
            cr.add(Restrictions.eq("bank", name).ignoreCase());
            list = cr.list();
        } else if (type.equals("2")) {
            BankInfoDAO bankInfoDAO = new BankInfoDAO();
            List<String> banks = bankInfoDAO.findByGroup(name);
            if (banks == null || banks.isEmpty()) {
                //                    cr.add(Restrictions.eq("bank", ""));
                //                    list = cr.list();
                return list;
            }
            Disjunction dis = Restrictions.disjunction();
            for (String s : banks) {
                dis.add(Restrictions.eq("bank", s).ignoreCase());
            }
            cr.add(dis);
            list = cr.list();
        }

        tx.commit();
    } catch (HibernateException he) {
        if (tx != null && tx.isActive()) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return list;
}

From source file:kltn.dao.ATMLocationDAO.java

public List<AtmLocation> findByFullAddressAndDistrictNotNull() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    List<AtmLocation> list = null;
    Transaction tx = null;//from   ww w .  j  ava2 s. c  o m
    try {

        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(AtmLocation.class);
        cr.add(Restrictions.isNotNull("fulladdress"));
        cr.add(Restrictions.isNotNull("district"));
        cr.addOrder(Order.asc("id"));
        list = cr.list();
        tx.commit();
    } catch (HibernateException he) {
        if (tx != null && tx.isActive()) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return list;
}

From source file:kltn.dao.ATMLocationDAO.java

public List<AtmLocation> findByFullAddressNotnull() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    List<AtmLocation> list = null;
    Transaction tx = null;/*  ww  w  . j  a v a 2 s .  c  o m*/
    try {

        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(AtmLocation.class);
        cr.add(Restrictions.isNotNull("fulladdress"));
        cr.add(Restrictions.isNull("district"));
        cr.addOrder(Order.asc("id"));
        list = cr.list();
        tx.commit();
    } catch (HibernateException he) {
        if (tx != null && tx.isActive()) {
            tx.rollback();
        }
    } finally {
        session.close();
    }
    return list;
}

From source file:kltn.dao.ATMLocationDAO.java

public List<AtmLocation> filter(String keyword, String province, String district, String precinct,
        Character standardStatus, Character geocodingStatus, String bank) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    List<AtmLocation> list = null;
    Transaction tx = null;/*w ww .java  2 s. c om*/
    try {

        tx = session.beginTransaction();
        Criteria cr = session.createCriteria(AtmLocation.class);
        if (keyword != null && !keyword.trim().isEmpty()) {
            cr.add(Restrictions.like("fulladdress", "%" + keyword + "%").ignoreCase());
        }
        if (!province.isEmpty()) {
            cr.add(Restrictions.eq("provinceCity", province).ignoreCase());
        }
        if (!district.isEmpty()) {
            cr.add(Restrictions.eq("district", district).ignoreCase());
        }
        if (!precinct.isEmpty()) {
            cr.add(Restrictions.eq("precinct", precinct).ignoreCase());
        }
        if (standardStatus != null) {
            if (standardStatus == '0') {
                cr.add(Restrictions.isNull("standardlization"));
            } else {
                cr.add(Restrictions.eq("standardlization", standardStatus));
            }
        }
        if (geocodingStatus != null) {
            if (geocodingStatus == '0') {
                cr.add(Restrictions.isNull("latd"));
            } else if (geocodingStatus == '1') {
                cr.add(Restrictions.isNotNull("latd"));
            }
        }
        if (!bank.isEmpty()) {
            cr.add(Restrictions.eq("bank", bank).ignoreCase());
        }
        cr.addOrder(Order.asc("id"));
        list = cr.list();
        tx.commit();
    } catch (HibernateException he) {
        if (tx != null && tx.isActive()) {
            tx.rollback();
        }
    }
    return list;
}

From source file:marmar.ganaderia_fxml.hibernate.ConectorBovino.java

public ArrayList<Bovino> getBovinosFiltrados(String sexo, String estado, String arete, Raza raza, String edad,
        int meses) {

    ArrayList<Bovino> result = null;
    Session session = HibernateConector.factory.openSession();
    Transaction tx = null;/*from www  . j av a  2  s  .  co m*/
    try {
        tx = session.beginTransaction();

        Criteria cr = session.createCriteria(Bovino.class);

        //filtrar el sexo
        if (sexo.charAt(0) == 'A') {
        } else {
            Criterion c = Restrictions.ilike("sexo", sexo);
            cr.add(c);
        }

        //filtrar el estado del animal
        if (estado.equalsIgnoreCase("Todo Estado")) {
        } else if (estado.equalsIgnoreCase("Vendidas")) {
            Criterion fm = Restrictions.isNull("fecha_muerte");
            Criterion v = Restrictions.isNotNull("venta");
            cr.add(fm);
            cr.add(v);
        } else if (estado.equalsIgnoreCase("Muertas")) {
            Criterion fm = Restrictions.isNotNull("fecha_muerte");
            Criterion v = Restrictions.isNull("venta");
            cr.add(fm);
            cr.add(v);
        } else {
            //vivas
            Criterion fm = Restrictions.isNull("fecha_muerte");
            Criterion v = Restrictions.isNull("venta");
            cr.add(fm);
            cr.add(v);
        }

        //filtro para los aretes
        if (arete.equalsIgnoreCase("Todas")) {
        } else if (arete.equalsIgnoreCase("Con Arete")) {
            Criterion c = Restrictions.isNotNull("num_arete");
            cr.add(c);
        } else {
            Criterion c = Restrictions.isNull("num_arete");
            cr.add(c);
        }

        result = (ArrayList) cr.list();

        for (Bovino b : result) {
            Hibernate.initialize(b.getRaza());
            Hibernate.initialize(b.getVenta());
            Hibernate.initialize(b.getVacunas());
            b.getVacunas().size();
        }
        tx.commit();

    } catch (HibernateException he) {
        if (tx != null) {
            tx.rollback();
        }
        System.err.println(he.getMessage());
        he.printStackTrace();
    } finally {
        session.close();
    }

    if (result != null) {
        ArrayList<Bovino> filtrados = new ArrayList<>(result.size());
        if (edad.equalsIgnoreCase("Toda Edad")) {
            return result;
        } else if (edad.equalsIgnoreCase("Mayor o Igual Que")) {

            for (Bovino b : result) {
                if (b.getEdad() >= meses) {
                    filtrados.add(b);
                }
            }
        } else {
            for (Bovino b : result) {
                if (b.getEdad() <= meses) {
                    filtrados.add(b);
                }
            }

        }
        return filtrados;
    }
    return result;
}

From source file:me.repository.office.OfficeDao.java

License:Apache License

public Page<Office> findOffices(Page<Office> pageObj, Office office) {
    DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Office.class);
    if (!StringUtils.isBlank(office.getName())) {
        detachedCriteria.add(Restrictions.like("name", "%" + office.getName() + "%"));
    }//from  w w w. j av  a2 s .  co  m
    if (!StringUtils.isBlank(office.getOfficeCode())) {
        detachedCriteria.add(Restrictions.like("officeCode", "%" + office.getOfficeCode() + "%"));
    }
    detachedCriteria.add(Restrictions.isNotNull("parentId"));//   
    //      detachedCriteria.add(Restrictions.isNotNull("parent.id"));//   
    return find(pageObj, detachedCriteria);
}

From source file:mitm.common.hibernate.HibernateDatabaseCriterion.java

License:Open Source License

private Criterion createNOTNULLCriterion() {
    return Restrictions.isNotNull(property);
}

From source file:mitm.common.security.certstore.dao.X509CertStoreDAOHibernate.java

License:Open Source License

/**
 * Helper function that returns the number of records that searchField would return.
 *//* w  ww .ja v a2s.c  om*/
private int getSearchFieldCount(Field field, String search, Expired expired, MissingKeyAlias missingKeyAlias,
        Date date) {
    Criteria criteria = createCriteria(entityName);

    criteria.setProjection(Projections.rowCount());

    criteria.add(Restrictions.eq(getColumnName(Field.STORE_NAME), storeName));

    criteria.add(Restrictions.ilike(getColumnName(field), search));

    if (expired == Expired.NOT_ALLOWED) {
        criteria.add(Restrictions.lt(getColumnName(Field.NOT_BEFORE), date));
        criteria.add(Restrictions.gt(getColumnName(Field.NOT_AFTER), date));
    }

    if (missingKeyAlias == MissingKeyAlias.NOT_ALLOWED) {
        criteria.add(Restrictions.isNotNull(getColumnName(Field.KEY_ALIAS)));
    }

    return (Integer) criteria.uniqueResult();
}

From source file:mitm.common.security.certstore.dao.X509CertStoreDAOHibernate.java

License:Open Source License

@Override
public int getRowCount(Expired expired, MissingKeyAlias missingKeyAlias, Date date) {
    Criteria criteria = createCriteria(entityName);

    criteria.setProjection(Projections.rowCount());

    criteria.add(Restrictions.eq(getColumnName(Field.STORE_NAME), storeName));

    if (expired == Expired.NOT_ALLOWED) {
        criteria.add(Restrictions.lt(getColumnName(Field.NOT_BEFORE), date));
        criteria.add(Restrictions.gt(getColumnName(Field.NOT_AFTER), date));
    }/*w  w  w .j ava  2s  .co m*/

    if (missingKeyAlias == MissingKeyAlias.NOT_ALLOWED) {
        criteria.add(Restrictions.isNotNull(getColumnName(Field.KEY_ALIAS)));
    }

    return (Integer) criteria.uniqueResult();
}

From source file:mx.edu.um.mateo.activos.dao.impl.ActivoDaoHibernate.java

License:Open Source License

@Override
@Transactional(readOnly = true)/*from   w  ww .j  av a 2  s .co m*/
public Map<String, Object> lista(Map<String, Object> params) {
    log.debug("Buscando lista de activos con params {}", params);
    if (params == null) {
        params = new HashMap<>();
    }

    if (!params.containsKey("max")) {
        params.put("max", 10);
    } else {
        params.put("max", Math.min((Integer) params.get("max"), 100));
    }

    if (params.containsKey("pagina")) {
        Long pagina = (Long) params.get("pagina");
        Long offset = (pagina - 1) * (Integer) params.get("max");
        params.put("offset", offset.intValue());
    }

    if (!params.containsKey("offset")) {
        params.put("offset", 0);
    }
    Criteria criteria = currentSession().createCriteria(Activo.class);
    Criteria countCriteria = currentSession().createCriteria(Activo.class);

    criteria.createAlias("tipoActivo", "ta");
    countCriteria.createAlias("tipoActivo", "ta");

    if (params.containsKey("empresa")) {
        criteria.createCriteria("empresa").add(Restrictions.idEq(params.get("empresa")));
        countCriteria.createCriteria("empresa").add(Restrictions.idEq(params.get("empresa")));
    }

    if (params.containsKey("tipoActivoIds")) {
        criteria.add(Restrictions.in("ta.id", (List) params.get("tipoActivoIds")));
        countCriteria.add(Restrictions.in("ta.id", (List) params.get("tipoActivoIds")));
    }

    if (params.containsKey("cuentaId")) {
        criteria.createCriteria("centroCosto").add(Restrictions.eq("id.idCosto", params.get("cuentaId")));
        countCriteria.createCriteria("centroCosto").add(Restrictions.eq("id.idCosto", params.get("cuentaId")));
    }

    if (params.containsKey("proveedorId")) {
        criteria.createCriteria("proveedor").add(Restrictions.idEq(params.get("proveedorId")));
        countCriteria.createCriteria("proveedor").add(Restrictions.idEq(params.get("proveedorId")));
    }

    Date fechaIniciado = null;
    if (params.containsKey("fechaIniciado")) {
        fechaIniciado = (Date) params.get("fechaIniciado");
        criteria.add(Restrictions.ge("fechaCompra", fechaIniciado));
        countCriteria.add(Restrictions.ge("fechaCompra", fechaIniciado));
    }

    Date fechaTerminado = null;
    if (params.containsKey("fechaTerminado")) {
        Calendar cal = Calendar.getInstance();
        cal.setTime((Date) params.get("fechaTerminado"));
        cal.set(Calendar.HOUR_OF_DAY, 23);
        cal.set(Calendar.MINUTE, 59);
        cal.set(Calendar.SECOND, 59);
        cal.set(Calendar.MILLISECOND, 999);
        fechaTerminado = cal.getTime();
        criteria.add(Restrictions.le("fechaCompra", fechaTerminado));
        countCriteria.add(Restrictions.le("fechaCompra", fechaTerminado));
    }

    if (params.containsKey("bajas")) {
        if (fechaIniciado != null) {
            criteria.add(Restrictions.eq("inactivo", true));
            countCriteria.add(Restrictions.eq("inactivo", true));
            criteria.add(Restrictions.ge("fechaInactivo", fechaIniciado));
            countCriteria.add(Restrictions.ge("fechaInactivo", fechaIniciado));
            if (fechaTerminado != null) {
                criteria.add(Restrictions.le("fechaInactivo", fechaTerminado));
                countCriteria.add(Restrictions.le("fechaInactivo", fechaTerminado));
            }
        } else if (fechaTerminado != null) {
            criteria.add(Restrictions.eq("inactivo", true));
            countCriteria.add(Restrictions.eq("inactivo", true));
            criteria.add(Restrictions.le("fechaInactivo", fechaTerminado));
            countCriteria.add(Restrictions.le("fechaInactivo", fechaTerminado));
        } else {
            criteria.add(Restrictions.eq("inactivo", true));
            countCriteria.add(Restrictions.eq("inactivo", true));
        }
    } else {
        criteria.add(Restrictions.eq("inactivo", false));
        countCriteria.add(Restrictions.eq("inactivo", false));
    }

    if (params.containsKey("reubicaciones")) {
        if (fechaIniciado != null) {
            criteria.add(Restrictions.isNotNull("fechaReubicado"));
            countCriteria.add(Restrictions.isNotNull("fechaReubicado"));
            criteria.add(Restrictions.ge("fechaReubicado", fechaIniciado));
            countCriteria.add(Restrictions.ge("fechaReubicado", fechaIniciado));
            if (fechaTerminado != null) {
                criteria.add(Restrictions.le("fechaReubicado", fechaIniciado));
                countCriteria.add(Restrictions.le("fechaReubicado", fechaIniciado));
            }
        } else if (fechaTerminado != null) {
            criteria.add(Restrictions.isNotNull("fechaReubicado"));
            countCriteria.add(Restrictions.isNotNull("fechaReubicado"));
            criteria.add(Restrictions.le("fechaReubicado", fechaIniciado));
            countCriteria.add(Restrictions.le("fechaReubicado", fechaIniciado));
        } else {
            criteria.add(Restrictions.isNotNull("fechaReubicado"));
            countCriteria.add(Restrictions.isNotNull("fechaReubicado"));
        }
    }

    if (params.containsKey("responsableNombre")) {
        criteria.add(Restrictions.ilike("responsable", (String) params.get("responsable"), MatchMode.ANYWHERE));
        countCriteria
                .add(Restrictions.ilike("responsable", (String) params.get("responsable"), MatchMode.ANYWHERE));
    }

    if (params.containsKey("filtro")) {
        String filtro = (String) params.get("filtro");
        Disjunction propiedades = Restrictions.disjunction();
        propiedades.add(Restrictions.ilike("folio", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("procedencia", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("factura", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("pedimento", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("poliza", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("codigo", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("descripcion", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("marca", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("modelo", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("ubicacion", filtro, MatchMode.ANYWHERE));
        propiedades.add(Restrictions.ilike("responsable", filtro, MatchMode.ANYWHERE));
        criteria.add(propiedades);
        countCriteria.add(propiedades);
    }

    if (params.containsKey("order")) {
        criteria.addOrder(Order.asc("ta.cuenta.id.idCtaMayor"));
        String campo = (String) params.get("order");
        if (params.get("sort").equals("desc")) {
            criteria.addOrder(Order.desc(campo));
        } else {
            criteria.addOrder(Order.asc(campo));
        }
    } else {
        criteria.addOrder(Order.asc("ta.cuenta.id.idCtaMayor"));
        criteria.addOrder(Order.desc("folio"));
    }

    if (!params.containsKey("reporte")) {
        criteria.setFirstResult((Integer) params.get("offset"));
        criteria.setMaxResults((Integer) params.get("max"));
    }
    params.put("activos", criteria.list());

    countCriteria.setProjection(Projections.rowCount());
    params.put("cantidad", (Long) countCriteria.list().get(0));

    ProjectionList list = Projections.projectionList();
    list.add(Projections.sum("depreciacionAnual"), "depreciacionAnual");
    list.add(Projections.sum("depreciacionMensual"), "depreciacionMensual");
    list.add(Projections.sum("depreciacionAcumulada"), "depreciacionAcumulada");
    list.add(Projections.sum("moi"), "moi");
    list.add(Projections.groupProperty("fechaDepreciacion"), "fechaDepreciacion");
    countCriteria.setProjection(list);

    List<?> proyecciones = countCriteria.list();
    Iterator<?> iterator = proyecciones.iterator();
    if (iterator.hasNext()) {
        Object[] obj = (Object[]) iterator.next();
        NumberFormat nf = DecimalFormat.getInstance();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
        Date fecha;
        if (obj[4] != null) {
            fecha = (Date) obj[4];
        } else {
            fecha = new Date();
        }
        params.put("resumen", new String[] { nf.format(obj[0]), nf.format(obj[1]), nf.format(obj[2]),
                nf.format(obj[3]), sdf.format(fecha) });
    }

    return params;
}