analytics/templates/ps/qs/filterIntervalRange.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).
-->
<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="queryCM" mode="interpret" processor="XSLT" type="exec" condition=".[/root/env/param[@name='xxRetrievePrompt']='true']" mandatory="false" nodelist="header, env, http, cookies, bus:biBusHeader">
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:cm="http://developer.cognos.com/schemas/bibus/3/" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
			<xsl:template match="/">
				<xts:sequence>
					<xts:append>
						<xts:request asText="true" href="bus://dispatcher" protocol="BUS" responseEnvelope="false" soapAction="http://www.ibm.com/xmlns/prod/cognos/contentManagerService/201404/">
							<SOAP-ENV:Envelope xmlns:bus="http://developer.cognos.com/schemas/bibus/3/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
								<SOAP-ENV:Header>
									<xsl:copy-of select="/root/header/bus:biBusHeader"/>
								</SOAP-ENV:Header>
								<SOAP-ENV:Body>
									<cm:query xmlns:cm="http://developer.cognos.com/schemas/bibus/3/">
										<search>
											<xsl:value-of select="xtsext:urldecode(string(/root/env/param[@name='xxSearchPath']))"/>
										</search>
										<properties xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="cm:propEnum[1]">
											<item xsi:type="">parameters</item>
										</properties>
									</cm:query>
								</SOAP-ENV:Body>
							</SOAP-ENV:Envelope>
						</xts:request>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<xts:block id="appendDocument" mode="interpret" processor="XSLT" type="exec" dependency="queryCM" condition=".[/root/env/param[@name='xxRetrievePrompt']='true']" mandatory="false" nodelist="header, env, http, cookies, bus:biBusHeader, cm:queryResponse">
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/" xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" xmlns:cm="http://developer.cognos.com/schemas/cm/1/" xmlns:SOAP-ENV="http://www.w3.org/2001/09/soap-envelope" xmlns:bus="http://developer.cognos.com/schemas/bibus/3/" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
			<xsl:output method="xml" version="1.0" encoding="UTF-8"/>
			<xsl:template match="/root">
				<xts:sequence>
					<xts:append select="/root/env">
						<xsl:for-each select="/root/cm:queryResponse/queryResult/item/parameters/value/item" xmlns:cm="http://developer.cognos.com/schemas/bibus/3/">
							<xsl:if test="/root/env/param[@name='xxFromParamName']=./name">
								<xsl:for-each select="./value/item/start">
									<param name="xxFromValue"><xsl:value-of select="./use" disable-output-escaping="yes"/></param>
								</xsl:for-each>
							</xsl:if>
							<xsl:if test="/root/env/param[@name='xxToParamName']=./name">
								<xsl:for-each select="./value/item/end">
									<param name="xxToValue"><xsl:value-of select="./use" disable-output-escaping="yes"/></param>
								</xsl:for-each>
							</xsl:if>
							<xsl:if test="/root/env/param[@name='xxToParamName']=./name">
								<xsl:for-each select="./value/item/use">
									<param name="xxFromValue"><xsl:value-of select="." disable-output-escaping="yes"/></param>
									<param name="xxToValue"><xsl:value-of select="." disable-output-escaping="yes"/></param>
								</xsl:for-each>
							</xsl:if>
						</xsl:for-each>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<xts:block id="getLocalPrompts" mode="interpret" processor="XSLT" type="exec" dependency="queryCM" condition=".[not(/root/env/param[@name='xxRetrievePrompt'])]" mandatory="false" nodelist="header, env, http, cookies, bus:biBusHeader">
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/" xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" xmlns:cm="http://developer.cognos.com/schemas/cm/1/" xmlns:SOAP-ENV="http://www.w3.org/2001/09/soap-envelope" xmlns:bus="http://developer.cognos.com/schemas/bibus/3/" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
			<xsl:output method="xml" version="1.0" encoding="UTF-8"/>
			<xsl:template match="/root">
				<xts:sequence>
					<xts:append select="/root/env">
						<xsl:for-each select="/root/env/param[@name='xxFromParamName']">
							<param name="xxFromParamName"><xsl:value-of select="." disable-output-escaping="yes"/></param>
						</xsl:for-each>
						<xsl:for-each select="/root/env/param[@name='xxToParamName']">
							<param name="xxToParamName"><xsl:value-of select="." disable-output-escaping="yes"/></param>
						</xsl:for-each>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<xts:block id="appendLocalPrompts" mode="interpret" processor="XSLT" type="exec" dependency="getLocalPrompts" condition=".[not(/root/env/param[@name='xxRetrievePrompt'])]" mandatory="false" nodelist="header, env, http, cookies, bus:biBusHeader">
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/" xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" xmlns:cm="http://developer.cognos.com/schemas/cm/1/" xmlns:SOAP-ENV="http://www.w3.org/2001/09/soap-envelope" xmlns:bus="http://developer.cognos.com/schemas/bibus/3/" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt">
			<xsl:output method="xml" version="1.0" encoding="UTF-8"/>
			<xsl:template match="/root">
				<xts:sequence>
					<xts:append select="/root/env">
						<xsl:for-each select="/root/env/param[@name='xxFromParamName']/selectChoices">
							<xsl:choose>
								<xsl:when test="./selectBoundRange/start">
									<param name="xxFromValue"><xsl:value-of select="./selectBoundRange/start/@useValue"/></param>
								</xsl:when>
								<xsl:when test="./selectUnboundedEndRange/start">
									<param name="xxFromValue"><xsl:value-of select="./selectUnboundedEndRange/start/@useValue"/></param>
								</xsl:when>
								<xsl:when test="./selectOption">
									<param name="xxFromValue"><xsl:value-of select="./selectOption/@useValue"/></param>
								</xsl:when>
							</xsl:choose>
						</xsl:for-each>
						<xsl:for-each select="/root/env/param[@name='xxToParamName']/selectChoices">
							<xsl:choose>
								<xsl:when test="./selectBoundRange/end">
									<param name="xxToValue"><xsl:value-of select="./selectBoundRange/end/@useValue"/></param>
								</xsl:when>
								<xsl:when test="./selectUnboundedStartRange/end">
									<param name="xxToValue"><xsl:value-of select="./selectUnboundedStartRange/end/@useValue"/></param>
								</xsl:when>
								<xsl:when test="./selectOption">
									<param name="xxToValue"><xsl:value-of select="./selectOption/@useValue"/></param>
								</xsl:when>
							</xsl:choose>
						</xsl:for-each>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
	<xts:block id="page" type="exec" mode="output" processor="XSLT" mimeType="text/html" dependency="appendDocument appendLocalPrompts" nodelist="env, debug, http, command, system, session, user, actions, tabs, configProps, credential, cookies, setCookies, accountOptions, newSession, gatewayURI, cm:queryResponse, objectClass, prompting">
		<!-- get the debug logic sheet -->
		<xts:logicsheet path="logicsheets/debuglogic.xslt"/>
		<!-- get the new theme stuff -->
		<xts:logicsheet path="qs/logicsheets/filter_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:filterdlg="test_filterDlg" 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:xtsext="xalan://com.cognos.xts.ext.XTSExt" xmlns:qsdlg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/qs/dialog/" exclude-result-prefixes="filterdlg xsl xts lyt pf dp df cp cf dbg xtsext qsdlg">
			<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">
				<!--Get HTML output for the HEAD section -->
				<dp:page>
					<dp:script>


						<xsl:call-template name="getPromptCommonIncludes"/>
						<xsl:call-template name="getintervalFieldIncludes">
							<xsl:with-param name="promptLocale" select="$promptLocale"/>
							<xsl:with-param name="promptContentLocale" select="$contentLocale"/>
						</xsl:call-template>
						<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/filterDialog.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();
