analytics/webcontent/qfw/QFLogFormatting.js

/****************************************************************************************************************************

Licensed Materials - Property of IBM 
BI and PM: QFW 
© Copyright IBM Corp. 2005, 2010 
US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 

*****************************************************************************************************************************/



var fso = null;

function getFileSystemObject()
{
	try
	{
		if(	fso == null )
			fso = new ActiveXObject("Scripting.FileSystemObject");
	
		return fso;
	} catch (e) {
		return null;
	}	
}

function executeXML( text, binFolder, fileName )
{
	text = text.replace( /<[^> \/]+:/g, "<" );
    text = text.replace( /<\/[^> ]+:/g, "</" );
    text = text.replace( /(\<\/?)(validate)/g, "$1execute" );
    text = text.replace( /<queryFeedback[\S\s]*<\/queryFeedback>/g, "" );

	var fso = new ActiveXObject("Scripting.FileSystemObject");
	var s = fso.CreateTextFile( fileName + ".xml", true);
	s.WriteLine(text);
	s.Close();

	var myshell = new ActiveXObject( "WScript.shell" );
	
	myshell.CurrentDirectory = binFolder;
	myshell.run( "\"" + binFolder + "\\QFWTest.exe\" -rsxsl 2 -pagesize -1 -d \"" + binFolder + "\\..\\logs\\qfw\" \"" + fileName + ".xml\"" , 1, true );

	if( fso.FileExists(fileName + ".out") )
	{
		textFile = fso.OpenTextFile(fileName + ".out",1);
		var fileContents = textFile.ReadAll();
		textFile.Close();

		return fileContents;
	}
}

var xslObject = null;

function getOutputFormattingXsl() 
{
	if( xslObject != null )
		return xslObject;

	var fileSystem = getFileSystemObject();

	xslFile = fileSystem.OpenTextFile( binFolder.innerText + "\\..\\templates\\qfw\\QFResultSetFormatting.xsl" ,1 );
	var xslFileContents = xslFile.ReadAll();
	xslFile.Close();			

	xslObject = new ActiveXObject("Microsoft.XMLDOM");
	xslObject.async = false;
	xslObject.loadXML( xslFileContents );

	return xslObject;
}


function executeOnClick()
{
	var fullXML = event.srcElement.parentElement;
    var xmlroot = null;
	var resultroot = null;
	var child = fullXML.firstChild;
	for( ; child != null; child = child.nextSibling )
		if( child.tagName == "DIV" )
		{
			if( xmlroot == null && child.className == 'e')
				xmlroot = child;
			
			if( child.className == "result" )
				resultroot = child;
			else
				child.style.display = "none";
		}
	
	if( resultroot != null )
	{
		resultroot.style.display = "block";
		return;
	}

	if( xmlroot == null )
		return;

	if( document.body.client != "CRN" )
		executeWithQFWTest( xmlroot, fullXML );
	else
		executeWithCRN( xmlroot, fullXML );
}

var v_sFrameId_Counter = 1;
function executeWithCRN( xmlroot, fullXML )
{
	var v_oFrame;
	var v_sFrameId;
	
	for( var i = 0; i < fullXML.childNodes.length; ++i )
		if( fullXML.childNodes[i].tagName == "IFRAME" )
			v_oFrame = fullXML.childNodes[i];
	
	if( !v_oFrame )
	{
		var v_sFrameId = "idResultView" + (v_sFrameId_Counter++);
		v_oFrame = document.createElement( "IFRAME" );
		
		fullXML.appendChild( v_oFrame );
		v_oFrame.outerHTML = 
		'<IFRAME src="' + window.parent.G_HAL.F_GetFileURL('../hal/blank.htm') + 
		'" name="' + v_sFrameId + '" id="' + v_sFrameId + '" frameBorder="no" style="border:none; display:block; width: 80%;"></IFRAME>';
		
		var v_sQueryText = extractV5CommandText( xmlroot, fullXML );
		var v_sReportSpec = window.parent.G_QanReportGenerator.F_convertQueryToReportSpec( v_sQueryText );
		window.parent.G_QanQueryExecution.F_submitReportViewRequest( v_sFrameId, document, v_sReportSpec );
	}
	else
	{
		v_oFrame.style.display = "block";
	}
}


window.adjustResultViewer = function(viewerWindow)
{
	// alert( 'h='+ viewerWindow.document.getElementById( 'CVReportRS' ).offsetHeight + ';w=' +  viewerWindow.document.body.scrollWidth );
	//debugger;
	
	var v_nViewerIframe = document.getElementById(viewerWindow.name);
	
	var v_nViewerElement = viewerWindow.document.getElementById( 'CVReportRS' );
	var v_viewerHeight =  v_nViewerElement.offsetHeight;

	var v_nViewerToolbarElement = viewerWindow.document.getElementById( 'CVToolbarRS' );
	if( v_nViewerToolbarElement )
		v_viewerHeight += v_nViewerToolbarElement.offsetHeight;

	var v_nViewerNavElement = viewerWindow.document.getElementById( 'CVNavLinksRS' );
	if( v_nViewerNavElement )
		v_viewerHeight += v_nViewerNavElement.offsetHeight;
		
	 
	v_nViewerIframe.style.height = v_viewerHeight + 5 + 'px';
	v_nViewerIframe.style.width = viewerWindow.document.body.scrollWidth + 5 + 'px';
}



function extractV5CommandText( xmlroot, fullXML )
{
	var queryText = "";
	var rootElemName = xmlNodeName( xmlroot );

	if( rootElemName == 'command' || rootElemName == 'qs:command' )
		queryText = xmlroot.innerText;
	else
	{
		var connectElem;
		var queryElem = document.getElementById( fullXML.parentNode.objId );
		if( queryElem )
			connectElem = document.getElementById( queryElem.connectId + "_connect" );

		if( connectElem && connectElem.children.length >= 2 )
		{
			var connectionSpecElem = connectElem.firstChild;
			for( ; connectionSpecElem && connectionSpecElem.className != "e"; 
					connectionSpecElem = connectionSpecElem.nextSibling );
			if( !connectionSpecElem )
				formatXMLFromString( connectElem );
			for(  connectionSpecElem = connectElem.firstChild; 
					connectionSpecElem && connectionSpecElem.className != "e"; 
					connectionSpecElem = connectionSpecElem.nextSibling );
			
			
			queryText = "<command>" + ((connectionSpecElem)?connectionSpecElem.innerText:"") +
						 xmlroot.innerText + "</command>"; 
		}
		else
			queryText = "<command>" + xmlroot.innerText + "</command>"; 
	}

	queryText = queryText.replace( /\<[^\> ]*:?parameters.*\>/, "<parameters xmlns:bus=\"http://developer.cognos.com/schemas/bibus/3/\" SOAP-ENC:arrayType=\"bus:parameterValue[2]\" xmlns:SOAP-ENC=\"http://schemas.xmlsoap.org/soap/encoding/\" xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xsi:type=\"SOAP-ENC:Array\">" );
	queryText = queryText.replace( /\<\/[^\> ]*:?parameters/, "</parameters" );
	
	queryText = queryText.replace( /\<qs:command/, "<command" );
	queryText = queryText.replace( /\<\/qs:command/, "</command" );

	queryText = queryText.replace( /rID="[^"]*"/g, "" );
	
	return queryText;
}



function executeWithQFWTest( xmlroot, fullXML )
{
	var resultroot = document.createElement( "div" );
	fullXML.appendChild( resultroot );
	resultroot.innerText = " Procesing ... "; 
	resultroot.className = "result";

	var thisdate = new Date();
	var fileName = binFolder.innerText + "\\..\\logs\\qfw\\qfwlog_temp_" + thisdate.getTime();


	var queryText = extractV5CommandText( xmlroot, fullXML );
	
	var resultContent = 
		executeXML( queryText, binFolder.innerText, fileName );

	var xml = new ActiveXObject("Microsoft.XMLDOM")
	xml.async = false;
	if( xml.loadXML(resultContent) )
	{
		var htmlText = xml.transformNode( getOutputFormattingXsl() );
		resultroot.innerHTML = htmlText;
	}
	else
	{
		resultroot.innerHTML = "<pre></pre>";
		resultroot.firstChild.innerText = resultContent;
	}


	event.cancelBubble = true;
}



function executeSetProperties()
{
	var propsElem = event.srcElement;

	var dsPwd = document.createElement( "span" );
	propsElem.appendChild( dsPwd );
	dsPwd.innerText = "Password";

	var dsPwd = document.createElement( "textArea" );
	propsElem.appendChild( dsPwd );
	dsPwd.rows = 1;
	dsPwd.cols = 20;
	
}



function mainMethodOnClick()
{
	var methodElem = event.srcElement;
	for( ; methodElem != null && methodElem.className != "method"; 
			methodElem = methodElem.parentElement );

	if( methodElem == null )
		return;

	var children = methodElem.childNodes;
	for( i = 0; i < children.length; ++i ) 
	{
		if( children[i].className == "nesting" )
		{
			if( event.srcElement.innerText == '(-)' )
			{	
				event.srcElement.innerText = '(+)';
				children[i].style.display ='none';
			}
			else
			{	
				event.srcElement.innerText = '(-)';
				children[i].style.display ='block';
			}
		}
	}
}	

