Subversion Repositories SmartDukaan

Rev

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

Rev 2289 Rev 2293
Line 88... Line 88...
88 
    </where>
 88 
    </where>
89 
    ORDER BY id
 89 
    ORDER BY id
90 
  </select>
 90 
  </select>
91 
 
 91 
 
92 
  <select id="getMinMaxPaymentAmount" resultType="hashmap">
 92 
  <select id="getMinMaxPaymentAmount" resultType="hashmap">
93 
    SELECT MIN(AMOUNT) MIN, MAX(AMOUNT) MAX from payment
 93 
    SELECT MIN(AMOUNT) MIN, MAX(AMOUNT) MAX from payment WHERE status = 2
94 
  </select>
 94 
  </select>
95
95
96 
  <select id="getAttributesForPayment" parameterType="int" resultType="paymentAttribute">
 96 
  <select id="getAttributesForPayment" parameterType="int" resultType="paymentAttribute">
97 
    SELECT * FROM paymentattribute where payment_id = #{id}
 97 
    SELECT * FROM paymentattribute where payment_id = #{id}
98 
  </select>
 98 
  </select>