analytics/templates/ps/qs/calcNumericMultiple.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 sum, product, average, minimum, maximun
-->
<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>

			            <xsl:call-template name="getintervalFieldIncludes">
			            	<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"/>/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">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/selectColumn.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>
						<script type="text/javascript">
							<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/qs/calcNumericMultiple.js</xsl:attribute>
							<xsl:text/>//<xsl:text/>
						</script>						
						<script type="text/javascript">&lt;!--
var goDialogManager = new CDialogManager();
                        <clcdlg:jvs/>
var expression = new Array();
var calcParentIds = new Array();
var calculatedExpression = new Array();
var detailAggs = new Array();
var cf = getConfigFrame();
var calcType = cf.dlgGlobalGetParm('xxCalcType');
var substVarValue = null;


function generateName ()
{
    var calcName = "";
    var ii;
    var selCount = expression.length;
    var calc = document.f.calcList.options[document.f.calcList.selectedIndex].value;

    if (calc == "+")
		calcName = "<xts:string id="CALCULATION_SUM_EQUATION" encode="javascript"/>";
    else if (calc == "*")
		calcName = "<xts:string id="CALCULATION_PROD_EQUATION" encode="javascript"/>";
	else if (calc == "average")
		calcName = "<xts:string id="CALCULATION_AVG_EQUATION" encode="javascript"/>";
	else if (calc == "maximum")
		calcName = "<xts:string id="CALCULATION_MAX_EQUATION" encode="javascript"/>";
	else
		calcName = "<xts:string id="CALCULATION_MIN_EQUATION" encode="javascript"/>";

    for (ii = 0; ii &lt; (selCount - 1); ii++)
	{
        if (selCount > 1)
		{
			if (calc == "+")
				calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[ii].text + "<xts:string id="CALCULATION_SUM_SEPARATOR" encode="javascript"/>^0");
			else if (calc == "*")
				calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[ii].text + "<xts:string id="CALCULATION_PROD_SEPARATOR" encode="javascript"/>^0");
			else
				calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[ii].text + "<xts:string id="CALCULATION_AVG_MAX_MIN_SEPARATOR" encode="javascript"/>^0");
		}
    }

    if (document.f.numberCheck.checked)
	{
		var calcNum = 0;
		if (calcType == 'interval')
		{
			if (!document.f.inputValueRadio || (document.f.inputValueRadio[0].checked || (document.f.inputValueRadio[1].checked &amp;&amp; substVarValue == null)))
			{
				if (intervalControlintervalFrom.isValid())
					calcNum = intervalControlintervalFrom.sGetFormatValue();
			}
			else
				calcNum = textBoxstringValue.m_oForm.value;
		}
		else
		{
			if (document.getElementById("textBoxNumeric").style.display != "none")
				var textBoxValue = textBoxnumberValue;
			else
				var textBoxValue = textBoxstringValue;
			if (textBoxValue.isValid())
			{
				if (textBoxValue.m_oForm.value == "")
				{
					if (calc == "*")
						calcNum = 1;
				}
				else
					calcNum = textBoxValue.sGetFormatValue();
			}
			else
				calcNum = textBoxValue.m_oForm.value;
		}

		if (calc == "+")
			calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[document.f.repSel.options.length - 1].text + "<xts:string id="CALCULATION_SUM_SEPARATOR" encode="javascript"/>" + calcNum);
		else if (calc == "*")
			calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[document.f.repSel.options.length - 1].text + "<xts:string id="CALCULATION_PROD_SEPARATOR" encode="javascript"/>" + calcNum);
		else
			calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[document.f.repSel.options.length - 1].text + "<xts:string id="CALCULATION_AVG_MAX_MIN_SEPARATOR" encode="javascript"/>" + calcNum);
    }
    else
		calcName = stringReplace (calcName, "\\^0", document.f.repSel.options[document.f.repSel.options.length - 1].text);
    return calcName;
}

function minmax(op, constantVal)
{
    var prevExpr = "^^^0^^^"; // at least one expression
    var ii, calcExpr;
    var selCount = expression.length;
    for (ii=1; ii &lt; selCount; ii++)
	{
        calcExpr = 'if ((^^^' + ii + '^^^) ' + op + ' (' + prevExpr + ')) then (^^^' + ii + '^^^) else (' + prevExpr + ')';
        prevExpr = calcExpr;
    }
    if (document.f.numberCheck.checked)
        calcExpr = 'if ((' + constantVal + ') ' + op + ' (' + prevExpr + ')) then (' + constantVal + ') else (' + prevExpr + ')';
    return calcExpr;
}

