20200721 代码提交

xiaoyong931011

2020-07-21 73ba9555b3c37880af618ae44708b1c711173e7b

20200721  代码提交

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

@@ -724,6 +724,19 @@
            AND account_status = '1'

        )

    </select>

    <select id="selectHYZHForBasicRealDataAlone" resultType="java.lang.String">

        SELECT

            COUNT(a.id)

        FROM

            member_wallet_contract a

			
        LEFT JOIN member m ON m.id = a.member_id

        WHERE

            a.wallet_code = 'USDT'

        AND a.total_balance > 1

        AND FIND_IN_SET('22015141', m.referer_ids)

        AND m.account_type = 1;

    </select>

    <select id="selectHYZHForBasicAllDataAlone" resultType="java.lang.String">

        SELECT

            COUNT(a.id)