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

public List<ItemExpensesEntity> getItemExpensesList(Calendar start, Calendar end, WarehouseEntity warehouse,
        PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemExpensesEntity.class, "itemexpenses");
    c.createAlias("itemexpenses.expenses", "expenses");
    c.add(Restrictions.between("expenses.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("expenses.warehouse", warehouse));
    }//from   www . j  av  a2s. c  om
    if (partner != null) {
        c.add(Restrictions.eq("expenses.partner", partner));
    }
    if (currency != null) {
        c.add(Restrictions.eq("expenses.currency", currency));
    }
    c.add(Restrictions.eq("expenses.status", status));
    c.addOrder(Order.asc("expenses.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List<ItemExpensesDraftEntity> getItemExpensesDraftList(ExpensesDraftEntity expensesdraft) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ItemExpensesDraftEntity.class);
    c.add(Restrictions.eq("expensesdraft", expensesdraft));
    c.addOrder(Order.asc("id"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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

public List getItemGroupList(int itemperpage, int page, String sort, String keyword) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ItemGroupEntity.class);
    Criterion code = Restrictions.like("code", "%" + keyword + "%");
    Criterion desc = Restrictions.like("name", "%" + keyword + "%");
    LogicalExpression orExp = Restrictions.or(code, desc);
    c.add(orExp);//from  w  w w  .j  av a 2s .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.ItemInvoicePurchaseDao.java

public List<ItemInvoicePurchaseEntity> getItemInvoicePurchaseList(InvoicePurchaseEntity invoicepurchase) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ItemInvoicePurchaseEntity.class);
    c.add(Restrictions.eq("invoicepurchase", invoicepurchase));
    c.addOrder(Order.asc("id"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List<ItemInvoicePurchaseEntity> getItemInvoicePurchaseList(Calendar start, Calendar end,
        WarehouseEntity warehouse, PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemInvoicePurchaseEntity.class, "iteminvoicepurchase");
    c.createAlias("iteminvoicepurchase.invoicepurchase", "invoicepurchase");
    c.add(Restrictions.between("invoicepurchase.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("invoicepurchase.warehouse", warehouse));
    }/*from   ww  w.j a  va  2 s .  co  m*/
    if (currency != null) {
        c.add(Restrictions.eq("invoicepurchase.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("invoicepurchase.partner", partner));
    }
    c.add(Restrictions.eq("invoicepurchase.status", status));
    c.addOrder(Order.asc("invoicepurchase.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List<ItemInvoicePurchaseDraftEntity> getItemInvoicePurchaseDraftList(
        InvoicePurchaseDraftEntity invoicepurchasedraft) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ItemInvoicePurchaseDraftEntity.class);
    c.add(Restrictions.eq("invoicepurchasedraft", invoicepurchasedraft));
    c.addOrder(Order.asc("id"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List<ItemInvoiceSalesEntity> getItemInvoiceSalesList(InvoiceSalesEntity invoicesales) {
    Session session = this.sessionFactory.getCurrentSession();
    Criteria c = session.createCriteria(ItemInvoiceSalesEntity.class);
    c.add(Restrictions.eq("invoicesales", invoicesales));
    c.addOrder(Order.asc("id"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

public List<ItemInvoiceSalesEntity> getItemInvoiceSalesList(Calendar start, Calendar end,
        WarehouseEntity warehouse, PartnerEntity partner, CurrencyEntity currency, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemInvoiceSalesEntity.class, "iteminvoicesales");
    c.createAlias("iteminvoicesales.invoicesales", "invoicesales");
    c.add(Restrictions.between("invoicesales.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("invoicesales.warehouse", warehouse));
    }//from www. j a v a  2s. c o  m
    if (currency != null) {
        c.add(Restrictions.eq("invoicesales.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("invoicesales.partner", partner));
    }
    c.add(Restrictions.eq("invoicesales.status", status));
    c.addOrder(Order.asc("invoicesales.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

Introduction

Prototype

Document

Usage