需求:设置多级奖励,按红包数量发放相应奖励。
可以使用for循环实现,但使用sql实现更简洁、高效。
<select id="selectReward" parameterType="com.tiefan.fbs.sps.mg.entity.MgRedPacketSessionReward" resultMap="BaseResultMap">
select
<include refid="Base_Column_List" />
from sps_mg_red_packet_session_reward
where activity_code = #{activityCode}
and red_packet_number <![CDATA[<=]]> #{redPacketNumber}
and del_flag = 0
order by red_packet_number desc limit 1
</select>