需求:设置多级奖励,按红包数量发放相应奖励。
可以使用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>