StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>This is one possible solution:</p> <pre><code><xsl:variable name="vCountRows"> <xsl:apply-templates select="Documents/Section[1]" mode="findmax" /> </xsl:variable> <xsl:variable name="vCountCols" select="count(Documents/Section)" /> <xsl:template match="/Documents"> <table r="{$vCountRows}" s="{$vCountCols}"> <thead> <xsl:call-template name="create-thead" /> </thead> <tbody> <xsl:call-template name="create-tr" /> </tbody> </table> </xsl:template> <xsl:template name="create-thead"> <tr> <xsl:apply-templates select="Section" /> </tr> </xsl:template> <xsl:template match="Section"> <th><xsl:value-of select="SectionName" /></th> </xsl:template> <xsl:template name="create-tr"> <xsl:param name="row" select="1" /> <tr> <xsl:call-template name="create-td"> <xsl:with-param name="row" select="$row" /> </xsl:call-template> </tr> <xsl:if test="$row &lt; $vCountRows"> <xsl:call-template name="create-tr"> <xsl:with-param name="row" select="$row + 1" /> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template name="create-td"> <xsl:param name="col" select="1" /> <xsl:param name="row" select="1" /> <td> <xsl:value-of select="Section[$col]/Document[$row]/FileName" /> </td> <xsl:if test="$col &lt; $vCountCols"> <xsl:call-template name="create-td"> <xsl:with-param name="col" select="$col + 1" /> <xsl:with-param name="row" select="$row" /> </xsl:call-template> </xsl:if> </xsl:template> <xsl:template match="Section" mode="findmax"> <xsl:variable name="c" select="count(Document)" /> <xsl:variable name="next" select="following-sibling::Section[count(Document) &gt; $c][1]" /> <xsl:choose> <xsl:when test="$next"> <xsl:apply-templates select="$next" mode="findmax" /> </xsl:when> <xsl:otherwise> <xsl:value-of select="$c" /> </xsl:otherwise> </xsl:choose> </xsl:template> </code></pre> <p>With your input it produces:</p> <pre><code><table> <thead> <tr> <td>Green</td> <td>MRO/Refurb</td> </tr> </thead> <tbody> <tr> <td>Tier 1 Schedules</td> <td>Tier 2 Governance</td> </tr> <tr> <td>Tier 3 Schedules</td> <td></td> </tr> <tr> <td>Setback Schedule</td> <td></td> </tr> <tr> <td>Tier 2 Governance</td> <td></td> </tr> </tbody> </table> </code></pre> <p>The general apporach goes like this:</p> <ol> <li>Find out how many rows we are going to get (this happens in <code><xsl:template match="Section" mode="findmax"></code>, which recursively finds the section with the maximum number of <code><Document></code> nodes</li> <li>Find out how many columns we are going to get (by counting the number of <code><Section></code>s)</li> <li>calling a templates that creates a <code><tr></code>, and keeps calling itself until all necessary rows have been created</li> <li>in this template, a second template is called, this one creates the <code><td></code>s. It keeps calling itself until it reaches the max number of columns (from step 2)</li> </ol> <p>The algorithm:</p> <ul> <li>uses incrementing column- and row-numbers as indexes</li> <li>uses recursion to achieve one-by-one index increments (since actually incrementing a variable is impossible in XSLT)</li> <li>creates the right number of empty cells for sections that have less documents</li> </ul> <p>A more efficient version (probably using <code><xsl:key></code>s) exists, I'll look into optimizing mine a little more.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload