|
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 public class ReportValuationStock extends HttpSecureAppServlet {
33
34
35 public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
36 VariablesSecureApp vars = new VariablesSecureApp(request);
37
38 if (!Utility.hasProcessAccess(this, vars, "", "ReportValuationStock")) {
39 bdError(response, "AccessTableNoView", vars.getLanguage());
40 return;
41 }
42
43 if (vars.commandIn("DEFAULT", "RELATION")) {
44 String  strDate = vars.getGlobalVariable("inpDate", "ReportValuationStock|Date", DateTimeData.today(this));
45 String strWarehouse = vars.getGlobalVariable("inpmWarehouseId", "ReportValuationStock|Warehouse", "");
46 String strCategoryProduct = vars.getGlobalVariable("inpCategoryProduct", "ReportValuationStock|CategoryProduct", "");
47 printPageDataSheet(response, vars, strDate, strWarehouse, strCategoryProduct);
48 } else if (vars.commandIn("FIND")) {
49 String strDate = vars.getGlobalVariable("inpDate", "ReportValuationStock|Date", DateTimeData.today(this));
50 String strWarehouse = vars.getRequestGlobalVariable("inpmWarehouseId", "ReportValuationStock|Warehouse");
51 String strCategoryProduct = vars.getRequestGlobalVariable("inpCategoryProduct", "ReportValuationStock|CategoryProduct");
52 printPageDataSheet(response, vars, strDate, strWarehouse, strCategoryProduct);
53 } else pageError(response);
54 }
55
56 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strDate, String strWarehouse, String strCategoryProduct)
57 throws IOException, ServletException {
58 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
59 response.setContentType("text/html; charset=UTF-8");
60 PrintWriter out = response.getWriter();
61 String discard[]={"discard"};
62 XmlDocument xmlDocument;
63 ReportValuationStockData[] data= ReportValuationStockData.select(this, strDate , DateTimeData.nDaysAfter(this, strDate,"1"), strWarehouse, strCategoryProduct);
64 if (data == null || data.length == 0) {
65 data = ReportValuationStockData.set();
66 discard[0] = "sectionCategoryProduct";
67 }
68 if (vars.commandIn("DEFAULT")) {
69 discard[0] = "sectionCategoryProduct";
70 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportValuationStock", discard).createXmlDocument();
71 data = ReportValuationStockData.set();
72 } else {
73 xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportValuationStock", discard).createXmlDocument();
74 }
75
76 ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportValuationStock", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
77 toolbar.prepareSimpleToolBarTemplate();
78 xmlDocument.setParameter("toolbar", toolbar.toString());
79
80 try {
81 KeyMap key = new KeyMap(this, vars, "ReportValuationStock.html");
82 xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
83 } catch (Exception ex) {
84 throw new ServletException(ex);
85 }
86 try {
87 WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportValuationStock");
88 xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
89 xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
90 xmlDocument.setParameter("childTabContainer", tabs.childTabs());
91 xmlDocument.setParameter("theme", vars.getTheme());
92 NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportValuationStock.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
93 xmlDocument.setParameter("navigationBar", nav.toString());
94 LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportValuationStock.html", strReplaceWith);
95 xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
96 } catch (Exception ex) {
97 throw new ServletException(ex);
98 }
99 {
100 OBError myMessage = vars.getMessage("ReportValuationStock");
101 vars.removeMessage("ReportValuationStock");
102 if (myMessage!=null) {
103 xmlDocument.setParameter("messageType", myMessage.getType());
104 xmlDocument.setParameter("messageTitle", myMessage.getTitle());
105 xmlDocument.setParameter("messageMessage", myMessage.getMessage());
106 }
107 }
108
109 xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
110 xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
111 xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
112 xmlDocument.setParameter("date", strDate);
113 xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
114 xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
115 xmlDocument.setParameter("mWarehouseId", strWarehouse);
116 xmlDocument.setParameter("categoryProduct", strCategoryProduct);
117 try {
118 ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "M_Warehouse_ID", "M_Warehouse of Client", "", Utility.getContext(this, vars, "#User_Client",""), Utility.getContext(this, vars, "#AD_Client_ID", ""), 0);
119 Utility.fillSQLParameters(this, vars, null, comboTableData,"", "");
120 xmlDocument.setData("reportM_WAREHOUSEID","liststructure", comboTableData.select(false));
121 comboTableData = null;
122 } catch (Exception ex) {
123 throw new ServletException(ex);
124 }
125 try {
126 ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Product_Category_ID", "", "", Utility.getContext(this, vars, "#User_Org", ""), Utility.getContext(this, vars, "#User_Client", ""), 0);
127 Utility.fillSQLParameters(this, vars, null, comboTableData, "", strCategoryProduct);
128 xmlDocument.setData("reportM_PRODUCT_CATEGORYID","liststructure", comboTableData.select(false));
129 comboTableData = null;
130 } catch (Exception ex) {
131 throw new ServletException(ex);
132 }
133
134 xmlDocument.setData("structure1", data);
135 out.println(xmlDocument.print());
136 out.close();
137 }
138
139 public String getServletInfo() {
140 return "Servlet ReportValuationStock. This Servlet was made by Pablo Sarobe";
141 } }
143
144 |
Popular Tags |
Java API By Example, From Geeks To Geeks.