KickJava   Java API By Example, From Geeks To Geeks.

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


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.erpCommon.businessUtility.Tree;
24 import org.openbravo.erpCommon.businessUtility.TreeData;
25 import org.openbravo.base.secureApp.HttpSecureAppServlet;
26 import org.openbravo.base.secureApp.VariablesSecureApp;
27 import org.openbravo.xmlEngine.XmlDocument;
28 import java.io.*;
29 import java.util.*;
30 import javax.servlet.*;
31 import javax.servlet.http.*;
32
33 import org.openbravo.utils.Replace;
34 import org.openbravo.erpCommon.ad_combos.OrganizationComboData;
35
36
37 import org.openbravo.erpCommon.utility.DateTimeData;
38
39 public class ReportMaterialDimensionalAnalysesJR extends HttpSecureAppServlet {
40
41
42   public void doPost (HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
43     VariablesSecureApp vars = new VariablesSecureApp(request);
44
45     if (!Utility.hasProcessAccess(this, vars, "", "ReportMaterialDimensionalAnalysesJR")) {
46       bdError(response, "AccessTableNoView", vars.getLanguage());
47       return;
48     }
49
50     if (vars.commandIn("DEFAULT", "DEFAULT_COMPARATIVE")){
51       String JavaDoc strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportMaterialDimensionalAnalysesJR|dateFrom", "");
52       String JavaDoc strDateTo = vars.getGlobalVariable("inpDateTo", "ReportMaterialDimensionalAnalysesJR|dateTo", "");
53       String JavaDoc strDateFromRef = vars.getGlobalVariable("inpDateFromRef", "ReportMaterialDimensionalAnalysesJR|dateFromRef", "");
54       String JavaDoc strDateToRef = vars.getGlobalVariable("inpDateToRef", "ReportMaterialDimensionalAnalysesJR|dateToRef", "");
55       String JavaDoc strPartnerGroup = vars.getGlobalVariable("inpPartnerGroup", "ReportMaterialDimensionalAnalysesJR|partnerGroup", "");
56       String JavaDoc strcBpartnerId = vars.getInGlobalVariable("inpcBPartnerId_IN", "ReportMaterialDimensionalAnalysesJR|partner", "");
57       String JavaDoc strProductCategory = vars.getGlobalVariable("inpProductCategory", "ReportMaterialDimensionalAnalysesJR|productCategory", "");
58       String JavaDoc strmProductId = vars.getInGlobalVariable("inpmProductId_IN", "ReportMaterialDimensionalAnalysesJR|product", "");
59       String JavaDoc strNotShown = vars.getInGlobalVariable("inpNotShown", "ReportMaterialDimensionalAnalysesJR|notShown", "");
60       String JavaDoc strShown = vars.getInGlobalVariable("inpShown", "ReportMaterialDimensionalAnalysesJR|shown", "");
61       String JavaDoc strOrg = vars.getGlobalVariable("inpOrg", "ReportMaterialDimensionalAnalysesJR|org", "0");
62       String JavaDoc strOrder = vars.getGlobalVariable("inpOrder","ReportMaterialDimensionalAnalysesJR|order","Normal");
63       String JavaDoc strMayor = vars.getGlobalVariable("inpMayor", "ReportMaterialDimensionalAnalysesJR|mayor", "");
64       String JavaDoc strMenor = vars.getGlobalVariable("inpMenor", "ReportMaterialDimensionalAnalysesJR|menor", "");
65       String JavaDoc strComparative = "";
66       if (vars.commandIn("DEFAULT_COMPARATIVE")) strComparative = vars.getRequestGlobalVariable("inpComparative", "ReportMaterialDimensionalAnalysesJR|comparative");
67       else strComparative = vars.getGlobalVariable("inpComparative", "ReportMaterialDimensionalAnalysesJR|comparative", "N");
68       printPageDataSheet(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor);
69     } else if (vars.commandIn("EDIT_HTML", "EDIT_HTML_COMPARATIVE")) {
70       String JavaDoc strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportMaterialDimensionalAnalysesJR|dateFrom");
71       String JavaDoc strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportMaterialDimensionalAnalysesJR|dateTo");
72       String JavaDoc strDateFromRef = vars.getRequestGlobalVariable("inpDateFromRef", "ReportMaterialDimensionalAnalysesJR|dateFromRef");
73       String JavaDoc strDateToRef = vars.getRequestGlobalVariable("inpDateToRef", "ReportMaterialDimensionalAnalysesJR|dateToRef");
74       String JavaDoc strPartnerGroup = vars.getRequestGlobalVariable("inpPartnerGroup", "ReportMaterialDimensionalAnalysesJR|partnerGroup");
75       String JavaDoc strcBpartnerId = vars.getRequestInGlobalVariable("inpcBPartnerId_IN", "ReportMaterialDimensionalAnalysesJR|partner");
76       String JavaDoc strProductCategory = vars.getRequestGlobalVariable("inpProductCategory", "ReportMaterialDimensionalAnalysesJR|productCategory");
77       String JavaDoc strmProductId = vars.getRequestInGlobalVariable("inpmProductId_IN", "ReportMaterialDimensionalAnalysesJR|product");
78       String JavaDoc strNotShown = vars.getInStringParameter("inpNotShown");
79       String JavaDoc strShown = vars.getInStringParameter("inpShown");
80       String JavaDoc strOrg = vars.getGlobalVariable("inpOrg", "ReportMaterialDimensionalAnalysesJR|org", "0");
81       String JavaDoc strOrder = vars.getRequestGlobalVariable("inpOrder","ReportMaterialDimensionalAnalysesJR|order");
82       String JavaDoc strMayor = vars.getStringParameter("inpMayor", "");
83       String JavaDoc strMenor = vars.getStringParameter("inpMenor", "");
84       String JavaDoc strComparative = vars.getStringParameter("inpComparative", "N");
85       printPageHtml(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor, "html");
86     } else if (vars.commandIn("EDIT_PDF", "EDIT_PDF_COMPARATIVE")) {
87       String JavaDoc strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportMaterialDimensionalAnalysesJR|dateFrom");
88       String JavaDoc strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportMaterialDimensionalAnalysesJR|dateTo");
89       String JavaDoc strDateFromRef = vars.getRequestGlobalVariable("inpDateFromRef", "ReportMaterialDimensionalAnalysesJR|dateFromRef");
90       String JavaDoc strDateToRef = vars.getRequestGlobalVariable("inpDateToRef", "ReportMaterialDimensionalAnalysesJR|dateToRef");
91       String JavaDoc strPartnerGroup = vars.getRequestGlobalVariable("inpPartnerGroup", "ReportMaterialDimensionalAnalysesJR|partnerGroup");
92       String JavaDoc strcBpartnerId = vars.getRequestInGlobalVariable("inpcBPartnerId_IN", "ReportMaterialDimensionalAnalysesJR|partner");
93       String JavaDoc strProductCategory = vars.getRequestGlobalVariable("inpProductCategory", "ReportMaterialDimensionalAnalysesJR|productCategory");
94       String JavaDoc strmProductId = vars.getRequestInGlobalVariable("inpmProductId_IN", "ReportMaterialDimensionalAnalysesJR|product");
95       String JavaDoc strNotShown = vars.getInStringParameter("inpNotShown");
96       String JavaDoc strShown = vars.getInStringParameter("inpShown");
97       String JavaDoc strOrg = vars.getGlobalVariable("inpOrg", "ReportMaterialDimensionalAnalysesJR|org", "0");
98       String JavaDoc strOrder = vars.getRequestGlobalVariable("inpOrder","ReportMaterialDimensionalAnalysesJR|order");
99       String JavaDoc strMayor = vars.getStringParameter("inpMayor", "");
100       String JavaDoc strMenor = vars.getStringParameter("inpMenor", "");
101       String JavaDoc strComparative = vars.getStringParameter("inpComparative", "N");
102       printPageHtml(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor, "pdf");
103     } else pageErrorPopUp(response);
104   }
105
106   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 {
107     if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet");
108     String JavaDoc discard[]={"selEliminarHeader1"};
109     if (strComparative.equals("Y")) {
110       discard[0] = "selEliminarHeader2";
111     }
112     XmlDocument xmlDocument=null;
113     xmlDocument = xmlEngine.readXmlTemplate("org/openbravo/erpCommon/ad_reports/ReportMaterialDimensionalAnalysesFilterJR", discard).createXmlDocument();
114
115     ToolBar toolbar = new ToolBar(this, vars.getLanguage(), "ReportMaterialDimensionalAnalysesFilterJR", 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, "ReportMaterialDimensionalAnalysesFilterJR.html");
121       xmlDocument.setParameter("keyMap", key.getReportKeyMaps());
122     } catch (Exception JavaDoc ex) {
123       throw new ServletException(ex);
124     }
125     try {
126       WindowTabs tabs = new WindowTabs(this, vars, "org.openbravo.erpCommon.ad_reports.ReportMaterialDimensionalAnalysesJR");
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(), "ReportMaterialDimensionalAnalysesFilterJR.html", classInfo.id, classInfo.type, strReplaceWith, tabs.breadcrumb());
132       xmlDocument.setParameter("navigationBar", nav.toString());
133       LeftTabsBar lBar = new LeftTabsBar(this, vars.getLanguage(), "ReportMaterialDimensionalAnalysesFilterJR.html", strReplaceWith);
134       xmlDocument.setParameter("leftTabs", lBar.manualTemplate());
135     } catch (Exception JavaDoc ex) {
136       throw new ServletException(ex);
137     }
138     {
139       OBError myMessage = vars.getMessage("ReportMaterialDimensionalAnalysesJR");
140       vars.removeMessage("ReportMaterialDimensionalAnalysesJR");
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("calendar", vars.getLanguage().substring(0,2));
149     xmlDocument.setParameter("language", "LNG_POR_DEFECTO=\"" + vars.getLanguage() + "\";");
150     xmlDocument.setParameter("direction", "var baseDirection = \"" + strReplaceWith + "/\";\n");
151     xmlDocument.setParameter("dateFrom", strDateFrom);
152     xmlDocument.setParameter("dateFromdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
153     xmlDocument.setParameter("dateFromsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
154     xmlDocument.setParameter("dateTo", strDateTo);
155     xmlDocument.setParameter("dateTodisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
156     xmlDocument.setParameter("dateTosaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
157     xmlDocument.setParameter("dateFromRef", strDateFromRef);
158     xmlDocument.setParameter("dateFromRefdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
159     xmlDocument.setParameter("dateFromRefsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
160     xmlDocument.setParameter("dateToRef", strDateToRef);
161     xmlDocument.setParameter("dateToRefdisplayFormat", vars.getSessionValue("#AD_SqlDateFormat"));
162     xmlDocument.setParameter("dateToRefsaveFormat", vars.getSessionValue("#AD_SqlDateFormat"));
163     /*xmlDocument.setParameter("paramBPartnerId", strcBpartnerId);
164       xmlDocument.setParameter("bPartnerDescription", ReportMaterialDimensionalAnalysesData.selectBpartner(this, strcBpartnerId));
165       xmlDocument.setParameter("mProduct", strmProductId);
166       xmlDocument.setParameter("productDescription", ReportMaterialDimensionalAnalysesData.selectMproduct(this, strmProductId));*/
167     xmlDocument.setParameter("cBpGroupId", strPartnerGroup);
168     xmlDocument.setParameter("mProductCategoryId", strProductCategory);
169     xmlDocument.setParameter("adOrgId", strOrg);
170     xmlDocument.setParameter("normal", strOrder);
171     xmlDocument.setParameter("amountasc", strOrder);
172     xmlDocument.setParameter("amountdesc", strOrder);
173     xmlDocument.setParameter("mayor", strMayor);
174     xmlDocument.setParameter("menor", strMenor);
175     xmlDocument.setParameter("comparative", strComparative);
176     try {
177       ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "C_BP_Group_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportMaterialDimensionalAnalysesJR"), Utility.getContext(this, vars, "#User_Client", "ReportMaterialDimensionalAnalysesJR"), 0);
178       Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportMaterialDimensionalAnalysesJR", strPartnerGroup);
179       xmlDocument.setData("reportC_BP_GROUPID","liststructure", comboTableData.select(false));
180       comboTableData = null;
181     } catch (Exception JavaDoc ex) {
182       throw new ServletException(ex);
183     }
184
185
186     try {
187       ComboTableData comboTableData = new ComboTableData(vars, this, "TABLEDIR", "M_Product_Category_ID", "", "", Utility.getContext(this, vars, "#User_Org", "ReportMaterialDimensionalAnalysesJR"), Utility.getContext(this, vars, "#User_Client", "ReportMaterialDimensionalAnalysesJR"), 0);
188       Utility.fillSQLParameters(this, vars, null, comboTableData, "ReportMaterialDimensionalAnalysesJR", strProductCategory);
189       xmlDocument.setData("reportM_PRODUCT_CATEGORYID","liststructure", comboTableData.select(false));
190       comboTableData = null;
191     } catch (Exception JavaDoc ex) {
192       throw new ServletException(ex);
193     }
194
195     xmlDocument.setData("reportAD_ORGID", "liststructure", OrganizationComboData.selectCombo(this, vars.getRole()));
196     xmlDocument.setData("reportCBPartnerId_IN", "liststructure", ReportMaterialDimensionalAnalysesJRData.selectBpartner(this, Utility.getContext(this, vars, "#User_Org", ""), Utility.getContext(this, vars, "#User_Client", ""), strcBpartnerId));
197     xmlDocument.setData("reportMProductId_IN", "liststructure", ReportMaterialDimensionalAnalysesJRData.selectMproduct(this, Utility.getContext(this, vars, "#User_Org", ""), Utility.getContext(this, vars, "#User_Client", ""), strmProductId));
198
199
200
201     if (vars.getLanguage().equals("en_US")) {
202       xmlDocument.setData("structure1", ReportMaterialDimensionalAnalysesJRData.selectNotShown(this, strShown));
203       xmlDocument.setData("structure2", strShown.equals("")?new ReportMaterialDimensionalAnalysesJRData[0]:ReportMaterialDimensionalAnalysesJRData.selectShown(this, strShown));
204     } else {
205       xmlDocument.setData("structure1", ReportMaterialDimensionalAnalysesJRData.selectNotShownTrl(this, vars.getLanguage(), strShown));
206       xmlDocument.setData("structure2", strShown.equals("")?new ReportMaterialDimensionalAnalysesJRData[0]:ReportMaterialDimensionalAnalysesJRData.selectShownTrl(this, vars.getLanguage(), strShown));
207     }
208
209
210     response.setContentType("text/html; charset=UTF-8");
211     PrintWriter out = response.getWriter();
212     out.println(xmlDocument.print());
213     out.close();
214   }
215
216   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{
217     if (log4j.isDebugEnabled()) log4j.debug("Output: print html");
218     String JavaDoc strOrderby = "";
219     String JavaDoc[] discard = {"", "", "", "", ""};
220     String JavaDoc[] discard1={"selEliminarBody1", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard", "discard"};
221     if (strComparative.equals("Y")) discard1[0] = "selEliminarBody2";
222     String JavaDoc strTitle = "";
223     strTitle = "del "+strDateFrom+" al "+strDateTo;
224     if (!strPartnerGroup.equals("")) strTitle = strTitle+", para el grupo de terceros "+ReportMaterialDimensionalAnalysesJRData.selectBpgroup(this, strPartnerGroup);
225     //if (!strcBpartnerId.equals("")) strTitle = strTitle+", para el tercero "+ReportMaterialDimensionalAnalysesData.selectBpartner(this, strcBpartnerId);
226 if (!strProductCategory.equals("")) strTitle = strTitle+" y categoria de producto "+ReportMaterialDimensionalAnalysesJRData.selectProductCategory(this, strProductCategory);
227     //if (!strmProductId.equals("")) strTitle = strTitle+" y el producto "+ReportMaterialDimensionalAnalysesData.selectMproduct(this, strmProductId);
228
229     ReportMaterialDimensionalAnalysesJRData[] data = null;
230     String JavaDoc[] strShownArray = {"", "", "", "", ""};
231     if (strShown.startsWith("(")) strShown = strShown.substring(1, strShown.length()-1);
232     if (!strShown.equals("")) {
233       strShown = Replace.replace(strShown, "'", "");
234       strShown = Replace.replace(strShown, " ", "");
235       StringTokenizer st = new StringTokenizer(strShown, ",", false);
236       int intContador = 0;
237       while (st.hasMoreTokens()){
238         strShownArray[intContador] = st.nextToken();
239         intContador++;
240       }
241
242     }
243     ReportMaterialDimensionalAnalysesJRData[] dimensionLabel = null;
244     if (vars.getLanguage().equals("en_US")) {
245       dimensionLabel = ReportMaterialDimensionalAnalysesJRData.selectNotShown(this, "");
246     } else {
247       dimensionLabel = ReportMaterialDimensionalAnalysesJRData.selectNotShownTrl(this, vars.getLanguage(), "");
248     }
249     String JavaDoc[] strTextShow = {"", "", "", "", ""};
250     String JavaDoc[] strLevelLabel = {"", "", "", "", ""};
251     int intDiscard = 0;
252     int intProductLevel = 6;
253     int intAuxDiscard = -1;
254     for (int i = 0; i<5; i++){
255       if (strShownArray[i].equals("1")) {
256         strTextShow[i] = "C_BP_GROUP.NAME";
257         intDiscard++;
258         strLevelLabel[i] = dimensionLabel[0].name;
259       }
260       else if (strShownArray[i].equals("2")) {
261         strTextShow[i] = "AD_COLUMN_IDENTIFIER(to_char('C_Bpartner'), to_char( C_BPARTNER.C_BPARTNER_ID), to_char( 'es_ES'))";
262         intDiscard++;
263         strLevelLabel[i] = dimensionLabel[1].name;
264       }
265       else if (strShownArray[i].equals("3")) {
266         strTextShow[i] = "M_PRODUCT_CATEGORY.NAME";
267         intDiscard++;
268         strLevelLabel[i] = dimensionLabel[2].name;
269       }
270       else if (strShownArray[i].equals("4")) {
271         strTextShow[i] = "AD_COLUMN_IDENTIFIER(to_char('M_Product'), to_char( M_PRODUCT.M_PRODUCT_ID), to_char( 'es_ES'))";
272         intAuxDiscard = i;
273         intDiscard++;
274         intProductLevel = i+1;
275         strLevelLabel[i] = dimensionLabel[3].name;
276       }
277       else if (strShownArray[i].equals("5")) {
278         strTextShow[i] = "M_INOUT.DOCUMENTNO";
279         intDiscard++;
280         strLevelLabel[i] = dimensionLabel[4].name;
281       }
282       else {
283         strTextShow[i] = "''";
284         discard[i] = "display:none;";
285       }
286     }
287     if (intDiscard != 0 || intAuxDiscard != -1){
288       int k=1;
289       strOrderby = " ORDER BY NIVEL"+k+",";
290       while (k<intDiscard){
291         strOrderby = strOrderby+"NIVEL"+k+",";
292         k++;
293       }
294       if (k==1){
295         if (strOrder.equals("Normal")){
296           strOrderby = " ORDER BY NIVEL"+k;
297         } else if (strOrder.equals("Amountasc")){
298           strOrderby = " ORDER BY LINENETAMT ASC";
299         } else if (strOrder.equals("Amountdesc")){
300           strOrderby = " ORDER BY LINENETAMT DESC";
301         } else{
302           strOrderby = "1";
303         }
304       } else{
305         if (strOrder.equals("Normal")){
306           strOrderby += "NIVEL"+k;
307         } else if (strOrder.equals("Amountasc")){
308           strOrderby += "LINENETAMT ASC";
309         } else if (strOrder.equals("Amountdesc")){
310           strOrderby += "LINENETAMT DESC";
311         } else{
312           strOrderby = "1";
313         }
314       }
315
316     } else{
317       strOrderby = " ORDER BY 1";
318     }
319     String JavaDoc strHaving = "";
320     if (!strMayor.equals("") && !strMenor.equals("")) {strHaving = " HAVING SUM(LINENETAMT) > "+strMayor+" AND SUM(LINENETAMT) < "+strMenor;}
321     else if (!strMayor.equals("") && strMenor.equals("")) {strHaving = " HAVING SUM(LINENETAMT) > "+strMayor;}
322     else if (strMayor.equals("") && !strMenor.equals("")) {strHaving = " HAVING SUM(LINENETAMT) < "+strMenor;}
323     else{ strHaving = " HAVING SUM(MOVEMENTQTY) <> 0 OR SUM(MOVEMENTQTYREF) <> 0";}
324     strOrderby = strHaving + strOrderby;
325     String JavaDoc strReportPath = "";
326     if (strComparative.equals("Y")){
327       strReportPath = "@basedesign@/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml";
328       data = ReportMaterialDimensionalAnalysesJRData.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", "ReportMaterialDimensionalAnalysesJR"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strDateFromRef, DateTimeData.nDaysAfter(this, strDateToRef,"1"), strOrderby);
329     } else {
330       strReportPath = "@basedesign@/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml";
331       data = ReportMaterialDimensionalAnalysesJRData.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", "ReportMaterialDimensionalAnalysesJR"), strDateFrom, DateTimeData.nDaysAfter(this, strDateTo,"1"), strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strOrderby);
332     }
333
334     if (data.length == 0 || data == null){
335       //discard1[0] = "selEliminar1";
336 data = ReportMaterialDimensionalAnalysesJRData.set();
337     }
338     HashMap<String JavaDoc, Object JavaDoc> parameters = new HashMap<String JavaDoc, Object JavaDoc>();
339     parameters.put("LEVEL1_LABEL", strLevelLabel[0]);
340     parameters.put("LEVEL2_LABEL", strLevelLabel[1]);
341     parameters.put("LEVEL3_LABEL", strLevelLabel[2]);
342     parameters.put("LEVEL4_LABEL", strLevelLabel[3]);
343     parameters.put("LEVEL5_LABEL", strLevelLabel[4]);
344     parameters.put("DIMENSIONS", new Integer JavaDoc(intDiscard));
345     parameters.put("REPORT_TITLE", classInfo.name);
346     parameters.put("REPORT_SUBTITLE", strTitle);
347     parameters.put("PRODUCT_LEVEL", new Integer JavaDoc(intProductLevel));
348     renderJR(vars, response, strReportPath, strOutput, parameters, data, null );
349
350   }
351
352   public String JavaDoc getServletInfo() {
353     return "Servlet ReportPurchaseDimensionalAnalysesJR. This Servlet was made by Jon Alegría";
354   } // end of getServletInfo() method
355 }
356
357
Popular Tags