analytics/webcontent/qs/cmd.js

/****************************************************************
** Licensed Materials - Property of IBM
**
** BI and PM: qs
**
** (C) Copyright IBM Corp. 2001, 2015
**
** US Government Users Restricted Rights - Use, duplication or 
** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
*****************************************************************/

// Copyright (C) 2008 Cognos ULC, an IBM Company. All Rights Reserved.
// Cognos and the Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated) in the United States and/or other countries.  IBM and the IBM logo are trademarks of International Business Machines Corporation in the United States, or other countries, or both.  Other company, product, or service names may be trademarks or service marks of others.




var __preview_win = null;
var addColumnId = 0;
var RSParameters;

function sendCmd(sCommandString, xslref, resetRows, bLeaveDialog)
{
    
	var bIsRerun = false;
	
	cfgSet("FirstRunQS", false);
	
	
	var cmdStr = sCommandString;
	if (typeof recordCommand == "function")
	{
		recordCommand(cmdStr);
	}

	if (resetRows)
	{
		cmdStr = "PF;" + cmdStr;	
	}
	
	if (! cfgGet("isRunAsPreview"))
	{
		
		var sAmountOfData = cfgGet("amountOfData");
		cmdStr += generateCmdToSwitchRunMode(sAmountOfData);
		
		
		cfgRemove("amountOfData");
	}

	if (xslref.length <= 0)
	{
		xslref = 'qs.xsl';
	}

	
	cfgSet("OLD_qs_spec", cfgGet("conversation_qs_spec"));

	var oReportManager = goApplicationManager.getReportManager();
	var oQSRequest = oReportManager.createRequest("runSpecification");
	oReportManager.setRequestDefaultOptions(oQSRequest);	
	
	oQSRequest.addOption("ui.action", "edit");
	
	var c = cfgGet("conversation_primaryRequest");
	if (c)
	{
		oQSRequest.addOption("ui.conversation", c);
	}

	
	var sUiObject = getUiObjectString();
	if (sUiObject && sUiObject.length)
	{
		oQSRequest.addOption("ui.object", sUiObject);
	}
	
	oQSRequest.addOption("ui.command", cmdStr);
	oQSRequest.addOption("run.xslURL", xslref);
	if (cmdStr.charAt(0) == "P" && cmdStr.charAt(1) == "U")
	{
		
		oQSRequest.removeOption("parameters");
		if (goApplicationManager)
		{
			var promptRunOption = goApplicationManager.get("run.prompt");
			if (promptRunOption)
			{
				oQSRequest.addOption("run.prompt", promptRunOption);
			}
		}
	}
	else if(cmdStr.indexOf("ON:") > -1 && cmdStr.indexOf("full") > -1)
	{
		
		
		
		
		
		
		bIsRerun = true;
		oQSRequest.addOption("rerun", "true");

		var executionPrompt = cfgGet("executionPrompt");
		var promptFlag = cfgGet("promptFlag");
		if ( executionPrompt != null && executionPrompt != "" )
		{
			oQSRequest.addOption("run.prompt", executionPrompt);
		}
		else if (promptFlag != null && promptFlag != "")
		{
			oQSRequest.addOption("run.prompt", promptFlag);
		}
		else
		{
			oQSRequest.addOption("run.prompt", "true");
		}		
	}
	else
	{
		oQSRequest.addOption("run.prompt", "false");
	}

	var promptValuesArray = getPromptPageParameterValues();
	if (promptValuesArray!=null && typeof promptValuesArray == "object")
	{
		for (var i in promptValuesArray)
		{
			var promptValues = promptValuesArray[i];
			oQSRequest.addOption(promptValues[0], promptValues[1]);
		}
	}

	var oAllParams = goApplicationManager.getReportManager().getParameterManager().getAllParametersAsObject();
	if (oAllParams.promptPageParameters !== null)
	{
		oReportManager.setRequestDefaultOptionsForCV(true, true, "meta,exec", oQSRequest);
	}
	else if (bIsRerun)
	{
		oReportManager.setRequestDefaultOptionsForCV(true, true, "any", oQSRequest);
	}
	else
	{
		oReportManager.setRequestDefaultOptionsForCV(true, false, "any", oQSRequest);
	}
	
	
	
	
	if(sCommandString.indexOf("ON:") != 0)
	{
		updateReportHasChanged(true);
	}

	
	if (cfgGet("specification.editSpecification"))
	{
		oQSRequest.addOption("specification.editSpecification", cfgGet("specification.editSpecification"));
	}

	oReportManager.asyncSubmit(bLeaveDialog, oQSRequest);
};