var treeID = 1;

function xmlFirstChild( xmlNode, nodeName )
{
	var i = 0;
	for( ; i < xmlNode.childNodes.length; ++i )
	{
		if( xmlNode.childNodes[i].tagName == "DIV" && xmlNode.childNodes[i].className == "" )
		{
			xmlNode = xmlNode.childNodes[i]; 
			i = -1;
			continue;
		}

		if( xmlNode.childNodes[i].className == "e" && 
			( nodeName == null || nodeName == xmlNodeName( xmlNode.childNodes[i] ) ) ) 
			return xmlNode.childNodes[i];
	}

	return null;
}

function xmlGetText( xmlNode )
{
	var i = 0;
	for( ; i < xmlNode.childNodes.length; ++i )
	{
		if( xmlNode.childNodes[i].tagName == "DIV" && xmlNode.childNodes[i].className == "" )
		{
			xmlNode = xmlNode.childNodes[i]; 
			i = -1;
			continue;
		}

		if( xmlNode.childNodes[i].tagName == "B" && xmlNode.childNodes[i].className == "t" )
		{
			return xmlNode.childNodes[i].innerText;
		}
	}

	return "";
}

function xmlNextSibling( xmlNode, nodeName )
{
	var xmlNode = xmlNode.nextSibling;
	for( ; xmlNode != null; xmlNode = xmlNode.nextSibling )
	{
		if( xmlNode.className == "e" &&
			( nodeName == null || nodeName == xmlNodeName( xmlNode ) ) ) 
		{
			return xmlNode;
		}
	}

	return null;
}

function xmlParent( xmlNode )
{
	for( ; xmlNode != null; xmlNode = xmlNode.parentElement )
	{
		if( xmlNode.className == "e" ) 
			return xmlNode;
	}

	return null;
}


function xmlNodeName( xmlNode )
{
	var i = 0;
	for( ; i < xmlNode.childNodes.length; ++i )
	{
		if( xmlNode.childNodes[i].className == "c" ) 
		{
			xmlNode = xmlNode.childNodes[i];
			break;
		}
	}
	
	var elemContent = xmlNode.innerText;
	return elemContent.replace(/</,'').match(/[^\ >\/]*/)[0];
}


function xmlNodeAttribute( xmlNode, attributeName )
{
	var i = 0;
	for( ; i < xmlNode.childNodes.length; ++i )
	{
		if( xmlNode.childNodes[i].className == "c" ) 
		{
			xmlNode = xmlNode.childNodes[i];
			break;
		}
	}

	elemContent = xmlNode.innerText;
	
	var v_reAttrExpr = new RegExp( ' ' + attributeName + '\=\"([^\"]*)\"' );
	var v_aAttrExprRes = elemContent.match( v_reAttrExpr );
	if( !v_aAttrExprRes )
		return "";
		
	return (v_aAttrExprRes[1])? v_aAttrExprRes[1]: "";
}



function isQSAPICommandType( elemName ) 
{
	return ( elemName == "execute" ||
			elemName == "getParameters" ||
			elemName == "validate" ) ;
}

function getV5QuerySet( xmlNode )
{
	var elemName = xmlNodeName( xmlNode );
	if( elemName == "querySet" )
		return xmlNode;

	if( isQSAPICommandType( elemName ) ||
		elemName == "source" ||
		elemName == "response" )
	{
		return xmlFirstChild( xmlNode, "querySet" );
	}
	
	if( elemName == "command" || elemName == "qs:command" )
	{
		var childNode = xmlFirstChild( xmlNode );
		for( ; childNode != null; childNode = xmlNextSibling( childNode ) )
		{
			elemName = xmlNodeName( childNode );
			if( isQSAPICommandType( elemName ) )
			{
				return xmlFirstChild( childNode, "querySet" );
			}
		}
	}
}


function unwindQuerySet( xmlNode, tree, parentIndex )
{
	var xmlQuerySet = getV5QuerySet( xmlNode );
	if( xmlQuerySet == null )
		return false;

	var queryArray = new Array();
	var xmlQueries = xmlFirstChild( xmlQuerySet, "queries"	);
	if( xmlQueries != null )
	{
		var xmlQuery = xmlFirstChild( xmlQueries, "query" );
		for( ; xmlQuery != null; xmlQuery = xmlNextSibling( xmlQuery, "query" ) )
		{
			queryArray[ xmlNodeAttribute( xmlQuery, "name" ) ] = xmlQuery;	
		}

		xmlQuery = xmlFirstChild( xmlQueries, "providerQuery" );
		for( ; xmlQuery != null; xmlQuery = xmlNextSibling( xmlQuery, "providerQuery" ) )
		{
			unwindProviderQuery( xmlQuery, tree, parentIndex, queryArray );	
		}
	}


	var xmlQRDs = xmlFirstChild( xmlQuerySet, "queryResultDefinitions" );
	if( xmlQRDs != null )
	{
		var xmlQRD = xmlFirstChild( xmlQRDs, "queryResultDefinition" );
		for( ; xmlQRD != null; xmlQRD = xmlNextSibling( xmlQRD, "queryResultDefinition" ) )
		{
			unwindQRD( xmlQRD, tree, parentIndex, queryArray );
		}
		
	}
	
	return true;
}

var treeLeafIdGen = 0;

function unwindQRD( xmlQRD, tree, parentIndex, queryArray )
{
	thisLeafId = treeLeafIdGen++;
	tree.add( thisLeafId, parentIndex, 
				xmlNodeAttribute( xmlQRD, "name" ),
				null, null, "#FCFFD3", "QRD" );
	
	preserveId2XMLNodeMapping( thisLeafId, xmlQRD );
	
	unwindQueryRef( xmlQRD, tree, thisLeafId, queryArray );				
}

function unwindQueryRef( xmlRef, tree, parentIndex, queryArray )
{
	queryName = xmlNodeAttribute( xmlRef, "refQuery" );
	xmlQuery = queryArray[queryName];
	if( xmlQuery == null )
		return;

	unwindQuery( xmlQuery, tree, parentIndex, queryArray );
}


function unwindQuery( xmlQuery, tree, parentIndex, queryArray )
{
	thisLeafId = treeLeafIdGen++;
	tree.add( thisLeafId, parentIndex, 
				xmlNodeAttribute( xmlQuery, "name" ),
				null, null, "#E3E3D3", "Query" );


	xmlSource = xmlFirstChild( xmlQuery, "source" );
	if( xmlSource == null )
		return;
	
	preserveId2XMLNodeMapping( thisLeafId, xmlQuery );

	unwindSource( xmlSource, tree, thisLeafId, queryArray );
}

function unwindSource( xmlSource, tree, parentIndex, queryArray )
{
	if( unwindQuerySet( xmlSource, tree, parentIndex ) )
		return;

	var childNode = xmlFirstChild( xmlSource );
	
	for( ; childNode != null; childNode = xmlNextSibling( childNode ) )
	{
		if( xmlNodeName( childNode ) == "queryRef" )
			unwindQueryRef( childNode, tree, parentIndex, queryArray );
		else if( xmlNodeName( childNode ) == "providerQuery" )
			unwindProviderQuery( childNode, tree, parentIndex, queryArray );
		else if( xmlNodeName( childNode ) == "queryOperation" || 
					xmlNodeName( childNode ) == "joinOperation"  )
			unwindOperation( childNode, tree, parentIndex, queryArray );
		else if( xmlNodeName( childNode ) == "sqlQuery" || 
					xmlNodeName( childNode ) == "mdxQuery" )
			unwindNativeQuery( childNode, tree, parentIndex, queryArray );
	}
}


function providerQuery_GetPlanDetails( xmlPQuery )
{
	var xmlPlans = xmlFirstChild( xmlPQuery, "plans" );
	if( !xmlPlans)
		return;
	
	var xmlPlan = xmlFirstChild( xmlPlans, "plan" );
	if( !xmlPlan )
		return;
		
	return xmlFirstChild( xmlPlan, "planDetails" );
}


function preserveId2XMLNodeMapping( thisLeafId, xmlPQuery )
{
	if( !document.nodeId2XMLNode )
		document.nodeId2XMLNode = [];
		
	document.nodeId2XMLNode[ thisLeafId ] = xmlPQuery;	
}


function createQueryPlanNode( xmlPQuery, tree, parentIndex )
{
	var providerStr = xmlNodeAttribute( xmlPQuery, "provider" );
	
	var nodeText;
	
	if( providerStr == "CubeBuildProvider" )
		nodeText = "CUBE";
	else if( providerStr == "OlapQueryProvider" )
		nodeText = "MDX";
	else if( providerStr == "RelationalQueryProvider" )
		nodeText = "SQL";
	else
	{
		var xmlPlanDetails = providerQuery_GetPlanDetails( xmlPQuery );
		if( !xmlPlanDetails )
			return parentIndex;	

		if( xmlFirstChild( xmlPlanDetails, "wrappedQuery" ) )
			nodeText = "MDX";
		else
			return parentIndex;	
	}
		
	var thisLeafId = treeLeafIdGen++;
	
	tree.add( thisLeafId, parentIndex, 
				xmlNodeAttribute( xmlPQuery, "name" ),
				null, null, "#A3E3E3", nodeText );
				
	preserveId2XMLNodeMapping( thisLeafId, xmlPQuery );
				
	return thisLeafId;	
} 


