| | |
|---|
| | | <select id="getEnableListByCouponId" resultMap="ResultVOMap"> |
|---|
| | | SELECT * FROM `yeshi_ec_user_system_coupon` uc |
|---|
| | | WHERE uc.`usc_uid`= #{uid} AND uc.usc_state = 1 |
|---|
| | | AND DATE_FORMAT(CURDATE(),'%Y%m%d') <![CDATA[ >= ]]>DATE_FORMAT(uc.`usc_start_time`,'%Y%m%d'); |
|---|
| | | AND DATE_FORMAT(CURDATE(),'%Y%m%d') <![CDATA[ >= ]]>DATE_FORMAT(uc.`usc_start_time`,'%Y%m%d') |
|---|
| | | <if test="activated != null">AND uc.usc_state_activate = #{activated}</if> |
|---|
| | | AND uc.usc_coupon_id in |
|---|
| | | <foreach collection="list" item="item" open="(" close=")" |
|---|