function generateCmdToSwitchRunMode(sPreviousLimitData)
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var cmdStr = "";
	var currentLimitData = getPreviewType();

	
	
	
	var sNewDataMode = "";
	if (sPreviousLimitData && sPreviousLimitData.length && sPreviousLimitData != currentLimitData)
	{
		sNewDataMode = sPreviousLimitData;
	}
	else if (oMQMgr.hasLimitDataChanged() && currentLimitData.length)
	{
		sNewDataMode = currentLimitData;
	}
	
	if (sNewDataMode.length)
	{
		cmdStr += ";" + createCommand("O", "N", new Array(sNewDataMode));
	}
	
	return cmdStr;
};

function escapeParam(param) { return escapeSpecialChar(param); }

function escapeSpecialChar(s1) {
	var s2 = "";

	if (s1 != null)
	{
		s2 = s1.toString();

		s2 = s2.replace(/%/g, "%25");
		s2 = s2.replace(/;/g, "%3B");
		s2 = s2.replace(/\"/g, "%22");
		s2 = s2.replace(/\\/g, "%5C");
		s2 = s2.replace(/,/g, "%2C");
		s2 = s2.replace(/\n/g, "%0A");
		s2 = s2.replace(/ /g, "%20");
	}

	return s2;
};

function generateNcCmd(colId, newColName)
{
	return createCommand("M", "N", new Array(escapeParam(goApplicationManager.getMiniQueryManager().getColumnId(colId)), escapeParam(newColName)));
};

function generateAcCmd(before_col_id, id, col, label, datatype, usage, regularAgg, semiAgg, promptType, displayType, sortOnRef, promptCascadeOnRef, promptFilterItemRef, groupType, bIsHierarchy, levelOrdinal, hun, metaType, currency, promptUseItemRef, promptDisplayItemRef)
{
	
	

	if (before_col_id != "-1")
		before_col_id = validateBeforeColId(before_col_id);
	if (sortOnRef == "")
		sortOnRef = "none";
	if (promptCascadeOnRef == "")
		promptCascadeOnRef = "none";
	if (promptFilterItemRef == "")
		promptFilterItemRef = "none";
	if (groupType == "")
		groupType = "none";
	if (currency == "")
		currency = "none";
	if (promptUseItemRef == "")
		promptUseItemRef = "none";
	if (promptDisplayItemRef == "")
		promptDisplayItemRef = "none";		
	if (promptType == "")
		promptType = 0;
		
	
	regularAgg = getRegularAggregateFromModelValue(regularAgg);		
	var cmd = createCommand("M", "A", new Array(escapeParam(before_col_id), escapeParam(id), escapeParam(col), escapeParam(label), datatype, usage, regularAgg, semiAgg, promptType, displayType, escapeParam(sortOnRef), escapeParam(promptCascadeOnRef), escapeParam(promptFilterItemRef), escapeParam(groupType), escapeParam(bIsHierarchy), escapeParam(levelOrdinal), escapeParam(hun), escapeParam(metaType), escapeParam(currency), escapeParam(promptUseItemRef), escapeParam(promptDisplayItemRef)));
	return cmd;
};

function validateBeforeColId(before_col_id)
{
	if (before_col_id == "")
		before_col_id = (cfgSize("SelColumns")== 1) ? goApplicationManager.getMiniQueryManager().getColumnId(cfgGetAt("SelColumns", 0)) : "-1";
	return before_col_id;
};

function generateAddCalcColCmd(before_col_id, id, colExpression, calculatedExpression, label, calcBy, calcOp, calcBase, calcNumDecs, calculationType, usageType, regularAgg, semiAgg, promptType, displayType, detailAgg, sortOnRef, qIDArray, groupType, currency, promptUseItemRef, promptDisplayItemRef)
{
	
	var params = new Array();
	params[0] = escapeParam(validateBeforeColId(before_col_id));
	params[1] = escapeParam(id);
	params[2] = escapeParam(colExpression);
	params[3] = escapeParam(label);
	if (calculationType != -1)
		params[4] = calculationType;
	else
		params[4] = "21";
	if (usageType != -1 && usageType != "")
	{
		params[5] = usageType;
	}
	
	
	else if (usageType == "" && calculationType == "0") 
	{
		params[5] = "0";
	}
	else
	{
		params[5] = "3";
	}
	params[6] = getRegularAggregateFromModelValue(regularAgg);
	if (semiAgg != "")
	{
		params[7] = escapeParam(semiAgg);
	}
	else
	{
		params[7] = "0";
	}
	if (promptType != -1)
		params[8] = promptType;
	else
		params[8] = "0";
	params[9] = displayType;
	if (sortOnRef == "")
		sortOnRef = "none";
	if (groupType == "")
		groupType = "none";
	if (currency == "")
		currency = "none";
	if (promptUseItemRef == "" || typeof promptUseItemRef == "undefined")
		promptUseItemRef = "none";
	if (promptDisplayItemRef == "" || typeof promptDisplayItemRef == "undefined")
 		promptDisplayItemRef = "none";
	params[10] = escapeParam(sortOnRef);
	params[11] = escapeParam(groupType);
	params[12] = escapeParam(calcBy);
	params[13] = escapeParam(calcOp);
	params[14] = escapeParam(calcBase);
	params[15] = calcNumDecs;
	params[16] = escapeParam(calculatedExpression);
	if (detailAgg != -1)
		params[17] = detailAgg;
	else
		params[17] = "calculated";
	params[18] = escapeParam(currency);
	params[19] = escapeParam(promptUseItemRef);
	params[20] = escapeParam(promptDisplayItemRef);
	if (typeof qIDArray != "undefined")
	{
		for (var i = 0; i < qIDArray.length; i++)
			params[params.length] = escapeParam(qIDArray[i]);
	}
	return createCommand("M", "X", params)
};

function endac()
{
	var mc = cfgGet("MultiColumnAddCommand");
	if (mc && mc.length > 0)
		sendCmd(mc, "", true);

	cfgRemove("MultiColumnAddCommand");
};






function cc(columnType, before_col_id, colExpression, label, datatype, usage, regularAgg, semiAgg, promptType, displayType, sortOnRef, promptCascadeOnRef, promptFilterItemRef, groupType, bIsHierarchy, levelOrdinal, hun, metaType, currency, promptUseItemRef, promptDisplayItemRef)
{
	var mc = cfgGet("MultiColumnAddCommand");
	if (mc==null||(mc && mc.length == 0))
		mc="";
	else
		mc += ";";

	if (columnType == "OD")
	{
		
		
		mc += generateAddFilterCmd("name", label, escapeParam(colExpression));
	}
	else
	{
		var id = "XX" + addColumnId++;
		if (columnType == "MX")
		{
			var checkedRegularAgg = regularAgg;
			if (usage == 3)
				checkedRegularAgg = (checkedRegularAgg <= 1 ? "automatic" : regularAgg);
			else
				checkedRegularAgg = (checkedRegularAgg <= 1 ? "none" : regularAgg);
			mc += generateAddCalcColCmd(before_col_id, id, colExpression, colExpression, label, "none", "model", "none", "none", datatype, usage, checkedRegularAgg, semiAgg, promptType, displayType, (regularAgg <= 1 ? "automatic" : -1), "none", new Array(), groupType, currency, promptUseItemRef, promptDisplayItemRef);
		}
		else
			mc += generateAcCmd(before_col_id, id, colExpression, label, datatype, usage, regularAgg, semiAgg, promptType, displayType, sortOnRef, promptCascadeOnRef, promptFilterItemRef, groupType, bIsHierarchy, levelOrdinal, hun, metaType, currency, promptUseItemRef, promptDisplayItemRef);
	}
	cfgSet("MultiColumnAddCommand", mc);
};

function getPreviewType()
{
	var oMQManager = goApplicationManager.getMiniQueryManager();
	var sLimitData = "full"
	if (typeof oMQManager === "object")
	{
		sLimitData = oMQManager.getLimitData();
	}
	return sLimitData;
};

function cancelErrorPage() {
	goBack();
};

function cancelPromptPage() {
	goBack();
};

function goBack() {
	var rf = getReportFrame();
	if (rf && rf.history) {
		if (historyLength!=null && historyLength + 2 > rf.history.length) {
			if (historyLength < 1)
				document.location.replace(goApplicationManager.getReportFrame().oCVQS.getWebContentRoot() + "/common/blank.html");
			else {
				rf.history.go(-2);
			}
		}
		else rf.history.back();
	}
};

function generateReplaceExpressionCmd(colExpression, calculatedExpression, calcOp)
{
	return createCommand("M","R", new Array(escapeParam(goApplicationManager.getMiniQueryManager().getColumnId(cfgGetAt("SelColumns", 0))),escapeParam(colExpression),escapeParam(calculatedExpression),escapeParam(calcOp)));
};

function refreshDialog()
{
	if (typeof cfgGet("LAST_DIALOG") == "undefined")
	{
		hideDialogFrame();
		return;
	}
	switch(cfgGet("LAST_DIALOG"))
	{
		case "filterComplex":
			goApplicationManager.getFeatureManager().launchFeature('FilterComplex');
			break;
		case "filter":
			goApplicationManager.getFeatureManager().launchFeature('FilterSimple');
			break;
		case "sort":
			goApplicationManager.getFeatureManager().launchFeature('Sort');
			break;
		case "summarize":
			goApplicationManager.getFeatureManager().launchFeature('Summarize', new Array('summarize', false));
			break;
		case "rename":
			goApplicationManager.getFeatureManager().launchFeature('Rename');
			break;
		case "newcalculation":
			goApplicationManager.getFeatureManager().launchFeature('Calculate');
			break;
		case "customizeValues":
			goApplicationManager.getFeatureManager().launchFeature('CustomGroups');
			break;
		case "refreshnewcalculation":
			refreshNewCalculation();
			break;
		case "format":
			goApplicationManager.getFeatureManager().launchFeature("Format", new Array("default"));
			break;
		case "condStyles":
			goApplicationManager.getFeatureManager().launchFeature("ConditionalStyle");
			break;
		case "textStyle":
			goApplicationManager.getFeatureManager().launchFeature("StyleText");
			break;
		case "borderStyle":
		case "chart":
		case "pageSize":
		case "saveas":
			break;
		default:
			if (cfgSize("SelColumns") > 0)
			{
				hideDialogFrame();
			}
			return;
	}
	if (typeof getDialogFrame().removeExecute == "function")
	{
		getDialogFrame().removeExecute();
	}
};

function upgradeModelExecute()
{
	var bIsNewReport = cfgGet("NewReport");
	if (bIsNewReport === null)
	{
		bIsNewReport = false;
	}
	
	
	var sSpecPath = cfgGet("xxSpec");
	if (! sSpecPath || sSpecPath === "")
	{
		sSpecPath = cfgGet("upgradeDialogObjPath");
	}

	
	
	if (! bIsNewReport)
	{
		
		cfgSet("conversation_qs_obj", sSpecPath);
		cfgRemove("conversation_qs_spec");		
	}
	else
	{
		
		cfgRemove("conversation_qs_obj");
	}
	
	cfgSet("persistOptions", "false");
	
	var sCmd = "";
	if (typeof oLimitedDataPreference === "object" && oLimitedDataPreference.getProperty("forceNoDataOnNextRun") === true)
	{
		sCmd = "ON:none;";
	}
	
	sCmd += createCommand ("P","U", new Array(escapeParam(cfgGet("upgradeDialogModel"))));
	sendCmd(sCmd,"",false);
};

function upgradeModelCancel()
{
	if (gsUiBackURL == null || gsUiBackURL == "")
	{
		window.close();
	}
	else
	{
		document.location.replace(gsUiBackURL);
	}
};

function checkResponse(response, currentDocument, currentAction, callbackFunction)
{
	if (response == null || currentDocument == null || currentAction == null || callbackFunction == null)
	{
		return false;
	}
	var htmlMatch = response.match(/<HTML>/i);
	
	if(htmlMatch === null || htmlMatch === "undefined")
	{
		
		htmlMatch = response.match(/<!DOCTYPE/i);
	}
	
	if (htmlMatch && (htmlMatch.length >= 1))
	{
		currentDocument.write(response);
		currentDocument.close();
		return false;
	}

	if (typeof response == "string" && response.match( /^FAULT;timeout/i ) )
	{
		cfgSet("LAST_ACTION", currentAction);
		cfgSet("LAST_FUNCTION", callbackFunction);
		pptFaultHandler();
		return false;
	}
	return true;
};

function pptFaultHandler( aCAMoptions )
{
	var theURL = goApplicationManager.get("scriptEngine") + "?b_action=xts.run&m=portal/close.xts";
	if ( aCAMoptions && aCAMoptions.length )
	{
		for (var idxOption = 0; idxOption < aCAMoptions.length; idxOption++)
		{
			theURL += "&" + encodeURIComponent(aCAMoptions[idxOption].name) + "=" + encodeURIComponent(aCAMoptions[idxOption].value);
		}
	}
	theURL += "&h_CAM_action=logonAs";
	var expWnd = window.open(theURL,"LoginWnd",'scrollbars=yes,resizable=yes,width=540,height=360');
};


function pdsCallback(prmtObject)
{
	if (prmtObject)
	{
		var parameters = prmtObject.parameters ? prmtObject.parameters : null;
		var state = prmtObject.state ? prmtObject.state : null;
		var conversation = null; 
		var clientContext = prmtObject.clientContext ? prmtObject.clientContext : null;
		var tracking = prmtObject.tracking ? prmtObject.tracking : null;

		getConfigFrame().promptResponse(parameters, state, conversation, clientContext, tracking);
	}
};


function ccModalCallBack(command, data)
{
	
	
	if (cfgGet("LAST_DIALOG") == "queryOpen")
	{
		goApplicationManager.getFeatureManager().launchFeature("OpenReport", new Array("ccModalCallback", command, data));
	}
	
	
	
	else if (typeof command != "undefined" && command == "ok")
	{
		if (cfgGet("LAST_SAVE_DIALOG") == "save")
		{
			goApplicationManager.getFeatureManager().launchFeature("Save", new Array(cfgGet("LAST_SAVE_DIALOG")));
		}
		else if (cfgGet("LAST_SAVE_DIALOG") == "saveas")
		{
			goApplicationManager.getFeatureManager().launchFeature("SaveAs", new Array(cfgGet("ACTION_AFTER_SAVE")));
		}
		else
		{
			switch(cfgGet("LAST_ACTION"))
			{
				case "functionList":
					setTimeout("fetchMetadataFunctionList('" + cfgGet("CURRENT_REQUEST") + "');", 1);
					break;
				case "metadataTree":
					setTimeout("doMetadataRequest('" + cfgGet("CURRENT_REQUEST") + "');", 1);
					break;
				case "logon":
					
					if (cfgGet("gbIsAnonymous") === true)
					{
						bannerHome(cfgGet("gsCognosHome"));
					}
					else
					{
						
						
						var iTraversableNamespaces = cfgGet("giTraversableLogonNamespaces");
						if (iTraversableNamespaces && iTraversableNamespaces > 0)
						{
							iTraversableNamespaces += 1;
						}
						cfgSet("giTraversableLogonNamespaces", iTraversableNamespaces);

						
						var iAvailableNamespaces = cfgGet("giAvailableLogonNamespaces");
						setTimeout("initLogonMenu(" + iAvailableNamespaces + "," + iTraversableNamespaces + ", false);", 1);
					}
					break;
				case "logoff":
					
					break;
				default:
					if (typeof cfgGet("LAST_FUNCTION") == "function")
					{
						var sFunctionName = cfgGet("LAST_FUNCTION").toString().match(/( \w+)/)[0];
						setTimeout(cfgGet("LAST_FUNCTION"), 1);
					}
					break;
			}
		}
	}
	cfgRemove("LAST_FUNCTION");
	cfgRemove("LAST_ACTION");
	cfgRemove("LAST_SAVE_DIALOG");
	cfgRemove("ACTION_AFTER_SAVE");
	cfgRemove("LAST_DIALOG");
};

function addCalcColumn(before_col_id, colExpression, calculatedExpression, label, calcBy, calcOp, calcBase, calcNumDecs, calculationType, usageType, regularAgg, promptType, detailAgg, qIDArray)
{
	
	var id = "XX" + addColumnId++;
	var cmd = generateAddCalcColCmd(before_col_id, id, colExpression, calculatedExpression, label, calcBy, calcOp, calcBase, calcNumDecs, calculationType, usageType, regularAgg, "0", promptType, "4", detailAgg, "none", qIDArray, "none", "none", "none", "none");
	sendCmd(cmd, "", true);
	hideDialogFrame();
};

function cancelRequest()
{
	var urlParams = "b_action=cognosViewer&ui.action=cancel&cv.responseFormat=successfulRequest";
	if (cfgGet("m_tracking"))
	{
		urlParams += "&m_tracking=" + encodeURIComponent(cfgGet("m_tracking"));
	}
	urlParams += "&conversationid=" + cfgGet("conversation_primaryRequestId");
	if (cafContextId != "")
	{
		urlParams += "&ui.cafcontextid=" + cafContextId;
	}

	
	cfgRemove("m_tracking");
	
	sendDispatcherRequest(urlParams, null);	
	hideDialogFrame();
	
	if (typeof oLimitedDataPreference === "object" && oLimitedDataPreference.getProperty("noDataAfterCancel") === false)
	{
		cfgSet("qsBrowserBackPerformedOnCancel", true);
		cfgSet("conversation_qs_spec", cfgGet("OLD_qs_spec"));
		cfgSet("do_not_set_NR", true);

	    var repMgr = goApplicationManager.getReportManager();
	    if (repMgr !== null)
	    {
		    repMgr.getUndoManager().executeSpec(repMgr.get("sMiniQueryMarkup"));
	    }
	}
	else
	{
		goApplicationManager.getFeatureManager().launchFeature('Run', new Array('none'));
	}
};

function constructGETRequestParamsString(urlParams)
{
	var newUrlParams = "";
	if (typeof CAFXSSEncode == "function")
		newUrlParams = CAFXSSEncode(urlParams);
	else
		newUrlParams = urlParams;
	if (cafContextId != "")
	{
		if (newUrlParams != "")
			return newUrlParams + "&ui.cafcontextid=" + cafContextId;
		else
			return "ui.cafcontextid=" + cafContextId;
	}
	else
		return newUrlParams;
};


function wrapCmdWithCreateColumnBasedonMetadataItem(sCmd, sId)
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	if (sId && oMQMgr.getColumnById(sId) === MINI_QUERY_NO_COLUMN_FOUND)
	{
		var oData = cfgGet("_META_" + sId);
		if (oData && oData["columnId"] && oData["addCmd"])
		{
			
			
			
			var sId_escaped = escapeParam(oData["columnId"]);
			sCmd = [
				oData["addCmd"],
				sCmd,
				createCommand("M", "D", [sId_escaped] )
			].join(";");
			
			cfgRemove("_META_" + sId);                        
		}
	}
	return sCmd;
};


