analytics/templates/ps/qs/calcStringLeftRightTrim.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 left, right, trim
-->
<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"/>/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 substVarValue = null;

function execute()
{
	var before_col_id = cf.dlgGlobalGetParm('xxInsBeforeColid');
	var calcFormat = "none";
	var first = "";
	var second = "";
	var calcExpr = "";
	var calcOp = document.f.calcList.options[document.f.calcList.selectedIndex].value; // Left, Right, or Trim
	var listSeparator = goDialogManager.getMiniQueryManager().getListSeparator();

	var numChars = 0;
	if (cf.dlgGlobalGetParm('xxDialogType') != 'CALCULATION_TEXT_TRIM')
	{
		if ((getDisplayStyle("textBoxNumeric")!= "none")&amp;&amp;textBoxnumberValue&amp;&amp;(textBoxnumberValue.isValid())&amp;&amp;(textBoxnumberValue.sGetValue() > 0))
			numChars = parseInt(textBoxnumberValue.sGetValue());
		else if (getDisplayStyle("textBoxString") != "none" &amp;&amp; substVarValue != null)
			numChars = substVarValue;
		else
			return;
	}
	if (((calcOp == "left") || (calcOp == "right")) &amp;&amp; (numChars == 0))
		return;

	if (calcOp == "left")
		calcExpr = "substring( " + document.f.repSel.options[document.f.repSel.selectedIndex].value + " from 1 for " + numChars + " )";
	else if (calcOp == "right")
	{
		calcExpr = "substring( " + document.f.repSel.options[document.f.repSel.selectedIndex].value + listSeparator + " character_length( " + document.f.repSel.options[document.f.repSel.selectedIndex].value + " ) - ";
		if (getDisplayStyle("textBoxNumeric") != "none")
			calcExpr += (numChars - 1) + listSeparator + " " + numChars + " )";
		else
			calcExpr += "(" + numChars + " - 1)" + listSeparator + " " + numChars + " )";
	}
	else
		calcExpr = "trim(trailing" + listSeparator + " " + document.f.repSel.options[document.f.repSel.selectedIndex].value + ")";

	if (calcExpr != "")
	{
		var calcName = getCalcName();
		getConfigFrame().addCalcColumn(before_col_id, calcExpr, calcExpr, 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 calcName = document.f.calcList.options[document.f.calcList.selectedIndex].value; // Left, Right, or Trim

	if (getDisplayStyle("textBoxNumeric") != "none")
	{
		var numChars = 0;
		if (cf.dlgGlobalGetParm('xxDialogType') != 'CALCULATION_TEXT_TRIM')
		{
			if (textBoxnumberValue &amp;&amp; (textBoxnumberValue.isValid())&amp;&amp;(textBoxnumberValue.sGetValue() > 0)) {
				numChars = textBoxnumberValue.sGetValue();
			}
			numChars = parseInt(numChars);
		}

		if (calcName == "left")
			calcName = (document.f.repSel.options[document.f.repSel.selectedIndex].text).substring(0, numChars);
		else if (calcName == "right")
		{
			calcName = document.f.repSel.options[document.f.repSel.selectedIndex].text;
			calcName = calcName.substr(calcName.length - numChars);
		}
		else
			calcName = stringReplace ("<xts:string id="CALCULATION_TRIM_EQUATION" encode="javascript"/>", "\\^0", document.f.repSel.options[document.f.repSel.options.selectedIndex].text);
	}
	else if (textBoxstringValue)
	{
		if (calcName == "left")
			calcName = stringReplace ("<xts:string id="CALCULATION_LEFTMOST_CHARACTERS_HINT" encode="javascript"/>", "\\^0", textBoxstringValue.sGetValue());
		else
			calcName = stringReplace ("<xts:string id="CALCULATION_RIGHTMOST_CHARACTERS_HINT" encode="javascript"/>", "\\^0", textBoxstringValue.sGetValue());
	}
	return calcName;
}

function init()
{
	attachMouseEvents();

	// populate selected columns menu
	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();
	for (var i = 0; i &lt; cf.dlgGlobalSize('xxValidCalcItem'); i++)
		validCalcs[validCalcs.length] = cf.dlgGlobalGetParmAt('xxValidCalcItem', i);

	populateCalculationList(calcType, validCalcs);
	// select calculation
	document.f.calcList.selectedIndex = cf.dlgGlobalGetParm('xxCalcTypeIdx');
	loadHint();
	getConfigFrame().cfgSet("CALCULATION_REFRESH", true);
	addInsert();
	setGlobals(calcType, false);
	if (typeof textBoxnumberValue != "undefined")
	{
		<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();
	}

	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
		<clcdlg:subst_var numeric="true"/>
		//hide the second input field
		setDisplayStyle("textBoxString", "none");
	</xsl:if>
}

function redrawHint()
{
	setTimeout(loadHint, 10);
}
						//--&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 valign="top" width="100%" height="100%">
									<lyt:layout style="2" border="no">
										<lyt:section>
											<clcdlg:calculations/>
											<dp:input>
												<dp:section1>
													<xts:string id="CALCULATION_REP_ITEM"/>
												</dp:section1>
												<dp:section2>
													<select name="repSel" size="1" style="width:260" onChange="javascript:loadHint();"/>
												</dp:section2>
											</dp:input>
											<xsl:if test="/root/env/param[@name='xxDialogType'] != 'CALCULATION_TEXT_TRIM'">
												<dp:input>
													<dp:section1>
														<xsl:if test="/root/env/param[@name='xxDialogType'] = 'CALCULATION_LEFT'">
															<xts:string id="CALCULATION_LEFTMOST_CHARACTERS"/>
														</xsl:if>
														<xsl:if test="/root/env/param[@name='xxDialogType'] = 'CALCULATION_RIGHT'">
															<xts:string id="CALCULATION_RIGHTMOST_CHARACTERS"/>
														</xsl:if>
													</dp:section1>
													<dp:section2>
														<table>
															<tr>
																<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="'numCharsParam'"/>
																		<xsl:with-param name="promptDataType" select="'whole'"/>
																		<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>
															</tr>
														</table>
													</dp:section2>
												</dp:input>
											</xsl:if>
										</lyt:section>
										<lyt:section>
											<clcdlg:calc_hint/>
										</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>