fix
Hentua
2023-05-09 fb3e8318fa249bb52dfb0157f7c29b4cc8b930e4
fix
2 files modified
8 ■■■■ changed files
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java 2 ●●● patch | view | raw | blame | history
src/main/resources/mapper/modules/MallMemberMapper.xml 6 ●●●● patch | view | raw | blame | history
src/main/java/cc/mrbird/febs/mall/mapper/MallMemberMapper.java
@@ -106,7 +106,7 @@
    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);
src/main/resources/mapper/modules/MallMemberMapper.xml
@@ -482,13 +482,13 @@
    </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>