function unwindProviderQuery( xmlPQuery, tree, parentIndex, queryArray )
{
	var thisLeafId;
	
	if( !tree.m_bQueryPlan )
	{
		thisLeafId = treeLeafIdGen++;
		tree.add( thisLeafId, parentIndex, 
					xmlNodeAttribute( xmlPQuery, "name" ),
					null, null, "#A3E3E3", "providerQuery <div>[" + xmlNodeAttribute( xmlPQuery, "provider" ) + "]</div>" );
	}
	else
	{
		thisLeafId = createQueryPlanNode( xmlPQuery, tree, parentIndex ); 
	}	

	preserveId2XMLNodeMapping( thisLeafId, xmlPQuery );

	
	xmlSource = xmlFirstChild( xmlPQuery, "source" );
	if( xmlSource == null )
		return;
	
	unwindSource( xmlSource, tree, thisLeafId, queryArray );
}			

function unwindOperation( xmlOperation, tree, parentIndex, queryArray )
{
	thisLeafId = treeLeafIdGen++;
	tree.add( thisLeafId, parentIndex,  xmlNodeAttribute(xmlOperation, 'setOperation'), 
				null, null, null, xmlNodeName(xmlOperation) );

	preserveId2XMLNodeMapping( thisLeafId, xmlOperation );

	xmlQueryRefs = xmlFirstChild( xmlOperation, "queryRefs" );
	if( xmlQueryRefs == null )
		return;

	unwindSource( xmlQueryRefs, tree, thisLeafId, queryArray );
}			

function unwindJoin( xmlJoin, tree, parentIndex, queryArray )
{
	thisLeafId = treeLeafIdGen++;
	tree.add( thisLeafId, parentIndex, xmlNodeName(xmlOperation) );

	xmlJoinOperands = xmlFirstChild( xmlJoin, "joinOperands" );
	if( xmlJoinOperands == null )
		return;

	preserveId2XMLNodeMapping( thisLeafId, xmlJoin );

	var xmlJoinOperand = xmlFirstChild( xmlJoinOperands );
	for( ; xmlJoinOperand != null; xmlJoinOperand = xmlNextSibling( xmlJoinOperand ) )
		unwindSource( xmlJoin, tree, thisLeafId, queryArray );
}			

function unwindNativeQuery( xmlNativeQuery, tree, parentIndex, queryArray )
{
	thisLeafId = treeLeafIdGen++;
	tree.add( thisLeafId, parentIndex, xmlNodeName(xmlNativeQuery) );
	preserveId2XMLNodeMapping( thisLeafId, xmlNativeQuery );
}			

function buildQueryTree( fullXML, nodeInitializationFunc )
{
	var treeNode = document.createElement( "div" );
	fullXML.insertBefore( treeNode, (fullXML.lastChild.className == "nodeDetails")? fullXML.lastChild: null  );
	
	treeNode.className = "tree";
	treeNode.id = "tree_" + treeID;
	treeID++;
	
	var t = new LogTree( treeNode.id +'.t',treeNode);

	treeNode.t = t;

	t.config.nodeWidth = 60;
	t.config.nodeHeight = 40;
	t.config.levelMargin = 20;
	t.config.siblingMargin = 10;
	t.config.tempTreeContainer = tempTreeContainer;
	tempTreeContainer.parentElement.className = "tree";

	xmlRoot = xmlFirstChild( fullXML );

	nodeInitializationFunc( xmlRoot, t, -1 );

	t.container.onclick = queryPlan_onClick;
	t.container.onblur = queryPlan_onBlur;
								
	t.UpdateTree();

	var rootGroup = treeNode.childNodes[0];

	treeNode.style.height = rootGroup.style.posHeight + 3;
	treeNode.style.width = "100%";
}	

var G_QueryPlan_activeNode;

function queryPlan_getNodeContainer( planNode )
{
	for( ; planNode && planNode.tagName != "roundrect"; planNode = planNode.parentElement );
	return planNode;
}	

function queryPlan_treeContainer( planNode )
{
	for( ; planNode && planNode.className != "fullXML"; planNode = planNode.parentElement );
	return planNode;
}	

function queryPlan_getNodeDetailsArea( fullXML )
{
	if( !fullXML.nodeDetailsArea )
	{
		var nodeDetailsArea = document.createElement( "DIV" );
		nodeDetailsArea.className = "nodeDetails";
		fullXML.appendChild( nodeDetailsArea );
		
		
		fullXML.nodeDetailsArea = nodeDetailsArea;
	}
	
	return fullXML.nodeDetailsArea;
}



function queryPlan_populateNodeDetailsTitle( nodeDetailsArea, planNode )
{
	if( !nodeDetailsArea.titleDiv )
	{
		nodeDetailsArea.titleDiv = document.createElement( "DIV" );
		nodeDetailsArea.appendChild( nodeDetailsArea.titleDiv );
		nodeDetailsArea.titleDiv.className = "detailsTitle";
	}

	nodeDetailsArea.titleDiv.innerHTML = "";
			
	nodeDetailsArea.nodeNameB = document.createElement( "B" );
	nodeDetailsArea.titleDiv.appendChild( nodeDetailsArea.nodeNameB  );
	nodeDetailsArea.nodeNameB.className = "detailsName";
	
	nodeDetailsArea.nodeNameB.innerText = planNode.firstChild.childNodes[0].innerText;
}

function queryPlan_getDetailsContentDiv( nodeDetailsArea )
{
	if( !nodeDetailsArea.detailContextDiv )
	{
		nodeDetailsArea.detailContextDiv = document.createElement( "DIV" );
		nodeDetailsArea.appendChild( nodeDetailsArea.detailContextDiv );
	}
	return nodeDetailsArea.detailContextDiv;
}

function queryPlan_propertyOnClick()
{
	var propertyNameU = event.srcElement;
	var nodeDetailsArea = propertyNameU.parentElement.parentElement;
	var contentDiv = queryPlan_getDetailsContentDiv( nodeDetailsArea );
	var propertyName = propertyNameU.innerText;
	
	for( var i  = 0; i < contentDiv.childNodes.length; ++i )
		contentDiv.childNodes[i].style.display = "none";
	
	contentDiv.property2RenderedValue[propertyName].style.display = "block";
}


function queryPlan_populateNodeDetails_title( nodeDetailsArea, contentDiv, propertyName, renderedProperty )
{
	renderedProperty.style.display = "none";
	contentDiv.appendChild( renderedProperty );
	
	if( !contentDiv.property2RenderedValue )
		contentDiv.property2RenderedValue = [];

	contentDiv.property2RenderedValue[propertyName] = renderedProperty;
	
	var propertyNameU = document.createElement( "U" );
	nodeDetailsArea.titleDiv.appendChild( propertyNameU );
	propertyNameU.innerText = propertyName;
	propertyNameU.onclick = queryPlan_propertyOnClick;
}			

function queryPlan_populateNodeDetails_fromInfo( nodeDetailsArea, planNode, xmlPlanNode )
{
	var initPropertyContent;
	 
	var contentDiv = queryPlan_getDetailsContentDiv( nodeDetailsArea );
	var xmlInfoNode = xmlFirstChild( xmlPlanNode, "info" );
	if( xmlInfoNode )
	{
		var xmlInfoItemNode = xmlFirstChild( xmlInfoNode, "property" );
		
		for( ; xmlInfoItemNode != null; xmlInfoItemNode = xmlNextSibling( xmlInfoItemNode, "property" ) )
		{
			var propertyText = xmlGetText( xmlInfoItemNode );
			var propertyName = xmlNodeAttribute( xmlInfoItemNode, "name" );

			var renderedProperty = document.createElement( "DIV" );
			renderedProperty.innerText = propertyText;

			queryPlan_populateNodeDetails_title( nodeDetailsArea, contentDiv, propertyName, renderedProperty );
			
			if( !initPropertyContent )
				initPropertyContent = renderedProperty;
		}
	}
	
	return initPropertyContent; 
}


function queryPlan_populateNodeDetails_xmlQuery( nodeDetailsArea, planNode, xmlQuery )
{
	var nodeDiv = document.createElement( "DIV" );
	parentPlanDiv.appendChild( nodeDiv );
	nodeDiv.className = "items";
	nodeDiv.innerText = nodeName + ' "' + xmlNodeAttribute( xmlPlanNode, "Name" ) + '"';
	parentPlanDiv = nodeDiv;

}


