analytics/webcontent/qs/selectColumn.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.




function mainMouseUp(event)
{
	if (typeof enableResize == "function")
		enableResize(false);
	if (typeof getConfigFrame().enableResizeDialogFrame == "function")
		getConfigFrame().enableResizeDialogFrame(false);
};

function mainMouseMove(event)
{
	if (typeof resizeMenuPane == "function")
		resizeMenuPane(event, false);
	if (typeof getConfigFrame().resizeDialogFrame == "function")
	{
		var top = 0;
		if (document.all && event.srcElement.ownerDocument != getConfigFrame().document)
		{
			var elem = getConfigFrame().document.getElementById("dialogFrame")
			while (elem != null)
			{
				if (elem.tagName != "TR" && typeof elem.offsetTop == "number")
					top += elem.offsetTop;
				elem = elem.offsetParent;
			}
		}
		getConfigFrame().resizeDialogFrame(event,event.clientY+top);
	}
};

function removeFromIntArray(iEl, a)
{
	
	var i;
	var remove = false;
	for (i = 0; i < a.length; i++)
	{
		if (a[i] == iEl)
			remove = true;
		if (remove && i + 1 < a.length)
			a[i] = a[i + 1];
	}
	if (remove)
		a.length--;
};

function keydown(e)
{
	if (e.cancelBubble === true && e.returnValue === false) return;

	if (goApplicationManager.getReportManager().get("currentMode") == "prompting")
	{
		return;
	}

	if (e.keyCode == 46)
	{ 
		goApplicationManager.getFeatureManager().launchFeature('Delete');
		cancelEvent(e);
	}
	else if (e.keyCode == 90 && e.ctrlKey == true && e.shiftKey == false) 
	{
		goApplicationManager.getFeatureManager().launchFeature('Undo');
	}
	else if ((e.keyCode == 90 && e.ctrlKey == true && e.shiftKey == true) || (e.keyCode == 89 && e.ctrlKey == true)) 
	{
		goApplicationManager.getFeatureManager().launchFeature('Redo');
	}
	else if (e.ctrlKey == true)
	{
		if (e.keyCode == 88) 
		{
			goApplicationManager.getFeatureManager().launchFeature('Cut');
			cancelEvent(e);
		}
		else if (e.keyCode == 86) 
		{
			goApplicationManager.getFeatureManager().launchFeature('Paste');
			cancelEvent(e);
		}
		else if (e.keyCode == 78) 
		{
			goApplicationManager.getFeatureManager().launchFeature('NewReport');
			cancelEvent(e);
		}
		else if (e.keyCode == 83) 
		{
			goApplicationManager.getFeatureManager().launchFeature('Save');
			cancelEvent(e);
		}
		else if (e.keyCode == 65) 
		{
			goApplicationManager.getFeatureManager().launchFeature('SaveAs');
			if (document.all)
			{
				e.returnValue = false;
				e.cancelBubble = true;
			}
			else
			{
				
				
				
				e.preventDefault();
				window.getSelection().removeAllRanges();
			}
		}
		
	}
	
	else if(e.keyCode == 13 || e.keyCode == 39 || e.keyCode == 37 || e.keyCode == 38 || e.keyCode == 40 || e.keyCode == 32) 
	{
			var selection = goApplicationManager.getSelectionController();
			if(selection.m_oCognosViewer != null)
			{
				selection.m_oCognosViewer.onKeyDown(e);
				cancelEvent(e);
			}
	}
};

function cancelEvent(e) {
	if (document.all)
	{
	    e.cancelBubble = true;
		e.returnValue = false;
	}
	else
	{
		e.preventDefault();
	}
};


function selectionIsNumeric(bUseOldType)
{
	var cf = (typeof getConfigFrame == "function" ? getConfigFrame() : this);
	var oMQMgr = cf.goApplicationManager.getMiniQueryManager();
	var numSelCols = cf.cfgSize("SelColumns");
	if (numSelCols == 0)
		return false;
	var bNumericColumn = false;

	for (var i = 0; i < numSelCols; i++)
	{
		if (oMQMgr.isReportExpression(cf.cfgGetAt("SelColumns", i)))
			continue;
		if (bUseOldType)
		{
			var bIsFakeMeasure = oMQMgr.isFakeMeasure(cf.cfgGetAt("SelColumns", i));
			if ((bIsFakeMeasure && !isOldTypeNumeric(cf.cfgGetAt("SelColumns", i))) ||
				(!bIsFakeMeasure && !oMQMgr.isNumeric(cf.cfgGetAt("SelColumns", i))))
				return false;
		}
		else
		{
			if (!oMQMgr.isNumeric(cf.cfgGetAt("SelColumns", i)) && ! oMQMgr.hasNumericDetailAggregate(cf.cfgGetAt("SelColumns", i)))
				return false;
		}
		bNumericColumn = true;
	}
	return bNumericColumn;
};


