diff options
Diffstat (limited to 'ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/Globals.java')
| -rw-r--r-- | ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/Globals.java | 2307 |
1 files changed, 2307 insertions, 0 deletions
diff --git a/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/Globals.java b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/Globals.java new file mode 100644 index 00000000..ec6de3a4 --- /dev/null +++ b/ecomp-sdk/epsdk-analytics/src/main/java/org/openecomp/portalsdk/analytics/system/Globals.java @@ -0,0 +1,2307 @@ +/*- + * ================================================================================ + * eCOMP Portal SDK + * ================================================================================ + * Copyright (C) 2017 AT&T Intellectual Property + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * ================================================================================ + */ + +/* =========================================================================================== + * This class is part of <I>RAPTOR (Rapid Application Programming Tool for OLAP Reporting)</I> + * Raptor : This tool is used to generate different kinds of reports with lot of utilities + * =========================================================================================== + * + * ------------------------------------------------------------------------------------------- + * Globals.java - This class is used to read properties file and call the common methods + * existing among all the frameworks. + + * ------------------------------------------------------------------------------------------- + * + * + * Changes + * ------- + * 31-Jul-2009 : Version 8.4 (Sundar); <UL><LI> getRequestparametersMap method iterates form field collections. </LI> + * </UL> + * 27-Jul-2009 : Version 8.4 (Sundar); <UL><LI> Added property "admin_role_equiv_to_super_role" to specify Admin User equivalent to Super User.</LI> + * </UL> + * 14-Jul-2009 : Version 8.4 (Sundar); <UL><LI> Added property to showing/hiding params displayed in dashboard reports.</LI> + * </UL> + * + */ +package org.openecomp.portalsdk.analytics.system; + +import java.io.IOException; +import java.io.UnsupportedEncodingException; +import java.util.ArrayList; +import java.util.HashMap; +import java.util.Hashtable; +import java.util.Iterator; +import java.util.List; +import java.util.Map; +import java.util.Properties; +import java.util.Set; +import java.util.StringTokenizer; + +import javax.servlet.ServletContext; +import javax.servlet.http.HttpServletRequest; + +import org.openecomp.portalsdk.analytics.config.ConfigLoader; +import org.openecomp.portalsdk.analytics.controller.ActionMapping; +import org.openecomp.portalsdk.analytics.model.runtime.FormField; +import org.openecomp.portalsdk.analytics.model.runtime.ReportFormFields; +import org.openecomp.portalsdk.analytics.model.runtime.ReportRuntime; +import org.openecomp.portalsdk.analytics.util.AppConstants; +import org.openecomp.portalsdk.analytics.util.ExcelColorDef; +import org.openecomp.portalsdk.analytics.util.Scheduler; +import org.openecomp.portalsdk.analytics.util.Utils; +import org.openecomp.portalsdk.core.logging.logic.EELFLoggerDelegate; + +public class Globals extends org.openecomp.portalsdk.analytics.RaptorObject { + + static EELFLoggerDelegate logger = EELFLoggerDelegate.getLogger(Globals.class); + + + private static boolean systemInitialized = false; + + private static ActionMapping raptorActionMapping = null; + + private static Scheduler scheduler = null; + + // System type constants + public final static String ST_FUSION = "fusion"; + + public final static String ST_GENERIC = "generic"; + + public final static String ST_PRISMS = "prisms"; + + private static String systemType = ST_PRISMS; // default + + private static IAppUtils appUtils = null; + + private static IDbUtils dbUtils = null; + + private static RDbUtils rdbUtils = null; + + private static int debugLevel = 5; + + private static int downloadLimit = 65000; // max number rows for download + // csv file + + private static int defaultPageSize = 50; + + private static int formFieldsListSize = 50; + + private static int schedulerInterval = 0; + + private static String systemName = "MSA Databank"; + + private static String baseTitle = "ANALYSIS"; + + private static String sheet_name = "Raptor Reports"; + + private static String jFreeVersion = AppConstants.JFV_0911; + + private static boolean allowSQLBasedReports = true; // whether to allow + // SQL-based report + // definition (security + // risk); super users + // are always allowed to + // create SQL-based + // reports + + private static boolean showDisclaimer = true; // whether to include + // disclaimer page at the + // bottom of each screen + + private static boolean displayFormBeforeRun = true; // whether to display + // the form page as a + // separate page before + // running the report + + private static boolean includeFormWithData = true; // whether to include + // the form page on the + // report data page + + private static boolean cacheChartData = true; // whether to cache chart + // data in the session => + // faster re-display if the + // data volume does not get + // too large + + private static boolean cacheCurPageData = true; // whether to cache report + // data for the currently + // displayed page in the + // session => faster + // re-display if the data + // volume does not get too + // large + + private static boolean deleteOnlyByOwner = true; // whether to permit + // report deletion only + // by report owner or by + // everyone with "write" + // access + + private static boolean enableReportLog = true; // whether to log each + // report execution and + // update time and user ID + + private static boolean cacheUserRoles = true; // whether to cache user + // roles info in memory + // (saves many DB reads, but + // does not account for + // roles assigned after the + // cache was loaded) + + private static boolean monthFormatUseLastDay = true; // whether to + // convert month + // formats (e.g. + // MM/YYYY) to the + // last day of the + // month (true) or + // first day (false) + // - like 12/2003 is + // converted to + // either 12/31/2003 + // or 12/01/2003 + + private static boolean printTitleInDownload = false; // whether to print + // the report title + // in the download + // files + + private static boolean showDescrAtRuntime = false; // whether to show + // report description + // when the report is + // run and in the quick + // links + + // private static boolean skipChartLabelsToFit = false; // whether to skip + // labels on the Line chart axis when they overlap + private static boolean showNonstandardCharts = false; // whether to show + // chart types that + // are purpose + // and/or data + // specific + + private static boolean allowRuntimeChartSel = true; // whether to allow the + // user to change the + // chart type at runtime + + private static boolean displayChartTitle = false; // whether to display + // the report title as + // chart title as well + + private static boolean mergeCrosstabRowHeadings = true; // whether to + // merge/blank + // multi-level row + // headings in + // cross-tab report + + private static boolean displayChartByDefault = true; // whether to + // display chart + // when displaying + // the report at + // first or just a + // "Show Chart" + // button + + private static boolean printParamsInDownload = false; // whether to print + // the form field + // values in the + // download files + + // private static boolean chartLinesAlwaysSolid = true; // whether + // multi-lines chart uses solid line for all series or dashed/dotted/etc for + // each + // private static boolean chartLinesAlwaysSmooth = true; // whether line + // charts display smooth lines or with marked points on them for each value + private static int maxDecimalsOnTotals = 2; // Maximum number of decimals + // displayed in totals; decimal + // digits beyond that number + // will be truncated; if + // negative => display all + // decimal digits + + private static int defaultChartWidth = 700; + + private static int defaultChartHeight = 420; + + private static int skipChartLabelsLimit = 30; + + private static boolean canCopyOnReadOnly = true; // whether to users with + // read-only rights for + // a report can copy it + + // Currently not loaded from a property file + private static boolean restrictTablesByRole = true; // whether to restrict + // DB tables + // accessibility by user + // role; defaults to + // false if table + // CR_TABLE_ROLE is + // empty, otherwise true + + private static String javaTimeFormat = "MM/dd/yyyy h:m:s a"; + + private static String oracleTimeFormat = "%m/%d/%Y %h:%i:%s %p"; // must + // correspond + // to + // the + // java + // format + // modifier + + private static String raptorVersion = "10.5.1"; + + private static int flatFileLowerLimit = 0; + + private static int flatFileUpperLimit = 0; + + private static String shellScriptDir = ""; + + private static String queryFolder = ""; + + private static String requestParams = ""; + + private static String sessionParams = ""; + + private static boolean displayAllUsers = true; + + private static boolean user_col_def = true; + + private static boolean printFooterInDownload = true; + + private static String footerFirstLine = ""; + + private static String footerSecondLine = ""; + + private static boolean reportsInPoPUpWindow = false; + + private static boolean poPUpInNewWindow = false; + + private static boolean passRequestParamInDrilldown = false; + + private static Properties raptorPdfProperties; + + private static Properties raptorProperties; + + private static Properties sqlProperty; + + private static boolean showPDFDownloadIcon = false; + + + + private Globals() { + } + + public static synchronized void initializeSystem(ServletContext servletContext) { + if (systemInitialized) + return; + AppConstants.initializeAppConstants(); + ExcelColorDef.initializeExcelColorDef(); + + //DB Agnostic Addition + try{ + Properties sqlProperty = ConfigLoader.getProperties(servletContext, ConfigLoader.SQL_PROPERTIES); + Globals.sqlProperty = sqlProperty; + } + + catch (IOException e) { + e.printStackTrace(); + } + + try { + Properties raptorProperties = ConfigLoader.getProperties(servletContext, + ConfigLoader.RAPTOR_PROPERTIES); + initializeRaptorProperties(raptorProperties); + + + } catch (Exception e) { + logger.error(EELFLoggerDelegate.debugLogger, ("[EXCEPTION ENCOUNTERED IN RAPTOR] Globals: Unable to load properties [" + + ConfigLoader.RAPTOR_PROPERTIES + "]. Exception: " + e.getMessage())); + // throw new RuntimeException(e.getMessage()); + } + + systemInitialized = true; + + try { + appUtils = (IAppUtils) Class.forName( + "org.openecomp.portalsdk.analytics.system." + systemType.toLowerCase() + ".AppUtils") + .newInstance(); + appUtils.initializeAppUtils(servletContext); + + dbUtils = (IDbUtils) Class.forName( + "org.openecomp.portalsdk.analytics.system." + systemType.toLowerCase() + ".DbUtils") + .newInstance(); + dbUtils.initializeDbUtils(servletContext); + + if(!Globals.getSystemType().equals(Globals.ST_GENERIC)) { + rdbUtils = (RDbUtils) Class.forName( + "org.openecomp.portalsdk.analytics.system." + systemType.toLowerCase() + ".RemoteDbUtils") + .newInstance(); + rdbUtils.initializeDbUtils(servletContext); + } + } catch (Exception e) { + String eMsg = "[SYSTEM ERROR] Globals: Unable to instantiate system classes. Exception: " + + e.getMessage(); + logger.error(EELFLoggerDelegate.debugLogger, ("[EXCEPTION ENCOUNTERED IN RAPTOR] " + eMsg)); + systemInitialized = false; + throw new RuntimeException(eMsg); + } + + try { + raptorActionMapping = ConfigLoader.loadRaptorActionMapping(servletContext); + } catch (Exception e) { + String eMsg = "[SYSTEM ERROR] Globals: Unable to load Raptor action mapping. Exception: " + + e.getMessage(); + logger.error(EELFLoggerDelegate.debugLogger, ("[EXCEPTION ENCOUNTERED IN RAPTOR] " + eMsg)); + systemInitialized = false; + throw new RuntimeException(eMsg); + } // catch + + /*try { + //DataSet ds = DbUtils + // .executeQuery("SELECT 1 FROM dual WHERE EXISTS (SELECT 1 FROM cr_table_role)"); + + String p_sql = Globals.getInitializeRoles(); + DataSet ds = DbUtils.executeQuery(p_sql); + + restrictTablesByRole = (ds.getRowCount() > 0); + } catch (Exception e) { + String eMsg = "[SYSTEM ERROR] Globals: Unable to load Raptor version. Exception: " + + e.getMessage(); + debugLogger.error("[EXCEPTION ENCOUNTERED IN RAPTOR] " + eMsg, e); + } // catch + */ + /*try { + //DataSet ds = DbUtils.executeQuery("SELECT cr_raptor.get_version FROM dual"); + + //String n_sql = Globals.getInitializeVersion(); + //DataSet ds = DbUtils.executeQuery(n_sql); + //raptorVersion = Globals.get + // if(ds.getRowCount()>0) + // raptorVersion = " v"+ds.getString(0, 0); + } catch (Exception e) { + String eMsg = "[SYSTEM ERROR] Globals: Unable to load Raptor version. Exception: " + + e.getMessage(); + debugLogger.error("[EXCEPTION ENCOUNTERED IN RAPTOR] " + eMsg, e); + } // catch*/ + + + //initiate pdf global config + try { + raptorPdfProperties = ConfigLoader.getProperties(servletContext, ConfigLoader.RAPTOR_PDF_PROPERTIES); + } + catch (Exception e) { + logger.error(EELFLoggerDelegate.debugLogger, ("[EXCEPTION ENCOUNTERED IN RAPTOR] Globals: Unable to load properties [" + + ConfigLoader.RAPTOR_PDF_PROPERTIES + "]. Exception: " + e.getMessage())); + + } + + scheduler = new Scheduler(schedulerInterval); + + } // initializeSystem + + public static void initializeRaptorProperties(Properties raptorProperties) { + Globals.raptorProperties = raptorProperties; + systemType = raptorProperties.getProperty("system"); + + try { + debugLevel = Integer.parseInt(nvls(raptorProperties + .getProperty("debug_level")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + downloadLimit = Integer.parseInt(nvls(raptorProperties + .getProperty("download_limit")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + defaultPageSize = Integer.parseInt(nvls(raptorProperties + .getProperty("default_page_size")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + formFieldsListSize = Integer.parseInt(nvls(raptorProperties + .getProperty("form_fields_list_size")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + schedulerInterval = Integer.parseInt(nvls(raptorProperties + .getProperty("scheduler_interval")).trim()); + } catch (NumberFormatException nfe) { + System.out.println("NUMBERFORMATEXCEPTION Schedular " + raptorProperties + .getProperty("scheduler_interval")); + schedulerInterval = 0; + } + + try { + maxDecimalsOnTotals = Integer.parseInt(nvls(raptorProperties + .getProperty("max_decimals_on_totals")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + defaultChartWidth = Integer.parseInt(nvls(raptorProperties + .getProperty("default_chart_width")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + defaultChartHeight = Integer.parseInt(nvls(raptorProperties + .getProperty("default_chart_height")).trim()); + } catch (NumberFormatException nfe) { + } + + try { + skipChartLabelsLimit = Integer.parseInt(nvls(raptorProperties + .getProperty("skip_chart_labels_limit")).trim()); + } catch (NumberFormatException nfe) { + } + + systemName = nvls(raptorProperties.getProperty("system_name"), "MSA Databank"); + baseTitle = nvls(raptorProperties.getProperty("base_title"), "ANALYSIS"); + jFreeVersion = nvls(raptorProperties.getProperty("jfree_version"), + AppConstants.JFV_0911); + + allowSQLBasedReports = nvls( + raptorProperties.getProperty("allow_sql_based_reports"), "yes") + .toUpperCase().startsWith("Y"); + showDisclaimer = nvls(raptorProperties.getProperty("show_disclaimer"), "yes") + .toUpperCase().startsWith("Y"); + displayFormBeforeRun = nvls( + raptorProperties.getProperty("display_form_before_run"), "yes") + .toUpperCase().startsWith("Y"); + includeFormWithData = nvls(raptorProperties.getProperty("include_form_with_data"), + "yes").toUpperCase().startsWith("Y"); + cacheChartData = nvls(raptorProperties.getProperty("cache_chart_data"), "yes") + .toUpperCase().startsWith("Y"); + cacheCurPageData = nvls(raptorProperties.getProperty("cache_cur_page_data"), "yes") + .toUpperCase().startsWith("Y"); + deleteOnlyByOwner = nvls(raptorProperties.getProperty("delete_only_by_owner"), + "yes").toUpperCase().startsWith("Y"); + enableReportLog = nvls(raptorProperties.getProperty("enable_report_log"), "yes") + .toUpperCase().startsWith("Y"); + cacheUserRoles = nvls(raptorProperties.getProperty("cache_user_roles"), "yes") + .toUpperCase().startsWith("Y"); + monthFormatUseLastDay = nvls( + raptorProperties.getProperty("month_format_use_last_day"), "yes") + .toUpperCase().startsWith("Y"); + printTitleInDownload = nvls( + raptorProperties.getProperty("print_title_in_download"), "no") + .toUpperCase().startsWith("Y"); + showDescrAtRuntime = nvls(raptorProperties.getProperty("show_descr_at_runtime"), + "no").toUpperCase().startsWith("Y"); + // skipChartLabelsToFit = + // nvls(raptorProperties.getProperty("skip_chart_labels_to_fit"), + // "no" ).toUpperCase().startsWith("Y"); + showNonstandardCharts = nvls( + raptorProperties.getProperty("show_nonstandard_charts"), "no") + .toUpperCase().startsWith("Y"); + allowRuntimeChartSel = nvls( + raptorProperties.getProperty("allow_runtime_chart_sel"), "yes") + .toUpperCase().startsWith("Y"); + displayChartTitle = nvls(raptorProperties.getProperty("display_chart_title"), "no") + .toUpperCase().startsWith("Y"); + mergeCrosstabRowHeadings = nvls( + raptorProperties.getProperty("merge_crosstab_row_headings"), "yes") + .toUpperCase().startsWith("Y"); + displayChartByDefault = nvls( + raptorProperties.getProperty("display_chart_by_default"), "yes") + .toUpperCase().startsWith("Y"); + //System.out.println("Params Globals " + raptorProperties.getProperty("print_params_in_download")); + + printParamsInDownload = nvls( + raptorProperties.getProperty("print_params_in_download"), "no") + .toUpperCase().startsWith("Y"); + //System.out.println("printParamsInDownload " + printParamsInDownload); + + canCopyOnReadOnly = nvls(raptorProperties.getProperty("can_copy_on_read_only"), + "yes").toUpperCase().startsWith("Y"); + // chartLinesAlwaysSolid = + // nvls(raptorProperties.getProperty("chart_lines_always_solid"), + // "yes").toUpperCase().startsWith("Y"); + // chartLinesAlwaysSmooth = + // nvls(raptorProperties.getProperty("chart_lines_always_smooth"), + // "yes").toUpperCase().startsWith("Y"); + displayAllUsers = nvls( + raptorProperties.getProperty("display_all_users"), "yes") + .toUpperCase().startsWith("Y"); + requestParams = nvls( + raptorProperties.getProperty("request_get_params"), ""); + sessionParams = nvls( + raptorProperties.getProperty("session_params"), ""); + user_col_def = nvls( + raptorProperties.getProperty("user_col_def"), "no") + .toUpperCase().startsWith("Y"); + sheet_name = nvls(raptorProperties.getProperty("sheet_name"), "Raptor Reports"); + try { + flatFileLowerLimit = Integer.parseInt(raptorProperties + .getProperty("flat_file_lower_limit")); + } catch (NumberFormatException nfe) { + } + try { + flatFileUpperLimit = Integer.parseInt(raptorProperties + .getProperty("flat_file_upper_limit")); + } catch (NumberFormatException nfe) { + } + shellScriptDir = nvls(raptorProperties.getProperty("shell_script_dir"), ""); + //queryFolder = nvls(raptorProperties.getProperty("download_query_folder"), AppUtils.getTempFolderPath()+"../raptor/dwnld/query/"); + queryFolder = nvls(raptorProperties.getProperty("download_query_folder"),"../raptor/dwnld/query/"); + + + printFooterInDownload = nvls( + raptorProperties.getProperty("print_footer_in_download"), "no") + .toUpperCase().startsWith("Y"); + footerFirstLine = nvls(raptorProperties.getProperty("footer_first_line"), "AT&T Proprietary"); + footerSecondLine = nvls(raptorProperties.getProperty("footer_second_line"), "Use Pursuant to Company Instructions"); + reportsInPoPUpWindow = nvls( + raptorProperties.getProperty("report_in_popup_window"), "no") + .toUpperCase().startsWith("Y"); + poPUpInNewWindow = nvls( + raptorProperties.getProperty("popup_in_new_window"), "no") + .toUpperCase().startsWith("Y") && reportsInPoPUpWindow; + + passRequestParamInDrilldown = nvls( + raptorProperties.getProperty("pass_request_param_in_drilldown"), "yes") + .toUpperCase().startsWith("Y"); + showPDFDownloadIcon = nvls( + raptorProperties.getProperty("show_pdf_download"), "no") + .toUpperCase().startsWith("Y"); + } + + /** *********************************************************************** */ + + public static ActionMapping getRaptorActionMapping() { + if (!systemInitialized) + throw new RuntimeException("[SYSTEM ERROR] Globals not initialized"); + + return raptorActionMapping; + } // getRaptorActionMapping + + public static String getSystemType() { + if (!systemInitialized) + throw new RuntimeException("[SYSTEM ERROR] Globals not initialized"); + + return systemType; + } // getSystemType + + public static IAppUtils getAppUtils() { + if (!systemInitialized) + throw new RuntimeException("[SYSTEM ERROR] Globals not initialized"); + + return appUtils; + } // getAppUtils + + public static IDbUtils getDbUtils() { + if (!systemInitialized) + throw new RuntimeException("[SYSTEM ERROR] Globals not initialized"); + + return dbUtils; + } // getDbUtils + + public static RDbUtils getRDbUtils() { + if (!systemInitialized) + throw new RuntimeException("[SYSTEM ERROR] Globals not initialized"); + return rdbUtils; + } // getDbUtils + + /** *********************************************************************** */ + + public static int getDebugLevel() { + return debugLevel; + } + + public static int getDownloadLimit() { + return downloadLimit; + } + + public static int getCSVDownloadLimit() { + return Integer.parseInt(nvls(raptorProperties.getProperty("csv_download_limit"), new Integer(getDownloadLimit()).toString()).trim()); + } + + public static String getDownloadLimitAsText() { + return java.text.NumberFormat.getNumberInstance(java.util.Locale.US).format( + downloadLimit); + } + + public static int getDefaultPageSize() { + return defaultPageSize; + } + + public static int getFormFieldsListSize() { + return formFieldsListSize; + } + + public static int getSchedulerInterval() { + return schedulerInterval; + } + + public static String getBaseTitle() { + return baseTitle; + } + + public static String getJFreeVersion() { + return jFreeVersion; + } + + public static String getSystemName() { + return systemName; + } + + public static boolean getAllowSQLBasedReports() { + return allowSQLBasedReports; + } + + public static boolean getShowDisclaimer() { + return showDisclaimer; + } + + public static boolean getDisplayFormBeforeRun() { + return displayFormBeforeRun; + } + + public static boolean getIncludeFormWithData() { + return includeFormWithData; + } + + public static boolean getCacheChartData() { + return cacheChartData; + } + + public static boolean getCacheCurPageData() { + return cacheCurPageData; + } + + public static boolean getDeleteOnlyByOwner() { + return deleteOnlyByOwner; + } + + public static boolean getEnableReportLog() { + return enableReportLog; + } + + public static boolean getCacheUserRoles() { + return cacheUserRoles; + } + + public static boolean getMonthFormatUseLastDay() { + return monthFormatUseLastDay; + } + + public static boolean getPrintTitleInDownload() { + return printTitleInDownload; + } + + public static boolean getShowDescrAtRuntime() { + return showDescrAtRuntime; + } + + // public static boolean getSkipChartLabelsToFit() { return + // skipChartLabelsToFit; } + public static boolean getShowNonstandardCharts() { + return showNonstandardCharts; + } + + public static boolean getAllowRuntimeChartSel() { + return allowRuntimeChartSel; + } + + public static boolean getDisplayChartTitle() { + return displayChartTitle; + } + + public static boolean getMergeCrosstabRowHeadings() { + return mergeCrosstabRowHeadings; + } + + public static boolean getDisplayChartByDefault() { + return displayChartByDefault; + } + + public static boolean getPrintParamsInDownload() { + return printParamsInDownload; + } + + public static boolean getCanCopyOnReadOnly() { + return canCopyOnReadOnly; + } + + // public static boolean getChartLinesAlwaysSolid() { return + // chartLinesAlwaysSolid; } + // public static boolean getChartLinesAlwaysSmooth() { return + // chartLinesAlwaysSmooth; } + public static int getMaxDecimalsOnTotals() { + return maxDecimalsOnTotals; + } + + public static int getDefaultChartWidth() { + return defaultChartWidth; + } + + public static int getDefaultChartHeight() { + return defaultChartHeight; + } + + public static int getSkipChartLabelsLimit() { + return skipChartLabelsLimit; + } + + public static boolean getRestrictTablesByRole() { + return restrictTablesByRole; + } + + public static String getJavaTimeFormat() { + return javaTimeFormat; + } + +/* public static String getOracleTimeFormat() { + return oracleTimeFormat; + } +*/ + + public static String getRaptorVersion() { + return raptorVersion; + } + + public static boolean getDisplayAllUsers() { + return displayAllUsers; + } + + public static boolean getUserColDef() { + return user_col_def; + } + + public static String getSheetName() { + return sheet_name; + } + + public static int getFlatFileLowerLimit() { + return flatFileLowerLimit; + } + + public static int getFlatFileUpperLimit() { + return flatFileUpperLimit; + } + + + public static String getShellScriptDir() { + return shellScriptDir; + } + + public static String getQueryFolder() { + return AppUtils.getTempFolderPath()+queryFolder; + } + + public static String getRequestParams() { + return requestParams; + } + + public static String getSessionParams() { + return sessionParams; + } + + public static boolean getPrintFooterInDownload() { + return printFooterInDownload; + } + + public static String getFooterFirstLine() { + return footerFirstLine; + } + + public static String getFooterSecondLine() { + return footerSecondLine; + } + + public static boolean getReportsInPoPUpWindow() { + return reportsInPoPUpWindow; + } + + public static boolean getPoPUpInNewWindow() { + return poPUpInNewWindow; + } + + public static boolean getPassRequestParamInDrilldown() { + return passRequestParamInDrilldown; + } + + + //pdf specific properties + public static float getDataFontSize() { + float size = 10f; + + try { + size = Float.parseFloat(nvls(raptorPdfProperties.getProperty("pdf_data_font_size")).trim()); + } catch (Exception ex) { + + } + return size; + } + + public static float getDataFontSizeOffset() { + float size = 9f; + + try { + size = Float.parseFloat(nvls(raptorPdfProperties.getProperty("pdf_data_font_size_offset")).trim()); + } catch (Exception ex) { + + } + return size; + } + + public static float getFooterFontSize() { + float size = 9f; + + try { + size = Float.parseFloat(nvls(raptorPdfProperties.getProperty("pdf_footer_font_size")).trim()); + } catch (Exception ex) { + + } + return size; + } + + public static int getPageNumberPosition() { + int size = 1; + + try { + size = Integer.parseInt(nvls(raptorPdfProperties.getProperty("pdf_page_number_position")).trim()); + } catch (Exception ex) { + + } + return size; + } + + public static String getDataFontFamily() { + + return nvls(raptorPdfProperties.getProperty("pdf_data_font_family"),"Arial").trim(); + } + + public static String getFooterFontFamily() { + + return nvls(raptorPdfProperties.getProperty("pdf_footer_font_family"),"Arial").trim(); + } + + public static boolean isCoverPageNeeded() { + + return nvls(raptorPdfProperties.getProperty("display_cover_page"),"true").trim().equalsIgnoreCase("true"); + } + + public static boolean isDataAlternateColor() { + + return nvls(raptorPdfProperties.getProperty("pdf_data_alternate_color"),"true").trim().equalsIgnoreCase("true"); + } + + public static String getPDFFooter() { + + return nvls(raptorPdfProperties.getProperty("pdf_footer")); + } + + public static boolean isCreatedOwnerInfoNeeded() { + return nvls(raptorPdfProperties.getProperty("display_create_owner_info"),"true").trim().equalsIgnoreCase("true"); + } + + // Selected Form field section in the run page + public static boolean displayFormFieldInfo() { + return nvls(raptorProperties.getProperty("display_formfield_info"),"no").trim().toUpperCase().startsWith("Y"); + } + + // Customize Form field section in the run page + public static boolean customizeFormFieldInfo() { + return nvls(raptorProperties.getProperty("customize_formfield_info"),"no").trim().toUpperCase().startsWith("Y"); + } + + public static boolean displayLoginIdForDownloadedBy() { + return nvls(raptorPdfProperties.getProperty("display_loginid_for_downloaded_by"),"false").trim().equalsIgnoreCase("true"); + } + + public static boolean isDefaultOrientationPortrait() { + return nvls(raptorPdfProperties.getProperty("is_default_orientation_portrait"),"true").trim().equalsIgnoreCase("true"); + } + + public static String getSessionInfoForTheCoverPage() { + return nvls(raptorPdfProperties.getProperty("session_info")); + } + + public static String getDatePattern() { + + return nvls(raptorPdfProperties.getProperty("pdf_date_pattern"),"MM/dd/yyyy hh:mm:ss a"); + } + + public static String getTimeZone() { + + return nvls(raptorPdfProperties.getProperty("pdf_date_timezone"),"EST"); + } + + public static String getWordBeforePageNumber() { + + return nvls(raptorPdfProperties.getProperty("pdf_word_before_page_number")); + } + + public static String getWordAfterPageNumber() { + + return nvls(raptorPdfProperties.getProperty("pdf_word_after_page_number")); + } + + public static float getPDFFooterFontSize() { + float size = 7f; + + try { + size = Float.parseFloat(nvls(raptorPdfProperties.getProperty("pdf_footer_font_size")).trim()); + } catch (Exception ex) { + + } + return size; + } + + public static String getDataBackgroundAlternateHexCode() { + + return nvls(raptorPdfProperties.getProperty("pdf_data_background_alternate_hex_code"),"#FFFFFF"); + } + + public static String getDataDefaultBackgroundHexCode() { + + return nvls(raptorPdfProperties.getProperty("pdf_data_default_background_hex_code"),"#FFFFFF"); + } + + public static String getDataTableHeaderFontColor() { + + return nvls(raptorPdfProperties.getProperty("pdf_data_table_header_font_hex_code"),"#FFFFFF"); + } + + public static String getDataTableHeaderBackgroundFontColor() { + + return nvls(raptorPdfProperties.getProperty("pdf_data_table_header_background_hex_code"),"#8A9BB3"); + } + + public static boolean isFolderTreeAllowed() { + return nvls(raptorProperties.getProperty("show_folder_tree"),"yes").trim().toUpperCase().startsWith("Y"); + } + + public static boolean isFolderDefaultMinimized() { + return nvls(raptorProperties.getProperty("folder_tree_minimized"),"no").trim().toUpperCase().startsWith("Y"); + } + + public static boolean isFolderTreeAllowedOnlyForAdminUsers() { + return nvls(raptorProperties.getProperty("show_folder_tree_only_to_admin_users"),"yes").trim().toUpperCase().startsWith("Y"); + } + + public static float getCoverPageFirstColumnSize() { + float size = 0.3f; + + try { + size = Float.parseFloat(nvls(raptorPdfProperties.getProperty("pdf_coverpage_firstcolumn_size")).trim()); + } catch (Exception ex) { + + } + return size; + } + + public static boolean isImageAutoRotate() { + return nvls(raptorPdfProperties.getProperty("pdf_image_auto_rotate"),"false").trim().equalsIgnoreCase("true"); + } + + + public static boolean isShowPDFDownloadIcon() { + return showPDFDownloadIcon; + } + + + public static void setShowPDFDownloadIcon(boolean showPDFDownloadIcon) { + Globals.showPDFDownloadIcon = showPDFDownloadIcon; + } + + public static int getScheduleLimit() { + int limit = 1000; + try { + limit = Integer.parseInt(nvls(raptorProperties.getProperty("schedule_limit")).trim()); + } catch (Exception ex) { + + } + return limit; + } + +// public static String getWhereConditionForUserRole() { +// return nvls(raptorProperties.getProperty("schedule_where_condition"),"").trim(); +// } + public static String getCustomizedScheduleQueryForUsers() { + return nvls(raptorProperties.getProperty("schedule_custom_query_for_users"),"").trim(); + } + + public static String getTimeFormat() { + return nvls(raptorProperties.getProperty("time_format"),"%m/%d/%Y %h:%i:%s %p").trim(); + } + + public static String getCustomizedScheduleQueryForRoles() { + return nvls(raptorProperties.getProperty("schedule_custom_query_for_roles"),"").trim(); + } + + public static String getScheduleDatePattern() { + return nvls(raptorProperties.getProperty("schedule_date_pattern"),"MM/dd/yyyy hh:mm:ss a"); + } + + public static String getChartYearlyPattern() { + return nvls(raptorProperties.getProperty("chart_yearly_format"),"yyyy"); + } + + public static String getChartMonthlyPattern() { + return nvls(raptorProperties.getProperty("chart_monthly_format"),"MMM-yyyy"); + } + + public static String getChartDailyPattern() { + return nvls(raptorProperties.getProperty("chart_daily_format"),"MM-dd-yyyy"); + } + + public static String getChartWeeklyPattern() { + return nvls(raptorProperties.getProperty("chart_weekly_format"),"MM-dd-yyyy"); + } + + public static String getChartHourlyPattern() { + return nvls(raptorProperties.getProperty("chart_hourly_format"),"HH"); + } + + public static String getChartMinutePattern() { + return nvls(raptorProperties.getProperty("chart_minute_format"),"HH:mm"); + } + + public static String getChartSecPattern() { + return nvls(raptorProperties.getProperty("chart_second_format"),"HH:mm:ss"); + } + + public static String getChartMilliSecPattern() { + return nvls(raptorProperties.getProperty("chart_millisecond_format"),"HH:mm:ss.S"); + } + + public static String getSessionParamsForScheduling() { + return nvls(raptorProperties.getProperty("session_params_for_scheduling"),""); + } + + public static String getDisplaySessionParamInPDFEXCEL() { + return nvls(raptorProperties.getProperty("display_session_param_pdfexcel"),""); + } + + public static String getDisplayScheduleSessionParamInPDFEXCEL() { + return nvls(raptorProperties.getProperty("session_params_for_displaying_in_scheduling"),""); + } + + public static boolean isScheduleDateParamAutoIncr() { + return nvls(raptorProperties.getProperty("session_date_formfield_auto_incr"),"yes").trim().toUpperCase().startsWith("Y"); + } + + public static int getMaxCellWidthInExcel() { + int cellWidth = 40; + try { + cellWidth = Integer.parseInt(nvls(raptorProperties.getProperty("max_cell_width_in_excel")).trim()); + } catch (Exception ex) { + + } + return cellWidth; + } + + public static synchronized int getFormFieldsCount(HttpServletRequest request) + { + if(request.getSession().getAttribute( + AppConstants.SI_REPORT_RUNTIME) == null ) + { + return 0; + } + + ReportRuntime rr = (ReportRuntime) request.getSession().getAttribute( + AppConstants.SI_REPORT_RUNTIME); + + ReportFormFields rff = rr.getReportFormFields(); + + int idx = 0; + FormField ff = null; + Map fieldNameMap = new HashMap(); + int countOfFields = 0 ; + for(rff.resetNext(); rff.hasNext(); idx++) { + ff = rff.getNext(); + fieldNameMap.put(ff.getFieldName(), ff.getFieldDisplayName()); + countOfFields++; + } + return countOfFields; + + } + + public static synchronized java.util.HashMap getRequestParametersMap(HttpServletRequest request, HashMap paramsMap) { + HashMap valuesMap = new HashMap(); + if(paramsMap.size() <= 0) { + return valuesMap; + } + + ReportRuntime rr = (ReportRuntime) request.getSession().getAttribute( + AppConstants.SI_REPORT_RUNTIME); + if(rr.getReportType().equals(AppConstants.RT_DASHBOARD)) { + rr = (ReportRuntime) request.getSession().getAttribute("FirstDashReport"); + } + ReportFormFields rff = rr.getReportFormFields(); + + int idx = 0; + FormField ff = null; + + Map fieldNameMap = new HashMap(); + int countOfFields = 0 ; + + + for(rff.resetNext(); rff.hasNext(); idx++) { + ff = rff.getNext(); + fieldNameMap.put(ff.getFieldName(), ff.getFieldDisplayName()); + countOfFields++; + } + + List formParameter = new ArrayList(); + String formField = ""; + + for(int i = 0 ; i < rff.size(); i++) { + ff = ((FormField)rff.getFormField(i)); + formField = ff.getFieldName(); + + if(paramsMap.containsKey(formField) ) { + String vals = (String) paramsMap.get(formField); + StringBuffer value = new StringBuffer(""); + boolean isMultiValue = false; + isMultiValue = ff.getFieldType().equals(FormField.FFT_CHECK_BOX) + || ff.getFieldType().equals(FormField.FFT_LIST_MULTI); + boolean isTextArea = (ff.getFieldType().equals(FormField.FFT_TEXTAREA) && rr.getReportDefType() + .equals(AppConstants.RD_SQL_BASED)); + + if(isMultiValue) { + value.append("("); + } + StringTokenizer st = new StringTokenizer(vals, "|"); + if(st.countTokens()>0) { + while(st.hasMoreTokens()) { + if(isMultiValue) value.append("'"); + String token = st.nextToken(); + try { + if(token !=null && token.length() > 0) + token = java.net.URLDecoder.decode(token, "UTF-8"); + } catch (UnsupportedEncodingException ex) {} + catch (IllegalArgumentException ex1){} + catch (Exception ex2){} + value.append(token); + if(isMultiValue) value.append("'"); + if(st.hasMoreTokens()) { + value.append(","); + } + } + } else { + String valueStr = ""; + valueStr = request.getParameter(formField); + valueStr = Utils.oracleSafe(valueStr); + valueStr = "('" + Utils.replaceInString(valueStr, ",", "'|'") + "')"; + valueStr = Utils.replaceInString(valueStr, "|", ","); + valuesMap.put(fieldNameMap.get(formField), valueStr); + valueStr = ""; + } + if(isMultiValue) value.append(")"); + + valuesMap.put(fieldNameMap.get(formField), value.toString()); + if(ff.getValidationType().equals(FormField.VT_TIMESTAMP_HR) || ff.getValidationType().equals(FormField.VT_TIMESTAMP_MIN) || ff.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) { + String valueStr = ""; + if(ff.getValidationType().equals(FormField.VT_TIMESTAMP_HR)) { + valueStr = (String) paramsMap.get(formField +"_Hr"); + valuesMap.put(formField+"_Hr", valueStr); + valueStr = ""; + } else if (ff.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)) { + valueStr =(String) paramsMap.get(formField +"_Hr"); + valuesMap.put(formField+"_Hr", valueStr); + valueStr = ""; + valueStr = (String) paramsMap.get(formField +"_Min"); + valuesMap.put(formField+"_Min", valueStr); + valueStr = ""; + } else if (ff.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) { + valueStr = (String) paramsMap.get(formField +"_Hr"); + valuesMap.put(formField+"_Hr", valueStr); + valueStr = ""; + valueStr =(String) paramsMap.get(formField +"_Min"); + valuesMap.put(formField+"_Min", valueStr); + valueStr = ""; + valueStr = (String) paramsMap.get(formField +"_Sec"); + valuesMap.put(formField+"_Sec", valueStr); + valueStr = ""; + } + } + + value = new StringBuffer(""); + + } else if (paramsMap.containsKey(formField +"_auto")) { + String vals = (String) paramsMap.get(formField +"_auto"); + StringBuffer value = new StringBuffer(""); + boolean isMultiValue = false; + isMultiValue = ff.getFieldType().equals(FormField.FFT_CHECK_BOX) + || ff.getFieldType().equals(FormField.FFT_LIST_MULTI); + boolean isTextArea = (ff.getFieldType().equals(FormField.FFT_TEXTAREA) && rr.getReportDefType() + .equals(AppConstants.RD_SQL_BASED)); + + if(isMultiValue) { + value.append("("); + } + StringTokenizer st = new StringTokenizer(vals, "|"); + if(st.countTokens()>0) { + while(st.hasMoreTokens()) { + if(isMultiValue) value.append("'"); + String token = st.nextToken(); + try { + if(token !=null && token.length() > 0) + token = java.net.URLDecoder.decode(Utils.oracleSafe(token), "UTF-8"); + } catch (UnsupportedEncodingException ex) {} + catch (IllegalArgumentException ex1){} + catch (Exception ex2){} + value.append(token); + if(isMultiValue) value.append("'"); + if(st.hasMoreTokens()) { + value.append(","); + } + } + } else { + String valueStr = ""; + valueStr = request.getParameter(formField +"_auto"); + valueStr = "('" + Utils.replaceInString(valueStr, ",", "'|'") + "')"; + valueStr = Utils.replaceInString(valueStr, "|", ","); + valuesMap.put(fieldNameMap.get(formField), valueStr); + valueStr = ""; + } + if(isMultiValue) value.append(")"); + + valuesMap.put(fieldNameMap.get(formField), value.toString()); + + if(ff.getValidationType().equals(FormField.VT_TIMESTAMP_HR) || ff.getValidationType().equals(FormField.VT_TIMESTAMP_MIN) || ff.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) { + String valueStr = ""; + if(ff.getValidationType().equals(FormField.VT_TIMESTAMP_HR)) { + valueStr = (String) paramsMap.get(formField +"_Hr"); + valuesMap.put(formField+"_Hr", valueStr); + valueStr = ""; + } else if (ff.getValidationType().equals(FormField.VT_TIMESTAMP_MIN)) { + valueStr = (String) paramsMap.get(formField +"_Hr"); + valuesMap.put(formField+"_Hr", valueStr); + valueStr = ""; + valueStr = (String) paramsMap.get(formField +"_Min"); + valuesMap.put(formField+"_Min", valueStr); + valueStr = ""; + } else if (ff.getValidationType().equals(FormField.VT_TIMESTAMP_SEC)) { + valueStr = (String) paramsMap.get(formField +"_Hr"); + valuesMap.put(formField+"_Hr", valueStr); + valueStr = ""; + valueStr = (String) paramsMap.get(formField +"_Min"); + valuesMap.put(formField+"_Min", valueStr); + valueStr = ""; + valueStr = (String) paramsMap.get(formField +"_Sec"); + valuesMap.put(formField+"_Sec", valueStr); + valueStr = ""; + } + } + value = new StringBuffer(""); + + + } else + valuesMap.put(fieldNameMap.get(formField), "" ); + } + return valuesMap; + } + + public static synchronized java.util.HashMap getRequestParamtersMap(HttpServletRequest request) { + return getRequestParamtersMap(request, false); + } + + public static synchronized java.util.HashMap getRequestParamtersMap(HttpServletRequest request, boolean isFromChild) + { + HashMap valuesMap = new HashMap(); + ReportRuntime rr = null; + if(request.getSession().getAttribute( + AppConstants.SI_REPORT_RUNTIME) == null ) + { + rr = (ReportRuntime) request.getSession().getAttribute("FirstDashReport"); + if(rr==null) + return valuesMap; + } + + rr = (ReportRuntime) request.getSession().getAttribute( + AppConstants.SI_REPORT_RUNTIME); + if(rr!=null && rr.getReportType().equals(AppConstants.RT_DASHBOARD)) { + rr = (ReportRuntime) request.getSession().getAttribute("FirstDashReport"); + } + + ReportFormFields rff = rr.getReportFormFields(); + + int idx = 0; + FormField ff = null; + + Map fieldNameMap = new HashMap(); + int countOfFields = 0 ; + + + for(rff.resetNext(); rff.hasNext(); idx++) { + ff = rff.getNext(); + fieldNameMap.put(ff.getFieldName(), ff.getFieldDisplayName()); + countOfFields++; + } + if(isFromChild) { + Hashtable ht = rr.getReportParamValues(); + Set set = ht.entrySet(); + HashMap hashMap = new HashMap(); + Iterator itr = set.iterator(); + while(itr.hasNext()){ + Map.Entry entry = (Map.Entry)itr.next(); + Object key = entry.getKey(); + Object val = entry.getValue(); + if(key==null){ + key = ""; // Or whatever you want + } + if(val==null){ + val = ""; // Or whatever you want + } + hashMap.put(fieldNameMap.get((String)key),val); + } + return hashMap; + + } else { + List formParameter = new ArrayList(); + String formField = ""; + +// for(int i = 1 ; i < (countOfFields+1); i++) +// { +// formField ="ff"+i; +// +// if(request.getParameterValues(formField) != null && request.getParameterValues(formField).length > 1 ) +// { +// String[] vals = request.getParameterValues(formField); +// boolean isMultiValue = false; +// StringBuffer value = new StringBuffer(""); +// if(vals.length > 1) { +// isMultiValue = true; +// value.append("("); +// } +// for(int j = 0 ; j < vals.length; j++) +// { +// if(isMultiValue) value.append("'"); +// try { +// if(vals[j] !=null && vals[j].length() > 0) +// value.append(java.net.URLDecoder.decode(vals[j], "UTF-8"));// + ","; +// else +// value.append(vals[j]); +// } catch (UnsupportedEncodingException ex) {value.append(vals[j]);} +// catch (IllegalArgumentException ex1){value.append(vals[j]);} +// catch (Exception ex2){value.append(vals[j]);} +// +// +// if(isMultiValue) value.append("'"); +// +// if(j != vals.length -1) { +// value.append(","); +// } +// } +// if(vals.length > 1) { +// value.append(")"); +// } +// +// //value = value.substring(0 , value.length()); +// +// valuesMap.put(fieldNameMap.get(formField), value.toString()); +// value = new StringBuffer(""); +// +// } +// else if(request.getParameter(formField) != null) +// { +// String value = ""; +// value = request.getParameter(formField); +// try { +// if(value !=null && value.length() > 0) +// value = java.net.URLDecoder.decode(request.getParameter(formField), "UTF-8"); +// } catch (UnsupportedEncodingException ex) {} +// catch (IllegalArgumentException ex1){} +// catch (Exception ex2){} +// valuesMap.put(fieldNameMap.get(formField), value); +// +// }else +// { +// valuesMap.put(fieldNameMap.get(formField), "NULL" ); +// } +// } + for(int i = 0 ; i < rff.size(); i++) { + ff = ((FormField)rff.getFormField(i)); + formField = ff.getFieldName(); + boolean isMultiValue = false; + isMultiValue = ff.getFieldType().equals(FormField.FFT_CHECK_BOX) + || ff.getFieldType().equals(FormField.FFT_LIST_MULTI); + boolean isTextArea = (ff.getFieldType().equals(FormField.FFT_TEXTAREA) && rr.getReportDefType() + .equals(AppConstants.RD_SQL_BASED)); + + if(request.getParameterValues(formField) != null && isMultiValue ) { + String[] vals = request.getParameterValues(formField); + StringBuffer value = new StringBuffer(""); + if(!AppUtils.getRequestFlag(request, AppConstants.RI_RESET_ACTION)) { + + if ( isMultiValue ) { + value.append("("); + } + for(int j = 0 ; j < vals.length; j++) { + if(isMultiValue) value.append("'"); + try { + if(vals[j] !=null && vals[j].length() > 0) { + vals[j] = Utils.oracleSafe(vals[j]); + value.append(java.net.URLDecoder.decode(vals[j], "UTF-8"));// + ","; + } + else + value.append(vals[j]); + } catch (UnsupportedEncodingException ex) {value.append(vals[j]);} + catch (IllegalArgumentException ex1){value.append(vals[j]);} + catch (Exception ex2){ + value.append(vals[j]); + } + + + if(isMultiValue) value.append("'"); + + if(j != vals.length -1) { + value.append(","); + } + } + if(vals.length > 0) { + value.append(")"); + } + } + + //value = value.substring(0 , value.length()); + + valuesMap.put(fieldNameMap.get(formField), value.toString()); + value = new StringBuffer(""); + } else if(request.getParameter(formField) != null) { + if(isTextArea) { + String value = ""; + value = request.getParameter(formField); +/* try { + value = java.net.URLDecoder.decode(value, "UTF-8"); + } catch (UnsupportedEncodingException ex) {} + catch (IllegalArgumentException ex1){} + catch (Exception ex2){} +*/ + value = Utils.oracleSafe(value); + value = "('" + Utils.replaceInString(value, ",", "'|'") + "')"; + value = Utils.replaceInString(value, "|", ","); + valuesMap.put(fieldNameMap.get(formField), value); + value = ""; + } else { + String value = ""; + if(!AppUtils.getRequestFlag(request, AppConstants.RI_RESET_ACTION)) + value = request.getParameter(formField); + /*try { + value = java.net.URLDecoder.decode(value, "UTF-8"); + } catch (UnsupportedEncodingException ex) {} + catch (IllegalArgumentException ex1){} + catch (Exception ex2){} +*/ + valuesMap.put(fieldNameMap.get(formField), Utils.oracleSafe(value)); + } + + } else { + valuesMap.put(fieldNameMap.get(formField), "" ); + } + + } + + return valuesMap; + } + } + + //new method added to get the help message for schedule tab + public static String getScheduleHelpMessage() { + return nvls(raptorProperties.getProperty("schedule_help_text"),"").trim(); + } + + //new method added to get the help message for schedule tab + public static String getUseLoginIdInSchedYN() { + return nvls(raptorProperties.getProperty("use_loginid_in_schedYN"),"N").trim(); + } + + //new method to check if map is allowed or not + public static String getMapAllowedYN() { + return nvls(raptorProperties.getProperty("map_allowed"),"").trim(); + } + + //new method added to get gmap key + public static String getGmapKey() { + return nvls(raptorProperties.getProperty("gmap_key"),"").trim(); + } + +// new method added to get gmap + public static String getProjectFolder() { + return nvls(raptorProperties.getProperty("PROJECT-FOLDER"),"").trim(); + } + + + //new method added to get gmap + public static String getMarketShapefileFolder() { + return nvls(raptorProperties.getProperty("MARKET-SHAPEFILE-FOLDER"),"").trim(); + } + + //new method added to get gmap + public static String getTileSize() { + return nvls(raptorProperties.getProperty("TILE-SIZE"),"").trim(); + } + + // new method added to get gmap + public static String getOutputFolder() { + return nvls(raptorProperties.getProperty("OUTPUT-FOLDER"),"").trim(); + } + + //getting server details + public static boolean isWeblogicServer() { + return nvls(raptorProperties.getProperty("application_server"),"tomcat").trim().toUpperCase().startsWith("WEBLOGIC"); + } + + public static String getTempFolderURL() { + return nvls(AppUtils.getTempFolderURL(),"").trim(); + } + + public static int getMaxDrillDownLevel() { + int drillDownLevel = 1; + try { + drillDownLevel = Integer.parseInt(nvls(raptorProperties.getProperty("max_drilldown_level")).trim()); + } catch (Exception ex) { + + } + return drillDownLevel; + } + + public static int getMemoryThreshold() { + int threshold = Integer.parseInt(nvls(raptorProperties.getProperty("memory_threshold_percentage"),"0").trim()); + if(threshold <= 0) threshold = 0; + return threshold; + } + + public static boolean showParamsInAllDashboardReports() { + return nvls(raptorProperties.getProperty("show_params_in_all_dashboard_reports"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean isAdminRoleEquivalenttoSuperRole() { + return nvls(raptorProperties.getProperty("admin_role_equiv_to_super_role"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean showLoadingMsgDuringFormFieldChain() { + return nvls(raptorProperties.getProperty("show_loading_during_formfield_chain"),"Y").trim().toUpperCase().startsWith("Y"); + } + + public static boolean showPrintIcon() { + return nvls(raptorProperties.getProperty("show_print_icon"),"Y").trim().toUpperCase().startsWith("Y"); + } + + public static boolean IsGlobalNoWrap() { + return nvls(raptorProperties.getProperty("globally_nowrap"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static String getCalendarOutputDateFormat() { + return nvls(raptorProperties.getProperty("calendar_output_date_format"),"MM/dd/yyyy"); + } + + public static String getUserDefinedMessageForMemoryLimitReached() { + return nvls(raptorProperties.getProperty("user_defined_message_memory_limit"),"Please note: Due to limited computing resource at this time,"); + } + + public static String getAdhocUserRoldId() { + return nvls(raptorProperties.getProperty("adhoc_user_roleId"),""); + } + + public static String getAdhocReportSequence() { + return nvls(raptorProperties.getProperty("adhoc_report_sequence"),""); + } + + public static boolean hideToolTipsGlobally() { + return nvls(raptorProperties.getProperty("hide_tooltips_in_chart"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean showScheduleIconBeforeRun() { + return nvls(raptorProperties.getProperty("show_schedule_icon_before_run"),"Y").trim().toUpperCase().startsWith("Y"); + } + + public static boolean hideRaptorFooter() { + return nvls(raptorProperties.getProperty("hide_raptor_footer"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean getPrintParamsInCSVDownload() { + return nvls(raptorProperties.getProperty("print_params_in_csv_download"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static String getLogVariablesInSession() { + return nvls(raptorProperties.getProperty("log_variable_in_session"), ""); + } + + public static boolean hideTitleInDashboard() { + return nvls(raptorProperties.getProperty("notitle_in_dashboard"), "N").trim().toUpperCase().startsWith("Y"); + } + + public static String getEncryptedSMTPServer() { + return nvls(raptorProperties.getProperty("secure_smtp_server"), ""); + } + + public static boolean generateSchedReportsInFileSystem() { + return nvls(raptorProperties.getProperty("generate_store_sched_reports"), "N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean showExcel2007DownloadIcon() { + return nvls(raptorProperties.getProperty("show_excel_2007_download"), "N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean printExcelInLandscapeMode() { + return nvls(raptorProperties.getProperty("print_excel_in_landscape"), "").trim().toUpperCase().startsWith("Y"); + } + + public static String getAppDefinedMessageForSendingSchedAsAttachment() { + return nvls(raptorProperties.getProperty("app_defined_message_schedule_attachment"),"Send as Attachment"); + } + + public static String getReportEmptyMessage() { + return nvls(raptorProperties.getProperty("no_rows_found"),"Your Search didn't yield any results."); + } + + public static boolean showAnimatedChartOption() { + return nvls(raptorProperties.getProperty("show_animated_chart_option"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean showAnimatedChartOnly() { + return nvls(raptorProperties.getProperty("show_animated_chart_only"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean adjustContentBasedOnHeight() { + return nvls(raptorProperties.getProperty("adjust_content_based_on_height"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean disclaimerPositionedTopInCSVExcel() { + return nvls(raptorProperties.getProperty("disclaimer_positioned_top_in_csvexcel"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static String customizedSubmitButtonText() { + return nvls(raptorProperties.getProperty("custom_submit_button_text"),"submit"); + } + + public static String customizedResetButtonText() { + return nvls(raptorProperties.getProperty("custom_reset_button_text"),"reset"); + } + public static boolean customizeFormFieldLayout() { + return nvls(raptorProperties.getProperty("customize_formfield_layout"),"N").trim().toUpperCase().startsWith("Y"); + } + public static String getRaptorTheme() { + return nvls(raptorProperties.getProperty("raptor_theme"),"default"); + } + + public static String getFormfieldAlignment() { + return nvls(raptorProperties.getProperty("formfield_alignment"),"left"); + } + + public static boolean displayExcelOptionInDashboard() { + return nvls(raptorProperties.getProperty("display_excel_option_in_dashboard"),"N").trim().toUpperCase().startsWith("Y"); + } + + public static boolean displayRuntimeOptionsAsDefault() { + return nvls(raptorProperties.getProperty("display_runtime_options_as_default"),"Y").trim().toUpperCase().startsWith("Y"); + } + + public static boolean displayHiddenFormfieldinExcel() { + return nvls(raptorProperties.getProperty("display_hidden_field_in_excel"),"N").trim().toUpperCase().startsWith("Y"); + } + + //ReportLoader.java + public static String getLoadCustomReportXml(){ + return nvls(sqlProperty.getProperty("load.custom.report.xml")); + } + + public static String getDBUpdateReportXml(){ + return nvls(sqlProperty.getProperty("db.update.report.xml")); + } + + public static String getDBUpdateReportXmlMySql(){ + return nvls(sqlProperty.getProperty("db.update.report.xml.mysql")); + } + + public static String getDBUpdateReportXmlMySqlSelect(){ + return nvls(sqlProperty.getProperty("db.update.report.xml.mysql.select")); + } + + public static String getUpdateCustomReportRec(){ + return nvls(sqlProperty.getProperty("update.custom.report.rec")); + } + + public static String getIsReportAlreadyScheduled(){ + return nvls(sqlProperty.getProperty("is.report.already.scheduled")); + } + + public static String getCreateCustomReportRec(){ + return nvls(sqlProperty.getProperty("create.custom.report.rec")); + } + + public static String getTheUserReportNames(){ + return nvls(sqlProperty.getProperty("get.user.report.names")); + } + + public static String getTheReportOwnerId(){ + return nvls(sqlProperty.getProperty("get.report.owner.id")); + } + + public static String getReportSecurity(){ + return nvls(sqlProperty.getProperty("report.security.create")); + } + + public static String getDeleteReportRecordLog(){ + return nvls(sqlProperty.getProperty("delete.report.record.log")); + } + + public static String getDeleteReportRecordUsers(){ + return nvls(sqlProperty.getProperty("delete.report.record.users")); + } + + public static String getDeleteReportRecordSchedule(){ + return nvls(sqlProperty.getProperty("delete.report.record.schedule")); + } + + public static String getDeleteReportRecordAccess(){ + return nvls(sqlProperty.getProperty("delete.report.record.access")); + } + + public static String getDeleteReportRecordEmail(){ + return nvls(sqlProperty.getProperty("delete.report.record.email")); + } + + public static String getDeleteReportRecordFavorite(){ + return nvls(sqlProperty.getProperty("delete.report.record.favorite")); + } + + public static String getDeleteReportRecordReport(){ + return nvls(sqlProperty.getProperty("delete.report.record.report")); + } + + public static String getLoadQuickLinks(){ + return nvls(sqlProperty.getProperty("load.quick.links")); + } + + public static String getLoadFolderReports(){ + return nvls(sqlProperty.getProperty("load.folder.reports")); + } + + public static String getLoadFolderReportsUser(){ + return nvls(sqlProperty.getProperty("load.folder.reports.user")); + } + + public static String getLoadFolderReportsPublicSql(){ + return nvls(sqlProperty.getProperty("load.folder.reports.publicsql")); + } + + public static String getLoadQuickDownloadLinks(){ + return nvls(sqlProperty.getProperty("load.quick.download.links")); + } + + public static String getLoadReportsToSchedule(){ + return nvls(sqlProperty.getProperty("load.reports.to.schedule")); + } + + public static String getLoadReportsToAddInDashboard(){ + return nvls(sqlProperty.getProperty("load.reports.to.add.in.dashboard")); + } + + public static String getLoadMyRecentLinks(){ + return nvls(sqlProperty.getProperty("load.my.recent.links")); + } + + public static String getCreateReportLogEntry(){ + return nvls(sqlProperty.getProperty("create.report.log.entry")); + } + + public static String getCreateReportLogEntryExecTime(){ + return nvls(sqlProperty.getProperty("create.report.log.entry.exec.time")); + } + + public static String getClearReportLogEntries(){ + return nvls(sqlProperty.getProperty("clear.report.log.entries")); + } + + public static String getLoadReportLogEntries(){ + return nvls(sqlProperty.getProperty("load.report.log.entries")); + } + + public static String getDoesUserCanScheduleReport(){ + return nvls(sqlProperty.getProperty("does.user.can.schedule.report")); + } + + public static String getDoesUserCanSchedule(){ + return nvls(sqlProperty.getProperty("does.user.can.schedule")); + } + + public static String getTheSystemDateTime(){ + return nvls(sqlProperty.getProperty("get.system.date.time")); + } + + public static String getTheNextDayDateTime(){ + return nvls(sqlProperty.getProperty("get.next.day.date.time")); + } + + public static String getTheNextFifteenMinDateTime(){ + return nvls(sqlProperty.getProperty("get.next.fifteen.minutes.date.time")); + } + + public static String getTheNextThirtyMinDateTime(){ + return nvls(sqlProperty.getProperty("get.next.thirty.minutes.date.time")); + } + + public static String getTheTemplateFile(){ + return nvls(sqlProperty.getProperty("get.template.file")); + } + + public static String getLoadPdfImgLookup(){ + return nvls(sqlProperty.getProperty("load.pdf.img.lookup")); + } + + public static String getLoadActionImgLookup(){ + return nvls(sqlProperty.getProperty("load.action.img.lookup")); + } + + //ActionHandler.java + + public static String getReportValuesMapDefA(){ + return nvls(sqlProperty.getProperty("report.values.map.def.a")); + } + public static String getReportValuesMapDefB(){ + return nvls(sqlProperty.getProperty("report.values.map.def.b")); + } + public static String getReportValuesMapDefC(){ + return nvls(sqlProperty.getProperty("report.values.map.def.c")); + } + public static String getReportValuesMapDefD(){ + return nvls(sqlProperty.getProperty("report.values.map.def.d")); + } + + public static String getTestSchedCondPopup(){ + return nvls(sqlProperty.getProperty("test.sched.cond.popup")); + } + + public static String getDownloadAllEmailSent(){ + return nvls(sqlProperty.getProperty("download.all.email.sent")); + } + + public static String getDownloadAllGenKey(){ + return nvls(sqlProperty.getProperty("download.all.gen.key")); + } + + public static String getDownloadAllRetrieve(){ + return nvls(sqlProperty.getProperty("download.all.retrieve")); + } + + public static String getDownloadAllInsert(){ + return nvls(sqlProperty.getProperty("download.all.insert")); + } + + //ReportWrapper.java + + public static String getReportWrapperFormat(){ + return nvls(sqlProperty.getProperty("report.wrapper.format")); + } + + public static String getGenerateSubsetSql(){ + return nvls(sqlProperty.getProperty("generate.subset.sql")); + } + + public static String getReportSqlForFormfield(){ + return nvls(sqlProperty.getProperty("formfield.id.name.sql")); + } + + public static String getReportSqlForFormfieldPrefix(){ + return nvls(sqlProperty.getProperty("formfield.id.name.sql.prefix")); + } + + public static String getReportSqlForFormfieldSuffix(){ + return nvls(sqlProperty.getProperty("formfield.id.name.sql.suffix")); + } + + public static String getReportSqlOnlyFirstPart(){ + return nvls(sqlProperty.getProperty("report.sql.only.first.part")); + } + + public static String getReportSqlOnlySecondPartA(){ + return nvls(sqlProperty.getProperty("report.sql.only.second.part.a")); + } + + public static String getReportSqlOnlySecondPartB(){ + return nvls(sqlProperty.getProperty("report.sql.only.second.part.b")); + } + + public static String getReportSqlOnlySecondPartBNoOrderBy(){ + return nvls(sqlProperty.getProperty("report.sql.only.second.part.b.noorderby")); + } + + public static String getGenerateSqlVisualSelect(){ + return nvls(sqlProperty.getProperty("generate.sql.visual.select")); + } + + public static String getGenerateSqlVisualCount(){ + return nvls(sqlProperty.getProperty("generate.sql.visual.count")); + } + + public static String getGenerateSqlVisualDual(){ + return nvls(sqlProperty.getProperty("generate.sql.visual.select")); + } + + //ReportRuntime.java + + public static String getLoadCrosstabReportData(){ + return nvls(sqlProperty.getProperty("load.crosstab.report.data")); + } + + //ReportRunHandler.java + + public static String getGenerateSqlHandler(){ + return nvls(sqlProperty.getProperty("generate.sql.handler")); + } + + public static String getGenerateSqlSelect(){ + return nvls(sqlProperty.getProperty("generate.sql.select")); + } + + public static String getRemoteDbSchemaSql() { + return nvls(sqlProperty.getProperty("load.remoteDB.schema")); + } + + public static String getRemoteDbSchemaSqlWithWhereClause() { + return nvls(sqlProperty.getProperty("load.remoteDB.schema.where")); + } + + //ReportSchedule.java + + public static String getLoadScheduleData(){ + return nvls(sqlProperty.getProperty("load.schedule.data")); + } + + public static String getLoadScheduleGetId(){ + return nvls(sqlProperty.getProperty("load.schedule.getid")); + } + + public static String getLoadScheduleUsers(){ + return nvls(sqlProperty.getProperty("load.schedule.users")); + } + + public static String getNewScheduleData(){ + return nvls(sqlProperty.getProperty("new.schedule.data")); + } + + public static String getNewReportData(){ + return nvls(sqlProperty.getProperty("new.report.data")); + } + + public static String getExecuteUpdate(){ + return nvls(sqlProperty.getProperty("execute.update")); + } + + public static String getExecuteUpdateUsers(){ + return nvls(sqlProperty.getProperty("execute.update.users")); + } + + public static String getExecuteUpdateRoles(){ + return nvls(sqlProperty.getProperty("execute.update.roles")); + } + + public static String getExecuteUpdateActivity(){ + return nvls(sqlProperty.getProperty("execute.update.activity")); + } + + public static String getDeleteScheduleData(){ + return nvls(sqlProperty.getProperty("delete.schedule.data")); + } + + public static String getDeleteScheduleDataUsers(){ + return nvls(sqlProperty.getProperty("delete.schedule.data.users")); + } + + public static String getDeleteScheduleDataId(){ + return nvls(sqlProperty.getProperty("delete.schedule.data.id")); + } + + public static String getLoadCondSql(){ + return nvls(sqlProperty.getProperty("load.cond.sql")); + } + + public static String getLoadCondSqlSelect(){ + return nvls(sqlProperty.getProperty("load.cond.sql.select")); + } + + public static String getPersistCondSqlUpdate(){ + return nvls(sqlProperty.getProperty("persist.cond.sql.update")); + } + + public static String getPersistCondSqlLarge(){ + return nvls(sqlProperty.getProperty("persist.cond.sql.large")); + } + + public static String getPersistCondSqlSet(){ + return nvls(sqlProperty.getProperty("persist.cond.sql.set")); + } + + //DataCache.java + + public static String getTheDataViewActions(){ + return nvls(sqlProperty.getProperty("get.data.view.actions")); + } + + public static String getThePublicReportIdNames(){ + return nvls(sqlProperty.getProperty("get.public.report.id.names")); + } + + public static String getThePrivateAccessibleNamesA(){ + return nvls(sqlProperty.getProperty("get.private.accessible.names.a")); + } + public static String getThePrivateAccessibleNamesIf(){ + return nvls(sqlProperty.getProperty("get.private.accessible.names.if")); + } + public static String getThePrivateAccessibleNamesB(){ + return nvls(sqlProperty.getProperty("get.private.accessible.names.b")); + } + + public static String getTheGroupAccessibleNamesA(){ + return nvls(sqlProperty.getProperty("get.group.accessible.names.a")); + } + + public static String getTheGroupAccessibleNamesB(){ + return nvls(sqlProperty.getProperty("get.group.accessible.names.b")); + } + + public static String getTheReportTableSourcesA(){ + return nvls(sqlProperty.getProperty("get.report.table.sources.a")); + } + + public static String getTheReportTableSourcesWhere(){ + return nvls(sqlProperty.getProperty("get.report.table.sources.where")); + } + + public static String getTheReportTableSourcesIf(){ + return nvls(sqlProperty.getProperty("get.report.table.sources.if")); + } + + public static String getTheReportTableSourcesElse(){ + return nvls(sqlProperty.getProperty("get.report.table.sources.else")); + } + + public static String grabTheReportTableA(){ + return nvls(sqlProperty.getProperty("grab.report.table.a")); + } + + public static String grabTheReportTableIf(){ + return nvls(sqlProperty.getProperty("grab.report.table.if")); + } + + public static String grabTheReportTableElse(){ + return nvls(sqlProperty.getProperty("grab.report.table.else")); + } + + public static String grabTheReportTableB(){ + return nvls(sqlProperty.getProperty("grab.report.table.b")); + } + + public static String grabTheReportTableC(){ + return nvls(sqlProperty.getProperty("grab.report.table.c")); + } + + public static String getTheReportTableCrJoin(){ + return nvls(sqlProperty.getProperty("get.report.table.crjoin")); + } + + public static String getTheReportTableJoins(){ + return nvls(sqlProperty.getProperty("get.report.table.joins")); + } + + public static String getGenerateReportTableCol(){ + return nvls(sqlProperty.getProperty("generate.report.table.col")); + } + + + public static String getGenerateDbUserSqlA(){ + return nvls(sqlProperty.getProperty("generate.db.user.sql.a")); + } + + public static String getGenerateDbUserSqlIf(){ + return nvls(sqlProperty.getProperty("generate.db.user.sql.if")); + } + + public static String getGenerateDbUserSqlElse(){ + return nvls(sqlProperty.getProperty("generate.db.user.sql.else")); + } + + public static String getGenerateDbUserSqlB(){ + return nvls(sqlProperty.getProperty("generate.db.user.sql.b")); + } + + public static String getGenerateDbUserSqlC(){ + return nvls(sqlProperty.getProperty("generate.db.user.sql.c")); + } + + public static String getGenerateDbUserSqlD(){ + return nvls(sqlProperty.getProperty("generate.db.user.sql.d")); + } + + //SearchHandler.java + + public static String getLoadReportSearchResult(){ + return nvls(sqlProperty.getProperty("load.report.search.result")); + } + + public static String getLoadReportSearchRepIdSql(){ + return nvls(sqlProperty.getProperty("load.report.search.rep_id_sql")); + } + + public static String getLoadReportSearchInstr(){ + return nvls(sqlProperty.getProperty("load.report.search.instr")); + } + + public static String getLoadReportSearchResultUser(){ + return nvls(sqlProperty.getProperty("load.report.search.result.user")); + } + + public static String getLoadReportSearchResultPublic(){ + return nvls(sqlProperty.getProperty("load.report.search.result.public")); + } + + public static String getLoadReportSearchResultFav(){ + return nvls(sqlProperty.getProperty("load.report.search.result.fav")); + } + + public static String getLoadReportSearchResultSort(){ + return nvls(sqlProperty.getProperty("load.report.search.result.sort")); + } + + public static String getLoadFolderReportResult(){ + return nvls(sqlProperty.getProperty("load.folder.report.result")); + } + + public static String getLoadFolderReportResultSort(){ + return nvls(sqlProperty.getProperty("load.folder.report..result.sort")); + } + + //WizardProcessor.java + + public static String getProcessFilterAddEdit(){ + return nvls(sqlProperty.getProperty("process.filter.add.edit")); + } + + //ReportDefinition.java + + public static String getPersistReportAdhoc(){ + return nvls(sqlProperty.getProperty("persist.report.adhoc")); + } + + //Globals.java + public static String getInitializeRoles(){ + return nvls(sqlProperty.getProperty("initialize.roles")); + } + + public static String getInitializeVersion(){ + return nvls(sqlProperty.getProperty("initialize.version")); + } + + public static String getDBType(){ + return nvls(raptorProperties.getProperty("db_type"), "oracle"); + } + + public static boolean isPostgreSQL(){ + return getDBType().equals("postgresql"); + } + public static boolean isMySQL(){ + return getDBType().equals("mysql"); + } + public static boolean isOracle(){ + return getDBType().equals("oracle"); + } + + //scheduler + public static String getAvailableSchedules(){ + return nvls(sqlProperty.getProperty("scheduler.available.schedules")); + } + + public static String getCurrentDateString(){ + return nvls(sqlProperty.getProperty("current.date.string")); + } + + public static String getSchedulerUserEmails(){ + return nvls(sqlProperty.getProperty("scheduler.user.emails")); + } + + public static String getSqlConvertToRaw(){ + return nvls(sqlProperty.getProperty("convert.to.raw")); + } + + public static Properties getRaptorPdfProperties() { + return raptorPdfProperties; + } + + public static void setRaptorPdfProperties(Properties raptorPdfProperties) { + Globals.raptorPdfProperties = raptorPdfProperties; + } + + public static Properties getRaptorProperties() { + return raptorProperties; + } + + public static void setRaptorProperties(Properties raptorProperties) { + Globals.raptorProperties = raptorProperties; + } + + public static Properties getSqlProperty() { + return sqlProperty; + } + + public static void setSqlProperty(Properties sqlProperty) { + Globals.sqlProperty = sqlProperty; + } + + public static String getSequenceNextVal() { + return nvls(sqlProperty.getProperty("seq.next.val")); + } + + public static String getRandomString() { + return nvls(sqlProperty.getProperty("seq.next.val")); + } + + public static String getReportUserAccess(){ + return nvls(sqlProperty.getProperty("report.user.access")); + } + + public static String getAddUserAccess(){ + return nvls(sqlProperty.getProperty("add.user.access")); + } + + public static String getUpdateUserAccess(){ + return nvls(sqlProperty.getProperty("update.user.access")); + } + + public static String getRemoveUserAccess(){ + return nvls(sqlProperty.getProperty("remove.user.access")); + } + + public static String getAddRoleAccess(){ + return nvls(sqlProperty.getProperty("add.role.access")); + } + + public static String getUpdateRoleAccess(){ + return nvls(sqlProperty.getProperty("update.role.access")); + } + + public static String getRemoveRoleAccess(){ + return nvls(sqlProperty.getProperty("remove.role.access")); + } + + public static boolean isSystemInitialized() { + return systemInitialized; + } + +} // Globals |