analytics/templates/ps/transforms/portal/schedule/generateParams.xslt

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

    IBM Cognos Products: ps

    (C) Copyright IBM Corp. 2005, 2011

    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).
-->
<xsl:stylesheet version="1.0" 
	xmlns:xtsext="xalan://com.cognos.xts.ext.XTSExt" 
	xmlns:cm="http://developer.cognos.com/schemas/xts-cm/1/" 
	xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
	xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
	xmlns:xts="http://developer.cognos.com/schemas/xts/" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	exclude-result-prefixes="xsd xsi xts">
		
	<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="no"/>

	<xsl:template match="schedule" priority="1">
		<xsl:call-template name="timeParams"/>

		<xsl:apply-templates/>
	</xsl:template>
	
	<xsl:template match="timeZone" priority="2"/>

	<!--
	===============================================================================================
	timeParams - even if no schedule was saved we must create these params
	===============================================================================================
	-->	
	<xsl:template name="timeParams" priority="2">
		<!-- Date variables -->
		<xsl:variable name="xsl_UTC_timeformat" select="'yyyy-MM-dd HH:mm:00'"/>
		<xsl:variable name="timeZone" select="timeZone"/>
		<xsl:variable name="contentLocale" select="contentLocale"/>
		<xsl:variable name="currentTime"><xsl:value-of select="xtsext:getCurrentDateTime(string($timeZone))"/></xsl:variable>
		<xsl:variable name="current_day" select="substring(string($currentTime),9,2)"/>
		<xsl:variable name="current_month" select="substring(string($currentTime),6,2)"/>
		<xsl:variable name="endDate">
			<xsl:choose>
				<xsl:when test="cm:schedule/cm:endDate[not(@nil)] and not(cm:schedule/cm:type = 'trigger' and cm:schedule/cm:triggerName[@nil])">
					<xsl:value-of select="xtsext:formatDateFromUTC(string(cm:schedule/cm:endDate),string($xsl_UTC_timeformat),string($timeZone),string($contentLocale))"/>
				</xsl:when>
				<xsl:otherwise><xsl:value-of select="$currentTime"/></xsl:otherwise>
			</xsl:choose>
		</xsl:variable>
		<xsl:variable name="startDate">
			<xsl:choose>
				<xsl:when test="cm:schedule/cm:startDate[not(@nil)] and not(cm:schedule/cm:type = 'trigger' and cm:schedule/cm:triggerName[@nil])">
					<xsl:value-of select="xtsext:formatDateFromUTC(string(cm:schedule/cm:startDate),string($xsl_UTC_timeformat),string($timeZone),string($contentLocale))"/>
				</xsl:when>			
				<xsl:otherwise><xsl:value-of select="$currentTime"/></xsl:otherwise>
			</xsl:choose>
		</xsl:variable>
		
		<param name="current_day"><xsl:value-of select="$current_day"/></param>
		<param name="current_month">
			<xsl:choose>
				<xsl:when test="$current_month='01'">january</xsl:when>
				<xsl:when test="$current_month='02'">february</xsl:when>
				<xsl:when test="$current_month='03'">march</xsl:when>
				<xsl:when test="$current_month='04'">april</xsl:when>
				<xsl:when test="$current_month='05'">may</xsl:when>
				<xsl:when test="$current_month='06'">june</xsl:when>
				<xsl:when test="$current_month='07'">july</xsl:when>
				<xsl:when test="$current_month='08'">august</xsl:when>
				<xsl:when test="$current_month='09'">september</xsl:when>
				<xsl:when test="$current_month='10'">october</xsl:when>
				<xsl:when test="$current_month='11'">november</xsl:when>
				<xsl:when test="$current_month='12'">december</xsl:when>
			</xsl:choose>
		</param>
		<param name="timezone"><xsl:value-of select="$timeZone"/></param>
		<!-- for prompt control start date-->
		<param name="p_sched_date1">
			<xsl:value-of select="substring(string($startDate),1,10)"/>
		</param>
		<!-- for prompt control start time -->
		<param name="p_sched_time1">
			<xsl:value-of select="concat(substring(string($startDate),12,19), '.000')"/>
		</param>	

		<!-- for prompt control end date-->
		<param name="p_sched_date2">
			<xsl:value-of select="substring(string($endDate),1,10)"/>
		</param>
		<!-- for prompt control end time -->
		<param name="p_sched_time2">
			<xsl:value-of select="concat(substring(string($endDate),12,19), '.000')"/>
		</param>
	</xsl:template>
	
	<!--
	===============================================================================================
	if a schedule was saved in CM then produce the proper params
	===============================================================================================
	-->		
	<xsl:template match="cm:schedule" priority="2">
		<xsl:variable name="xsl_UTC_timeformat">
  			<xsl:text>yy-MM-dd'T'HH:mm:00</xsl:text>
  		</xsl:variable>
		<xsl:if test="cm:active='false'">
			<param name="m_sp_active">true</param>
		</xsl:if>
		<xsl:if test="cm:priority[not(@nil)]">
			<param name="m_sp_priority">
				<xsl:value-of select="cm:priority"/>
			</param>
		</xsl:if>
		<xsl:if test="cm:endType[not(@nil)]">
			<param name="m_sp_endType">
				<xsl:value-of select="cm:endType"/>
			</param>
		</xsl:if>
		<xsl:if test="cm:type[not(@nil)]">
			<param name="m_sp_type">
				<xsl:choose>
					<xsl:when test="cm:type='monthlyAbsolute' or cm:type='monthlyRelative'">monthly</xsl:when>
					<xsl:when test="cm:type='yearlyAbsolute' or cm:type='yearlyRelative'">yearly</xsl:when>
					<xsl:otherwise><xsl:value-of select="cm:type"/></xsl:otherwise>
				</xsl:choose>
			</param>
		</xsl:if>
		<xsl:if test="cm:triggerName[not(@nil)]">
			<param name="m_sp_triggerName">
				<xsl:value-of select="cm:triggerName"/>
			</param>
		</xsl:if>
		<xsl:if test="cm:type != 'trigger'">
			<xsl:if test="cm:dailyPeriod[not(@nil)]">
				<param name="m_sp_dailyPeriod"><xsl:value-of select="cm:dailyPeriod"/></param>
			</xsl:if>
			<xsl:if test="cm:everyNPeriods[not(@nil)]">
				<param name="m_sp_everyNminutes"><xsl:value-of select="cm:everyNPeriods"/></param>
				<param name="m_sp_everyNhours"><xsl:value-of select="cm:everyNPeriods"/></param>
				<param name="m_sp_everyNdays"><xsl:value-of select="cm:everyNPeriods"/></param>
				<param name="m_sp_everyNweeks"><xsl:value-of select="cm:everyNPeriods"/></param>
				<param name="m_sp_everyNmonthsAbs"><xsl:value-of select="cm:everyNPeriods"/></param>
				<param name="m_sp_everyNmonthsRel"><xsl:value-of select="cm:everyNPeriods"/></param>
			</xsl:if>
			<xsl:if test="cm:monthlyAbsoluteDay[not(@nil)]">
				<param name="m_sp_monthlyAbsoluteDay"><xsl:value-of select="cm:monthlyAbsoluteDay"/></param>
			</xsl:if>
			<xsl:if test="cm:monthlyRelativeDay[not(@nil)]">
				<param name="m_sp_monthlyRelativeDay"><xsl:value-of select="cm:monthlyRelativeDay"/></param>
			</xsl:if>
			<xsl:if test="cm:monthlyRelativeWeek[not(@nil)]">
				<param name="m_sp_monthlyRelativeWeek"><xsl:value-of select="cm:monthlyRelativeWeek"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklyFriday[not(@nil)]">
				<param name="m_sp_weeklyFriday"><xsl:value-of select="cm:weeklyFriday"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklyMonday[not(@nil)]">
				<param name="m_sp_weeklyMonday"><xsl:value-of select="cm:weeklyMonday"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklySaturday[not(@nil)]">
				<param name="m_sp_weeklySaturday"><xsl:value-of select="cm:weeklySaturday"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklySunday[not(@nil)]">
				<param name="m_sp_weeklySunday"><xsl:value-of select="cm:weeklySunday"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklyThursday[not(@nil)]">
				<param name="m_sp_weeklyThursday"><xsl:value-of select="cm:weeklyThursday"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklyTuesday[not(@nil)]">
				<param name="m_sp_weeklyTuesday"><xsl:value-of select="cm:weeklyTuesday"/></param>
			</xsl:if>
			<xsl:if test="cm:weeklyWednesday[not(@nil)]">
				<param name="m_sp_weeklyWednesday"><xsl:value-of select="cm:weeklyWednesday"/></param>
			</xsl:if>
			<xsl:if test="cm:yearlyAbsoluteDay[not(@nil)]">
				<param name="m_sp_yearlyAbsoluteDay"><xsl:value-of select="cm:yearlyAbsoluteDay"/></param>
			</xsl:if>
			<xsl:if test="cm:yearlyAbsoluteMonth[not(@nil)]">
				<param name="m_sp_yearlyAbsoluteMonth"><xsl:value-of select="cm:yearlyAbsoluteMonth"/></param>
			</xsl:if>
			<xsl:if test="cm:yearlyRelativeDay[not(@nil)]">
				<param name="m_sp_yearlyRelativeDay"><xsl:value-of select="cm:yearlyRelativeDay"/></param>
			</xsl:if>
			<xsl:if test="cm:yearlyRelativeMonth[not(@nil)]">
				<param name="m_sp_yearlyRelativeMonth"><xsl:value-of select="cm:yearlyRelativeMonth"/></param>
			</xsl:if>
			<xsl:if test="cm:yearlyRelativeWeek[not(@nil)]">
				<param name="m_sp_yearlyRelativeWeek"><xsl:value-of select="cm:yearlyRelativeWeek"/></param>
			</xsl:if>
			
			<xsl:if test="contains(cm:type,'Absolute')">
				<param name="sub_type">absolute</param>
			</xsl:if>
			<xsl:if test="contains(cm:type,'Relative')">
				<param name="sub_type">relative</param>
			</xsl:if>
			<xsl:variable name="currentTime"><xsl:value-of select="xtsext:getCurrentDateTime(string(../timeZone))"/></xsl:variable>
			<xsl:variable name="startDate">
				<xsl:choose>
					<xsl:when test="cm:startDate[not(@nil)] and not(cm:type = 'trigger' and cm:triggerName[@nil])">
						<xsl:value-of select="cm:startDate"/>
					</xsl:when>			
					<xsl:otherwise><xsl:value-of select="$currentTime"/></xsl:otherwise>
				</xsl:choose>
			</xsl:variable>
			<xsl:choose>
 				<xsl:when test="cm:intradayRecurrenceStart[not(@nil)]">
 					<xsl:variable name="recurrenceStartDateTimeGMT" select="concat(substring-before($startDate,'T'),'T', cm:intradayRecurrenceStart)"/>
 					<xsl:variable name="recurrenceStartDateTimeUserTZ" select="xtsext:formatDateFromUTC($recurrenceStartDateTimeGMT,string($xsl_UTC_timeformat),string(../timeZone),string(../contentLocale))"/>
 					<param name="p_intradayRecurrenceStart">
 						<xsl:value-of select="substring-after($recurrenceStartDateTimeUserTZ,'T')"/>
 					</param>
 				</xsl:when>
 			</xsl:choose>
 			<xsl:choose>
 				<xsl:when test="cm:intradayRecurrenceEnd[not(@nil)]">
 					<xsl:variable name="recurrenceEndDateTimeGMT" select="concat(substring-before($startDate,'T'),'T', cm:intradayRecurrenceEnd)"/>
 					<xsl:variable name="recurreneEndDateTimeUserTZ" select="xtsext:formatDateFromUTC($recurrenceEndDateTimeGMT,string($xsl_UTC_timeformat),string(../timeZone),string(../contentLocale))"/>
 					<param name="p_intradayRecurrenceEnd">
 						<xsl:value-of select="substring-after($recurreneEndDateTimeUserTZ,'T')"/>
 					</param>
 				</xsl:when>
 			</xsl:choose>
 
			<xsl:if test="contains(cm:type,'WithIntradayRecurrence')">
				<param name="df_intra">true</param>
			</xsl:if>
 			<xsl:choose>
 				<xsl:when test="cm:intradayRecurrenceInterval[not(@nil)]">
 					<!-- cm:intradayRecurrenceInterval is expected in the format: PT#M or PT#H -->
 					<param name="m_sp_intradayRecurrenceIntervalNum">
 						<xsl:value-of select="substring-after(substring(cm:intradayRecurrenceInterval, 1, string-length(cm:intradayRecurrenceInterval)-1), 'PT')"/>
 					</param>
 					<xsl:variable name="unit" select="substring(cm:intradayRecurrenceInterval, string-length(cm:intradayRecurrenceInterval))"/>
 					<param name="m_sp_intradayRecurrenceIntervalUnit">
 						<xsl:value-of select="$unit"/>
 					</param>
 				</xsl:when>
 			</xsl:choose>
		</xsl:if>
	</xsl:template>
</xsl:stylesheet>