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

public List getImageList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ImageEntity.class);
    Criterion code = Restrictions.like("id", "%" + keyword + "%");
    Criterion desc = Restrictions.like("name", "%" + keyword + "%");
    LogicalExpression orExp = Restrictions.or(code, desc);
    c.add(orExp);/*from  w w 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.InvoicePurchaseDao.java

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

---

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

public List getInvoicePurchaseList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseEntity.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);/*  ww w.j a va2s.  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();
}

---

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

public List getUnpaidInvoicePurchaseList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseEntity.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();// w  ww  .  j  av  a  2  s. co  m
    return ls;
}

---

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

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

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

---

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

public List getInvoicePurchaseDraftList(int itemperpage, int page, String sort, String keyword, UserEntity user,
        WarehouseEntity warehouse) {//from   w w w . j  a  v  a 2  s .  co  m
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoicePurchaseDraftEntity.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.InvoiceSalesDao.java

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

---

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

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

---

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

public List getUnpaidInvoiceSalesList(PartnerEntity partner, CurrencyEntity currency) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(InvoiceSalesEntity.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();//  ww w  .  ja  va2s.c  o m
    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
• »