KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > org > openbravo > erpCommon > ad_reports > ReportExpense


1 /*
2  *************************************************************************
3  * The contents of this file are subject to the Openbravo Public License
4  * Version 1.0 (the "License"), being the Mozilla Public License
5  * Version 1.1 with a permitted attribution clause; you may not use this
6  * file except in compliance with the License. You may obtain a copy of
7  * the License at http://www.openbravo.com/legal/license.html
8  * Software distributed under the License is distributed on an "AS IS"
9  * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
10  * License for the specific language governing rights and limitations
11  * under the License.
12  * The Original Code is Openbravo ERP.
13  * The Initial Developer of the Original Code is Openbravo SL
14  * All portions are Copyright (C) 2001-2006 Openbravo SL
15  * All Rights Reserved.
16  * Contributor(s): ______________________________________.
17  ************************************************************************
18  */

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 ReportExpense extends HttpSecureAppServlet {
33
34
35   public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
36     VariablesSecureApp vars = new VariablesSecureApp(request);
37
38     if (vars.commandIn("DEFAULT")) {
39       String JavaDoc strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportExpense|dateFrom", "");
40       String JavaDoc strDateTo = vars.getGlobalVariable("inpDateTo", "ReportExpense|dateTo", "");
41       String JavaDoc strcBpartnerId = vars.getGlobalVariable("inpcBPartnerId", "ReportExpense|cBpartnerId", "");
42       String JavaDoc strPartner = vars.getGlobalVariable("inpPartner", "ReportExpense|partner", "");
43       printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner);
44     } else if (vars.commandIn("DIRECT")) {
45       String JavaDoc strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportExpense|dateFrom", "");
46       String JavaDoc strDateTo = vars.getGlobalVariable("inpDateTo", "ReportExpense|dateTo", "");
47       String JavaDoc strcBpartnerId = vars.getGlobalVariable("inpcBPartnerId", "ReportExpense|cBpartnerId", "");
48       String JavaDoc strPartner = vars.getGlobalVariable("inpPartner", "ReportExpense|partner", "");
49       setHistoryCommand(request, "DIRECT");
50       printPageDataHtml(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner);
51     } else if (vars.commandIn("FIND")) {
52       String JavaDoc strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportExpense|dateFrom");
53       String JavaDoc strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportExpense|dateTo");
54       String JavaDoc strcBpartnerId = vars.getRequestGlobalVariable("inpcBPartnerId", "ReportExpense|cBpartnerId");
55       String JavaDoc strPartner = vars.getRequestGlobalVariable("inpPartner", "ReportExpense|partner");
56       setHistoryCommand(request, "DIRECT");
57       printPageDataHtml(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner);
58     } else pageError(response);
59   }
60
61   void printPageDataHtml(HttpServletResponse response, VariablesSecureApp vars, String JavaDoc strDateFrom, String JavaDoc strDateTo, String JavaDoc strcBpartnerId, String JavaDoc strPartner)
62     throws IOException, ServletException {
63     if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
64     response.setContentType("text/html; charset=UTF-8");
65     PrintWriter out = response.getWriter();
66     XmlDocument xmlDocument=null;
67     ReportExpenseData[] data1 = null;
68    
69     if (vars.commandIn("DEFAULT") && strDateFrom.equals("") && strDateTo.equals("") && strcBpartnerId.equals("") && strPartner.equals("")){
70       /*discard[0] = "sectionPartner";
71       data1 = ReportExpenseData.set();
72       strDateFrom = DateTimeData.weekBefore(this);
73       strDateTo = DateTimeData.today(this);*/

74       printPageDataSheet(response, vars, strDateFrom, strDateTo, strcBpartnerId, strPartner);
75     } else {
76       data1 = ReportExpenseData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportExpense"), Utility.getContext(this, vars, "#User_Org", "ReportExpense"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strPartner);
77     }
78     xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportExpenseEdit").createXmlDocument();
79
80
81     
82
83
84     xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
85     xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
86    
87
88     xmlDocument.setData("structure1", data1);
89
90     out.println(xmlDocument.print());
91     out.close();
92   }
93   
94   void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String JavaDoc strDateFrom, String JavaDoc strDateTo, String JavaDoc strcBpartnerId, String JavaDoc strPartner)
95     throws IOException, ServletException {
96     if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
97     response.setContentType("text/html; charset=UTF-8");
98     PrintWriter out = response.getWriter();
99     XmlDocument xmlDocument=null;
100     ReportExpenseData[] data1 = null;
101    
102    
103     xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportExpense").createXmlDocument();
104
105
106     ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportExpense", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
107     toolbar.prepareSimpleToolBarTemplate();
108     xmlDocument.setParameter("toolbar", toolbar.toString());
109     try {
110       KeyMap key = new KeyMap(this, vars, "ReportExpense.html");
111       xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
112     } catch (Exception JavaDoc ex) {
113       throw new ServletException(ex);
114     }
115     try {
116       WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportExpense");
117       xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
118       xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
119       xmlDocument.setParameter("childTabContainer", tabs.childTabs());
120       xmlDocument.setParameter("theme", vars.getTheme());
121       NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportExpense.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
122       xmlDocument.setParameter("navigationBar", nav.toString());
123       LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportExpense.html", strReplaceWith);
124       xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
125     } catch (Exception JavaDoc ex) {
126       throw new ServletException(ex);
127     }
128     {
129       OBError myMessage = vars.getMessage("ReportExpense");
130       vars.removeMessage("ReportExpense");
131       if (myMessage!=null) {
132         xmlDocument.setParameter("messageType", myMessage.getType());
133         xmlDocument.setParameter("messageTitle", myMessage.getTitle());
134         xmlDocument.setParameter("messageMessage", myMessage.getMessage());
135       }
136     }
137
138
139     xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
140     xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
141     xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
142     xmlDocument.setParameter("dateFrom", strDateFrom);
143     xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
144     xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
145     xmlDocument.setParameter("dateTo", strDateTo);
146     xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
147     xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
148     xmlDocument.setParameter("paramBPartnerId", strcBpartnerId);
149     xmlDocument.setParameter("bPartnerDescription", ReportExpenseData.selectBpartner(this, strcBpartnerId));
150     xmlDocument.setParameter("partner", strPartner);
151
152     try {
153       ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "C_BPartner_ID", "C_BPartner Employee w Address", "", Utility.getContext(this, vars, "#User_Org", "ReportExpense"), Utility.getContext(this, vars, "#User_Client", "ReportExpense"), 0);
154       Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportExpense", "");
155       xmlDocument.setData("reportC_BPartner_ID","liststructure", comboTableData.select(false));
156       comboTableData = null;
157     } catch (Exception JavaDoc ex) {
158       throw new ServletException(ex);
159     }
160
161    
162
163     out.println(xmlDocument.print());
164     out.close();
165   }
166   
167   /*void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strDateFrom, String strDateTo, String strcBpartnerId, String strPartner)
168     throws IOException, ServletException {
169     if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
170     response.setContentType("text/html; charset=UTF-8");
171     PrintWriter out = response.getWriter();
172     XmlDocument xmlDocument=null;
173     ReportExpenseData[] data1 = null;
174     String discard[] = {"discard"};
175     if (vars.commandIn("DEFAULT") && strDateFrom.equals("") && strDateTo.equals("") && strcBpartnerId.equals("") && strPartner.equals("")){
176       discard[0] = "sectionPartner";
177       data1 = ReportExpenseData.set();
178       strDateFrom = DateTimeData.weekBefore(this);
179       strDateTo = DateTimeData.today(this);
180     } else {
181       data1 = ReportExpenseData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportExpense"), Utility.getContext(this, vars, "#User_Org", "ReportExpense"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strcBpartnerId, strPartner);
182     }
183     xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportExpense", discard).createXmlDocument();
184
185
186     ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportExpense", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
187     toolbar.prepareSimpleToolBarTemplate();
188     xmlDocument.setParameter("toolbar", toolbar.toString());
189     try {
190       KeyMap key = new KeyMap(this, vars, "ReportExpense.html");
191       xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
192     } catch (Exception ex) {
193       throw new ServletException(ex);
194     }
195     try {
196       WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportExpense");
197       xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
198       xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
199       xmlDocument.setParameter("childTabContainer", tabs.childTabs());
200       xmlDocument.setParameter("theme", vars.getTheme());
201       NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportExpense.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
202       xmlDocument.setParameter("navigationBar", nav.toString());
203       LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportExpense.html", strReplaceWith);
204       xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
205     } catch (Exception ex) {
206       throw new ServletException(ex);
207     }
208     {
209       OBError myMessage = vars.getMessage("ReportExpense");
210       vars.removeMessage("ReportExpense");
211       if (myMessage!=null) {
212         xmlDocument.setParameter("messageType", myMessage.getType());
213         xmlDocument.setParameter("messageTitle", myMessage.getTitle());
214         xmlDocument.setParameter("messageMessage", myMessage.getMessage());
215       }
216     }
217
218
219     xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
220     xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
221     xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
222     xmlDocument.setParameter("dateFrom", strDateFrom);
223     xmlDocument.setParameter("dateTo", strDateTo);
224     xmlDocument.setParameter("paramBPartnerId", strcBpartnerId);
225     xmlDocument.setParameter("bPartnerDescription", ReportExpenseData.selectBpartner(this, strcBpartnerId));
226     xmlDocument.setParameter("partner", strPartner);
227
228     try {
229       ComboTableData comboTableData = new ComboTableData(vars, this, "TABLE", "C_BPartner_ID", "C_BPartner Employee w Address", "", Utility.getContext(this, vars, "#User_Org", "ReportExpense"), Utility.getContext(this, vars, "#User_Client", "ReportExpense"), 0);
230       Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportExpense", "");
231       xmlDocument.setData("reportC_BPartner_ID","liststructure", comboTableData.select(false));
232       comboTableData = null;
233     } catch (Exception ex) {
234       throw new ServletException(ex);
235     }
236
237     xmlDocument.setData("structure1", data1);
238
239     out.println(xmlDocument.print());
240     out.close();
241   }*/

242
243   public String JavaDoc getServletInfo() {
244     return "Servlet ReportExpense. This Servlet was made by Jon Alegria";
245   } // end of getServletInfo() method
246
}
247
Popular Tags