20200712 代码提交

xiaoyong931011

2020-07-12 2c357041e5dcf2e52aff24c45225fc3e895a6aff

20200712  代码提交

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

@@ -8,6 +8,15 @@
        FROM

            contract_hold_order s

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

        WHERE

            s.member_id IN (

                SELECT

                    id

                FROM

                    member

                WHERE

                    account_type = '1'

            )

        <where>

            <if test="record != null" >

                <if test="record.account!=null and record.account!=''">


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

@@ -9,7 +9,15 @@
            contract_order s

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

        <where>

        order_type in (3,4)

        s.order_type IN (3, 4)

        AND s.member_id IN (

            SELECT

                id

            FROM

                member

            WHERE

                account_type = '1'

        )

            <if test="record != null" >

                <if test="record.account!=null and record.account!=''">

                    and (m.phone = #{record.account} or m.email = #{record.account} or m.invite_id=#{record.account})