function queryPlan_populateNodeDetails_fromXmlQueryNode( nodeDetailsArea, xmlQueryNode, parentQueryDiv )
{
	var nodeName = xmlNodeName( xmlQueryNode );
	if( nodeName == "expression"	    ||
		nodeName == "filterExpression"  )
	{
		var nodeDiv = document.createElement( "DIV" );
		parentQueryDiv.appendChild( nodeDiv );
		nodeDiv.className = "queryExpr";
		nodeDiv.innerText = xmlGetText( xmlQueryNode );
		return;
	}

	if(	nodeName == "edge"				 ||
		nodeName == "valueSet"			 ||
		nodeName == "groupHeader"		 ||
		nodeName == "groupFooter"		 ||
		nodeName == "groupDetails"		 ||
		nodeName == "dataItemRef"		 ||
		nodeName == "dataItem"			 ||
		nodeName == "detailFilter"		 ||
		nodeName == "slicer"			 ||
		nodeName == "summaryFilter"  )
	{
		var nodeDiv = document.createElement( "DIV" );
		parentQueryDiv.appendChild( nodeDiv );
		nodeDiv.className = "queryItem";
		nodeDiv.innerText = nodeName;

		var nameAttrValue;
		
		if( nodeName == "valueSet" || nodeName == "dataItemRef" )
			nameAttrValue = xmlNodeAttribute( xmlQueryNode, "refDataItem" ) ;
		else
			nameAttrValue = xmlNodeAttribute( xmlQueryNode, "name" ) ;
		
		if( nameAttrValue )
			 nodeDiv.innerText += ' "' + nameAttrValue + '"';
			 
		parentQueryDiv = nodeDiv;
	}
	
	if(	nodeName == "source"  )
	{
		return;
	}
	
	var xmlChild = xmlFirstChild( xmlQueryNode );
	for( ; xmlChild; xmlChild = xmlNextSibling( xmlChild ) )
	{
		queryPlan_populateNodeDetails_fromXmlQueryNode( nodeDetailsArea, xmlChild, parentQueryDiv );
	}
}


function queryPlan_populateNodeDetails_fromOriginal( nodeDetailsArea, planNode, xmlPlanNode )
{
	var xmlOriginal = xmlFirstChild( xmlPlanNode, "original" );
	if( !xmlOriginal )
	{
		var xmlPlanDetails = providerQuery_GetPlanDetails( xmlPlanNode );
		xmlOriginal = xmlFirstChild( xmlPlanDetails, "wrappedQuery" );
		if( !xmlOriginal )
			return null;
	}
		
	var contentDiv = queryPlan_getDetailsContentDiv( nodeDetailsArea );

	var queryDetailsDiv = document.createElement( "DIV" );
	contentDiv.appendChild( queryDetailsDiv );
	
	queryPlan_populateNodeDetails_fromXmlQueryNode( nodeDetailsArea, xmlOriginal, queryDetailsDiv );
	
	queryPlan_populateNodeDetails_title( nodeDetailsArea, contentDiv, "query", queryDetailsDiv );
	
	return queryDetailsDiv; 
}


function queryPlan_populateNodeDetails_fromCubeNode( nodeDetailsArea, xmlPlanNode, parentPlanDiv )
{
	var nodeName = xmlNodeName( xmlPlanNode );
	if( nodeName == "Dimension" ||
		nodeName == "Hierarchy" ||
		nodeName == "LevelRef"  ||
		nodeName == "Level"		||
		nodeName == "Measure"  )
	{
		var nodeDiv = document.createElement( "DIV" );
		parentPlanDiv.appendChild( nodeDiv );
		nodeDiv.className = "cube";
		nodeDiv.innerText = nodeName + ' "' + xmlNodeAttribute( xmlPlanNode, "Name" ) + '"';
		parentPlanDiv = nodeDiv;
	}
	
	if(	nodeName != "planDetails" &&
		nodeName != "Model" &&
		nodeName != "DimensionCollection" &&
		nodeName != "Dimension" &&
		nodeName != "HierarchyCollection" &&
		nodeName != "Hierarchy" &&
		nodeName != "HierarchyLevels" &&
		nodeName != "LevelCollection" &&
		nodeName != "MeasureCollection" )
	{
		return;
	}
	
	var xmlChild = xmlFirstChild( xmlPlanNode );
	for( ; xmlChild; xmlChild = xmlNextSibling( xmlChild ) )
	{
		queryPlan_populateNodeDetails_fromCubeNode( nodeDetailsArea, xmlChild, parentPlanDiv );
	}
}



function queryPlan_populateNodeDetails_fromCube( nodeDetailsArea, planNode, xmlPlanNode )
{
	var xmlPlanDetails = providerQuery_GetPlanDetails( xmlPlanNode );

	var contentDiv = queryPlan_getDetailsContentDiv( nodeDetailsArea );

	var cubePlanDetailsDiv = document.createElement( "DIV" );
	contentDiv.appendChild( cubePlanDetailsDiv );
	
	queryPlan_populateNodeDetails_fromCubeNode( nodeDetailsArea, xmlPlanDetails, cubePlanDetailsDiv );
	
	return cubePlanDetailsDiv; 
}


function queryPlan_populateNodeDetails( nodeDetailsArea, planNode )
{
	queryPlan_populateNodeDetailsTitle( nodeDetailsArea, planNode );

	var contentDiv = queryPlan_getDetailsContentDiv( nodeDetailsArea );
	contentDiv.innerHTML = "";

	if( !document.nodeId2XMLNode	)
		return;
		
	var xmlPlanNode = document.nodeId2XMLNode[ planNode.id ];
	
	if( !xmlPlanNode )
		return;
		
	var nodeName = xmlNodeName( xmlPlanNode );
	if( nodeName == "query"  || nodeName == "queryResultDefinition" || nodeName == "queryOperation" )
		queryPlan_populateNodeDetails_v5Blocks( nodeDetailsArea, planNode, xmlPlanNode, nodeName );
	else	
		queryPlan_populateNodeDetails_providerQueryBlocks( nodeDetailsArea, planNode, xmlPlanNode );
}		

function queryPlan_populateNodeDetails_v5Blocks( nodeDetailsArea, planNode, xmlPlanNode, nodeName )
{
	var contentDiv = queryPlan_getDetailsContentDiv( nodeDetailsArea );

	var queryDetailsDiv = document.createElement( "DIV" );
	
	contentDiv.appendChild( queryDetailsDiv );
	
	queryPlan_populateNodeDetails_fromXmlQueryNode( nodeDetailsArea, xmlPlanNode, queryDetailsDiv, nodeName );
	
	queryPlan_populateNodeDetails_title( nodeDetailsArea, contentDiv, nodeName, queryDetailsDiv );
	
	queryDetailsDiv.style.display = "block";

	return queryDetailsDiv; 

}

		
function queryPlan_populateNodeDetails_providerQueryBlocks( nodeDetailsArea, planNode, xmlPlanNode )
{		
	var initPropertyContent = queryPlan_populateNodeDetails_fromInfo( nodeDetailsArea, planNode, xmlPlanNode );

	if( xmlNodeAttribute( xmlPlanNode, "provider" ) == "CubeBuildProvider" )
		initPropertyContent = queryPlan_populateNodeDetails_fromCube( nodeDetailsArea, planNode, xmlPlanNode );
	else
	{
		var propertyContent = queryPlan_populateNodeDetails_fromOriginal( nodeDetailsArea, planNode, xmlPlanNode );
		if( !initPropertyContent )
			initPropertyContent = propertyContent;
	}
		

	if( initPropertyContent ) 
		initPropertyContent.style.display = "block";
}



function queryPlan_onClick()
{
	
	var planNode = queryPlan_getNodeContainer( event.srcElement  );
	var fullXML = queryPlan_treeContainer( planNode );
	if( !fullXML )
		return;
	
	planNode.prevFillColorValue = planNode.fillColor.value;
	planNode.fillColor = "white";
	
	var nodeDetailsArea = queryPlan_getNodeDetailsArea( fullXML );
	queryPlan_populateNodeDetails( nodeDetailsArea, planNode );
	nodeDetailsArea.style.display = "block";
	
	if( G_QueryPlan_activeNode )
		queryPlan_onBlur();
		 
	G_QueryPlan_activeNode = planNode;
}


function queryPlan_onBlur()
{
	var planNode = G_QueryPlan_activeNode;

	planNode.fillColor = planNode.prevFillColorValue;
}



function unwindPlanQuerySet( xmlNode, tree, parentIndex )
{
	tree.container.parentElement.className = "plan";
	tree.m_bQueryPlan = true;
	unwindQuerySet( xmlNode, tree, parentIndex );
}



function shortParameterOnClick()
{
}

function adjustParameterHeaderState( fullXML, open )
{
	//determine which parameter type it is
	var paramElem = fullXML.firstChild;
	for( ; paramElem != null; paramElem = paremElem.nextSibling )
		if( paramElem.className == "paramType" )
			break;
			
	if( paramElem == null )
		return;
	var paramType = paramElem.innerText.replace(/:\s*/, "" );

	//finds the methodHeader
	var headerElem = fullXML.parentElement.firstChild;
	for( ;  headerElem  != null;  headerElem = headerElem .nextSibling )
		if(  headerElem.className == "methodHeader" )
			break;
	
	if( headerElem == null )
		return;

	//finds the parameter in the methodHeader
	var paramToggleElem = headerElem.firstChild;
	for( ; paramToggleElem != null; paramToggleElem = paramToggleElem.nextSibling )
		if( paramToggleElem.tagName == "U" && paramToggleElem.innerText.indexOf( paramType ) == 0 )
			break;
			
	if( paramToggleElem == null )
		return;
	
	//changes the +/-
	paramToggleElem.previousSibling.innerText = (open)? "-": "+";
}

