Example usage for org.hibernate.criterion Restrictions and

Introduction

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

Prototype

public static LogicalExpression and(Criterion lhs, Criterion rhs)

Source Link

Document

Return the conjuction of two expressions

Usage

From source file:models.db.acentera.impl.ProjectImpl.java

License:Open Source License

public static ProjectProviders getProjectCloudProviderById(Long projectId, long providerId, User user) {
    Session s = (Session) HibernateSessionFactory.getSession();

    Criteria criteria = s.createCriteria(ProjectProviders.class);

    ProjectProviders provider = (ProjectProviders) criteria
            .add(Restrictions.and(Restrictions.eq("id", providerId), Restrictions.eq("project.id", projectId)))
            .uniqueResult();//from   w  ww  . ja v  a 2 s  . c  o m

    return provider;

}

From source file:models.db.acentera.impl.ProjectRegionsImpl.java

License:Open Source License

public static ProjectRegions getProjectRegionById(Long projectId, Long regionId) {

    Session session = (Session) HibernateSessionFactory.getSession();
    Criteria criteria = session.createCriteria(ProjectRegions.class);
    ProjectRegions g = (ProjectRegions) criteria
            .add(Restrictions.and(Restrictions.eq("project.id", projectId), Restrictions.eq("id", regionId)))
            .uniqueResult();/*from   w w w.  j  a va  2 s  .  c o  m*/

    return g;
}

From source file:models.db.acentera.impl.UserForgotKeysImpl.java

License:Open Source License

public static UserForgotKeys getByIdAndLock(String token, String newToken, String ip) {

    Session s = (Session) HibernateSessionFactory.getSession();
    Criteria criteria = s.createCriteria(UserForgotKeys.class);

    UserForgotKeys dbToken = null;/* ww w. j a  v a2 s .com*/

    String sqlWhere = "CREATED > DATE_SUB(curdate(), INTERVAL 1 DAY)";

    Logger.debug("gokenid : " + token + " new tokenid request " + newToken + " ip " + ip);
    try {
        //TODO Validate if DEV MODE... (H2 does not support DATE_SUB)
        //we fix this temporary by play.Play.isDev
        if (play.Play.isDev()) {
            dbToken = (UserForgotKeys) criteria
                    .add(Restrictions.and(Restrictions.eq("tokenid", token), Restrictions.eq("redeemed", 0)))
                    .uniqueResult();
        } else {
            dbToken = (UserForgotKeys) criteria.add(Restrictions.and(Restrictions.eq("tokenid", token),
                    Restrictions.eq("tokenid_request", null), Restrictions.eq("redeemed", 0),
                    Restrictions.sqlRestriction(sqlWhere))).uniqueResult();
        }
    } catch (Exception ee) {

        ee.printStackTrace();

    }
    Logger.debug("DB TOKEN IS : " + dbToken);
    if (dbToken != null) {
        dbToken.setTokenid_request(newToken);
        dbToken.setIp(ip);
        try {
            dbToken = saveOrUpdate(dbToken);
            return dbToken;
        } catch (DAOException e) {
            e.printStackTrace();
        }
    }

    //Couldn't get token
    return null;
}

From source file:mx.uabc.mxl.sistemas.persistencia.dao.NegocioDAO.java

public List<PlatilloDTO> getPlatillosByCategoria(NegocioDTO negocio, Categoria categoria) {

    List<PlatilloDTO> platillos;

    try {/*from   w  w  w  .  j a v a2s  .  c  o m*/
        HibernateUtil.openSession();
        HibernateUtil.beginTransaction();
        //Get all platillos of a negocio by categoria....
        platillos = HibernateUtil
                .getSession().createCriteria(PlatilloDTO.class).add(Restrictions
                        .and(Restrictions.eq("negocio", negocio), Restrictions.eq("categoria", categoria)))
                .list();

    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        platillos = null;
        System.out.println(e);
    } finally {
        HibernateUtil.closeSession();
    }

    return platillos;
}

From source file:mx.uabc.mxl.sistemas.persistencia.dao.OrdenDAO.java

public List<OrdenDTO> getOrdenesAlumno(UsuarioDTO alumno) {
    List<OrdenDTO> ordenes;

    try {//from w  w w .j  a v a 2s. c o m
        HibernateUtil.openSession();
        HibernateUtil.beginTransaction();

        //Get ordenes of alumno that are already placed.
        ordenes = HibernateUtil.getSession().createCriteria(OrdenDTO.class)
                .add(Restrictions.and(Restrictions.eq("alumno", alumno), Restrictions.eq("realizada", true)))
                .addOrder(Order.desc("fecha")).setFetchMode("platillosOrdenados", FetchMode.JOIN)
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();

    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        ordenes = null;
        System.out.println(e);
    } finally {
        HibernateUtil.closeSession();
    }

    return ordenes;
}

From source file:mx.uabc.mxl.sistemas.persistencia.dao.OrdenDAO.java