function init()
{
	attachMouseEvents();

	for (var i = 0; i &lt; cf.dlgGlobalSize('xxCalcParentIds'); i++)
	{
		var id = cf.dlgGlobalGetParmAt('xxCalcParentIds', i);
		calcParentIds[i] = id[0];
	}
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxColInfo'); i++)
	{
		var colInfo = cf.dlgGlobalGetParmAt('xxColInfo', i);
		expression[i] = colInfo[1];
		document.f.repSel.options[document.f.repSel.options.length] = new Option(colInfo[0], i);
	}
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxSummExpr'); i++)
	{
		var summ = cf.dlgGlobalGetParmAt('xxSummExpr', i);
		detailAggs[i] = summ[0];
		calculatedExpression[i] = summ[1];
	}

	var validCalcs = new Array();
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxValidCalcItem'); i++)
		validCalcs[validCalcs.length] = cf.dlgGlobalGetParmAt('xxValidCalcItem',i);

	if (calcType == 'interval')
		populateCalculationList(calcType, validCalcs);
	else if (cf.dlgGlobalGetParm('xxDialogType') == 'CALCULATION_SUM' || cf.dlgGlobalGetParm('xxDialogType') == 'CALCULATION_PRODUCT')
		populateCalculationList(calcType, validCalcs, "arithmetic");
	else
		populateCalculationList(calcType, validCalcs, "analytic");

    // select calculation
    document.f.calcList.selectedIndex = cf.dlgGlobalGetParm('xxCalcTypeIdx');

	if (calcType != 'interval')
	    document.f.calcNumberList.selectedIndex = cf.dlgGlobalGetParm('xxCalcSubTypeIdx');

	// disable checkbox if only 1 selected column
	if (cf.dlgGlobalSize('xxColInfo') == 1)
		document.f.numberCheck.setAttribute("disabled","true");

    // check number checkbox if only one column selected
    document.f.numberCheck.checked = (cf.dlgGlobalSize('xxColInfo') == 1 ? true : false);
    <xsl:choose>
		<xsl:when test="/root/env/param[@name='xxCalcType']='interval' and /root/env/param[@name='xxSubstVar']='true'">
			setInterval(loadHint, 100);
		</xsl:when>
		<xsl:otherwise>
			loadHint();
		</xsl:otherwise>
	</xsl:choose>
	setGlobals(calcType, false);
	addInsert();

	if (calcType != 'interval')
	{
		<xsl:choose>
			<xsl:when test="/root/browserInfo/isNS6='true'">
				textBoxnumberValue.m_oForm.addEventListener("keydown", redrawHint, true);
			</xsl:when>
			<xsl:otherwise>
				textBoxnumberValue.m_oForm.attachEvent("onkeydown", redrawHint);
			</xsl:otherwise>
		</xsl:choose>
		textBoxnumberValue.m_oForm.focus();
	}

	var oIntervalFrom = [document.f.intervalDaysintervalFrom, document.f.intervalHoursintervalFrom, document.f.intervalMinutesintervalFrom, document.f.intervalSecondsintervalFrom];
	if (oIntervalFrom.length > 0)
	{
		if (oIntervalFrom[0])
		{
			oIntervalFrom[0].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalFrom[0].onclick = topGotFocus;
			oIntervalFrom[0].onkeypress = topGotFocus;
			oIntervalFrom[0].onpaste = topGotFocus;
			oIntervalFrom[0].onblur = topGotFocus;
		}
		if (oIntervalFrom[1])
		{
			oIntervalFrom[1].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalFrom[1].onclick = topGotFocus;
			oIntervalFrom[1].onkeypress = topGotFocus;
			oIntervalFrom[1].onpaste = topGotFocus;
			oIntervalFrom[1].onblur = topGotFocus;
		}
		if (oIntervalFrom[2])
		{
			oIntervalFrom[2].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalFrom[2].onclick = topGotFocus;
			oIntervalFrom[2].onkeypress = topGotFocus;
			oIntervalFrom[2].onpaste = topGotFocus;
			oIntervalFrom[2].onblur = topGotFocus;
		}
		if (oIntervalFrom[3])
		{
			oIntervalFrom[3].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalFrom[3].onclick = topGotFocus;
			oIntervalFrom[3].onkeypress = topGotFocus;
			oIntervalFrom[3].onpaste = topGotFocus;
			oIntervalFrom[3].onblur = topGotFocus;
		}
	}
	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
		<xsl:choose>
			<xsl:when test="not(/root/env/param[@name='xxCalcType']='interval')">
				<clcdlg:subst_var numeric="true"/>
			</xsl:when>
			<xsl:otherwise>
				<clcdlg:subst_var/>
			</xsl:otherwise>
		</xsl:choose>
		<xsl:choose>
			<xsl:when test="/root/browserInfo/isNS6='true'">
				textBoxstringValue.m_oForm.addEventListener("change", redrawHint, true);
			</xsl:when>
			<xsl:otherwise>
				textBoxstringValue.m_oForm.attachEvent("onchange", redrawHint);
			</xsl:otherwise>
		</xsl:choose>
		<xsl:if test="not(/root/env/param[@name='xxCalcType']='interval')">
			//hide the second input field
			document.getElementById("textBoxString").style.display = "none";
		</xsl:if>
	</xsl:if>
	checkOverflowOnSelect(document.f.repSel);
}

