counting type of element

sbutt · July 16th, 2013, 11:58 AM

Hi All,
I want to count the number of passengers individually, which are characterized by their age. For example, age <= 2 years is infant, age <= 12 years is child, else = adult.

I have been given with the date of birth of every passenger. From DOB, I need to calculate the age and then I have to count the passengers in 3 above categories.

Input..

Code:

                 <ns3:PassengerCounts>
                    <ns3:PassengerCount BirthDate="1988-04-16"/>
                    <ns3:PassengerCount BirthDate="1988-04-16"/>
                </ns3:PassengerCounts>

In the output, I need to create 3 different variable, which i will then place at the appropriate position.

Code:

<xsl:variable name="adultCount"> ??? </xsl:variable>
<xsl:variable name="childCount"> ??? </xsl:variable>
<xsl:variable name="infantCount"> ??? </xsl:variable>

I have created a following variable, which uses a template to return the passenger age, but I am a bit confused as to how I can count the total number of adults, children and infants from it?

Any help in xslt 1, would be appreciated. Thanks.

Code:

<xsl:variable name="age">
					<xsl:call-template name="getAge_template">
						<xsl:with-param name="birhtdate" select="@BirthDate"/>
						<xsl:with-param name="traveldate" select="//ota:OTA_TT_GroundAvailRQ/ota:Locations[1]/ota:Pickup/@DateTime"/>
					</xsl:call-template>
				</xsl:variable>		


<xsl:template name="getAge_template">
		<xsl:param name="birhtdate"/>
		<xsl:param name="traveldate"/>
		<xsl:param name="pattern">yyyy-MM-dd</xsl:param>
		<xsl:param name="age" select="java:text.ParsePosition.new(0)"/>
		<xsl:variable name="sdformater" select="java:text.SimpleDateFormat.new($pattern)"/>
		<xsl:variable name="bd" select="java:util.Calendar.getInstance()"/>
		<xsl:variable name="td" select="java:util.Calendar.getInstance()"/>
		<xsl:if test="java:setTimeInMillis($bd, java:getTime(java:parse($sdformater, $birhtdate)))"/>
		<xsl:if test="java:setTimeInMillis($td, java:getTime(java:parse($sdformater, $traveldate)))"/>
		<xsl:if test="java:setIndex($age, java:get($td, 1) - java:get($bd, 1) )"/>
		<xsl:choose>
			<xsl:when test="java:get($td, 2) &lt; java:get($bd, 2)">
				<xsl:value-of select="java:getIndex($age) -1"/>
			</xsl:when>
			<xsl:when test=" java:get($td, 2) = java:get($bd, 2)  and java:get($td, 5) &lt; java:get($bd, 5)">
				<xsl:value-of select="java:getIndex($age) -1"/>
			</xsl:when>
			<xsl:otherwise>
				<xsl:value-of select="java:getIndex($age)"/>
			</xsl:otherwise>
		</xsl:choose>
	</xsl:template>

Martin Honnen · July 16th, 2013, 12:02 PM

All those uses of Java APIs suggest your XSLT processor is implemented in Java. That means you should be able to use the Java version of Saxon 9 and XSLT 2.0 and that way you could implement it in pure XSLT 2.0, no?

sbutt · July 16th, 2013, 12:08 PM

it's a huge xsl file, which are using xslt 1.0 features and by using xslt 2 for this problem, the other things would get disturbed, unfortunately.

mhkay · July 16th, 2013, 12:19 PM

>it's a huge xsl file, which are using xslt 1.0 features and by using xslt 2 for this problem, the other things would get disturbed, unfortunately.

What makes you think that? It's entirely possible to introduce XSLT 2.0 features incrementally into a 1.0 stylesheet.

sbutt · July 16th, 2013, 12:25 PM

I can try if u could help?

Martin Honnen · July 16th, 2013, 02:07 PM

If you want to use XSLT 2.0 then http://www.stylusstudio.com/xsllist/...post60440.html has some snippet to try to compute the age.

sbutt · July 16th, 2013, 02:59 PM

thanks for the info, Martin. My main problem is to compute the count per passenger type (adult, children, infant). Age calculation i could do myself but I couldnt able to handle the count factor. May be some pointer in that direction might help?

Thanks.

sbutt · July 17th, 2013, 07:38 AM

this is how i finally managed to do it:

Code:

	<xsl:variable name="checkAgeInfants">
			<xsl:value-of select="xs:date(xs:dateTime(ota:Locations[1]/ota:Pickup/@DateTime)) - xs:yearMonthDuration('P2Y')"/>
		</xsl:variable>
		<xsl:variable name="checkAgeChildren">
			<xsl:value-of select="xs:date(xs:dateTime(ota:Locations[1]/ota:Pickup/@DateTime)) - xs:yearMonthDuration('P12Y')"/>
		</xsl:variable>


		<xsl:variable name="adultCount">
			<xsl:value-of select="count(ota:PassengerPreferences/ota:PassengerCounts/ota:PassengerCount[xs:date(@BirthDate) &lt; xs:date($checkAgeChildren)])"/>
		</xsl:variable>
		<xsl:message>adultCount <xsl:value-of select="$adultCount"/>
		</xsl:message>
		<xsl:variable name="childCount">
			<xsl:value-of select="count(ota:PassengerPreferences/ota:PassengerCounts/ota:PassengerCount[(xs:date(@BirthDate) &gt; xs:date($checkAgeChildren)) and (xs:date(@BirthDate) &lt; xs:date($checkAgeInfants))])"/>
		</xsl:variable>
		<xsl:message>childCount <xsl:value-of select="$childCount"/>
		</xsl:message>
		<xsl:variable name="infantCount">
			<xsl:value-of select="count(ota:PassengerPreferences/ota:PassengerCounts/ota:PassengerCount[xs:date(@BirthDate) &gt; xs:date($checkAgeInfants)])"/>
		</xsl:variable>