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

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

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

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

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

public List<ItemInvoiceWarehouseInEntity> getItemInvoiceWarehouseInList(Calendar start, Calendar end,
        WarehouseEntity warehouse, WarehouseEntity origin, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemInvoiceWarehouseInEntity.class, "iteminvoicewarehousein");
    c.createAlias("iteminvoicewarehousein.invoicewarehousein", "invoicewarehousein");
    c.add(Restrictions.between("invoicewarehousein.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("invoicewarehousein.warehouse", warehouse));
    }/*from  ww  w  .j  a v a2  s  .  c  o  m*/
    if (origin != null) {
        c.add(Restrictions.eq("invoicewarehousein.origin", origin));
    }
    c.add(Restrictions.eq("invoicewarehousein.status", status));
    c.addOrder(Order.asc("invoicewarehousein.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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

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

public List<ItemInvoiceWarehouseOutEntity> getItemInvoiceWarehouseOutList(Calendar start, Calendar end,
        WarehouseEntity warehouse, WarehouseEntity destination, boolean status) {
    Session session = this.sessionFactory.getCurrentSession();

    Criteria c = session.createCriteria(ItemInvoiceWarehouseOutEntity.class, "iteminvoicewarehouseout");
    c.createAlias("iteminvoicewarehouseout.invoicewarehouseout", "invoicewarehouseout");
    c.add(Restrictions.between("invoicewarehouseout.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("invoicewarehouseout.warehouse", warehouse));
    }//from   w w w  . j a va2 s  .  c  o  m
    if (destination != null) {
        c.add(Restrictions.eq("invoicewarehouseout.destination", destination));
    }
    c.add(Restrictions.eq("invoicewarehouseout.status", status));
    c.addOrder(Order.asc("invoicewarehouseout.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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

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

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

    Criteria c = session.createCriteria(ItemReturnPurchaseEntity.class, "itemreturnpurchase");
    c.createAlias("itemreturnpurchase.returnpurchase", "returnpurchase");
    c.add(Restrictions.between("returnpurchase.date", start, end));
    if (warehouse != null) {
        c.add(Restrictions.eq("returnpurchase.warehouse", warehouse));
    }//w w  w  .  j  ava 2 s .  c  o m
    if (currency != null) {
        c.add(Restrictions.eq("returnpurchase.currency", currency));
    }
    if (partner != null) {
        c.add(Restrictions.eq("returnpurchase.partner", partner));
    }
    c.add(Restrictions.eq("returnpurchase.status", status));
    c.addOrder(Order.asc("returnpurchase.date"));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

Example usage for org.hibernate.criterion CriteriaSpecification DISTINCT_ROOT_ENTITY

Introduction

Prototype

Document

Usage