从网上找到的代码只能调用出通过的稿数,如何在此基础上加一个总稿数呢?
<?xml version="1.0" encoding="utf-8"?>
<root>
<LabelType>000统计</LabelType>
<LabelImage>../../Admin/Images/LabelIco/GetArticleCustom.gif</LabelImage>
<LabelIntro>用户排名列表</LabelIntro>
<OutType>sin</OutType>
<LabelDataType>sql_sysquery</LabelDataType>
<attributes>
<name>outputQty</name>
<default>10</default>
<intro>列表数量</intro>
</attributes>
<LabelSqlString><![CDATA[select top @outputQty PE_CommonModel.Inputer,count(PE_CommonModel.Inputer) as total from
(PE_CommonModel inner join PE_Users on PE_CommonModel.Inputer=PE_Users.UserName)
inner join PE_UserGroups on PE_UserGroups.GroupID=PE_Users.GroupID
where PE_CommonModel.Status=99 AND DATEPART(mm, PE_CommonModel.UpdateTime) = DATEPART(mm, GETDATE()) and DATEPART(yy, PE_CommonModel.UpdateTime) = DATEPART(yy, GETDATE()) AND PE_UserGroups.GroupName='@GroupName'
group by Inputer order by total desc]]></LabelSqlString>
<LabelTemplate><![CDATA[<?xml version="1.0" encoding="utf-8"?>
<xsl:transform version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:pe="labelproc" exclude-result-prefixes="pe">
<xsl:output method="html" />
<xsl:template match="/">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td class="title1">排名</td>
<td class="title2">姓名</td>
<td class="title3">稿数</td>
</tr>
<xsl:choose>
<xsl:when test="count(/NewDataSet/Table) = 0">
<tr>
<td colspan="3"><span style="color:red">还没有任何内容!</span></td>
</tr>
</xsl:when>
<xsl:otherwise>
<xsl:for-each select="/NewDataSet/Table">
<tr>
<td></td>
<td><xsl:value-of select="Inputer"/></td>
<td><xsl:value-of select="total"/></td>
</tr>
</xsl:for-each>
</xsl:otherwise>
</xsl:choose>
</table>
</xsl:template>
</xsl:transform>]]></LabelTemplate>
<CacheTime>0</CacheTime>
<EnabelAjax>False</EnabelAjax>
<IsXsltSql>false</IsXsltSql>
<IsXsltCountSql>false</IsXsltCountSql>
<Version officialVersion="" modifiedVersions="3606" compatibleVersion="" />
<attributes>
<name>GroupName</name>
<datatype>supersql</datatype>
<default>注册会员</default>
<intro>会员组名称</intro>
</attributes>
</root>
输出只有审核通过的稿数
我想要增加一个总稿数,该怎么修改呢
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td class="title1">排名</td>
<td class="title2">姓名</td>
<td class="title3">采用</td>
<td class="title3">总投稿</td>
</tr>
<xsl:choose>
<xsl:when test="count(/NewDataSet/Table) = 0">
<tr>
<td colspan="3"><span style="color:red">还没有任何内容!</span></td>
</tr>
</xsl:when>
<xsl:otherwise>
<xsl:for-each select="/NewDataSet/Table">
<tr>
<td></td>
<td><xsl:value-of select="Inputer"/></td>
<td><xsl:value-of select="total"/></td>
<td><xsl:value-of select="??????"/></td>
</tr>
</xsl:for-each>
</xsl:otherwise>
</xsl:choose>
</table>