<%@ page contentType="text/html;charset=windows-1252"%>
<%@ page errorPage="error.jsp" %>
<%@ page import="net.sf.jasperreports.engine.*,net.sf.jasperreports.engine.util.JRProperties" %>
<%@ page import="net.sf.jasperreports.engine.util.*" %>
<%@ page import="net.sf.jasperreports.engine.export.*" %>
<%@ page import="net.sf.jasperreports.j2ee.servlets.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%
/*Recupero variables*/
//String nombre_articulo= request.getParameter("nombre_articulo");
//int nombre_articulo= Integer.parseInt(request.getParameter("nombre_articulo"));

String clave= request.getParameter ("var1");

%>

<%///=application.getRealPath("/reports/cuadro_EB.jrxml")%>

<%
	// JasperCompileManager.compileReportToFile(application.getRealPath("/reports/evalyrecomendacionesreport.jrxml"));
%>


<%
	File reportFile = new File(application.getRealPath("/reports/evalyrecomendacionesreport.jasper"));
  	if (!reportFile.exists())
		throw new JRRuntimeException("File evalyrecomendacionesreport.jasper not found. The report design must be compiled first.");

	JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFile.getPath());

	Map parameters = new HashMap();
	parameters.put("ReportTitle", "Address Report");
	parameters.put("BaseDir", reportFile.getParentFile());
	parameters.put("p_imagen", application.getRealPath("/img/banner_reportes.jpg"));	
	parameters.put("p_idprog",clave);

	Class.forName ("org.postgresql.Driver");
	Connection connection = DriverManager.getConnection ("jdbc:postgresql://localhost:5432/sisepef","postgres","postgres");		
	//Connection connection = DriverManager.getConnection ("jdbc:postgresql://localhost:5432/mp", "postgres", "admin");	
	
	byte[] bytes = 
		JasperRunManager.runReportToPdf(
			reportFile.getPath(), 
			parameters,
			connection
			//new JREmptyDataSource() 
			);
	connection.close();
	
	response.setContentType("application/pdf");
	response.setContentLength(bytes.length);
	ServletOutputStream ouputStream = response.getOutputStream();
	ouputStream.write(bytes, 0, bytes.length);
	ouputStream.flush();
	ouputStream.close();
%>