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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Criteria c = session.createCriteria(ItemDeliveryEntity.class, "itemdelivery");
    c.createAlias("itemdelivery.delivery", "delivery");
    c.add(Restrictions.between("delivery.date", start, end));
    c.add(Restrictions.eq("delivery.warehouse", warehouse));
    c.add(Restrictions.eq("delivery.status", status));
    c.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY);
    return c.list();
}

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

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

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

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