function redrawHint()
{
	setTimeout(loadHint, 10);
}

function setTextBoxFocus()
{
	// textbox does not exist in case of interval... so set function to do nothing.
	if (calcType != 'interval')
		document.f._textEditBoxnumberValue.focus();
}

function topGotFocus()
{
	document.f.numberCheck.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']!='interval'">
												<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:260px"/>
												</dp:section2>
											</dp:input>
										</lyt:section>
										<lyt:section>
											<clcdlg:calc_hint/>
										</lyt:section>
									</lyt:layout>
									<lyt:layout style="2">
										<lyt:section>
											<table>
												<xsl:if test="/root/env/param[@name='xxCalcType']='interval' and /root/env/param[@name='xxSubstVar']='true'">
													<tr>
														<td nowrap="nowrap">
															<input type="checkbox" name="numberCheck" onClick="javascript:onSelOperation();"/>
														</td>
														<td class="formLabel">
															<xts:string id="CALCULATION_VALUE"/>
														</td>
													</tr>
												</xsl:if>
												<tr>
													<td nowrap="nowrap" valign="middle">
														<xsl:if test="not(/root/env/param[@name='xxCalcType']='interval' and /root/env/param[@name='xxSubstVar']='true')">
															<input type="checkbox" name="numberCheck" onClick="javascript:onSelOperation();"/>
														</xsl:if>
													</td>
													<xsl:if test="not(/root/env/param[@name='xxCalcType']='interval' and /root/env/param[@name='xxSubstVar']='true')">
														<td class="formText" nowrap="nowrap" valign="middle">
															<xsl:choose>
																<xsl:when test="/root/env/param[@name='xxCalcType']='interval'">
																	<xts:string id="CALCULATION_INTERVAL"/>
																</xsl:when>
																<xsl:when test="/root/env/param[@name='xxSubstVar']='true'">
																	<xts:string id="CALCULATION_VALUE"/>
																</xsl:when>
																<xsl:otherwise>
																	<xts:string id="CALCULATION_NUMBER"/>
																</xsl:otherwise>
															</xsl:choose>
														</td>
													</xsl:if>
													<xsl:choose>
														<xsl:when test="/root/env/param[@name='xxCalcType']='interval'">
															<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																<td>
																	<input type="radio" name="inputValueRadio" checked="true"/>
																</td>
															</xsl:if>
															<td>
																<xsl:call-template name="getSelectInterval">
																	<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="promptDefaultValue" select="''"/>
																	<xsl:with-param name="suppressDisabled" select="'true'"/>
																	<xsl:with-param name="promptShowSeconds" select="'true'"/>
																	<xsl:with-param name="promptId" select="'intervalFrom'"/>
																	<xsl:with-param name="promptParameter" select="'intervalparameter1'"/>
																</xsl:call-template>
															</td>
															<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																<tr>
																	<td>
																	</td>
																	<td>
																		<input type="radio" name="inputValueRadio"/>
																	</td>
																	<td>
																		<table>
																			<tr>
																				<td 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="'stringValue'"/>
																						<xsl:with-param name="promptHideText" select="'false'"/>
																						<xsl:with-param name="promptMultiLine" select="'false'"/>
																						<xsl:with-param name="promptParameter" select="'stringParam1'"/>
																						<xsl:with-param name="promptReadOnly" select="'true'"/>
																					</xsl:call-template>
																				</td>
																				<td id="buttonContainer"/>
																			</tr>
																		</table>
																	</td>
																</tr>
															</xsl:if>
														</xsl:when>
														<xsl:otherwise>
															<td id="textBoxNumeric" 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="'numberValue'"/>
																	<xsl:with-param name="promptHideText" select="'false'"/>
																	<xsl:with-param name="promptMultiLine" select="'false'"/>
																	<xsl:with-param name="promptParameter" select="'numberParam'"/>
																	<xsl:with-param name="promptDataType" select="'number'"/>
																	<xsl:with-param name="promptMaxLength" select="'15'"/>
																</xsl:call-template>
															</td>
															<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																<td id="textBoxString" 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="'stringValue'"/>
																		<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="buttonContainer"/>
															</xsl:if>
														</xsl:otherwise>
													</xsl:choose>
												</tr>
											</table>
										</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>