function adjustErrorHeaderState( fullXML, open )
{
	var paramElem = fullXML.firstChild;
	for( ; paramElem != null; paramElem = paremElem.nextSibling )
		if( paramElem.className == "err")
			break;

	if( paramElem == null )
		return;


	var headerElem = fullXML.parentElement.firstChild;
	for( ;  headerElem  != null;  headerElem = headerElem .nextSibling )
		if(  headerElem.className == "methodHeader" )
			break;

	if( headerElem == null )
		return;

	var paramToggleElem = headerElem.firstChild;
	for( ; paramToggleElem != null; paramToggleElem = paramToggleElem.nextSibling )
{		if( paramToggleElem.tagName == "U" && paramToggleElem.innerText.indexOf( "error" ) == 0 )
			break;
}

	if( paramToggleElem == null )
		return;
	
	paramToggleElem.previousSibling.innerText = (open)? "-": "+";
}


function openExecutionPlan( parent )
{
	if( parent.tagName == "DIV" && parent.className == "fullXML" )
	{
		if( parent.childNodes.length >= 4 && parent.childNodes[3].tagName == "U" ) 
		{
			var fullXML = parent;
			fullXML.style.display = 'block';
			setParameterPresentation( "Plan", fullXML );
		}

		return;
	}

	var childNode = parent.firstChild;
	for( ; childNode != null; childNode = childNode.nextSibling )
	{
		openExecutionPlan( childNode, open );
	}
}

function allParametersFoldingCall(parent)
{
	if( event.srcElement.innerText.indexOf( "Hide" ) == 0)
	{
		allParametersFolding( parent, false )
		event.srcElement.innerText = "Show query trees";
	}
	else
	{
		allParametersFolding( parent, true )
		event.srcElement.innerText = "Hide query trees";
	}
}

function showExecutionTree( parent )
{
	window.parent.G_QanApp.F_CreateExecutionTrees();
	window.parent.G_QanApp.F_ShowExecutionTrees();
}

function allParametersFolding( parent, open )
{	
	if( parent.tagName == "DIV" && parent.className == "fullXML" )
	{
		if( parent.childNodes.length >= 3 && parent.childNodes[2].tagName == "U" ) 
		{
			if( open )
			{
				parent.style.display = 'block';
				setParameterPresentation( "Tree", parent );
			}
			else
			{
				parent.style.display = 'none';
			}
			adjustParameterHeaderState( parent, open );
			updateMethodInfoClass( parent.parentElement );
		}

		return;
	}

	var childNode = parent.firstChild;
	for( ; childNode != null; childNode = childNode.nextSibling )
	{
		allParametersFolding( childNode, open );
		if(childNode.nextSibling == null) break;
	}	
}

function allErrorsFoldingCall(parent)
{
	var numError = 0;
	
	if( event.srcElement.innerText.indexOf( "Hide" ) == 0)
	{
		numError = allErrorsFolding( parent, false, numError )
		event.srcElement.innerText = "Show all errors";
	}
	else
	{
		numError = allErrorsFolding( parent, true, numError )
		if(!numError)
		{
			alert("There are no errors to show in this log");
			event.srcElement.onclick = ""
			event.srcElement.style.color = "gray";
			return;
		}
		event.srcElement.innerText = "Hide all errors";
	}
}

function allErrorsFolding( parent, open, numError )
{
	if( parent.tagName == "DIV" && parent.className == "fullXML" && parent.innerText.indexOf( "error" ) == 0)
	{
		if( parent.childNodes.length == 2 && parent.childNodes[1].tagName == "DIV" ) 
		{
			var fullXML = parent;
			if( open )
			{
				fullXML.style.display = 'block';
				setParameterPresentation( "XML", fullXML );
			}
			else
				fullXML.style.display = 'none';
			
			adjustErrorHeaderState( fullXML, open );
			updateMethodInfoClass( fullXML.parentElement );
		}
		numError++;
		return numError;
	}
	
	var childNode = parent.firstChild;
	for( ; childNode != null; childNode = childNode.nextSibling )
	{
		numError = allErrorsFolding( childNode, open, numError );
	}
	
	return numError;
}

function globalEventHandler()
{
	if( event.srcElement == null )
		return;

	var parentElement = event.srcElement.parentElement;

	if( event.srcElement.tagName == "U" && parentElement != null )
	{
		if( parentElement.className == "fullXML" )
		{
			return changeParameterPresentation();
		}
		else if( parentElement.className == "logItemMenu" )
		{
			return changeLogItemPresentation();
		}
	}
	
	if( event.srcElement.tagName == "B" && event.srcElement.className == "paramType" && 
		parentElement != null && parentElement.className == "fullXML" )
	{
		return setSelectionOnXML( parentElement );
	}
	
	if( event.srcElement.className == "logItemHeader" || 
		parentElement != null && parentElement.className == "logItemHeader" )
	{
		return foldingLogItem();
	}
}

function foldingLogItem()
{
	var v_spanLogItem = event.srcElement;
	if( v_spanLogItem.className != "logItemHeader" )
		v_spanLogItem = v_spanLogItem.parentElement;
		
	if( !v_spanLogItem )
		return;

	var v_divLogContainer = v_spanLogItem.parentElement;
	if( !v_divLogContainer )
		return;
	
	var v_img = v_spanLogItem.firstChild;
	if( !v_img )
		return;
	
	var v_bIsOpened = ( v_img.src.search(/show_area.gif$/) >= 0 );
	
	if( v_bIsOpened )
		v_img.src = v_img.src.replace( /show_area.gif$/, "hide_area.gif" );
	else
		v_img.src = v_img.src.replace( /hide_area.gif$/, "show_area.gif" );
	
	var v_divSibling = v_spanLogItem.nextSibling;
	for( ; v_divSibling; v_divSibling = v_divSibling.nextSibling )
	{
		v_divSibling.style.display = ( v_bIsOpened )? 'none': "block";
	}
	
	if( !v_bIsOpened )
		setLogItemPresentation( v_divLogContainer.presentation, v_divLogContainer );
}
 
function changeLogItemPresentation()
{
	if( event.srcElement != null && event.srcElement.tagName != "U" )
		return;

	var v_sPresentationType = event.srcElement.innerText;
	var v_divLogItemMenu = event.srcElement.parentElement;	
	var v_divLogItemContainer = v_divLogItemMenu.parentElement;

	setLogItemPresentation( v_sPresentationType, v_divLogItemContainer );
}


function setLogItemPresentation( v_sPresentationType, v_divLogItemContainer )
{
	v_divLogItemContainer.presentation = v_sPresentationType;
	var v_bFoundPresentation = false;
	
	var v_divLogItemPresentation = v_divLogItemContainer.firstChild;
	for( ; v_divLogItemPresentation; 
			v_divLogItemPresentation = v_divLogItemPresentation.nextSibling )
	{	
		if( !v_divLogItemPresentation.presentation )
			continue;
			
		var v_bMatches = (v_divLogItemPresentation.presentation.indexOf(v_sPresentationType) >= 0 );
		v_divLogItemPresentation.style.display = ( v_bMatches )? "block": "none";
		v_bFoundPresentation |= ( v_divLogItemPresentation.presentation == v_sPresentationType );  
	}
	
	if( !v_bFoundPresentation )
		window.parent.G_QanApp.F_ShowPresentation( v_sPresentationType, v_divLogItemContainer );
}



 
function changeParameterPresentation()
{
	if( event.srcElement != null && event.srcElement.tagName != "U" )
		return;

	var presentationType = event.srcElement.innerText;
	var parent = event.srcElement.parentElement.parentElement;
	var fullXML = event.srcElement.parentElement;	

	setParameterPresentation( presentationType, fullXML );
}


function setParameterPresentation( presentationType, fullXML )
{
	var treeNode, xmlNode, planNode, resultNode;
	var parent = fullXML.parentElement;
	
	for( var i = 0; i < fullXML.childNodes.length; ++i ) 
		if( fullXML.childNodes[i].className == "e" )
			xmlNode = fullXML.childNodes[i];
		else
			if( fullXML.childNodes[i].className == "tree" )
				treeNode = fullXML.childNodes[i];
			else if( fullXML.childNodes[i].className == "plan" )
				planNode = fullXML.childNodes[i];
			else
				if( fullXML.childNodes[i].tagName == "DIV" ||
					fullXML.childNodes[i].tagName == "IFRAME" )
				{
					fullXML.childNodes[i].style.display = "none";
				}
				
	if( xmlNode == null )
	{		
		formatXMLFromString( fullXML );

		for( var i = 0; i < fullXML.childNodes.length; ++i ) 
			if( fullXML.childNodes[i].className == "e" )
				xmlNode = fullXML.childNodes[i];
	}			

	if( presentationType == "Tree" )
	{
		fullXML.presentation = "queryTree";
		if( treeNode )
			treeNode.style.display = "block";
		else
			buildQueryTree( fullXML, unwindQuerySet );

		if( xmlNode )
			xmlNode.style.display = "none";
		if( planNode )
			planNode.style.display = "none";
		if( resultNode )
			resultNode.style.display = "none";

	}
	else if( presentationType == "Plan" )
	{
		fullXML.presentation = "queryPlan";
		if( planNode )
			planNode.style.display = "block";
		else
			buildQueryTree( fullXML, unwindPlanQuerySet );

		if( xmlNode )
			xmlNode.style.display = "none";
		if( treeNode )
			treeNode.style.display = "none";

	}
	else
	{
		fullXML.presentation = "XML";
		if( treeNode )
			treeNode.style.display = "none";
		if( planNode )
			planNode.style.display = "none";
		if( xmlNode )
		{
			xmlNode.style.display = "block";
		}
	}	
}


