Subversion Repositories SmartDukaan

Rev

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

Rev 6503 Rev 7049
Line 77... Line 77...
77 
    WHERE merchantTxnId=#{merchantTxnId}
 77 
    WHERE merchantTxnId=#{merchantTxnId}
78 
    ORDER BY id DESC
 78 
    ORDER BY id DESC
79 
    LIMIT 1
 79 
    LIMIT 1
80 
  </select>
 80 
  </select>
81
81
- 
 
 82 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">
- 
 
 83 
  	SELECT * FROM payment
- 
 
 84 
    WHERE merchantTxnId=#{merchantTxnId}
- 
 
 85 
    AND isDigital = 1
- 
 
 86 
    ORDER BY id DESC
- 
 
 87 
    LIMIT 1
- 
 
 88 
  </select>
- 
 
 89
82 
  <sql id="getPaymentsWhereClause">
 90 
  <sql id="getPaymentsWhereClause">
83 
    <if test="fromTime != ''">
 91 
    <if test="fromTime != ''">
84 
      initTimestamp &gt;= #{fromTime}
 92 
      initTimestamp &gt;= #{fromTime}
85 
    </if>
 93 
    </if>
86 
    <if test="toTime != '' &amp;&amp; status == 0">
 94 
    <if test="toTime != '' &amp;&amp; status == 0">