List of usage examples for org.hibernate Query setDate
@Deprecated @SuppressWarnings("unchecked") default Query<R> setDate(String name, Date val)
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(); } }); }