function longParameterFolding()
{
	var paramType = event.srcElement.parentElement.innerText.split(" ")[0];
	var parent = event.srcElement.parentElement.parentElement.parentElement;
	var children = parent.childNodes;
}	


function updateMethodInfoClass( methodInfo )
{
	var open = false;
	var children = methodInfo.childNodes;
	for( i = 0; i < children.length; ++i ) 
	{
		if( children[i].className != "fullXML" )
			continue;

		if( children[i].style.display == "block" )
		{
			open = true;
			break;
		}
	}
	
	if( open && methodInfo.className == "methodInfo" )
		methodInfo.className = "methodInfoOpen";

	if( !open && methodInfo.className == "methodInfoOpen" )
		methodInfo.className = "methodInfo";
}	


function parameterFolding()
{
	var paramType = event.srcElement.innerText.split(" ")[0];
	var parent = event.srcElement.parentElement.parentElement;
	var plus = event.srcElement.previousSibling;

	var children = parent.childNodes;
	for( i = 0; i < children.length; ++i ) 
	{
		if( children[i].className != "fullXML" )
			continue;

		var fullXML = children[i];
		var firstTimeOpened = (children[i].style.display == '');
		var switchedToTreeView = false;

		if( fullXML.innerText.indexOf( paramType ) == 0)
		{
			if( fullXML.style.display == '' || fullXML.style.display == 'none' )
			{
				fullXML.style.display = 'block';
				plus.innerHTML = '-';
				if( firstTimeOpened )
				{
					var childNode = fullXML.firstChild;
					for( ; childNode != null; childNode = childNode.nextSibling )
						if( childNode.tagName == "U" )
							break;
							
					setParameterPresentation( (childNode)? "Tree": "XML", fullXML);
					switchedToTreeView = true;
				}
			}
			else
			{
				children[i].style.display = 'none';
				plus.innerHTML = '+';
				break;
			}
			
			break;
		}
	}

	updateMethodInfoClass( parent );

	event.cancelBubble = true;
}

function setSelectionOnXML( fullXML )
{
	var range = document.selection.createRange();

	var xmlChildren = fullXML.children;
	for( j = 0; j < xmlChildren.length; ++j )
	{
		if( xmlChildren[j].tagName != 'DIV' )
			continue; 

		range.moveToElementText( xmlChildren[j] );
		try{ 
			range.select();
		} catch (error) {};
	}
}

function toggleXmlContent()
{
	var xmlLineTag;
	var xmlElemTag = event.srcElement;
	for( ; xmlElemTag; xmlElemTag = xmlElemTag.parentElement )
	{
		if( xmlElemTag.tagName == 'DIV' && xmlElemTag.className == 'c' )
			xmlLineTag = xmlElemTag;

		if( xmlElemTag.tagName == 'DIV' && xmlElemTag.className == 'e' )
			break;
	}
		
	if( !xmlElemTag )
		return;
	
	var xmlElemToHide;	
		
	if( xmlLineTag )
	{
		var children = xmlElemTag.childNodes;
		for( i = 0; i < children.length; ++i ) 
		{
			if( children[i].tagName != 'DIV' || children[i].className != '' )
				continue;
				
			xmlElemToHide = children[i];		
			if( xmlElemToHide.style.display == 'none' )
			{
				xmlElemToHide.style.display = 'block';
				xmlLineTag.innerHTML = xmlLineTag.innerHTML.replace( /<SPAN class=collapsed><\/SPAN>/, "" );					
			}
			else
			{
				xmlElemToHide.style.display = 'none';
				xmlLineTag.innerHTML += '<SPAN class=collapsed></SPAN>';
			}
			break;
		}				
	} 	
	else
	{
		xmlLineTag = xmlElemTag.children[0];
		if( !xmlLineTag || xmlLineTag.tagName != 'DIV' || xmlLineTag.children.length == 0 )
			return;
			
		xmlElemToHide = xmlLineTag.children[xmlLineTag.children.length - 1];
		if( !xmlElemToHide || xmlElemToHide.tagName != 'B' )
			return;
			
		if( xmlElemToHide.style.display == 'none' )
		{
			xmlElemToHide.style.display = 'inline';
			xmlLineTag.innerHTML = xmlLineTag.innerHTML.replace( /<SPAN class=collapsed><\/SPAN>/, "" );					
		}
		else
		{
			xmlElemToHide.style.display = 'none';
			xmlLineTag.innerHTML = xmlLineTag.innerHTML.replace( /\&gt;/, "&gt;<SPAN class=collapsed></SPAN>" );
		}
	}

	event.cancelBubble = true;
	return true;
}

function openPreferencesDialog()
{
	window.parent.D_QanPreferencies.F_Show();
}

function allPreferencesFoldingCall( doc )
{
	var rule;
	if (doc.styleSheets[0].rules)
	{
		rule = doc.styleSheets[0].rules;
	}
	else
	{
		alert("Stylesheet rules are unreadable. Preferences not available");
		event.srcElement.onclick = "";
		event.srcElement.style.color = "gray";
		return;
	}
	
	if( event.srcElement.innerText.indexOf( "Show" ) == 0)
	{
		setSelections(doc);
		allPreferencesFolding( rule, true )
		event.srcElement.innerText = "Hide preferences";
	}
	else
	{
		allPreferencesFolding( rule, false )
		if( event.srcElement.innerText.indexOf( "Hide" ) == 0)
		{
			event.srcElement.innerText = "Show preferences";
		}
		else
		{
			//find "Hide preferences" and rename with "Show preferences"
			var preferences = doc.body;
			for(var t=0; t < preferences.childNodes.length; t++)
			{
				if (preferences.childNodes[t].className == "menu")
				{
					preferences = preferences.childNodes[t];
					break;
				}
			}
			//HTML->Body->menu->preferences->[preferencesList]
			for(var t=0; t < preferences.childNodes.length; t++)
			{
				if (preferences.childNodes[t].className == "menuitem")
				{
					if( preferences.childNodes[t].innerText.indexOf( "Hide preferences" ) == 0)
					{
						preferences.childNodes[t].innerText = "Show preferences";
						return;
					}
				}
			}
		}
	}
}
	
function allPreferencesFolding( rule, open )
{
	
	for (var i = 0; i < rule.length; i++)
	{
		if (rule[i].selectorText == ".preferences" ) 
		{
			if(open)
				rule[i].style.display="block";
			else
				rule[i].style.display="none";
			return;
		}
	}
}

function saveANDapplyPreferences( doc )
{
	inputPreferences(doc);
	savePreferences(doc);
	applyPreferences(doc);
}

function loadANDapplyPreferences( doc )
{
	loadPreferences(doc);
	applyPreferences(doc);
}

function applyPreferences( doc )
{	
	var rule;
	if (doc.styleSheets[0].rules)
	{
		rule = doc.styleSheets[0].rules;
	}
	else
	{
		alert("Stylesheet rules are unreadable. Preferences not available");
		event.srcElement.onclick = "";
		event.srcElement.style.color = "gray";
		return;
	}
	
	var fullXMLhit = false;
	var providersListTemp = [];
	providersListTemp = providersListTemp.concat(providersList);
	var highlightListTemp = [];
	highlightListTemp = highlightListTemp.concat(highlightList);
	
	for (var i = 0; i < rule.length; i++)
	{	//changes the <style> to apply color scheme throughout log
		var selectorText = rule[i].selectorText;
		if(!selectorText) continue;
		
		switch (selectorText)
		{
			case ".nHL":
				rule[i].style.display = nHLdisplay;
				break;
			case ".nHLtimeStamp":
				rule[i].style.display = nHLtimeStamp;
				rule[i].style.color = dark;
				break;
			case ".timeStamp":
				rule[i].style.display = timeStamp;
				rule[i].style.color = dark;
				break;
			
			case ".methodHeader EM":
			case ".methodHeader SMALL":
			case ".preference":
			case ".tree":
			case ".action":
				rule[i].style.background = light;
				break;
			case ".methodInfoOpen":
				rule[i].style.background = medL;
				break;
			case ".providerName":
				rule[i].style.color = dark;
				break;
			case ".nodeDetails":
				rule[i].style.background = medL;
				break;
			case ".queryItem":
			case ".queryExpr":
				rule[i].style.background = light;
				break;
			case ".preferences":
				rule[i].style.color = dark;
				rule[i].style.background = medL;
				break;
			case ".fullXML":
				if (!fullXMLhit)
				{
					rule[i].style.background = light;
					fullXMLhit = true;
				}
				break;
			default:
				for (var j = 0; j < providersListTemp.length; j++)
				{
					if (selectorText == providersListTemp[j])
					{
						switch (highlightListTemp[0])
						{
							case undefined:
								break;
							case "none":
								rule[i].style.display = "";
								rule[i].style.background = "";
								break;
							case "hide":
								rule[i].style.display = "none";
								rule[i].style.background = "";
								break;
							default:
								rule[i].style.display = "";
								rule[i].style.background = colorLookup(highlightListTemp[0]);
						}
						providersListTemp.shift();
						highlightListTemp.shift();highlightListTemp
					}
				}
		}
	}
}

