Subversion Repositories SmartDukaan

Rev

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

Rev 2388 Rev 4141
Line 99... Line 99...
99 
      <include refid="getPaymentsWhereClause"/>
 99 
      <include refid="getPaymentsWhereClause"/>
100 
    </where>
 100 
    </where>
101 
    ORDER BY id
 101 
    ORDER BY id
102 
  </select>
 102 
  </select>
103 
 
 103 
 
- 
 
 104 
  <select id="getPaymentsByCapturedDate" parameterType="map" resultMap="paymentResult">
- 
 
 105 
    SELECT * FROM payment
- 
 
 106 
    <where>
- 
 
 107 
      status = #{status}
- 
 
 108 
	  <if test="fromTime != ''">
- 
 
 109 
	    AND successTimestamp &gt;= #{fromTime}
- 
 
 110 
	  </if>
- 
 
 111 
	  <if test="toTime != ''">
- 
 
 112 
	    AND successTimestamp &lt;= #{toTime}
- 
 
 113 
	  </if>
- 
 
 114 
	  <if test="gatewayId != 0">
- 
 
 115 
        AND gatewayId = #{gatewayId}
- 
 
 116 
      </if>
- 
 
 117 
    </where>
- 
 
 118 
    ORDER BY id
- 
 
 119 
  </select>
- 
 
 120 
 
104 
  <select id="getPaymentsForUser" parameterType="map" resultMap="paymentResult">
 121 
  <select id="getPaymentsForUser" parameterType="map" resultMap="paymentResult">
105 
    SELECT * FROM payment
 122 
    SELECT * FROM payment
106 
    <where>
 123 
    <where>
107 
      <include refid="getPaymentsWhereClause"/>
 124 
      <include refid="getPaymentsWhereClause"/>
108 
      AND userId=#{userId}
 125 
      AND userId=#{userId}