团队列表

KKSU

2024-01-04 6b9f5f6d688fd3428483dc1da393b65a9a4f7ce3

团队列表

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

@@ -415,7 +415,7 @@
        </if>
    </select>

    <select id="selectAchieveBuyOrderCntByMemberId" resultType="java.lang.Integer ">
    <select id="selectAchieveBuyOrderCntByMemberId" resultType="java.lang.Integer">
        select count(a.id)
        from mall_product_buy a
             inner join mall_member b on a.member_id=b.ID
@@ -424,7 +424,7 @@
            and find_in_set(#{inviteId}, b.referrer_ids)
    </select>

    <select id="selectAchieveSellOrderCntByMemberId" resultType="java.lang.Integer ">
    <select id="selectAchieveSellOrderCntByMemberId" resultType="java.lang.Integer">
        select count(a.id)
        from mall_product_sell a
             inner join mall_member b on a.member_id=b.ID