Subversion Repositories SmartDukaan

Rev

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

Rev 8604 Rev 8899
Line 83... Line 83...
83 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">
 83 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">
84 
  	SELECT * FROM payment
 84 
  	SELECT * FROM payment
85 
    WHERE merchantTxnId=#{merchantTxnId}
 85 
    WHERE merchantTxnId=#{merchantTxnId}
86 
    AND isDigital = 1
 86 
    AND isDigital = 1
87 
    ORDER BY id DESC
 87 
    ORDER BY id DESC
88 
    LIMIT 1
 - 
 
89 
  </select>
 88 
  </select>
90
89
91 
  <sql id="getPaymentsWhereClause">
 90 
  <sql id="getPaymentsWhereClause">
92 
    <if test="fromTime != ''">
 91 
    <if test="fromTime != ''">
93 
      initTimestamp &gt;= #{fromTime}
 92 
      initTimestamp &gt;= #{fromTime}