var usingCookie = false;
var filename = "\\..\\templates\\qfw\\QF_Logging_preferences.css" //reset in load
var timeStamp;
var nHLtimeStamp;
var nHLdisplay;
var highlightList;
var highlightColor;

var providersList = [".QFS", 
					".CoordinationPlanner", 
					".RefinerProvider", 
					".ZeroSuppressProvider", 
					".MDOperationProvider", 
					".CubeBuildProvider", 
					".NoDataModeProvider", 
					".ReporterModeProvider", 
					".TabularFuncProvider", 
					".TabularOperationProvider", 
					".RelationalQueryProvider", 
					".OlapQueryProvider", 
					".PowerCubeODP", 
					".SAPBWODP", 
					".SAPBWODP2", 
					".MSAnalysisODP", 
					".MasterDetailProvider"]

var light;
var medL;
var medD;
var dark;

function loadPreferences( doc )
{
	if( doc.body.client == "CRN" )
	{
		usingCookie = true;
	}

	if(usingCookie)
	{
		timeStamp = manipulateCookie( doc, "timeStamp", "?" ) || manipulateCookie( doc, "timeStamp", "none" );
		nHLtimeStamp = manipulateCookie( doc, "nHLtimeStamp", "?" ) || manipulateCookie( doc, "nHLtimeStamp", "none" );
		nHLdisplay = manipulateCookie( doc, "minors", "?" ) || manipulateCookie( doc, "minors", "none" );
		highlightList = manipulateCookie( doc, "providers", "?" ) || ["none","none","none","none","none","none","none","none","none","none","none","none","none","none","none","none","none"];
		highlightColor = manipulateCookie( doc, "color", "?" ) || manipulateCookie( doc, "color", "blue" );
		colorScheme( highlightColor );
	}
	else
	{
		filename = doc.body.childNodes[0].innerText + filename; //gets binFolder and makes path for prefs file
		readPrefsCss();
	}
}

function inputPreferences( doc )
{
	var nodeList = [];
	var parentEvent = event.srcElement.parentElement.childNodes; //HTML->Body->preferences->[preferenceList]
	for (var i = 0; i < parentEvent.length; i++)
	{
		if (parentEvent[i].id)
		{
			switch (parentEvent[i].id) //HTML->Body->preferences->preference
			{
				case "timestamp":
					if(usingCookie) manipulateCookie( doc, "timeStamp", "kill" );
					if(usingCookie) manipulateCookie( doc, "nHLtimeStamp", "kill" );
					//HTML->Body->menu->preferences->timeStamp->select->option->preferenceOption
					var preferences = parentEvent[i];
					for(var t=0; t < preferences.childNodes.length; t++)
					{
						if ( preferences.childNodes[t].innerText )
						{
							preferences = preferences.childNodes[t];
							break;
						}
					}
					for(var t=0; t < preferences.length; t++)
					{
						if( preferences[t].selected )
						{
							var temp = preferences[t].value.split(", ");
							timeStamp = temp[0];
							nHLtimeStamp = temp[1];
							break;
						}
					}
					break;
				case "minors":
					if(usingCookie) manipulateCookie( doc, "minors", "kill" );
					//HTML->Body->menu->preferences->minors->select->option->preferenceOption
					var preferences = parentEvent[i];
					for(var t=0; t < preferences.childNodes.length; t++)
					{
						if ( preferences.childNodes[t].innerText )
						{
							preferences = preferences.childNodes[t];
							break;
						}
					}
					for(var t=0; t < preferences.length; t++)
					{
						if( preferences[t].selected )
						{
							nHLdisplay = preferences[t].value
							break;
						}
					}
					break;
				case "providers":
					highlightList = [];	//resets highlightList
					if(usingCookie) manipulateCookie( doc, "providers", "kill" );
					//HTML->Body->menu->preferences->providers->preferenceOption->select->option
					var preferences = parentEvent[i];
					for(var t=0; t < preferences.childNodes.length; t++)
					{
						if ( preferences.childNodes[t].innerText )
						{
							for(var s=0; s < preferences.childNodes[t].childNodes.length; s++)
							{
								if ( preferences.childNodes[t].childNodes[s].innerText )
								{
									for(var r=0; r < preferences.childNodes[t].childNodes[s].childNodes.length; r++)
									{
										if ( preferences.childNodes[t].childNodes[s].childNodes[r].innerText )
										{
											if( preferences.childNodes[t].childNodes[s].childNodes[r].selected )
											{
												highlightList.push( preferences.childNodes[t].childNodes[s].childNodes[r].value );
												break;
											}
										}
									}
								}
							}
						}
					}
					break;
				case "color":
					if(usingCookie) manipulateCookie( doc, "color", "kill" );
					//HTML->Body->menu->preferences->minors->select->option->preferenceOption
					var preferences = parentEvent[i];
					for(var t=0; t < preferences.childNodes.length; t++)
					{
						if ( preferences.childNodes[t].innerText )
						{
							preferences = preferences.childNodes[t];
							break;
						}
					}
					for(var t=0; t < preferences.length; t++)
					{
						if( preferences[t].selected )
						{
							highlightColor = preferences[t].value
							break;
						}
					}
					colorScheme( highlightColor );
					break;
			}	
		}
	}
}

function savePreferences( doc )
{
	if (usingCookie)
	{
		manipulateCookie( doc, "timeStamp", timeStamp);
		manipulateCookie( doc, "nHLtimeStamp", nHLtimeStamp );
		manipulateCookie( doc, "minors", nHLdisplay );
		manipulateCookie( doc, "providers", highlightList );
		manipulateCookie( doc, "color", highlightColor);
	}
	else
	{
		fso = getFileSystemObject();
		
		if( fso == null )
		{
			usingCookie = true;
			savePreferences( doc );
			return;
		}
		
		writePrefsCss();
		
	}
}

function manipulateCookie( doc, name, value )
{
	if (value == "?")
	{//load
		if(name == "providers")
		{
			var cookieJar = doc.cookie.split(";");
			for (var i=0; i < cookieJar.length; i++)
			{
				if(cookieJar[i].indexOf(name) != -1)
				{
					var providers = cookieJar[i].substr( cookieJar[i].indexOf("=")+1, cookieJar[i].length ).split(",");
					return providers;
				}
			}
			return null;
		}
		
		var cookieJar = doc.cookie.split(";");
		for (var i=0; i < cookieJar.length; i++)
		{
			if(cookieJar[i].indexOf(name) != -1) return cookieJar[i].substr( cookieJar[i].indexOf("=")+1, cookieJar[i].length );
		}
		return null;
	}
	else if( value == "kill" )
	{//erase
		expiD = new Date();
		expiD.setTime( expiD.getTime() - 1 ); //makes expiry in the past, thus erasing the cookie
		doc.cookie = name + "=" + value + ";expires=" + expiD.toUTCString();
		return;
	}
	else
	{//save
		expiD = new Date();
		expiD.setTime( expiD.getTime() + 600000000 ); //adds one week to date
		doc.cookie = (name + "=" + value + ";expires=" + expiD.toUTCString() + ";path=/");
		return value;
	}
}

function writePrefsCss()
{
	fso = getFileSystemObject();
	
	// modifies .css file
	var pref;
	pref = fso.CreateTextFile( filename , true);

	pref.WriteLine( value2Rule( 1, timeStamp ) );
	pref.WriteLine( value2Rule( 2, nHLtimeStamp ) );
	pref.WriteLine( value2Rule( 3, nHLdisplay ) );
	pref.WriteLine( value2Rule( 4, highlightList ) );
	pref.WriteLine( value2Rule( 5, highlightColor ) );
		
	pref.Close();
}

function value2Rule( ruleNum, text )
{
	return ".rule" + ruleNum + " { background-image: url(" + text + ") }" ;
}

function readPrefsCss()
{
	if( document.styleSheets.length < 4 || document.styleSheets[3].rules.length < 5)
	{
		//alert( "No preferences file found. Setting defaults" );
		setDefaults();
		return;
	}	
	
	var v_cssPrefs = document.styleSheets[3];
	
	timeStamp = rule2Value( v_cssPrefs.rules[0] );
	nHLtimeStamp = rule2Value( v_cssPrefs.rules[1] );
	nHLdisplay  = rule2Value( v_cssPrefs.rules[2] );
	highlightList = rule2Value( v_cssPrefs.rules[3] ).split(",");
	highlightColor = rule2Value( v_cssPrefs.rules[4] );
	colorScheme( highlightColor );
}

function rule2Value( cssRule )
{
	return cssRule.style.backgroundImage.replace( /url\(/, "" ).replace( /\)/, "" );
}

function verifyPrefs(doc)
{
	if(usingCookie)
	{
		alert( "Cookie:\n" + doc.cookie );
		return;
	}
	
	readPrefsCss();
	
	alert( filename + ":\n\n"
			+ "timeStamp: " + timeStamp
			+ "\nnHLtimeStamp: " + nHLtimeStamp
			+ "\nnHLdisplay: " + nHLdisplay
			+ "\nhighlightList: " + highlightList
			+ "\nhighlightColor: " + highlightColor )
}

