xml - xml中特定属性值的总和是多少？

Question

我有这个 XML 文档，我想为每个 Computername 计算 Forground 中的 Minutes 和 Minutes Open

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <row>
    <Computername>A00123</Computername>
    <Full Name>Bob Robert</Full Name>
    <Username>brobert</Username>
    <Model>toto 1 (Late 2017)</Model>
    <Serial Number>C02EX1</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>4</Minutes in Forground>
    <Minutes Open>4</Minutes Open>
  </row>
  <row>
    <Computername>B00265</Computername>
    <Full Name>Lise Mona</Full Name>
    <Username>lmona</Username>
    <Model>titi 2 (Early 2018)</Model>
    <Serial Number>C02HX2</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>5</Minutes in Forground>
    <Minutes Open>1359</Minutes Open>
  </row>
  <row>
    <Computername>B00265</Computername>
    <Full Name>Lise Mona</Full Name>
    <Username>lmona</Username>
    <Model>titi 2 (Early 2018)</Model>
    <Serial Number>C02HX2</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>1</Minutes in Forground>
    <Minutes Open>1479</Minutes Open>
  </row>
  <row>
    <Computername>B00265</Computername>
    <Full Name>Lise Mona</Full Name>
    <Username>lmona</Username>
    <Model>titi 2 (Early 2018)</Model>
    <Serial Number>C02HX2</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>99</Minutes in Forground>
    <Minutes Open>390</Minutes Open>
  </row>
  <row>
    <Computername>C00854</Computername>
    <Full Name>Sheila Smith</Full Name>
    <Username>ssmith</Username>
    <Model>tata 1 (Middle 2019)</Model>
    <Serial Number>C02ZX3</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>12</Minutes in Forground>
    <Minutes Open>1331</Minutes Open>
  </row>
  <row>
    <Computername>C00854</Computername>
    <Full Name>Sheila Smith</Full Name>
    <Username>ssmith</Username>
    <Model>tata 1 (Middle 2019)</Model>
    <Serial Number>C02ZX3</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>2</Minutes in Forground>
    <Minutes Open>13</Minutes Open>
  </row>
</root>

我想编写一个 XSLT 文档，它将原始文档 XML 转换为出口，为每台计算机保留，计算机名，全名，用户名，型号，序列号，应用程序名称，版本号和所有 Minutes 在前台和分钟打开如下 Xml

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <row>
    <Computername>A00123</Computername>
    <Full Name>Bob Robert</Full Name>
    <Username>brobert</Username>
    <Model>toto 1 (Late 2017)</Model>
    <Serial Number>C02EX1</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>4</Minutes in Forground>
    <Minutes Open>4</Minutes Open>
  </row>
  <row>
    <Computername>B00265</Computername>
    <Full Name>Lise Mona</Full Name>
    <Username>lmona</Username>
    <Model>titi 2 (Early 2018)</Model>
    <Serial Number>C02HX2</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>105</Minutes in Forground>
    <Minutes Open>3228</Minutes Open>
  </row>
  <row>
    <Computername>C00854</Computername>
    <Full Name>Sheila Smith</Full Name>
    <Username>ssmith</Username>
    <Model>tata 1 (Middle 2019)</Model>
    <Serial Number>C02ZX3</Serial Number>
    <App Name>test 3.app</App Name>
    <Version Number>24.0.0 v1 FRA (3008)</Version Number>
    <Minutes in Forground>14</Minutes in Forground>
    <Minutes Open>1344</Minutes Open>
  </row>
</root>

我能怎么做？xslt？xsltproc? 预先感谢您的帮助

标签： xmlxslt