Example usage for org.hibernate.criterion Restrictions eq

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

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

Introduction

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

Prototype

public static SimpleExpression eq(String propertyName, Object value)

Source Link

Document

Apply an "equal" constraint to the named property

Usage

From source file:apm.modules.sys.service.RoleService.java

License:Open Source License

public List<Role> findAllRole() {
    //1.??5?//  w  ww . j a v a2 s .c  o m
    List<Role> rs = dao.findDefineRoles();

    //2.?
    User user = Users.currentUser();
    DetachedCriteria dc = dao.createDetachedCriteria();
    dc.createAlias("office", "office");
    dc.createAlias("userList", "userList", JoinType.LEFT_OUTER_JOIN);
    dc.add(dataScopeFilter(user, "office", "userList")); //??????
    dc.add(Restrictions.eq(Role.DEL_FLAG, Role.DEL_FLAG_NORMAL));
    dc.addOrder(Order.asc("office.code")).addOrder(Order.asc("name"));

    List<Role> rs2 = dao.find(dc);
    for (int i = 0; i < rs2.size(); i++) { //??
        Role r = rs2.get(i);
        if (!rs.contains(r)) {
            rs.add(r);
        }
    }
    return rs;
}

From source file:apm.modules.sys.service.UserService.java

License:Open Source License

public Page<User> findUser(Page<User> page, User user) {
    DetachedCriteria dc = dao.createDetachedCriteria();
    User currentUser = Users.currentUser();
    dc.createAlias("company", "company");

    if (user.getCompany() != null && StringUtils.isNotEmpty(user.getCompany().getId())) {
        dc.add(Restrictions.or(Restrictions.eq("company.id", user.getCompany().getId()), //?
                Restrictions.like("company.parentIds", "%," + user.getCompany().getId() + ",%") //??
        ));/* w  w w .j ava 2  s . c o m*/
    } else {
        dc.add(Restrictions.or(Restrictions.eq("company.id", currentUser.getCompany().getId()), //?
                Restrictions.like("company.parentIds", "%," + currentUser.getCompany().getId() + ",%") //??
        ));
    }
    /*dc.createAlias("office", "office");
    if (user.getOffice()!=null && StringUtils.isNotEmpty(user.getOffice().getId())){
       dc.add(Restrictions.or(                                                   
       Restrictions.eq("office.id", user.getOffice().getId()),                     //
       Restrictions.like("office.parentIds", "%,"+user.getOffice().getId()+",%")      //?
       ));
    }else{
       dc.add(Restrictions.or(                                                   
       Restrictions.eq("office.id", currentUser.getOffice().getId()),                     //
       Restrictions.like("office.parentIds", "%,"+currentUser.getOffice().getId()+",%")      //?
       ));
    }*/
    // ????
    if (!currentUser.isAdmin()) {
        dc.add(Restrictions.ne("id", "1"));
    }
    /*if(user.getOffice() != null && StringUtils.isNotBlank(user.getOffice().getId())){
    dc.add(dataScopeFilter(currentUser, "office", ""));
    }*/
    /*dc.add(dataScopeFilter(currentUser, "office", ""));*/

    //System.out.println(dataScopeFilterString(currentUser, "office", ""));
    if (StringUtils.isNotEmpty(user.getLoginName())) {
        dc.add(Restrictions.like("loginName", "%" + user.getLoginName() + "%"));
    }
    if (StringUtils.isNotEmpty(user.getName())) {
        dc.add(Restrictions.like("name", "%" + user.getName() + "%"));
    }
    dc.add(Restrictions.eq(User.DEL_FLAG, User.DEL_FLAG_NORMAL));
    if (!StringUtils.isNotEmpty(page.getOrderBy())) {
        /*dc.addOrder(Order.asc("company.code")).addOrder(Order.asc("office.code")).addOrder(Order.desc("id"));*/
        dc.addOrder(Order.asc("company.code")).addOrder(Order.desc("id"));
    }
    return dao.find(page, dc);
}

From source file:ar.com.zauber.commons.repository.query.visitor.CriteriaFilterVisitor.java

License:Apache License

