1 19 package org.openbravo.erpCommon.ad_reports; 20 21 import org.openbravo.erpCommon.utility.*; 22 import org.openbravo.erpCommon.businessUtility.WindowTabs; 23 import org.openbravo.base.secureApp.HttpSecureAppServlet; 24 import org.openbravo.base.secureApp.VariablesSecureApp; 25 import org.openbravo.xmlEngine.XmlDocument; 26 import java.io.*; 27 import javax.servlet.*; 28 import javax.servlet.http.*; 29 import org.openbravo.utils.Replace; 30 import java.util.HashMap ; 31 32 import net.sf.jasperreports.engine.*; 33 import net.sf.jasperreports.engine.design.JasperDesign; 34 import java.sql.Connection ; 35 import net.sf.jasperreports.engine.xml.JRXmlLoader; 36 import net.sf.jasperreports.engine.export.JRHtmlExporter; 37 import net.sf.jasperreports.engine.export.JRHtmlExporterParameter; 38 39 public class ReportSalesOrderOpenItemJR extends HttpSecureAppServlet { 40 41 42 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException { 43 VariablesSecureApp vars = new VariablesSecureApp(request); 44 45 if (!Utility.hasProcessAccess(this, vars, "", "RV_ReportSalesOrderOpenItemJR")) { 46 bdError(response, "AccessTableNoView", vars.getLanguage()); 47 return; 48 } 49 50 if (vars.commandIn("DEFAULT")) { 51 String strWarehouse = vars.getGlobalVariable("inpWarehouse", "ReportSalesOrderOpenItemJR|Warehouse", ""); 52 printPageDataSheet(response, vars, strWarehouse); 53 } else if (vars.commandIn("FIND")) { 54 String strWarehouse = vars.getRequestGlobalVariable("inpWarehouse", "ReportSalesOrderOpenItemJR|Warehouse"); 55 printPageDataHtml(response, vars, strWarehouse); 56 } else pageError(response); 57 } 58 59 void printPageDataHtml(HttpServletResponse response, VariablesSecureApp vars, String strWarehouse) 60 throws IOException, ServletException { 61 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 62 response.setContentType("text/html; charset=UTF-8"); 63 String discard[]={"discard"}; 65 66 JasperPrint jasperPrint; 67 68 String strReportName = "@basedesign@/org/openbravo/erpCommon/ad_reports/ReportSalesOrderOpenItemEdit.jrxml"; 69 String strOutput = "html"; 70 if (strOutput.equals("pdf")) response.setHeader("Content-disposition", "inline; filename=ReportSalesOrderOpenItemEdit.pdf"); 71 72 ReportSalesOrderOpenItemData[] data = ReportSalesOrderOpenItemData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportSalesOrderOpenItemJR"), Utility.getContext(this, vars, "#User_Org", "ReportSalesOrderOpenItemJR"), strWarehouse); 73 HashMap <String , Object > parameters = new HashMap <String , Object >(); 74 parameters.put("REPORT_TITLE", ""); 75 renderJR(vars, response, strReportName, strOutput, parameters, data, null ); 77 78 94 } 95 96 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strWarehouse) 97 throws IOException, ServletException { 98 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 99 response.setContentType("text/html; charset=UTF-8"); 100 PrintWriter out = response.getWriter(); 101 102 103 104 105 String discard[]={"discard"}; 106 XmlDocument xmlDocument; 107 108 109 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportSalesOrderOpenItemJR").createXmlDocument(); 110 111 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportSalesOrderOpenItemJR", false, "", "", "",false, "ad_reports", strReplaceWith, false, true); 112 toolbar.prepareSimpleToolBarTemplate(); 113 xmlDocument.setParameter("toolbar", toolbar.toString()); 114 115 try { 116 KeyMap key = new KeyMap(this, vars, "ReportSalesOrderOpenItemJR.html"); 117 xmlDocument.setParameter("keyMap", key.getReportKeyMaps()); 118 } catch (Exception ex) { 119 throw new ServletException(ex); 120 } 121 try { 122 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportSalesOrderOpenItemJR"); 123 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs()); 124 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs()); 125 xmlDocument.setParameter("childTabContainer", tabs.childTabs()); 126 xmlDocument.setParameter("theme", vars.getTheme()); 127 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportSalesOrderOpenItemJR.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb()); 128 xmlDocument.setParameter("navigationBar", nav.toString()); 129 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportSalesOrderOpenItemJR.html", strReplaceWith); 130 xmlDocument.setParameter("leftTabs", lBar.manualTemplate()); 131 } catch (Exception ex) { 132 throw new ServletException(ex); 133 } 134 { 135 OBError myMessage = vars.getMessage("ReportSalesOrderOpenItemJR"); 136 vars.removeMessage("ReportSalesOrderOpenItemJR"); 137 if (myMessage!=null) { 138 xmlDocument.setParameter("messageType", myMessage.getType()); 139 xmlDocument.setParameter("messageTitle", myMessage.getTitle()); 140 xmlDocument.setParameter("messageMessage", myMessage.getMessage()); 141 } 142 } 143 144 145 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n"); 146 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";"); 147 xmlDocument.setParameter("mWarehouseId", strWarehouse); 148 try { 149 ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Warehouse_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportSalesOrderOpenItemJR"), Utility.getContext(this, vars, "#User_Client", "ReportSalesOrderOpenItemJR"), 0); 150 Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportSalesOrderOpenItemJR", strWarehouse); 151 xmlDocument.setData("reportM_WAREHOUSESHIPPER","liststructure", comboTableData.select(false)); 152 comboTableData = null; 153 } catch (Exception ex) { 154 throw new ServletException(ex); 155 } 156 157 158 out.println(xmlDocument.print()); 159 out.close(); 160 } 161 162 228 public String getServletInfo() { 229 return "Servlet ReportSalesOrderOpenItem. This Servlet was made by Jon AlegrÃa"; 230 } } 232 233 | Popular Tags |