|
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 java.util.HashMap  ;
30
31 import net.sf.jasperreports.engine.*;
32 import net.sf.jasperreports.engine.design.JasperDesign;
33 import java.sql.Connection ;
34 import net.sf.jasperreports.engine.xml.JRXmlLoader;
35 import net.sf.jasperreports.engine.export.JRHtmlExporter;
36 import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
37
38 import org.openbravo.erpCommon.ad_combos.ProcessPlanComboData;
39
40 import org.openbravo.erpCommon.utility.DateTimeData;
41
42 public class ReportWorkRequirementDaily extends HttpSecureAppServlet {
43
44
45 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
46 VariablesSecureApp vars = new VariablesSecureApp(request);
47
48 if (!Utility.hasProcessAccess(this, vars, "", "RV_ReportWorkRequirementDaily")) {
49 bdError(response, "AccessTableNoView", vars.getLanguage());
50 return;
51 }
52
53 if (vars.commandIn("DEFAULT")) {
54 String strStartDateFrom = vars.getGlobalVariable("inpStartDateFrom", "ReportWorkRequirementDaily|StartDateFrom", "");
55 String strStartDateTo = vars.getGlobalVariable("inpStartDateTo", "ReportWorkRequirementDaily|StartDateTo", "");
56 String strmaProcessPlan = vars.getGlobalVariable("inpmaProcessPlanId", "ReportWorkRequirementDaily|MA_ProcessPlan_ID", "");
57 strStartDateTo = DateTimeData.today(this);
58 strStartDateFrom = DateTimeData.today(this);
59 printPageDataSheet(response, vars, strStartDateFrom, strStartDateTo, strmaProcessPlan);
60 } else if (vars.commandIn("FIND")) {
61 String strStartDateFrom = vars.getRequestGlobalVariable("inpStartDateFrom", "ReportWorkRequirementDaily|StartDateFrom");
62 String strStartDateTo = vars.getRequestGlobalVariable("inpStartDateTo", "ReportWorkRequirementDaily|StartDateTo");
63 String strmaProcessPlan = vars.getRequestGlobalVariable("inpmaProcessPlanId", "ReportWorkRequirementDaily|MA_ProcessPlan_ID");
64 printPageDataHtml(response, vars, strStartDateFrom, strStartDateTo, strmaProcessPlan);
65 } else pageError(response);
66 }
67
68 void printPageDataHtml(HttpServletResponse response, VariablesSecureApp vars, String strStartDateFrom, String strStartDateTo, String strmaProcessPlan)
69 throws IOException, ServletException {
70 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
71
72 ReportWorkRequirementDailyData[] data=null;
73
74 data = ReportWorkRequirementDailyData.select(this, vars.getLanguage(), Utility.getContext(this, vars, "#User_Client", "ReportWorkRequirementDaily"), Utility.getContext(this, vars, "#User_Org", "ReportWorkRequirementDaily"), strStartDateFrom, strStartDateTo, strmaProcessPlan);
75 for (int i=0; i<data.length; i++) {
76 ReportWorkRequirementDailyData[] product = ReportWorkRequirementDailyData.producedproduct(this, data[i].wrpid);
77 data[i].prodproduct = product[0].name;
78 String strqty = ReportWorkRequirementDailyData.inprocess(this, data[i].wrid, data[i].productid);
79 data[i].inprocess = strqty;
80 if (strqty == "") {
81 strqty = "0";
82 }
83 }
84
85
86 JasperPrint jasperPrint;
87
88 String strReportName = "@basedesign@/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEdit.jrxml";
89 String strOutput ="pdf";
90 String strTitle =classInfo.name;
91
92
93 if (strOutput.equals("pdf")) response.setHeader("Content-disposition", "inline; filename=ReportSalesOrderOpenItemEdit.pdf");
94
95 HashMap <String , Object > parameters = new HashMap <String , Object >();
96 parameters.put("Title", strTitle);
97 parameters.put("REPORT_TITLE", strTitle);
98 renderJR(vars, response, strReportName, strOutput, parameters, data, null );
99
100 }
101
102
103
104
105 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strStartDateFrom, String strStartDateTo, String strmaProcessPlan)
106 throws IOException, ServletException {
107 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
108 response.setContentType("text/html; charset=UTF-8");
109 PrintWriter out = response.getWriter();
110 XmlDocument xmlDocument=null;
111
112 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDaily").createXmlDocument();
113
114
115 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportWorkRequirementDaily", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
116 toolbar.prepareSimpleToolBarTemplate();
117 xmlDocument.setParameter("toolbar", toolbar.toString());
118
119 try {
120 KeyMap key = new KeyMap(this, vars, "ReportWorkRequirementDaily.html");
121 xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
122 } catch (Exception ex) {
123 throw new ServletException(ex);
124 }
125 try {
126 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportWorkRequirementDaily");
127 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
128 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
129 xmlDocument.setParameter("childTabContainer", tabs.childTabs());
130 xmlDocument.setParameter("theme", vars.getTheme());
131 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportWorkRequirementDaily.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
132 xmlDocument.setParameter("navigationBar", nav.toString());
133 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportWorkRequirementDaily.html", strReplaceWith);
134 xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
135 } catch (Exception ex) {
136 throw new ServletException(ex);
137 }
138 {
139 OBError myMessage = vars.getMessage("ReportWorkRequirementDaily");
140 vars.removeMessage("ReportWorkRequirementDaily");
141 if (myMessage!=null) {
142 xmlDocument.setParameter("messageType", myMessage.getType());
143 xmlDocument.setParameter("messageTitle", myMessage.getTitle());
144 xmlDocument.setParameter("messageMessage", myMessage.getMessage());
145 }
146 }
147
148 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
149 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
150 xmlDocument.setParameter("maProcessPlan", strmaProcessPlan);
151 xmlDocument.setParameter("startDateFrom", strStartDateFrom);
152 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
153 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
154 xmlDocument.setParameter("startDateTo", strStartDateTo);
155 xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
156 xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
157 xmlDocument.setData("reportMA_PROCESSPLAN", "liststructure", ProcessPlanComboData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportWorkRequirementDaily"), Utility.getContext(this, vars, "#User_Org", "ReportWorkRequirementDaily")));
158
159 out.println(xmlDocument.print());
160 out.close();
161 }
162
163
227 public String getServletInfo() {
228 return "Servlet ReportWorkRequirementDaily.";
229 } }
231 |
Popular Tags |
Java API By Example, From Geeks To Geeks.