Subversion Repositories SmartDukaan

Rev

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

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