gerrit.onap Code Review - portal/sdk.git/blob

   1 /*
   2  * ============LICENSE_START==========================================
   3  * ONAP Portal SDK
   4  * ===================================================================
   5  * Copyright © 2017 AT&T Intellectual Property. All rights reserved.
   6  * ===================================================================
   7  *
   8  * Unless otherwise specified, all software contained herein is licensed
   9  * under the Apache License, Version 2.0 (the "License");
  10  * you may not use this software except in compliance with the License.
  11  * You may obtain a copy of the License at
  12  *
  13  *             http://www.apache.org/licenses/LICENSE-2.0
  14  *
  15  * Unless required by applicable law or agreed to in writing, software
  16  * distributed under the License is distributed on an "AS IS" BASIS,
  17  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  18  * See the License for the specific language governing permissions and
  19  * limitations under the License.
  20  *
  21  * Unless otherwise specified, all documentation contained herein is licensed
  22  * under the Creative Commons License, Attribution 4.0 Intl. (the "License");
  23  * you may not use this documentation except in compliance with the License.
  24  * You may obtain a copy of the License at
  25  *
  26  *             https://creativecommons.org/licenses/by/4.0/
  27  *
  28  * Unless required by applicable law or agreed to in writing, documentation
  29  * distributed under the License is distributed on an "AS IS" BASIS,
  30  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  31  * See the License for the specific language governing permissions and
  32  * limitations under the License.
  33  *
  34  * ============LICENSE_END============================================
  35  *
  36  *
  37  */
  38 package org.onap.portalsdk.analytics.controller;
  39
  40 import java.text.SimpleDateFormat;
  41 import java.util.ArrayList;
  42 import java.util.Calendar;
  43 import java.util.Collections;
  44 import java.util.Iterator;
  45 import java.util.List;
  46 import java.util.TimeZone;
  47
  48 import javax.servlet.http.HttpServletRequest;
  49 import javax.xml.datatype.DatatypeConfigurationException;
  50 import javax.xml.datatype.DatatypeFactory;
  51 import javax.xml.datatype.XMLGregorianCalendar;
  52
  53 import org.onap.portalsdk.analytics.error.RaptorException;
  54 import org.onap.portalsdk.analytics.error.ValidationException;
  55 import org.onap.portalsdk.analytics.model.ReportHandler;
  56 import org.onap.portalsdk.analytics.model.ReportLoader;
  57 import org.onap.portalsdk.analytics.model.base.IdNameValue;
  58 import org.onap.portalsdk.analytics.model.base.OrderBySeqComparator;
  59 import org.onap.portalsdk.analytics.model.base.OrderSeqComparator;
  60 import org.onap.portalsdk.analytics.model.definition.ReportDefinition;
  61 import org.onap.portalsdk.analytics.model.definition.ReportSchedule;
  62 import org.onap.portalsdk.analytics.model.runtime.FormField;
  63 import org.onap.portalsdk.analytics.model.runtime.ReportRuntime;
  64 import org.onap.portalsdk.analytics.system.AppUtils;
  65 import org.onap.portalsdk.analytics.system.DbUtils;
  66 import org.onap.portalsdk.analytics.system.Globals;
  67 import org.onap.portalsdk.analytics.util.AppConstants;
  68 import org.onap.portalsdk.analytics.util.DataSet;
  69 import org.onap.portalsdk.analytics.util.XSSFilter;
  70 import org.onap.portalsdk.analytics.xmlobj.ChartDrillFormfield;
  71 import org.onap.portalsdk.analytics.xmlobj.ColFilterType;
  72 import org.onap.portalsdk.analytics.xmlobj.DataColumnType;
  73 import org.onap.portalsdk.analytics.xmlobj.DataSourceType;
  74 import org.onap.portalsdk.analytics.xmlobj.FormFieldType;
  75 import org.onap.portalsdk.analytics.xmlobj.FormatType;
  76 import org.onap.portalsdk.analytics.xmlobj.JavascriptItemType;
  77 import org.onap.portalsdk.analytics.xmlobj.Marker;
  78 import org.onap.portalsdk.analytics.xmlobj.ObjectFactory;
  79 import org.onap.portalsdk.analytics.xmlobj.SemaphoreType;
  80 import org.onap.portalsdk.core.logging.logic.EELFLoggerDelegate;
  81
  82 /**<HR/>
  83  * This class is part of <B><I>RAPTOR (Rapid Application Programming Tool for OLAP Reporting)</I></B><BR/>
  84  * <HR/>
  85  *
  86  * --------------------------------------------------------------------------------------------------<BR/>
  87  * <B>WizardProcessor.java</B> - This class is used to process the user input provided in the wizard.<BR/>
  88  * It is called in creation as well as updation process. It builds report xml via JAXB using user<BR/>
  89  * input. This is vital one, to store meta information of each report<BR/>
  90  * ---------------------------------------------------------------------------------------------------<BR/>
  91  *
  92  *
  93  * <U>Change Log</U><BR/><BR/>
  94  *
  95  * 31-Aug-2009 : Version 8.5.1 (Sundar);<UL><LI> For Time Series multi series property is exposed. </LI></UL>
  96  * 28-Aug-2009 : Version 8.5.1 (Sundar);<UL><LI> If user login id is null, it would display user name when user is added for schedule. </LI></UL>
  97  * 18-Aug-2009 : Version 8.5.1 (Sundar);<UL><LI> request Object is passed to prevent caching user/roles - Datamining/Hosting. </LI></UL>
  98  * 12-Aug-2009 : Version 8.5 (Sundar); <UL><LI> For Line Charts too options are captured and rendering is customized. </LI></UL>
  99  * 29-Jul-2009 : Version 8.4 (Sundar); <UL><LI> Maximum Excel Download size would be persisted if changed. </LI></UL>
 100  * 14-Jul-2009 : Version 8.4 (Sundar); <UL><LI> Schedule feature is added to Dashboard Reports. </LI></UL>
 101  * 29-Jun-2009 : Version 8.4 (Sundar); <UL><LI> Options for <I>Compare to Previous year Chart</I> are processed.</LI>
 102  *                                                                              <LI> In the Bar chart Last Occuring Series/Category can be plotted as Bar or Line Renderer. </LI>
 103  *                                                                        </UL>
 104  * 22-Jun-2009 : Version 8.4 (Sundar); <UL><LI> processChart method is modified to accommodate creating
 105  * Bar Charts, Time Difference Charts and adding generic chart options.</LI></UL>
 106  *
 107  */
 108
 109 public class WizardProcessor extends org.onap.portalsdk.analytics.RaptorObject {
 110         private static final EELFLoggerDelegate logger = EELFLoggerDelegate.getLogger(WizardProcessor.class);
 111
 112         public WizardProcessor() {
 113         }
 114
 115         public static Calendar getCalendar(XMLGregorianCalendar xmlCalendar){
 116             TimeZone timeZone = xmlCalendar.getTimeZone(xmlCalendar.getTimezone());
 117             Calendar calendar = Calendar.getInstance(timeZone);
 118             calendar.set(Calendar.YEAR,xmlCalendar.getYear());
 119             calendar.set(Calendar.MONTH,xmlCalendar.getMonth()-1);
 120             calendar.set(Calendar.DATE,xmlCalendar.getDay());
 121             calendar.set(Calendar.HOUR_OF_DAY,xmlCalendar.getHour());
 122             calendar.set(Calendar.MINUTE,xmlCalendar.getMinute());
 123             calendar.set(Calendar.SECOND,xmlCalendar.getSecond());
 124             return calendar;
 125         }
 126
 127         private String adjustDataType(String oracleDataType) {
 128                 return "VARCHAR2".equals(oracleDataType) ? AppConstants.CT_CHAR : oracleDataType;
 129                 // Probably should be expanded to convert any CHAR or VARCHAR type to
 130                 // CT_CHAR, number type to CT_NUMBER and date to CT_DATE
 131         } // adjustDataType
 132
 133         public void persistReportDefinition(HttpServletRequest request, ReportDefinition rdef)
 134                         throws RaptorException {
 135                 ReportRuntime rr = (ReportRuntime) request.getSession().getAttribute(
 136                                 AppConstants.SI_REPORT_RUNTIME);
 137                 if (rr != null && rr.getReportID().equals(rdef.getReportID()))
 138                         request.getSession().removeAttribute(AppConstants.SI_REPORT_RUNTIME);
 139                 rdef.persistReport(request);
 140         } // persistReportDefinition
 141
 142         public void processWizardStep(HttpServletRequest request) throws Exception {
 143                 String action = nvl(request.getParameter(AppConstants.RI_WIZARD_ACTION),
 144                                 AppConstants.WA_BACK);
 145
 146                 String reportID = AppUtils.getRequestValue(request, AppConstants.RI_REPORT_ID);
 147                 ReportDefinition rdef = (new ReportHandler()).loadReportDefinition(request, reportID);
 148                 request.getSession().setAttribute(AppConstants.SI_REPORT_DEFINITION, rdef);
 149
 150                 String curStep = rdef.getWizardSequence().getCurrentStep();
 151                 String curSubStep = rdef.getWizardSequence().getCurrentSubStep();
 152                 if (AppUtils.getRequestNvlValue(request, "showDashboardOptions").length()<=0)
 153                    request.setAttribute("showDashboardOptions", "F");
 154         logger.debug(EELFLoggerDelegate.debugLogger, ("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^curStep " + curStep + " " + curSubStep + " " + action));
 155                 boolean reportUpdated = false;
 156                 if (!action.equals(AppConstants.WA_BACK)) {
 157                         if (curStep.equals(AppConstants.WS_DEFINITION)) {
 158                                 reportUpdated = processDefinition(request);
 159                         } else if (curStep.equals(AppConstants.WS_SQL)) {
 160                                 if (action.equals(AppConstants.WA_VALIDATE))
 161                                         reportUpdated = processValidateSQL(request);
 162                         } else if (curStep.equals(AppConstants.WS_TABLES)) {
 163                                 if (curSubStep.equals(AppConstants.WSS_ADD))
 164                                         reportUpdated = processTableAdd(request);
 165                                 else if (curSubStep.equals(AppConstants.WSS_EDIT))
 166                                         reportUpdated = processTableEdit(request);
 167                                 else if (action.equals(AppConstants.WA_DELETE))
 168                                         reportUpdated = processTableDelete(request);
 169                         } else if (curStep.equals(AppConstants.WS_COLUMNS)) {
 170                                 if (curSubStep.equals(AppConstants.WSS_ADD)
 171                                                 || curSubStep.equals(AppConstants.WSS_EDIT) || action.equals(AppConstants.WA_SAVE) || action.equals(AppConstants.WA_NEXT)) {
 172                                         reportUpdated = processColumnAddEdit(request, curSubStep
 173                                                         .equals(AppConstants.WSS_EDIT) || curSubStep
 174                                                         .equals(AppConstants.WA_MODIFY));
 175                                 }
 176                                 else if (curSubStep.equals(AppConstants.WSS_ADD_MULTI))
 177                                         reportUpdated = processColumnAddMulti(request);
 178                                 else if (curSubStep.equals(AppConstants.WSS_ORDER_ALL))
 179                                         reportUpdated = processColumnOrderAll(request);
 180                                 else if (action.equals(AppConstants.WA_DELETE))
 181                                         reportUpdated = processColumnDelete(request);
 182                                 else if (action.equals(AppConstants.WA_MOVE_UP))
 183                                         reportUpdated = processColumnMoveUp(request);
 184                                 else if (action.equals(AppConstants.WA_MOVE_DOWN))
 185                                         reportUpdated = processColumnMoveDown(request);
 186                         } else if (curStep.equals(AppConstants.WS_FORM_FIELDS)) {
 187                                 if (curSubStep.equals(AppConstants.WSS_ADD)
 188                                                 || curSubStep.equals(AppConstants.WSS_EDIT))
 189                                         reportUpdated = processFormFieldAddEdit(request, curSubStep
 190                                                         .equals(AppConstants.WSS_EDIT), action);
 191                                 else if (action.equals(AppConstants.WA_DELETE))
 192                                         reportUpdated = processFormFieldDelete(request);
 193                                 else if (action.equals(AppConstants.WA_MOVE_UP))
 194                                         reportUpdated = processFormFieldMoveUp(request);
 195                                 else if (action.equals(AppConstants.WA_MOVE_DOWN))
 196                                         reportUpdated = processFormFieldMoveDown(request);
 197                                 else if (action.equals(AppConstants.WSS_ADD_BLANK))
 198                                         reportUpdated = processFormFieldBlank(request);
 199                                 else if (action.equals(AppConstants.WSS_INFO_BAR))
 200                                         reportUpdated = processFormFieldInfoBar(request);
 201                         } else if (curStep.equals(AppConstants.WS_FILTERS)) {
 202                                 if (curSubStep.equals(AppConstants.WSS_ADD)
 203                                                 || curSubStep.equals(AppConstants.WSS_EDIT))
 204                                         reportUpdated = processFilterAddEdit(request, curSubStep
 205                                                         .equals(AppConstants.WSS_EDIT));
 206                                 else if (action.equals(AppConstants.WA_DELETE))
 207                                         reportUpdated = processFilterDelete(request);
 208                         } else if (curStep.equals(AppConstants.WS_SORTING)) {
 209                                 if (curSubStep.equals(AppConstants.WSS_ADD)
 210                                                 || curSubStep.equals(AppConstants.WSS_EDIT))
 211                                         reportUpdated = processSortAddEdit(request, curSubStep
 212                                                         .equals(AppConstants.WSS_EDIT));
 213                                 else if (curSubStep.equals(AppConstants.WSS_ORDER_ALL))
 214                                         reportUpdated = processSortOrderAll(request);
 215                                 else if (action.equals(AppConstants.WA_DELETE))
 216                                         reportUpdated = processSortDelete(request);
 217                                 else if (action.equals(AppConstants.WA_MOVE_UP))
 218                                         reportUpdated = processSortMoveUp(request);
 219                                 else if (action.equals(AppConstants.WA_MOVE_DOWN))
 220                                         reportUpdated = processSortMoveDown(request);
 221                         } else if (curStep.equals(AppConstants.WS_JAVASCRIPT)) {
 222                                 if (action.equals(AppConstants.WSS_ADD))
 223                                         reportUpdated = processAddJavascriptElement(request);
 224                                 else if (action.equals(AppConstants.WA_SAVE))
 225                                         reportUpdated = processSaveJavascriptElement(request);
 226                                 else if (action.equals(AppConstants.WA_DELETE))
 227                                         reportUpdated = processDeleteJavascriptElement(request);
 228                                 else
 229                                         reportUpdated = processJavascript(request);
 230                         } else if (curStep.equals(AppConstants.WS_CHART)) {
 231                                 reportUpdated = processChart(request, action);
 232                         } else if (curStep.equals(AppConstants.WS_USER_ACCESS)) {
 233                                 reportUpdated = processUserAccess(request, action);
 234                         } else if (curStep.equals(AppConstants.WS_REPORT_LOG)) {
 235                                 if (action.equals(AppConstants.WA_DELETE_USER))
 236                                         reportUpdated = processClearLog(request);
 237                         } else if (curStep.equals(AppConstants.WS_SCHEDULE)) {
 238                                 reportUpdated = processSchedule(request, action);
 239                         } else if(curStep.equals(AppConstants.WS_DATA_FORECASTING)) {
 240                                 reportUpdated = processForecasting(request, action);
 241                         }
 242                         /****For Report Maps - Start*****/
 243                         else if (curStep.equals(AppConstants.WS_MAP)) {
 244                                 reportUpdated = processMap(request, action);
 245                         }
 246                         /****For Report Maps - End*****/
 247
 248                         // else
 249             }
 250                 if (reportUpdated)
 251                         persistReportDefinition(request, rdef);
 252         } // processWizardStep
 253
 254         public void processImportSemaphorePopup(HttpServletRequest request) throws RaptorException {
 255                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 256                                 AppConstants.SI_REPORT_DEFINITION);
 257
 258                 String importReportId = AppUtils
 259                                 .getRequestNvlValue(request, AppConstants.RI_REPORT_ID);
 260                 ReportRuntime rr = (new ReportHandler()).loadReportRuntime(request, importReportId,
 261                                 false);
 262
 263                 ArrayList importedList = new ArrayList();
 264                 if (rr.getSemaphoreList() != null)
 265                         for (Iterator iter = rr.getSemaphoreList().getSemaphore().iterator(); iter
 266                                         .hasNext();) {
 267                                 SemaphoreType sem = rdef.addSemaphore(new ObjectFactory(),
 268                                                 (SemaphoreType) iter.next());
 269                                 importedList
 270                                                 .add(new IdNameValue(sem.getSemaphoreId(), sem.getSemaphoreName()));
 271                         } // for
 272
 273                 if (!importedList.isEmpty()) {
 274                         request.setAttribute(AppConstants.RI_DATA_SET, importedList);
 275                         persistReportDefinition(request, rdef);
 276                 } // if
 277         } // processImportSemaphorePopup
 278
 279         public void processSemaphorePopup(HttpServletRequest request) throws RaptorException {
 280                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 281                                 AppConstants.SI_REPORT_DEFINITION);
 282
 283                 String semaphoreId = AppUtils.getRequestNvlValue(request, "semaphoreId");
 284                 String semaphoreName = AppUtils.getRequestNvlValue(request, "semaphoreName");
 285                 String semaphoreType = AppUtils.getRequestNvlValue(request, "semaphoreType");
 286
 287                 SemaphoreType semaphore = rdef.getSemaphoreById(semaphoreId);
 288                 if (semaphore == null) {
 289                         semaphore = rdef.addSemaphoreType(new ObjectFactory(), semaphoreName,
 290                                         semaphoreType, null);
 291                         semaphoreId = semaphore.getSemaphoreId();
 292                         request.setAttribute("semaphoreId", semaphoreId);
 293                 } else {
 294                         rdef.deleteSemaphore(semaphore);
 295                         semaphore.setSemaphoreName(semaphoreName);
 296                         semaphore.setSemaphoreType(semaphoreType);
 297
 298                         rdef.setSemaphore(semaphore);
 299                 }
 300
 301                 String[] formatId = request.getParameterValues("formatId");
 302                 String[] lessThanValue = request.getParameterValues("lessThanValue");
 303                 String[] expression = request.getParameterValues("expression");
 304                 String[] bold = request.getParameterValues("bold");
 305                 String[] italic = request.getParameterValues("italic");
 306                 String[] underline = request.getParameterValues("underline");
 307                 String[] bgColor = request.getParameterValues("bgColor");
 308                 String[] fontColor = request.getParameterValues("fontColor");
 309                 String[] fontFace = request.getParameterValues("fontFace");
 310                 String[] fontSize = request.getParameterValues("fontSize");
 311
 312                 for (int i = 0; i < lessThanValue.length; i++)
 313                         if (i == 0 || nvl(lessThanValue[i]).length() > 0) {
 314                                 FormatType fmt = null;
 315                                 if (i == 0 || nvl(formatId[i]).length() > 0)
 316                                         fmt = ReportDefinition.getSemaphoreFormatById(semaphore, nvl(formatId[i]));
 317                                 if (fmt == null)
 318                                         fmt = ReportDefinition.addEmptyFormatType(new ObjectFactory(), semaphore);
 319
 320                                 fmt.setLessThanValue(nvl(lessThanValue[i]));
 321                                 fmt.setExpression(nvl(expression[i]));
 322                                 fmt.setBold("Y".equals(bold[i]));
 323                                 fmt.setItalic("Y".equals(italic[i]));
 324                                 fmt.setUnderline("Y".equals(underline[i]));
 325                                 fmt.setBgColor(bgColor[i]);
 326                                 fmt.setFontColor(fontColor[i]);
 327                                 fmt.setFontFace(fontFace[i]);
 328                                 fmt.setFontSize(fontSize[i]);
 329                         } else if (nvl(formatId[i]).length() > 0)
 330         ReportDefinition.deleteFormatType(semaphore, formatId[i]);
 331
 332                 persistReportDefinition(request, rdef);
 333         } // processSemaphorePopup
 334
 335         private boolean processDefinition(HttpServletRequest request) throws RaptorException {
 336                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 337                                 AppConstants.SI_REPORT_DEFINITION);
 338
 339                 String reportName  = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportName"));
 340                 String reportDescr = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportDescr"));
 341                 String folderId = AppUtils.getRequestNvlValue(request, "folder_id");
 342                 boolean isAllowSchedule = (AppUtils.getRequestNvlValue(request, "allowSchedule").length()<=0?"N":AppUtils.getRequestNvlValue(request, "allowSchedule")).startsWith("Y");
 343                 boolean isColumnGroup = (AppUtils.getRequestNvlValue(request, "multiGroupColumn").length()<=0?"N":AppUtils.getRequestNvlValue(request, "multiGroupColumn")).startsWith("Y");
 344                 boolean isTopDown = (AppUtils.getRequestNvlValue(request, "topDown").length()<=0?"N":AppUtils.getRequestNvlValue(request, "topDown")).startsWith("Y");
 345                 boolean isSizedByContent= (AppUtils.getRequestNvlValue(request, "sizedByContent").length()<=0?"N":AppUtils.getRequestNvlValue(request, "sizedByContent")).startsWith("Y");
 346                 boolean reportsInNewWindow = false;
 347                 boolean hideFormFieldAfterRun = false;
 348
 349                 /*recurrance in schedule tab  - Start*/
 350       String isOneTimeScheduleAllowed = nvl(AppUtils.getRequestValue(request, "isOneTimeScheduleAllowed"),"N");
 351         String isHourlyScheduleAllowed = nvl(AppUtils.getRequestValue(request, "isHourlyScheduleAllowed"),"N");
 352         String isDailyScheduleAllowed = nvl(AppUtils.getRequestValue(request, "isDailyScheduleAllowed"),"N");
 353         String isDailyMFScheduleAllowed = nvl(AppUtils.getRequestValue(request, "isDailyMFScheduleAllowed"),"N");
 354         String isWeeklyScheduleAllowed = nvl(AppUtils.getRequestValue(request, "isWeeklyScheduleAllowed"),"N");
 355         String isMonthlyScheduleAllowed = nvl(AppUtils.getRequestValue(request, "isMonthlyScheduleAllowed"),"N");
 356     /*recurrance in schedule tab  - End*/
 357
 358
 359                 if (reportDescr.length() > 1000)
 360                         reportDescr = reportDescr.substring(0, 1000);
 361                 boolean reportUpdated;
 362
 363                 String reportType = AppUtils.getRequestNvlValue(request, "reportType");
 364
 365                 rdef.setFolderId(folderId);
 366
 367                 if(reportType.equals(AppConstants.RT_DASHBOARD)) {
 368                         rdef.setReportName(reportName);
 369                         rdef.setReportDescr(reportDescr);
 370                         rdef.setReportType(reportType);
 371             String dashboardLayoutHTML = AppUtils.getRequestNvlValue(request, "dashboardLayoutHTML");
 372                         rdef.setDashboardLayoutHTML(dashboardLayoutHTML);
 373                         String dataContainerHeight = nvl(AppUtils.getRequestValue(request, "heightContainer"), "auto");
 374                         String dataContainerWidth = nvl(AppUtils.getRequestValue(request, "widthContainer"), "auto");
 375                         rdef.setDataContainerHeight(dataContainerHeight);
 376                         rdef.setDataContainerWidth(dataContainerWidth);
 377                         rdef.setAllowSchedule(isAllowSchedule?"Y":"N");
 378
 379                         rdef.generateWizardSequence(request);
 380
 381                 } else {
 382
 383                         if (AppUtils.getRequestNvlValue(request, "reportType").equals(AppConstants.RT_CROSSTAB) || rdef.getReportType().equals(AppConstants.RT_CROSSTAB))  {
 384
 385                                 String widthNo = AppUtils.getRequestNvlValue(request, "widthNo");
 386                                 if(nvl(widthNo).endsWith("px"))
 387                                         rdef.setWidthNoColumn(widthNo);
 388                                 else
 389                                         rdef.setWidthNoColumn(widthNo+"px");
 390                         }
 391
 392                         String dataGridAlign = AppUtils.getRequestNvlValue(request, "dataGridAlign");
 393                         if(nvl(dataGridAlign).length()>0) {
 394                                 rdef.setDataGridAlign(dataGridAlign);
 395                         } else {
 396                                 rdef.setDataGridAlign("left");
 397                         }
 398
 399                         String pdfImgLogo = AppUtils.getRequestNvlValue(request, "pdfImg");
 400                         if(nvl(pdfImgLogo).length()>0)
 401                                 rdef.setPdfImg(pdfImgLogo);
 402                         else
 403                                 rdef.setPdfImg(null);
 404                         String emptyMessage = AppUtils.getRequestNvlValue(request, "emptyMessage");
 405                         if(nvl(emptyMessage).length()>0)
 406                                 rdef.setEmptyMessage(emptyMessage);
 407                         else
 408                                 rdef.setEmptyMessage("");
 409                         String formHelp = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "formHelp"));
 410
 411                         if(AppUtils.getRequestNvlValue(request, "excelDownloadSize").length()>0)
 412                          rdef.setMaxRowsInExcelDownload(Integer.parseInt(AppUtils.getRequestValue(request, "excelDownloadSize")));
 413                         if(AppUtils.getRequestNvlValue(request, "reportInNewWindow").length()>0)
 414                                 reportsInNewWindow = "Y".equals(AppUtils.getRequestNvlValue(request,"reportInNewWindow"));
 415                         if(AppUtils.getRequestNvlValue(request, "hideFormFieldsAfterRun").length()>0)
 416                                 hideFormFieldAfterRun = "Y".equals(AppUtils.getRequestNvlValue(request,"hideFormFieldsAfterRun"));
 417
 418
 419                         if(AppUtils.getRequestNvlValue(request, "displayFolderTree").length()>0)
 420                                 rdef.setDisplayFolderTree("Y".equals(AppUtils.getRequestNvlValue(request,"displayFolderTree")));
 421                         else
 422                                 rdef.setDisplayFolderTree(false);
 423                         String dataSource = AppUtils.getRequestNvlValue(request, "dataSource");
 424                         String dbType = Globals.getDBType();
 425                         String schemaSql = Globals.getRemoteDbSchemaSqlWithWhereClause();
 426                         schemaSql = schemaSql.replace("[schema_id]", dataSource);
 427                         DataSet ds = null;
 428                          try {
 429                                 ds = DbUtils.executeQuery(schemaSql);
 430
 431                                 for (int i = 0; i < ds.getRowCount(); i++) {
 432                                         dbType = ds.getItem(i, 2);
 433                                 }
 434                 }
 435                 catch (Exception e) {}
 436
 437                         int pageSize = Globals.getDefaultPageSize();
 438                         try {
 439                                 pageSize = Integer.parseInt(AppUtils.getRequestValue(request, "pageSize"));
 440                         } catch (NumberFormatException e) {
 441                         }
 442                         String rApproved = nvl(AppUtils.getRequestValue(request, "menuApproved"), "N");
 443                         String menuID = "";
 444                         String[] menuIDs = request.getParameterValues("menuID");
 445                         if (menuIDs != null)
 446                                 for (int i = 0; i < menuIDs.length; i++)
 447                                         menuID += (menuID.length() == 0 ? "" : "|") + menuIDs[i];
 448
 449                         boolean rRCSDisabled = "Y".equals(AppUtils.getRequestNvlValue(request, "runtimeColSortDisabled"));
 450                         String reportDefType = AppUtils.getRequestNvlValue(request, "reportDefType");
 451                         String dataContainerHeight = nvl(AppUtils.getRequestValue(request, "heightContainer"), "auto");
 452                         String dataContainerWidth = nvl(AppUtils.getRequestValue(request, "widthContainer"), "auto");
 453
 454                         String displayOptions = nvl(AppUtils.getRequestValue(request, "hideForm"), "N")
 455                                         + nvl(AppUtils.getRequestValue(request, "hideChart"), "N")
 456                                         + nvl(AppUtils.getRequestValue(request, "hideData"), "N")
 457                                         + nvl(AppUtils.getRequestValue(request, "hideBtns"), "N")
 458                                         + nvl(AppUtils.getRequestValue(request, "hideMap"), "N")
 459                                         + nvl(AppUtils.getRequestValue(request, "hideExcelIcons"), "N")
 460                                         + nvl(AppUtils.getRequestValue(request, "hidePDFIcons"), "N");
 461
 462                         String numFormCols = nvl(AppUtils.getRequestValue(request, "numFormCols"), "1");
 463                         String reportTitle = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportTitle"));
 464                         String reportSubTitle = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportSubTitle"));
 465                         String reportHeader = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportHeader"));
 466                         String reportFooter = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportFooter"));
 467
 468                         int frozenColumns = 0;
 469                         try {
 470                                 frozenColumns = Integer.parseInt(AppUtils.getRequestValue(request, "frozenColumns"));
 471                         } catch (NumberFormatException ex) {
 472
 473                         }
 474
 475                         rdef.setReportName(reportName);
 476                         rdef.setReportDescr(reportDescr);
 477                         rdef.setFormHelpText(formHelp);
 478                         rdef.setReportType(reportType);
 479                         rdef.setPageSize(pageSize);
 480                         rdef.setDBInfo(dataSource);
 481                         rdef.setDBType(dbType);
 482                         rdef.setDisplayOptions(displayOptions);
 483                         rdef.setDataContainerHeight(dataContainerHeight);
 484                         rdef.setDataContainerWidth(dataContainerWidth);
 485                         rdef.setAllowSchedule(isAllowSchedule?"Y":"N");
 486                         rdef.setMultiGroupColumn(isColumnGroup?"Y":"N");
 487                         rdef.setTopDown(isTopDown?"Y":"N");
 488                         rdef.setSizedByContent(isSizedByContent?"Y":"N");
 489                         rdef.setMenuID(menuID);
 490                         rdef.setMenuApproved("Y".equals(rApproved));
 491                         if (reportDefType.length() > 0)
 492                                 rdef.setReportDefType(reportDefType);
 493
 494                         rdef.setHideFormFieldAfterRun(hideFormFieldAfterRun);
 495                         rdef.setReportInNewWindow(reportsInNewWindow);
 496                         rdef.setRuntimeColSortDisabled(rRCSDisabled);
 497                         rdef.setNumFormCols(numFormCols);
 498                         rdef.setReportTitle(reportTitle);
 499                         rdef.setReportSubTitle(reportSubTitle);
 500                         rdef.setReportHeader(reportHeader);
 501                         rdef.setReportFooter(reportFooter);
 502                         rdef.setIsOneTimeScheduleAllowed(isOneTimeScheduleAllowed);
 503                         rdef.setIsHourlyScheduleAllowed(isHourlyScheduleAllowed);
 504             rdef.setIsDailyScheduleAllowed(isDailyScheduleAllowed);
 505             rdef.setIsDailyMFScheduleAllowed(isDailyMFScheduleAllowed);
 506             rdef.setIsWeeklyScheduleAllowed(isWeeklyScheduleAllowed);
 507             rdef.setIsMonthlyScheduleAllowed(isMonthlyScheduleAllowed);
 508             rdef.setFrozenColumns(frozenColumns);
 509
 510                         } // if
 511
 512                 rdef.generateWizardSequence(request);
 513
 514                 reportUpdated = true;
 515
 516                 if ("-1".equals(rdef.getReportID()))
 517                         // Always need to persist new report - in case it is a copy
 518                         reportUpdated = true;
 519
 520                 return reportUpdated;
 521         } // processDefinition
 522
 523         private boolean processTableAdd(HttpServletRequest request) throws RaptorException {
 524                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 525                                 AppConstants.SI_REPORT_DEFINITION);
 526
 527                 String tableName = AppUtils.getRequestNvlValue(request, "tableName").toUpperCase();
 528                 String tableId = rdef.getUniqueTableId(tableName);
 529
 530                 String joinTableExpr = null;
 531                 String joinTableId = null;
 532
 533                 DataSourceType joinTable =
 534                         rdef.getTableById(AppUtils.getRequestValue(request, "joinTableName"));
 535                 if (joinTable != null) {
 536                         String joinTableName = joinTable.getTableName();
 537                         joinTableId = joinTable.getTableId();
 538
 539                         String joinExpr = AppUtils.getRequestNvlValue(request, "joinExpr").toUpperCase();
 540
 541                         joinTableExpr = joinExpr.replaceAll("\\["+tableName+"\\]", tableId);
 542                         joinTableExpr = joinTableExpr.replaceAll("\\["+joinTableName+"\\]", joinTableId);
 543 //                      debugLogger.debug("joinExpr : "+joinExpr+"\njoinTableExpr : "+ joinTableExpr);
 544                 }
 545
 546                 rdef.addDataSourceType(new ObjectFactory(), tableId, tableName, AppUtils
 547                                 .getRequestNvlValue(request, "tablePK"), AppUtils.getRequestNvlValue(request,
 548                                 "displayName"), joinTableId, joinTableExpr, null);
 549
 550                 rdef.setOuterJoin(rdef.getTableById(tableId), AppUtils.getRequestNvlValue(request,
 551                                 "outerJoin"));
 552                 rdef.resetCache(true);
 553
 554                 return true;
 555         } // processTableAdd
 556
 557         private boolean processTableEdit(HttpServletRequest request) throws Exception {
 558                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 559                                 AppConstants.SI_REPORT_DEFINITION);
 560
 561                 DataSourceType dst = rdef.getTableById(AppUtils.getRequestNvlValue(request,
 562                                 AppConstants.RI_DETAIL_ID));
 563
 564                 String displayName = XSSFilter.filterRequest(AppUtils.getRequestNvlValue(request, "displayName"));
 565                 String outerJoin = AppUtils.getRequestNvlValue(request, "outerJoin");
 566
 567                 String tableName = AppUtils.getRequestNvlValue(request, "tableName").toUpperCase();
 568                 String joinTableId = AppUtils.getRequestNvlValue(request, "joinTableName");
 569
 570                 String joinExpr = AppUtils.getRequestNvlValue(request, "joinExpr").toUpperCase();
 571
 572                 String joinTableExpr = null;
 573                 if(joinExpr.length()!=0){
 574                         joinTableExpr = joinExpr.replaceAll("\\["+tableName+"\\]", rdef.getTableByDBName(tableName).getTableId());
 575                         joinTableExpr = joinTableExpr.replaceAll("\\["+rdef.getTableById(joinTableId).getTableName().toUpperCase()+"\\]", joinTableId);
 576                         dst.setRefDefinition(joinTableExpr);
 577                 }
 578                 boolean reportUpdated = (!displayName.equals(nvl(dst.getDisplayName())) ||
 579                                                                  !outerJoin.equals(rdef.getOuterJoinType(dst))  ||
 580                                                                  !(joinExpr.length()==0));
 581
 582                 dst.setDisplayName(displayName);
 583                 rdef.setOuterJoin(dst, outerJoin);
 584                 if (reportUpdated)
 585                 rdef.resetCache(true);
 586
 587                 return true; // reportUpdated;
 588         } // processTableEdit
 589
 590
 591         private boolean processTableDelete(HttpServletRequest request) throws Exception {
 592                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 593                                 AppConstants.SI_REPORT_DEFINITION);
 594                 rdef.deleteDataSourceType(AppUtils.getRequestNvlValue(request,
 595                                 AppConstants.RI_DETAIL_ID));
 596                 return true;
 597         } // processTableDelete
 598
 599         private boolean processColumnAddEdit(HttpServletRequest request, boolean isEdit)
 600                         throws Exception {
 601                 if(!isEdit) {
 602                         return true;
 603                 }
 604                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 605                                 AppConstants.SI_REPORT_DEFINITION);
 606                 DataColumnType currColumn = null;
 607
 608                 String tableId = null;
 609                 String colName = null;
 610                 String dataType = null;
 611                 if (isEdit) {
 612                         currColumn = rdef.getColumnById(AppUtils.getRequestNvlValue(request,
 613                                         AppConstants.RI_DETAIL_ID));
 614
 615                         if(currColumn!=null) {
 616                                 tableId = currColumn.getTableId();
 617                                 colName = currColumn.getDbColName(); // currColumn.getColName();
 618                                 dataType = currColumn.getDbColType();
 619                         }
 620                 } else {
 621                         String colData = AppUtils.getRequestNvlValue(request, "columnDetails");
 622                         if(nvl(colData).length()>0) {
 623                                 tableId = colData.substring(0, colData.indexOf('|'));
 624                                 colName = colData.substring(tableId.length() + 1,
 625                                                 colData.indexOf('|', tableId.length() + 1)).toUpperCase();
 626                                 dataType = colData.substring(tableId.length() + colName.length() + 2);
 627                         }
 628                 } // else
 629
 630                 String exprFormula = AppUtils.getRequestNvlValue(request, "exprFormula");
 631
 632                 String colNameValue = null;
 633                 if (exprFormula.length() > 0)
 634                         if (exprFormula.equals("_exprText_"))
 635                                 colNameValue = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestValue(request, "exprText"));
 636                         else if (exprFormula.equals("COUNT(*)"))
 637                                 colNameValue = exprFormula;
 638                         else
 639                                 colNameValue = exprFormula + " " + colName + ")";
 640                 else
 641                         colNameValue = colName;
 642
 643                 int displayWidth = -1;
 644                 try {
 645                         displayWidth = Integer.parseInt(AppUtils.getRequestValue(request, "displayWidth"));
 646                 } catch (NumberFormatException e) {
 647                 }
 648
 649                 String sColId = isEdit ? currColumn.getColId() : (nvl(colName).length()>0?rdef.getUniqueColumnId(colName):null);
 650                 String drillDownParams = AppUtils.getRequestValue(request, "drillDownParams");
 651                 if (drillDownParams != null) {
 652                         // Replacing references to [this] with [col_id]
 653                         while (drillDownParams.indexOf("[this]") >= 0) {
 654                                 int startIdx = drillDownParams.indexOf("[this]");
 655                                 StringBuffer sb = new StringBuffer();
 656
 657                                 if (startIdx > 0)
 658                                         sb.append(drillDownParams.substring(0, startIdx));
 659                                 sb.append("[" + sColId + "]");
 660                                 if (startIdx + 6 < drillDownParams.length() - 1)
 661                                         sb.append(drillDownParams.substring(startIdx + 5));
 662                                 drillDownParams = sb.toString();
 663                         } // while
 664                 } // if
 665
 666                 String crossTabValue = null;
 667                 boolean isVisible = AppUtils.getRequestFlag(request, "visible");
 668                 boolean isSortable = AppUtils.getRequestFlag(request, "sortable");
 669                 String nowrap = AppUtils.getRequestNvlValue(request, "nowrap");
 670                 int indentation = 0;
 671                 try {
 672                         indentation = Integer.parseInt(AppUtils.getRequestNvlValue(request, "indentation"));
 673                 }catch (NumberFormatException e) {
 674                 }
 675                 String dependsOnFormField = AppUtils.getRequestNvlValue(request, "dependsOnFormField");
 676                 boolean isGroupBreak = AppUtils.getRequestFlag(request, "groupBreak");
 677                 String groupByPosStr = AppUtils.nvls(AppUtils.getRequestValue(request, "groupByPos"), "0");
 678                 int groupByPos = Integer.parseInt(groupByPosStr);
 679                 currColumn.setGroupByPos(groupByPos);
 680
 681                 if(groupByPos > 0) {
 682                         String subTotalCustomText = AppUtils.nvls(AppUtils.getRequestValue(request, "subTotalCustomText"), "Sub Total");
 683                         currColumn.setSubTotalCustomText(subTotalCustomText);
 684
 685                         boolean hideRepeatedKey = AppUtils.getRequestFlag(request, "hideRepeatedKeys");
 686                         currColumn.setHideRepeatedKey(hideRepeatedKey);
 687                 }
 688
 689                 String displayTotal = AppUtils.getRequestNvlValue(request, "displayTotal");
 690                 String widthInPxls = AppUtils.getRequestNvlValue(request, "widthInPxls");
 691
 692                 if (rdef.getReportType().equals(AppConstants.RT_CROSSTAB)) {
 693
 694
 695
 696                         crossTabValue = AppUtils.getRequestValue(request, "crossTabValue");
 697                         isVisible = nvl(crossTabValue).equals(AppConstants.CV_ROW)
 698                                         || nvl(crossTabValue).equals(AppConstants.CV_COLUMN)
 699                                         || nvl(crossTabValue).equals(AppConstants.CV_VALUE);
 700                         isGroupBreak = nvl(crossTabValue).equals(AppConstants.CV_ROW)
 701                                         || nvl(crossTabValue).equals(AppConstants.CV_COLUMN);
 702
 703                         if (nvl(crossTabValue).equals(AppConstants.CV_VALUE))
 704                                 displayTotal += "|"
 705                                                 + AppUtils.getRequestNvlValue(request, "displayTotalPerRow");
 706                         else
 707                                 displayTotal = "";
 708                 } // if
 709
 710                 String displayName = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "displayName"));
 711                 String colType = AppUtils.getRequestNvlValue(request, "colType");
 712                 String displayFormat = AppUtils.getRequestNvlValue(request, "displayFormat");
 713
 714                 //HYPERLINK
 715                 if(colType.equals(AppConstants.CT_HYPERLINK)) {
 716                         String hyperlinkURL = AppUtils.getRequestValue(request, "hyperlinkURL");
 717                         currColumn.setHyperlinkURL(hyperlinkURL);
 718                         String anchor  = AppUtils.getRequestValue(request, "anchor");
 719                         currColumn.setHyperlinkType(anchor);
 720                         if(anchor.equals("IMAGE")) {
 721                                 String actionImg = AppUtils.getRequestValue(request, "actionImg");
 722                                 currColumn.setActionImg(actionImg);
 723                         }
 724                 }
 725
 726
 727
 728                 String displayAlign = AppUtils.getRequestValue(request, "displayAlign");
 729                 String displayHeaderAlign = AppUtils.getRequestValue(request, "displayHeaderAlign");
 730                 String drillDownURL = AppUtils.getRequestValue(request, "drillDownURL");
 731                 String drillDownSuppress = AppUtils.getRequestValue(request, "drillDownSuppress");
 732                 boolean drillDownPopUp = AppUtils.getRequestFlag (request, "drillDownPopUp");
 733                 String semaphoreId = AppUtils.getRequestNvlValue(request, "semaphore");
 734                 String semaphoreType = AppUtils.getRequestNvlValue(request, "semaphoreTypeHidden");
 735
 736                 String levelStr = AppUtils.getRequestNvlValue(request, "multiGroupColLevel");
 737                 String startColGroup = AppUtils.getRequestNvlValue(request, "startMultiGroup");
 738                 String colGroupColSpan = AppUtils.getRequestNvlValue(request, "colspan");
 739                 int level = 0;
 740                 try {
 741                         level = Integer.parseInt(levelStr);
 742                 }catch (NumberFormatException ex) {
 743                         level = 0;
 744                 }
 745                 int startColGroupInt = 0;
 746                 int colGroupColSpanInt = 0;
 747         if(level > 0) {
 748                 try {
 749                         //startColGroupInt = Integer.parseInt(startColGroup);
 750                         colGroupColSpanInt = Integer.parseInt(colGroupColSpan);
 751                 } catch (NumberFormatException ex) {
 752
 753                 }
 754         }
 755         currColumn.setLevel(level);
 756         if(level > 0) {
 757                 currColumn.setStart(startColGroupInt);
 758                 currColumn.setColspan(colGroupColSpanInt);
 759         }
 760
 761                 String targetColumnId = (semaphoreType.indexOf("|")!= -1 ? semaphoreType.substring(semaphoreType.indexOf("|")+1):"");
 762                 DataColumnType targetColumn = rdef.getColumnById(targetColumnId);
 763
 764                 SemaphoreType semaphore = rdef.getSemaphoreById(semaphoreId);
 765                 rdef.deleteSemaphore(semaphore);
 766                 if(nvl(semaphoreType).length() > 0 && semaphoreType.indexOf("|")!=-1)
 767                         semaphore.setSemaphoreType(semaphoreType.substring(0,semaphoreType.indexOf("|")));
 768                 if(semaphore!=null) {
 769                         semaphore.setComment(currColumn.getColId());
 770                         if(nvl(semaphoreType).length() > 0)
 771                                 semaphore.setTarget(targetColumnId.length()>0? targetColumnId: "");
 772                         rdef.setSemaphore(semaphore);
 773                 }
 774
 775
 776                 if (isEdit) {
 777                         if(nvl(widthInPxls).length()>0) {
 778                                 if(nvl(widthInPxls).endsWith("px"))
 779                                         currColumn.setDisplayWidthInPxls(widthInPxls);
 780                                 else
 781                                         currColumn.setDisplayWidthInPxls(widthInPxls+"px");
 782                         } else {
 783                                 currColumn.setDisplayWidthInPxls("");
 784                         }
 785
 786                         currColumn.setCrossTabValue(crossTabValue);
 787                         currColumn.setDependsOnFormField(dependsOnFormField);
 788                         currColumn.setDisplayName(displayName);
 789                         //currColumn.setOriginalDisplayName(displayName);
 790
 791                         if (displayWidth > 0)
 792                                 currColumn.setDisplayWidth(displayWidth);
 793                         currColumn.setDisplayAlignment(displayAlign);
 794                         currColumn.setDisplayHeaderAlignment(displayHeaderAlign);
 795                         currColumn.setDrillDownURL(drillDownURL);
 796                         currColumn.setDrillDownParams(drillDownParams);
 797                         currColumn.setDrillDownType(drillDownSuppress);
 798                         currColumn.setDrillinPoPUp(drillDownPopUp);
 799                         //indentation
 800                         currColumn.setIndentation(indentation);
 801                         if(drillDownPopUp) {
 802                                 rdef.setDrillDownURLInPopupPresent(true);
 803                         }
 804                         /*if(targetColumn!=null) {
 805                                 currColumn.setSemaphoreId(null);
 806                                 targetColumn.setSemaphoreId(semaphoreId);
 807                         } else */
 808                         currColumn.setSemaphoreId(semaphoreId);
 809                         currColumn.setGroupBreak(isGroupBreak);
 810             logger.debug(EELFLoggerDelegate.debugLogger, (" ------------ Display Total ---------- "+ displayTotal));
 811                         currColumn.setDisplayTotal(displayTotal);
 812             //if (currColumn.getDrillDownURL() == null || currColumn.getDrillDownURL().length() == 0)
 813               currColumn.setVisible(isVisible);
 814               currColumn.setIsSortable(isSortable);
 815               currColumn.setNowrap(nowrap);
 816             //else
 817             //    currColumn.setVisible(true);
 818               if (rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
 819                 if(colType!=null)
 820                         currColumn.setColType(colType);
 821                                 displayFormat = AppUtils.getRequestValue(request, "colDataFormat");
 822                                 if (displayFormat != null){
 823                                         currColumn.setColFormat(displayFormat);
 824                                 }
 825                                 if(colType!=null && colType.equals(AppConstants.CT_DATE)) {
 826                                         boolean enhancedPagination = AppUtils.getRequestFlag(request, "enhancedPagination");
 827                                         currColumn.setEnhancedPagination(enhancedPagination);
 828                                 }
 829               }
 830                         if (!rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
 831                                 currColumn.setColName(colNameValue);
 832                                 if (displayFormat != null)
 833                                         currColumn.setColFormat(displayFormat);
 834                                 //currColumn.setVisible(isVisible);
 835                                 currColumn.setCalculated(exprFormula.length() > 0);
 836
 837                                 rdef.adjustColumnType(currColumn);
 838                         } // if
 839
 840                         rdef.resetCache(true);
 841                 } else
 842                         currColumn = rdef.addDataColumnType(new ObjectFactory(), sColId, tableId, colName,
 843                                         crossTabValue, colNameValue, displayName, displayWidth, displayAlign, rdef
 844                                                         .getAllColumns().size() + 1, isVisible,
 845                                         (exprFormula.length() > 0), adjustDataType(dataType), displayFormat,
 846                                         isGroupBreak, -1, null, displayTotal, null, -1, drillDownSuppress,
 847                                         drillDownURL, drillDownParams, semaphoreId, null);
 848
 849                 if (rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED))
 850                         rdef.setColumnNoParseDateFlag(currColumn, AppUtils.getRequestFlag(request,
 851                                         "no_parse_date"));
 852         if(nvl(displayName).length()>0)
 853                         return true;
 854         else
 855                 return false;
 856         } // processColumnAddEdit
 857
 858         private boolean processColumnAddMulti(HttpServletRequest request) throws Exception {
 859                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 860                                 AppConstants.SI_REPORT_DEFINITION);
 861
 862                 List reportCols = rdef.getAllColumns();
 863                 int nCol = reportCols.size() + 1;
 864
 865                 String[] addColumn = request.getParameterValues("addColumn");
 866                 String[] tableId = request.getParameterValues("tableId");
 867                 String[] columnName = request.getParameterValues("columnName");
 868                 String[] columnType = request.getParameterValues("columnType");
 869                 String[] displayName = request.getParameterValues("displayName");
 870
 871                 for (int i = 0; i < addColumn.length; i++)
 872                         if (addColumn[i].equals("Y")) {
 873                                 int j = 2;
 874                                 String uniqueDisplayName = displayName[i];
 875                                 boolean isUnique = true;
 876                                 do {
 877                                         isUnique = true;
 878                                         for (Iterator iter = reportCols.iterator(); iter.hasNext();)
 879                                                 if (uniqueDisplayName.equals(((DataColumnType) iter.next())
 880                                                                 .getDisplayName())) {
 881                                                         isUnique = false;
 882                                                         uniqueDisplayName = displayName[i] + (j++);
 883                                                         break;
 884                                                 } // if
 885                                 } while (!isUnique);
 886
 887                                 rdef
 888                                                 .addDataColumnType(
 889                                                                 new ObjectFactory(),
 890                                                                 rdef.getUniqueColumnId(columnName[i]),
 891                                                                 tableId[i],
 892                                                                 columnName[i],
 893                                                                 null,
 894                                                                 columnName[i],
 895                                                                 uniqueDisplayName,
 896                                                                 10,
 897                                                                 "Left",
 898                                                                 nCol++,
 899                                                                 true,
 900                                                                 false,
 901                                                                 adjustDataType(columnType[i]),
 902                                                                 (columnType[i].equals(AppConstants.CT_DATE) ? AppConstants.DEFAULT_DATE_FORMAT
 903                                                                                 : null), false, -1, null, null, null, -1, null, null,
 904                                                                 null, null, null);
 905                         } // if
 906
 907                 return true;
 908         } // processColumnAddMulti
 909
 910         private boolean processColumnOrderAll(HttpServletRequest request) throws Exception {
 911                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 912                                 AppConstants.SI_REPORT_DEFINITION);
 913
 914                 String[] colId = request.getParameterValues("colId");
 915                 String[] colOrder = request.getParameterValues("colOrder");
 916
 917                 boolean reportUpdated = false;
 918                 for (int i = 0; i < colId.length; i++) {
 919                         DataColumnType dct = rdef.getColumnById(nvl(colId[i]));
 920                         if (dct == null)
 921                                 continue;
 922
 923                         int iColOrder = 0;
 924                         try {
 925                                 iColOrder = Integer.parseInt(colOrder[i]);
 926                         } catch (NumberFormatException e) {
 927                         }
 928
 929                         if (iColOrder > 0) {
 930                                 dct.setOrderSeq(iColOrder);
 931                                 reportUpdated = true;
 932                         } // if
 933                 } // for
 934
 935                 if (reportUpdated) {
 936                         List reportCols = rdef.getAllColumns();
 937                         Collections.sort(reportCols, new OrderSeqComparator());
 938
 939                         int iOrder = 1;
 940                         for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
 941                                 DataColumnType dct = (DataColumnType) iter.next();
 942                                 dct.setOrderSeq(iOrder++);
 943                         } // for
 944
 945                         rdef.resetCache(false);
 946                 } // if
 947
 948                 return reportUpdated;
 949         } // processColumnOrderAll
 950
 951         private boolean processColumnDelete(HttpServletRequest request) throws Exception {
 952                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 953                                 AppConstants.SI_REPORT_DEFINITION);
 954                 rdef.deleteDataColumnType(AppUtils.getRequestNvlValue(request,
 955                                 AppConstants.RI_DETAIL_ID));
 956                 return true;
 957         } // processColumnDelete
 958
 959         private boolean processColumnMoveUp(HttpServletRequest request) throws Exception {
 960                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 961                                 AppConstants.SI_REPORT_DEFINITION);
 962                 rdef.shiftColumnOrderUp(AppUtils
 963                                 .getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
 964                 return true;
 965         } // processColumnMoveUp
 966
 967         private boolean processColumnMoveDown(HttpServletRequest request) throws Exception {
 968                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 969                                 AppConstants.SI_REPORT_DEFINITION);
 970                 rdef.shiftColumnOrderDown(AppUtils.getRequestNvlValue(request,
 971                                 AppConstants.RI_DETAIL_ID));
 972                 return true;
 973         } // processColumnMoveDown
 974
 975         private boolean processFormFieldAddEdit(HttpServletRequest request, boolean isEdit,
 976                         String action) throws Exception {
 977                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
 978                                 AppConstants.SI_REPORT_DEFINITION);
 979
 980                 String fieldName = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "fieldName"));
 981                 String multiSelectSize  =  "0";
 982                 String colId = AppUtils.getRequestNvlValue(request, "fieldColId");
 983                 if (rdef.getReportDefType().equals(AppConstants.RD_SQL_BASED)) {
 984                         String displayFormat = AppUtils.getRequestNvlValue(request, "displayFormat");
 985                         if (displayFormat.length() > 0)
 986                                 colId += "|" + displayFormat;
 987                 } // if
 988                 String fieldType = AppUtils.getRequestNvlValue(request, "fieldType");
 989                 String validation = AppUtils.getRequestNvlValue(request, "validation");
 990                 String mandatory = nvl(AppUtils.getRequestValue(request, "mandatory"), "N");
 991                 String defaultValue = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "defaultValue"));
 992                 String fieldHelp = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "fieldHelp"));
 993                 String fieldSQL = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "fieldSQL"));
 994                 String fieldDefaultSQL = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "fieldDefaultSQL"));
 995         String visible = nvl(AppUtils.getRequestValue(request, "visible"),"Y");
 996         String dependsOn = nvl(AppUtils.getRequestValue(request, "dependsOn"),"");
 997         String rangeStartDate = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "rangeStartDate"));
 998         String rangeEndDate = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "rangeEndDate"));
 999         String rangeStartDateSQL = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "rangeStartDateSQL"));
