Example usage for org.hibernate.criterion Projections projectionList

Introduction

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

Prototype

public static ProjectionList projectionList()

Source Link

Document

Create a new projection list.

Usage

From source file:bernardo.venda.controle.ProdutoVendaControle.java

public List findAllM(Caixa caixa) {
    Criteria crit = getSession().createCriteria(ProdutoVenda.class, "pv")
            .setProjection(Projections.projectionList().add(Projections.property("produto"))
                    .add(Projections.sum("quantidade")).add(Projections.sum("quantEntrada"))
                    .add(Projections.sum("quantSaida")).add(Projections.groupProperty("produto")))
            .createCriteria("transacao").add(Restrictions.eq("caixa", caixa));

    List results = crit.list();//from   www.  ja va2s.  co  m
    return results;
}

From source file:br.com.gerenciapessoal.repository.Lancamentos.java

@SuppressWarnings("UnusedAssignment")
public Map<Date, BigDecimal> valoresTotaisPorData(Integer numeroDeDias, Conta conta) {
    Session session = manager.unwrap(Session.class);

    Calendar dataInicial = Calendar.getInstance();
    dataInicial = DateUtils.truncate(dataInicial, Calendar.DAY_OF_MONTH);
    dataInicial.add(Calendar.DAY_OF_MONTH, numeroDeDias * -1);

    Map<Date, BigDecimal> resultado = criarMapaVazio(numeroDeDias, dataInicial);

    Criteria criteria = session.createCriteria(Lancamento.class).createAlias("conta", "c");

    criteria.setProjection(Projections.projectionList()
            .add(Projections.sqlGroupProjection("date(data_emissao) as data", "date(data_emissao)",
                    new String[] { "data" }, new Type[] { StandardBasicTypes.DATE }))
            .add(Projections.sum("valorLanca").as("valor")))
            .add(Restrictions.ge("dataEmissao", dataInicial.getTime()));

    if (conta != null) {
        criteria.add(Restrictions.eq("c.id", conta.getId()));
    }//w w w .j a  v  a2s.  c  o  m
    List<DataValor> valoresPorData = criteria.setResultTransformer(Transformers.aliasToBean(DataValor.class))
            .list();

    for (DataValor dataValor : valoresPorData) {
        resultado.put(dataValor.getData(), dataValor.getValor());
    }

    return resultado;
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getMailSender() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getMailSender()");
    final Criteria mailFrom = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("mailFrom"));
    mailFrom.setProjection(proList);//from   w  w w  . ja  va 2 s.c o  m
    return (String) mailFrom.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getMailSenderNotLogged() {

    log.fine("[ System ] getMailSenderNotLogged()");

    final Criteria mailFrom = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("mailFrom"));
    mailFrom.setProjection(proList);//www. j a va  2  s  .co  m
    return (String) mailFrom.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public boolean sendNotification() {

    log.fine("Invoking sendNotification() database query,");

    final Criteria sendNotification = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("sendNotification"));
    sendNotification.setProjection(proList);
    return (Boolean) sendNotification.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getSubject() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getSubject()");

    final Criteria subject = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("subject"));
    subject.setProjection(proList);//from   w  w  w.j  a va2s  . c om
    return (String) subject.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getSubjectNotLogged() {

    log.fine("[ System ] getSubjectNotLogged()");

    final Criteria subject = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("subject"));
    subject.setProjection(proList);//from   w ww .jav a  2 s  .  c o  m
    return (String) subject.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getDests() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getDests()");

    final Criteria subject = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("dests"));
    subject.setProjection(proList);//from w  w  w  .ja  v  a  2 s.  c  o m
    return (String) subject.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getDestsNotLogged() {

    log.fine("[ System ] getDestsNotLogged()");

    final Criteria subject = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("dests"));
    subject.setProjection(proList);/*from  www  .j a va 2s .c  om*/
    return (String) subject.uniqueResult();
}

From source file:br.com.hrstatus.dao.impl.ConfigurationDAO.java

License:Open Source License

public String getJndiMail() {

    log.fine("[ " + userInfo.getLoggedUsername() + " ] getJndiMail()");

    final Criteria subject = session().createCriteria(Configurations.class);
    final ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("jndiMail"));
    subject.setProjection(proList);// www .j a v  a 2 s  .  c o  m
    return (String) subject.uniqueResult();
}