/*-
* ================================================================================
* 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 RAPTOR (Rapid Application Programming Tool for OLAP Reporting)
* 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);
- getRequestparametersMap method iterates form field collections.
*
* 27-Jul-2009 : Version 8.4 (Sundar); - Added property "admin_role_equiv_to_super_role" to specify Admin User equivalent to Super User.
*
* 14-Jul-2009 : Version 8.4 (Sundar); - Added property to showing/hiding params displayed in dashboard reports.
*
*
*/
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