analytics/templates/ps/qs/calcDateTimeMaxMin.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 date time max / min
-->
<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="page" type="exec" mode="output" processor="XSLT" mimeType="text/html">

		<!-- 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="getselectDateIncludes">
			            	<xsl:with-param name="promptLocale" select="$promptLocale"/>
			                <xsl:with-param name="promptContentLocale" select="$contentLocale"/>
			            </xsl:call-template>

			            <xsl:call-template name="getselectTimeIncludes">
			            	<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>

						<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">&lt;!--
						var goDialogManager = new CDialogManager();
						<clcdlg:jvs/>

var expression = new Array();
var calcParentIds = new Array();
cf = getConfigFrame();
var calcType = cf.dlgGlobalGetParm('xxCalcType');
var substVarValue = null;

function execute()
{
	var before_col_id = cf.dlgGlobalGetParm('xxInsBeforeColid');
	var calcOp = document.f.calcList.options[document.f.calcList.selectedIndex].value;
	var calcExpr = "";
	var cType = 52;
	var constantVal = "";

	if (!document.f.inputValueRadio || (document.f.inputValueRadio[0].checked || (document.f.inputValueRadio[1].checked &amp;&amp; substVarValue == null)))
	{
		if (calcType == 'date' || calcType == 'datetime')
		{
			if(document.f.datetimeCheck.checked)
			{
				if(pickerControldateTop.isValid())
					constantVal += pickerControldateTop.sGetValue();
				else return;
			}
			else
				constantVal += pickerControldateTop.sGetValue();
		}
		if (calcType == 'datetime')
			constantVal += " ";
		if (calcType == 'time' || calcType == 'datetime')
		{
			if(document.f.datetimeCheck.checked)
			{
				if(timePickertimeTop.isValid())
					constantVal += timePickertimeTop.sGetValue();
				else return;
			}
			else
				constantVal += timePickertimeTop.sGetValue();
		}
		if (calcType == 'interval')
		{
			if(document.f.datetimeCheck.checked)
			{
				if(intervalControlintervalTo.isValid())
					constantVal += intervalControlintervalTo.sGetValue();
				else return;
			}
			else
				constantVal += intervalControlintervalTo.sGetValue();
		}
	}
	else
		constantVal = substVarValue;

	if (document.f.calcList.options[document.f.calcList.selectedIndex].value == "max")
		calcExpr = minmax("&gt;", constantVal);
	else
		calcExpr = minmax("&lt;", constantVal);

	if (calcType == "date")
	{
		calcOp += "Date";
		cType = 50;
	}
	else if (calcType == "time")
	{
		calcOp += "Time";
		cType = 51;
	}
	else if (calcType == "interval")
	{
		calcOp += "Interval";
		cType = 53;
	}
	else
		calcOp += "DateTime";

	if (!calcExpr)
		return;
    var selCount = expression.length;
	for (var counter = 0; counter &lt; selCount; counter++)
		calcExpr = stringReplace (calcExpr, "\\^\\^\\^" + counter + "\\^\\^\\^", expression[counter]);
	var calcName = getCalcName();
	getConfigFrame().addCalcColumn(before_col_id, calcExpr, calcExpr, calcName, "none", calcOp, "none", "none", cType, 2, "none", -1, "none", calcParentIds);
}

function generateName(withQuotes)
{
    var calcName = "";
    var ii;
    var selCount = expression.length;

	if (calcType == "interval")
	{
		if (document.f.calcList.options[document.f.calcList.selectedIndex].value == "max")
			calcName = "<xts:string id="CALCULATION_MAX_EQUATION" encode="javascript"/>";
		else
			calcName = "<xts:string id="CALCULATION_MIN_EQUATION" encode="javascript"/>";
	}
	else
	{
		if (document.f.calcList.options[document.f.calcList.selectedIndex].value == "max")
			calcName = "<xts:string id="CALCULATION_LATEST_EQUATION" encode="javascript"/>";
		else
			calcName = "<xts:string id="CALCULATION_EARLIEST_EQUATION" encode="javascript"/>";
	}

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


	if (document.f.datetimeCheck.checked)
	{
		var calcNum = "";
		if (!document.f.inputValueRadio || (document.f.inputValueRadio[0].checked || (document.f.inputValueRadio[1].checked &amp;&amp; substVarValue == null)))
		{
			if (calcType == 'date' || calcType == 'datetime')
				calcNum += pickerControldateTop.sGetFormatValue();
			if (calcType == 'datetime')
				calcNum += " ";
			if (calcType == 'time' || calcType == 'datetime')
				calcNum += timePickertimeTop.sGetFormatValue();
			if (calcType == 'interval')
				calcNum += intervalControlintervalTo.sGetFormatValue();
		}
		else
			calcNum = textBoxstringValue.m_oForm.value;
		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.datetimeCheck.checked)
        calcExpr = 'if ((' + constantVal + ') ' + op + ' (' + prevExpr + ')) then (' + constantVal + ') else (' + prevExpr + ')';
    return calcExpr;
}

