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

public List getNonTradeList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.addOrder(Order.asc("name"));
    c.createCriteria("partnertype").add(Restrictions.eq("parent", 2));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();//from  w w w.  j  av a  2  s . c om
    return ls;
}

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

public List getActiveNonTradeList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    c.add(Restrictions.eq("status", true));
    c.addOrder(Order.asc("name"));
    c.createCriteria("partnertype").add(Restrictions.eq("parent", 2));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    List ls = c.list();/*from  www  . j  a  va  2  s  .  com*/
    return ls;
}

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

public List getPartnerList(PartnerTypeEntity partnertype, boolean status) {

    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerEntity.class);
    if (partnertype != null) {
        c.add(Restrictions.eq("partnertype", partnertype));
    }//  w ww.  j a  v  a 2  s  .c  o  m

    c.add(Restrictions.eq("status", status));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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

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

public List<PartnerTypeEntity> getActivePartnerTypeList() {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(PartnerTypeEntity.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.PartnerTypeDao.java

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

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

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

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {/*www. ja va2 s  . co 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.PaymentInDao.java

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

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

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

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

    c.add(disjunction);//from   w  w w.j  av a 2s .c om

    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();
}