Ratha's Ground!: February 2012

Friday, February 10, 2012

Implementing incremental logic in XSLT

I faced difficult time to implement the incremental logic for xslt 1.0 today..My requirement was to printout consequent numbers upto a certain value.
Here is my sample segment xslt code for this..

<xsl:element name="Numbers">

                              <xsl:for-each select="//flight_info">

                              <xsl:if test="position()= last()">

                                  <xsl:call-template name="incrementValue">

                                      <xsl:with-param name="i" select="1"/>

                                     <xsl:with-param name="pos" select="position()"/>

                                </xsl:call-template>

                                </xsl:if>

                             </xsl:for-each>

     </xsl:element>

//This template does the trick, which contains the recursive call to the same template..

    <xsl:template name="incrementValue">

        <xsl:param name="i" />

        <xsl:param name="pos" />

        <xsl:if test="$i <= $pos">

            <xsl:value-of select="concat($i,' ')" />

            <xsl:call-template name="incrementValue">

                <xsl:with-param name="i" select="$i + 1" />

                <xsl:with-param name="pos" select="$pos" />

            </xsl:call-template>

        </xsl:if>

    </xsl:template>

Monday, February 6, 2012

Date conversion function in XSLT

Recently, i found a need to convert one format to different date formats using XSLT script..This is a sample script i wrote to convert Thu Jun 07 18:00:00 EDT 2012 --to--> 2012-06-07T18:00:00 which may be useful to others also...

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    
    <xsl:template match="/">

        <xsl:element name="PickUpDateTime">
            <xsl:call-template name="FormatDate">
                <xsl:with-param name="DateTime" select="//date" />
            </xsl:call-template>
        </xsl:element>

    </xsl:template>

    <xsl:template name="FormatDate">
        <xsl:param name="DateTime" />
        
        <xsl:variable name="day">
            <xsl:value-of select="substring($DateTime,1,3)" />
        </xsl:variable>

        <xsl:variable name="month-temp">
            <xsl:value-of select="substring-after($DateTime,' ')" />
        </xsl:variable>
        <xsl:variable name="month">
            <xsl:value-of select="substring($month-temp,1,3)" />
        </xsl:variable>

        <xsl:variable name="date-temp">
            <xsl:value-of select="substring-after($month-temp,' ')" />
        </xsl:variable>
        <xsl:variable name="date">
            <xsl:value-of select="substring($date-temp,1,2)" />
        </xsl:variable>

        <xsl:variable name="year">
            <xsl:value-of select="substring-after($DateTime,'EDT ')" />
        </xsl:variable>

        <xsl:variable name="time">
            <xsl:value-of select="substring-after($date-temp,' ')" />
        </xsl:variable>

        <xsl:variable name="hh">
            <xsl:value-of select="substring($time,1,2)" />
        </xsl:variable>
        <xsl:variable name="mm">
            <xsl:value-of select="substring($time,4,2)" />
        </xsl:variable>
        <xsl:variable name="ss">
            <xsl:value-of select="substring($time,7,2)" />
        </xsl:variable>

        <xsl:value-of select="$year" />

        <xsl:value-of select="'-'" />

        <xsl:choose>
            <xsl:when test="$month = 'Jan'">01</xsl:when>
            <xsl:when test="$month= 'Feb'">02</xsl:when>
            <xsl:when test="$month = 'Mar'">03</xsl:when>
            <xsl:when test="$month = 'Apr'">04</xsl:when>
            <xsl:when test="$month = 'May'">05</xsl:when>
            <xsl:when test="$month = 'Jun'">06</xsl:when>
            <xsl:when test="$month = 'Jul'">07</xsl:when>
            <xsl:when test="$month = 'Aug'">08</xsl:when>
            <xsl:when test="$month = 'Sep'">09</xsl:when>
            <xsl:when test="$month = 'Oct'">10</xsl:when>
            <xsl:when test="$month = 'Nov'">11</xsl:when>
            <xsl:when test="$month = 'Dec'">12</xsl:when>
        </xsl:choose>

        <xsl:value-of select="'-'" />

        <xsl:value-of select="$date" />
        <xsl:value-of select="'T'" />
        <xsl:value-of select="$hh" />
        <xsl:value-of select="':'" />
        <xsl:value-of select="$mm" />
        <xsl:value-of select="':'" />
        <xsl:value-of select="$ss" />
    </xsl:template>
</xsl:stylesheet>