Subversion Repositories SmartDukaan

Rev

Rev 8899 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 8899 Rev 20927
Line 75... Line 75...
75 
  <select id="getPaymentForTxn" parameterType="int" resultMap="paymentResult">
 75 
  <select id="getPaymentForTxn" parameterType="int" resultMap="paymentResult">
76 
    SELECT * FROM payment
 76 
    SELECT * FROM payment
77 
    WHERE merchantTxnId=#{merchantTxnId}
 77 
    WHERE merchantTxnId=#{merchantTxnId}
78 
    AND isDigital = 0
78 
    AND isDigital = 0
79 
    ORDER BY id DESC
 79 
    ORDER BY id DESC
80 
    LIMIT 1
 - 
 
81 
  </select>
 80 
  </select>
82
81
83 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">
 82 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">
84 
  	SELECT * FROM payment
 83 
  	SELECT * FROM payment
85 
    WHERE merchantTxnId=#{merchantTxnId}
 84 
    WHERE merchantTxnId=#{merchantTxnId}