1 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 ; 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 strDateFrom = vars.getGlobalVariable("inpDateFrom", "ReportPurchaseDimensionalAnalysesJR|dateFrom", ""); 60 String strDateTo = vars.getGlobalVariable("inpDateTo", "ReportPurchaseDimensionalAnalysesJR|dateTo", ""); 61 String strDateFromRef = vars.getGlobalVariable("inpDateFromRef", "ReportPurchaseDimensionalAnalysesJR|dateFromRef", ""); 62 String strDateToRef = vars.getGlobalVariable("inpDateToRef", "ReportPurchaseDimensionalAnalysesJR|dateToRef", ""); 63 String strPartnerGroup = vars.getGlobalVariable("inpPartnerGroup", "ReportPurchaseDimensionalAnalysesJR|partnerGroup", ""); 64 String strcBpartnerId = vars.getInGlobalVariable("inpcBPartnerId_IN", "ReportPurchaseDimensionalAnalysesJR|partner", ""); 65 String strProductCategory = vars.getGlobalVariable("inpProductCategory", "ReportPurchaseDimensionalAnalysesJR|productCategory", ""); 66 String strmProductId = vars.getInGlobalVariable("inpmProductId_IN", "ReportPurchaseDimensionalAnalysesJR|product", ""); 67 String strNotShown = vars.getInGlobalVariable("inpNotShown", "ReportPurchaseDimensionalAnalysesJR|notShown", ""); 68 String strShown = vars.getInGlobalVariable("inpShown", "ReportPurchaseDimensionalAnalysesJR|shown", ""); 69 String strOrg = vars.getGlobalVariable("inpOrg", "ReportPurchaseDimensionalAnalysesJR|org", "0"); 70 String strOrder = vars.getGlobalVariable("inpOrder","ReportPurchaseDimensionalAnalyze|order","Normal"); 71 String strMayor = vars.getGlobalVariable("inpMayor", "ReportPurchaseDimensionalAnalyze|mayor", ""); 72 String strMenor = vars.getGlobalVariable("inpMenor", "ReportPurchaseDimensionalAnalyze|menor", ""); 73 String 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 strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportPurchaseDimensionalAnalysesJR|dateFrom"); 79 String strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportPurchaseDimensionalAnalysesJR|dateTo"); 80 String strDateFromRef = vars.getRequestGlobalVariable("inpDateFromRef", "ReportPurchaseDimensionalAnalysesJR|dateFromRef"); 81 String strDateToRef = vars.getRequestGlobalVariable("inpDateToRef", "ReportPurchaseDimensionalAnalysesJR|dateToRef"); 82 String strPartnerGroup = vars.getRequestGlobalVariable("inpPartnerGroup", "ReportPurchaseDimensionalAnalysesJR|partnerGroup"); 83 String strcBpartnerId = vars.getRequestInGlobalVariable("inpcBPartnerId_IN", "ReportPurchaseDimensionalAnalysesJR|partner"); 84 String strProductCategory = vars.getRequestGlobalVariable("inpProductCategory", "ReportPurchaseDimensionalAnalysesJR|productCategory"); 85 String strmProductId = vars.getRequestInGlobalVariable("inpmProductId_IN", "ReportPurchaseDimensionalAnalysesJR|product"); 86 String strNotShown = vars.getInStringParameter("inpNotShown"); 87 String strShown = vars.getInStringParameter("inpShown"); 88 String strOrg = vars.getGlobalVariable("inpOrg", "ReportPurchaseDimensionalAnalysesJR|org", "0"); 89 String strOrder = vars.getRequestGlobalVariable("inpOrder","ReportPurchaseDimensionalAnalysesJR|order"); 90 String strMayor = vars.getStringParameter("inpMayor", ""); 91 String strMenor = vars.getStringParameter("inpMenor", ""); 92 String 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 strDateFrom = vars.getRequestGlobalVariable("inpDateFrom", "ReportPurchaseDimensionalAnalysesJR|dateFrom"); 96 String strDateTo = vars.getRequestGlobalVariable("inpDateTo", "ReportPurchaseDimensionalAnalysesJR|dateTo"); 97 String strDateFromRef = vars.getRequestGlobalVariable("inpDateFromRef", "ReportPurchaseDimensionalAnalysesJR|dateFromRef"); 98 String strDateToRef = vars.getRequestGlobalVariable("inpDateToRef", "ReportPurchaseDimensionalAnalysesJR|dateToRef"); 99 String strPartnerGroup = vars.getRequestGlobalVariable("inpPartnerGroup", "ReportPurchaseDimensionalAnalysesJR|partnerGroup"); 100 String strcBpartnerId = vars.getRequestInGlobalVariable("inpcBPartnerId_IN", "ReportPurchaseDimensionalAnalysesJR|partner"); 101 String strProductCategory = vars.getRequestGlobalVariable("inpProductCategory", "ReportPurchaseDimensionalAnalysesJR|productCategory"); 102 String strmProductId = vars.getRequestInGlobalVariable("inpmProductId_IN", "ReportPurchaseDimensionalAnalysesJR|product"); 103 String strNotShown = vars.getInStringParameter("inpNotShown"); 104 String strShown = vars.getInStringParameter("inpShown"); 105 String strOrg = vars.getGlobalVariable("inpOrg", "ReportPurchaseDimensionalAnalysesJR|org", "0"); 106 String strOrder = vars.getRequestGlobalVariable("inpOrder","ReportPurchaseDimensionalAnalysesJR|order"); 107 String strMayor = vars.getStringParameter("inpMayor", ""); 108 String strMenor = vars.getStringParameter("inpMenor", ""); 109 String strComparative = vars.getStringParameter("inpComparative", "N"); 110 printPageHtml(response, vars, strComparative, strDateFrom, strDateTo, strPartnerGroup, strcBpartnerId, strProductCategory, strmProductId, strNotShown, strShown, strDateFromRef, strDateToRef, strOrg, strOrder, strMayor, strMenor, "pdf"); 112 } else pageErrorPopUp(response); 114 } 115 116 void printPageDataSheet(HttpServletResponse response, VariablesSecureApp vars, String strComparative, String strDateFrom, String strDateTo, String strPartnerGroup, String strcBpartnerId, String strProductCategory, String strmProductId, String strNotShown, String strShown, String strDateFromRef, String strDateToRef, String strOrg, String strOrder, String strMayor, String strMenor) throws IOException, ServletException { 117 if (log4j.isDebugEnabled()) log4j.debug("Output: dataSheet"); 118 String 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 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 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 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 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 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 strComparative, String strDateFrom, String strDateTo, String strPartnerGroup, String strcBpartnerId, String strProductCategory, String strmProductId, String strNotShown, String strShown, String strDateFromRef, String strDateToRef, String strOrg, String strOrder, String strMayor, String strMenor, String strOutput) throws IOException, ServletException{ 227 if (log4j.isDebugEnabled()) log4j.debug("Output: print html"); 228 HashMap<String , Object > parameters = new HashMap<String , Object >(); 229 String strOrderby = ""; 230 String [] discard = {"", "", "", "", ""}; 231 String [] 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 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 [] 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 [] strLevelLabel = {"", "", "", "", ""}; 263 String [] 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 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 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 { 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 (intDiscard)); 357 parameters.put("REPORT_TITLE", classInfo.name); 358 parameters.put("REPORT_SUBTITLE", strTitle); 359 parameters.put("PRODUCT_LEVEL", new Integer (intProductLevel)); 360 renderJR(vars, response, strReportPath, strOutput, parameters, data, null ); 361 } 362 363 public String getServletInfo() { 364 return "Servlet ReportPurchaseDimensionalAnalysesJR. This Servlet was made by Jon AlegrÃa"; 365 } } 367 368 | Popular Tags |