Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria add.

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:com.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List getTop() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class);
    dc.addOrder(Order.asc("idInventario"));

    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);//from  w w w  . ja  v  a 2 s .  c  om
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fechaInsert", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List LastCodInventario(Serializable id) {
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class, "inv");
    dc.createAlias("inv.tbcClaseActivo", "clase");
    dc.add(Restrictions.eq("clase.idClaseActivo", id));
    dc.addOrder(Order.desc("idInventario"));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_InventarioDaoImpl.java

@Override
public List findBycodigo(String code) {
    DetachedCriteria dc = DetachedCriteria.forClass(TbInventario.class, "inv");
    //dc.createAlias("inv.tbcClaseActivo", "clase");
    dc.add(Restrictions.eq("inv.codigoInventario", code));
    //dc.addOrder(Order.desc("idInventario"));
    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_MovimientoDaoImp.java

@Override
public List getTop() {
    // TODO Auto-generated method stub
    DetachedCriteria dc = DetachedCriteria.forClass(TbMovimiento.class, "movimiento");
    //dc.setFetchMode("TbrMovimientoInventario", FetchMode.JOIN);

    Date fecha_finalHoy = new Date();
    Date fecha_inicial = new Date();

    //restar dias a la fecha
    Calendar calendar = Calendar.getInstance();
    calendar.setTime(fecha_finalHoy);/*w w w  .  j a va 2 s . c  o m*/
    calendar.add(Calendar.DAY_OF_YEAR, -7); // numero de das a aadir, o restar en caso de das<0
    fecha_inicial = calendar.getTime();

    dc.add(Restrictions.between("fechaMovimiento", fecha_inicial, fecha_finalHoy));
    System.out.println("fecha inicial:" + fecha_inicial + "fecha final:" + fecha_finalHoy);

    // dc.add(Restrictions.ge("fechaMovimiento", highestDate));
    // dc.add(Restrictions.lt("fechaMovimiento", highestDate));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();

}

From source file:com.isdemu.dao.impl.TB_MovimientoDaoImp.java

@Override
public List getMovInv(Serializable id) {

    DetachedCriteria dc = DetachedCriteria.forClass(TbrMovimientoInventario.class, "movimientoInventario");

    dc.createAlias("movimientoInventario.tbMovimiento", "movi");
    dc.add(Restrictions.eq("movi.idMovimiento", id));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();

}

From source file:com.isdemu.dao.impl.TB_Ubicacion_PersonaDaoImpl.java

@Override
public List getAllidUbicacion(Serializable id) {

    DetachedCriteria dc = DetachedCriteria.forClass(TbUbicacionPersona.class, "ubicacionpersona");

    dc.createAlias("ubicacionpersona.tbcUbicacion", "ubicacion");
    dc.add(Restrictions.eq("ubicacion.idUbicacion", id));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.isdemu.dao.impl.TB_Ubicacion_PersonaDaoImpl.java

@Override
public List getAllidPersona(Serializable id) {

    DetachedCriteria dc = DetachedCriteria.forClass(TbUbicacionPersona.class, "ubicacionpersona");

    dc.createAlias("ubicacionpersona.tbcPersona", "persona");
    dc.add(Restrictions.eq("persona.idPersona", id));

    return dc.getExecutableCriteria(sessionFactory.getCurrentSession()).list();
}

From source file:com.itrus.ca.modules.cms.service.ArticleService.java

License:Open Source License

public Page<Article> find(Page<Article> page, Article article, boolean isDataScopeFilter) {
    // ??6??/*from   www. j a v  a2s . c  om*/
    Date updateExpiredWeightDate = (Date) CacheUtils.get("updateExpiredWeightDateByArticle");
    if (updateExpiredWeightDate == null
            || (updateExpiredWeightDate != null && updateExpiredWeightDate.getTime() < new Date().getTime())) {
        articleDao.updateExpiredWeight();
        CacheUtils.put("updateExpiredWeightDateByArticle", DateUtils.addHours(new Date(), 6));
    }
    DetachedCriteria dc = articleDao.createDetachedCriteria();
    dc.createAlias("category", "category");
    dc.createAlias("category.site", "category.site");
    if (article.getCategory() != null && article.getCategory().getId() != null
            && !Category.isRoot(article.getCategory().getId())) {
        Category category = categoryDao.findOne(article.getCategory().getId());
        if (category != null) {
            dc.add(Restrictions.or(Restrictions.eq("category.id", category.getId()),
                    Restrictions.like("category.parentIds", "%," + category.getId() + ",%")));
            dc.add(Restrictions.eq("category.site.id", category.getSite().getId()));
            article.setCategory(category);
        } else {
            dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
        }
    } else {
        dc.add(Restrictions.eq("category.site.id", Site.getCurrentSiteId()));
    }
    if (StringUtils.isNotEmpty(article.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(article.getTitle()) + "%"));
    }
    if (StringUtils.isNotEmpty(article.getPosid())) {
        dc.add(Restrictions.like("posid", "%," + article.getPosid() + ",%"));
    }
    if (StringUtils.isNotEmpty(article.getImage()) && Article.YES.equals(article.getImage())) {
        dc.add(Restrictions.and(Restrictions.isNotNull("image"), Restrictions.ne("image", "")));
    }
    if (article.getCreateBy() != null && article.getCreateBy().getId() > 0) {
        dc.add(Restrictions.eq("createBy.id", article.getCreateBy().getId()));
    }
    if (isDataScopeFilter) {
        dc.createAlias("category.office", "categoryOffice").createAlias("createBy", "createBy");
        dc.add(dataScopeFilter(UserUtils.getUser(), "categoryOffice", "createBy"));
    }
    dc.add(Restrictions.eq(Article.DEL_FLAG, article.getDelFlag()));
    if (StringUtils.isBlank(page.getOrderBy())) {
        dc.addOrder(Order.desc("weight"));
        dc.addOrder(Order.desc("updateDate"));
    }
    return articleDao.find(page, dc);
}

From source file:com.itrus.ca.modules.cms.service.CommentService.java

License:Open Source License

public Page<Comment> find(Page<Comment> page, Comment comment) {
    DetachedCriteria dc = commentDao.createDetachedCriteria();
    if (comment.getContentId() != null && comment.getContentId() > 0) {
        dc.add(Restrictions.eq("contentId", comment.getContentId()));
    }//ww w. ja va 2 s.  co  m
    if (StringUtils.isNotEmpty(comment.getTitle())) {
        dc.add(Restrictions.like("title", "%" + EscapeUtil.escapeLike(comment.getTitle()) + "%"));
    }
    dc.add(Restrictions.eq(Comment.DEL_FLAG, comment.getDelFlag()));
    dc.addOrder(Order.desc("id"));
    return commentDao.find(page, dc);
}

From source file:com.itrus.ca.modules.cms.service.GuestbookService.java

License:Open Source License

public Page<Guestbook> find(Page<Guestbook> page, Guestbook guestbook) {
    DetachedCriteria dc = guestbookDao.createDetachedCriteria();
    if (StringUtils.isNotEmpty(guestbook.getType())) {
        dc.add(Restrictions.eq("type", guestbook.getType()));
    }//from  w w w.  jav a2  s.c om
    if (StringUtils.isNotEmpty(guestbook.getContent())) {
        dc.add(Restrictions.like("content", "%" + EscapeUtil.escapeLike(guestbook.getContent()) + "%"));
    }
    dc.add(Restrictions.eq(Guestbook.DEL_FLAG, guestbook.getDelFlag()));
    dc.addOrder(Order.desc("id"));
    return guestbookDao.find(page, dc);
}