protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { ServletOutputStream servletOutputStream = response.getOutputStream(); JasperReport jasperReport; JasperPrint jasperPrint; Connection conn = null; try { Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:jboss/datasources/BuffaloDS"); conn = ds.getConnection(); if (conn != null) { System.out.println("Conexion Exitosa JDBC com.edb.Driver..."); } else { System.out.println("Error Conexion JDBC com.edb.Driver..."); } } catch (Exception e) { // TODO: handle exception System.out.println("Error al conectar JDBC: " + e.getMessage()); } try { String pUsuario = request.getParameter("pUsuario"); String pSucursal = request.getParameter("pSucursal"); String pId = request.getParameter("pId"); System.out.println("Parametros Reporte: ......"); System.out.println("pUsuario: " + pUsuario); System.out.println("pSucursal: " + pSucursal); System.out.println("pId : " + pId); System.out.println("Conexion em: " + em.isOpen()); @SuppressWarnings("deprecation") String realPath = request.getRealPath("/"); System.out.println("Real Path: " + realPath); // load JasperDesign from XML and compile it into JasperReport System.out.println( "Context getServletContext: " + request.getServletContext().getContextPath()); System.out.println("Context getServletPath: " + request.getServletPath()); System.out.println( "Context getSession().getServletContext(): " + request.getSession().getServletContext().getRealPath("/")); String urlPath = request.getRequestURL().toString(); urlPath = urlPath.substring(0, urlPath.length() - request.getRequestURI().length()) + request.getContextPath() + "/"; System.out.println("URL ::::: " + urlPath); String rutaReporte = urlPath + "resources/report/OrdenesIngreso/reporteTraspasoMateriaPrima.jasper"; System.out.println("rutaReporte: " + rutaReporte); String rutaImagen = urlPath + "resources/gfx/Medipiel-Logo.jpg"; System.out.println("RutaImagen: " + rutaImagen); String SUBREPORT_DIR = urlPath + "resources/report/OrdenesIngreso/"; System.out.println("SUBREPORT_DIR: " + SUBREPORT_DIR); // create a map of parameters to pass to the report. Map parameters = new HashMap(); parameters.put("SUBREPORT_DIR", SUBREPORT_DIR); parameters.put("usuario", pUsuario); /*parameters.put("pSucursal", new Integer(pSucursal));*/ parameters.put("ID", new Integer(pId)); // parameters.put("pRutaImagen", rutaImagen); // find file .jasper jasperReport = (JasperReport) JRLoader.loadObject(new URL(rutaReporte)); // fill JasperPrint using fillReport() method jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn); // save report to path // JasperExportManager.exportReportToPdfFile(jasperPrint,"C:/etiquetas/Etiqueta+"+pCodigoPre+"-"+pNombreElaborado+".pdf"); response.setContentType("application/pdf"); JasperExportManager.exportReportToPdfStream(jasperPrint, servletOutputStream); servletOutputStream.flush(); servletOutputStream.close(); } catch (Exception e) { // display stack trace in the browser e.printStackTrace(); System.out.println("Error al ingresar RerpoteVentas: " + e.getMessage()); StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"); response.getOutputStream().print(stringWriter.toString()); } }
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { try { Locales.setCurrent(request); if (Users.getCurrent() == null) { // for a bug in websphere portal 5.1 with Domino LDAP Users.setCurrent((String) request.getSession().getAttribute("xava.user")); } request.getParameter("application"); // for a bug in websphere 5.1 request.getParameter("module"); // for a bug in websphere 5.1 Tab tab = (Tab) request.getSession().getAttribute("xava_reportTab"); int[] selectedRowsNumber = (int[]) request.getSession().getAttribute("xava_selectedRowsReportTab"); Map[] selectedKeys = (Map[]) request.getSession().getAttribute("xava_selectedKeysReportTab"); int[] selectedRows = getSelectedRows(selectedRowsNumber, selectedKeys, tab); request.getSession().removeAttribute("xava_selectedRowsReportTab"); Integer columnCountLimit = (Integer) request.getSession().getAttribute("xava_columnCountLimitReportTab"); request.getSession().removeAttribute("xava_columnCountLimitReportTab"); setDefaultSchema(request); String user = (String) request.getSession().getAttribute("xava_user"); request.getSession().removeAttribute("xava_user"); Users.setCurrent(user); String uri = request.getRequestURI(); if (uri.endsWith(".pdf")) { InputStream is; JRDataSource ds; Map parameters = new HashMap(); synchronized (tab) { tab.setRequest(request); parameters.put("Title", tab.getTitle()); parameters.put("Organization", getOrganization()); parameters.put("Date", getCurrentDate()); for (String totalProperty : tab.getTotalPropertiesNames()) { parameters.put(totalProperty + "__TOTAL__", getTotal(request, tab, totalProperty)); } TableModel tableModel = getTableModel(request, tab, selectedRows, false, true, null); tableModel.getValueAt(0, 0); if (tableModel.getRowCount() == 0) { generateNoRowsPage(response); return; } is = getReport(request, response, tab, tableModel, columnCountLimit); ds = new JRTableModelDataSource(tableModel); } JasperPrint jprint = JasperFillManager.fillReport(is, parameters, ds); response.setContentType("application/pdf"); response.setHeader( "Content-Disposition", "inline; filename=\"" + getFileName(tab) + ".pdf\""); JasperExportManager.exportReportToPdfStream(jprint, response.getOutputStream()); } else if (uri.endsWith(".csv")) { String csvEncoding = XavaPreferences.getInstance().getCSVEncoding(); if (!Is.emptyString(csvEncoding)) { response.setCharacterEncoding(csvEncoding); } response.setContentType("text/x-csv"); response.setHeader( "Content-Disposition", "inline; filename=\"" + getFileName(tab) + ".csv\""); synchronized (tab) { tab.setRequest(request); response .getWriter() .print( TableModels.toCSV( getTableModel(request, tab, selectedRows, true, false, columnCountLimit))); } } else { throw new ServletException( XavaResources.getString("report_type_not_supported", "", ".pdf .csv")); } } catch (Exception ex) { log.error(ex.getMessage(), ex); throw new ServletException(XavaResources.getString("report_error")); } finally { request.getSession().removeAttribute("xava_reportTab"); } }
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { ServletOutputStream servletOutputStream = response.getOutputStream(); JasperReport jasperReport; JasperPrint jasperPrint; Connection conn = null; Properties props = new Properties(); // FacesContext.getCurrentInstance().responseComplete(); try { Context ctx = new InitialContext(); DataSource ds = (DataSource) ctx.lookup("java:jboss/datasources/BuffaloDS"); conn = ds.getConnection(); if (conn != null) { System.out.println("Conexion Exitosa JDBC com.edb.Driver..."); } else { System.out.println("Error Conexion JDBC com.edb.Driver..."); } } catch (Exception e) { // TODO: handle exception System.out.println("Error al conectar JDBC: " + e.getMessage()); } try { String pPaciente = request.getParameter("pPaciente"); String pCodigoPre = request.getParameter("pCodigoPre"); String pNombreElaborado = request.getParameter("pNombreElaborado"); String pPresentacion = request.getParameter("pPresentacion"); String pMedico = request.getParameter("pMedico"); String pUso = request.getParameter("pUso"); String pConservacion = request.getParameter("pConservacion"); String pFechaElaboracion = request.getParameter("pFechaElaboracion"); String pFechaVencimiento = request.getParameter("pFechaVencimiento"); System.out.println("Parametros Reporte: ......"); System.out.println("pPaciente: " + pPaciente); System.out.println("pCodigoPre: " + pCodigoPre); System.out.println("pNombreElaborado: " + pNombreElaborado); System.out.println("pPresentacion: " + pPresentacion); System.out.println("pMedico: " + pMedico); System.out.println("pUso: " + pUso); System.out.println("pConservacion: " + pConservacion); System.out.println("pFechaElaboracion: " + pFechaElaboracion); System.out.println("pFechaVencimiento: " + pFechaVencimiento); System.out.println("Conexion em: " + em.isOpen()); @SuppressWarnings("deprecation") String realPath = request.getRealPath("/"); System.out.println("Real Path: " + realPath); // load JasperDesign from XML and compile it into JasperReport System.out.println( "Context getServletContext: " + request.getServletContext().getContextPath()); System.out.println("Context getServletPath: " + request.getServletPath()); System.out.println( "Context getSession().getServletContext(): " + request.getSession().getServletContext().getRealPath("/")); String urlPath = request.getRequestURL().toString(); urlPath = urlPath.substring(0, urlPath.length() - request.getRequestURI().length()) + request.getContextPath() + "/"; System.out.println("URL ::::: " + urlPath); // create a map of parameters to pass to the report. Map parameters = new HashMap(); parameters.put("pPaciente", pPaciente); parameters.put("pCodigoPre", pCodigoPre); parameters.put("pNombreElaborado", pNombreElaborado); parameters.put("pPresentacion", pPresentacion); parameters.put("pMedico", pMedico); parameters.put("pUso", pUso); parameters.put("pConservacion", pConservacion); parameters.put("pFechaElaboracion", pFechaElaboracion); parameters.put("pFechaVencimiento", pFechaVencimiento); String rutaReporte = urlPath + "resources/report/EtiquetaGrande.jasper"; System.out.println("rutaReporte: " + rutaReporte); // find file .jasper jasperReport = (JasperReport) JRLoader.loadObject(new URL(rutaReporte)); // fill JasperPrint using fillReport() method jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn); // //save report to path // // JasperExportManager.exportReportToPdfFile(jasperPrint,"C:/etiquetas/Etiqueta+"+pCodigoPre+"-"+pNombreElaborado+".pdf"); response.setContentType("application/pdf"); JasperExportManager.exportReportToPdfStream(jasperPrint, servletOutputStream); servletOutputStream.flush(); servletOutputStream.close(); } catch (Exception e) { // display stack trace in the browser e.printStackTrace(); System.out.println("Error al ingresar ReporteEtiquetaGrande: " + e.getMessage()); StringWriter stringWriter = new StringWriter(); PrintWriter printWriter = new PrintWriter(stringWriter); e.printStackTrace(printWriter); response.setContentType("text/plain"); response.getOutputStream().print(stringWriter.toString()); } }