You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ofbiz.apache.org by jl...@apache.org on 2007/12/16 23:38:02 UTC
svn commit: r604728 - in /ofbiz/trunk:
applications/content/src/org/ofbiz/content/survey/ framework/webapp/
framework/webapp/src/org/ofbiz/webapp/view/
Author: jleroux
Date: Sun Dec 16 14:38:02 2007
New Revision: 604728
URL: http://svn.apache.org/viewvc?rev=604728&view=rev
Log:
A patch from Fabien Carrion "To permit to have a view with jasperreports to export to excel using the poi api, or the jxls api." (https://issues.apache.org/jira/browse/OFBIZ-1250) - OFBIZ-1250
JasperReports is any longer used in OFBIz but this might be helpful in some occasions. As it changes anything (I reviewed but no tested) I prefer to commit than ignore.
Added:
ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java (with props)
ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java (with props)
Modified:
ofbiz/trunk/applications/content/src/org/ofbiz/content/survey/PdfSurveyServices.java
ofbiz/trunk/framework/webapp/build.xml
Modified: ofbiz/trunk/applications/content/src/org/ofbiz/content/survey/PdfSurveyServices.java
URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/content/src/org/ofbiz/content/survey/PdfSurveyServices.java?rev=604728&r1=604727&r2=604728&view=diff
==============================================================================
--- ofbiz/trunk/applications/content/src/org/ofbiz/content/survey/PdfSurveyServices.java (original)
+++ ofbiz/trunk/applications/content/src/org/ofbiz/content/survey/PdfSurveyServices.java Sun Dec 16 14:38:02 2007
@@ -127,9 +127,9 @@
} else if (type == AcroFields.FIELD_TYPE_LIST || type == AcroFields.FIELD_TYPE_COMBO) {
surveyQuestion.set("surveyQuestionTypeId", "OPTION");
// TODO: handle these specially with the acroFields.getListOptionDisplay (and getListOptionExport?)
- String[] listOptionDisplayArray = acroFields.getListOptionDisplay(fieldName);
+ /*String[] listOptionDisplayArray = acroFields.getListOptionDisplay(fieldName);
String[] listOptionExportArray = acroFields.getListOptionExport(fieldName);
- Debug.logInfo("listOptionDisplayArray: " + listOptionDisplayArray + "; listOptionExportArray: " + listOptionExportArray, module);
+ Debug.logInfo("listOptionDisplayArray: " + listOptionDisplayArray + "; listOptionExportArray: " + listOptionExportArray, module);*/
} else {
surveyQuestion.set("surveyQuestionTypeId", "TEXT_SHORT");
Debug.logWarning("Building Survey from PDF, fieldName=[" + fieldName + "]: don't know how to handle field type: " + type + "; defaulting to short text", module);
Modified: ofbiz/trunk/framework/webapp/build.xml
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/webapp/build.xml?rev=604728&r1=604727&r2=604728&view=diff
==============================================================================
--- ofbiz/trunk/framework/webapp/build.xml (original)
+++ ofbiz/trunk/framework/webapp/build.xml Sun Dec 16 14:38:02 2007
@@ -91,6 +91,8 @@
<!-- JasperReports dependent files -->
<exclude name="org/ofbiz/webapp/view/JasperReportsPdfViewHandler.java"/>
<exclude name="org/ofbiz/webapp/view/JasperReportsXmlViewHandler.java"/>
+ <exclude name="org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java"/>
+ <exclude name="org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java"/>
<!-- JPublish/EdenLib dependent files -->
<exclude name="org/ofbiz/webapp/view/GenericViewRenderer.java"/>
<exclude name="org/ofbiz/webapp/view/JPublishViewHandler.java"/>
Added: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java?rev=604728&view=auto
==============================================================================
--- ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java (added)
+++ ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java Sun Dec 16 14:38:02 2007
@@ -0,0 +1,137 @@
+/*******************************************************************************
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ *******************************************************************************/
+package org.ofbiz.webapp.view;
+
+import java.io.IOException;
+import java.io.InputStream;
+import java.util.Map;
+
+import javax.servlet.ServletContext;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import net.sf.jasperreports.engine.JRDataSource;
+import net.sf.jasperreports.engine.JREmptyDataSource;
+import net.sf.jasperreports.engine.JasperCompileManager;
+import net.sf.jasperreports.engine.JasperFillManager;
+import net.sf.jasperreports.engine.JasperPrint;
+import net.sf.jasperreports.engine.JasperReport;
+import net.sf.jasperreports.engine.export.JExcelApiExporter;
+import net.sf.jasperreports.engine.export.JExcelApiExporterParameter;
+
+import org.ofbiz.base.util.Debug;
+import org.ofbiz.base.util.UtilHttp;
+import org.ofbiz.base.util.cache.UtilCache;
+import org.ofbiz.webapp.control.ContextFilter;
+import org.ofbiz.entity.GenericDelegator;
+import org.ofbiz.entity.jdbc.ConnectionFactory;
+
+
+/**
+ * Handles JasperReports JXls view rendering
+ */
+public class JasperReportsJXlsViewHandler implements ViewHandler {
+
+ public static final String module = JasperReportsJXlsViewHandler.class.getName();
+
+ protected ServletContext context;
+ public static UtilCache jasperReportsCompiledCache = new UtilCache("webapp.JasperReportsCompiled");
+
+ public void init(ServletContext context) throws ViewHandlerException {
+ this.context = context;
+ }
+
+ public void render(String name, String page, String info, String contentType, String encoding, HttpServletRequest request, HttpServletResponse response) throws ViewHandlerException {
+ // some containers call filters on EVERY request, even forwarded ones,
+ // so let it know that it came from the control servlet
+
+ if (request == null) {
+ throw new ViewHandlerException("The HttpServletRequest object was null, how did that happen?");
+ }
+ if (page == null || page.length() == 0) {
+ throw new ViewHandlerException("View page was null or empty, but must be specified");
+ }
+ if (info == null || info.length() == 0) {
+ Debug.logInfo("View info string was null or empty, (optionally used to specify an Entity that is mapped to the Entity Engine datasource that the report will use).", module);
+ }
+
+ // tell the ContextFilter we are forwarding
+ request.setAttribute(ContextFilter.FORWARDED_FROM_SERVLET, new Boolean(true));
+ GenericDelegator delegator = (GenericDelegator) request.getAttribute("delegator");
+ if (delegator == null) {
+ throw new ViewHandlerException("The delegator object was null, how did that happen?");
+ }
+
+ try {
+ JasperReport report = (JasperReport) jasperReportsCompiledCache.get(page);
+ if (report == null) {
+ synchronized (this) {
+ report = (JasperReport) jasperReportsCompiledCache.get(page);
+ if (report == null) {
+ InputStream is = context.getResourceAsStream(page);
+ report = JasperCompileManager.compileReport(is);
+ jasperReportsCompiledCache.put(page, report);
+ }
+ }
+ }
+
+ response.setContentType("application/xls");
+
+ Map parameters = (Map) request.getAttribute("jrParameters");
+ if (parameters == null) {
+ parameters = UtilHttp.getParameterMap(request);
+ }
+
+ JRDataSource jrDataSource = (JRDataSource) request.getAttribute("jrDataSource");
+ JasperPrint jp = null;
+ if (jrDataSource == null) {
+ String datasourceName = delegator.getEntityHelperName(info);
+ if (datasourceName != null && datasourceName.length() > 0) {
+ Debug.logInfo("Filling report with connection from datasource: " + datasourceName, module);
+ jp = JasperFillManager.fillReport(report, parameters, ConnectionFactory.getConnection(datasourceName));
+ } else {
+ Debug.logInfo("Filling report with an empty JR datasource", module);
+ jp = JasperFillManager.fillReport(report, parameters, new JREmptyDataSource());
+ }
+ } else {
+ Debug.logInfo("Filling report with a passed in jrDataSource", module);
+ jp = JasperFillManager.fillReport(report, parameters, jrDataSource);
+ }
+
+ if (jp.getPages().size() < 1) {
+ throw new ViewHandlerException("Report is Empty (no results?)");
+ } else {
+ Debug.logInfo("Got report, there are " + jp.getPages().size() + " pages.", module);
+ }
+ JExcelApiExporter exporter = new JExcelApiExporter();
+ exporter.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jp);
+ exporter.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, response.getOutputStream());
+ exporter.exportReport();
+
+ } catch (IOException ie) {
+ throw new ViewHandlerException("IO Error in report", ie);
+ } catch (java.sql.SQLException e) {
+ throw new ViewHandlerException("Database error while running report", e);
+ } catch (Exception e) {
+ throw new ViewHandlerException("Error in report", e);
+ // } catch (ServletException se) {
+ // throw new ViewHandlerException("Error in region", se.getRootCause());
+ }
+ }
+}
Propchange: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java
------------------------------------------------------------------------------
svn:keywords = "Date Rev Author URL Id"
Propchange: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsJXlsViewHandler.java
------------------------------------------------------------------------------
svn:mime-type = text/plain
Added: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java
URL: http://svn.apache.org/viewvc/ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java?rev=604728&view=auto
==============================================================================
--- ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java (added)
+++ ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java Sun Dec 16 14:38:02 2007
@@ -0,0 +1,138 @@
+/*******************************************************************************
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied. See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ *******************************************************************************/
+package org.ofbiz.webapp.view;
+
+import java.io.IOException;
+import java.io.InputStream;
+import java.util.Map;
+
+import javax.servlet.ServletContext;
+import javax.servlet.http.HttpServletRequest;
+import javax.servlet.http.HttpServletResponse;
+
+import net.sf.jasperreports.engine.JRDataSource;
+import net.sf.jasperreports.engine.JREmptyDataSource;
+import net.sf.jasperreports.engine.JasperCompileManager;
+import net.sf.jasperreports.engine.JasperFillManager;
+import net.sf.jasperreports.engine.JasperPrint;
+import net.sf.jasperreports.engine.JasperReport;
+import net.sf.jasperreports.engine.export.JRXlsExporter;
+import net.sf.jasperreports.engine.export.JRXlsExporterParameter;
+
+import org.ofbiz.base.util.Debug;
+import org.ofbiz.base.util.UtilHttp;
+import org.ofbiz.base.util.cache.UtilCache;
+import org.ofbiz.webapp.control.ContextFilter;
+import org.ofbiz.entity.GenericDelegator;
+import org.ofbiz.entity.jdbc.ConnectionFactory;
+
+
+/**
+ * Handles JasperReports PoiXls view rendering
+ */
+public class JasperReportsPoiXlsViewHandler implements ViewHandler {
+
+ public static final String module = JasperReportsPoiXlsViewHandler.class.getName();
+
+ protected ServletContext context;
+ public static UtilCache jasperReportsCompiledCache = new UtilCache("webapp.JasperReportsCompiled");
+
+ public void init(ServletContext context) throws ViewHandlerException {
+ this.context = context;
+ }
+
+ public void render(String name, String page, String info, String contentType, String encoding, HttpServletRequest request, HttpServletResponse response) throws ViewHandlerException {
+ // some containers call filters on EVERY request, even forwarded ones,
+ // so let it know that it came from the control servlet
+
+ if (request == null) {
+ throw new ViewHandlerException("The HttpServletRequest object was null, how did that happen?");
+ }
+ if (page == null || page.length() == 0) {
+ throw new ViewHandlerException("View page was null or empty, but must be specified");
+ }
+ if (info == null || info.length() == 0) {
+ Debug.logInfo("View info string was null or empty, (optionally used to specify an Entity that is mapped to the Entity Engine datasource that the report will use).", module);
+ }
+
+ // tell the ContextFilter we are forwarding
+ request.setAttribute(ContextFilter.FORWARDED_FROM_SERVLET, new Boolean(true));
+ GenericDelegator delegator = (GenericDelegator) request.getAttribute("delegator");
+ if (delegator == null) {
+ throw new ViewHandlerException("The delegator object was null, how did that happen?");
+ }
+
+ try {
+ JasperReport report = (JasperReport) jasperReportsCompiledCache.get(page);
+ if (report == null) {
+ synchronized (this) {
+ report = (JasperReport) jasperReportsCompiledCache.get(page);
+ if (report == null) {
+ InputStream is = context.getResourceAsStream(page);
+ report = JasperCompileManager.compileReport(is);
+ jasperReportsCompiledCache.put(page, report);
+ }
+ }
+ }
+
+ response.setContentType("application/xls");
+
+ Map parameters = (Map) request.getAttribute("jrParameters");
+ if (parameters == null) {
+ parameters = UtilHttp.getParameterMap(request);
+ }
+
+ JRDataSource jrDataSource = (JRDataSource) request.getAttribute("jrDataSource");
+ JasperPrint jp = null;
+ if (jrDataSource == null) {
+ String datasourceName = delegator.getEntityHelperName(info);
+ if (datasourceName != null && datasourceName.length() > 0) {
+ Debug.logInfo("Filling report with connection from datasource: " + datasourceName, module);
+ jp = JasperFillManager.fillReport(report, parameters, ConnectionFactory.getConnection(datasourceName));
+ } else {
+ Debug.logInfo("Filling report with an empty JR datasource", module);
+ jp = JasperFillManager.fillReport(report, parameters, new JREmptyDataSource());
+ }
+ } else {
+ Debug.logInfo("Filling report with a passed in jrDataSource", module);
+ jp = JasperFillManager.fillReport(report, parameters, jrDataSource);
+ }
+
+ if (jp.getPages().size() < 1) {
+ throw new ViewHandlerException("Report is Empty (no results?)");
+ } else {
+ Debug.logInfo("Got report, there are " + jp.getPages().size() + " pages.", module);
+ }
+ JRXlsExporter exporter = new JRXlsExporter();
+ exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT, jp);
+ exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, response.getOutputStream());
+ exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
+ exporter.exportReport();
+
+ } catch (IOException ie) {
+ throw new ViewHandlerException("IO Error in report", ie);
+ } catch (java.sql.SQLException e) {
+ throw new ViewHandlerException("Database error while running report", e);
+ } catch (Exception e) {
+ throw new ViewHandlerException("Error in report", e);
+ // } catch (ServletException se) {
+ // throw new ViewHandlerException("Error in region", se.getRootCause());
+ }
+ }
+}
Propchange: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java
------------------------------------------------------------------------------
svn:keywords = "Date Rev Author URL Id"
Propchange: ofbiz/trunk/framework/webapp/src/org/ofbiz/webapp/view/JasperReportsPoiXlsViewHandler.java
------------------------------------------------------------------------------
svn:mime-type = text/plain