List of usage examples for com.liferay.portal.kernel.dao.orm Type DATE
Type DATE
To view the source code for com.liferay.portal.kernel.dao.orm Type DATE.
Click Source Link
From source file:com.ext.portlet.halcon.service.impl.SolicitudContactoLocalServiceImpl.java
License:Open Source License
@SuppressWarnings("unchecked") public List<Object[]> obtenerSolicitud(Integer filas, Integer pagina, String fechaInicio, String fechaFinal) throws BusinessException { _log.info(//from w ww .j a va2 s. co m "com.ext.portlet.halcon.service.SolicitudContactoLocalService - obtenerSolicitudCount : fechainicio " + fechaInicio + " - fechafinal " + fechaFinal + " - filas " + filas.toString() + " - pagina " + pagina.toString()); Session session = null; try { session = solicitudContactoPersistence.openSession(); String sql = CustomSQLUtil.get(FINDER_SOLICITUDES); SQLQuery q = session.createSQLQuery(sql); if (filas > 0 && pagina > 0) { q.setFirstResult(filas * pagina - filas); q.setMaxResults(filas); } q.addScalar("slct_IdSolicitudContacto", Type.STRING); q.addScalar("slct_EsCliente", Type.STRING); q.addScalar("slct_Nombres", Type.STRING); q.addScalar("slct_Apellidos", Type.STRING); q.addScalar("slct_Email", Type.STRING); q.addScalar("slct_TipoDocumento", Type.STRING); q.addScalar("slct_Ndocumento", Type.STRING); q.addScalar("slct_Direccion", Type.STRING); q.addScalar("slct_Departamento", Type.STRING); q.addScalar("slct_Provincia", Type.STRING); q.addScalar("slct_Distrito", Type.STRING); q.addScalar("slct_Telefono", Type.STRING); q.addScalar("slct_Fecha", Type.DATE); q.addScalar("slct_Mensaje", Type.STRING); q.addScalar("slct_Moneda", Type.STRING); q.addScalar("slct_Importe", Type.STRING); q.addScalar("slct_TipoMensaje", Type.STRING); q.addScalar("slct_TipoTema", Type.STRING); QueryPos qPos = QueryPos.getInstance(q); qPos.add(fechaInicio + " 0:00:00"); qPos.add(fechaFinal + " 23:59:59"); List<Object[]> out = new ArrayList<Object[]>(); out = q.list(); return out; } catch (Exception e) { e.printStackTrace(); _log.error("Error en com.ext.portlet.halcon.service.SolicitudContactoLocalService" + e.toString()); throw new BusinessException( "Error en com.ext.portlet.halcon.service.SolicitudContactoLocalService.obtenerSolicitud - Clase: com.ext.portlet.halcon.service.SolicitudContactoLocalService", e.toString()); } finally { solicitudContactoPersistence.closeSession(session); } }
From source file:org.oep.cmon.dao.tlct.service.persistence.TaiLieuChungThucFinderImpl.java
License:Apache License
/** * This is fucntion searchByCongDanId2DanhMucGiayTo * Version: 1.0//ww w.j av a2 s .c o m * * History: * DATE AUTHOR DESCRIPTION * ------------------------------------------------- * 3-March-2013 Nam Dinh Create new * @param String group, Long congDanId, Long doiTuongId, int start, int end * @return List<TaiLieuChungThuc> */ public List<TaiLieuChungThuc> searchByCongDanId2DanhMucGiayTo(String group, Long congDanId, Long doiTuongId, int start, int end) { // TODO Auto-generated method stub Session session = null; List<TaiLieuChungThuc> list = new ArrayList<TaiLieuChungThuc>(); try { session = openSession(); StringBuffer sql = new StringBuffer(""); sql.append(" SELECT DISTINCT nlttl.ID AS ID, dmgt.TEN AS TEN, dmgt.MA AS MA, nlttl.TRANGTHAI " + ", nlttl.NGAYUPLOAD, nlttl.hieuluctungay, nlttl.hieulucdenngay, nlttl.DANHMUCGIAYTOID, nlttl.noiluutruid,nlttl.phienban as PHIENBAN " + " FROM CMON_NOILUUTRUTAILIEU nlttl " + " INNER JOIN CMON_DANHMUCGIAYTO dmgt ON dmgt.ID=nlttl.DANHMUCGIAYTOID " + " LEFT JOIN CMON_DMGIAYTO2DOITUONGSUDUNG dtgt ON dtgt.LOAIGIAYTOID=dmgt.ID " + " LEFT JOIN CMON_LOAIDOITUONG dt ON dt.ID=dtgt.LOAIDOITUONGID " + " WHERE dmgt.daxoa=0 and dtgt.daxoa=0 and dtgt.trangthai=1 and dt.daxoa=0"); if (Validator.isNotNull(group)) { sql.append(" AND (LOWER(dmgt.TEN) like LOWER(?) OR LOWER(dmgt.MA) like LOWER(?) )"); } if (Validator.isNotNull(congDanId)) { sql.append(" AND nlttl.chusohuuId = ?"); sql.append( " AND ( nlttl.danhmucgiaytoid, nlttl.phienban ) IN ( SELECT danhmucgiaytoid, MAX(phienban) FROM cmon_noiluutrutailieu where chusohuuid=? GROUP BY danhmucgiaytoid ) "); } if (Validator.isNotNull(doiTuongId)) { sql.append(" AND dt.id = ?"); } sql.append(" ORDER BY nlttl.NGAYUPLOAD DESC, LOWER(dmgt.TEN) ASC "); SQLQuery q = session.createSQLQuery(sql.toString()); q.addScalar("ID", Type.LONG); q.addScalar("TEN", Type.STRING); q.addScalar("MA", Type.STRING); q.addScalar("TRANGTHAI", Type.INTEGER); q.addScalar("NGAYUPLOAD", Type.DATE); q.addScalar("HIEULUCTUNGAY", Type.DATE); q.addScalar("HIEULUCDENNGAY", Type.DATE); q.addScalar("DANHMUCGIAYTOID", Type.LONG); q.addScalar("NOILUUTRUID", Type.LONG); q.addScalar("PHIENBAN", Type.INTEGER); QueryPos qPos = QueryPos.getInstance(q); if (Validator.isNotNull(group)) { qPos.add("%" + group + "%"); qPos.add("%" + group + "%"); } if (Validator.isNotNull(congDanId)) { qPos.add(congDanId); qPos.add(congDanId); } if (Validator.isNotNull(doiTuongId)) { qPos.add(doiTuongId); } Iterator<Object[]> itr = (Iterator<Object[]>) QueryUtil.iterate(q, getDialect(), start, end); while (itr.hasNext()) { Object[] a = itr.next(); TaiLieuChungThuc t = new TaiLieuChungThucImpl(); t.setId(Long.valueOf(a[0].toString())); t.setTen((String) a[1]); t.setGhiChu(a[2].toString()); t.setTrangThai(Integer.valueOf(a[3].toString())); t.setNgayUpload((java.util.Date) a[4]); t.setHieuLucTuNgay((java.util.Date) a[5]); t.setHieuLucDenNgay((java.util.Date) a[6]); t.setDanhMucGiayToId(Long.valueOf(a[7].toString())); t.setNoiLuuTruId(Long.valueOf(a[8].toString())); t.setPhienBan(Integer.valueOf(a[9].toString())); list.add(t); } return list; } catch (Exception e) { e.printStackTrace(); } finally { closeSession(session); } return list; }