KickJava   Java API By Example, From Geeks To Geeks.

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


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.ad_combos.AccountNumberComboData;
31
32 import org.openbravo.erpCommon.utility.DateTimeData;
33
34 public class ReportDebtPayment extends HttpSecureAppServlet {
35
36
37   public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
38     VariablesSecureApp vars = new VariablesSecureApp(request);
39
40     if (!Utility.hasProcessAccess(this, vars, "", "RV_ReportDebtPayment")) {
41       bdError(response, "AccessTableNoView", vars.getLanguage());
42       return;
43     }
44
45     if (vars.commandIn("DEFAULT", "DIRECT")) {
46       String JavaDoc strcbankaccount = vars.getGlobalVariable("inpmProductId", "ReportDebtPayment|C_Bankaccount_ID", "");
47       String JavaDoc strC_BPartner_ID = vars.getGlobalVariable("inpBpartnerId", "ReportDebtPayment|C_BPartner_ID", "");
48       String JavaDoc strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportDebtPayment|DateFrom", "");
49       String JavaDoc strDateTo = vars.getGlobalVariable("inpDateTo", "ReportDebtPayment|DateTo", "");
50       String JavaDoc strCal1 = vars.getGlobalVariable("inpCal1", "ReportDebtPayment|Cal1", "");
51       String JavaDoc strCalc2 = vars.getGlobalVariable("inpCalc2", "ReportDebtPayment|Cal2", "");
52       String JavaDoc strPaymentRule = vars.getGlobalVariable("inpCPaymentRuleId", "ReportDebtPayment|PaymentRule", "");
53       String JavaDoc strSettle = vars.getGlobalVariable("inpSettle", "ReportDebtPayment|Settle", "");
54       String JavaDoc strConciliate = vars.getGlobalVariable("inpConciliate", "ReportDebtPayment|Conciliate", "");
55       String JavaDoc strStatus = vars.getGlobalVariable("inpStatus", "ReportDebtPayment|Status", "");
56       String JavaDoc strGroup = vars.getGlobalVariable("inpGroup", "ReportDebtPayment|Group", "isGroup");
57       String JavaDoc strPending = "";
58       String JavaDoc strReceipt = "";
59       if (vars.commandIn("DIRECT")) {
60         strReceipt = vars.getGlobalVariable("inpReceipt", "ReportDebtPayment|Receipt", "N");
61         strPending = vars.getGlobalVariable("inpPending", "ReportDebtPayment|Pending", "");
62       }
63       else {
64         strReceipt = vars.getGlobalVariable("inpReceipt", "ReportDebtPayment|Receipt", "Y");
65         strPending = vars.getGlobalVariable("inpPending", "ReportDebtPayment|Pending", "isPending");
66       }
67       //String strEntry = vars.getGlobalVariable("inpEntry", "ReportDebtPayment|Entry","0");
68
setHistoryCommand(request, "DIRECT");
69       printPageDataSheet(response, vars, strC_BPartner_ID, strDateFrom, strDateTo, strCal1, strCalc2, strPaymentRule, strSettle, strConciliate, strReceipt, strPending, strcbankaccount, strStatus, strGroup);
70     } else if (vars.commandIn("FIND")) {
71       String JavaDoc strcbankaccount = vars.getRequestGlobalVariable("inpcBankAccountId", "ReportDebtPayment|C_Bankaccount_ID");
72       String JavaDoc strC_BPartner_ID = vars.getRequestGlobalVariable("inpBpartnerId", "ReportDebtPayment|C_BPartner_ID");
73       String JavaDoc strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportDebtPayment|DateFrom");
74       String JavaDoc strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportDebtPayment|DateTo");
75       String JavaDoc strCal1 = vars.getRequestGlobalVariable("inpCal1", "ReportDebtPayment|Cal1");
76       String JavaDoc strCalc2 = vars.getRequestGlobalVariable("inpCal2", "ReportDebtPayment|Cal2");
77       String JavaDoc strPaymentRule = vars.getRequestGlobalVariable("inpCPaymentRuleId", "ReportDebtPayment|PaymentRule");
78       String JavaDoc strSettle = vars.getRequestGlobalVariable("inpSettle", "ReportDebtPayment|Settle");
79       String JavaDoc strConciliate = vars.getRequestGlobalVariable("inpConciliate", "ReportDebtPayment|Conciliate");
80       String JavaDoc strPending = vars.getRequestGlobalVariable("inpPending", "ReportDebtPayment|Pending");
81       String JavaDoc strGroup = vars.getRequestGlobalVariable("inpGroup", "ReportDebtPayment|Group");
82       String JavaDoc strStatus = vars.getRequestGlobalVariable("inpStatus", "ReportDebtPayment|Status");
83       //String strReceipt = vars.getRequestGlobalVariable("inpReceipt", "ReportDebtPayment|Receipt");
84
String JavaDoc strReceipt = vars.getStringParameter("inpReceipt").equals("")?"N":vars.getStringParameter("inpReceipt");
85       vars.setSessionValue("ReportDebtPayment|Receipt", strReceipt);
86       //String strEntry = vars.getGlobalVariable("inpEntry", "ReportDebtPayment|Entry","1");
87
setHistoryCommand(request, "DIRECT");
88       printPageDataSheet(response, vars, strC_BPartner_ID, strDateFrom, strDateTo, strCal1, strCalc2, strPaymentRule, strSettle, strConciliate, strReceipt, strPending, strcbankaccount, strStatus, strGroup);
89     } else pageError(response);
90   }
91
92   void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String JavaDoc strC_BPartner_ID, String JavaDoc strDateFrom, String JavaDoc strDateTo, String JavaDoc strCal1, String JavaDoc strCalc2, String JavaDoc strPaymentRule, String JavaDoc strSettle, String JavaDoc strConciliate, String JavaDoc strReceipt, String JavaDoc strPending , String JavaDoc strcbankaccount, String JavaDoc strStatus, String JavaDoc strGroup)
93     throws IOException, ServletException {
94     if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
95     response.setContentType("text/html; charset=UTF-8");
96     PrintWriter out = response.getWriter();
97     String JavaDoc discard[]={"discard", "discard2", "discard3"};
98     String JavaDoc strAux = "";
99     if (log4j.isDebugEnabled()) log4j.debug("strGroup = " + strGroup);
100     if (strPending.equals("") && strConciliate.equals("") && strSettle.equals("")) {
101       strAux = "";
102     } else {
103       if (strPending.equals("isPending")) {
104         strAux = "'Pendientes'";
105       }
106       if (strConciliate.equals("isConciliate")) {
107         if (!strAux.equals("")) {
108           strAux = strAux + ",";
109         }
110         strAux = strAux + "'Conciliados'";
111       }
112       if (strSettle.equals("isSettle")) {
113         if (!strAux.equals("")) {
114           strAux = strAux + ",";
115         }
116         strAux = strAux + "'Saldados'";
117       }
118       strAux = "(" + strAux + ")";
119     }
120     XmlDocument xmlDocument;
121     ReportDebtPaymentData[] data = null;
122     if(!strGroup.equals("")) data= ReportDebtPaymentData.select(this, vars.getLanguage(), Utility.getContext(this, vars, "#User_Client", "ReportDebtPayment"), Utility.getContext(this, vars, "#User_Org", "ReportDebtPayment"), strC_BPartner_ID, strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strCal1, strCalc2, strPaymentRule, strReceipt, strStatus, strAux, strcbankaccount);
123     else data= ReportDebtPaymentData.selectNoBpartner(this, vars.getLanguage(), Utility.getContext(this, vars, "#User_Client", "ReportDebtPayment"), Utility.getContext(this, vars, "#User_Org", "ReportDebtPayment"), strC_BPartner_ID, strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strCal1, strCalc2, strPaymentRule, strReceipt, strStatus, strAux, strcbankaccount);
124     if (data == null || data.length == 0) {
125       data = ReportDebtPaymentData.set();
126       discard[0] = "sectionBpartner";
127       discard[1] = "sectionStatus2";
128       discard[2] = "sectionTotal2";
129     }
130
131     if(!strGroup.equals("")){
132       discard[0] = "sectionDetail2";
133       discard[1] = "sectionStatus2";
134       discard[2] = "sectionTotal2";
135     } else {
136       discard[0] = "sectionBpartner";
137       discard[1] = "sectionTotal";
138     }
139     if (vars.commandIn("DEFAULT")) {
140       discard[0] = "sectionBpartner";
141       discard[1] = "sectionStatus2";
142       discard[2] = "sectionTotal2";
143       xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportDebtPayment", discard).createXmlDocument();
144       data = ReportDebtPaymentData.set();
145     } else {
146       xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportDebtPayment", discard).createXmlDocument();
147     }
148     ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportDebtPayment", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
149     toolbar.prepareSimpleToolBarTemplate();
150     xmlDocument.setParameter("toolbar", toolbar.toString());
151
152     try {
153       KeyMap key = new KeyMap(this, vars, "ReportDebtPayment.html");
154       xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
155     } catch (Exception JavaDoc ex) {
156       throw new ServletException(ex);
157     }
158     try {
159       WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportDebtPayment");
160       xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
161       xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
162       xmlDocument.setParameter("childTabContainer", tabs.childTabs());
163       xmlDocument.setParameter("theme", vars.getTheme());
164       NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportDebtPayment.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
165       xmlDocument.setParameter("navigationBar", nav.toString());
166       LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportDebtPayment.html", strReplaceWith);
167       xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
168     } catch (Exception JavaDoc ex) {
169       throw new ServletException(ex);
170     }
171     {
172       OBError myMessage = vars.getMessage("ReportDebtPayment");
173       vars.removeMessage("ReportDebtPayment");
174       if (myMessage!=null) {
175         xmlDocument.setParameter("messageType", myMessage.getType());
176         xmlDocument.setParameter("messageTitle", myMessage.getTitle());
177         xmlDocument.setParameter("messageMessage", myMessage.getMessage());
178       }
179     }
180
181
182     xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
183     xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
184     xmlDocument.setParameter("paramLanguage", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
185     xmlDocument.setParameter("cBankAccount", strcbankaccount);
186     xmlDocument.setData("reportC_ACCOUNTNUMBER","liststructure",AccountNumberComboData.select(this, Utility.getContext(this, vars, "#User_Client", "ReportDebtPayment"), Utility.getContext(this, vars, "#User_Org", "ReportDebtPayment")));
187     xmlDocument.setParameter("paramBPartnerId", strC_BPartner_ID);
188     xmlDocument.setParameter("dateFrom", strDateFrom);
189     xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
190     xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
191     xmlDocument.setParameter("dateTo", strDateTo);
192     xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
193     xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
194     xmlDocument.setParameter("amountFrom", strCal1);
195     xmlDocument.setParameter("amountTo", strCalc2);
196     xmlDocument.setParameter("paymentRule", strPaymentRule);
197     xmlDocument.setParameter("settle", strSettle);
198     xmlDocument.setParameter("conciliate", strConciliate);
199     xmlDocument.setParameter("pending", strPending);
200     xmlDocument.setParameter("receipt", strReceipt);
201     xmlDocument.setParameter("payable", strReceipt);
202     xmlDocument.setParameter("status", strStatus);
203     xmlDocument.setParameter("group", strGroup);
204     if (log4j.isDebugEnabled()) log4j.debug("diacard = " + discard[0] + " - " + discard[1] + " - " + discard[2]);
205     xmlDocument.setParameter("paramBPartnerDescription", ReportDebtPaymentData.bPartnerDescription(this, strC_BPartner_ID));
206     if (log4j.isDebugEnabled()) log4j.debug("ListData.select PaymentRule:"+strPaymentRule);
207     try {
208       ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "", "All_Payment Rule", "", Utility.getContext(this, vars, "#User_Org", "ReportDebtPayment"), Utility.getContext(this, vars, "#User_Client", "ReportDebtPayment"), 0);
209       Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportDebtPayment", strPaymentRule);
210       xmlDocument.setData("reportPaymentRule","liststructure", comboTableData.select(false));
211       comboTableData = null;
212     } catch (Exception JavaDoc ex) {
213       throw new ServletException(ex);
214     }
215     if (log4j.isDebugEnabled()) log4j.debug("ListData.select Status:"+strPaymentRule);
216     try {
217       ComboTableData comboTableData = new ComboTableData(vars, this, "LIST", "", "C_DP_Management_Status", "", Utility.getContext(this, vars, "#User_Org", "ReportDebtPayment"), Utility.getContext(this, vars, "#User_Client", "ReportDebtPayment"), 0);
218       Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportDebtPayment", strStatus);
219       xmlDocument.setData("reportStatus","liststructure", comboTableData.select(false));
220       comboTableData = null;
221     } catch (Exception JavaDoc ex) {
222       throw new ServletException(ex);
223     }
224     xmlDocument.setData(!strGroup.equals("")?"structure1":"structure2", data);
225     out.println(xmlDocument.print());
226     out.close();
227   }
228
229   public String JavaDoc getServletInfo() {
230     return "Servlet ReportDebtPayment. This Servlet was made by Pablo Sarobe";
231   } // end of getServletInfo() method
232
}
233
234
Popular Tags