20210325 交易员头部信息

xiaoyong931011

2021-03-26 e9021602c042efff49267e7a164ab403ad00401d

20210325  交易员头部信息

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

@@ -60,7 +60,7 @@
    </select>

    <select id="selectFollowOrderTotalProfitByMemberId" resultType="java.math.BigDecimal">
        select IFNULL(sum(reward_ratio)*100, 0)
        select sum(reward_ratio)*100
        from contract_order
        where member_id=#{memberId} and contract_type=2
    </select>

 src/main/resources/mapper/documentary/FollowFollowerOrderRelationDao.xml

@@ -40,7 +40,7 @@
    </select>

    <select id="selectTraderTotalProfitSelf" resultType="java.math.BigDecimal">
        select IFNULL(sum(reward_amount), 0)
        select sum(reward_amount)
        from contract_order
        where member_id=#{memberId} and contract_type=2
    </select>