var cf = getConfigFrame();
var onlyPrompt = false;
var complexFilterType = "selectInterval";
var substVarValueFrom = null;
var substVarValueTo = null;
var advClosedSize = 500;
var advOpenedSize = 565;

var sFILTER_LOWEST_VALUE = '<xts:string id="FILTER_LOWEST_VALUE" encode="javascript"/>';
var sFILTER_HIGHEST_VALUE = '<xts:string id="FILTER_HIGHEST_VALUE" encode="javascript"/>';
var sFILTER_INTERVAL_DEFAULT_VALUE = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";

function execute() { filterIntervalRange_execute(); }
function buildFilterExpression() { return filterIntervalRange_buildFilterExpression(); }

<filterdlg:update_value_field/>

function init()
{
	var oOptions = {};
	<xsl:if test="/root/env/param[@name='xxFromParamName' or @name='xxToParamName']">
		oOptions.bPrompt = true;
	</xsl:if>
	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
		oOptions.bUseAdv = true;
	</xsl:if>

	filterIntervalRange_init(oOptions);

	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
		<filterdlg:subst_var_button/>
	</xsl:if>
}
						//--&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 -->
									<dp:header help="false">
										<!-- header titles -->
										<dp:title>
											<xts:string id="FILTER_TITLE"/>
										</dp:title>
										<!-- close link for the header -->
										<dp:close>
											<a href="javascript:this.cancelDialog()">
												<dp:closeMarker/>
											</a>
										</dp:close>
										<!-- description (hint text) -->
										<dp:description>
											<xts:string id="FILTER_INTERVAL_DESCRIPTION"/>
										</dp:description>
									</dp:header>
								</td>
							</tr>
							<tr>
								<td width="100%" height="100%" valign="top">
									<!-- layout -->
									<lyt:layout style="2" border="no">
										<lyt:section>
											<dp:input>
												<dp:section1>
													<xts:string id="FILTER_ON"/>
												</dp:section1>
												<dp:section2>
													<xsl:attribute name="id">colName</xsl:attribute>
												</dp:section2>
											</dp:input>
										</lyt:section>
										<lyt:section>
											<qsdlg:promptBox/>
										</lyt:section>
									</lyt:layout>
									<lyt:layout style="1" border="no" joinSection="true">
										<lyt:section>
											<qsdlg:conditionBox/>
										</lyt:section>
									</lyt:layout>
									<lyt:layout style="1" border="yes" title="FILTER_FROM" joinSection="true">
										<lyt:section>
											<table>
												<tr>
													<td>
														<input type="radio" name="fromValue">
															<xsl:if test="/root/env/param[@name='xxFromValue']">
																<xsl:attribute name="checked">true</xsl:attribute>
															</xsl:if>
														</input>
													</td>
													<td>
														<!-- Render a select interval prompt-->
														<xsl:variable name="interval1">
															<xsl:choose>
																<xsl:when test="/root/env/param[@name='xxFromValue']">
																	<xsl:value-of select="/root/env/param[@name='xxFromValue']"/>
																</xsl:when>
															</xsl:choose>
														</xsl:variable>
														<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="$interval1"/>
															<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="'parameter1'"/>
														</xsl:call-template>
													</td>
												</tr>
												<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
													<tr>
														<td>
															<input type="radio" name="fromValue"/>
														</td>
														<td>
															<table>
																<tr>
																	<td valign="bottom">
																		<img width="10">
																			<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/common/images/spacer.gif</xsl:attribute>
																		</img>
																		<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="'stringValueFrom'"/>
																			<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="buttonContainer1"/>
																</tr>
															</table>
														</td>
													</tr>
												</xsl:if>
												<tr>
													<td>
														<input type="radio" name="fromValue">
															<xsl:if test="not(/root/env/param[@name='xxFromValue'])">
																<xsl:attribute name="checked">true</xsl:attribute>
															</xsl:if>
														</input>
													</td>
													<td class="formText">
														<img width="10">
															<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/common/images/spacer.gif</xsl:attribute>
														</img>
														<xts:string id="FILTER_LOWEST_VALUE"/>
													</td>
												</tr>
											</table>
										</lyt:section>
									</lyt:layout>
									<lyt:layout style="1" border="yes" title="FILTER_TO" joinSection="true">
										<lyt:section>
											<table>
												<tr>
													<td>
														<input type="radio" name="toValue">
															<xsl:if test="/root/env/param[@name='xxToValue']">
																<xsl:attribute name="checked">true</xsl:attribute>
															</xsl:if>
														</input>
													</td>
													<td>
														<!-- Render a select interval prompt-->
														<xsl:variable name="interval2">
															<xsl:choose>
																<xsl:when test="/root/env/param[@name='xxToValue']">
																	<xsl:value-of select="/root/env/param[@name='xxToValue']"/>
																</xsl:when>
															</xsl:choose>
														</xsl:variable>
														<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="$interval2"/>
															<xsl:with-param name="suppressDisabled" select="'true'"/>
															<xsl:with-param name="promptShowSeconds" select="'true'"/>
															<xsl:with-param name="promptId" select="'intervalTo'"/>
															<xsl:with-param name="promptParameter" select="'parameter2'"/>
														</xsl:call-template>
													</td>
												</tr>
												<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
													<tr>
														<td>
															<input type="radio" name="toValue"/>
														</td>
														<td>
															<table>
																<tr>
																	<td valign="bottom">
																		<img width="10">
																			<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/common/images/spacer.gif</xsl:attribute>
																		</img>
																		<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="'stringValueTo'"/>
																			<xsl:with-param name="promptHideText" select="'false'"/>
																			<xsl:with-param name="promptMultiLine" select="'false'"/>
																			<xsl:with-param name="promptParameter" select="'stringParam2'"/>
																			<xsl:with-param name="promptReadOnly" select="'true'"/>
																		</xsl:call-template>
																	</td>
																	<td id="buttonContainer2"/>
																</tr>
															</table>
														</td>
													</tr>
												</xsl:if>
												<tr>
													<td>
														<input type="radio" name="toValue">
															<xsl:if test="not(/root/env/param[@name='xxToValue'])">
																<xsl:attribute name="checked">true</xsl:attribute>
															</xsl:if>
														</input>
													</td>
													<td class="formText">
														<img width="10">
															<xsl:attribute name="src"><xsl:value-of select="$webRoot"/>/common/images/spacer.gif</xsl:attribute>
														</img>
														<xts:string id="FILTER_HIGHEST_VALUE"/>
													</td>
												</tr>
											</table>
										</lyt:section>
									</lyt:layout>
									<lyt:layout style="1" border="no" joinSection="true">
										<lyt:section>
											<qsdlg:nullOptions/>
											<qsdlg:filterBasedOnDSBox/>
										</lyt:section>
									</lyt:layout>
								</td>
							</tr>
							<tr>
								<td width="100%" height="0%">
									<!-- Use default buttons [ OK = execute() and CANCEL = hideDialogFrame() ] -->
									<qsdlg:defaultButtons/>
								</td>
							</tr>
							<!-- <dbg:dumpxml select="/"/> -->
						</table>
					</form>
				</dp:page>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
</xts:morphlet>