Subversion Repositories SmartDukaan

Rev

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

Rev 5432 Rev 5560
Line 18... Line 18...
18 
	</resultMap>
 18 
	</resultMap>
19
19
20 
<insert id="createCart" parameterType="cart" useGeneratedKeys="true" keyProperty="id">
 20 
<insert id="createCart" parameterType="cart" useGeneratedKeys="true" keyProperty="id">
21 
    INSERT INTO cart
 21 
    INSERT INTO cart
22 
    (cart_status, checked_out_on, created_on, updated_on,
22 
    (cart_status, checked_out_on, created_on, updated_on,
23 
    total_price, discounted_price, coupon_code )
 23 
    total_price, discounted_price, coupon_code, pickupStoreId )
24 
    VALUES
 24 
    VALUES
25 
    (#{cart_status}, #{checked_out_on}, #{created_on}, #{updated_on},
 25 
    (#{cart_status}, #{checked_out_on}, #{created_on}, #{updated_on},
26 
    #{total_price}, #{discounted_price}, #{coupon_code})
 26 
    #{total_price}, #{discounted_price}, #{coupon_code}, #{pickupStoreId})
27 
</insert>
 27 
</insert>
28 
 
 28 
 
29 
<insert id="insertDiscount" parameterType="discount" useGeneratedKeys="true" keyProperty="id">
 29 
<insert id="insertDiscount" parameterType="discount" useGeneratedKeys="true" keyProperty="id">
30 
    INSERT INTO discount
 30 
    INSERT INTO discount
31 
    (line_cart_id, line_item_id, discount, quantity)
 31 
    (line_cart_id, line_item_id, discount, quantity)
Line 196... Line 196...
196 
	coupon_code = #{coupon_code},
 196 
	coupon_code = #{coupon_code},
197 
	updated_on = #{updated_on},
 197 
	updated_on = #{updated_on},
198 
	checked_out_on = #{checked_out_on},
 198 
	checked_out_on = #{checked_out_on},
199 
	total_price = #{total_price},
 199 
	total_price = #{total_price},
200 
	discounted_price = #{discounted_price},
 200 
	discounted_price = #{discounted_price},
201 
	coupon_code = #{coupon_code}
 201 
	coupon_code = #{coupon_code},
- 
 
 202 
	pickupStoreId = #{pickupStoreId}
202 
	<where>
 203 
	<where>
203 
        id = #{id}
 204 
        id = #{id}
204 
	</where>
 205 
	</where>
205 
</update>
 206 
</update>
206 
 
 207