KickJava   Java API By Example, From Geeks To Geeks.

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


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
20 package org.openbravo.erpCommon.ad_reports;
21
22 import org.openbravo.erpCommon.utility.*;
23 import org.openbravo.erpCommon.businessUtility.Tree;
24 import org.openbravo.erpCommon.businessUtility.TreeData;
25 import org.openbravo.erpCommon.businessUtility.WindowTabs;
26 import org.openbravo.base.secureApp.HttpSecureAppServlet;
27 import org.openbravo.base.secureApp.VariablesSecureApp;
28 import org.openbravo.xmlEngine.XmlDocument;
29 import java.io.*;
30 import java.util.*;
31 import java.text.*;
32 import javax.servlet.*;
33 import javax.servlet.http.*;
34
35 import org.openbravo.utils.Replace;
36 import org.openbravo.erpCommon.ad_combos.OrganizationComboData;
37
38 import org.openbravo.erpCommon.utility.DateTimeData;
39
40 import net.sf.jasperreports.engine.*;
41 import net.sf.jasperreports.engine.design.JasperDesign;
42 import java.sql.Connection JavaDoc;
43 import net.sf.jasperreports.engine.xml.JRXmlLoader;
44 import net.sf.jasperreports.engine.export.JRHtmlExporter;
45 import net.sf.jasperreports.engine.export.JRHtmlExporterParameter;
46
47 public class ReportPurchaseDimensionalAnalysesJR extends HttpSecureAppServlet {
48   
49
50   public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
51     VariablesSecureApp vars = new VariablesSecureApp(request);
52
53     if (!Utility.hasProcessAccess(this, vars, "", "ReportPurchaseDimensionalAnalysesJR")) {
54       bdError(response, "AccessTableNoView", vars.getLanguage());
55       return;
56     }
57
58     if (vars.commandIn("DEFAULT", "DEFAULT_COMPARATIVE")){
59       String JavaDoc strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportPurchaseDimensionalAnalysesJR|dateFrom", "");
60       String JavaDoc strDateTo = vars.getGlobalVariable("inpDateTo", "ReportPurchaseDimensionalAnalysesJR|dateTo", "");
61       String JavaDoc strDateFromRef = vars.getGlobalVariable("inpDateFromRef", "ReportPurchaseDimensionalAnalysesJR|dateFromRef", "");
62       String JavaDoc strDateToRef = vars.getGlobalVariable("inpDateToRef", "ReportPurchaseDimensionalAnalysesJR|dateToRef", "");
63       String JavaDoc strPartnerGroup = vars.getGlobalVariable("inpPartnerGroup", "ReportPurchaseDimensionalAnalysesJR|partnerGroup", "");
64       String JavaDoc strcBpartnerId = vars.getInGlobalVariable("inpcBPartnerId_IN", "ReportPurchaseDimensionalAnalysesJR|partner", "");
65       String JavaDoc strProductCategory = vars.getGlobalVariable("inpProductCategory", "ReportPurchaseDimensionalAnalysesJR|productCategory", "");
66       String JavaDoc strmProductId = vars.getInGlobalVariable("inpmProductId_IN", "ReportPurchaseDimensionalAnalysesJR|product", "");
67       String JavaDoc strNotShown = vars.getInGlobalVariable("inpNotShown", "ReportPurchaseDimensionalAnalysesJR|notShown", "");
68       String JavaDoc strShown = vars.getInGlobalVariable("inpShown", "ReportPurchaseDimensionalAnalysesJR|shown", "");
69       String JavaDoc strOrg = vars.getGlobalVariable("inpOrg", "ReportPurchaseDimensionalAnalysesJR|org", "0");
70       String JavaDoc strOrder = vars.getGlobalVariable("inpOrder","ReportPurchaseDimensionalAnalyze|order","Normal");
71       String JavaDoc strMayor = vars.getGlobalVariable("inpMayor", "ReportPurchaseDimensionalAnalyze|mayor", "");
72       String JavaDoc strMenor = vars.getGlobalVariable("inpMenor", "ReportPurchaseDimensionalAnalyze|menor", "");
73       String JavaDoc strComparative = "";
74       if (vars.commandIn("DEFAULT_COMPARATIVE")) strComparative = vars.getRequestGlobalVariable("inpComparative", "ReportPurchaseDimensionalAnalysesJR|comparative");
75       else strComparative = vars.getGlobalVariable("inpComparative", "ReportPurchaseDimensionalAnalysesJR|comparative", "N");
76       printPageDataSheet(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor);
77     }else if (vars.commandIn("EDIT_HTML", "EDIT_HTML_COMPARATIVE")) {
78       String JavaDoc strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportPurchaseDimensionalAnalysesJR|dateFrom");
79       String JavaDoc strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportPurchaseDimensionalAnalysesJR|dateTo");
80       String JavaDoc strDateFromRef = vars.getRequestGlobalVariable("inpDateFromRef", "ReportPurchaseDimensionalAnalysesJR|dateFromRef");
81       String JavaDoc strDateToRef = vars.getRequestGlobalVariable("inpDateToRef", "ReportPurchaseDimensionalAnalysesJR|dateToRef");
82       String JavaDoc strPartnerGroup = vars.getRequestGlobalVariable("inpPartnerGroup", "ReportPurchaseDimensionalAnalysesJR|partnerGroup");
83       String JavaDoc strcBpartnerId = vars.getRequestInGlobalVariable("inpcBPartnerId_IN", "ReportPurchaseDimensionalAnalysesJR|partner");
84       String JavaDoc strProductCategory = vars.getRequestGlobalVariable("inpProductCategory", "ReportPurchaseDimensionalAnalysesJR|productCategory");
85       String JavaDoc strmProductId = vars.getRequestInGlobalVariable("inpmProductId_IN", "ReportPurchaseDimensionalAnalysesJR|product");
86       String JavaDoc strNotShown = vars.getInStringParameter("inpNotShown");
87       String JavaDoc strShown = vars.getInStringParameter("inpShown");
88       String JavaDoc strOrg = vars.getGlobalVariable("inpOrg", "ReportPurchaseDimensionalAnalysesJR|org", "0");
89       String JavaDoc strOrder = vars.getRequestGlobalVariable("inpOrder","ReportPurchaseDimensionalAnalysesJR|order");
90       String JavaDoc strMayor = vars.getStringParameter("inpMayor", "");
91       String JavaDoc strMenor = vars.getStringParameter("inpMenor", "");
92       String JavaDoc strComparative = vars.getStringParameter("inpComparative", "N");
93       printPageHtml(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor, "html");
94     }else if (vars.commandIn("EDIT_PDF", "EDIT_PDF_COMPARATIVE")) {
95       String JavaDoc strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportPurchaseDimensionalAnalysesJR|dateFrom");
96       String JavaDoc strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportPurchaseDimensionalAnalysesJR|dateTo");
97       String JavaDoc strDateFromRef = vars.getRequestGlobalVariable("inpDateFromRef", "ReportPurchaseDimensionalAnalysesJR|dateFromRef");
98       String JavaDoc strDateToRef = vars.getRequestGlobalVariable("inpDateToRef", "ReportPurchaseDimensionalAnalysesJR|dateToRef");
99       String JavaDoc strPartnerGroup = vars.getRequestGlobalVariable("inpPartnerGroup", "ReportPurchaseDimensionalAnalysesJR|partnerGroup");
100       String JavaDoc strcBpartnerId = vars.getRequestInGlobalVariable("inpcBPartnerId_IN", "ReportPurchaseDimensionalAnalysesJR|partner");
101       String JavaDoc strProductCategory = vars.getRequestGlobalVariable("inpProductCategory", "ReportPurchaseDimensionalAnalysesJR|productCategory");
102       String JavaDoc strmProductId = vars.getRequestInGlobalVariable("inpmProductId_IN", "ReportPurchaseDimensionalAnalysesJR|product");
103       String JavaDoc strNotShown = vars.getInStringParameter("inpNotShown");
104       String JavaDoc strShown = vars.getInStringParameter("inpShown");
105       String JavaDoc strOrg = vars.getGlobalVariable("inpOrg", "ReportPurchaseDimensionalAnalysesJR|org", "0");
106       String JavaDoc strOrder = vars.getRequestGlobalVariable("inpOrder","ReportPurchaseDimensionalAnalysesJR|order");
107       String JavaDoc strMayor = vars.getStringParameter("inpMayor", "");
108       String JavaDoc strMenor = vars.getStringParameter("inpMenor", "");
109       String JavaDoc strComparative = vars.getStringParameter("inpComparative", "N");
110       //if (strComparative.equals("N"))
111
printPageHtml(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor, "pdf");
112       //else printPagePdf(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor);
113
} else pageErrorPopUp(response);
114   }
115
116   void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String JavaDoc strComparative, String JavaDoc strDateFrom, String JavaDoc strDateTo, String JavaDoc strPartnerGroup, String JavaDoc strcBpartnerId, String JavaDoc strProductCategory, String JavaDoc strmProductId, String JavaDoc strNotShown, String JavaDoc strShown, String JavaDoc strDateFromRef, String JavaDoc strDateToRef, String JavaDoc strOrg, String JavaDoc strOrder, String JavaDoc strMayor, String JavaDoc strMenor) throws IOException, ServletException {
117     if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
118     String JavaDoc discard[]={"selEliminarHeader1"};
119     if (strComparative.equals("Y")) {
120       discard[0] = "selEliminarHeader2";
121     }
122     XmlDocument xmlDocument=null;
123     xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportPurchaseDimensionalAnalysesFilterJR", discard).createXmlDocument();
124     
125     ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportPurchaseDimensionalAnalysesFilterJR", false, "", "", "",false, "ad_reports", strReplaceWith, false, true);
126     toolbar.prepareSimpleToolBarTemplate();
127     xmlDocument.setParameter("toolbar", toolbar.toString());
128     
129     xmlDocument.setParameter("calendar", vars.getLanguage().substring(0,2));
130     xmlDocument.setParameter("language", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
131     xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
132     xmlDocument.setParameter("dateFrom", strDateFrom);
133     xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
134     xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
135     xmlDocument.setParameter("dateTo", strDateTo);
136     xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
137     xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
138     xmlDocument.setParameter("dateFromRef", strDateFromRef);
139     xmlDocument.setParameter("dateFromRefdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
140     xmlDocument.setParameter("dateFromRefsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
141     xmlDocument.setParameter("dateToRef", strDateToRef);
142     xmlDocument.setParameter("dateToRefdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
143     xmlDocument.setParameter("dateToRefsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
144     /*xmlDocument.setParameter("paramBPartnerId", strcBpartnerId);
145     xmlDocument.setParameter("bPartnerDescription", ReportPurchaseDimensionalAnalysesJRData.selectBpartner(this, strcBpartnerId));
146     xmlDocument.setParameter("mProduct", strmProductId);
147     xmlDocument.setParameter("productDescription", ReportPurchaseDimensionalAnalysesJRData.selectMproduct(this, strmProductId));*/

148     xmlDocument.setParameter("cBpGroupId", strPartnerGroup);
149     xmlDocument.setParameter("mProductCategoryId", strProductCategory);
150     xmlDocument.setParameter("adOrgId", strOrg);
151     xmlDocument.setParameter("normal", strOrder);
152     xmlDocument.setParameter("amountasc", strOrder);
153     xmlDocument.setParameter("amountdesc", strOrder);
154     xmlDocument.setParameter("mayor", strMayor);
155     xmlDocument.setParameter("menor", strMenor);
156     xmlDocument.setParameter("comparative", strComparative);
157
158     try {
159       KeyMap key = new KeyMap(this, vars, "ReportPurchaseDimensionalAnalysesFilterJR.html");
160       xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
161     } catch (Exception JavaDoc ex) {
162       throw new ServletException(ex);
163     }
164     try {
165       WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportPurchaseDimensionalAnalysesJR");
166       xmlDocument.setParameter("parentTabContainer", tabs.parentTabs());
167       xmlDocument.setParameter("mainTabContainer", tabs.mainTabs());
168       xmlDocument.setParameter("childTabContainer", tabs.childTabs());
169       xmlDocument.setParameter("theme", vars.getTheme());
170       NavigationBar nav = new NavigationBar(this, vars.getLanguage(), "ReportPurchaseDimensionalAnalysesFilterJR.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
171       xmlDocument.setParameter("navigationBar", nav.toString());
172       LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportPurchaseDimensionalAnalysesFilterJR.html", strReplaceWith);
173       xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
174     } catch (Exception JavaDoc ex) {
175       throw new ServletException(ex);
176     }
177     {
178       OBError myMessage = vars.getMessage("ReportPurchaseDimensionalAnalysesJR");
179       vars.removeMessage("ReportPurchaseDimensionalAnalysesJR");
180       if (myMessage!=null) {
181         xmlDocument.setParameter("messageType", myMessage.getType());
182         xmlDocument.setParameter("messageTitle", myMessage.getTitle());
183         xmlDocument.setParameter("messageMessage", myMessage.getMessage());
184       }
185     }
186
187
188   try {
189     ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_BP_Group_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportPurchaseDimensionalAnalysesJR"), Utility.getContext(this, vars, "#User_Client", "ReportPurchaseDimensionalAnalysesJR"), 0);
190     Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportPurchaseDimensionalAnalysesJR", strPartnerGroup);
191     xmlDocument.setData("reportC_BP_GROUPID","liststructure", comboTableData.select(false));
192     comboTableData = null;
193   } catch (Exception JavaDoc ex) {
194     throw new ServletException(ex);
195   }
196
197
198   try {
199     ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Product_Category_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportPurchaseDimensionalAnalysesJR"), Utility.getContext(this, vars, "#User_Client", "ReportPurchaseDimensionalAnalysesJR"), 0);
200     Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportPurchaseDimensionalAnalysesJR", strProductCategory);
201     xmlDocument.setData("reportM_PRODUCT_CATEGORYID","liststructure", comboTableData.select(false));
202     comboTableData = null;
203   } catch (Exception JavaDoc ex) {
204     throw new ServletException(ex);
205   }
206
207     xmlDocument.setData("reportAD_ORGID", "liststructure", OrganizationComboData.selectCombo(this, vars.getRole()));
208     xmlDocument.setData("reportCBPartnerId_IN", "liststructure", ReportPurchaseDimensionalAnalysesJRData.selectBpartner(this, Utility.getContext(this, vars, "#User_Org", ""), Utility.getContext(this, vars, "#User_Client", ""), strcBpartnerId));
209     xmlDocument.setData("reportMProductId_IN", "liststructure", ReportPurchaseDimensionalAnalysesJRData.selectMproduct(this, Utility.getContext(this, vars, "#User_Org", ""), Utility.getContext(this, vars, "#User_Client", ""), strmProductId));
210    
211        
212      if (vars.getLanguage().equals("en_US")) {
213       xmlDocument.setData("structure1", ReportPurchaseDimensionalAnalysesJRData.selectNotShown(this, strShown));
214       xmlDocument.setData("structure2", strShown.equals("")?new ReportPurchaseDimensionalAnalysesJRData[0]:ReportPurchaseDimensionalAnalysesJRData.selectShown(this, strShown));
215     } else {
216       xmlDocument.setData("structure1", ReportPurchaseDimensionalAnalysesJRData.selectNotShownTrl(this, vars.getLanguage(), strShown));
217       xmlDocument.setData("structure2", strShown.equals("")?new ReportPurchaseDimensionalAnalysesJRData[0]:ReportPurchaseDimensionalAnalysesJRData.selectShownTrl(this, vars.getLanguage(), strShown));
218     }
219     
220     response.setContentType("text/html; charset=UTF-8");
221     PrintWriter out = response.getWriter();
222     out.println(xmlDocument.print());
223     out.close();
224   }
225
226   void printPageHtml(HttpServletResponse response, VariablesSecureApp vars, String JavaDoc strComparative, String JavaDoc strDateFrom, String JavaDoc strDateTo, String JavaDoc strPartnerGroup, String JavaDoc strcBpartnerId, String JavaDoc strProductCategory, String JavaDoc strmProductId, String JavaDoc strNotShown, String JavaDoc strShown, String JavaDoc strDateFromRef, String JavaDoc strDateToRef, String JavaDoc strOrg, String JavaDoc strOrder, String JavaDoc strMayor, String JavaDoc strMenor, String JavaDoc strOutput) throws IOException, ServletException{
227     if (log4j.isDebugEnabled()) log4j.debug("Output: print html");
228     HashMap<String JavaDoc, Object JavaDoc> parameters = new HashMap<String JavaDoc, Object JavaDoc>();
229     String JavaDoc strOrderby = "";
230     String JavaDoc[] discard = {"", "", "", "", ""};
231     String JavaDoc[] discard1={"selEliminarBody1", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard"};
232     if (strComparative.equals("Y")) discard1[0] = "selEliminarBody2";
233     String JavaDoc strTitle = "";
234     strTitle = Utility.messageBD(this, "From", vars.getLanguage()) + " " + strDateFrom + " " + Utility.messageBD(this, "To", vars.getLanguage()) + " "+strDateTo;
235     if (!strPartnerGroup.equals("")) strTitle = strTitle+", " + Utility.messageBD(this, "ForBPartnerGroup", vars.getLanguage()) + " "+ReportPurchaseDimensionalAnalysesJRData.selectBpgroup(this, strPartnerGroup);
236     
237     if (!strProductCategory.equals("")) strTitle = strTitle+" " + Utility.messageBD(this, "And", vars.getLanguage()) + " " + Utility.messageBD(this, "ProductCategory", vars.getLanguage()) + " "+ReportPurchaseDimensionalAnalysesJRData.selectProductCategory(this, strProductCategory);
238     
239
240     ReportPurchaseDimensionalAnalysesJRData[] data = null;
241     String JavaDoc[] strShownArray = {"", "", "", "", ""};
242     if (strShown.startsWith("(")) strShown = strShown.substring(1, strShown.length()-1);
243     if (!strShown.equals("")) {
244       strShown = Replace.replace(strShown, "'", "");
245       strShown = Replace.replace(strShown, " ", "");
246       StringTokenizer st = new StringTokenizer(strShown, ",", false);
247       int intContador = 0;
248       while (st.hasMoreTokens()){
249         strShownArray[intContador] = st.nextToken();
250         intContador++;
251       }
252       
253     }
254     
255     ReportPurchaseDimensionalAnalysesJRData[] dimensionLabel = null;
256     if (vars.getLanguage().equals("en_US")) {
257       dimensionLabel = ReportPurchaseDimensionalAnalysesJRData.selectNotShown(this, "");
258     } else {
259       dimensionLabel = ReportPurchaseDimensionalAnalysesJRData.selectNotShownTrl(this, vars.getLanguage(), "");
260     }
261     
262     String JavaDoc[] strLevelLabel = {"", "", "", "", ""};
263     String JavaDoc[] strTextShow = {"", "", "", "", ""};
264     int intDiscard = 0;
265     int intProductLevel = 6;
266     int intAuxDiscard = -1;
267     for (int i = 0; i<5; i++){
268       if (strShownArray[i].equals("1")) {
269         strTextShow[i] = "C_BP_GROUP.NAME";
270         intDiscard++;
271         strLevelLabel[i] = dimensionLabel[0].name;
272       }
273       else if (strShownArray[i].equals("2")) {
274         strTextShow[i] = "AD_COLUMN_IDENTIFIER('C_Bpartner', TO_CHAR(C_BPARTNER.C_BPARTNER_ID), 'es_ES')";
275         intDiscard++;
276         strLevelLabel[i] = dimensionLabel[1].name;
277       }
278       else if (strShownArray[i].equals("3")) {
279         strTextShow[i] = "M_PRODUCT_CATEGORY.NAME";
280         intDiscard++;
281         strLevelLabel[i] = dimensionLabel[2].name;
282       }
283       else if (strShownArray[i].equals("4")) {
284         strTextShow[i] = "AD_COLUMN_IDENTIFIER('M_Product', TO_CHAR(M_PRODUCT.M_PRODUCT_ID), 'es_ES')";
285         intProductLevel = i+1;
286         intDiscard++;
287         intAuxDiscard = i;
288         strLevelLabel[i] = dimensionLabel[3].name;
289       }
290       else if (strShownArray[i].equals("5")) {
291         strTextShow[i] = "C_ORDER.DOCUMENTNO";
292         intDiscard++;
293         strLevelLabel[i] = dimensionLabel[4].name;
294       }
295       else {
296         strTextShow[i] = "''";
297         discard[i] = "display:none;";
298       }
299     }
300     if (intDiscard != 0 || intAuxDiscard != -1){
301       int k=1;
302       strOrderby = " ORDER BY NIVEL"+k+",";
303       while (k<intDiscard){
304         strOrderby = strOrderby+"NIVEL"+k+",";
305         k++;
306       }
307       if (k==1){
308         if (strOrder.equals("Normal")){
309           strOrderby = " ORDER BY NIVEL"+k;
310         } else if (strOrder.equals("Amountasc")){
311           strOrderby = " ORDER BY LINENETAMT ASC";
312         } else if (strOrder.equals("Amountdesc")){
313           strOrderby = " ORDER BY LINENETAMT DESC";
314         } else{
315           strOrderby = "1";
316         }
317       } else{
318         if (strOrder.equals("Normal")){
319           strOrderby += "NIVEL"+k;
320         } else if (strOrder.equals("Amountasc")){
321           strOrderby += "LINENETAMT ASC";
322         } else if (strOrder.equals("Amountdesc")){
323           strOrderby += "LINENETAMT DESC";
324         } else{
325           strOrderby = "1";
326         }
327       }
328       
329     } else{
330       strOrderby = " ORDER BY 1";
331     }
332     String JavaDoc strHaving = "";
333     if (!strMayor.equals("") && !strMenor.equals("")) {strHaving = " HAVING SUM(LINENETAMT) > "+strMayor+" AND SUM(LINENETAMT) < "+strMenor;}
334     else if (!strMayor.equals("") && strMenor.equals("")) {strHaving = " HAVING SUM(LINENETAMT) > "+strMayor;}
335     else if (strMayor.equals("") && !strMenor.equals("")) {strHaving = " HAVING SUM(LINENETAMT) < "+strMenor;}
336     else{ strHaving = " HAVING SUM(LINENETAMT) <> 0 OR SUM(LINENETREF) <> 0";}
337     strOrderby = strHaving + strOrderby;
338
339     String JavaDoc strReportPath;
340     if (strComparative.equals("Y")){
341       strReportPath = "@basedesign@/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml";
342       
343       data = ReportPurchaseDimensionalAnalysesJRData.select(this, strTextShow[0], strTextShow[1], strTextShow[2], strTextShow[3], strTextShow[4], Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg), Utility.getContext(this, vars, "#User_Client", "ReportPurchaseDimensionalAnalysesJR"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strDateFromRef, DateTimeData.nDaysAfter(this, strDateToRef,"1"), strOrderby);
344
345
346     } else { //no comparative report using JasperReports
347
strReportPath = "@basedesign@/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml";
348
349       data = ReportPurchaseDimensionalAnalysesJRData.selectNoComparative(this, strTextShow[0], strTextShow[1], strTextShow[2], strTextShow[3], strTextShow[4], Tree.getMembers(this, TreeData.getTreeOrg(this, vars.getClient()), strOrg), Utility.getContext(this, vars, "#User_Client", "ReportPurchaseDimensionalAnalysesJR"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strOrderby);
350     }
351     parameters.put("LEVEL1_LABEL", strLevelLabel[0]);
352     parameters.put("LEVEL2_LABEL", strLevelLabel[1]);
353     parameters.put("LEVEL3_LABEL", strLevelLabel[2]);
354     parameters.put("LEVEL4_LABEL", strLevelLabel[3]);
355     parameters.put("LEVEL5_LABEL", strLevelLabel[4]);
356     parameters.put("DIMENSIONS", new Integer JavaDoc(intDiscard));
357     parameters.put("REPORT_TITLE", classInfo.name);
358     parameters.put("REPORT_SUBTITLE", strTitle);
359     parameters.put("PRODUCT_LEVEL", new Integer JavaDoc(intProductLevel));
360     renderJR(vars, response, strReportPath, strOutput, parameters, data, null );
361   }
362
363   public String JavaDoc getServletInfo() {
364     return "Servlet ReportPurchaseDimensionalAnalysesJR. This Servlet was made by Jon Alegría";
365   } // end of getServletInfo() method
366
}
367
368
Popular Tags