analytics/templates/ps/qs/calcConcat.xts

<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed Materials - Property of IBM

BI and PM: qs

(C) Copyright IBM Corp. 2001, 2017

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 (R) is a trademark of Cognos ULC, (formerly Cognos Incorporated).
-->

<!--
Used for concatenation
-->
<xts:morphlet resolverBase="prompting" version="1.0" xmlns:xts="http://developer.cognos.com/schemas/xts/" messageBase="messages/QSRVUITextPL.xml,messages/portal.xml,messages/portalRL.xml" requiredCapability="canUseQueryStudio">
	<xts:block id="browserDetection" path="qs/browserDetection.xslt" mode="interpret" type="exec" processor="XSLT" contentId="browserDetection" partId="1"/>

    <xts:block id="page" type="exec" mode="output" processor="XSLT" mimeType="text/html" dependency="browserDetection">

        <!-- get the debug logic sheet -->
        <xts:logicsheet path="logicsheets/debuglogic.xslt"/>

        <!-- get the new theme stuff -->
        <!-- apply the following logicsheets in order -->
        <xts:logicsheet path="qs/logicsheets/calc_theme.xsl"/>
        <xts:logicsheet path="logicsheets/portal.xsl"/>
        <xts:logicsheet path="qs/logicsheets/dialogs.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/dialog/framework.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/layout.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/dialog/presentation.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/controls/framework.xsl"/>
        <xts:logicsheet path="logicsheets/presentation/controls/presentation.xsl"/>
        <xts:logicsheet path="logicsheets/cm-logic.xsl"/>

        <!-- apply the form logic -->
        <xts:logicsheet path="logicsheets/formlogic.xslt"/>
        <xsl:stylesheet version="1.0"
			xmlns:clcdlg="test_calculationDlg"
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:xts="http://developer.cognos.com/schemas/xts/"
			xmlns:lyt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/layout/"
			xmlns:pf="http://developer.cognos.com/schemas/xts/pf"
			xmlns:dp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/presentation/"
			xmlns:df="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/framework/"
			xmlns:cp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/presentation/"
			xmlns:cf="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/framework/"
			xmlns:dbg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/debug/"
			xmlns:qsdlg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/qs/dialog/"
			xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt"
			exclude-result-prefixes="clcdlg xsl xts lyt pf dp df cp cf dbg qsdlg xtsext">

            <xsl:output method="html" version="1.0" encoding="UTF-8" indent="no"/>

			<!-- Default variables (like skin) and prompt variables -->
			<qsdlg:variables/>
			<qsdlg:promptVariables/>

			<!-- Prompt Control XSL include -->
            <xsl:include href="p_include.xsl"/>

            <!-- add any theme variables -->
            <df:variables/>
            <pf:variables/>

            <!-- start the output -->
            <xsl:template match="/root">
                <dp:page>
                    <dp:script>


		    	       	<xsl:call-template name="getPromptCommonIncludes"/>

						<xsl:call-template name="gettextBoxIncludes">
		    	        	<xsl:with-param name="promptLocale" select="$promptLocale"/>
		        			<xsl:with-param name="promptContentLocale" select="$contentLocale"/>
		    			</xsl:call-template>

						<link href="{$qsdlgskin}/qs/QSRVDialog.css" type="text/css" rel="stylesheet"/>
                        <script type="text/javascript">
                        	<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/layout.js</xsl:attribute>
                        	<xsl:text/>//<xsl:text/>
                        </script>
                        <script type="text/javascript">
                        	<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/dialogs/concatDlg.js</xsl:attribute>
                        	<xsl:text/>//<xsl:text/>
                        </script>
				<script type="text/javascript">
                        	<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/rv/cvConstants.js</xsl:attribute>
                        	<xsl:text/>//<xsl:text/>
                        </script>
						<script type="text/javascript">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/rv/common.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>
                        <script type="text/javascript">
                        	<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/rv/cvui.js</xsl:attribute>
                        	<xsl:text/>//<xsl:text/>
                        </script>
                        <script type="text/javascript">
                        	<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/common/framework/notification/CObserver.js</xsl:attribute>
                        	<xsl:text/>//<xsl:text/>
                        </script>
						<script type="text/javascript">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/classes/CDialogManager.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>
						<script type="text/javascript">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/classes/CWindowManager.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>
						<script type="text/javascript">&lt;!--
var goDialogManager = new CDialogManager();
                            <clcdlg:jvs/>
var cf = getConfigFrame();
var calcType = cf.dlgGlobalGetParm('xxCalcType');
var substVarValuePreceding = '';
var substVarValueFollowing = '';
var substVarValueMiddle = '';

