| | |
| | | |
| | | List<MallMember> selectMemberAfterLevelList(String level); |
| | | |
| | | List<MallMember> selectAgentOrPartnetMemberList(@Param("memberLevel") Integer memberLevel); |
| | | List<MallMember> selectAgentOrPartnetMemberList(@Param("level") Integer memberLevel); |
| | | |
| | | |
| | | Integer selectOwnCntByInviteIdAndAccountLevel(@Param("inviteId") String inviteId, @Param("accountLevel") Integer accountLevel); |
| | |
| | | </select> |
| | | |
| | | <select id="selectAgentOrPartnetMemberList" resultType="cc.mrbird.febs.mall.entity.MallMember"> |
| | | select * from mall_membebr a |
| | | select * from mall_member a |
| | | where 1=1 |
| | | <if test="level == 2"> |
| | | a.account_level in (2, 3) |
| | | and a.account_level in (2, 3) |
| | | </if> |
| | | <if test="level == 3"> |
| | | a.account_level = 3 |
| | | and a.account_level = 3 |
| | | </if> |
| | | </select> |
| | | |