在XML中使用条件求和[关闭]

由 发布于

我正在处理其中插入了以下XML的RTF模板。

    <?xml version="1.0" encoding="UTF-8"?>

-<DATA_DS>

-<OFFER_DETAILS>



-<OTHER_COMPONENTS>

<COMPONENT_NAME>Basic Salary</COMPONENT_NAME>

<COMPONENT_AMOUNT>40000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>HRA</COMPONENT_NAME>

<COMPONENT_AMOUNT>20000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Special Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Meal Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Education Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>NPS Adhoc Pay</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Monthly LTA</COMPONENT_NAME>

<COMPONENT_AMOUNT>1000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Employer PF</COMPONENT_NAME>

<COMPONENT_AMOUNT>5000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Superannuation</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Car Adhoc Allowance</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Gratuity</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Insurance Premium</COMPONENT_NAME>

<COMPONENT_AMOUNT>1500</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>


-<OTHER_COMPONENTS>

<COMPONENT_NAME>Housing Loan Subsidy</COMPONENT_NAME>

<COMPONENT_AMOUNT>2000</COMPONENT_AMOUNT>

<CURRENCY_CODE>INR</CURRENCY_CODE>

<SALARY_DATE_FROM>2020-05-22T00:00:00.000+00:00</SALARY_DATE_FROM>

<SALARY_DATE_TO>4712-12-31T00:00:00.000+00:00</SALARY_DATE_TO>

<OFFER_ID>300000048185676</OFFER_ID>

<OTHER_COMPON_CURRENCY_SYMBOL>₨</OTHER_COMPON_CURRENCY_SYMBOL>

</OTHER_COMPONENTS>



</OFFER_DETAILS>

</DATA_DS>

现在，我要对所有COMPONENT_AMOUNT进行加法运算/求和运算，其中COMPONENT_NAME ='基本工资和HRA，特殊临时津贴，膳食津贴和教育津贴，NPS临时工资和临时津贴以及每月LTA'

我对XML非常陌生，我仅尝试在RTF Word文档中使用以下代码。

<?for-each-group:OTHER_COMPONENTS;./COMPONENT_NAME?>
<?if:COMPONENT_NAME='Basic Salary'?><?sum(COMPONENT_AMOUNT)?><?end if?>
<?if:COMPONENT_NAME='HRA'?><?sum(COMPONENT_AMOUNT)?><?end if?>
<?end for-each-group?>

这给我输出为

40000
20000

但是我想要输出如下

60000

如何做到这一点？