1000         String rangeEndDateSQL = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "rangeEndDateSQL"));
1001         boolean isGroupFormField = AppUtils.getRequestFlag(request,"isGroupFormField");
1002
1003         Calendar start = null;
1004         Calendar end = null;
1005         if (AppUtils.nvl(rangeStartDate).length()>0){
1006                 SimpleDateFormat dtf = new SimpleDateFormat("MM/dd/yyyy");
1007             start = Calendar.getInstance();
1008             start.setTime(dtf.parse(rangeStartDate));
1009         }
1010         if (AppUtils.nvl(rangeEndDate).length()>0){
1011                 SimpleDateFormat dtf = new SimpleDateFormat("MM/dd/yyyy");
1012             end = Calendar.getInstance();
1013             end.setTime(dtf.parse(rangeEndDate));
1014         }/*
1015                  * if(fieldHelp.length()>255) fieldHelp = fieldHelp.substring(0, 255);
1016                  */
1017
1018                 boolean reportUpdated = false;
1019
1020                 FormFieldType currField = null;
1021                 if (isEdit) {
1022                         String fieldId = AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID);
1023
1024                         currField = rdef.getFormFieldById(fieldId);
1025                         if (currField != null && nvl(fieldName).length()>0) {
1026                                 reportUpdated = (!(fieldName.equals(nvl(currField.getFieldName()))
1027                                                 && colId.equals(nvl(currField.getColId()))
1028                                                 && fieldType.equals(nvl(currField.getFieldType()))
1029                                                 && validation.equals(nvl(currField.getValidationType()))
1030                                                 && mandatory.equals(nvl(currField.getMandatory(), "N"))
1031                                                 && defaultValue.equals(nvl(currField.getDefaultValue()))
1032                                                 && fieldSQL.equals(nvl(currField.getFieldSQL()))
1033                         && fieldDefaultSQL.equals(nvl(currField.getFieldDefaultSQL()))
1034                         && dependsOn.equals(nvl(currField.getDependsOn(), "N"))
1035                         && (start == null || (start != null && currField.getRangeStartDate() == null) || (start.compareTo(getCalendar(currField.getRangeStartDate())) )==0)
1036                         && (end == null || (end != null && currField.getRangeEndDate() == null) || (end.equals(currField.getRangeEndDate())))
1037                         && rangeStartDateSQL.equals(nvl(currField.getRangeStartDateSQL()))
1038                         && rangeEndDateSQL.equals(nvl(currField.getRangeEndDateSQL()))
1039                         && visible.equals(nvl(currField.getVisible(), "Y"))
1040                         && isGroupFormField == currField.isGroupFormField()
1041                         && fieldHelp.equals(nvl(currField.getComment()))));
1042
1043                                 rdef.replaceFormFieldReferences("[" + currField.getFieldName() + "]", "["
1044                                                 + fieldName + "]");
1045
1046                                 currField.setFieldName(fieldName);
1047                                 currField.setColId(colId);
1048                                 currField.setFieldType(fieldType);
1049                                 currField.setValidationType(validation);
1050                                 currField.setMandatory(mandatory);
1051                                 currField.setDefaultValue(defaultValue);
1052                                 currField.setFieldSQL(fieldSQL);
1053                                 currField.setFieldDefaultSQL(fieldDefaultSQL);
1054                                 currField.setComment(fieldHelp);
1055                 currField.setVisible(visible);
1056                 currField.setDependsOn(dependsOn);
1057                 try {
1058                         if(start!=null) {
1059                                 currField.setRangeStartDate(DatatypeFactory.newInstance()
1060                                 .newXMLGregorianCalendar(start.YEAR, start.MONTH, start.DAY_OF_WEEK, start.HOUR, start.MINUTE, start.SECOND, start.MILLISECOND, start.ZONE_OFFSET));
1061                         } else {
1062                                 currField.setRangeStartDate(null);
1063                         }
1064                         if(end!=null) {
1065                                 currField.setRangeEndDate(DatatypeFactory.newInstance()
1066                                 .newXMLGregorianCalendar(end.YEAR, end.MONTH, end.DAY_OF_WEEK, end.HOUR, end.MINUTE, end.SECOND, end.MILLISECOND, end.ZONE_OFFSET));
1067                         } else {
1068                                 currField.setRangeEndDate(null);
1069                         }
1070                         /*currField.setRangeEndDate(DatatypeFactory.newInstance()
1071                                 .newXMLGregorianCalendar(end));*/
1072                 } catch (DatatypeConfigurationException ex) {
1073
1074                 }
1075
1076                 currField.setRangeStartDateSQL(rangeStartDateSQL);
1077                 currField.setRangeEndDateSQL(rangeEndDateSQL);
1078                 currField.setGroupFormField(isGroupFormField);
1079                         if(fieldType.equals(FormField.FFT_LIST_MULTI)) {
1080                                 multiSelectSize  = AppUtils.getRequestNvlValue(request, "multiSelectListSize");
1081                                 currField.setMultiSelectListSize(multiSelectSize);
1082                         }
1083
1084
1085                         } // if
1086                 } else {
1087                         reportUpdated = true;
1088
1089                         currField = rdef.addFormFieldType(new ObjectFactory(), fieldName, colId,
1090                                         fieldType, validation, mandatory, defaultValue, fieldSQL, fieldHelp, start, end, rangeStartDateSQL, rangeEndDateSQL);
1091
1092                         request.setAttribute(AppConstants.RI_DETAIL_ID, currField.getFieldId());
1093                 } // else
1094
1095                 if (action.equals(AppConstants.WA_ADD_USER)) {
1096                         reportUpdated = true;
1097                         rdef.addFormFieldPredefinedValue(new ObjectFactory(), currField, XSSFilter.filterRequestOnlyScript(AppUtils
1098                                         .getRequestNvlValue(request, "newPredefinedValue")));
1099                 } else if (action.equals(AppConstants.WA_DELETE_USER)) {
1100                         reportUpdated = true;
1101                         rdef.deleteFormFieldPredefinedValue(currField, AppUtils.getRequestNvlValue(
1102                                         request, "delPredefinedValue"));
1103                 }
1104
1105                 return reportUpdated;
1106         } // processFormFieldAddEdit
1107
1108         private boolean processFormFieldDelete(HttpServletRequest request) throws Exception {
1109                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1110                                 AppConstants.SI_REPORT_DEFINITION);
1111
1112                 String fieldId = AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID);
1113                 rdef.deleteFormField(fieldId);
1114
1115                 return true;
1116         } // processFormFieldDelete
1117
1118         private boolean processFormFieldMoveUp(HttpServletRequest request) throws Exception {
1119                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1120                                 AppConstants.SI_REPORT_DEFINITION);
1121                 rdef.shiftFormFieldUp(AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
1122                 return true;
1123         } // processFormFieldMoveUp
1124
1125         private boolean processFormFieldMoveDown(HttpServletRequest request) throws Exception {
1126                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1127                                 AppConstants.SI_REPORT_DEFINITION);
1128                 rdef.shiftFormFieldDown(AppUtils
1129                                 .getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
1130                 return true;
1131         } // processFormFieldMoveDown
1132
1133         private boolean processFormFieldBlank(HttpServletRequest request) throws Exception {
1134                 boolean reportUpdated = false;
1135                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1136                                 AppConstants.SI_REPORT_DEFINITION);
1137                 reportUpdated = true;
1138                 rdef.addFormFieldBlank(new ObjectFactory());
1139                 return true;
1140         } // processFormFieldMoveDown
1141
1142         //processFormFieldInfoBar
1143         private boolean processFormFieldInfoBar(HttpServletRequest request) throws Exception {
1144                 boolean reportUpdated = false;
1145                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1146                                 AppConstants.SI_REPORT_DEFINITION);
1147                 reportUpdated = true;
1148                 rdef.addCustomizedTextForParameters(XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "blueBarField")));
1149                 return true;
1150         } // processFormFieldMoveDown
1151
1152
1153         private boolean processForecasting(HttpServletRequest request,  String action) throws Exception {
1154                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1155                                 AppConstants.SI_REPORT_DEFINITION);
1156
1157                 if(rdef.getDataminingOptions()==null)
1158             rdef.addDataminingOptions(new ObjectFactory());
1159
1160                 String classifiers = AppUtils.getRequestNvlValue(request, "classifiers");
1161                 rdef.setClassifier(classifiers);
1162                 String dateAttrColId = AppUtils.getRequestNvlValue(request, "timeAttribute");
1163                 String timeFormat = AppUtils.getRequestNvlValue(request, "timeFormat");
1164                 if(timeFormat.equals("Default"))
1165                         timeFormat = "yyyy-MM-dd HH:mm:ss";
1166                 String forecastingPeriod = AppUtils.getRequestNvlValue(request, "forecastingPeriod");
1167
1168                 String[] forecastCols = request.getParameterValues("forecastCol");
1169                 List reportCols     = rdef.getAllColumns();
1170                 DataColumnType dct = null;
1171                 Iterator iter = null;
1172
1173
1174
1175                 if(dateAttrColId != null) {
1176                         for(iter=reportCols.iterator(); iter.hasNext(); ) {
1177                                 dct = (DataColumnType) iter.next();
1178                                 if(dct.getColId().equals(dateAttrColId)) {
1179                                         dct.setDataMiningCol(AppConstants.DM_DATE_ATTR);
1180                                         if(timeFormat!=null)
1181                                                 rdef.setForecastingTimeFormat(timeFormat);
1182                                         break;
1183                                 }
1184                         }
1185                 }
1186
1187                 if(forecastCols != null) {
1188                         for (int i = 0; i < forecastCols.length; i++) {
1189                                 for(iter=reportCols.iterator(); iter.hasNext(); ) {
1190                                         dct = (DataColumnType) iter.next();
1191                                         if(dct.getColId().equals(forecastCols[i])) {
1192                                                 dct.setDataMiningCol(AppConstants.DM_FORECASTING_ATTR);
1193                                         }
1194                                 }
1195                         }
1196                         rdef.setForecastingPeriod(forecastingPeriod);
1197                 }
1198                 boolean reportUpdated = true;
1199
1200                 return reportUpdated;
1201         } // processForecasting
1202
1203
1204         private boolean processFilterAddEdit(HttpServletRequest request, boolean isEdit)
1205                         throws Exception {
1206                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1207                                 AppConstants.SI_REPORT_DEFINITION);
1208
1209                 String colId = AppUtils.getRequestNvlValue(request, "filterColId");
1210                 String filterExpr = AppUtils.getRequestNvlValue(request, "filterExpr");
1211                 String argType = (filterExpr.equals("IS NULL") || filterExpr.equals("IS NOT NULL")) ? null
1212                                 : AppUtils.getRequestNvlValue(request, "argType");
1213                 String argValue = (filterExpr.equals("IS NULL") || filterExpr.equals("IS NOT NULL")) ? null
1214                                 : AppUtils.getRequestNvlValue(request, "argValue");
1215
1216                 if (nvl(argType).equals(AppConstants.AT_COLUMN)) {
1217                         List reportCols = rdef.getAllColumns();
1218                         for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
1219                                 DataColumnType dct = (DataColumnType) iter.next();
1220                                 if (argValue != null && argValue.equals("[" + dct.getDisplayName() + "]")) {
1221                                         argValue = dct.getColId();
1222                                         break;
1223                                 }
1224                         } // for
1225                 } // if
1226
1227                 if (nvl(argType).equals(AppConstants.AT_VALUE)
1228                                 && (!nvl(argValue).equals(AppConstants.FILTER_MAX_VALUE))
1229                                 && (!nvl(argValue).equals(AppConstants.FILTER_MIN_VALUE))) {
1230                         // Validating the value by type
1231                         DataColumnType currColumn = rdef.getColumnById(colId);
1232                         String currColType = currColumn.getColType();
1233
1234                         try {
1235                                 String s_sql = Globals.getProcessFilterAddEdit();
1236                                 s_sql = s_sql.replace("[argValue]", argValue);
1237                                 /*DataSet ds = DbUtils.executeQuery("SELECT "
1238                                                 + (currColType.equals(AppConstants.CT_NUMBER) ? ("TO_NUMBER('"
1239                                                                 + argValue + "')")
1240                                                                 : (currColType.equals(AppConstants.CT_DATE) ? ("TO_DATE('"
1241                                                                                 + argValue
1242                                                                                 + "', '"
1243                                                                                 + nvl(currColumn.getColFormat(),
1244                                                                                                 AppConstants.DEFAULT_DATE_FORMAT) + "')")
1245                                                                                 : ("'" + argValue + "'"))) + " FROM dual");*/
1246
1247                                 DataSet ds = DbUtils.executeQuery("SELECT "
1248                                                 + (currColType.equals(AppConstants.CT_NUMBER) ? ("TO_NUMBER('"
1249                                                                 + argValue + "')")
1250                                                                 : (currColType.equals(AppConstants.CT_DATE) ? ("TO_DATE('"
1251                                                                                 + argValue
1252                                                                                 + "', '"
1253                                                                                 + nvl(currColumn.getColFormat(),
1254                                                                                                 AppConstants.DEFAULT_DATE_FORMAT) + "')")
1255                                                                                 : s_sql)));
1256                         } catch (Exception e) {
1257                                 throw new ValidationException(
1258                                                 ""
1259                                                                 + (currColType.equals(AppConstants.CT_NUMBER) ? "Invalid number"
1260                                                                                 : (currColType.equals(AppConstants.CT_DATE) ? ("Invalid date<br>Expected date format " + nvl(
1261                                                                                                 currColumn.getColFormat(),
1262                                                                                                 AppConstants.DEFAULT_DATE_FORMAT))
1263                                                                                                 : "Invalid value<br>Possible reason: use of single quotes"))
1264                                                                 + "<!--" + e.getMessage() + "--><br>Value: " + argValue);
1265                         }
1266                 } // if
1267
1268                 if (isEdit) {
1269                         int filterPos = -1;
1270                         try {
1271                                 filterPos = Integer.parseInt(AppUtils.getRequestValue(request, "filterPos"));
1272                         } catch (NumberFormatException e) {
1273                         }
1274
1275                         ColFilterType currFilter = rdef.getFilterById(colId, filterPos);
1276                         if (currFilter != null) {
1277                                 currFilter.setJoinCondition(AppUtils.getRequestValue(request, "filterJoin"));
1278                                 currFilter.setOpenBrackets(AppUtils.getRequestValue(request, "openBrackets"));
1279                                 currFilter.setExpression(filterExpr);
1280                                 // if(argType!=null)
1281                                 currFilter.setArgType(argType);
1282                                 // if(argValue!=null)
1283                                 currFilter.setArgValue(argValue);
1284                                 currFilter
1285                                                 .setCloseBrackets(AppUtils.getRequestValue(request, "closeBrackets"));
1286                         } // if
1287
1288                         rdef.resetCache(true);
1289                 } else {
1290                         rdef.addColFilterType(new ObjectFactory(), colId, AppUtils.getRequestValue(
1291                                         request, "filterJoin"), AppUtils.getRequestValue(request, "openBrackets"),
1292                                         filterExpr, argType, argValue, AppUtils.getRequestValue(request,
1293                                                         "closeBrackets"), null);
1294                 } // else
1295
1296                 return true;
1297         } // processFilterAddEdit
1298
1299         private boolean processFilterDelete(HttpServletRequest request) throws Exception {
1300                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1301                                 AppConstants.SI_REPORT_DEFINITION);
1302
1303                 String filterId = AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID);
1304                 String colId = filterId.substring(0, filterId.indexOf('|'));
1305                 int filterPos = -1;
1306                 try {
1307                         filterPos = Integer.parseInt(filterId.substring(colId.length() + 1));
1308                 } catch (NumberFormatException e) {
1309                 }
1310
1311                 rdef.removeColumnFilter(colId, filterPos);
1312
1313                 return true;
1314         } // processFilterDelete
1315
1316         private boolean processSortAddEdit(HttpServletRequest request, boolean isEdit)
1317                         throws Exception {
1318                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1319                                 AppConstants.SI_REPORT_DEFINITION);
1320
1321                 String sortAscDesc = AppUtils.getRequestNvlValue(request, "sortAscDesc");
1322                 if (isEdit) {
1323                         DataColumnType currColumn = rdef.getColumnById(AppUtils.getRequestNvlValue(
1324                                         request, AppConstants.RI_DETAIL_ID));
1325                         if (currColumn != null)
1326                                 currColumn.setOrderByAscDesc(sortAscDesc);
1327                         rdef.resetCache(true);
1328                 } else
1329                         rdef.addColumnSort(AppUtils.getRequestNvlValue(request, "sortColId"), sortAscDesc,
1330                                         rdef.getNumSortColumns() + 1);
1331
1332                 return true;
1333         } // processSortAddEdit
1334
1335         private boolean processSortOrderAll(HttpServletRequest request) throws Exception {
1336                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1337                                 AppConstants.SI_REPORT_DEFINITION);
1338
1339                 String[] colId = request.getParameterValues("colId");
1340                 String[] sortOrder = request.getParameterValues("sortOrder");
1341                 String[] sortAscDesc = request.getParameterValues("sortAscDesc");
1342
1343                 boolean reportUpdated = false;
1344                 for (int i = 0; i < colId.length; i++) {
1345                         DataColumnType dct = rdef.getColumnById(nvl(colId[i]));
1346                         if (dct == null)
1347                                 continue;
1348
1349                         int iSortOrder = 0;
1350                         try {
1351                                 iSortOrder = Integer.parseInt(sortOrder[i]);
1352                         } catch (NumberFormatException e) {
1353                         }
1354
1355                         if (iSortOrder > 0) {
1356                                 if (dct.getOrderBySeq() > 0) {
1357                                         // Update sort
1358                                         if (dct.getOrderBySeq() != iSortOrder) {
1359                                                 dct.setOrderBySeq(iSortOrder);
1360                                                 reportUpdated = true;
1361                                         } // if
1362                                         if (!nvl(dct.getOrderByAscDesc()).equals(nvl(sortAscDesc[i]))) {
1363                                                 dct.setOrderByAscDesc(sortAscDesc[i]);
1364                                                 reportUpdated = true;
1365                                         } // if
1366                                 } else {
1367                                         // Add sort
1368                                         dct.setOrderBySeq(iSortOrder);
1369                                         dct.setOrderByAscDesc(sortAscDesc[i]);
1370                                         reportUpdated = true;
1371                                 } // else
1372                         } else {
1373                                 if (dct.getOrderBySeq() > 0) {
1374                                         // Remove sort
1375                                         dct.setOrderBySeq(0);
1376                                         dct.setOrderByAscDesc(null);
1377                                         reportUpdated = true;
1378                                 } // if
1379                         } // else
1380                 } // for
1381
1382                 if (reportUpdated) {
1383                         List reportCols = rdef.getAllColumns();
1384                         Collections.sort(reportCols, new OrderBySeqComparator());
1385                         int iOrder = 1;
1386                         for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
1387                                 DataColumnType dct = (DataColumnType) iter.next();
1388                                 if (dct.getOrderBySeq() > 0)
1389                                         dct.setOrderBySeq(iOrder++);
1390                         } // for
1391                         Collections.sort(reportCols, new OrderSeqComparator());
1392
1393                         rdef.resetCache(true);
1394                 } // if
1395
1396                 return reportUpdated;
1397         } // processSortOrderAll
1398
1399         private boolean processSortDelete(HttpServletRequest request) throws Exception {
1400                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1401                                 AppConstants.SI_REPORT_DEFINITION);
1402                 rdef.removeColumnSort(AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
1403                 return true;
1404         } // processSortDelete
1405
1406         private boolean processSortMoveUp(HttpServletRequest request) throws Exception {
1407                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1408                                 AppConstants.SI_REPORT_DEFINITION);
1409                 rdef
1410                                 .shiftColumnSortUp(AppUtils.getRequestNvlValue(request,
1411                                                 AppConstants.RI_DETAIL_ID));
1412                 return true;
1413         } // processSortMoveUp
1414
1415         private boolean processSortMoveDown(HttpServletRequest request) throws Exception {
1416                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1417                                 AppConstants.SI_REPORT_DEFINITION);
1418                 rdef.shiftColumnSortDown(AppUtils.getRequestNvlValue(request,
1419                                 AppConstants.RI_DETAIL_ID));
1420                 return true;
1421         } // processSortMoveDown
1422
1423         private boolean processJavascript (HttpServletRequest request) throws Exception {
1424         processSaveJavascriptElement(request);
1425                 return true;
1426         }
1427
1428         private boolean processSaveJavascriptElement (HttpServletRequest request) throws Exception {
1429                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1430                                 AppConstants.SI_REPORT_DEFINITION);
1431                 rdef.setJavascriptElement(AppUtils.getRequestNvlValue(request, AppConstants.RI_JAVASCRIPT));
1432                 String id = AppUtils.getRequestNvlValue(request, AppConstants.RI_JAVASCRIPT_ITEM_ID);
1433                 String fieldId = AppUtils.getRequestNvlValue(request, "javascriptFormField-"+id);
1434                 if( nvl(fieldId).length()>0 && !(fieldId.startsWith("-1"))) {
1435
1436                         String callableJavascriptText = AppUtils.getRequestNvlValue(request, "callText-"+id);
1437
1438                         logger.debug(EELFLoggerDelegate.debugLogger, ("FieldId " + fieldId + " Call Text " + callableJavascriptText+ " id  " + id));
1439                         JavascriptItemType javaScriptType = null;
1440                         if(id.length()>0 && id.startsWith("-1")) {
1441                                 javaScriptType = rdef.addJavascriptType(new ObjectFactory(), id);
1442                                 javaScriptType.setFieldId(fieldId);
1443                                 if(!fieldId.equals("os1") || !fieldId.equals("ol1"))
1444                                         javaScriptType.setId(rdef.getNextIdForJavaScriptElement(new ObjectFactory(), fieldId));
1445                                 else {
1446                                         if(fieldId.equals("os1"))
1447                                                 javaScriptType.setId("os1|1");
1448                                         else
1449                                                 javaScriptType.setId("ol1|1");
1450                                 }
1451                                 javaScriptType.setCallText(callableJavascriptText);
1452                         } else {
1453                                 javaScriptType = rdef.addJavascriptType(new ObjectFactory(), id);
1454                                 javaScriptType.setCallText(callableJavascriptText);
1455                         }
1456                 }
1457                 return true;
1458         }
1459         private boolean processAddJavascriptElement (HttpServletRequest request) throws Exception {
1460                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1461                                 AppConstants.SI_REPORT_DEFINITION);
1462
1463                 JavascriptItemType javaScriptType = rdef.addJavascriptType(new ObjectFactory(), "");
1464                 javaScriptType.setId("");
1465                 javaScriptType.setFieldId("");
1466                 javaScriptType.setCallText("");
1467
1468                 return true;
1469         }
1470
1471         private boolean processDeleteJavascriptElement (HttpServletRequest request) throws Exception {
1472                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1473                                 AppConstants.SI_REPORT_DEFINITION);
1474                 String id = AppUtils.getRequestNvlValue(request, AppConstants.RI_JAVASCRIPT_ITEM_ID);
1475                 if(rdef.deleteJavascriptType(id))
1476                         return true;
1477                 else
1478                         return false;
1479         }
1480
1481         private boolean processChart(HttpServletRequest request, String action) throws Exception {
1482                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
1483                                 AppConstants.SI_REPORT_DEFINITION);
1484
1485                 int valueColsCount = rdef.getChartValueColumnsList(AppConstants.CHART_ALL_COLUMNS, null).size();
1486
1487                 String chartType = AppUtils.getRequestNvlValue(request, "chartType");
1488                 String chartTypeFixed = AppUtils.getRequestValue(request, "chartTypeFixed");
1489                 String legendColId = AppUtils.getRequestNvlValue(request, "legendCol");
1490                 // String valueColId = AppUtils.getRequestNvlValue(request, "valueCol");
1491                 String leftAxisLabel = AppUtils.getRequestValue(request, "leftAxisLabel");
1492                 String rightAxisLabel = AppUtils.getRequestValue(request, "rightAxisLabel");
1493                 String chartWidth = XSSFilter.filterRequest(AppUtils.getRequestNvlValue(request, "chartWidth"));
1494                 String chartHeight = XSSFilter.filterRequest(AppUtils.getRequestNvlValue(request, "chartHeight"));
1495                 String chartMultiseries = AppUtils.getRequestNvlValue(request, "multiSeries");
1496                 String lastSeriesALineChart = AppUtils.getRequestNvlValue(request, "lastSeriesALineChart");
1497                 String lastSeriesABarChart = AppUtils.getRequestNvlValue(request, "lastSeriesABarChart");
1498                 String overLayItemLabel = "N";
1499                 String chartDisplay = null;
1500
1501                 String multiplePieOrder = null;
1502                 String multiplePieLabelDisplay = null;
1503
1504                 String chartOrientation = null;
1505                 String secondaryChartRenderer = null;
1506
1507                 String linearRegression = null;
1508
1509                 boolean multiplePieOrderInRunPage = false;
1510                 boolean multiplePieLabelDisplayInRunPage = false;
1511
1512                 boolean chartOrientationInRunPage = false;
1513                 boolean secondaryChartRendererInRunPage = false;
1514
1515                 boolean chartDisplayInRunPage = false;
1516
1517                 String intervalFromdate = null;
1518                 String intervalTodate = null;
1519                 String intervalLabel = null;
1520         boolean displayIntervalInputInRunPage = false;
1521                 boolean animate = false;
1522
1523                 animate = AppUtils.getRequestNvlValue(request, "animatedOption").equals("animate");
1524                 if(Globals.showAnimatedChartOption())
1525                         rdef.setChartAnimate(animate);
1526
1527
1528                 String removeColId = "";
1529                 if (action.equals(AppConstants.WA_DELETE_USER)) {
1530                         removeColId = AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID);
1531                         if(valueColsCount == 2 && !rdef.hasSeriesColumn()) {
1532                                 rdef.setChartLeftAxisLabel(null);
1533                                 rdef.setChartRightAxisLabel(null);
1534
1535                         if(chartType.equals(AppConstants.GT_TIME_SERIES) || chartType.equals(AppConstants.GT_PIE_MULTIPLE)) {
1536                                 chartMultiseries = "N";
1537                         }
1538                 }
1539                 }
1540
1541                 if(rdef.getChartAdditionalOptions()==null)
1542             rdef.addChartAdditionalOptions(new ObjectFactory());
1543
1544                 if(rdef.getChartDrillOptions()==null)
1545             rdef.addChartDrillOptions(new ObjectFactory());
1546
1547                 //clearing already added
1548                 if(rdef.getChartDrillOptions().getTargetFormfield()!=null)
1549                         rdef.getChartDrillOptions().getTargetFormfield().removeAll(rdef.getChartDrillOptions().getTargetFormfield());
1550
1551
1552                 if(chartType.equals(AppConstants.GT_PIE_MULTIPLE)) {
1553                         multiplePieOrder = AppUtils.getRequestNvlValue(request, "multiplePieOrder");
1554                         multiplePieLabelDisplay = AppUtils.getRequestNvlValue(request, "multiplePieLabelDisplay");
1555                         chartDisplay = AppUtils.getRequestNvlValue(request, "chartDisplay");
1556                         //if(AppUtils.getRequestNvlValue(request, "multiplePieOrderInRunPage").length()>0)
1557                                 multiplePieOrderInRunPage = AppUtils.getRequestNvlValue(request,"multiplePieOrderInRunPage").equals("Y");
1558                         //if(AppUtils.getRequestNvlValue(request, "multiplePieLabelDisplayInRunPage").length()>0)
1559                                 multiplePieLabelDisplayInRunPage = AppUtils.getRequestNvlValue(request,"multiplePieLabelDisplayInRunPage").equals("Y");
1560                         //if(AppUtils.getRequestNvlValue(request, "chartDisplayInRunPage").length()>0)
1561                                 chartDisplayInRunPage = AppUtils.getRequestNvlValue(request,"chartDisplayInRunPage").equals("Y");
1562                         if(rdef.getChartAdditionalOptions()!=null) {
1563                                 rdef.setChartMultiplePieOrder(multiplePieOrder+(multiplePieOrderInRunPage?"|Y":""));
1564                                 rdef.setChartMultiplePieLabelDisplay(multiplePieLabelDisplay+(multiplePieLabelDisplayInRunPage?"|Y":""));
1565                                 rdef.setChartDisplay(chartDisplay+(chartDisplayInRunPage?"|Y":""));
1566                         }
1567
1568                 }
1569
1570                 if(chartType.equals(AppConstants.GT_REGRESSION)) {
1571                         linearRegression = AppUtils.getRequestNvlValue(request, "regressionType");
1572                         rdef.setLinearRegressionColor(AppUtils.getRequestNvlValue(request, "valueLinearRegressionColor"));
1573                         rdef.setExponentialRegressionColor(AppUtils.getRequestNvlValue(request, "valueExponentialRegressionColor"));
1574                         rdef.setCustomizedRegressionPoint(AppUtils.getRequestNvlValue(request, "regressionPointCustomization"));
1575
1576                         if(nvl(linearRegression).length()>0)
1577                                 rdef.setLinearRegression(linearRegression);
1578                         else
1579                                 rdef.setLinearRegression("Y");
1580                 }
1581
1582                 if(chartType.equals(AppConstants.GT_BAR_3D)) {
1583                         chartOrientation = AppUtils.getRequestNvlValue(request, "chartOrientation");
1584                         secondaryChartRenderer = AppUtils.getRequestNvlValue(request, "secondaryChartRenderer");
1585                         chartDisplay = AppUtils.getRequestNvlValue(request, "chartDisplay");
1586                         //if(AppUtils.getRequestNvlValue(request, "chartOrientationInRunPage").length()>0)
1587                                 chartOrientationInRunPage = AppUtils.getRequestNvlValue(request,"chartOrientationInRunPage").equals("Y");
1588                         //if(AppUtils.getRequestNvlValue(request, "secondaryChartRendererInRunPage").length()>0)
1589                                 secondaryChartRendererInRunPage = AppUtils.getRequestNvlValue(request,"secondaryChartRendererInRunPage").equals("Y");
1590                         //if(AppUtils.getRequestNvlValue(request, "chartDisplayInRunPage").length()>0)
1591                                 chartDisplayInRunPage = AppUtils.getRequestNvlValue(request,"chartDisplayInRunPage").equals("Y");
1592                         rdef.setChartOrientation(chartOrientation+(chartOrientationInRunPage?"|Y":""));
1593                         rdef.setSecondaryChartRenderer(secondaryChartRenderer+(secondaryChartRendererInRunPage?"|Y":""));
1594                         rdef.setChartDisplay(chartDisplay+(chartDisplayInRunPage?"|Y":""));
1595                         rdef.setLastSeriesALineChart(nvl(lastSeriesALineChart, "N"));
1596                 }
1597
1598                 if(chartType.equals(AppConstants.GT_LINE)) {
1599                         chartOrientation = AppUtils.getRequestNvlValue(request, "chartOrientation");
1600                         secondaryChartRenderer = AppUtils.getRequestNvlValue(request, "secondaryChartRenderer");
1601                         chartDisplay = AppUtils.getRequestNvlValue(request, "chartDisplay");
1602                         //if(AppUtils.getRequestNvlValue(request, "chartOrientationInRunPage").length()>0)
1603                                 chartOrientationInRunPage = AppUtils.getRequestNvlValue(request,"chartOrientationInRunPage").equals("Y");
1604                         //if(AppUtils.getRequestNvlValue(request, "secondaryChartRendererInRunPage").length()>0)
1605                                 secondaryChartRendererInRunPage = AppUtils.getRequestNvlValue(request,"secondaryChartRendererInRunPage").equals("Y");
1606                         //if(AppUtils.getRequestNvlValue(request, "chartDisplayInRunPage").length()>0)
1607                                 chartDisplayInRunPage = AppUtils.getRequestNvlValue(request,"chartDisplayInRunPage").equals("Y");
1608                         rdef.setChartOrientation(chartOrientation+(chartOrientationInRunPage?"|Y":""));
1609                         rdef.setSecondaryChartRenderer(secondaryChartRenderer+(secondaryChartRendererInRunPage?"|Y":""));
1610                         rdef.setChartDisplay(chartDisplay+(chartDisplayInRunPage?"|Y":""));
1611                         rdef.setLastSeriesABarChart(nvl(lastSeriesABarChart, "N"));
1612                 }
1613                 if(chartType.equals(AppConstants.GT_TIME_DIFFERENCE_CHART)) {
1614                         intervalFromdate = AppUtils.getRequestNvlValue(request, "intervalFromDate");
1615                         intervalTodate   = AppUtils.getRequestNvlValue(request, "intervalToDate");
1616                         intervalLabel    = AppUtils.getRequestNvlValue(request, "intervalLabel");
1617                         displayIntervalInputInRunPage = AppUtils.getRequestNvlValue(request,"intervalInputInRunPage").equals("Y");
1618                         rdef.setIntervalFromdate(intervalFromdate+(displayIntervalInputInRunPage?"|Y":""));
1619                         rdef.setIntervalTodate(intervalTodate+(displayIntervalInputInRunPage?"|Y":""));
1620                         rdef.setIntervalLabel(intervalLabel);
1621                 }
1622                 if(chartType.equals(AppConstants.GT_STACKED_VERT_BAR) || chartType.equals(AppConstants.GT_STACKED_HORIZ_BAR) || chartType.equals(AppConstants.GT_STACKED_VERT_BAR_LINES)
1623                     || chartType.equals(AppConstants.GT_STACKED_HORIZ_BAR_LINES)) {
1624                          overLayItemLabel = AppUtils.getRequestNvlValue(request, "overlayItemValue");
1625                          rdef.setOverlayItemValueOnStackBar(nvl(overLayItemLabel, "N"));
1626                          animate = AppUtils.getRequestNvlValue(request, "animatedOption").equals("animate");
1627                          rdef.setChartAnimate(animate);
1628                 }
1629
1630                 rdef.setRangeAxisLowerLimit(AppUtils.getRequestNvlValue(request, "yAxisLowerLimit"));
1631                 rdef.setRangeAxisUpperLimit(AppUtils.getRequestNvlValue(request, "yAxisUpperLimit"));
1632                 rdef.setLegendLabelAngle(AppUtils.getRequestNvlValue(request,"labelAngle"));
1633         rdef.setLegendPosition(AppUtils.getRequestNvlValue(request,"legendPosition"));
1634         rdef.setMaxLabelsInDomainAxis(AppUtils.getRequestNvlValue(request,"maxLabelsInDomainAxis"));
1635         String chartLegendDisplay = AppUtils.getRequestNvlValue(request,"hideLegend");
1636         boolean showLegendDisplayOptionsInRunPage = false;
1637                 showLegendDisplayOptionsInRunPage = AppUtils.getRequestNvlValue(request,"showLegendDisplayOptionsInRunPage").equals("Y");
1638         rdef.setChartLegendDisplay(chartLegendDisplay+(showLegendDisplayOptionsInRunPage?"|Y":""));
1639         rdef.setChartToolTips(AppUtils.getRequestNvlValue(request,"hideTooltips"));
1640         rdef.setDomainAxisValuesAsString(AppUtils.getRequestNvlValue(request,"keepAsString"));
1641
1642         //System.out.println("KeepAsString " + AppUtils.getRequestNvlValue(request,"keepAsString"));
1643         //System.out.println("From ReportDef " + rdef.keepDomainAxisValueInChartAsString());
1644         // boolean reportUpdated = (!
1645                 // chartType.equals(nvl(rdef.getChartType())));
1646                 rdef.setChartType(chartType);
1647                 rdef.setChartTypeFixed(nvl(chartTypeFixed, "N"));
1648                 if (nvl(leftAxisLabel).length()>0)
1649                         rdef.setChartLeftAxisLabel(leftAxisLabel);
1650                 else
1651                         rdef.setChartLeftAxisLabel(null);
1652                 if (nvl(rightAxisLabel).length()>0)
1653                         rdef.setChartRightAxisLabel(rightAxisLabel);
1654                 else
1655                         rdef.setChartRightAxisLabel(null);
1656                 rdef.setChartWidth(nvl(chartWidth, "" + Globals.getDefaultChartWidth()));
1657                 rdef.setChartHeight(nvl(chartHeight, "" + Globals.getDefaultChartHeight()));
1658                 if(chartType.equals(AppConstants.GT_TIME_SERIES) || chartType.equals(AppConstants.GT_PIE_MULTIPLE)) {
1659                         rdef.setChartMultiSeries(chartMultiseries);
1660                 }  else {
1661                         rdef.setChartMultiSeries("N");
1662                 }
1663
1664                 List reportCols = rdef.getAllColumns();
1665                 for (Iterator iter = reportCols.iterator(); iter.hasNext();) {
1666                         DataColumnType dct = (DataColumnType) iter.next();
1667
1668                         if (dct.getColId().equals(legendColId)) {
1669                                 // reportUpdated = reportUpdated||(!
1670                                 // nvl(dct.getColOnChart()).equals(AppConstants.GC_LEGEND));
1671                                 dct.setColOnChart(AppConstants.GC_LEGEND);
1672                         } else {
1673                                 // reportUpdated =
1674                                 // reportUpdated||nvl(dct.getColOnChart()).equals(AppConstants.GC_LEGEND);
1675                                 dct.setColOnChart(null);
1676                         }
1677
1678                         /*
1679                          * if(dct.getColId().equals(valueColId)) { reportUpdated =
1680                          * reportUpdated||(dct.getChartSeq()<=0); dct.setChartSeq(1); }
1681                          * else { reportUpdated = reportUpdated||(dct.getChartSeq()>0);
1682                          */
1683                         dct.setChartSeq(-1);
1684                         /* } */
1685                 } // for
1686
1687                 int idx = 1;
1688                 List columns = rdef.getAllColumns();
1689                 if(chartType.equals(AppConstants.GT_TIME_SERIES)) {
1690                         String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1691                         String chartGroup = AppUtils.getRequestNvlValue(request, "chartGroup");
1692                         String yAxis = AppUtils.getRequestNvlValue(request, "yAxis");
1693                 for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1694                                 DataColumnType alldct = (DataColumnType) iterator.next();
1695                                 //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1696                                 alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1697                         }
1698
1699                 String drillDownReportId = AppUtils.getRequestNvlValue(request, "drillDownReport");
1700                 if(!drillDownReportId.equals("-1")) {
1701                         ReportRuntime ddRr = (new ReportHandler()).loadReportRuntime(request, drillDownReportId,
1702                                         false);
1703                         if (ddRr != null)
1704                                 request.setAttribute("CHART_FORMFIELDS", ddRr.getReportFormFields());
1705
1706                         for(ddRr.getReportFormFields().resetNext(); ddRr.getReportFormFields().hasNext(); ) {
1707                                         FormField ff = ddRr.getReportFormFields().getNext();
1708                                         if(!ff.getFieldType().equals(FormField.FFT_BLANK)) {
1709                                                 String value = AppUtils.getRequestNvlValue(request, "drillDown_"+ff.getFieldName());
1710                                                 ChartDrillFormfield cdf = new ObjectFactory().createChartDrillFormfield();
1711                                                 cdf.setFormfield(value);
1712                                                 rdef.getChartDrillOptions().getTargetFormfield().add(cdf);
1713                                         }
1714                         }
1715                 }
1716
1717                 } else {
1718                         if(chartType.equals(AppConstants.GT_BAR_3D)) {
1719                                 String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1720                                 String chartGroup = AppUtils.getRequestNvlValue(request, "chartGroup");
1721                                 String yAxis = AppUtils.getRequestNvlValue(request, "yAxis");
1722                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1723                                         DataColumnType alldct = (DataColumnType) iterator.next();
1724                                         //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1725                                         alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1726                                 }
1727                         String drillDownReportId = AppUtils.getRequestNvlValue(request, "drillDownReport");
1728                         rdef.setDrillReportIdForChart(drillDownReportId);
1729                         if(drillDownReportId.equals("-1")){
1730                                 rdef.setDrillReportIdForChart("");
1731                         }
1732
1733                         if(!drillDownReportId.equals("-1")) {
1734                                 ReportRuntime ddRr = (new ReportHandler()).loadReportRuntime(request, drillDownReportId,
1735                                                 false);
1736                                 if (ddRr != null)
1737                                         request.setAttribute("CHART_FORMFIELDS", ddRr.getReportFormFields());
1738
1739                                 for(ddRr.getReportFormFields().resetNext(); ddRr.getReportFormFields().hasNext(); ) {
1740                                                 FormField ff = ddRr.getReportFormFields().getNext();
1741                                                 if(!ff.getFieldType().equals(FormField.FFT_BLANK)) {
1742                                                         String value = AppUtils.getRequestNvlValue(request, "drillDown_"+ff.getFieldName());
1743                                                         ChartDrillFormfield cdf = new ObjectFactory().createChartDrillFormfield();
1744                                                         cdf.setFormfield(value);
1745                                                         rdef.getChartDrillOptions().getTargetFormfield().add(cdf);
1746                                                 }
1747                                 }
1748
1749                                 String xAxisFormField           = AppUtils.getRequestNvlValue(request, "drillDownXAxisFormfield");
1750                                 String yAxisFormField           = AppUtils.getRequestNvlValue(request, "drillDownYAxisFormfield");
1751                                 String seriesAxisFormField      = AppUtils.getRequestNvlValue(request, "drillDownSeriesAxisFormfield");
1752
1753                                 if(!xAxisFormField.equals("-1")){
1754                                         rdef.setDrillXAxisFormField(xAxisFormField);
1755
1756                                 if(!yAxisFormField.equals("-1"))
1757                                         rdef.setDrillYAxisFormField(yAxisFormField);
1758                                 if(!seriesAxisFormField.equals("-1"))
1759                                         rdef.setDrillSeriesFormField(seriesAxisFormField);
1760                                 } else {
1761                                         rdef.setDrillXAxisFormField("");
1762                                         rdef.setDrillYAxisFormField("");
1763                                         rdef.setDrillSeriesFormField("");
1764                                 }
1765                         }
1766
1767                         } else if(chartType.equals(AppConstants.GT_SCATTER)) {
1768                                 String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1769                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1770                                         DataColumnType alldct = (DataColumnType) iterator.next();
1771                                         //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1772                                         alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1773                                 }
1774
1775                         }else if(chartType.equals(AppConstants.GT_REGRESSION)) {
1776                                 String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1777                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1778                                         DataColumnType alldct = (DataColumnType) iterator.next();
1779                                         //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1780                                         alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1781                                 }
1782                         }else if(chartType.equals(AppConstants.GT_STACKED_HORIZ_BAR) || chartType.equals(AppConstants.GT_STACKED_VERT_BAR)
1783                     || chartType.equals(AppConstants.GT_STACKED_VERT_BAR_LINES) || chartType.equals(AppConstants.GT_STACKED_HORIZ_BAR_LINES)) {
1784                                 String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1785                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1786                                         DataColumnType alldct = (DataColumnType) iterator.next();
1787                                         //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1788                                         alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1789                                 }
1790                         }else if(chartType.equals(AppConstants.GT_LINE)) {
1791                                         String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1792                                 for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1793                                                 DataColumnType alldct = (DataColumnType) iterator.next();
1794                                                 //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1795                                                 alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1796                                         }
1797                         } else if (chartType.equals(AppConstants.GT_TIME_DIFFERENCE_CHART)) {
1798                                 String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1799                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1800                                         DataColumnType alldct = (DataColumnType) iterator.next();
1801                                         //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1802                                         alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1803                                 }
1804                         } else if (chartType.equals(AppConstants.GT_COMPARE_PREVYEAR_CHART)) {
1805                                 String chartSeries = AppUtils.getRequestNvlValue(request, "chartSeries");
1806                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1807                                         DataColumnType alldct = (DataColumnType) iterator.next();
1808                                         //debugLogger.debug("**********In  " +  chartSeries + " " + alldct.getColId());
1809                                         alldct.setChartSeries((chartSeries.equals(alldct.getColId()))?true : false);
1810                                 }
1811
1812                         } else {
1813                                 if (rdef.hasSeriesColumn()) {
1814                                 for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1815                                                 DataColumnType alldct = (DataColumnType) iterator.next();
1816                                                 alldct.setChartSeries(false);
1817                                         }
1818                                 }
1819
1820                         String drillDownReportId = AppUtils.getRequestNvlValue(request, "drillDownReport");
1821                         rdef.setDrillReportIdForChart(drillDownReportId);
1822                         if(drillDownReportId.equals("-1")){
1823                                 rdef.setDrillReportIdForChart("");
1824                         }
1825
1826                         if(!drillDownReportId.equals("-1")) {
1827                                 ReportRuntime ddRr = (new ReportHandler()).loadReportRuntime(request, drillDownReportId,
1828                                                 false);
1829                                 if (ddRr != null)
1830                                         request.setAttribute("CHART_FORMFIELDS", ddRr.getReportFormFields());
1831                                 for(ddRr.getReportFormFields().resetNext(); ddRr.getReportFormFields().hasNext(); ) {
1832                                                 FormField ff = ddRr.getReportFormFields().getNext();
1833                                                 if(!ff.getFieldType().equals(FormField.FFT_BLANK)) {
1834                                                         String value = AppUtils.getRequestNvlValue(request, "drillDown_"+ff.getFieldName());
1835                                                         ChartDrillFormfield cdf = new ObjectFactory().createChartDrillFormfield();
1836                                                         cdf.setFormfield(value);
1837                                                         rdef.getChartDrillOptions().getTargetFormfield().add(cdf);
1838                                                 }
1839                                 }
1840
1841                                 String xAxisFormField           = AppUtils.getRequestNvlValue(request, "drillDownXAxisFormfield");
1842                                 String yAxisFormField           = AppUtils.getRequestNvlValue(request, "drillDownYAxisFormfield");
1843                                 String seriesAxisFormField      = AppUtils.getRequestNvlValue(request, "drillDownSeriesAxisFormfield");
1844
1845                                 if(!xAxisFormField.equals("-1")){
1846                                         rdef.setDrillXAxisFormField(xAxisFormField);
1847
1848                                 if(!yAxisFormField.equals("-1"))
1849                                         rdef.setDrillYAxisFormField(yAxisFormField);
1850                                 if(!seriesAxisFormField.equals("-1"))
1851                                         rdef.setDrillSeriesFormField(seriesAxisFormField);
1852                                 } else {
1853                                         rdef.setDrillXAxisFormField("");
1854                                         rdef.setDrillYAxisFormField("");
1855                                         rdef.setDrillSeriesFormField("");
1856                                 }
1857                         }
1858
1859                         }
1860                 }
1861
1862                 for (int i = 1; i < Math.max(valueColsCount, 1) + 1; i++) {
1863                          //debugLogger.debug("********** " +  chartSeries);
1864                         if(i==1) {
1865                             /* Range Axis is resetted before adding */
1866                         for (Iterator iterator = columns.iterator(); iterator.hasNext();) {
1867                                         DataColumnType dct = (DataColumnType) iterator.next();
1868                                         if(!nvl(dct.getColOnChart()).equals(AppConstants.GC_LEGEND)) {
1869                                                 dct.setChartSeq(-1);
1870                                                 dct.setChartColor(null);
1871                                                 dct.setColOnChart(null);
1872                                                 dct.setCreateInNewChart(false);
1873                                                 dct.setChartGroup(null);
1874                                                 dct.setYAxis(null);
1875                                         }
1876                         }
1877
1878                         }
1879                         String newChartColAxis = AppUtils.getRequestNvlValue(request, "newChart" + i+"Axis");
1880                         String valueColId = AppUtils.getRequestNvlValue(request, "valueCol" + i);
1881                         String valueColColor = AppUtils.getRequestNvlValue(request, "valueCol" + i
1882                                         + "Color");
1883                         String valueColAxis = AppUtils
1884                                         .getRequestNvlValue(request, "valueCol" + valueColId + "Axis");
1885                         String chartGroup = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "chartGroup" + valueColId + "Axis"));
1886                         String yAxisGroup = "";
1887                         yAxisGroup = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "YAxisLabel" + valueColId));
1888                         //debugLogger.debug("^^^^^^^^^^^^^^^^^Chart Group  "  + chartGroup);
1889                         //if(chartType.equals(AppConstants.GT_TIME_SERIES)) {
1890                         //       debugLogger.debug("**********Outer If " +  chartSeries);
1891                         //}
1892
1893                         if (valueColId.length() > 0 && (!valueColId.equals(removeColId))) {
1894                                 DataColumnType dct = rdef.getColumnById(valueColId);
1895                                 dct.setChartSeq(idx++);
1896                                 dct.setChartColor(valueColColor);
1897                                 dct.setColOnChart(valueColAxis.equals("Y") ? "1" : "0");
1898                                 if(chartType.equals(AppConstants.GT_TIME_SERIES)) {
1899                                  dct.setCreateInNewChart(newChartColAxis.equals("Y") ? true : false);
1900                                 } else
1901                                  dct.setCreateInNewChart(false);
1902
1903                                  if(chartGroup!=null && chartGroup.length()>0)
1904                                          dct.setChartGroup(chartGroup+"|"+valueColId);
1905                                  else dct.setChartGroup("");
1906                                  if(chartType.equals(AppConstants.GT_TIME_SERIES))
1907                                          dct.setYAxis(nvl(yAxisGroup)+"|"+valueColId);
1908                                  else if (chartType.equals(AppConstants.GT_BAR_3D))
1909                                          dct.setYAxis(nvl(yAxisGroup)+"|"+valueColId);
1910                                  else dct.setYAxis("");
1911                                 //}
1912                                 //else
1913                                  //dct.setCreateInNewChart(false);
1914                         } else if (valueColId.length() > 0 && (valueColId.equals(removeColId))) {// if
1915                                 DataColumnType dct = rdef.getColumnById(valueColId);
1916                                 dct.setChartSeq(-1);
1917                                 dct.setChartColor(null);
1918                                 dct.setColOnChart(null);
1919                                 dct.setCreateInNewChart(false);
1920                                 dct.setChartGroup(null);
1921                                 dct.setYAxis(null);
1922                         } else { // else
1923                                 DataColumnType dct = rdef.getColumnById(valueColId);
1924                                 dct.setChartSeq(-1);
1925                                 dct.setChartColor(null);
1926                                 dct.setColOnChart(null);
1927                                 dct.setCreateInNewChart(false);
1928                                 dct.setChartGroup(null);
1929                                 dct.setYAxis(null);
1930                         }
1931                 } // for
1932
1933                 if (action.equals(AppConstants.WA_ADD_USER)) {
1934                         String valueColId = AppUtils.getRequestNvlValue(request, "valueColNew");
1935                         String valueColColor = AppUtils.getRequestNvlValue(request, "valueColNewColor");
1936                         String valueColAxis = AppUtils.getRequestNvlValue(request, "valueColNewAxis");
1937
1938                         if (valueColId.length() > 0) {
1939                                 DataColumnType dct = rdef.getColumnById(valueColId);
1940                                 dct.setChartSeq(idx++);
1941                                 dct.setChartColor(valueColColor);
1942                                 dct.setColOnChart(valueColAxis.equals("Y") ? "1" : "0");
1943                         } // if
1944                 } // for
1945
1946                 return true; // reportUpdated;
1947         } // processChart
1948
1949         public boolean processAdhocSchedule(HttpServletRequest request, String action)
1950         throws Exception {
1951                 ReportSchedule reportSchedule = (ReportSchedule) request.getSession().getAttribute(AppConstants.SI_REPORT_SCHEDULE);
1952                 reportSchedule.setScheduleUserID(AppUtils.getUserID(request));
1953                 reportSchedule.setSchedEnabled(
1954                                 nvl(AppUtils.getRequestValue(request, "schedEnabled"), "N"));
1955                 reportSchedule.setStartDate(
1956                                 AppUtils.getRequestNvlValue(request, "schedStartDate"));
1957                 reportSchedule.setEndDate(
1958                                 AppUtils.getRequestNvlValue(request, "schedEndDate"));
1959                 reportSchedule.setEndHour(AppUtils.getRequestNvlValue(request, "schedEndHour"));
1960                 reportSchedule.setEndMin(AppUtils.getRequestNvlValue(request, "schedEndMin"));
1961                 reportSchedule.setEndAMPM(AppUtils.getRequestNvlValue(request, "schedEndAMPM"));
1962                 //schedRunDate
1963                 reportSchedule.setRunDate(
1964                                 AppUtils.getRequestNvlValue(request, "schedRunDate").length()>0?AppUtils.getRequestNvlValue(request, "schedRunDate"):AppUtils.getRequestNvlValue(request, "schedStartDate"));
1965                 reportSchedule.setRunHour(AppUtils.getRequestNvlValue(request, "schedHour"));
1966                 reportSchedule.setRunMin(AppUtils.getRequestNvlValue(request, "schedMin"));
1967                 reportSchedule.setRunAMPM(AppUtils.getRequestNvlValue(request, "schedAMPM"));
1968                 reportSchedule.setRecurrence(
1969                                 AppUtils.getRequestNvlValue(request, "schedRecurrence"));
1970                 reportSchedule.setConditional(
1971                                 nvl(AppUtils.getRequestValue(request, "conditional"), "N"));
1972                 reportSchedule.setConditionSQL(
1973                                 AppUtils.getRequestNvlValue(request, "conditionSQL"));
1974                 reportSchedule.setNotify_type(
1975                                 AppUtils.getRequestNvlValue(request, "notify_type"));
1976                 reportSchedule.setDownloadLimit(
1977                                 AppUtils.getRequestNvlValue(request, "downloadLimit"));
1978                 reportSchedule.setFormFields(
1979                                 AppUtils.getRequestNvlValue(request, "formFields"));
1980                  reportSchedule.setAttachmentMode(
1981                                 AppUtils.getRequestNvlValue(request, "sendAttachment"));
1982
1983                 String userId = AppUtils.getRequestNvlValue(request, "schedEmailAdd");
1984                 String roleId = AppUtils.getRequestNvlValue(request, "schedEmailAddRole");
1985                 int flag = 0;
1986                 if ((!(userId.length()>0 || roleId.length()>0) && (reportSchedule.getEmailToUsers().isEmpty() && reportSchedule.getEmailToRoles().isEmpty())) ) {
1987                         flag = 1;
1988                 }
1989
1990                 if (flag == 1 || (action.equals(AppConstants.WA_ADD_USER) || action.equals(AppConstants.WA_ADD_ROLE)) ) {
1991                         String loggedInUserId = AppUtils.getUserID(request);
1992                         if (Globals.getUseLoginIdInSchedYN().equals("Y")){
1993                                 reportSchedule.addEmailToUser(loggedInUserId, AppUtils.getUserLoginId(request));
1994                         } else
1995                         reportSchedule.addEmailToUser(loggedInUserId, (AppUtils.getUserName(loggedInUserId).length()>0?AppUtils.getUserName(loggedInUserId):(AppUtils.getUserLoginId(loggedInUserId).length()>0?AppUtils.getUserLoginId(loggedInUserId):loggedInUserId) ));
1996                 }
1997                 if (action.equals(AppConstants.WA_ADD_USER)) {
1998                         //String userId = AppUtils.getRequestNvlValue(request, "schedEmailAdd");
1999                         String userName = AppUtils.getUserName(userId);
2000                         if (Globals.getUseLoginIdInSchedYN().equals("Y")){
2001                                 String userLoginId = AppUtils.getUserLoginId(userId);
2002                                 if (userId.length() > 0 && (userLoginId != null && userLoginId.length() > 0))
2003                                         reportSchedule.addEmailToUser(userId, userLoginId);
2004                                 else {
2005                                         if (userId.length() > 0 && (userName != null && userName.length() > 0) )
2006                                                 reportSchedule.addEmailToUser(userId, userName);
2007                                         else {
2008                                                 reportSchedule.addEmailToUser(userId, userId);
2009                                         }
2010                                 }
2011                         }else{
2012                                 if (userId.length() > 0 &&  (userName != null && userName.length() > 0) )
2013                                         reportSchedule.addEmailToUser(userId, userName);
2014                                 else {
2015                                         reportSchedule.addEmailToUser(userId, userId);
2016                                 }
2017                         }
2018
2019                 } else if (action.equals(AppConstants.WA_DELETE_USER))
2020                         reportSchedule.removeEmailToUser(
2021                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
2022                 else if (action.equals(AppConstants.WA_ADD_ROLE)) {
2023                         //String roleId = AppUtils.getRequestNvlValue(request, "schedEmailAddRole");
2024                         String roleName = AppUtils.getRoleName(roleId);
2025                         if (roleId.length() > 0 && roleName != null)
2026                                 reportSchedule.addEmailToRole(roleId, roleName);
2027                 } else if (action.equals(AppConstants.WA_DELETE_ROLE))
2028                         reportSchedule.removeEmailToRole(
2029                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
2030                 request.getSession().setAttribute(AppConstants.SI_REPORT_SCHEDULE, reportSchedule);
2031                 return true;
2032         } // processAdhocSchedule
2033
2034         private boolean processSchedule(HttpServletRequest request, String action)
2035                         throws Exception {
2036                 // Added for form field chaining in schedule tab so that setParamValues() is called
2037                 request.setAttribute(AppConstants.SCHEDULE_ACTION, "Y");
2038                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
2039                                 AppConstants.SI_REPORT_DEFINITION);
2040                 ReportSchedule reportSchedule = rdef.getReportSchedule();
2041                 reportSchedule.setScheduleUserID(AppUtils.getUserID(request));
2042                 reportSchedule.setSchedEnabled(
2043                                 nvl(AppUtils.getRequestValue(request, "schedEnabled"), "N"));
2044                 reportSchedule.setStartDate(
2045                                 AppUtils.getRequestNvlValue(request, "schedStartDate"));
2046                 reportSchedule.setEndDate(
2047                                 AppUtils.getRequestNvlValue(request, "schedEndDate"));
2048                 reportSchedule.setEndHour(AppUtils.getRequestNvlValue(request, "schedEndHour"));
2049                 reportSchedule.setEndMin(AppUtils.getRequestNvlValue(request, "schedEndMin"));
2050                 reportSchedule.setEndAMPM(AppUtils.getRequestNvlValue(request, "schedEndAMPM"));
2051                 //schedRunDate
2052                 reportSchedule.setRunDate(
2053                                 AppUtils.getRequestNvlValue(request, "schedRunDate").length()>0?AppUtils.getRequestNvlValue(request, "schedRunDate"):AppUtils.getRequestNvlValue(request, "schedStartDate"));
2054                 reportSchedule.setRunHour(AppUtils.getRequestNvlValue(request, "schedHour"));
2055                 reportSchedule.setRunMin(AppUtils.getRequestNvlValue(request, "schedMin"));
2056                 reportSchedule.setRunAMPM(AppUtils.getRequestNvlValue(request, "schedAMPM"));
2057                 reportSchedule.setRecurrence(
2058                                 AppUtils.getRequestNvlValue(request, "schedRecurrence"));
2059                 reportSchedule.setConditional(
2060                                 nvl(AppUtils.getRequestValue(request, "conditional"), "N"));
2061                 reportSchedule.setConditionSQL(
2062                                 AppUtils.getRequestNvlValue(request, "conditionSQL"));
2063                 reportSchedule.setNotify_type(
2064                                 AppUtils.getRequestNvlValue(request, "notify_type"));
2065                 reportSchedule.setDownloadLimit(
2066                                 AppUtils.getRequestNvlValue(request, "downloadLimit"));
2067                 reportSchedule.setFormFields(
2068                                 AppUtils.getRequestNvlValue(request, "formFields"));
2069                 reportSchedule.setAttachmentMode(
2070                                 AppUtils.getRequestNvlValue(request, "sendAttachment"));
2071
2072                 reportSchedule.setEncryptMode(
2073                                 AppUtils.getRequestNvlValue(request, "encryptMode"));
2074                 if (action.equals(AppConstants.WA_ADD_USER)) {
2075                         String userId = AppUtils.getRequestNvlValue(request, "schedEmailAdd");
2076                         String userName = AppUtils.getUserName(userId);
2077                         if (Globals.getUseLoginIdInSchedYN().equals("Y")){
2078                                 String userLoginId = AppUtils.getUserLoginId(userId);
2079                                 if (userId.length() > 0 && (userLoginId != null && userLoginId.length() > 0))
2080                                         reportSchedule.addEmailToUser(userId, userLoginId);
2081                                 else {
2082                                         if (userId.length() > 0 && (userName != null && userName.length() > 0) )
2083                                                 reportSchedule.addEmailToUser(userId, userName);
2084                                         else {
2085                                                 reportSchedule.addEmailToUser(userId, userId);
2086                                         }
2087                                 }
2088                         }else{
2089                                 if (userId.length() > 0 &&  (userName != null && userName.length() > 0) )
2090                                         reportSchedule.addEmailToUser(userId, userName);
2091                                 else {
2092                                         reportSchedule.addEmailToUser(userId, userId);
2093                                 }
2094                         }
2095                 } else if (action.equals(AppConstants.WA_DELETE_USER))
2096                         reportSchedule.removeEmailToUser(
2097                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
2098                 else if (action.equals(AppConstants.WA_ADD_ROLE)) {
2099                         String roleId = AppUtils.getRequestNvlValue(request, "schedEmailAddRole");
2100                         String roleName = AppUtils.getRoleName(roleId);
2101                         if (roleId.length() > 0 && roleName != null)
2102                                 reportSchedule.addEmailToRole(roleId, roleName);
2103                 } else if (action.equals(AppConstants.WA_DELETE_ROLE))
2104                         reportSchedule.removeEmailToRole(
2105                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
2106
2107                 return true;
2108         } // processSchedule
2109
2110         private boolean processUserAccess(HttpServletRequest request, String action)
2111                         throws Exception {
2112                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
2113                                 AppConstants.SI_REPORT_DEFINITION);
2114
2115                 String ownerID = AppUtils.getRequestNvlValue(request, "reportOwner");
2116                 String rPublic = nvl(AppUtils.getRequestValue(request, "public"), "N");
2117
2118                 boolean reportUpdated = (!(ownerID.equals(nvl(rdef.getOwnerID())) && rPublic
2119                                 .equals(rdef.isPublic() ? "Y" : "N")));
2120
2121                 rdef.getReportSecurity().setOwnerID(ownerID);
2122                 rdef.setPublic(rPublic.equals("Y"));
2123
2124                 if (action.equals(AppConstants.WA_ADD_USER))
2125                         rdef.getReportSecurity().addUserAccess(
2126                                         AppUtils.getRequestNvlValue(request, "newUserId"), "Y");
2127                 else if (action.equals(AppConstants.WA_DELETE_USER))
2128                         rdef.getReportSecurity().removeUserAccess(
2129                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
2130                 else if (action.equals(AppConstants.WA_GRANT_USER))
2131                         rdef.getReportSecurity().updateUserAccess(
2132                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID), "N");
2133                 else if (action.equals(AppConstants.WA_REVOKE_USER))
2134                         rdef.getReportSecurity().updateUserAccess(
2135                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID), "Y");
2136                 else if (action.equals(AppConstants.WA_ADD_ROLE))
2137                         rdef.getReportSecurity().addRoleAccess(
2138                                         AppUtils.getRequestNvlValue(request, "newRoleId"), "Y");
2139                 else if (action.equals(AppConstants.WA_DELETE_ROLE))
2140                         rdef.getReportSecurity().removeRoleAccess(
2141                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID));
2142                 else if (action.equals(AppConstants.WA_GRANT_ROLE))
2143                         rdef.getReportSecurity().updateRoleAccess(
2144                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID), "N");
2145                 else if (action.equals(AppConstants.WA_REVOKE_ROLE))
2146                         rdef.getReportSecurity().updateRoleAccess(
2147                                         AppUtils.getRequestNvlValue(request, AppConstants.RI_DETAIL_ID), "Y");
2148
2149                 return reportUpdated;
2150         } // processUserAccess
2151
2152         private boolean processClearLog(HttpServletRequest request) throws Exception {
2153                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
2154                                 AppConstants.SI_REPORT_DEFINITION);
2155                 String user_id = AppUtils.getUserID(request);
2156                 // Modified so that only the logged in user entries are erased. - Sundar
2157                 ReportLoader.clearReportLogEntries(rdef.getReportID(), user_id);
2158                 return false;
2159         } // processClearLog
2160
2161         private boolean processValidateSQL(HttpServletRequest request) throws Exception {
2162                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
2163                                 AppConstants.SI_REPORT_DEFINITION);
2164
2165                 String sql = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "reportSQL"));
2166                 request.setAttribute("sqlValidated", "N");
2167                 rdef.parseReportSQL(sql);
2168                 request.setAttribute("sqlValidated", "Y");
2169
2170                 return true;
2171         } // processValidateSQL
2172
2173
2174         /*****For Report Maps - Start******/
2175         private boolean processMap(HttpServletRequest request, String action) throws Exception {
2176                 ReportDefinition rdef = (ReportDefinition) request.getSession().getAttribute(
2177                                 AppConstants.SI_REPORT_DEFINITION);
2178
2179                 org.onap.portalsdk.analytics.xmlobj.ReportMap repMap = rdef.getReportMap();
2180                 //clearing already added
2181                 if (repMap != null){
2182                         repMap.getMarkers().removeAll(repMap.getMarkers());
2183                 }
2184                 String addressColumn = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "addressColumn0"));
2185                 System.out.println(" #$%#$%#$% -- address col = " + addressColumn);
2186                 String dataColumn = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "dataColumn0"));
2187                 String legendColumn = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "legendColumn"));
2188                 //String legendDisplayName = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "dataHeaderL"));
2189                 //if(nvl(legendDisplayName).length()<=0) legendDisplayName = legendColumn;
2190                 String color = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "markerColor0"));
2191                 String isMapAllowed = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "isMapAllowed"));
2192                 String useDefaultSize = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "useDefaultSize"));
2193                 String height = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "height"));
2194                 String width = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "width"));
2195                 System.out.println(" #$%#$%#$% -- useDefaultSize="+ useDefaultSize+"  height = " + height+" width="+width);
2196
2197                 String addAddress = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "addAddress"));
2198                 String latCol = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "latColumn"));
2199                 String longCol = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "longColumn"));
2200                 String colorCol = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "colorColumn"));
2201                 if (isMapAllowed.equals(""))
2202                         isMapAllowed = "N";
2203                 if (useDefaultSize.equals(""))
2204                         useDefaultSize = "N";
2205                 if (repMap == null)
2206                                 rdef.setReportMap(new ObjectFactory().createReportMap());
2207                 if(repMap!=null){
2208                         repMap.setAddressColumn(addressColumn);
2209                         repMap.setDataColumn(dataColumn);
2210                         repMap.setIsMapAllowedYN(isMapAllowed);
2211                         repMap.setUseDefaultSize(useDefaultSize);
2212                         repMap.setMarkerColor(color);
2213                         repMap.setAddAddressInDataYN(addAddress);
2214                         repMap.setLatColumn(latCol);
2215                         repMap.setLongColumn(longCol);
2216                         repMap.setColorColumn(colorCol);
2217                         repMap.setHeight(height.trim());
2218                         repMap.setWidth(width.trim());
2219                         repMap.setLegendColumn(legendColumn);
2220                         //repMap.setLegendDisplayName(legendDisplayName);
2221
2222                         Marker m = new ObjectFactory().createMarker();
2223                         m.setAddressColumn(addressColumn);
2224                         m.setDataColumn(dataColumn);
2225                         repMap.getMarkers().add(m);
2226                         String markerCountString = AppUtils.getRequestNvlValue(request, "markerCount");
2227                         int markerCount = 0;
2228                         if (markerCountString != null && markerCountString.equals("") == false){
2229                                 markerCount = new Integer(markerCountString).intValue();
2230                         }
2231                         for (int i = 1; i < markerCount; i ++){
2232                                 String additionalAddressColumn = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "addressColumn" + i));
2233                                 String additionalDataHeader = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "dataHeader" + i));
2234                                 String additionalData = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "dataColumn" + i));
2235                                 String additionalColor = XSSFilter.filterRequestOnlyScript(AppUtils.getRequestNvlValue(request, "markerColor" + i));
2236                                 if (additionalAddressColumn.equals("1") == false){
2237                                         m = new ObjectFactory().createMarker();
2238                                         m.setAddressColumn(additionalAddressColumn);
2239                                         m.setDataHeader(additionalDataHeader);
2240                                         m.setDataColumn(additionalData);
2241                                         m.setMarkerColor(additionalColor);
2242                                         repMap.getMarkers().add(m);
2243                                 }
2244                         }
2245                 }
2246
2247                 return true;
2248         } // processMap
2249         /*****For Report Maps - End******/
2250
2251
2252 } // WizardProcessor