<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
	function datetimeGotFocus()
	{
		document.f.inputValueRadio[0].checked = true;
	}
</xsl:if>

function init()
{
	attachMouseEvents();

	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], colInfo[1]);
	}

	for (var i = 0; i &lt; cf.dlgGlobalSize('xxCalcParentIds'); i++)
	{
		var id = cf.dlgGlobalGetParmAt('xxCalcParentIds', i);
		calcParentIds[i] = id[0];
	}

	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');
	getConfigFrame().cfgSet("CALCULATION_REFRESH", false);
    // check date/time checkbox if only one column selected
    document.f.datetimeCheck.checked = (cf.dlgGlobalSize('xxColInfo') == 1 ? true : false);
    setInterval(loadHint, 100);
	setGlobals(calcType, false);
	addInsert();

	if (cf.dlgGlobalSize('xxColInfo') == 1)
		document.f.datetimeCheck.setAttribute("disabled","true");

	var oIntervalTo = [document.f.intervalDaysintervalTo, document.f.intervalHoursintervalTo, document.f.intervalMinutesintervalTo, document.f.intervalSecondsintervalTo];
	if (oIntervalTo.length > 0)
	{
		if (oIntervalTo[0])
		{
			oIntervalTo[0].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalTo[0].onclick = toGotFocus;
			oIntervalTo[0].onkeypress = toGotFocus;
			oIntervalTo[0].onpaste = toGotFocus;
			oIntervalTo[0].onblur = toGotFocus;
		}
		if (oIntervalTo[1])
		{
			oIntervalTo[1].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalTo[1].onclick = toGotFocus;
			oIntervalTo[1].onkeypress = toGotFocus;
			oIntervalTo[1].onpaste = toGotFocus;
			oIntervalTo[1].onblur = toGotFocus;
		}
		if (oIntervalTo[2])
		{
			oIntervalTo[2].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalTo[2].onclick = toGotFocus;
			oIntervalTo[2].onkeypress = toGotFocus;
			oIntervalTo[2].onpaste = toGotFocus;
			oIntervalTo[2].onblur = toGotFocus;
		}
		if (oIntervalTo[3])
		{
			oIntervalTo[3].value = "<xts:string id="FILTER_INTERVAL_DEFAULT_VALUE" encode="javascript"/>";
			oIntervalTo[3].onclick = toGotFocus;
			oIntervalTo[3].onkeypress = toGotFocus;
			oIntervalTo[3].onpaste = toGotFocus;
			oIntervalTo[3].onblur = toGotFocus;
		}
	}

	<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
		//choose date and time radio button on focus
		var oDateTop = document.getElementById('dateEditBoxdateTop');
		var oTimeTop = document.getElementById('timeEditBoxtimeTop');
		if (oDateTop)
		{
			oDateTop.onclick = datetimeGotFocus;
			oDateTop.onkeypress = datetimeGotFocus;
			oDateTop.onpaste = datetimeGotFocus;

		}
		if (oTimeTop)
		{
			oTimeTop.onclick = datetimeGotFocus;
			oTimeTop.onkeypress = datetimeGotFocus;
			oTimeTop.onpaste = datetimeGotFocus;
		}

		if (document.dateTopimgPicker)
			document.dateTopimgPicker.onmousedown = datetimeGotFocus;

		<clcdlg:subst_var/>
	</xsl:if>
	checkOverflowOnSelect(document.f.repSel);
}

