Subversion Repositories SmartDukaan

Rev

Rev 8583 | Rev 8899 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 8583 Rev 8604
Line 90... Line 90...
90
90
91 
  <sql id="getPaymentsWhereClause">
 91 
  <sql id="getPaymentsWhereClause">
92 
    <if test="fromTime != ''">
 92 
    <if test="fromTime != ''">
93 
      initTimestamp &gt;= #{fromTime}
 93 
      initTimestamp &gt;= #{fromTime}
94 
    </if>
 94 
    </if>
- 
 
 95 
    <if test="toTime != ''">
- 
 
 96 
      AND initTimestamp &lt;= #{toTime}
- 
 
 97 
    </if>
- 
 
 98
- 
 
 99 
<!--
95 
    <if test="toTime != '' &amp;&amp; status == 0">
 100 
    <if test="toTime != '' &amp;&amp; status == 0">
96 
      AND initTimestamp &lt;= #{toTime}
 101 
      AND initTimestamp &lt;= #{toTime}
97 
    </if>
 102 
    </if>
98 
    <if test="toTime != '' &amp;&amp; status != 0">
 103 
	<if test="toTime != '' &amp;&amp; status != 0">
99 
      AND (errorTimestamp &lt;= #{toTime} OR successTimestamp &lt;= #{toTime})
 104 
      AND (errorTimestamp &lt;= #{toTime} OR successTimestamp &lt;= #{toTime})
100 
    </if>
 105 
    </if>
- 
 
 106 
 -->
101 
    <if test="status != -1">
 107 
    <if test="status != -1">
102 
      AND status=#{status}
 108 
      AND status=#{status}
103 
    </if>
 109 
    </if>
104 
    <if test="gatewayId != 0">
 110 
    <if test="gatewayId != 0">
105 
      AND gatewayId = #{gatewayId}
 111 
      AND gatewayId = #{gatewayId}