Example usage for org.hibernate Query setDate

List of usage examples for org.hibernate Query setDate

Introduction

In this page you can find the example usage for org.hibernate Query setDate.

Prototype

@Deprecated
@SuppressWarnings("unchecked")
default Query<R> setDate(String name, Date val) 

Source Link

Document

Bind the val (time is truncated) of a given Date object to a named query parameter.

Usage

From source file:ru.codemine.ccms.dao.TaskDAOImpl.java

License:Open Source License

@Override
public List<Task> getByPerformerAndCloseTimeInPeriod(Employee performer, LocalDate startDate,
        LocalDate endDate) {/*from ww  w .jav a2s . co  m*/
    Query query = getSession().createQuery(
            "FROM Task t WHERE :performer IN ELEMENTS(t.performers) AND t.closeTime >= :startDate AND t.closeTime <= :endDate");
    query.setParameter("performer", performer);
    query.setDate("startDate", startDate.toDate());
    query.setDate("endDate", endDate.toDate());

    return query.list();
}

From source file:ru.codemine.pos.dao.document.ChequeDAOImpl.java

License:Open Source License

@Override
public List<Cheque> getByPeriod(LocalDate startDate, LocalDate endDate) {
    endDate = endDate.plusDays(1); //    

    Query query = getSession().createQuery("FROM Cheque c WHERE c.creationTime BETWEEN :start AND :end");
    query.setDate("start", startDate.toDate());
    query.setDate("end", endDate.toDate());

    return query.list();
}

From source file:ru.codemine.pos.dao.document.ChequeDAOImpl.java

License:Open Source License

@Override
public List<Cheque> getByPeriod(LocalDate startDate, LocalDate endDate, Cheque.PaymentType type) {
    endDate = endDate.plusDays(1);/* w  w w . j ava2  s  . co  m*/

    Query query = getSession().createQuery(
            "FROM Cheque c WHERE c.paymentType = :type AND c.creationTime BETWEEN :start AND :end");
    query.setDate("start", startDate.toDate());
    query.setDate("end", endDate.toDate());
    query.setInteger("type", type.ordinal());

    return query.list();
}

From source file:services.fluxo.ContaBancariaService.java

/**
 * Retorna o saldo da conta bancria/*  w w  w .  java  2s.c o  m*/
 *
 * @param c
 * @return
 */
public double saldoCaixa(ContaBancaria c, Date ate) {
    return (Double) selectOnSession((s) -> {
        //            Query q = s.createQuery("SELECT "
        //                    + "CASE WHEN c.categoria.tipo = :entrada"
        //                    + " THEN SUM(c.valorTotal) - SUM(c.valorPago) "
        //                    + "ELSE ((SUM(c.valorTotal) - SUM(c.valorPago))) END"
        //                    + " FROM Contas c where c.id = :id");
        Query q = s.createQuery("SELECT SUM(" + "CASE WHEN contaCategoria.tipo = :entrada THEN " + "valor "
                + "ELSE (valor * -1.0) END" + ")" + " FROM ParcelaPagamento where contaBancaria.id = :id"
                + (ate != null ? " and data <= :data" : ""));
        q.setInteger("id", c.getId());
        q.setParameter("entrada", ContaCategoria.TipoCategoria.entrada);
        if (ate != null) {
            q.setDate("data", ate);
        }
        List l = q.list();
        if (l.size() == 1 && l.get(0) != null) {
            return Double.parseDouble(l.get(0).toString());
        }
        return 0D;
    });
}

From source file:services.fluxo.ContaBancariaService.java

/**
 * Consulta o saldo geral do sistema at perodo
 *
 * @param ate//from  w w  w .j ava 2  s .c  o m
 * @return
 */