/** calculate a criterion */
private Criterion createCriterion(final BinaryPropertyFilter binaryPropertyFilter, final Object value) {
    final String fieldName = getFieldName(binaryPropertyFilter.getProperty());
    final Criterion ret;

    if (binaryPropertyFilter instanceof EqualsPropertyFilter) {
        ret = Restrictions.eq(fieldName, value);
    } else if (binaryPropertyFilter instanceof LessThanPropertyFilter) {
        ret = Restrictions.lt(fieldName, value);
    } else if (binaryPropertyFilter instanceof LessThanEqualsPropertyFilter) {
        ret = Restrictions.le(fieldName, value);
    } else if (binaryPropertyFilter instanceof GreaterThanPropertyFilter) {
        ret = Restrictions.gt(fieldName, value);
    } else if (binaryPropertyFilter instanceof GreaterThanEqualsPropertyFilter) {
        ret = Restrictions.ge(fieldName, value);
    } else if (binaryPropertyFilter instanceof LikePropertyFilter) {
        if (((LikePropertyFilter) binaryPropertyFilter).getCaseSensitive()) {
            ret = Restrictions.like(fieldName, value);
        } else {//ww  w .  ja v a 2s . c om
            ret = Restrictions.ilike(fieldName, value);
        }
    } else {
        throw new IllegalStateException("Unable to process filter" + binaryPropertyFilter);
    }

    return ret;
}

From source file:ar.edu.unju.fi.apu.dao.imp.mysql.PacienteDAOImp.java

@Override
public Paciente obtenerPaciente(int numHC) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(Paciente.class);
    criteria.add(Restrictions.eq("numHC", numHC));
    Paciente paciente = (Paciente) criteria.list().get(0);
    return paciente;
}

From source file:ar.edu.unju.fi.apu.dao.imp.mysql.PropietarioDAOImp.java

@Override
public List<Propietario> obtenerTodos() {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(Propietario.class);
    criteria.add(Restrictions.eq("estado", true));
    criteria.addOrder(Order.asc("apellido"));
    List propietarios = criteria.list();
    return propietarios;
}

From source file:ar.edu.unju.fi.apu.dao.imp.mysql.UsuarioDAOImp.java

@Override
public Usuario validarUsuario(String nombreUsuario, String password) {
    Usuario usuario = null;/*from  w  w w  .ja va 2 s  .  c  o  m*/
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(Usuario.class);
    criteria.add(Restrictions.eq("nombreUsuario", nombreUsuario));//filtro por exactitud
    //        criteria.add(Restrictions.like("nombreUsuario", password, MatchMode.EXACT)); filtro por aporcciomacion
    criteria.add(Restrictions.eq("password", password));
    criteria.add(Restrictions.eq("estado", true));
    if (!criteria.list().isEmpty()) {
        usuario = (Usuario) criteria.list().get(0);
    }
    return usuario;
}

From source file:ar.edu.unju.fi.apu.dao.imp.mysql.UsuarioDAOImp.java

@Override
public Usuario obtenerUsuario(String nombreUsuario) {
    Usuario usuario = null;//from   ww w . j a  v  a  2  s . co m
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(Usuario.class);
    criteria.add(Restrictions.eq("nombreUsuario", nombreUsuario));
    if (!criteria.list().isEmpty()) {
        usuario = (Usuario) criteria.list().get(0);
    }
    return usuario;
}

From source file:ar.edu.unju.fi.apu.dao.impl.EncabezadoFacturaDAOImpl.java

@Override
public EncabezadoFactura obtenerEncabezadoFactura(String codigo) {
    EncabezadoFactura encabezadoFactura = null;
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(EncabezadoFactura.class);
    criteria.add(Restrictions.eq("codigo", codigo));
    if (!criteria.list().isEmpty()) {
        encabezadoFactura = (EncabezadoFactura) criteria.list().get(0);
    }/*from  ww w .  ja  v  a 2  s  . c om*/
    return encabezadoFactura;
}

From source file:ar.edu.unju.fi.apu.dao.impl.FacturaDetalleDAOImpl.java

@Override
public List<FacturaDetalle> obtenerDetalles(EncabezadoFactura factura) {
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(FacturaDetalle.class);

    criteria.add(Restrictions.eq("encabezadoFacturas", factura));

    return criteria.list();
}

From source file:ar.edu.unju.fi.apu.dao.impl.ProductoDAOImpl.java

@Override
public Producto obtenerProducto(String nombre) {
    Producto producto = null;/*from   w  w w . j  av a2s  . c o m*/
    Session session = HibernateUtil.getSessionFactory().openSession();
    Criteria criteria = session.createCriteria(Producto.class);
    criteria.add(Restrictions.eq("nombre", nombre));

    if (!criteria.list().isEmpty()) {
        producto = (Producto) criteria.list().get(0);
        session.close();
    }
    return producto;
}