20210406 交易员列表查询

xiaoyong931011

2021-04-06 88dba6b6bac3c3a579f092079ad07ea0b7cb9b89

20210406  交易员列表查询

 src/main/resources/mapper/contract/ContractOrderDao.xml

@@ -88,7 +88,8 @@
        select count(1)
        from contract_order a
        where member_id=#{memberId}
        and contract_type=2 and order_type in (3,4)
        and contract_type=2
          and closing_time is not null
        <if test="type!=null and type==1">
            and reward_amount > 0
        </if>
@@ -128,16 +129,17 @@
    </select>

    <select id="selectThirtyTotalCntByMemberId" resultType="java.math.BigDecimal">
        select count(id)/2
        select count(id)
        from contract_order
        where
              member_id=#{memberId}
          and contract_type=2
          and closing_time is not null
          and create_time BETWEEN #{offsetDay} and #{date}
    </select>

    <select id="selectThirtyWinCntByMemberId" resultType="java.math.BigDecimal">
        select count(id)/2
        select count(id)
        from contract_order
        where
        member_id=#{memberId}