function execute()
{
	var calcOp = "";
	var calcFormat = "none";
	var before_col_id = cf.dlgGlobalGetParm('xxInsBeforeColid');

	switch (calcType)
	{
		case "number":
			calcOp = "concatNumber";
			break;
		case "datetime":
			calcOp = "concatDatetime";
			break;
		case "string":
			calcOp = "concatString";
			break;
		case "interval":
			calcOp = "concatInterval";
			break;
		default:
			calcOp = "concatDefault";
			break;
	}

	var sCalcExpr = generateText(goDialogManager.getMiniQueryManager().getListSeparator());
	if (sCalcExpr !== "")
	{
		var calcName = getCalcName();
		getConfigFrame().addCalcColumn(before_col_id, sCalcExpr, sCalcExpr, calcName, "none", calcOp, "none", calcFormat, 62, 7, "none", -1, "none"); //calcBy,calcBase="none",calculationType=62,usage=7,regularAgg="none",promptType=-1,detailAgg="none"
    }
}

function generateName (withQuotes)
{
	var first = "";
	var second = "";
	var middle = "";
	var calcName = document.f.repSel.options[0].text;

	if (document.f.preceding.checked)
	{
		if (document.getElementById("textBoxString1").style.display != "none")
			first = document.f.firsttext.value;
		else
			first = textBoxstringPrecedingValue.m_oForm.value;
	}
	if (document.f.following.checked)
	{
		if (document.getElementById("textBoxString2").style.display != "none")
			second = document.f.secondtext.value;
		else
			second = textBoxstringFollowingValue.m_oForm.value;
	}
	if (document.f.middletext &amp;&amp; document.f.middle[1].checked == true)
		middle = " ";
	else if (document.f.middletext &amp;&amp; document.f.middle[2].checked == true)
	{
		if (document.getElementById("textBoxString3").style.display != "none")
			middle = document.f.middletext.value;
		else
			middle = textBoxstringMiddleValue.m_oForm.value;
	}
	for (var i = 1; i &lt; document.f.repSel.options.length; i++)
		calcName += middle + document.f.repSel.options[i].text;
	if (first != "")
		calcName = first + calcName;
	if (second != "")
		calcName += second;
    return calcName;
}

function updateValueFieldConcat(field, regularInput, constInput, substString, substValue)
{
	if (substString == null)
	{
		if (document.getElementById("textBox" + field).style.display != "none")
			regularInput.select();
		else
		{
			constInput.clear();
			document.getElementById("textBox" + field + "Constant").style.display = "none";
			if (document.all)
				document.getElementById("textBox" + field).style.display = "inline";
			else
				document.getElementById("textBox" + field).style.display = "table-cell";
			regularInput.select();
			onSelOperation();
		}
	}
	else
	{
		regularInput.value="";
		document.getElementById("textBox" + field).style.display="none";
		if (document.all)
			document.getElementById("textBox" + field + "Constant").style.display="inline";
		else
			document.getElementById("textBox" + field + "Constant").style.display="table-cell";
		constInput.m_oForm.value = substString;
		if (field == "String1")
		{
			substVarValuePreceding = substValue;
			topTextGotFocus()
		}
		else if (field == "String2")
		{
			substVarValueFollowing = substValue;
			bottomTextGotFocus()
		}
		else
		{
			substVarValueMiddle = substValue;
			middleTextGotFocus()
		}
	}
}

