XSL/XML variables & bit of javascript

codkat · Jan 24th, 2007, 03:03

Hi All..!

I think this is a tough question... I have the XML Layout code below..
I need to use XSL to assign different values to variables 'Severity', 'Probability' & 'Exposre' depending on user selections.

How do I go about doign this?

This is the XML Layout:

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<ScoreCardDef>
  <Columns>
    <Column id="EWRMType" type="text">
      <HeaderValue>
        <value>Status</value>
      </HeaderValue>
    </Column>
    <Column id="Severity" type="list">
      <HeaderValue>
        <value>Severity</value>
      </HeaderValue>
      <ListItem key="Severity-1">a</ListItem>
      <ListItem key="Severity-2">b</ListItem>
      <ListItem key="Severity-3">c</ListItem>
      <ListItem key="Severity-3">d</ListItem>
      <ListItem key="Severity-3">e</ListItem>
      <ListItem key="Severity-3">f</ListItem>
      <ListItem key="Severity-3">g</ListItem>
    </Column>
    <Column id="Exposure" type="list">
      <HeaderValue>
        <value>Exposure</value>
      </HeaderValue>
      <ListItem key="Exposure-1">At Least Once A Week</ListItem>
      <ListItem key="Exposure-2">Once A Month Or So</ListItem>
      <ListItem key="Exposure-3">Once Or Twice A Year</ListItem>
      <ListItem key="Exposure-4">Once Or Twice Every 10 Years</ListItem>
      <ListItem key="Exposure-5">Once Or Twice in 100 Years</ListItem>
    </Column>
    <Column id="Probability" type="list">
      <HeaderValue>
        <value>Probability</value>
      </HeaderValue>
      <ListItem key="Probability-1">Happens Often</ListItem>
      <ListItem key="Probability-2">Could Easily Happen</ListItem>
      <ListItem key="Probability-3">Could Happen and Has Happened Here or Elsewhere</ListItem>
      <ListItem key="Probability-4">Hasn't Happened Yet But Could</ListItem>
      <ListItem key="Probability-5">Conceivable, But Only In Extreme Circumstances</ListItem>
    </Column>
    <!-- calc w/ xsl -->
    <Column id="EWRM" type="calc">
      <HeaderValue>
        <value>EWRM</value>
      </HeaderValue>
    </Column>
  </Columns>
  <Total>
  </Total>
</ScoreCardDef>

A snippet of what I've started - not sure if <xsl: text> is right?:

Code: Select all

<xsl:when test="@type='calc'">
                        <xsl:variable name="Severity">
                            <xsl:choose>
                                <xsl:when test="../cell/@key='Severity-1'">
                                    <xsl:text>1000</xsl:text>
                                </xsl:when>
                                <xsl:when test="../cell/@key='Severity-2'">
                                    <xsl:text>300</xsl:text>
                                </xsl:when>
                                <xsl:when test="../cell/@key='Severity-3'">
                                    <xsl:text>100</xsl:text>
                                </xsl:when>

Any help would be greatly appreciated!

Kt

ukgeoff · Jan 24th, 2007, 21:19

I think you can forget about using xsl. It sounds like a ready made task for Ajax.

Hows your Ajax knowledge?

Do you want a range of values to be fetched from the server depending on a users response or is it simpler than that?

snow · Jan 24th, 2007, 22:03

What your doing looks great - could you post up the full code for debugging?

codkat · Jan 25th, 2007, 02:54

Thanks for your replies!
Unfortunately the application will only accept XML/XSL..

However I've done some progress..

I've spoken with someone and they insist my code below is correct with no errors.. can anyone pick up any errors? Because I still get an error within my application.. A very general error: "Unable to calculate: Exception Thrown"

See below code:

Code: Select all

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:foo="http://www.pacificedge.com/foo" extension-element-prefixes="msxsl" exclude-result-prefixes="foo">
  <xsl:output method="html" />
  <xsl:variable name="calcNameId">
    <xsl:value-of select="generate-id()" />
  </xsl:variable>
  <msxsl:script language="javascript" implements-prefix="foo">
    <![CDATA[
            var total = 0;
            function MultiplyCalc(Severity,Exposure,Probability)
            {
                var total = Severity * Exposure * Probability;
                return total;
            }
            
        ]]>
  </msxsl:script>
  <xsl:template match="root">
    <TABLE border="1" width="100%">
      <xsl:apply-templates select="columns" />
      <xsl:apply-templates select="row" />
    </TABLE>
  </xsl:template>
  <xsl:template match="columns">
    <TR>
      <xsl:for-each select="*/HeaderValue">
        <TD class="Heading">
          <xsl:value-of select="value" />
        </TD>
      </xsl:for-each>
    </TR>
  </xsl:template>
  <xsl:template match="row">
    <TR>
      <xsl:for-each select="*">
        <xsl:choose>
          <xsl:when test="@type='text'">
            <TD class="RHC" style="width:300px;">
              <DIV>
                <xsl:attribute name="id">
                  <xsl:value-of select="@id" />
                </xsl:attribute>
                <xsl:value-of select="value" />
              </DIV>
            </TD>
          </xsl:when>
          <xsl:when test="@type='list'">
            <TD class="RHC">
              <TABLE WIDTH="100%">
                <TR>
                  <TD align="center">
                    <xsl:choose>
                      <xsl:when test="//root/@readonly='true'">
                        <xsl:for-each select="ListItem">
                          <xsl:if test="@selected='true'">
                            <xsl:value-of select="text()" />
                          </xsl:if>
                        </xsl:for-each>
                      </xsl:when>
                      <xsl:otherwise>
                        <SELECT onchange="fnSelect_Onchange();">
                          <xsl:attribute name="id">
                            <xsl:value-of select="@id" />
                          </xsl:attribute>
                          <xsl:attribute name="nodeName">
                            <xsl:value-of select="@nodeName" />
                          </xsl:attribute>
                          <xsl:attribute name="rowId">
                            <xsl:value-of select="@rowId" />
                          </xsl:attribute>
                          <xsl:if test="//root/@readonly='true'">
                            <xsl:attribute name="DISABLED">true</xsl:attribute>
                          </xsl:if>
                          <xsl:for-each select="ListItem">
                            <OPTION>
                              <xsl:if test="@selected='true'">
                                <xsl:attribute name="SELECTED">
                                  <xsl:value-of select="@selected" />
                                </xsl:attribute>
                              </xsl:if>
                              <xsl:attribute name="value">
                                <xsl:value-of select="@key" />
                              </xsl:attribute>
                              <xsl:value-of select="text()" />
                            </OPTION>
                          </xsl:for-each>
                        </SELECT>
                      </xsl:otherwise>
                    </xsl:choose>
                  </TD>
                </TR>
              </TABLE>
            </TD>
          </xsl:when>
          <xsl:when test="@type='calc'">
            <xsl:variable name="Severity">
              <xsl:choose>
                    <xsl:when test="../cell/@key='Severity-1'">1000</xsl:when>
                    <xsl:when test="../cell/@key='Severity-2'">300</xsl:when>
                    <xsl:when test="../cell/@key='Severity-3'">100</xsl:when>
                    <xsl:when test="../cell/@key='Severity-4'">30</xsl:when>
                    <xsl:when test="../cell/@key='Severity-5'">10</xsl:when>
                    <xsl:when test="../cell/@key='Severity-6'">3</xsl:when>
                    <xsl:when test="../cell/@key='Severity-7'">1</xsl:when>
              </xsl:choose>
            </xsl:variable>
            <xsl:variable name="Exposure">
              <xsl:choose>
                <xsl:when test="../cell/@key='Exposure-1'">10</xsl:when>
                <xsl:when test="../cell/@key='Exposure-2'">3</xsl:when>
                <xsl:when test="../cell/@key='Exposure-3'">1</xsl:when>
                <xsl:when test="../cell/@key='Exposure-4'">0.3</xsl:when>
                <xsl:when test="../cell/@key='Exposure-5'">0.1</xsl:when>
              </xsl:choose>
            </xsl:variable>
            <xsl:variable name="Probability">
              <xsl:choose>
                <xsl:when test="../cell/@key='Probability-1'">1</xsl:when>
                <xsl:when test="../cell/@key='Probability-2'">0.3</xsl:when>
                <xsl:when test="../cell/@key='Probability-3'">0.1</xsl:when>
                <xsl:when test="../cell/@key='Probability-4'">0.03</xsl:when>
                <xsl:when test="../cell/@key='Probability-5'">0.01</xsl:when>
              </xsl:choose>
            </xsl:variable>
           <xsl:if test="@name='EWRM'">
              <TD class="RHC" align="center" type="calc" dataKey="EWRM" style="width:50px;">
                <xsl:value-of select="foo:MultiplyCalc($Severity,$Exposure,$Probability)" />
              </TD>
            </xsl:if>
          </xsl:when>        
        </xsl:choose>
      </xsl:for-each>
    </TR>
  </xsl:template>
</xsl:stylesheet>

Thanks for your help! =)

Kat

snow · Jan 25th, 2007, 09:56

Hi there,

from a quick look at your code I can't find anything wrong... however, that error should only be raised by the JavaScript you've got in there. Have you checked the values that you're putting into the method?

Tell us if they're valid or if you manage to get us sorted and tell us how!

All the best,
Snow