抽奖

KKSU

2024-02-29 2ebbd61dab90ff37662c196a5c3e6c4fe05701d2

抽奖

 src/main/resources/mapper/modules/MallMemberMapper.xml

@@ -58,25 +58,12 @@

    <select id="getMallMemberInfoById" resultType="cc.mrbird.febs.mall.vo.MallMemberVo">
        SELECT a.id,
               a.name,
               a.phone,
               a.email,
               a.sex,
               a.invite_id,
               a.level,
               a.account_status,
               a.CREATED_TIME,
               IFNULL(c.balance,0) balance,
               IFNULL(c.score,0) score,
               IFNULL(c.prize_score,0) prizeScore,
               d.description levelName,
               b.name
               IFNULL(c.balance,0) balance
               FROM mall_member a
            LEFT JOIN mall_member b on a.referrer_id = b.invite_id
            LEFT JOIN mall_member_wallet c on c.member_id = a.id
            LEFT JOIN data_dictionary_custom d on d.code = a.level
            where a.id = #{id}
            GROUP BY a.id
    </select>

    <select id="selectInfoByAccount" resultType="cc.mrbird.febs.mall.entity.MallMember">