This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

DEVELOPERS FORUM - XSLT BOM Report Help

オフライン Archive User 13 年以上前

jsnosal - Tuesday, December 18, 2012 12:59 PM:

I'm having issues with the rows inside my form. When there are two AML parts and three documents, the second document row is blank. I'm not sure what is causing this. Thank you for your help.

</Relationships>

</Item>

Style Sheet

<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:aras="www.aras-corp.com">

<xsl:output method="html" omit-xml-declaration="yes" standalone="yes" indent="yes"></xsl:output>

<xsl:template match="/">

<html>

table {empty-cells:show; border-collapse:collapse;}

th {font-family:helvetica; font-size:8pt; padding:2px; border:1px #000000 solid; background-color:#CCCCCC; text-transform:capitalize;}

td {font-family:helvetica; font-size:8pt; padding:2px; border:1px #000000 solid;}

td.noBorder {font-family:helvetica; font-size:8pt; padding:2px; border-width:0;}

</style>

</td>

</tr>

<td class="noBorder" colspan="13" style="font-family:helvetica;font-size:15pt;color:#DA1943;padding:2px;" align="left" uniqueID="ms__id22">Bill of Materials Report - <xsl:value-of select="//Item/name"></xsl:value-of> Rev <xsl:value-of select="//Item/major_rev"></xsl:value-of>

</td>

<td class="noBorder" colspan="7" style="font-family:helvetica;font-size:10pt;padding:2px;" align="right" uniqueID="ms__id23">Generated on: <script>function m00(r, n){r += ""; if (!n) n = 2; while(r.length < n){r = "0" + r;} return r;} var dt = new Date(); var a = top.opener.top.aras; if (a){var s = m00(dt.getUTCFullYear(),4)+"-"+m00((dt.getUTCMonth()+1))+"-"+m00(dt.getUTCDate())+"T"+m00(dt.getUTCHours())+":"+m00(dt.getUTCMinutes())+":"+m00(dt.getUTCSeconds())+"+0000"; s = a.convertToNeutral(s, "date", "yyyy-MM-ddTHH:mm:sszzz"); s = a.convertFromNeutral(s, "date", "short_date"); document.write(s);}</script>

</td>

</tr>

<tr>

<th colspan="6">Indenture Level</th>

<th>Part Number</th>

<th>Legacy Part Number</th>

<th>Revision</th>

<th>Description</th>

<th>Parameters</th>

<th>Quantity</th>

<th>Reference Designator</th>

<th>AML Status</th>

<th>Manufacturer</th>

<th>Manufacturer Part</th>

<th>Document Number</th>

<th>Document Name</th>

<th>Document Rev</th>

</tr>

<xsl:apply-templates select="//Item[@type='Part']"></xsl:apply-templates>

</table>

</body>

</html>

</xsl:template>

<xsl:template match="Item[@type='Part']">

<xsl:variable name="Depth" select="count(ancestor::Item[@type='Part'])"></xsl:variable>

<xsl:variable name="AML">

<xsl:choose>

<xsl:when test="count(Relationships/Item[@type='Part AML'])=0">1</xsl:when>

<xsl:otherwise>

<xsl:value-of select="count(Relationships/Item[@type='Part AML'])"></xsl:value-of>

</xsl:otherwise>

</xsl:choose>

</xsl:variable>

<xsl:variable name="Doc">

<xsl:choose>

<xsl:when test="count(Relationships/Item[@type='Part Document'])=0">1</xsl:when>

<xsl:otherwise>

<xsl:value-of select="count(Relationships/Item[@type='Part Document'])"></xsl:value-of>

</xsl:otherwise>

</xsl:choose>

</xsl:variable>

<xsl:variable name="rowCount">

<xsl:choose>

<xsl:when test="$AML <= $Doc"><xsl:value-of select="$Doc"></xsl:value-of></xsl:when>

<xsl:otherwise>

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

</xsl:otherwise>

</xsl:choose>

</xsl:variable>

<tr>

<xsl:if test="$Depth=0">0</xsl:if>

</td>

<xsl:if test="$Depth=1">1</xsl:if>

</td>

<xsl:if test="$Depth=2">2</xsl:if>

</td>

<xsl:if test="$Depth=3">3</xsl:if>

</td>

<xsl:if test="$Depth=4">4</xsl:if>

</td>

<xsl:if test="$Depth=5">5</xsl:if>

</td>

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

</td>

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

</td>

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

</td>

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

</td>

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

</td>

<xsl:choose>

<xsl:when test="$Depth=0">1</xsl:when>

<xsl:when test="$Depth!=0 and (../../quantity)=''">1</xsl:when>

<xsl:otherwise>

<xsl:value-of select="../../quantity"></xsl:value-of>

</xsl:otherwise>

</xsl:choose>

</td>

<xsl:value-of select="../../reference_designator"></xsl:value-of>

</td>

<xsl:value-of select="Relationships/Item[@type='Part AML'][1]/state"></xsl:value-of>

</td>

<xsl:value-of select="Relationships/Item[@type='Part AML'][1]/related_id/Item/manufacturer/@keyed_name"></xsl:value-of>

</td>

<xsl:value-of select="Relationships/Item[@type='Part AML'][1]/related_id/Item/item_number"></xsl:value-of>

</td>

<xsl:value-of select="Relationships/Item[@type='Part Document'][1]/related_id/Item/item_number"></xsl:value-of>

</td>

<xsl:value-of select="Relationships/Item[@type='Part Document'][1]/related_id/Item/name"></xsl:value-of>

</td>

<xsl:value-of select="Relationships/Item[@type='Part Document'][1]/related_id/Item/major_rev"></xsl:value-of>

</td>

<xsl:value-of select="count(Relationships/Item[@type='Part AML'])"></xsl:value-of>

</td>

<xsl:value-of select="count(Relationships/Item[@type='Part Document'])"></xsl:value-of>

</td>

</tr>

<xsl:apply-templates select="Relationships/Item[@type='Part AML'][position()!=1] | Relationships/Item[@type='Part Document'][position()!=1]"></xsl:apply-templates>

</xsl:template>

<xsl:template match="Item[@type='Part AML'] | Item[@type='Part Document']">

<tr>

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

</td>

<xsl:value-of select="related_id/Item/manufacturer/@keyed_name"></xsl:value-of>

</td>

<xsl:value-of select="related_id[@type='Manufacturer Part']/Item/item_number"></xsl:value-of>

</td>

<xsl:value-of select="related_id[@type='Document']/Item/item_number"></xsl:value-of>

</td>

<xsl:value-of select="related_id[@type='Document']/Item/name"></xsl:value-of>

</td>

<xsl:value-of select="related_id/Item/major_rev"></xsl:value-of>

</td>

</tr>

</xsl:template>

</xsl:stylesheet>

Brian - Thursday, December 20, 2012 1:02 AM:

Hi Jsonal,

Can you send me an email with the actual output of that query plus the stylesheet as attached files?

I can have a look at them and see if something jumps out.

Cheers,

Brian ([email protected])

jsnosal - Wednesday, January 9, 2013 10:56 AM:

I found the solution for this issue. I worked with JLRishe at Stackoverflow.com and the whole BOM report has been rewritten to get it to work. I also found how to make sure the BOM didn't ignore duplicate values. Thanks

Report Query

<related_id>

<related_id>

<related_id>

<related_id>

<related_id>

</related_id>

</Item>

</Relationships>

</Item>

</related_id>

</Item>

</Relationships>

</Item>

</related_id>

</Item>

</Relationships>

</Item>

</related_id>

</Item>

</Relationships>

</Item>

</related_id>

</Item>

</Relationships>

</Item>

Style Sheet

<xsl:stylesheet version="1.0" xmlns:xsl="www.w3.org/.../Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:aras="http://www.aras-corp.com" exclude-result-prefixes="msxsl">

<xsl:output method="html" omit-xml-declaration="yes" standalone="yes" indent="yes"></xsl:output>

<xsl:template match="/">

<html>

table {empty-cells:show; border-collapse:collapse;}

th {font-family:helvetica; font-size:8pt; padding:2px; border:1px #000000 solid; background-color:#CCCCCC; text-transform:capitalize;}

td {font-family:helvetica; font-size:8pt; padding:2px; border:1px #000000 solid;}

td.noBorder {font-family:helvetica; font-size:8pt; padding:2px; border-width:0;}

</style>

</td>

</tr>

Bill of Materials Report - <xsl:value-of select="//Item/name"></xsl:value-of> Rev <xsl:value-of select="//Item/major_rev"></xsl:value-of>

</td>

Generated on: <script>function m00(r, n){r += ""; if (!n) n = 2; while(r.length < n){r = "0" + r;} return r;} var dt = new Date(); var a = top.opener.top.aras; if (a){var s = m00(dt.getUTCFullYear(),4)+"-"+m00((dt.getUTCMonth()+1))+"-"+m00(dt.getUTCDate())+"T"+m00(dt.getUTCHours())+":"+m00(dt.getUTCMinutes())+":"+m00(dt.getUTCSeconds())+"+0000"; s = a.convertToNeutral(s, "date", "yyyy-MM-ddTHH:mm:sszzz"); s = a.convertFromNeutral(s, "date", "short_date"); document.write(s);}</script>

</td>

</tr>

<tr>

<th width="13%" colspan="6">Indent Level</th>

<th width="5%">Part Number</th>

<th width="5%">Revision</th>

<th width="13%">Description</th>

<th width="5%">Quantity</th>

<th width="5%">Reference Designator</th>

<th width="13%">Manufacturer</th>

<th width="13%">Manufacturer Part</th>

<th width="13%">Document Number</th>

<th width="13%">Document Name</th>

<th width="13%">Document Rev</th>

</tr>

<xsl:apply-templates select="//Item[@type='Part']"></xsl:apply-templates>

</table>

</body>

</html>

</xsl:template>

<xsl:template match="Item[@type='Part']">

<xsl:variable name="AmlItems" select="Relationships/Item[@type='Part AML']"/>

<xsl:variable name="DocItems" select="Relationships/Item[@type='Part Document']"/>

<xsl:variable name="MoreAmlItems" select="count($AmlItems) > count($DocItems)" />

<xsl:variable name="largerGroup" select="$AmlItems[$MoreAmlItems] | $DocItems[not($MoreAmlItems)]" />

<xsl:variable name="Depth" select="count(ancestor::Item[@type='Part'])"></xsl:variable>

<xsl:variable name="rowCount" select="count($largerGroup) + (count($largerGroup) = 0)"/>

<tr>

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

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

</xsl:call-template>

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

</td>

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

</td>

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

</td>

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

</td>

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

</td>

<xsl:choose>

<xsl:when test="$Depth=0">1</xsl:when>

<xsl:when test="$Depth!=0 and (../../quantity)=''">1</xsl:when>

<xsl:otherwise>

<xsl:value-of select="../../quantity"></xsl:value-of>

</xsl:otherwise>

</xsl:choose>

</td>

<xsl:value-of select="../../reference_designator"></xsl:value-of>

</td>

<xsl:apply-templates select="$largerGroup[1]" />

</tr>

<xsl:apply-templates select="$largerGroup[position() > 1]"></xsl:apply-templates>

</xsl:template>

<xsl:template name="IndentLevel">

<xsl:param name="level" select="0" />

<xsl:param name="rowSpan" />

<xsl:if test="count(ancestor::Item[@type = 'Part']) = $level">

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

</xsl:if>

</td>

<xsl:if test="$level < 5">

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

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

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

</xsl:call-template>

</xsl:if>

</xsl:template>

<xsl:template match="text()" />

<xsl:template match="Item[@type = 'Part AML']">

<xsl:variable name="pos" select="position()" />

<xsl:variable name="isTop" select="not(preceding-sibling::Item[@type = 'Part AML'])"/>

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

<xsl:with-param name="AmlItem" select="." />

<xsl:with-param name="PartDocument" select="../Item[@type = 'Part Document'][position() = $pos + not($isTop)]" />

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

</xsl:call-template>

</xsl:template>

<xsl:template match="Item[@type='Part Document']">

<xsl:variable name="pos" select="position()" />

<xsl:variable name="isTop" select="not(preceding-sibling::Item[@type = 'Part Document'])"/>

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

<xsl:with-param name="AmlItem" select="../Item[@type = 'Part AML'][position() = $pos + not($isTop)]" />

<xsl:with-param name="PartDocument" select="." />

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

</xsl:call-template>

</xsl:template>

<xsl:template name="ItemRow">

<xsl:param name="AmlItem" />

<xsl:param name="PartDocument" select="_" />

<xsl:param name="IsTop" />

<xsl:variable name="startingId" select="26 * $IsTop + 32 * not($IsTop)" />

<xsl:variable name="rowData">

</xsl:variable>

<xsl:variable name="rowCells">

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

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

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

</xsl:call-template>

</xsl:variable>

<xsl:choose>

<xsl:when test="$IsTop">

<xsl:copy-of select="$rowCells"/>

</xsl:when>

<xsl:otherwise>

<tr>

<xsl:copy-of select="$rowCells"/>

</tr>

</xsl:otherwise>

</xsl:choose>

</xsl:template>

<xsl:template name="RowCells">

<xsl:param name="rowData" />

<xsl:param name="startingId" />

<xsl:for-each select="msxsl:node-set($rowData)/cell">

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

</td>

</xsl:for-each>

</xsl:template>

</xsl:stylesheet>

sagar_makhesana - Tuesday, June 23, 2015 7:34 AM:

Hello Jsnosal ,

Is there any other way to get child level related data of related Item Using AML in this way

<AML>

<related_id>

</Relationships>

</Item>

</related_id>

</Item>

</Relationships>

</Item>

</AML>

But can we shorten the Query ??

Thanks in advance :-)

DEVELOPERS FORUM - XSLT BOM Report Help

Legal

Connect With Us