function getRegularAggregateFromModelValue(sRegularAgg)
{
	
	if (sRegularAgg == -1 || sRegularAgg === "-1")
	{
		sRegularAgg = "calculated";	
	}
	else if (sRegularAgg == 13 
		|| sRegularAgg === "13" 
		|| sRegularAgg === "countDistinct")
	{
		if (checkCalcFunctionAgainstDB("DATA_ITEM_AGGREGATE_COUNT_DISTINCT"))
		{
			sRegularAgg = "countDistinct";
		}
		else
		{
			
			
			sRegularAgg = "automatic";			
		}
	}
	return sRegularAgg;
};


function getUiObjectString()
{
	var sReturn = "";
	
	var sSpec = cfgGet("conversation_qs_spec");
	if (sSpec)
	{
		
		var sSearchPath = cfgGet("SearchPath");
		if (sSearchPath != null && sSearchPath != "")
		{
			sReturn = sSearchPath;
		}
	}
	else
	{
		
		sObjectPath = cfgGet("conversation_qs_obj");
		if (sObjectPath && sObjectPath.length)
		{
			sReturn = sObjectPath;
		}
		else
		{
			
			
			if (gsUiObject && gsUiObject.length)
			{
				sReturn = decodeURIComponent(gsUiObject);
			}
		}
	}

	return sReturn;
};