我们如何在datapower中的xslt中测试日期是否在从今天算起的180天内 [英] How do we test whether a date is within 180 days from today in xslt in datapower

问题描述

我正在为 datapower 编写一个 xslt，我得到了一个日期(付款日期).我必须检查该日期(付款日期)是否在当前日期的 180 天内

I am writing an xslt for datapower and in that I am getting a date(Payment Date).I have to check whether that date(Paymentt Date) is within 180 days of current date

我通过以下方式获得当前日期

I am getting present date by the following

<xsl:variable name="timestamp" select="date:date-time()"/>

现在如何检查180天的状况

Now how to check the condition for 180 days

以下是我的xslt

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

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:dp="http://www.datapower.com/extensions"
    xmlns:date="http://exslt.org/dates-and-times"
    xmlns:dpconfig="http://www.datapower.com/param/config"
    extension-element-prefixes="dp"
    exclude-result-prefixes="dp dpconfig"
>

  <xsl:output method="xml"/>

  <xsl:template match="/">
<PaymentDate><xsl:value-of select="dp:http-request-header('X-payment-date')"/></PaymentDate>  (From request I am getting payment date)

<xsl:variable name="timestamp" select="date:date-time()"/>        (From here I am getting present date)

<xsl:if  (this is what I am confused)

谢谢

推荐答案

在 XSLT 1.0 中计算日期差异:

<xsl:stylesheet version="1.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:date="http://exslt.org/dates-and-times"
extension-element-prefixes="date">

<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/>

<xsl:template match="/">
    <output>
        <difference>
            <xsl:call-template name="date-difference">
                <xsl:with-param name="date1" select="input/originalDate" />
                <xsl:with-param name="date2" select="date:date-time()" />
            </xsl:call-template>
        </difference>
    </output>
</xsl:template> 

<xsl:template name="date-difference">
    <xsl:param name="date1"/>
    <xsl:param name="date2"/>
    <xsl:param name="JDN1">
        <xsl:call-template name="JDN">
            <xsl:with-param name="date" select="$date1" />
        </xsl:call-template>
    </xsl:param>
    <xsl:param name="JDN2">
        <xsl:call-template name="JDN">
            <xsl:with-param name="date" select="$date2" />
        </xsl:call-template>
    </xsl:param>
    <xsl:value-of select="$JDN2 - $JDN1"/>
</xsl:template> 

<xsl:template name="JDN">
    <xsl:param name="date"/>
    <xsl:param name="year" select="substring($date, 1, 4)"/>
    <xsl:param name="month" select="substring($date, 6, 2)"/>
    <xsl:param name="day" select="substring($date, 9, 2)"/>
    <xsl:param name="a" select="floor((14 - $month) div 12)"/>
    <xsl:param name="y" select="$year + 4800 - $a"/>
    <xsl:param name="m" select="$month + 12*$a - 3"/>
    <xsl:value-of select="$day + floor((153*$m + 2) div 5) + 365*$y + floor($y div 4) - floor($y div 100) + floor($y div 400) - 32045" />
</xsl:template> 

</xsl:stylesheet>

应用于以下输入 XML 时:

When applied to the following input XML:

<input>
    <originalDate>2013-09-15</originalDate>
</input>

结果将是:

<?xml version="1.0" encoding="UTF-8"?>
<output>
  <difference>179</difference>
</output>

如果今天进行转换，2014-03-13.

if the transformation is performed today, 2014-03-13.

这篇关于我们如何在datapower中的xslt中测试日期是否在从今天算起的180天内的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！