a.id AS "id", a.member_code AS "memberCode", a.gift_name AS "giftName", a.gift_code AS "giftCode", a.face_price AS "facePrice", a.url AS "url", a.source AS "source", a.effective_date AS "effectiveDate", a.valid_date AS "validDate", a.usage_flow AS "usageFlow", a.usage_rule AS "usageRule", a.explains AS "explains", a.usestate AS "usestate", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag", a.gift_type AS "giftType", a.version AS "version" SELECT FROM sys_gift a WHERE a.id = #{id} SELECT FROM sys_gift a WHERE a.del_flag = "0" AND usestate = "0" AND a.member_code is null limit 1 UPDATE sys_gift SET member_code = ${memberCode}, usestate = "1", version = version + 1 WHERE id = #{id} AND version = #{version} SELECT FROM sys_gift a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.gift_name LIKE CONCAT('%', #{giftName}, '%') AND a.explains = #{explains} AND a.remarks = #{remarks} AND a.usestate='0' AND (a.valid_date IS NOT NULL or a.valid_date < now()) AND a.usestate='1' ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO sys_gift( id, member_code, gift_name, gift_code, face_price, url, source, effective_date, valid_date, usage_flow, usage_rule, explains, usestate, create_by, create_date, update_by, update_date, remarks, del_flag, gift_type, version ) VALUES ( #{id}, #{memberCode}, #{giftName}, #{giftCode}, #{facePrice}, #{url}, #{source}, #{effectiveDate}, #{validDate}, #{usageFlow}, #{usageRule}, #{explains}, #{usestate}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}, #{giftType}, #{version} ) UPDATE sys_gift SET member_code = #{memberCode}, gift_name = #{giftName}, gift_code = #{giftCode}, face_price = #{facePrice}, url = #{url}, source = #{source}, effective_date = #{effectiveDate}, valid_date = #{validDate}, usage_flow = #{usageFlow}, usage_rule = #{usageRule}, explains = #{explains}, usestate = #{usestate}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks}, gift_type = #{giftType}, version = #{version} WHERE id = #{id} UPDATE sys_gift SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}