Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

List of usage examples for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. CriteriaSpecification
  6. DISTINCT_ROOT_ENTITY

Introduction

In this page you can find the example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY.

Prototype

ResultTransformer DISTINCT_ROOT_ENTITY

To view the source code for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY.

Click Source Link

Document

Each row of results is a distinct instance of the root entity

Usage

From source file:net.purnama.pureff.dao.AdjustmentDao.java

public List getAdjustmentList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(AdjustmentEntity.class);
    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));

    c.add(disjunction);/* ww  w  . jav a 2  s  . c  o m*/

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

From source file:net.purnama.pureff.dao.AdjustmentDraftDao.java

public List<AdjustmentDraftEntity> getAdjustmentDraftList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(AdjustmentDraftEntity.class);
    c.addOrder(Order.desc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.AdjustmentDraftDao.java

public List getAdjustmentDraftList(int itemperpage, int page, String sort, String keyword, UserEntity user,
        WarehouseEntity warehouse) {// w ww.ja  v a2s .c  o  m
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(AdjustmentDraftEntity.class);
    c.add(Restrictions.like("id", "%" + keyword + "%"));
    c.add(Restrictions.eq("lastmodifiedby", user));
    c.add(Restrictions.eq("warehouse", warehouse));
    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

From source file:net.purnama.pureff.dao.BuyPriceDao.java

public List<BuyPriceEntity> getBuyPriceList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(BuyPriceEntity.class);
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.BuyPriceDao.java

public List<BuyPriceEntity> getBuyPriceList(ItemEntity item) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(BuyPriceEntity.class);
    c.add(Restrictions.eq("item", item));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.BuyPriceDao.java

public List<BuyPriceEntity> getBuyPriceList(UomEntity uom) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(BuyPriceEntity.class);
    c.add(Restrictions.eq("uom", uom));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.CurrencyDao.java

public List<CurrencyEntity> getActiveCurrencyList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(CurrencyEntity.class);
    c.add(Restrictions.eq("status", true));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.CurrencyDao.java

public List<CurrencyEntity> getCurrencyList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(CurrencyEntity.class);
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

From source file:net.purnama.pureff.dao.CurrencyDao.java

public List getCurrencyList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(CurrencyEntity.class);
    Criterion code = Restrictions.like("code", "%" + keyword + "%");
    Criterion desc = Restrictions.like("name", "%" + keyword + "%");
    LogicalExpression orExp = Restrictions.or(code, desc);
    c.add(orExp);//from w ww .j a v a2  s .co m

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {
        c.addOrder(Order.asc(sort));
    }
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    c.setFirstResult(itemperpage * (page - 1));
    c.setMaxResults(itemperpage);

    return c.list();
}

From source file:net.purnama.pureff.dao.DeliveryDao.java

public List<DeliveryEntity> getDeliveryList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(DeliveryEntity.class);
    c.addOrder(Order.desc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}