Subject: [xsl] Re: using keys for counting not sorting From: Dimitre Novatchev <dnovatchev@xxxxxxxxx> Date: Sun, 30 Dec 2001 00:19:12 -0800 (PST) |
Oopps... In my previous message I didn't take into account "characters" that only received messages, but didn't send any. Here's the now correct solution: <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="text"/> <xsl:key name="kByID" match="DIRECT" use="CHARACTER_ID"/> <xsl:key name="kByTargetID" match="TARGET_CHARACTER_ID" use="."/> <xsl:variable name="vUniqueCharactersSending" select="LOG/DIRECT[generate-id() = generate-id(key('kByID', CHARACTER_ID )[1] ) ]"/> <xsl:variable name="vUniqueCharactersReceiving" select="LOG/DIRECT/TARGET_CHARACTER_ID [generate-id() = generate-id(key('kByTargetID', . )[1] ) ]"/> <xsl:variable name="vNumCharactersSending" select="count($vUniqueCharactersSending)"/> <xsl:variable name="vNumCharactersReceiving" select="count($vUniqueCharactersReceiving)"/> <xsl:variable name="vTotalSent" select="count(LOG/DIRECT/CHARACTER_ID)"/> <xsl:variable name="NL" select="'
'"/> <xsl:template match="/"> <xsl:for-each select="$vUniqueCharactersSending"> <xsl:value-of select="concat('CHARACTER_ID ',CHARACTER_ID, ' sent ', count(key('kByID',CHARACTER_ID)), ' messages, received ', count(key('kByTargetID',CHARACTER_ID)), $NL )"/> </xsl:for-each> <xsl:for-each select="$vUniqueCharactersReceiving [not(key('kByID', .))]"> <xsl:value-of select="concat('CHARACTER_ID ', ., ' sent 0 messages, received ', count(key('kByTargetID',.)), $NL )"/> </xsl:for-each> <xsl:value-of select="$NL"/> <xsl:value-of select="concat('Number of characters having sent a message: ', $vNumCharactersSending, $NL )"/> <xsl:value-of select="concat('Number of characters having received a message: ', $vNumCharactersReceiving, $NL )"/> <xsl:value-of select="$NL"/> <xsl:value-of select="concat('Total sent: ', $vTotalSent, ', Average sent by a sending character: ', $vTotalSent div $vNumCharactersSending, '
', 'Total received: ', $vTotalSent, ', Average received by a receiving character: ', $vTotalSent div $vNumCharactersReceiving, '
' )"/> </xsl:template> </xsl:stylesheet> When this is applied to the following xml sorce document: <LOG> <DIRECT> <COMMUNICATION_TYPE>PAGETELL</COMMUNICATION_TYPE> <Invoc_serial>27</Invoc_serial> <Serial>3087908</Serial> <USAGE>TELL</USAGE> <MESSAGE_TYPE>EMOTE</MESSAGE_TYPE> <CHARACTER_ID>10010</CHARACTER_ID> <CHARACTER_STATUS>3</CHARACTER_STATUS> <LOCATION_ID>45040</LOCATION_ID> <TARGET_CHARACTER_ID>444444</TARGET_CHARACTER_ID> <TARGET_CHARACTER_STATUS>6</TARGET_CHARACTER_STATUS> <TARGET_CHARACTER_LOCATION_ID>23222</TARGET_CHARACTER_LOCATION_ID> <MESSAGE>hello</MESSAGE> <TIME>'Mon, 26 Nov 2001 15:40:29 +0000'</TIME> </DIRECT> <DIRECT> <COMMUNICATION_TYPE>PAGETELL</COMMUNICATION_TYPE> <Invoc_serial>27</Invoc_serial> <Serial>3087908</Serial> <USAGE>TELL</USAGE> <MESSAGE_TYPE>EMOTE</MESSAGE_TYPE> <CHARACTER_ID>10010</CHARACTER_ID> <CHARACTER_STATUS>3</CHARACTER_STATUS> <LOCATION_ID>45040</LOCATION_ID> <TARGET_CHARACTER_ID>444444</TARGET_CHARACTER_ID> <TARGET_CHARACTER_STATUS>6</TARGET_CHARACTER_STATUS> <TARGET_CHARACTER_LOCATION_ID>23222</TARGET_CHARACTER_LOCATION_ID> <MESSAGE>hello</MESSAGE> <TIME>'Mon, 26 Nov 2001 15:40:29 +0000'</TIME> </DIRECT> <DIRECT> <COMMUNICATION_TYPE>PAGETELL</COMMUNICATION_TYPE> <Invoc_serial>27</Invoc_serial> <Serial>3087908</Serial> <USAGE>TELL</USAGE> <MESSAGE_TYPE>EMOTE</MESSAGE_TYPE> <CHARACTER_ID>444444</CHARACTER_ID> <CHARACTER_STATUS>3</CHARACTER_STATUS> <LOCATION_ID>45040</LOCATION_ID> <TARGET_CHARACTER_ID>10010</TARGET_CHARACTER_ID> <TARGET_CHARACTER_STATUS>6</TARGET_CHARACTER_STATUS> <TARGET_CHARACTER_LOCATION_ID>23222</TARGET_CHARACTER_LOCATION_ID> <MESSAGE>hello</MESSAGE> <TIME>'Mon, 26 Nov 2001 15:40:29 +0000'</TIME> </DIRECT> <DIRECT> <COMMUNICATION_TYPE>PAGETELL</COMMUNICATION_TYPE> <Invoc_serial>27</Invoc_serial> <Serial>3087908</Serial> <USAGE>TELL</USAGE> <MESSAGE_TYPE>EMOTE</MESSAGE_TYPE> <CHARACTER_ID>50050</CHARACTER_ID> <CHARACTER_STATUS>3</CHARACTER_STATUS> <LOCATION_ID>45040</LOCATION_ID> <TARGET_CHARACTER_ID>60060</TARGET_CHARACTER_ID> <TARGET_CHARACTER_STATUS>6</TARGET_CHARACTER_STATUS> <TARGET_CHARACTER_LOCATION_ID>23222</TARGET_CHARACTER_LOCATION_ID> <MESSAGE>hello</MESSAGE> <TIME>'Mon, 26 Nov 2001 15:40:29 +0000'</TIME> </DIRECT></LOG> The result is: CHARACTER_ID 10010 sent 2 messages, received 1 CHARACTER_ID 444444 sent 1 messages, received 2 CHARACTER_ID 50050 sent 1 messages, received 0 CHARACTER_ID 60060 sent 0 messages, received 1 Number of characters having sent a message: 3 Number of characters having received a message: 3 Total sent: 4, Average sent by a sending character: 1.3333333333333332 Total received: 4, Average received by a receiving character: 1.3333333333333332 Cheers, Dimitre. __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Re: using keys for counting n, Dimitre Novatchev | Thread | [xsl] Re: Creating an input form, X, Dimitre Novatchev |
[xsl] Re: using keys for counting n, Dimitre Novatchev | Date | Re: [xsl] Creating an input form, X, Trevor Nash |
Month |