Subversion Repositories SmartDukaan

Rev

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

Rev 2288 Rev 2289
Line 56... Line 56...
56
56
57 
  <sql id="getPaymentsWhereClause">
 57 
  <sql id="getPaymentsWhereClause">
58 
    <if test="fromTime != ''">
 58 
    <if test="fromTime != ''">
59 
      initTimestamp &gt;= #{fromTime}
 59 
      initTimestamp &gt;= #{fromTime}
60 
    </if>
 60 
    </if>
61 
    <if test="toTime != '' && status == 0">
 61 
    <if test="toTime != '' &amp;&amp; status == 0">
62 
      AND initTimestamp &lt;= #{toTime}
 62 
      AND initTimestamp &lt;= #{toTime}
63 
    </if>
 63 
    </if>
64 
    <if test="toTime != '' && status != 0">
 64 
    <if test="toTime != '' &amp;&amp; status != 0">
65 
      AND (errorTimestamp &lt;= #{toTime} OR successTimestamp &lt;= #{toTime})
 65 
      AND (errorTimestamp &lt;= #{toTime} OR successTimestamp &lt;= #{toTime})
66 
    </if>
 66 
    </if>
67 
    <if test="status != -1">
 67 
    <if test="status != -1">
68 
      AND status=#{status}
 68 
      AND status=#{status}
69 
    </if>
 69 
    </if>