|
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
30 import org.openbravo.erpCommon.utility.DateTimeData;
31
32
33 import java.util.HashMap  ;
34 import net.sf.jasperreports.engine.*;
35 import net.sf.jasperreports.engine.design.JasperDesign;
36 import java.sql.Connection ;
37 import net.sf.jasperreports.engine.xml.JRXmlLoader;
38 import net.sf.jasperreports.engine.export.JRHtmlExporter;
39 import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
40
41 public class ReportWarehouseDetailInventoryJR extends HttpSecureAppServlet {
42
43
44 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
45 VariablesSecureApp vars = new VariablesSecureApp(request);
46
47 if (vars.commandIn("DEFAULT")) {
48 String strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportWarehouseDetailInventoryJR|DateFrom", "");
49 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportWarehouseDetailInventoryJR|DateTo", "");
50 String strWarehouse = vars.getStringParameter("inpmWarehouseId","");
51 printPageDataSheet(response, vars, strDateFrom, strDateTo, strWarehouse);
52 } else if (vars.commandIn("FIND")) {
53 String strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportWarehouseDetailInventoryJR|DateFrom");
54 String strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportWarehouseDetailInventoryJR|DateTo");
55 String strWarehouse = vars.getStringParameter("inpmWarehouseId");
56 printPagePDF(response, vars, strDateFrom, strDateTo, strWarehouse);
57 } else pageErrorPopUp(response);
58 }
59
60 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strWarehouse)
61 throws IOException, ServletException {
62 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
63 response.setContentType("text/html; charset=UTF-8");
64 PrintWriter out = response.getWriter();
65 XmlDocument xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportWarehouseDetailInventoryJR").createXmlDocument();
66
67 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportWarehouseDetailInventoryJR", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
68 toolbar.prepareSimpleToolBarTemplate();
69 xmlDocument.setParameter("toolbar", toolbar.toString());
70
71 try {
72 KeyMap key = new KeyMap(this, vars, "ReportWarehouseDetailInventoryJR.html");
73 xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
74 } catch (Exception ex) {
75 throw new ServletException(ex);
76 }
77 try {
78 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportWarehouseDetailInventoryJR");
79 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
80 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
81 xmlDocument.setParameter("childTabContainer", tabs.childTabs());
82 xmlDocument.setParameter("theme", vars.getTheme());
83 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportWarehouseDetailInventoryJR.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
84 xmlDocument.setParameter("navigationBar", nav.toString());
85 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportWarehouseDetailInventoryJR.html", strReplaceWith);
86 xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
87 } catch (Exception ex) {
88 throw new ServletException(ex);
89 }
90 {
91 OBError myMessage = vars.getMessage("ReportWarehouseDetailInventoryJR");
92 vars.removeMessage("ReportWarehouseDetailInventoryJR");
93 if (myMessage!=null) {
94 xmlDocument.setParameter("messageType", myMessage.getType());
95 xmlDocument.setParameter("messageTitle", myMessage.getTitle());
96 xmlDocument.setParameter("messageMessage", myMessage.getMessage());
97 }
98 }
99
100 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
101 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
102 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
103 xmlDocument.setParameter("dateFrom", strDateFrom);
104 xmlDocument.setParameter("dateTo", strDateTo);
105 xmlDocument.setParameter("mWarehouseId", strWarehouse);
106 xmlDocument.setParameter("dateFrom", strDateFrom);
107 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
108 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
109 xmlDocument.setParameter("dateTo", strDateTo);
110 xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
111 xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
112 try {
113 ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Warehouse_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportWarehouseDetailInventoryJR"), Utility.getContext(this, vars, "#User_Client", "ReportWarehouseDetailInventoryJR"), 0);
114 Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportWarehouseDetailInventoryJR", strWarehouse);
115 xmlDocument.setData("reportM_WAREHOUSEID","liststructure", comboTableData.select(false));
116 comboTableData = null;
117 } catch (Exception ex) {
118 throw new ServletException(ex);
119 }
120
121 out.println(xmlDocument.print());
122 out.close();
123 }
124
125 void printPagePDF(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strWarehouse) throws IOException, ServletException {
126 if (log4j.isDebugEnabled()) log4j.debug("Output: PDF");
127
128 String strDateFromSql = strDateFrom;
129
130 if (DateTimeData.compare(this, strDateFrom, DateTimeData.firstDay(this, DateTimeData.today(this))).equals("0")) strDateFromSql = DateTimeData.nDaysAfter(this, strDateFrom, "1");
131
132 ReportWarehouseDetailInventoryData[] data = ReportWarehouseDetailInventoryData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportWarehouseDetailInventory"), Utility.getContext(this, vars, "#User_Org", "ReportWarehouseDetailInventory"), strDateFromSql, DateTimeData.nDaysAfter(this, strDateTo,"1"), strWarehouse);
133
134 if (log4j.isDebugEnabled()) log4j.debug("data.length:"+data.length);
135
136 String strReportName = "@basedesign@/org/openbravo/erpCommon/ad_reports/ReportWarehouseDetailInventory.jrxml";
137 String strOutput = "pdf";
138 if (strOutput.equals("pdf")) response.setHeader("Content-disposition", "inline; filename=ReportWarehouseDetailInventory.pdf");
139
140 HashMap <String , Object > parameters = new HashMap <String , Object >();
141 parameters.put("REPORT_TITLE", "Warehouse inventory detail report");
142 parameters.put("REPORT_SUBTITLE", "Report consignment stock. From "+strDateFrom +" to "+strDateTo);
143 renderJR(vars, response, strReportName, strOutput, parameters, data, null );
144
145 }
146
147 public String getServletInfo() {
148 return "Servlet ReportWarehouseDetailInventory. This Servlet was made by Jon Alegria";
149 } }
151 |
Popular Tags |
Java API By Example, From Geeks To Geeks.