function selectionIsMeasure()
{
	var cf = (typeof getConfigFrame == "function" ? getConfigFrame() : this);
	var numSelCols = cf.cfgSize("SelColumns");
	if (numSelCols == 0)
	{
		return false;
	}
	
	var bMeasureColumn = false;
	var oMQMgr = cf.goApplicationManager.getMiniQueryManager();
	for (var i = 0; i < numSelCols; i++)
	{
		var oColumn = cf.cfgGetAt("SelColumns", i);
		if (oMQMgr.isReportExpression(oColumn))
		{
			continue;
		}

		if (! oMQMgr.isMeasure(oColumn))
		{
			return false;
		}
		
		bMeasureColumn = true;
	}
	return bMeasureColumn;
};



function selectionIsInterval(bUseOldType)
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var numSelCols = cfgSize("SelColumns");
	if (numSelCols == 0)
		return false;
	var bIntervalColumn = false;

	for (var i = 0; i < numSelCols; i++)
	{
		if (oMQMgr.isReportExpression(cfgGetAt("SelColumns", i)))
			continue;
		if (bUseOldType)
		{
			var bIsFakeMeasure = oMQMgr.isFakeMeasure(cfgGetAt("SelColumns", i));
			if ((bIsFakeMeasure && !isOldTypeInterval(cfgGetAt("SelColumns", i))) ||
				(!bIsFakeMeasure && !isInterval(cfgGetAt("SelColumns", i))))
				return false;
		}
		else
		{
			if (!isInterval(cfgGetAt("SelColumns", i)))
				return false;
		}
		bIntervalColumn = true;
	}
	return bIntervalColumn;
};

function selectionIsDateType(bUseOldType)
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var numSelCols = cfgSize("SelColumns");
	if (numSelCols == 0)
	{
		return false;
	}
	var bDateTypeColumn = false;

	for (var i = 0; i < numSelCols; i++)
	{
		if (oMQMgr.isReportExpression(cfgGetAt("SelColumns", i)))
		{
			continue;
		}
		if (bUseOldType)
		{
			var bIsFakeMeasure = oMQMgr.isFakeMeasure(cfgGetAt("SelColumns", i));
			if ((bIsFakeMeasure && !isOldTypeDateTime(cfgGetAt("SelColumns", i))) ||
				(!bIsFakeMeasure && !isDateTime(cfgGetAt("SelColumns", i))))
			{
				return false;
			}
		}
		else
		{
			if (!isDateTime(cfgGetAt("SelColumns", i)))
			{
				return false;
			}
		}

		bDateTypeColumn = true;
	}
	return bDateTypeColumn;
};

function addSelectionToCfgVariables(colId, useTag)
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var indexOfColId;
	if (typeof useTag != "undefined" && useTag == true)
	{
		indexOfColId = oMQMgr.getColumnIndexByAttribute("tag", colId);
	}
	else
	{
		indexOfColId = oMQMgr.getColumnIndexByAttribute("id", colId);
	}
	if (indexOfColId >= 0)
	{
		var colSelectedAlready = false;
		for (var i = 0; i < cfgSize("SelColumns"); i++)
		{
			if (cfgGetAt("SelColumns", i) == indexOfColId)
			{
				colSelectedAlready = true;
				break;
			}
		}
		if (!colSelectedAlready)
		{
			cfgSetAt("SelColumns", cfgSize("SelColumns"), indexOfColId);
		}
	}
};

function removeSelectionFromCfgVariables(tagRef)
{
	var oMQMgr = goApplicationManager.getMiniQueryManager();
	var indexOfColId = oMQMgr.getColumnIndexByAttribute("tag", tagRef);
	if (indexOfColId >= 0)
	{
		var selCols = cfgGet("SelColumns");
		cfgRemove("SelColumns");
		for (var i = 0; i < selCols.length; i++)
		{
			if (selCols[i] != indexOfColId)
			{
				cfgSetAt("SelColumns", cfgSize("SelColumns"), selCols[i]);
			}
		}
	}
};

function removeAllSelectionsFromCfgVariables()
{
	cfgRemove("SelColumns");
};

function dlgGenericSelectionMessage(multiSelect)
{
	dlgReset();
	dlgGlobalReset();
	dlgSetParm("m", "/" + qs_dir + "/actionErrorMessage.xts");
	dlgSetParm("xxMultiSelect", multiSelect);
	dlgSubmit();
};