function init()
{
	attachMouseEvents();

	for (var i = 0; i &lt; cf.dlgGlobalSize('xxColInfo'); i++)
	{
		var label = cf.dlgGlobalGetParmAt('xxColInfo', i);
		document.f.repSel.options[document.f.repSel.options.length] = new Option(label[0], label[1]);
	}

	var validCalcs = new Array();
	if (cf.dlgGlobalSize('xxColInfo') > 1)
		document.getElementById("displaySpacing").style.visibility = "visible";
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxValidCalcItem'); i++)
		validCalcs[validCalcs.length] = cf.dlgGlobalGetParmAt('xxValidCalcItem', i);

    populateCalculationList(calcType, validCalcs, "text");
    // select calculation
    document.f.calcList.selectedIndex = cf.dlgGlobalGetParm('xxCalcTypeIdx');
	if (cf.dlgGlobalGetParm('xxCalcSubTypeIdx') != null)
		document.f.calcNumberList.selectedIndex = cf.dlgGlobalGetParm('xxCalcSubTypeIdx');
    loadHint();
	addInsert();
	setGlobals(calcType, false);
	document.f.firsttext.focus();

	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
		//draw the first substitution variable button for the "preceding" field
		var buttonContainerStyle = new CUIStyle('mainHeader3', '', '', '', '');
		var buttonStyle = new CUIStyle('dialogButton', 'dialogButtonOver', '', '', '');

		var menuItemStyle = new CUIStyle('menuItem_normal', 'menuItem_hover', '', '', 'menuItem_disabled');
		var menuStyle = new CUIStyle('clsMenu', '', '', '', '');

		var substButtonContainer = new CBar('buttonContainer1', buttonContainerStyle, null, '<xsl:value-of select="$webRoot"/>/common/images/toolbar/');
		var bHideMenuButton = true;
		var substButton = new CToolbarButton(substButtonContainer, '', '<xsl:value-of select="$webRoot"/>/qs/images/substitution_variables.gif', '', buttonStyle, true, null, null, '<xsl:value-of select="$webRoot"/>');

		var substButtonDropDown = substButton.createDropDownMenu(menuStyle);
		new CMenuItem(substButtonDropDown, "<xts:string id="CALCULATION_STRING_SUBST_VAR" encode="javascript"/>", 'javascript:updateValueFieldConcat("String1", document.f.firsttext, textBoxstringPrecedingValue, null, null);', '', menuItemStyle, '<xsl:value-of select="$webRoot"/>', '<xsl:value-of select="$skin_root"/>');

		var numConstants = cf.dlgGlobalSize("xxSubstVarPair");

		for (var i = 0; i &lt; numConstants; i++)
		{
			var substVarPair = cf.dlgGlobalGetParmAt('xxSubstVarPair', i)
			new CMenuItem(substButtonDropDown, substVarPair[0], 'javascript:updateValueFieldConcat("String1", document.f.firsttext, textBoxstringPrecedingValue, "' + substVarPair[0] + '", "' + substVarPair[1] + '");', '', menuItemStyle, '<xsl:value-of select="$webRoot"/>', '<xsl:value-of select="$skin_root"/>');
		}

		substButtonContainer.setMenuType(cHorizonalBar);
		substButtonContainer.setAlign('left');
		substButtonContainer.draw();

		//draw the second substitution variable button for the "following" field
		substButtonContainer = new CBar('buttonContainer2', buttonContainerStyle, null, '<xsl:value-of select="$webRoot"/>/common/images/toolbar/');
		substButton = new CToolbarButton(substButtonContainer, '', '<xsl:value-of select="$webRoot"/>/qs/images/substitution_variables.gif', '', buttonStyle, true, null, null, '<xsl:value-of select="$webRoot"/>');
		substButtonDropDown = substButton.createDropDownMenu(menuStyle);
		new CMenuItem(substButtonDropDown, "<xts:string id="CALCULATION_STRING_SUBST_VAR" encode="javascript"/>", 'javascript:updateValueFieldConcat("String2", document.f.secondtext, textBoxstringFollowingValue, null, null);', '', menuItemStyle, '<xsl:value-of select="$webRoot"/>', '<xsl:value-of select="$skin_root"/>');

		for (var i = 0; i &lt; numConstants; i++)
		{
			var substVarPair = cf.dlgGlobalGetParmAt('xxSubstVarPair', i)
			new CMenuItem(substButtonDropDown, substVarPair[0], 'javascript:updateValueFieldConcat("String2", document.f.secondtext, textBoxstringFollowingValue, "' + substVarPair[0] + '", "' + substVarPair[1] + '");', '', menuItemStyle, '<xsl:value-of select="$webRoot"/>', '<xsl:value-of select="$skin_root"/>');
		}

		substButtonContainer.setMenuType(cHorizonalBar);
		substButtonContainer.setAlign('left');
		substButtonContainer.draw();

		//draw the third substitution variable button for the "middle" field
		substButtonContainer = new CBar('buttonContainer3', buttonContainerStyle, null, '<xsl:value-of select="$webRoot"/>/common/images/toolbar/');
		substButton = new CToolbarButton(substButtonContainer, '', '<xsl:value-of select="$webRoot"/>/qs/images/substitution_variables.gif', '', buttonStyle, true, null, null, '<xsl:value-of select="$webRoot"/>');
		substButtonDropDown = substButton.createDropDownMenu(menuStyle);
		new CMenuItem(substButtonDropDown, "<xts:string id="CALCULATION_STRING_SUBST_VAR" encode="javascript"/>", 'javascript:updateValueFieldConcat("String3", document.f.middletext, textBoxstringMiddleValue, null, null);', '', menuItemStyle, '<xsl:value-of select="$webRoot"/>', '<xsl:value-of select="$skin_root"/>');

		for (var i = 0; i &lt; numConstants; i++)
		{
			var substVarPair = cf.dlgGlobalGetParmAt('xxSubstVarPair', i)
			new CMenuItem(substButtonDropDown, substVarPair[0], 'javascript:updateValueFieldConcat("String3", document.f.middletext, textBoxstringMiddleValue, "' + substVarPair[0] + '", "' + substVarPair[1] + '");', '', menuItemStyle, '<xsl:value-of select="$webRoot"/>', '<xsl:value-of select="$skin_root"/>');
		}

		substButtonContainer.setMenuType(cHorizonalBar);
		substButtonContainer.setAlign('left');
		substButtonContainer.draw();
		//hide the input field for the substitution variable constants
		document.getElementById("textBoxString1Constant").style.display = "none";
		document.getElementById("textBoxString2Constant").style.display = "none";
		document.getElementById("textBoxString3Constant").style.display = "none";
		<xsl:choose>
			<xsl:when test="/root/browserInfo/isNS6='true'">
				textBoxstringPrecedingValue.m_oForm.addEventListener("change", topTextGotFocus, true);
				textBoxstringFollowingValue.m_oForm.addEventListener("change", bottomTextGotFocus, true);
				textBoxstringMiddleValue.m_oForm.addEventListener("change", middleTextGotFocus, true);
			</xsl:when>
			<xsl:otherwise>
				textBoxstringPrecedingValue.m_oForm.attachEvent("onchange", topTextGotFocus);
				textBoxstringFollowingValue.m_oForm.attachEvent("onchange", bottomTextGotFocus);
				textBoxstringMiddleValue.m_oForm.attachEvent("onchange", middleTextGotFocus);
			</xsl:otherwise>
		</xsl:choose>
	</xsl:if>
	checkOverflowOnSelect(document.f.repSel);
}