function setDefaults(doc)
{
	if(usingCookie)
	{
		timeStamp = manipulateCookie( doc, "timeStamp", "none" );
		nHLtimeStamp = manipulateCookie( doc, "nHLtimeStamp", "none" );
		nHLdisplay = manipulateCookie( doc, "minors", "none" );
		highlightList = ["none","none","none","none","none","none","none","none","none","none","none","none","none","none","none","none","none"];
		highlightColor = manipulateCookie( doc, "color", "blue" );
		colorScheme( highlightColor );
		return;
	}
	
		
	timeStamp = "none";
	nHLtimeStamp = "none";
	nHLdisplay = "none";
	highlightList = ["none","none","none","none","none","none","none","none","none","none","none","none","none","none","none","none","none"];
	highlightColor = "blue";
	colorScheme( highlightColor );
}

function setSelections(doc)
{
	//select proper options in preferences drop-down

	//HTML->Body->menu
	var preferences = doc.body;
	for(var t=0; t < preferences.childNodes.length; t++)
	{
		if (preferences.childNodes[t].className == "menu")
		{
			preferences = preferences.childNodes[t];
			break;
		}
	}
	//HTML->Body->menu->preferences->[preference]
	for(var t=0; t < preferences.childNodes.length; t++)
	{
		if (preferences.childNodes[t].className == "preferences")
		{
			preferences = preferences.childNodes[t].childNodes;
			break;
		}
	}
	
	var preference;
	for (var i=0; i < preferences.length; i++)
	{
		preference = preferences[i];
		if(preference.id)
		{
			var optionList = preference.childNodes;
			switch (preference.id)
			{
				case "timestamp":
					selectionSet( optionList, ("" + timeStamp + ", " + nHLtimeStamp) );
					break;
				case "minors":
					selectionSet( optionList, nHLdisplay );
					break;
				case "providers":
					var highlightIndex = 0;
					//HTML->Body->menu->preferences->preference->providers->preferenceOptionList
					for(var t1=0; t1 < optionList.length; t1++)
					{
						if (optionList[t1].providerClass)
						{
							selectionSet( optionList[t1].childNodes, highlightList[highlightIndex] )
							highlightIndex++;
						}
					}
					break;
				default:	//case "color":
					selectionSet( optionList, highlightColor );
			// end of switch
			}
		}
	}
}

function selectionSet( optionList, expectedValue )
{
	//HTML->Body->menu->preferences->preference->(id)->select->[options]
	for(var t1=0; t1 < optionList.length; t1++)
	{
		if (optionList[t1].innerText)
		{
			//HTML->Body->menu->preferences->preference->(id)->select->option
			for(var t2=0; t2 < optionList[t1].childNodes.length; t2++)
			{
				if ( optionList[t1].childNodes[t2].value == expectedValue)
				{
					optionList[t1].childNodes[t2].selected = "selected";
					break;
				}
			}
		}
	}
}

function colorScheme( color )
{
	switch (color)
	{
		case "red":
			light = "#ffcccc"
			medL = "#ff9999"
			medD = "#ff0000"
			dark = "#cc0000"
			break;
		case "orange":
			light = "#ffcccc"
			medL = "#ffcc99"
			medD = "#ff6600"
			dark = "#cc3300"
			break;
		case "yellow":
			light = "#ffffcc"
			medL = "#ffff99"
			medD = "#ffcc00"
			dark = "#cc9900"
			break;
		case "green":
			light = "#ccffcc"
			medL = "#99ff99"
			medD = "#00cc00"
			dark = "#009900"
			break;
		case "cyan":
			light = "#ccffff"
			medL = "#99ffff"
			medD = "#009999"
			dark = "#006666"
			break;
		case "purple":
			light = "#ffccff"
			medL = "#cc99ff"
			medD = "#660099"
			dark = "#330066"
			break;
		case "pink":
			light = "#ffccff"
			medL = "#ff99cc"
			medD = "#cc0099"
			dark = "#990066"
			break;
		case "grey":
			light = "#cccccc"
			medL = "#999999"
			medD = "#666666"
			dark = "#333333"
			break;
		default: //case "blue":
			light = "#f0f0ff"
			medL = "#9999ff"
			medD = "#0033cc"
			dark = "#003399"
	}
}

function colorLookup( color )
{
	switch (color)
	{
		case "red":
			return "#ffdddd";
		case "orange":
			return "#ffddcc";
		case "yellow":
			return "#ffffcc";
		case "green":
			return "#ddffdd";
		case "cyan":
			return "#ddffff";
		case "purple":
			return "#cc99ff";
		case "pink":
			return "#ffccdd";
		case "grey":
			return "#dddddd";
		default: //case "blue":
			return "#ddddff";
	}
}


function formatXMLFromString( fullXML )
{
	var v_elChild = fullXML.firstChild;
	for( ; v_elChild; v_elChild = v_elChild.nextSibling )
		if( v_elChild.className == "xmltext" )
		{
			var v_xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
			v_xmlDoc.async = false;
			var v_sXML = v_elChild.innerHTML.replace( /\<\?xml\:namespace[^\>]*\/\>/g, "" );
			// v_sXML = v_sXML.replace( /\<qs\:command /,  '<qs:command xmlns:qs="qs" xmlns:SOAP="soap"  xmlns:md="md" xmlns:x="x" ' );
			v_sXML = '<x xmlns:qs="qs" xmlns:SOAP="soap" xmlns:md="md" xmlns:x="x">' + v_sXML + '</x>';
			v_xmlDoc.loadXML( v_sXML );
			if( !v_xmlDoc.documentElement || !v_xmlDoc.documentElement.childNodes[0] )
				return;
				
			var v_aFormattedXML = [];
			formatXMLNode( v_xmlDoc.documentElement.childNodes[0], v_aFormattedXML );
			fullXML.innerHTML += v_aFormattedXML.join('');
		}
}
function formatXMLName( elName )
{
	if( elName.nodeName == "x:el" )
		return elName.getAttribute( "en" );
		
	return elName.nodeName;
}

function formatXMLNode( elNode, aFormattedHTML )
{
	if( elNode.selectNodes("x:at").length == elNode.childNodes.length )
	{
		aFormattedHTML.push(  '<DIV class="e">&lt;' + formatXMLName(elNode) );
		formatXMLNodeAttrs( elNode, aFormattedHTML ) 
		aFormattedHTML.push( '/&gt;</DIV>' );
			
		return;
	}
	
	if( elNode.selectNodes( '.[text() and not (comment())]' ).length )
	{
		aFormattedHTML.push(  '<DIV class="e" ondblclick="toggleXmlContent();"><DIV>&lt;' + formatXMLName(elNode) ); 
		formatXMLNodeAttrs( elNode, aFormattedHTML ) 
		aFormattedHTML.push(  '&gt;' );
		formatXMLNodeChildren( elNode, aFormattedHTML ); 
		aFormattedHTML.push(  '&lt;/' + formatXMLName(elNode) + '&gt;' );
		aFormattedHTML.push(  '</DIV></DIV>' );
	}
	else
	{
		aFormattedHTML.push( '<DIV class="e"><DIV class="c" ondblclick="toggleXmlContent();">&lt;' + formatXMLName(elNode) );
		formatXMLNodeAttrs( elNode, aFormattedHTML ); 
		aFormattedHTML.push( '&gt;</DIV><DIV>' );
		formatXMLNodeChildren( elNode, aFormattedHTML ); 
		aFormattedHTML.push( '<DIV>&lt;/' + formatXMLName(elNode) + '&gt;</DIV></DIV></DIV>' );
	}	
}

function formatXMLText( nText, aFormattedHTML )
{
	aFormattedHTML.push( '<B class="t">' + nText.text.F_XMLEEncode() + '</B>' );
}

function formatXMLComment( nComment, aFormattedHTML )
{
	aFormattedHTML.push( '<DIV class="k"><PRE>&lt;!--'  + nComment.text.F_XMLEEncode() + '--&gt;</PRE></DIV>' );
}


function formatXMLNodeAttrs( elNode, aFormattedHTML ) 
{
	for( var i = 0; i < elNode.childNodes.length; ++i )
	{
		if( elNode.childNodes[i].nodeName != 'x:at' )
			continue; 
			
		aFormattedHTML.push( ' ' + elNode.childNodes[i].getAttribute("n") + '="<B>' + 
							elNode.childNodes[i].text.F_XMLEEncode() + '"</B>' ); 
	}
}


function formatXMLNodeChildren( elNode, aFormattedHTML ) 
{
	var v_nChild = elNode.firstChild;
	for( ; v_nChild; v_nChild = v_nChild.nextSibling )
	{
		if( v_nChild.nodeName == "x:at" )
			continue;

		if( v_nChild.nodeType == 1 )
			formatXMLNode( v_nChild, aFormattedHTML );
		else if( v_nChild.nodeType == 3 )
			formatXMLText( v_nChild, aFormattedHTML );
		else if( v_nChild.nodeType == 8 )
			formatXMLComment( v_nChild, aFormattedHTML );	
	}
}



String.prototype.F_XMLEEncode = function()
{
	return this.replace( /&/g, "&amp;amp;" ).replace( /</g, "&amp;lt;" ).replace( />/g, "&amp;gt;" ).replace( /'/g, "&amp;apos;" ).replace( /"/g, "&amp;quot;" );
};