| | |
| | | */ |
| | | private String remark; |
| | | |
| | | private Integer isJump; |
| | | |
| | | @TableField(exist = false) |
| | | private List<MallVipBenefitsDetails> details; |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.List; |
| | | |
| | | public interface MallVipBenefitsMapper extends BaseMapper<MallVipBenefits> { |
| | | |
| | | IPage<MallVipBenefits> selectVipBenefitsListInPage(Page<MallVipBenefits> page); |
| | | |
| | | MallVipBenefits selectVipBenefitsById(@Param("id") Long id); |
| | | |
| | | List<MallVipBenefits> selectVipBenefitsByIds(@Param("list") List<Long> ids); |
| | | } |
| | |
| | | |
| | | @Override |
| | | public List<MallVipConfig> findConfigList() { |
| | | return this.baseMapper.selectVipConfigList(); |
| | | List<MallVipConfig> configs = this.baseMapper.selectVipConfigList(); |
| | | configs.forEach(item -> { |
| | | item.getBenefits().forEach(benefits -> { |
| | | benefits.setIsJump(CollUtil.isEmpty(benefits.getDetails()) ? 2 : 1); |
| | | }); |
| | | }); |
| | | return configs; |
| | | } |
| | | |
| | | @Override |
| | |
| | | left join mall_vip_benefits_details benefitsDetail on benefits.id=benefitsDetail.benefits_id |
| | | where benefits.id=#{id} |
| | | </select> |
| | | |
| | | <select id="selectVipBenefitsByIds" resultMap="VipBenefitsMap"> |
| | | select |
| | | benefits.*, |
| | | benefitsDetail.id c_id |
| | | ,benefitsDetail.image |
| | | ,benefitsDetail.is_click |
| | | ,benefitsDetail.link_type |
| | | ,benefitsDetail.content |
| | | ,benefitsDetail.seq |
| | | from mall_vip_benefits benefits |
| | | left join mall_vip_benefits_details benefitsDetail on benefits.id=benefitsDetail.benefits_id |
| | | where benefits.id in |
| | | <foreach collection="list" open="(" close=")" separator=","> |
| | | #{item} |
| | | </foreach> |
| | | </select> |
| | | </mapper> |
| | |
| | | <id property="id" column="c_id" /> |
| | | <result property="name" column="c_name" /> |
| | | <result property="icon" column="c_icon" /> |
| | | |
| | | <collection property="details" ofType="cc.mrbird.febs.vip.entity.MallVipBenefitsDetails"> |
| | | <id property="id" column="d_id" /> |
| | | </collection> |
| | | </collection> |
| | | </resultMap> |
| | | |
| | |
| | | ,benefits.id c_id |
| | | ,benefits.name c_name |
| | | ,benefits.icon c_icon |
| | | ,details.id d_id |
| | | from mall_vip_config config |
| | | inner join mall_vip_config_benefits configBenefits on config.id=configBenefits.config_id |
| | | inner join mall_vip_benefits benefits on configBenefits.benefits_id=benefits.id |
| | | left join mall_vip_benefits_details details on benefits.id = details.benefits_id |
| | | order by level |
| | | </select> |
| | | |