Subversion Repositories SmartDukaan

Rev

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

Rev 1946 Rev 4600
Line 12... Line 12...
12
  <select id="getPaymentGateway" parameterType="int" resultMap="gatewayResult">
12
  <select id="getPaymentGateway" parameterType="int" resultMap="gatewayResult">
13
    SELECT * FROM paymentgateway
13
    SELECT * FROM paymentgateway
14
    WHERE id=#{id}
14
    WHERE id=#{id}
15
  </select>
15
  </select>
16
  
16
  
-
 
17
  <select id="getActivePaymentGateways" resultMap="gatewayResult">
-
 
18
    SELECT * FROM paymentgateway WHERE status = 1
-
 
19
  </select>
-
 
20
  
17
  <select id="getAttributesForGateway" parameterType="int" resultType="gatewayAttribute">
21
  <select id="getAttributesForGateway" parameterType="int" resultType="gatewayAttribute">
18
    SELECT * FROM gatewayattribute where payment_gateway_id = #{id}
22
    SELECT * FROM gatewayattribute where payment_gateway_id = #{id}
19
  </select>
23
  </select>
20
</mapper>
24
</mapper>
21
25