function toGotFocus()
{
	document.f.datetimeCheck.checked=true;
}

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 width="100%" height="100%" valign="top">
									<lyt:layout style="2" border="no">
										<lyt:section>
											<clcdlg:calculations/>
											<dp:input>
												<dp:section1>
													<xts:string id="CALCULATION_SEL_REP_ITEMS"/>
												</dp:section1>
												<dp:section2>
													<select name="repSel" size="7" style="width:260"/>
												</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='xxSubstVar']='true'">
													<tr>
														<td>
															<input type="checkbox" name="datetimeCheck" onClick="javascript:onSelOperation();"/>
														</td>
														<td class="formLabel">
															<xts:string id="CALCULATION_VALUE"/>
														</td>
													</tr>
											    </xsl:if>
												<tr>
													<td valign="middle" nowrap="nowrap">
														<xsl:if test="not(/root/env/param[@name='xxSubstVar']='true')">
															<input type="checkbox" name="datetimeCheck" onClick="javascript:onSelOperation();"/>
														</xsl:if>
													</td>
													<td>
														<table>
															<tr>
																<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
																	<td>
																		<input type="radio" name="inputValueRadio" checked="true"/>
																	</td>
																</xsl:if>
																<td>
																	<table>
																		<xsl:if test="/root/env/param[@name='xxCalcType']='date' or /root/env/param[@name='xxCalcType']='datetime'">
																			<tr>
																				<td class="formText" nowrap="nowrap" valign="middle">
																					<xts:string id="CALCULATION_DATE"/>
																				</td>
																				<td>
																					<!-- Render a select date prompt-->
																					<xsl:call-template name="getSelectDate">
																						<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="promptStartOfWeek" select="'Sunday'"/>
																						<xsl:with-param name="promptCalendar" select="'Gregorian'"/>
																						<xsl:with-param name="promptParameter" select="'dateparameter1'"/>
																						<xsl:with-param name="promptInputOrder" select="'YMD'"/>
																						<xsl:with-param name="promptDefaultDate" select="'none'"/>
																						<xsl:with-param name="promptDateTime" select="'false'"/>
																						<xsl:with-param name="promptMultiSelect" select="'false'"/>
																						<xsl:with-param name="promptId" select="'dateTop'"/>
																						<xsl:with-param name="suppressDisabled" select="'true'"/>
																						<xsl:with-param name="promptSelectUI" select="'editBox'"/>
																					</xsl:call-template>
																				</td>
																			</tr>
																		</xsl:if>
																		<xsl:if test="/root/env/param[@name='xxCalcType']='time' or /root/env/param[@name='xxCalcType']='datetime'">
																			<tr>
																				<td class="formText" nowrap="nowrap" valign="middle">
																					<xts:string id="CALCULATION_TIME"/>
																				</td>
																				<td>
																					<xsl:call-template name="getSelectTime">
																						<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="'00:00:00.000'"/>
																						<xsl:with-param name="promptParameter" select="'timeparameter1'"/>
																						<xsl:with-param name="promptDisplay" select="1"/>
																						<xsl:with-param name="promptInline" select="'false'"/>
																						<xsl:with-param name="promptHourFormat" select="'hh'"/>
																						<xsl:with-param name="promptMinuteFormat" select="'mm'"/>
																						<xsl:with-param name="promptSecondFormat" select="'ss'"/>
																						<xsl:with-param name="promptMultiSelect" select="'false'"/>
																						<xsl:with-param name="promptId" select="'timeTop'"/>
																						<xsl:with-param name="suppressDisabled" select="'true'"/>
																						<xsl:with-param name="promptSelectUI" select="'editBox'"/>
																					</xsl:call-template>
																				</td>
																			</tr>
																		</xsl:if>
																		<xsl:if test="/root/env/param[@name='xxCalcType']='interval'">
																			<tr>
																				<td class="formText" nowrap="nowrap" valign="middle">
																					<xts:string id="CALCULATION_INTERVAL"/>
																				</td>
																				<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="'intervalTo'"/>
																						<xsl:with-param name="promptParameter" select="'intervalparameter1'"/>
																					</xsl:call-template>
																				</td>
																			</tr>
																		</xsl:if>
																	</table>
																</td>
															</tr>
														</table>
													</td>
												</tr>
												<xsl:if test="/root/env/param[@name='xxSubstVar']='true'">
													<tr>
														<td>
															<!-- Empty formatting cell -->
														</td>
														<td>
															<table>
																<tr>
																	<td>
																		<input type="radio" name="inputValueRadio"/>
																	</td>
																	<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>
											</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>