function changeSelectionToColumnTitle(multiSelect, selectionObject)
{
	var rf = goApplicationManager.getReportFrame();
	var selection = goApplicationManager.getSelectionController().getSelections();

	var allTds = rf.document.getElementsByTagName("td");

	goApplicationManager.getSelectionController().clearSelectedObjects();

	var lastSelection = -1;
	if (!multiSelect)
	{




		lastSelection = selectionObject.getTag();

	}

	for (var i = 0; i < allTds.length; i++)
	{
		var tag = allTds[i].getAttribute("tag");
		if (tag != null && tag != "" && (allTds[i].getAttribute("type") == "columnTitle" || allTds[i].getAttribute("type") == "section"))
		{
			var oSelCtrlr = goApplicationManager.getSelectionController();
			if (multiSelect)
			{
				for (var j = 0; j < selection.length; j++)
				{
					if (tag == selection[j].getTag())
					{
						if (oSelCtrlr !== null)
						{
							oSelCtrlr.selectNode(allTds[i]);
						}
					}
				}
			}
			else
			{
				if (tag == lastSelection)
				{
					if (oSelCtrlr !== null)
					{
						oSelCtrlr.selectNode(allTds[i]);
					}
					break;
				}
			}
		}
	}

	rf.window.focus();
};

function checkForValidSelection(multiSelectAllowed,summaryAllowed)
{
	if (typeof summaryAllowed == "undefined" || summaryAllowed == null)
		summaryAllowed = false;

	var reCrosstabLevel = /\b(ol|il)\b/;

	var cellRef;
	var rf = goApplicationManager.getReportFrame();
	var selection = null;
	var oSelCtrlr = goApplicationManager.getSelectionController();
	if (oSelCtrlr !== null)
	{
		selection = oSelCtrlr.getSelections();
		if (oSelCtrlr.selectionsAreAllSameType() == -1)
		{
			return false;
		}
	}
	if (selection === null)
	{
		return false;
	}

	if (multiSelectAllowed)
	{
		if (!summaryAllowed)
		{
			for (var i = 0; i < selection.length; i++)
			{
				cellRef = selection[i].getCellRef();
				if (selection[i].getLayoutType() == "summary" || (cellRef != null && reCrosstabLevel.test(cellRef.className)))
				{
					dlgGenericSelectionMessage(true);
					return false;
				}
			}
		}
	}
	else
	{
		var bSelNotOnSameCol = false;
		if (oSelCtrlr !== null)
		{
			bSelNotOnSameCol = !oSelCtrlr.selectionsAreAllOnSameColumn();
		}
		if (selection.length > 1 && bSelNotOnSameCol)
		{
			dlgGenericSelectionMessage(false);
			return false;
		}
		if (!summaryAllowed)
		{
			for (var i = 0; i < selection.length; i++)
			{
				cellRef = selection[i].getCellRef();
				if (selection[i].getLayoutType() == "summary"  || (cellRef != null && reCrosstabLevel.test(cellRef.className)))
				{
					if (selection.length > 1)
					{
						dlgGenericSelectionMessage(true);
					}
					else
					{
						dlgGenericSelectionMessage(false);
					}
					return false;
				}
			}
		}
	}
	return true;
};

function addColumnsForReselection()
{
	var rf = goApplicationManager.getReportFrame();

	rf.addReportElementsForReselection();

	var selection = goApplicationManager.getSelectionController().getSelections();
	cfgRemove("reselectColumns");
	for (var i = 0; i < selection.length; i++)
	{
		var cellIdx = -1;
		var rowIdx = -1;
		var cellRef = selection[i].getCellRef();
		if (typeof cellRef == "object" && cellRef != null)
		{
			cellIdx = cellRef.cellIndex;
			rowIdx = cellRef.parentNode.rowIndex;
		}
		var dispValue = "";
		if (selection[i].getDisplayValues().length > 0)
		{
			dispValue = selection[i].getDisplayValues()[0];
		}
		cfgSetAt("reselectColumns", cfgSize("reselectColumns"), new Array(selection[i].getTag(), cellIdx, rowIdx, dispValue, selection[i].getLayoutType()));
	}
};