public double saldoGeral(Date ate) {
    return (Double) selectOnSession((s) -> {
        //            Query q = s.createQuery("SELECT "
        //                    + "CASE WHEN c.categoria.tipo = :entrada"
        //                    + " THEN SUM(c.valorTotal) - SUM(c.valorPago) "
        //                    + "ELSE ((SUM(c.valorTotal) - SUM(c.valorPago))) END"
        //                    + " FROM Contas c where c.id = :id");
        Query q = s.createQuery("SELECT SUM(" + "CASE WHEN contaCategoria.tipo = :entrada THEN " + "valor "
                + "ELSE (valor * -1.0) END" + ")" + " FROM ParcelaPagamento c where c.data <= :data");

        q.setParameter("entrada", ContaCategoria.TipoCategoria.entrada);
        q.setDate("data", ate);
        List l = q.list();
        if (l.get(0) != null) {
            return Double.parseDouble(l.get(0).toString());
        }
        return 0d;
    });
}

From source file:turbo.service.HbnUserBillDAO.java

@Override
public ArrayList<UserBill> getUserBillByDate(String bookDate) {
    ArrayList<UserBill> result = new ArrayList<UserBill>();
    try {//  w  w  w  .  j a  v  a2 s  .  c om

        Session ss = getSession();

        ss.beginTransaction();

        SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy");

        Date exactDate = df.parse(bookDate);

        Query query = ss.createQuery("SELECT u FROM UserBill u WHERE DATE(u.bookDate) = :bookDate");
        query.setDate("bookDate", exactDate);

        result = (ArrayList<UserBill>) query.list();
        System.out.println(result.size());
        //ss.close();

    } catch (ParseException ex) {
        Logger.getLogger(HbnUserBillDAO.class.getName()).log(Level.SEVERE, null, ex);

    }
    return result;
}

From source file:ud.ing.modi.mapper.ClienteMapper.java

public List<PuntoRecarga> obtenerPtosRecargaPorFacturar(Date fechaInicial, Date fechaFinal) throws Exception {
    List<PuntoRecarga> listaResultado = null;
    try {/*from   w w  w . j a v  a  2  s .  c  om*/
        iniciaOperacion();
        //String query = "SELECT * FROM PUNTO_RECARGA WHERE PUNTO_RECARGA.COD_CLIENTE IN (SELECT DISTINCT RECARGA.COD_CLI_PTORECARGA FROM RECARGA WHERE RECARGA.FECHA_RECARGA BETWEEN ? AND <= ?)";
        String hqlQueryStr = "from PuntoRecarga as pt " + "where pt.idCliente in "
                + "(select distinct r.puntoRecarga from Recarga as r where r.fechaRecarga between ? and ?)";

        Query hqlQuery = getSesion().createQuery(hqlQueryStr);
        hqlQuery.setDate(0, fechaInicial);
        hqlQuery.setDate(1, fechaFinal);
        //String sqlQueryStr = "SELECT * FROM PUNTO_RECARGA WHERE PUNTO_RECARGA.COD_CLIENTE IN (SELECT DISTINCT RECARGA.COD_CLI_PTORECARGA FROM RECARGA)";

        //SQLQuery sqlQuery = getSesion().createSQLQuery(sqlQueryStr);
        //sqlQuery.addEntity("PUNTO_RECARGA", PuntoRecarga.class);
        //sqlQuery.addEntity("RECARGA", Recarga.class);
        System.out.println("Fecha inicial: " + fechaInicial.toString());
        System.out.println("Fecha final: " + fechaFinal.toString());
        //sqlQuery.setDate(0, fechaInicial);
        //sqlQuery.setDate(1, fechaFinal);
        //System.out.println("QUERY A EJECUTAR: " + sqlQuery.getQueryString());
        //listaResultado = sqlQuery.list();
        listaResultado = hqlQuery.list();
    } catch (Exception e) {
        e.printStackTrace();
        throw e;
    } finally {
        getSesion().close();
    }
    return listaResultado;
}

From source file:ud.ing.modi.mapper.RecargaMapper.java

