Example usage for org.hibernate.criterion Projections max

Introduction

In this page you can find the example usage for org.hibernate.criterion Projections max.

Prototype

public static AggregateProjection max(String propertyName)

Source Link

Document

A property maximum value projection

Usage

From source file:br.com.muranodesign.dao.impl.RegistroDiarioDAOImpl.java

License:Creative Commons License

@SuppressWarnings("unchecked")
public List<RegistroDiario> listarUltimo() {
    Criteria criteria = getSession().createCriteria(RegistroDiario.class);
    criteria.setProjection(Projections.max("data"));
    List<RegistroDiario> result = criteria.list();
    return result;
}

From source file:br.com.pfood.dao.imp.GenericDAOImp.java

@Override
public int buscaProximoCodigo(Class classe) throws Exception {

    Field[] fields = classe.getDeclaredFields();
    Criteria c = getSession().createCriteria(classe);
    for (Field f : fields) {
        f.setAccessible(true);/* ww w  .  j a  v  a  2 s  .  c  om*/
        if (f.isAnnotationPresent(Id.class)) {
            c.setProjection(Projections.max(f.getName()));
            break;
        }
    }
    c.setResultTransformer(c.DISTINCT_ROOT_ENTITY);
    Integer maximo = (Integer) c.uniqueResult();

    if (maximo == null || maximo == 0) {
        return 1;
    } else {
        return maximo + 1;
    }
}

From source file:br.com.sales.compra.DAO.DAO.java

/**
 * public void setById(int id) { nfc.setId(id); }
 *///from  www  .  j  a  v a 2  s  .  c o  m
public int getMaxNotaId(VO vo) {
    Criteria criteria = s.createCriteria(classe);
    int maxId = (int) criteria.setProjection(Projections.max("id")).uniqueResult();
    return maxId;
}

From source file:br.com.webbudget.domain.model.repository.entries.WalletBalanceRepository.java

License:Open Source License

/**
 *
 * @param wallet/*from w  w  w . ja  va 2s  .co m*/
 * @return
 */
@Override
public WalletBalance findLastWalletBalance(Wallet wallet) {

    final Criteria criteria = this.getSession().createCriteria(this.getPersistentClass());

    criteria.createAlias("wallet", "wl");
    criteria.add(Restrictions.eq("wl.id", wallet.getId()));

    criteria.setProjection(Projections.max("id"));

    final Object id = criteria.uniqueResult();

    if (id != null) {
        return this.findById((Long) id, false);
    } else {
        return null;
    }
}

From source file:br.com.webbudget.domain.model.repository.logbook.RefuelingRepository.java

License:Open Source License

/**
 * //from   ww  w  .j a  v  a 2 s .  co m
 * @param refueling
 * @return 
 */
@Override
public boolean isLast(Refueling refueling) {

    Criteria criteria = this.createCriteria();

    criteria.createAlias("vehicle", "ve");
    criteria.add(Restrictions.eq("ve.id", refueling.getVehicle().getId()));
    criteria.setProjection(Projections.max("id"));

    Object maxId = criteria.uniqueResult();

    if (maxId != null) {
        return refueling.getId().equals((Long) maxId);
    }
    return true;
}

From source file:br.com.webbudget.domain.model.repository.logbook.RefuelingRepository.java

License:Open Source License

/**
 *
 * @return/*from  w  w  w .j a  v a2  s . com*/
 */
@Override
public int findLastOdometerForVehicle(Vehicle vehicle) {

    Criteria criteria = this.createCriteria();

    criteria.createAlias("vehicle", "ve");
    criteria.add(Restrictions.eq("ve.id", vehicle.getId()));
    criteria.setProjection(Projections.max("id"));

    Object maxId = criteria.uniqueResult();

    if (maxId != null) {
        criteria = this.createCriteria();
        criteria.add(Restrictions.eq("id", (Long) maxId));
        return ((Refueling) criteria.uniqueResult()).getOdometer();
    }
    return 0;
}

From source file:br.com.webbudget.domain.model.repository.miscellany.ClosingRepository.java

License:Open Source License

/**
 *
 * @return/*from w  w  w .  j av  a2  s . co  m*/
 */
@Override
public BigDecimal findLastAccumulated() {

    final Criteria criteria = this.createCriteria();

    final DetachedCriteria mostRecent = DetachedCriteria.forClass(Closing.class)
            .setProjection(Projections.max("closingDate"));

    criteria.add(Property.forName("closingDate").eq(mostRecent));
    criteria.setProjection(Projections.sum("accumulated"));

    return (BigDecimal) criteria.uniqueResult();
}

From source file:br.com.webbudget.domain.model.repository.miscellany.FinancialPeriodRepository.java

License:Open Source License

/**
 * //ww w .  j a va2 s  .  c  o m
 * @return 
 */
@Override
public FinancialPeriod findLatestClosed() {

    final Criteria criteria = this.createCriteria();

    DetachedCriteria maxId = DetachedCriteria.forClass(FinancialPeriod.class)
            .add(Restrictions.eq("closed", true)).setProjection(Projections.max("id"));

    criteria.add(Property.forName("id").eq(maxId));

    return (FinancialPeriod) criteria.uniqueResult();
}

From source file:co.com.codesoftware.logic.admin.ConteosLogic.java

public Integer selectMaxProductoConteo() {
    Integer resultado = 1;/*from www . ja v  a2 s .  c  o m*/
    try {
        Criteria crit = sesion.createCriteria(ProductoConteoEntity.class).setProjection(Projections.max("id"));
        resultado = (Integer) crit.uniqueResult() + 1;
    } catch (Exception e) {
        resultado = 1;
        e.printStackTrace();
    }
    return resultado;
}

From source file:co.com.codesoftware.logic.MarcaLogic.java

/**
 * Funcion que consulta el maximo del id de la marca y le suma 1
 * @return //from ww  w .ja va2 s .  c o m
 */

public Integer selectMaxMarca() {
    Integer resultado = null;
    try {
        Criteria crit = sesion.createCriteria(MarcaEntity.class).setProjection(Projections.max("id"));
        resultado = (Integer) crit.uniqueResult() + 1;
    } catch (Exception e) {
        resultado = 1;
        e.printStackTrace();
    }
    return resultado;
}