function reselectColumns()
{
	var rf = goApplicationManager.getReportFrame();
	var selectionOF = null;
	var oSelCtrlr = goApplicationManager.getSelectionController();
	if (oSelCtrlr !== null)
	{
		selectionOF = oSelCtrlr.getSelectionObjectFactory();
	}
	if (selectionOF === null)
	{
		return;
	}
	var allTables = rf.document.getElementsByTagName("table");
	var reselectionsPrimary = new Array();
	var reselectionsSecondary = new Array();

	var previousSelections = new Array();
	for (var i = 0; i < cfgSize("reselectColumns"); i++)
	{
		previousSelections[previousSelections.length] = cfgGetAt("reselectColumns", i);
	}

	for (var j = 0; j < previousSelections.length; j++)
	{
		var rowVal = previousSelections[j][2];
		var colVal = previousSelections[j][1];
		var foundNode = false;
		if (rowVal > -1 && colVal > -1)
		{
			for (var i = 0; i < allTables.length; i++)
			{
				try
				{
					if (allTables[i] && allTables[i].rows && allTables[i].rows[rowVal] && allTables[i].rows[rowVal].cells)
					{
						var cell = allTables[i].rows[rowVal].cells[colVal];
						if (cell && cell.hasChildNodes())
						{
							for (var k = 0; k < cell.childNodes.length; k++)
							{
								
								if (cell.childNodes[k].firstChild.data == previousSelections[j][3])
								{
									reselectionsPrimary[reselectionsPrimary.length] = cell;
									foundNode = true;
									break;
								}
							}
						}
					}
				}
				catch(e)
				{
				}
			}
		}
		if (foundNode == false)
		{
			reselectionsSecondary[reselectionsSecondary.length] = j;
		}
	}
	var focusSet = false;
	var oSelCtrlr = goApplicationManager.getSelectionController();
	for (var i = 0; i < reselectionsPrimary.length; i++)
	{
		if (oSelCtrlr !== null)
		{
			oSelCtrlr.selectNode(reselectionsPrimary[i]);
		}
		if (focusSet == false)
		{
			focusSet = reselectionsPrimary[i];
		}
	}
	for (var i = 0; i < reselectionsSecondary.length; i++)
	{
		var SelObj = selectionOF.getSecondarySelectionObject(previousSelections[reselectionsSecondary[i]][0], previousSelections[reselectionsSecondary[i]][4]);
		if (SelObj != null)
		{
			goApplicationManager.getSelectionController().addSelectionObject(SelObj);
			addSelectionToCfgVariables(SelObj.getTag(), true);
			if (focusSet == false)
			{
				focusSet = rf.document.getElementsByTagName("table")[0];
			}
		}
	}
	cfgRemove("reselectColumns");
	if (focusSet != false && typeof focusSet.focus == "function")
	{
		focusSet.focus();
	}
};

function getColRefIdFromSelectionObject(oSelObj)
{
	oSelObj.fetchContextIds();
	var aContextIds = oSelObj.getSelectedContextIds();

	var sColRefId = "";
	if (aContextIds.length > 0 && aContextIds[0].length > 0)
	{
		var oSelController = goApplicationManager.getSelectionController();
		sColRefId = oSelController.getRefDataItem(aContextIds[0][0]);
	}
	return sColRefId;
};

