analytics/templates/ps/portal/test_connection_results.xts

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

    IBM Cognos Products: ps

    (C) Copyright IBM Corp. 2005, 2014

    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 xmlns:xts="http://developer.cognos.com/schemas/xts/" messageBase="messages/portal.xml, messages/portalRL.xml" requiredCapability="canUseDataSourcesTool">
	<!-- form logic stuff	============================================================== -->
	<xts:block id="formlogic_init" type="exec" mode="interpret" processor="XSLT" path="/logicsheets/formlogic_init.xslt" nodelist="env,credential,system,http"/>

	<!--
	================================================================================
	encrypt the password
	================================================================================
	-->
	<xts:block id="encrypt_password" path="/portal/encryptConnectionPasswords.xslt" dependency="formlogic_init" type="exec" mode="interpret" processor="XSLT" mandatory="false" condition=".[/root/env/param[@name='m_cube_password' or @name='test_cube_password' or @name='m_connection_password' or @name='test_password' or @name='m_connection_proxy_password'] != '']"/>

	<!--
	===============================================================================================
	getContent
		Get the dispatcher information
		If the user wants to test the connection with a signon, then we need to query for it
	===============================================================================================
	-->		
	<xts:block id="getContent" processor="XSLT" type="exec" dependency="formlogic_init">
		<xts:logicsheet path="logicsheets/presentation/dialog/templates.xsl"/>
		<xts:logicsheet path="logicsheets/cm-logic.xsl"/>
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0"
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"  
			xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" 
			xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/"
			xmlns:dt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/templates/" 			
			xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" 			
			xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			
			<xsl:template match="/">
				<xts:sequence>
					<xts:append>
						<content>
							<xsl:if test="/root/env/param[@name='pageitem']">
								<xts:transform src="transforms/CM/post-process.xslt" processor="XSLT">					
									<send:request provider="cm">
										<xts:transform src="transforms/CM/pre-process.xslt" processor="XSLT">
											<cm:query xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/">
												<cm:requests>
													<!-- get the signon information -->
														<cm:query> 
															<cm:search><xsl:value-of select="/root/env/param[@name='pageitem']"/>[permission('read')][permission('execute')]</cm:search>		
															<cm:properties>							
																<cm:property name="searchPath"/>
																<cm:property name="defaultName"/>
																<cm:property name="credentials"/>
																<cm:property name="iconURI"/>
															</cm:properties>
														</cm:query>
												</cm:requests>
											</cm:query>
										</xts:transform>
									</send:request>
								</xts:transform>
							</xsl:if>
						</content>
						<installedComponents>
							<xts:function name="getConfiguration">	
								<xts:param name="installedComponents"/>		
							</xts:function>
						</installedComponents>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>	

	<!--
	================================================================================
	decrypt_credentials
	================================================================================
	-->
	<xts:block id="decrypt_credentials" dependency="getContent" type="exec" mode="interpret" processor="XSLT" mandatory="false" condition=".[/root/env/param[@name='pageitem'] and /root/content/*[local-name() = 'queryResponse']/*[local-name() = 'queryReply']/*]">
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:variable name="xtscm" select="'http://developer.cognos.com/schemas/xts-cm/1/'"/>
			<xsl:template match="/">
				<xts:sequence>
					<xsl:variable name="selected_content" select="/root/env/param[@name='pageitem']"/>
					<xts:append>
						<decryptedCredential>
							<xts:decrypt>
								<xts:param name="provider">cognos.cam</xts:param>
								<xts:param name="source"><xsl:value-of select="substring-before(substring-after(xtsext:xmldecode( string(/root/content/cm:queryResponse/cm:queryReply/cm:dataSourceSignon/cm:credentials)), '&lt;encryptedValue&gt;'), '&lt;/encryptedValue&gt;')"/></xts:param>
							</xts:decrypt>
						</decryptedCredential>
					</xts:append>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>	
	
	<!--
	================================================================================
	test_connection
	================================================================================
	-->
	<xts:block id="test_connection" type="exec" mode="interpret" dependency="encrypt_password decrypt_credentials formlogic_init" processor="XSLT">
		<xts:logicsheet path="logicsheets/presentation/dialog/connections.xslt"/>
		<xts:logicsheet path="logicsheets/buslogic.xslt"/>
		<xsl:stylesheet version="1.0" 
			xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/" 
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/" 
			xmlns:dcx="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/dialog/connections/1/"
			xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
			exclude-result-prefixes="cm xsl dcx send xsi">
			
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>

			<xsl:key name="env-param" match="/root/env/param" use="@name"/>

			<dcx:testDataSourceVars/>
			
			<xsl:template match="/">			
				<xts:sequence>
					<xts:append>
						<testResults>
							<send:request provider="xts">
								<test:testDataSourceConnection xmlns:test="http://developer.cognos.com/schemas/xts/portal/iTestDataSource/1/">
									<connectionString>
										<xsl:value-of select="key('env-param','m_p_connectionString')"/>
									</connectionString>
									<credentials>
										<!-- create the encrypted credential -->
										<xsl:text/>&lt;credential&gt;&lt;encryptedValue&gt;<xsl:text/>
										<xsl:call-template name="dcx:genCredentials">
											<xsl:with-param name="username" select="$username"/>
											<xsl:with-param name="password" select="$password"/>
											<xsl:with-param name="passwordEncrypted" select="$passwordEncrypted"/>
											<xsl:with-param name="cubePassword" select="$cubePassword"/>
											<xsl:with-param name="cubePasswordEncrypted" select="$cubePasswordEncrypted"/>
											<xsl:with-param name="namespace" select="$usedNamespace"/>
										</xsl:call-template>						
										<xsl:text/>&lt;/encryptedValue&gt;&lt;/credential&gt;<xsl:text/>
									</credentials>
									<xsl:for-each select="key('env-param','dispatcher')">
										<dispatcher id="{.}"/>
									</xsl:for-each>
								</test:testDataSourceConnection>
							</send:request>
						</testResults>
					</xts:append>
				</xts:sequence>
			</xsl:template>
			
			<dcx:genCredentialTemplate/>
		</xsl:stylesheet>
	</xts:block>	

	<!--
	================================================================================
	delete_credentials - if we decrypted the credentials then delete them from the DOM once the test is done
	================================================================================
	-->
	<xts:block id="delete_credentials" dependency="test_connection" type="exec" mode="interpret" processor="XSLT" mandatory="false" condition=".[/root/env/param[@name='pageitem']]">
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/">
			<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>
			<xsl:variable name="xtscm" select="'http://developer.cognos.com/schemas/xts-cm/1/'"/>
			<xsl:template match="/">
				<xts:sequence>
					<xts:delete select="/root/decryptedCredential"/>
				</xts:sequence>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>					

	<!--======================================================================
		Name: 		resultPage
		Comments:  Render the action result page. It's a dialog page with Close button.
	======================================================================-->
	<xts:block id="resultPage" mode="output" processor="XSLT" type="exec" mimeType="text/html" dependency="delete_credentials formlogic_init">
		<!-- get the new theme stuff -->
		<xts:logicsheet path="logicsheets/portal.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"/>
		<!-- apply the form logic -->
		<xts:logicsheet path="logicsheets/formlogic.xslt"/>
		<xts:logicsheet path="logicsheets/validation.xslt"/>		
		<xts:logicsheet path="logicsheets/presentation/touch_up.xslt"/>
		<xsl:stylesheet version="1.0" 
			xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
			xmlns:test="http://developer.cognos.com/schemas/xts/portal/iTestDataSource/1/"
			xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/" 
			xmlns:lyt="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/layout/" 
			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:cf="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/framework/" 
			xmlns:cp="http://developer.cognos.com/schemas/xts/logicsheets/xslt/presentation/controls/presentation/" 
			xmlns:tool="http://developer.cognos.com/schemas/xts/logicsheets/xslt/toollogic/"
			xmlns:cml="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/cml/1/" 
			xmlns:bus="http://developer.cognos.com/schemas/bibus/3/"
			xmlns:pf="http://developer.cognos.com/schemas/xts/pf" 
			xmlns:utml="http://developer.cognos.com/schemas/xts/logicsheet/xslt/formlogic/" 
			xmlns:send="http://developer.cognos.com/schemas/xts/logic-sheet/xslt/brl/1/"
			xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" 
			xmlns:smt="http://developer.cognos.com/schemas/xts/admin/iServerManagement/1/"  
			xmlns:set="http://exslt.org/sets"
			exclude-result-prefixes="xsl test cm cml bus utml send xtsext smt tool set">
			<xsl:output method="html" version="1.0" encoding="UTF-8" indent="no" omit-xml-declaration="yes"/>
			<!-- current file name -->
			<xsl:variable name="mname" select="'test_connection_results.xts'"/>
			<!-- add any theme variables -->
			<pf:variables/>
			<!-- back-url must be defined, but not used -->
			<xsl:variable name="back-url" select="''"/>
			<xsl:variable name="browserTitle"><xts:string id="IDS_VIEW_ACTION_RESULTS_TEST_CONNECTION"/></xsl:variable>
			<xsl:variable name="queryServiceIsInstalled" select="/root/installedComponents/configuration/property/component[string(.)='queryService']"/>
			
			<xsl:template match="/root">
				<xsl:text disable-output-escaping='yes'>&lt;!DOCTYPE html></xsl:text><dp:page longTitle="$browserTitle">
					<dp:meta>
						<pf:meta/>	<!-- Standard meta tags -->
					</dp:meta>
					<dp:script>
						<pf:help context="HID_DATA_SOURCES"/>		 <!-- Help system -->
					</dp:script>					
					<script language="javascript">
						function doCancel()
						{
							<xsl:choose>
								<xsl:when test="key('env-param','from_bmt')!=''">
									<!-- Called only when canceling back to BMT environment. -->
									window.external.OnClose(1);
								</xsl:when>
								<xsl:otherwise>
									<xsl:choose>
										<xsl:when test="key('env-param', 'ps_nav_stack') and not(key('env-param', 'ps_nav_stack') = '') ">								
											document.pform.ps_nav_op.value = 'pop';			
											<xsl:variable name="nav-stack-delimiter" select="'*'"/>
											<xsl:variable name="target">
												<xsl:choose>
													<xsl:when test="contains(/root/env/param[@name='ps_nav_stack'], $nav-stack-delimiter)">
														<xsl:value-of select="substring-before( /root/env/param[@name='ps_nav_stack'], $nav-stack-delimiter )"/>
													</xsl:when>					
													<xsl:otherwise>
														<xsl:value-of select="/root/env/param[@name='ps_nav_stack']"/>
													</xsl:otherwise>
												</xsl:choose>
											</xsl:variable>
											document.pform.m.value = '<xsl:value-of select="xtsext:javascriptencode(string($target))"/>';
											document.pform.submit();
										</xsl:when>
										<xsl:otherwise>
											location.href = '<xsl:value-of select="xtsext:javascriptencode(string(/root/env/param[@name='backURL']))"/>';
										</xsl:otherwise>
									</xsl:choose>
								</xsl:otherwise>
							</xsl:choose>
						}					
					</script>
					<utml:form name="pform" method="post" action="{$gateway}">
						<!-- dialog header -->
						<dp:header>
							<!-- header titles-->
							<dp:title showName="false"><xsl:value-of select="$browserTitle"/></dp:title>
							<dp:close>
								<a href="javascript:doCancel()">
									<dp:closeMarker/>
								</a>
							</dp:close>							
						</dp:header>
						<!-- layout-->
						<lyt:layout style="1" border="no">
							<lyt:section>
								<xsl:choose>
									<xsl:when test="/root/testResults/test:testDataSourceConnectionResponse/dispatcher[displayName != '']">
										<cp:table iterate="/root/testResults/test:testDataSourceConnectionResponse/dispatcher" width="100%" align="left" id="maincontent">
											<cp:tableHeader>
												<cp:columnHeader/>
												<!-- Path-Name Column -->
												<cp:columnHeader>
													<!-- All of this is to align the header (...> Name) with the contents of the table-->
													<img height="5" width="1" border="0"><xsl:attribute name="src"><xsl:value-of select="$webcontent"/>/images/space.gif</xsl:attribute></img>
													<xsl:text/><xts:string id="IDS_PATH_INDICATOR"/><xsl:text>&#160;</xsl:text>
													<img height="5" width="1" border="0"><xsl:attribute name="src"><xsl:value-of select="$webcontent"/>/images/space.gif</xsl:attribute></img>
													<xsl:text/><xts:string id="IDS_NAME"/><xsl:text/>
												</cp:columnHeader>
												<cp:columnHeader>
													<xts:string id="IDS_TEST_HEADING_TYPE"/>
													<xsl:if test="$queryServiceIsInstalled">
														<xsl:text> / </xsl:text>
														<xts:string id="IDS_TEST_HEADING_STACK"/>
													</xsl:if> 
												</cp:columnHeader>
												<cp:columnHeader>
													<xts:string id="IDS_HEADING_STATUS"/>
												</cp:columnHeader>
												<cp:columnHeader width="100%">
													<xts:string id="IDS_HEADING_ERROR_MESSAGE"/>
												</cp:columnHeader>
											</cp:tableHeader>
											<!-- Column contents -->
											<cp:tableContent>
												<cp:columnContent>
													<xsl:if test="displayIcon != ''">
														<img>
															<xsl:attribute name="alt"><xsl:value-of select="displayScreenTip"/></xsl:attribute>
															<xsl:attribute name="src"><xsl:value-of select="displayIcon"/></xsl:attribute>
														</img>
													</xsl:if>
												</cp:columnContent>
												<!-- Path-Name Column -->
												<cp:columnContent>
													<xsl:if test="displayName != ''">
														<img height="16" width="20" align="absmiddle">
															<xsl:attribute name="alt">
																<xsl:value-of select="displayPath"/>
															</xsl:attribute>
															<xsl:attribute name="src"><xsl:value-of select="$skin_images"/>path.gif</xsl:attribute>
														</img>
														<xsl:text>   </xsl:text><xsl:value-of select="displayName"/>
													</xsl:if>
												</cp:columnContent>
												<cp:columnContent>
													<span title="{connectionString}">
														<xsl:value-of select="connectionType"/>
													</span>
													<xsl:if test="$queryServiceIsInstalled">
														<xsl:text> / </xsl:text>
														<xsl:value-of select="connectionStack"/>
													</xsl:if>
												</cp:columnContent>
												<cp:columnContent>
													<xsl:choose>
														<xsl:when test="not(errors)">
															<xsl:choose>
																<xsl:when test="count(connectionInfo/message[.!='']) > 1">															
																	<xsl:variable name="msg">
																		<xsl:apply-templates select="connectionInfo/message"/>
																	</xsl:variable>
																	<a href="#" onclick="javascript:alert('{$msg}');"><xts:string id="IDS_JOB_STATUS_SUCCEEDED"/></a>
																</xsl:when>
																<xsl:otherwise>
																	<xts:string id="IDS_JOB_STATUS_SUCCEEDED"/>
																</xsl:otherwise>
															</xsl:choose>
														</xsl:when>
														<xsl:otherwise>
															<xsl:choose>
																<xsl:when test="count(errors/message[.!='']) > 1">															
																	<xsl:variable name="msg">
																		<xsl:apply-templates select="errors/message"/>
																	</xsl:variable>
																	<a href="#" onclick="javascript:alert('{$msg}');"><xts:string id="IDS_JOB_STATUS_FAILED"/></a>
																</xsl:when>
																<xsl:otherwise>
																	<xts:string id="IDS_JOB_STATUS_FAILED"/>
																</xsl:otherwise>
															</xsl:choose>
														</xsl:otherwise>
													</xsl:choose>
												</cp:columnContent>
												<cp:columnContent wrap="true">
													<xsl:choose>
														<xsl:when test="not(errors)">
															<xsl:value-of select="connectionInfo/message[.!=''][1]"/>
														</xsl:when>
														<xsl:otherwise>
															<xsl:value-of select="errors/message[.!=''][1]"/>
														</xsl:otherwise>
													</xsl:choose>
												</cp:columnContent>
											</cp:tableContent>
										</cp:table>				
									</xsl:when>
									<xsl:otherwise>
										<cp:table iterate="/root/testResults/test:testDataSourceConnectionResponse/dispatcher" width="100%" align="left">
											<cp:tableHeader>
												<cp:columnHeader>
													<xts:string id="IDS_TEST_HEADING_TYPE"/>
													<xsl:if test="$queryServiceIsInstalled">
														<xsl:text> / </xsl:text>
														<xts:string id="IDS_TEST_HEADING_STACK"/>
													</xsl:if>
												</cp:columnHeader>
												<cp:columnHeader>
													<xts:string id="IDS_HEADING_STATUS"/>
												</cp:columnHeader>
												<cp:columnHeader width="100%">
													<xts:string id="IDS_HEADING_ERROR_MESSAGE"/>
												</cp:columnHeader>
											</cp:tableHeader>
											<!-- Column contents -->
											<cp:tableContent>
												<cp:columnContent>
													<span title="{connectionString}">
														<xsl:value-of select="connectionType"/>
													</span>
													<xsl:if test="$queryServiceIsInstalled">
														<xsl:text> / </xsl:text>
														<xsl:value-of select="connectionStack"/>
													</xsl:if>
												</cp:columnContent>
												<cp:columnContent>
													<xsl:choose>
														<xsl:when test="not(errors)">
															<xsl:choose>
																<xsl:when test="count(connectionInfo/message[.!='']) > 1">															
																	<xsl:variable name="msg">
																		<xsl:apply-templates select="connectionInfo/message"/>
																	</xsl:variable>
																	<a href="#" onclick="javascript:alert('{$msg}');"><xts:string id="IDS_JOB_STATUS_SUCCEEDED"/></a>
																</xsl:when>
																<xsl:otherwise>
																	<xts:string id="IDS_JOB_STATUS_SUCCEEDED"/>
																</xsl:otherwise>
															</xsl:choose>
														</xsl:when>
														<xsl:otherwise>
															<xsl:choose>
																<xsl:when test="count(errors/message[.!='']) > 1">															
																	<xsl:variable name="msg">
																		<xsl:apply-templates select="errors/message"/>
																	</xsl:variable>
																	<a href="#" onclick="javascript:alert('{$msg}');"><xts:string id="IDS_JOB_STATUS_FAILED"/></a>
																</xsl:when>
																<xsl:otherwise>
																	<xts:string id="IDS_JOB_STATUS_FAILED"/>
																</xsl:otherwise>
															</xsl:choose>
														</xsl:otherwise>
													</xsl:choose>
												</cp:columnContent>
												<cp:columnContent wrap="true">
													<xsl:choose>
														<xsl:when test="not(errors)">
															<xsl:value-of select="connectionInfo/message[.!=''][1]"/>
														</xsl:when>
														<xsl:otherwise>
															<xsl:value-of select="errors/message[.!=''][1]"/>
														</xsl:otherwise>
													</xsl:choose>
												</cp:columnContent>
											</cp:tableContent>
										</cp:table>				
									</xsl:otherwise>
								</xsl:choose>
							</lyt:section>
						</lyt:layout>
						<dp:footer>
							<df:button df:id="IDS_CLOSE" df:style="stack-down"/>
						</dp:footer>
					</utml:form>
				</dp:page>
			</xsl:template>
			<xsl:template match="message">
					<xsl:value-of select="xtsext:javascriptencode(string(.))"/><xsl:if test="string-length(normalize-space(.)) > 0">\n</xsl:if>
			</xsl:template>						
			<!-- Insert common templates -->
			<pf:gen-icon/>
		</xsl:stylesheet>
	</xts:block>
	<!--======================================================================
		Name: 		debug
		Comments:  display the debug info.
	======================================================================-->
	<xts:block id="debug" dependency="resultPage" condition=".[/root/session/param[@name='debug']='1']" type="exec" mode="output" processor="XSLT" mandatory="false" mimeType="text/html">
		<!-- get the debug logic sheet -->
		<xts:logicsheet path="logicsheets/debuglogic.xslt"/>
		<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dbg="http://developer.cognos.com/schemas/xts/logicsheets/xslt/debug/" exclude-result-prefixes="dbg">
			<xsl:output method="html" version="1.0" encoding="UTF-8" indent="no" omit-xml-declaration="yes"/>
			<xsl:template match="/">
				<dbg:dumpxml select="/root"/>
			</xsl:template>
		</xsl:stylesheet>
	</xts:block>
</xts:morphlet>