public List<Recarga> buscarRecargaPorPtoRecargaPorFacturar(PuntoRecarga puntoRecarga, Date fechaInicial,
        Date fechaFinal) {/* w w  w . j  a v  a2 s . c  om*/
    List<Recarga> recargas = null;
    System.out.println("Punto de recarga: " + puntoRecarga);
    try {
        iniciaOperacion();
        String hqlQuerystr = "from Recarga r where r.puntoRecarga = ? and r.fechaRecarga between ? and ? and factura is null";
        Query hqlquery = getSesion().createQuery(hqlQuerystr);
        hqlquery.setInteger(0, puntoRecarga.getIdCliente());
        hqlquery.setDate(1, fechaInicial);
        hqlquery.setDate(2, fechaFinal);
        //recargas= getSesion().createCriteria(Recarga.class).add(Restrictions.eq("puntoRecarga",puntoRecarga)).list();
        recargas = hqlquery.list();
        System.out.println("Movimientos hallados: " + recargas);
    } finally {
        getSesion().close();
    }
    return recargas;
}

From source file:uk.ac.ebi.metabolights.repository.dao.hibernate.Filter.java

License:Apache License

private void fillParameter(Query query, String key, Object value) throws DAOException {

    Class claz = value.getClass();

    if (claz.equals(String.class)) {
        query.setString(key, (String) value);

    } else if (claz.equals(Long.class)) {
        query.setLong(key, (Long) value);
    } else if (claz.equals(Integer.class)) {
        query.setInteger(key, (Integer) value);
    } else if (claz.equals(Date.class)) {
        query.setDate(key, (Date) value);

    } else {/*from   w  ww  .jav  a  2 s. c  o m*/
        throw new DAOException("Can't fill query parameter, Class " + claz.getName() + " not implemented");
    }
}

From source file:uk.ac.ox.oucs.vle.CourseDAOImpl.java

License:Educational Community License

@SuppressWarnings("unchecked")
public List<CourseGroupDAO> findCourseGroupByDept(final String deptId, final Range range, final Date now,
        final boolean external) {
    return getHibernateTemplate().executeFind(new HibernateCallback() {
        /**//from   w  w w  .j  av  a  2s .  c o  m
         * Note:
         * This can't be easily migrated to Hibernate Query API as collections are not supported
         * org.hibernate.MappingException: collection was not an association: uk.ac.ox.oucs.vle.CourseGroupDAO.otherDepartments
         */
        // Need the DISTINCT ROOT ENTITY filter.
        public Object doInHibernate(Session session) throws HibernateException, SQLException {

            Date startLastYear = getPreviousYearBeginning(LocalDate.fromDateFields(now)).toDate();
            StringBuffer querySQL = new StringBuffer();
            querySQL.append("SELECT DISTINCT cg.* ");
            querySQL.append("FROM course_group cg ");
            querySQL.append("LEFT JOIN course_group_otherDepartment cgd on cgd.courseGroupMuid = cg.muid ");
            querySQL.append("LEFT JOIN course_group_component cgc on cgc.courseGroupMuid = cg.muid ");
            querySQL.append("LEFT JOIN course_component cc on cgc.courseComponentMuid = cc.muid ");
            querySQL.append("WHERE ");

            querySQL.append("visibility != 'PR' AND ");

            if (external) {
                querySQL.append("visibility != 'RS' AND ");
            }

            querySQL.append("hideGroup = false AND ");

            switch (range) {
            case UPCOMING:
                querySQL.append(
                        "((cc.baseDate is null AND cc.startsText is not null) OR cc.baseDate > :now) AND ");
                break;
            case PREVIOUS:
                querySQL.append(
                        "((cc.baseDate is null AND cc.startsText is null) OR (cc.baseDate <= :now AND cc.baseDate >= :lastYear)) AND ");
                break;
            }

            querySQL.append("(otherDepartment = :deptId ");
            querySQL.append("OR (dept = :deptId and (subunit is NULL or subunit = ''))) ");
            querySQL.append("ORDER BY cg.title ");

            Query query = session.createSQLQuery(querySQL.toString()).addEntity(CourseGroupDAO.class);
            query.setString("deptId", deptId);
            query.setDate("now", now);
            if (range.equals(range.PREVIOUS)) {
                query.setDate("lastYear", startLastYear);
            }

            return query.list();
        }
    });
}