public List<PlatilloOrdenadoDTO> getPlatillosOrdenByNegocio(OrdenDTO orden, NegocioDTO negocio) {

    List<PlatilloOrdenadoDTO> platillos = null;

    try {//from   w  w w.  jav a2 s.  c  o m
        HibernateUtil.openSession();
        HibernateUtil.beginTransaction();

        //Get platillos of an order by negocio
        platillos = HibernateUtil.getSession().createCriteria(PlatilloOrdenadoDTO.class, "po")
                .createAlias("po.platillo.negocio", "negocio")
                .add(Restrictions.and(Restrictions.eq("po.orden", orden),
                        Restrictions.eq("negocio.nombre", negocio.getNombre())))
                .list();

    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        platillos = null;
        System.out.println(e);
    } finally {
        HibernateUtil.closeSession();
    }

    return platillos;
}

From source file:mx.uabc.mxl.sistemas.persistencia.dao.OrdenDAO.java

public List<OrdenDTO> getOrdenesByNegocio(NegocioDTO negocio) {

    List<OrdenDTO> ordenes = null;

    try {//from w  w  w .ja  v  a  2s. co  m
        HibernateUtil.openSession();
        HibernateUtil.beginTransaction();

        //Get platillos of an order by negocio
        ordenes = HibernateUtil.getSession().createCriteria(OrdenDTO.class, "orden")
                .createAlias("orden.platillosOrdenados", "platillos")
                .createAlias("platillos.platillo", "platillo")
                .add(Restrictions.and(Restrictions.eq("platillo.negocio", negocio),
                        Restrictions.eq("platillos.status", PlatilloOrdenadoDTO.Status.PREPARACION)))
                .setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();

        for (OrdenDTO orden : ordenes) {
            Hibernate.initialize(orden.getPlatillosOrdenados());
        }
    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        ordenes = null;
        System.out.println(e);
    } finally {
        HibernateUtil.closeSession();
    }

    return ordenes;
}

From source file:mx.uabc.mxl.sistemas.persistencia.dao.OrdenDAO.java

public PlatilloOrdenadoDTO getPlatilloOrdenado(OrdenDTO orden, PlatilloDTO platillo) {
    PlatilloOrdenadoDTO platilloOrdenado;

    try {//from   w  ww .  ja  va  2  s.  c o  m
        HibernateUtil.openSession();
        HibernateUtil.beginTransaction();

        //Get platillos of an order by negocio
        platilloOrdenado = (PlatilloOrdenadoDTO) HibernateUtil.getSession()
                .createCriteria(PlatilloOrdenadoDTO.class)
                .add(Restrictions.and(Restrictions.eq("orden", orden), Restrictions.eq("platillo", platillo)))
                .uniqueResult();

    } catch (Exception e) {
        HibernateUtil.rollbackTransaction();
        platilloOrdenado = null;
        System.out.println(e);
    } finally {
        HibernateUtil.closeSession();
    }

    return platilloOrdenado;
}

From source file:net.firejack.platform.core.store.AbstractStore.java

License:Apache License

@Override
public List<E> advancedSearchWithIdsFilter(List<List<SearchQuery>> searchQueries, Paging paging,
        SpecifiedIdsFilter filter) {//from   w w w.j a v a 2  s.c om
    LinkedList<Criterion> criterionList = new LinkedList<Criterion>();
    Map<String, String> aliases = new LinkedHashMap<String, String>();

    Criterion filterCriterion = createFilterCriterion(filter);

    if (searchQueries == null || searchQueries.isEmpty()) {
        criterionList.add(filterCriterion);
    } else {
        for (List<SearchQuery> queries : searchQueries) {
            Criterion criterion = parseAdvancedSearchRequest(queries, aliases, false);
            if (criterion == null && filterCriterion != null) {
                criterionList.add(filterCriterion);
            } else if (criterion != null) {
                criterionList.add(
                        filterCriterion == null ? criterion : Restrictions.and(filterCriterion, criterion));
            }
        }
    }

    if (paging != null) {
        List<SortField> sortFields = paging.getSortFields();
        for (SortField sortField : sortFields) {
            parseSorting(sortField, getClazz(), aliases);
        }
    }

    return search(criterionList, aliases, paging, true, true);
}

From source file:net.firejack.platform.core.store.AbstractStore.java

License:Apache License

@Override
public Integer advancedSearchCountWithIdsFilter(List<List<SearchQuery>> searchQueries,
        SpecifiedIdsFilter filter) {/*from   w  w  w  .  j  a  v a 2 s . co  m*/
    LinkedList<Criterion> criterionList = new LinkedList<Criterion>();
    Map<String, String> aliases = new LinkedHashMap<String, String>();

    Criterion filterCriterion = createFilterCriterion(filter);

    if (searchQueries == null || searchQueries.isEmpty()) {
        criterionList.add(filterCriterion);
    } else {
        for (List<SearchQuery> queries : searchQueries) {
            Criterion criterion = parseAdvancedSearchRequest(queries, aliases, false);
            if (criterion == null && filterCriterion != null) {
                criterionList.add(filterCriterion);
            } else if (criterion != null) {
                criterionList.add(
                        filterCriterion == null ? criterion : Restrictions.and(filterCriterion, criterion));
            }
        }
    }

    return searchCount(criterionList, aliases, true, true);
}