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

public List getInvoiceSalesList(Calendar begin, Calendar end, WarehouseEntity warehouse, PartnerEntity partner,
        CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }// www.  j a v a 2  s. c  o  m
    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.InvoiceSalesDraftDao.java

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

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

public List getInvoiceSalesDraftList(int itemperpage, int page, String sort, String keyword, UserEntity user,
        WarehouseEntity warehouse) {//from w w  w . j  a v a 2 s .c o  m
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesDraftEntity.class);
    c.add(Restrictions.eq("lastmodifiedby", user));
    c.add(Restrictions.eq("warehouse", warehouse));
    c.add(Restrictions.like("id", "%" + keyword + "%"));

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

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

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

public List getInvoiceWarehouseInList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceWarehouseInEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("origin_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("shipping_number", "%" + keyword + "%"));

    c.add(disjunction);/*from ww w .  jav  a2s.  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.InvoiceWarehouseInDraftDao.java

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

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

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

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

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

public List getInvoiceWarehouseOutList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceWarehouseOutEntity.class);

    Disjunction disjunction = Restrictions.disjunction();
    disjunction.add(Restrictions.like("number", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("warehouse_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("destination_code", "%" + keyword + "%"));
    disjunction.add(Restrictions.like("shipping_number", "%" + keyword + "%"));

    c.add(disjunction);/*w ww  . j  a  v  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.InvoiceWarehouseOutDraftDao.java

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