Example usage for org.hibernate.criterion CriteriaSpecification 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.RateDao.java

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

---

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

public List getRateList(CurrencyEntity currency, int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(RateEntity.class);
    c.add(Restrictions.eq("currency", currency));

    //        Criterion code = Restrictions.like("code", "%"+keyword+"%");
    //        Criterion desc = Restrictions.like("name", "%"+keyword+"%");
    //        LogicalExpression orExp = Restrictions.or(code,desc);
    //        c.add(orExp);

    if (sort.contains("-")) {
        c.addOrder(Order.desc(sort.substring(1)));
    } else {/*from  w ww . j a va2  s  .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.ReturnPurchaseDao.java

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

---

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

public List getReturnPurchaseList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnPurchaseEntity.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);/*w  w w  .  j  a  v  a2  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.ReturnPurchaseDao.java

public List getUnpaidReturnPurchaseList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnPurchaseEntity.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  .j a v  a 2s.  c om*/
    return ls;
}

---

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

public List getReturnPurchaseList(Calendar begin, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnPurchaseEntity.class);
    c.add(Restrictions.between("date", begin, end));
    if (partner != null) {
        c.add(Restrictions.eq("partner", partner));
    }//from  w  ww.ja  v  a 2s .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.ReturnPurchaseDraftDao.java

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

---

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

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

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

---

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

public List getReturnSalesList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ReturnSalesEntity.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  www  .j ava 2s .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);

    List ls = c.list();
    return ls;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• 45
• 46
• 47
• 48
• 49
• »