Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT

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.ReturnSalesDao.java

public List getUnpaidReturnSalesList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnSalesEntity.class);
    c.add(Restrictions.eq("partner", partner));
    c.add(Restrictions.eq("currency", currency));
    c.add(Restrictions.eq("status", true));
    c.add(Restrictions.gt("remaining", 0.0));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();/*from  w  ww.jav a2s  . c om*/
    return ls;
}

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

public List getReturnSalesList(Calendar begin, Calendar end, WarehouseEntity warehouse, PartnerEntity partner,
        CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnSalesEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }//from   w w  w .  ja v  a2  s  .com
    if (warehouse != null) {
        c.add(Restrictions.eq("warehouse", warehouse));
    }
    if (currency != null) {
        c.add(Restrictions.eq("currency", currency));
    }
    c.add(Restrictions.eq("status", status));
    c.addOrder(Order.asc("date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();
    return ls;
}

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

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

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

public List getReturnSalesDraftList(int itemperpage, int page, String sort, String keyword, UserEntity user,
        WarehouseEntity warehouse) {/*from  ww  w  .  jav a  2 s .c  o m*/
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnSalesDraftEntity.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.RoleDao.java

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

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

public List<RoleEntity> getRoleList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(RoleEntity.class);
    c.addOrder(Order.asc("name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List getRoleList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(RoleEntity.class);
    c.add(Restrictions.like("name", "%" + keyword + "%"));

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {/*  www.  j  a va 2s  .com*/
        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.SellPriceDao.java

public List<SellPriceEntity> getSellPriceList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(SellPriceEntity.class, "sellprice");
    c.createAlias("sellprice.item", "item");
    c.createAlias("sellprice.uom", "uom");
    c.addOrder(Order.desc("item.name"));
    c.addOrder(Order.asc("uom.name"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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

Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

Introduction

Prototype

Document

Usage