Package org.efs.openreports.engine.output

Examples of org.efs.openreports.engine.output.QueryEngineOutput


        QueryReportEngine queryEngine = new QueryReportEngine(dataSourceProvider, directoryProvider, propertiesProvider);       
       
        // set ExportType to null so QueryReportEngine just returns a list of results
        input.setExportType(null);
       
        QueryEngineOutput output = (QueryEngineOutput) queryEngine
            .generateReport(input);   
       
        jxlsReportMap.put(ORStatics.JXLS_REPORT_RESULTS, output.getResults());
      }
      else
      {
        conn = dataSourceProvider.getConnection(report.getDataSource().getId());
        JXLSReportManagerImpl rm = new JXLSReportManagerImpl(conn, jxlsReportMap, dataSourceProvider);
        jxlsReportMap.put("rm", rm);
      }

      FileInputStream template = new FileInputStream(directoryProvider
          .getReportDirectory()
          + report.getFile());

      XLSTransformer transformer = new XLSTransformer();
      HSSFWorkbook workbook = transformer.transformXLS(template, jxlsReportMap);     

      ByteArrayOutputStream out = new ByteArrayOutputStream();
      workbook.write(out);
     
      ReportEngineOutput output = new ReportEngineOutput();
      output.setContent(out.toByteArray());
      output.setContentType(ReportEngineOutput.CONTENT_TYPE_XLS);
     
      return output;
    }
    catch(Exception e)
    {
View Full Code Here


             * put the results in the VelocityContext for use in templates
             */
            if (report.getQuery() != null && report.getQuery().trim().length() > 0)
            {
                QueryReportEngine queryReport = new QueryReportEngine(dataSourceProvider, directoryProvider, propertiesProvider);
                QueryEngineOutput queryOutput = (QueryEngineOutput) queryReport.generateReport(input);
               
                context.put("results", queryOutput.getResults());
                context.put("properties", queryOutput.getProperties());
            }
          
            StringWriter writer = new StringWriter();
           
            Template template = Velocity.getTemplate(report.getFile());          
View Full Code Here

      else
      {
        QueryReportEngine queryReportEngine = new QueryReportEngine(
            dataSourceProvider, directoryProvider, propertiesProvider);
       
        QueryEngineOutput output = (QueryEngineOutput) queryReportEngine.generateReport(input);       
       
        session.put(ORStatics.QUERY_REPORT_RESULTS, output.getResults());
       
        session.put(ORStatics.QUERY_REPORT_PROPERTIES, output.getProperties());
      }     

      reportLog.setEndTime(new Date());
      reportLog.setStatus(ReportLog.STATUS_SUCCESS);
      reportLogProvider.updateReportLog(reportLog);
View Full Code Here

            dynaProperties[i].getType().getName());
      }

      rs.close();
     
      QueryEngineOutput output = new QueryEngineOutput();
     
      if (input.getExportType() == null)
      {
        output.setResults(results);
        output.setProperties(properties);
      }
      else
      {
        // Use DisplayTag to generate scheduled QueryReports
        MockDisplayTablePageContext pageContext = null;       
       
        if (input.getExportType() == ExportType.CSV)
        {
          pageContext = new MockDisplayTablePageContext(MockDisplayTablePageContext.EXPORT_TYPE_CSV, applicationContext);
          output.setContentType(ReportEngineOutput.CONTENT_TYPE_CSV);
         
        }
        else if (input.getExportType() == ExportType.XLS)
        {
          pageContext = new MockDisplayTablePageContext(MockDisplayTablePageContext.EXPORT_TYPE_XLS, applicationContext);
          output.setContentType(ReportEngineOutput.CONTENT_TYPE_XLS);
        }
        else
        {
          pageContext = new MockDisplayTablePageContext(MockDisplayTablePageContext.EXPORT_TYPE_PDF, applicationContext);
          output.setContentType(ReportEngineOutput.CONTENT_TYPE_PDF);
        }
         
        // create tag
        MockDisplayTableTag displayTag = new MockDisplayTableTag();
        displayTag.setPageContext(pageContext);
        displayTag.setName(results);     
        displayTag.doStartTag();
         
        // add columns
        for (int i = 0; i < properties.length; i++)
        {
          ColumnTag column = new ColumnTag();         
          column.setParent(displayTag);
          column.setProperty(properties[i].getName());
          column.setTitle(properties[i].getDisplayName());
          column.setDecorator(properties[i].getDecorator());
          column.setPageContext(pageContext)
          column.doStartTag();
          column.doEndTag();
        }
       
        // call doAfterBody for each row in the results
        for (int i= 0; i < results.size(); i++)
        {
          displayTag.doAfterBody()
        }       
       
        // call doEndTag to perform the export
        displayTag.doEndTag();
       
        HashMap<?,?> map = (HashMap<?,?>) pageContext.getRequest().getAttribute(TableTag.FILTER_CONTENT_OVERRIDE_BODY);
        Object content = map.get(TableTagParameters.BEAN_BODY);
       
        if (content instanceof String)
        {
          output.setContent(((String)content).getBytes());
        }
        else
        {
          output.setContent((byte[])content);
        }
      }
     
      return output;
    }
View Full Code Here

TOP

Related Classes of org.efs.openreports.engine.output.QueryEngineOutput

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.