<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xmc="http://xmlcomponents.org/TR/WD-xmc" 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" select="/document/Locales/XMLC_PoolStatsTitle"/>
<xsl:with-param name="PageTitle">
<img align="absmiddle" src="{$XMLC_PictosPath}button_Stats.gif"/>&#160;<xsl:value-of select="/document/Locales/XMLC_PoolStatsPageTitle"/>&#160;[<xsl:value-of select="/document/XMLC_Pool"/>]</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_PoolStats</xsl:with-param>
<xsl:with-param name="Tabs">
<xsl:call-template name="XMLCAdm_Tabs"/>
</xsl:with-param>
<xsl:with-param name="DisplayTabs">1</xsl:with-param>
<xsl:with-param name="Body">
<table border="0" cellpadding="2" cellspacing="0" class="clFlatTable">
<tr>
<td align="left" nowrap="">Databases: </td>
<td align="right">
<xsl:value-of select="PoolStats/DatabaseCount"/>
</td>
<td>&#160;</td>
<td align="left" nowrap="">Queries: </td>
<td align="right">
<xsl:value-of select="PoolStats/QueriesCount"/>
</td>
</tr>
<tr>
<td align="left" nowrap="">Modules: </td>
<td align="right">
<xsl:value-of select="Modules/Count"/>
</td>
<td>&#160;</td>
<td align="left" nowrap="">Components: </td>
<td align="right">
<xsl:value-of select="PoolStats/ComponentCount"/>
</td>
</tr>
</table>
<br/>
<table border="0" cellpadding="2" cellspacing="0" class="clFlatTable" width="100%">
<xsl:apply-templates select="XMLApplicationStats"/>
<xsl:apply-templates select="PoolStats"/>
<tr>
<td colspan="7" style="font-size: 1pt; ">&#160;</td>
</tr>
<xsl:apply-templates select="XMLModulesStats"/>
<xsl:apply-templates select="Modules"/>
</table>
</xsl:with-param>
</xsl:call-template>
</xsl:template>
<xsl:template match="XMLApplicationStats">
<tr class="clRowHeader">
<td valign="top">
<xsl:value-of select="/document/Locales/ThreadsHeader"/>&#160;<xsl:value-of select="/document/PoolStats/Count"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/AverageTimeHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/RequestsCountHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/CPUTimeHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/MinCPUHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/MaxCPUHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="/document/Locales/LastCPUTimeHeader"/>
</td>
</tr>
<tr class="clRowLight">
<td valign="top">
<xsl:value-of select="/document/Locales/XMLApplication"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="LastCPUTime"/>
</td>
</tr>
</xsl:template>
<xsl:template match="XMLModules">
<xsl:apply-templates select="XMLModule"/>
</xsl:template>
<xsl:template match="XMLModule">
<td colspan="4" valign="top">
<xsl:value-of select="Name"/>
</td>
</xsl:template>
<xsl:template match="PoolStats">
<tr class="clRowDark">
<td valign="top">
<xsl:value-of select="/document/Locales/Pool"/>&#160;<xsl:value-of select="/document/XMLC_Pool"/>
<br/>&#160;&#160;&#160;&#160;<xsl:value-of select="/document/Locales/AverageWaitTimeCaption"/>&#160;<xsl:value-of select="WaitingAverageTime"/>&#160;ms</td>
<td align="right" valign="top">
<xsl:value-of select="AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="LastCPUTime"/>
</td>
</tr>
<tr class="clRowLight">
<td valign="top">&#160;&#160;&#160;&#160;<xsl:value-of select="/document/Locales/OverheadCaption"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OverheadStats/AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OverheadStats/RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OverheadStats/CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OverheadStats/MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OverheadStats/MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OverheadStats/LastCPUTime"/>
</td>
</tr>
<tr class="clRowDark">
<td valign="top">&#160;&#160;&#160;&#160;BeforeDispatch</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/LastCPUTime"/>
</td>
</tr>
<tr class="clRowLight">
<td valign="top">&#160;&#160;&#160;&#160;OnAuthenticate</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthenticateStats/AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthenticateStats/RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthenticateStats/CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthenticateStats/MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthenticateStats/MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthenticateStats/LastCPUTime"/>
</td>
</tr>
<tr class="clRowDark">
<td valign="top">&#160;&#160;&#160;&#160;OnAuthorize</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthorizeStats/AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthorizeStats/RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthorizeStats/CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthorizeStats/MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthorizeStats/MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="OnAuthorizeStats/LastCPUTime"/>
</td>
</tr>
<tr class="clRowLight">
<td valign="top">&#160;&#160;&#160;&#160;AfterDispatch</td>
<td align="right" valign="top">
<xsl:value-of select="BeforeDispatchStats/AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AfterDispatchStats/RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AfterDispatchStats/CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AfterDispatchStats/MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AfterDispatchStats/MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AfterDispatchStats/LastCPUTime"/>
</td>
</tr>
		<tr class="clRowDark">
			<td valign="top">&#160;&#160;&#160;&#160;[DB]</td>
			<td align="right" valign="top">-</td>
			<td align="right" valign="top">-</td>
			<td align="right" valign="top">[<xsl:value-of select="DBStats/CPUTime"/>]</td>
			<td align="right" valign="top">[<xsl:value-of select="DBStats/MinCPU"/>]</td>
			<td align="right" valign="top">[<xsl:value-of select="DBStats/MaxCPU"/>]</td>
			<td align="right" valign="top">-</td>
		</tr>
</xsl:template>
<xsl:template match="XMLModulesStats">
<tr class="clRowHeader">
<td>
<xsl:value-of select="/document/Locales/XMLModulesHeader"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="LastCPUTime"/>
</td>
</tr>
</xsl:template>
<xsl:template match="Modules">
<xsl:apply-templates select="Module">
<xsl:sort select="Name"/>
</xsl:apply-templates>
</xsl:template>
<xsl:template match="Module">
<xsl:variable name="clValue">
<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>
<a>
<xsl:attribute name="href"><xsl:value-of select="/document/XMLC_Params/XMLC_ScriptName"/><xsl:choose><xsl:when test="/document/XMLC_Params/XMLC_UseXMLC_Action = '1'">?XMLC_Action=</xsl:when><xsl:otherwise>/</xsl:otherwise></xsl:choose>XMLC_StatsXMLModule<xsl:choose><xsl:when test="/document/XMLC_Params/XMLC_UseXMLC_Action = '1'">&amp;</xsl:when><xsl:otherwise>?</xsl:otherwise></xsl:choose>XMLC_Pool=<xsl:value-of select="/document/XMLC_Pool"/>&amp;XMLModule=<xsl:value-of select="Name"/></xsl:attribute>
<xsl:value-of select="Name"/>
</a>&#160;<a href="{/document/Aliases/XMLRADDLL}Default?ProjectName={$XMLC_InstanceName}&amp;XMLModule={Name}" target="_blank">
<img alt="{/document/Locales/DesignInXMLRADAlt}" border="0" src="{$XMLC_PictosPath}ico_step_right.gif"/>
</a>
</td>
<td align="right" valign="top">
<xsl:value-of select="AverageTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="RequestCount"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="CPUTime"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MinCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="MaxCPU"/>
</td>
<td align="right" valign="top">
<xsl:value-of select="LastCPUTime"/>
</td>
</tr>
</xsl:template>
</xsl:stylesheet>