function getColSpecialPropertiesFromSelectionObject(oSelObj)
{
	oSelObj.fetchContextIds();
	var aContextIds = oSelObj.getSelectedContextIds();

	var oColSpecialProperties = {};
	var sLevelId = "";
	var sIntersectId = "";
	var sForcedType = "";

	if (aContextIds.length === 0 || oSelObj === null)
	{
		return oColSpecialProperties;
	}
	else
	{
		var sColRefId = getColRefIdFromSelectionObject(oSelObj);
		if (sColRefId === "")
		{
			return oColSpecialProperties;
		}

		var oMQMgr = goApplicationManager.getMiniQueryManager();
		if (oMQMgr === null)
		{
			return oColSpecialProperties;
		}
		var oSelController = goApplicationManager.getSelectionController();
		var colIdx = 0; 

		var sColumnName = sColRefId;
		var oCellRef = oSelObj.getCellRef();
		if (typeof oCellRef == "object" && oCellRef !== null)
		{
			var sTag = oCellRef.getAttribute("tag");
			if (sTag !== null && sTag !== "")
			{
				for (colIdx = 0; colIdx < oMQMgr.getAllColumns().length; colIdx++)
				{
					if (sTag == oMQMgr.getTag(colIdx))
					{
						sColumnName = oMQMgr.getColumnId(colIdx);
						break;
					}
				}
			}
		}

		var bIsCrosstab = oMQMgr.hasPivottedColumns();
		var sCellRef = oSelObj.getCellRef();
		var iLastPivot = -1;

		
		
		if (bIsCrosstab === false && typeof sCellRef.getAttribute("qsc") == "string" && (sCellRef.getAttribute("qsc").indexOf("is") == 0 || sCellRef.getAttribute("qsc").indexOf("ss") == 0) && aContextIds[0].length > 1 && oSelController.getRefDataItem(aContextIds[0][1]))
		{
			sLevelId = oSelController.getRefDataItem(aContextIds[0][1]);
		}
		else if (bIsCrosstab === true)
		{
			
			for (colIdx = oMQMgr.getAllColumns().length; colIdx >= 0; colIdx--)
			{
				if (oMQMgr.isPivoted(colIdx))
				{
					iLastPivot = colIdx;
					break;
				}
			}

			
			
			
			
			if (typeof aContextIds[1] != "undefined" && aContextIds[1].length > 0 && typeof aContextIds[2] != "undefined" && aContextIds[2].length > 0)
			{
				var bIsPivot = false;
				var bIsInnerMeasure = false;

				

				var sLevelContext = "";
				var sIntersectContext = "";

				if (aContextIds[1].length > 1)
				{
					sLevelContext = aContextIds[1][1];
				}
				if (aContextIds[2].length > 1)
				{
					sIntersectContext = aContextIds[2][1];
				}

				
				
				
				if (oMQMgr.getColumnId(sColumnName) !== MINI_QUERY_NO_COLUMN_FOUND)
				{
					if (oMQMgr.isMeasure(sColumnName) && typeof sCellRef.getAttribute("qsc") == "string" && (sCellRef.getAttribute("qsc").indexOf("mv") == 0 || sCellRef.getAttribute("qsc").indexOf("ov") == 0))
					{
						bIsInnerMeasure = true;
					}
					if (oMQMgr.isPivoted(sColumnName))
					{
						bIsPivot = true;
						
						

						if (aContextIds[2].length > 1)
						{
							sLevelContext = aContextIds[2][1];
						}
						else
						{
							sLevelContext = "";
						}
						if (aContextIds[1].length > 1)
						{
							sIntersectContext = aContextIds[1][1];
						}
						else
						{
							sIntersectContext = "";
						}
					}
				}

				
				if (!bIsInnerMeasure)
				{
					if (sLevelContext && oSelController.getRefDataItem(sLevelContext))
					{
						sLevelId = oSelController.getRefDataItem(sLevelContext);
					}
					if (sIntersectContext && oSelController.getRefDataItem(sIntersectContext))
					{
						sIntersectId = oSelController.getRefDataItem(sIntersectContext);
						
						
						if (sIntersectId == oMQMgr.getColumnId(iLastPivot) || bIsPivot)
						{
							sIntersectId = "";
						}
						else if (sIntersectId != "")
						{
							
							var bFoundQuery = false;

							if (oMQMgr.getColumnId(sIntersectId) !== MINI_QUERY_NO_COLUMN_FOUND)
							{
								bFoundQuery = true;
							}
							
							
							
							if (!bFoundQuery)
							{
								sIntersectId = "";
							}
							
							
							
							
							
							else if (sLevelId === "")
							{
								sColumnName = sColRefId;
								sLevelId = sIntersectId;
								sIntersectId = "";
								sForcedType = "ColumnGroupFooterValueStyle";
							}
						}
					}
				}
			}
			if (sCellRef.getAttribute("qsc") && sColRefId)
			{
				
				if (sCellRef.getAttribute("qsc").indexOf("iv") == 0 || sCellRef.getAttribute("qsc").indexOf("ov") == 0)
				{
					var sMeasureId = "";
					
					if (sColumnName != sColRefId)
					{
						sMeasureId = sColRefId;
					}

					
					if (sLevelId == sMeasureId)
					{
						sLevelId = "";
					}
					if (sIntersectId == sMeasureId)
					{
						sIntersectId = "";
					}
				}
				
				else if (sCellRef.getAttribute("qsc").indexOf("il") == 0 || sCellRef.getAttribute("qsc").indexOf("ol") == 0)
				{
					if (oMQMgr.isMeasure(sColRefId))
					{
						sLevelId = sColumnName;
						sColumnName = sColRefId;
					}
				}
			}
		}

		if ((sLevelId !== "") && (oMQMgr.getColumnId(sLevelId) === MINI_QUERY_NO_COLUMN_FOUND))
		{
			sLevelId = "";
		}
	}

	if (sLevelId !== "")
	{
		oColSpecialProperties.levelId = sLevelId;
	}
	if (sIntersectId !== "")
	{
		oColSpecialProperties.intersectId = sIntersectId;
	}
	if (sForcedType !== "")
	{
		oColSpecialProperties.forcedType = sForcedType;
	}

	
	return oColSpecialProperties;
};