function topTextGotFocus()
{
	document.f.preceding.checked=true;
	onSelOperation();
}

function bottomTextGotFocus()
{
	document.f.following.checked=true;
	onSelOperation();
}

function middleTextGotFocus()
{
	document.f.middle[2].checked=true;
	onSelOperation();
}
                        //--&gt;</script>
                    </dp:script>
					<form style="margin:0px" name="f" method="POST" onsubmit="execute();return false;">
						<table border="0" cellspacing="0" cellpadding="0" height="100%" width="100%">
							<tr>
								<td width="100%" height="0%">
									<!-- dialog header -->
									<clcdlg:basic_header/>
								</td>
							</tr>
							<tr>
								<td width="100%" height="100%" valign="top">
									<lyt:layout style="2" border="no">
										<lyt:section>
											<xsl:if test="/root/env/param[@name='xxCalcType']='number'">
												<clcdlg:calculationsType/>
											</xsl:if>
											<clcdlg:calculations/>
											<dp:input>
												<dp:section1>
													<xts:string id="CALCULATION_SEL_REP_ITEMS"/>
												</dp:section1>
												<dp:section2>
													<select name="repSel" size="6" style="width:260"/>
												</dp:section2>
											</dp:input>
											<dp:input>
												<dp:section1/>
												<dp:section2>
													<dp:choice>
														<dp:section1>
															<input type="checkbox" name="preceding" onClick="javascript:onSelOperation();">
																<xts:string id="CALCULATION_PRECEDING_TEXT"/>
															</input>
														</dp:section1>
														<dp:section2>
															<table>
																<tr>
																	<td id="textBoxString1" valign="bottom">
																		<input type="text" name="firsttext" onClick="javascript:topTextGotFocus();" onKeyDown="setTimeout(topTextGotFocus, 10);">
																			<xsl:if test="/root/system/param[@name='disableEnterKeyAutoSubmit'] != 'true'">
																				<xsl:attribute name="onKeyUp">javascript:if (event.keyCode == 13) execute();</xsl:attribute>
																			</xsl:if>
																		</input>
																	</td>
																	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																		<td id="textBoxString1Constant" valign="bottom">
																			<xsl:call-template name="getTextBox">
																				<xsl:with-param name="promptLocale" select="$promptLocale"/>
																				<xsl:with-param name="promptFormName" select="$promptFormName"/>
																				<xsl:with-param name="promptRequired" select="'false'"/>
																				<xsl:with-param name="promptId" select="'stringPrecedingValue'"/>
																				<xsl:with-param name="promptHideText" select="'false'"/>
																				<xsl:with-param name="promptMultiLine" select="'false'"/>
																				<xsl:with-param name="promptParameter" select="'numberParam1'"/>
																				<xsl:with-param name="promptReadOnly" select="'true'"/>
																			</xsl:call-template>
																		</td>
																		<td id="buttonContainer1"/>
																	</xsl:if>
																</tr>
															</table>
														</dp:section2>
														<dp:section1>
															<input type="checkbox" name="following" onClick="javascript:onSelOperation();">
																<xts:string id="CALCULATION_FOLLOWING_TEXT"/>
															</input>
														</dp:section1>
														<dp:section2>
															<table>
																<tr>
																	<td id="textBoxString2" valign="bottom">
																		<input type="text" name="secondtext" onClick="javascript:bottomTextGotFocus();" onKeyDown="setTimeout(bottomTextGotFocus, 10);">
																			<xsl:if test="/root/system/param[@name='disableEnterKeyAutoSubmit'] != 'true'">
																				<xsl:attribute name="onKeyUp">javascript:if (event.keyCode == 13) execute();</xsl:attribute>
																			</xsl:if>
																		</input>
																	</td>
																	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																		<td id="textBoxString2Constant" valign="bottom">
																			<xsl:call-template name="getTextBox">
																				<xsl:with-param name="promptLocale" select="$promptLocale"/>
																				<xsl:with-param name="promptFormName" select="$promptFormName"/>
																				<xsl:with-param name="promptRequired" select="'false'"/>
																				<xsl:with-param name="promptId" select="'stringFollowingValue'"/>
																				<xsl:with-param name="promptHideText" select="'false'"/>
																				<xsl:with-param name="promptMultiLine" select="'false'"/>
																				<xsl:with-param name="promptParameter" select="'numberParam2'"/>
																				<xsl:with-param name="promptReadOnly" select="'true'"/>
																			</xsl:call-template>
																		</td>
																		<td id="buttonContainer2"/>
																	</xsl:if>
																</tr>
															</table>
														</dp:section2>
													</dp:choice>
												</dp:section2>
											</dp:input>
										</lyt:section>
										<lyt:section>
											<clcdlg:calc_hint/>
											<div id="displaySpacing" style="visibility:hidden">
												<dp:section1>
													<div class="formLabel">
														<xts:string id="CALCULATION_MIDDLE_TEXT"/>
													</div>
												</dp:section1>
												<dp:section2>
													<dp:choice>
														<dp:section1>
															<input type="radio" name="middle" checked="true" onClick="javascript:onSelOperation();"/>
														</dp:section1>
														<dp:section2>
															<xts:string id="CALCULATION_NONE"/>
														</dp:section2>
														<dp:section1>
															<input type="radio" name="middle" onClick="javascript:onSelOperation();"/>
														</dp:section1>
														<dp:section2>
															<xts:string id="CALCULATION_SPACE"/>
														</dp:section2>
														<dp:section1>
															<input type="radio" name="middle" onClick="javascript:onSelOperation();"/>
														</dp:section1>
														<dp:section2>
															<table>
																<tr>
																	<td id="textBoxString3" valign="bottom">
																		<input type="text" name="middletext" onClick="javascript:middleTextGotFocus();" onKeyDown="javascript:setTimeout(middleTextGotFocus, 10);">
																			<xsl:if test="/root/system/param[@name='disableEnterKeyAutoSubmit'] != 'true'">
																				<xsl:attribute name="onKeyUp">javascript:if (event.keyCode == 13) execute();</xsl:attribute>
																			</xsl:if>
																		</input>
																	</td>
																	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																		<td id="textBoxString3Constant" valign="bottom">
																			<xsl:call-template name="getTextBox">
																				<xsl:with-param name="promptLocale" select="$promptLocale"/>
																				<xsl:with-param name="promptFormName" select="$promptFormName"/>
																				<xsl:with-param name="promptRequired" select="'false'"/>
																				<xsl:with-param name="promptId" select="'stringMiddleValue'"/>
																				<xsl:with-param name="promptHideText" select="'false'"/>
																				<xsl:with-param name="promptMultiLine" select="'false'"/>
																				<xsl:with-param name="promptParameter" select="'numberParam3'"/>
																				<xsl:with-param name="promptReadOnly" select="'true'"/>
																			</xsl:call-template>
																		</td>
																		<td id="buttonContainer3"/>
																	</xsl:if>
																</tr>
															</table>
														</dp:section2>
													</dp:choice>
												</dp:section2>
											</div>
										</lyt:section>
									</lyt:layout>
								</td>
							</tr>
							<tr>
								<td width="100%" height="0%">
									<!-- Use default buttons [ OK = execute() and CANCEL = hideDialogFrame() ] -->
									<clcdlg:buttons/>
								</td>
							</tr>
							<!-- <dbg:dumpxml select="/"/> -->
						</table>
					</form>
				</dp:page>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
</xts:morphlet>