Subversion Repositories SmartDukaan

Rev

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

Rev 7049 Rev 8295
Line 73... Line 73...
73 
  </select>
 73 
  </select>
74
74
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
- 
 
 79 
    AND gatewayId != 9
- 
 
 80 
    <!---To prevent showing payment details of gift vouchers-->
78 
    ORDER BY id DESC
 81 
    ORDER BY id DESC
79 
    LIMIT 1
 82 
    LIMIT 1
80 
  </select>
 83 
  </select>
81
84
82 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">
 85 
  <select id="getPaymentForRechargeTxn" parameterType="int" resultMap="paymentResult">