<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xslc="http://xslcomponents.org/TR/WD-xslc">
<xsl:import href="../xslc.xsl"/>
<xsl:import href="XMLCAdm_Tabs.xsl"/>
<xsl:template match="/">
<xsl:apply-templates select="document"/>
</xsl:template>
<xsl:template match="document">
<xsl:call-template name="xslc:Page">
<xsl:with-param name="Title">
<xsl:value-of select="/document/Locales/XMLC_StatsXMLServiceTitle"/>&#160;-&#160;<xsl:value-of select="/document/XMLServiceStats/XMLService"/>
</xsl:with-param>
<xsl:with-param name="PageTitle">
<img align="absmiddle" src="{$XMLC_PictosPath}button_StatsXMLService.gif"/>&#160;<xsl:value-of select="/document/Locales/XMLC_StatsXMLServicePageTitle"/>&#160;-&#160;<xsl:value-of select="/document/XMLServiceStats/XMLService"/>
</xsl:with-param>
<xsl:with-param name="ToolbarButtonsLeft">
<xsl:call-template name="AdmCommonToolbarButtonsLeft"/>
</xsl:with-param>
<xsl:with-param name="ToolbarButtonsRight">
<xsl:call-template name="AdmCommonToolbarButtonsRight"/>
</xsl:with-param>
<xsl:with-param name="ActivePageName">XMLC_StatsXMLService</xsl:with-param>
<xsl:with-param name="DisplayTabs">1</xsl:with-param>
<xsl:with-param name="Tabs">
<xsl:call-template name="XMLCAdm_Tabs"/>
</xsl:with-param>
<xsl:with-param name="Body">
<xsl:call-template name="xslc:ApplicationMessages"/>
<table border="0" cellpadding="2" cellspacing="0" class="clFlatTable" width="100%">
<tr class="clRowHeader">
<td colspan="3">
<xsl:value-of select="/document/Locales/XMLGramAverageTimeCaption"/>&#160;<xsl:value-of select="XMLServiceStats/XMLGramAverageTime"/>ms<br/>
<xsl:value-of select="/document/Locales/XMLGramRequestCountCaption"/>&#160;<xsl:value-of select="XMLServiceStats/XMLGramRequestCount"/>
<br/>
<xsl:value-of select="/document/Locales/XMLGramCPUTimeCaption"/>&#160;<xsl:value-of select="XMLServiceStats/XMLGramCPUTime"/>
</td>
<td colspan="6" valign="top">
<xsl:value-of select="/document/Locales/XMLInstructionCaption"/>
</td>
<td colspan="3" valign="top">
<xsl:value-of select="/document/Locales/XMLInstructionFetchesCaption"/>
</td>
</tr>
<xsl:apply-templates select="XMLServiceStats"/>
</table>
</xsl:with-param>
</xsl:call-template>
</xsl:template>
<xsl:template match="XMLServiceStats">
<tr class="clRowHeader">
<td valign="top">
<xsl:value-of select="/document/Locales/KindHeader"/>
</td>
<td valign="top">
<xsl:value-of select="/document/Locales/NameHeader"/>
</td>
<td valign="top">
<xsl:value-of select="/document/Locales/StatementHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/AverageHeader"/>
<br/>
<xsl:value-of select="AverageTime"/>ms</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/CountHeader"/>
<br/>
<xsl:value-of select="RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/CPUTimeHeader"/>
<br/>
<xsl:value-of select="CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/MinCPUHeader"/>
<br/>
<xsl:value-of select="MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/MaxCPUHeader"/>
<br/>
<xsl:value-of select="MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/LastCPUHeader"/>
<br/>
<xsl:value-of select="LastCPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/FetchesCountHeader"/>
<br/>
<xsl:value-of select="DataFetches"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/FetchesAverageTimeHeader"/>
<br/>
<xsl:value-of select="DataAverageFetchTime"/>ms</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/AverageFetchesPerRequestHeader"/>
<br/>
<xsl:value-of select="DataAverageFetchesPerRequest"/>
</td>
</tr>
<xsl:apply-templates select="XMLInstruction | Event"/>
</xsl:template>
<xsl:template match="XMLInstruction">
<xsl:variable name="clValue">
<xsl:choose>
<xsl:when test="position() mod 2 = 1">clRowDark</xsl:when>
<xsl:otherwise>clRowLight</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<tr class="{$clValue}">
<td valign="top">
<xsl:value-of select="Operation"/>&#160;<a href="/XMLRADBin/XMLRAD.dll/Default?ProjectName={$XMLC_InstanceName}&amp;XMLModule={/document/XMLModule}&amp;XMLService={/document/XMLServiceStats/XMLService}&amp;IName={Name}" target="_blank">
<img alt="{/document/Locales/DesignInXMLRADAlt}" border="0" src="{$XMLC_PictosPath}ico_step_right.gif"/>
</a>
</td>
<td valign="top">
<xsl:value-of select="Name"/>
</td>
<td valign="top">
<xsl:apply-templates select="Statement"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="AverageTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="RequestCount"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="CPUTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="MinCPU"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="MaxCPU"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="LastCPUTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="Fetches"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="AverageFetchTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="AverageFetchesPerRequest"/>
</td>
</tr>
<xsl:if test="Operation = 'DBExtract'">
<xsl:variable name="clValue2">
<xsl:choose>
<xsl:when test="position() mod 2 = 0">clRowDark</xsl:when>
<xsl:otherwise>clRowLight</xsl:otherwise>
</xsl:choose>
</xsl:variable>
<tr class="{$clValue}">
<td valign="top">&#160;</td>
<td valign="top"/>
<td valign="top">DB</td>
<td valign="top" align="right">(<xsl:value-of select="Query/OpenAverageTime"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/OpenRequestCount"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/OpenCPUTime"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/OpenMinCPU"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/OpenMaxCPU"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/OpenLastCPUTime"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/Fetches"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/AverageFetchTime"/>)</td>
<td valign="top" align="right">(<xsl:value-of select="Query/AverageFetchesPerRequest"/>)</td>
</tr>
</xsl:if>
<xsl:apply-templates select="Event">
<xsl:with-param name="clValue" select="$clValue"/>
</xsl:apply-templates>
</xsl:template>
<xsl:template match="Event">
<xsl:param name="clValue">
<xsl:choose>
<xsl:when test="position() mod 2 = 1">clRowDark</xsl:when>
<xsl:otherwise>clRowLight</xsl:otherwise>
</xsl:choose>
</xsl:param>
<tr class="{$clValue}">
<td valign="top">
<xsl:variable name="Operation" select="Operation"/>
<xsl:value-of select="$Operation"/>
<xsl:choose>
<xsl:when test="$Operation='XSL'">&#160;[<a href="/XMLRADBin/XMLRAD.dll/Default?ProjectName={$XMLC_InstanceName}&amp;XMLModule={/document/XMLModule}&amp;XMLService={/document/XMLServiceStats/XMLService}&amp;XSLStudio=1" target="_blank">XSLStudio</a>]</xsl:when>
<xsl:when test="($Operation = 'BeforeXMLService') or ($Operation = 'AfterXMLService')">&#160;<a href="{/document/Aliases/XMLRADDLL}EditEventHandler?ProjectName={$XMLC_InstanceName}&amp;{/document/XMLC_Params/XMLC_InputParams}&amp;IName=XMLService&amp;EventType={$Operation}" target="XMLC_PartialFrame">
<img align="absmiddle" alt="{/document/Locales/EditEventHandlerHint}" border="0" src="{$XMLC_PictosPath}ico_step_right.gif" title="{/document/Locales/EditEventHandlerHint}"/>
</a>
</xsl:when>
<xsl:when test="($Operation = 'BeforeXMLGram') or ($Operation = 'AfterXMLGram')">&#160;<a href="{/document/Aliases/XMLRADDLL}EditEventHandler?ProjectName={$XMLC_InstanceName}&amp;{/document/XMLC_Params/XMLC_InputParams}&amp;IName=xmlgram&amp;EventType={$Operation}" target="XMLC_PartialFrame">
<img align="absmiddle" alt="{/document/Locales/EditEventHandlerHint}" border="0" src="{$XMLC_PictosPath}ico_step_right.gif" title="{/document/Locales/EditEventHandlerHint}"/>
</a>
</xsl:when>
</xsl:choose>
</td>
<td valign="top">
<xsl:value-of select="Name"/>
</td>
<td valign="top">
<xsl:apply-templates select="Statement"/>
<xsl:variable name="Statement" select="Statement"/>
<xsl:if test="($Statement = 'BeforeInstruction') or ($Statement = 'BeforeInternalInstruction') or ($Statement = 'AfterInternalInstruction') or ($Statement = 'AfterInstruction')">&#160;<a href="{/document/Aliases/XMLRADDLL}EditEventHandler?ProjectName={$XMLC_InstanceName}&amp;{/document/XMLC_Params/XMLC_InputParams}&amp;IName={../Name}&amp;EventType={$Statement}" target="XMLC_PartialFrame">
<img align="absmiddle" alt="{/document/Locales/EditEventHandlerHint}" border="0" src="{$XMLC_PictosPath}ico_step_right.gif" title="{/document/Locales/EditEventHandlerHint}"/>
</a>
</xsl:if>
</td>
<td valign="top" align="right">
<xsl:value-of select="AverageTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="RequestCount"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="CPUTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="MinCPU"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="MaxCPU"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="LastCPUTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="Fetches"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="AverageFetchTime"/>
</td>
<td valign="top" align="right">
<xsl:value-of select="AverageFetchesPerRequest"/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
