fix
Helius
2022-07-30 6f0f8c8241c743edc8cc6411e4573a4a26940214
fix
1 files modified
8 ■■■■ changed files
src/main/resources/mapper/dapp/DappFundFlowDao.xml 8 ●●●● patch | view | raw | blame | history
src/main/resources/mapper/dapp/DappFundFlowDao.xml
@@ -53,10 +53,10 @@
    <select id="selectAmountTotalByType" resultType="java.util.HashMap">
        select
            MAX(if(type = 1, a.amount, 0)) buy
             , MAX(if(type = 2, a.amount, 0)) sale
             , MAX(if(type = 3, a.amount, 0)) mine
             , MAX(if(type = 4, a.amount, 0)) teamReward
            IFNULL(MAX(if(type = 1, a.amount, 0)),0) buy
             , IFNULL(MAX(if(type = 2, a.amount, 0)),0) sale
             , IFNULL(MAX(if(type = 3, a.amount, 0)),0) mine
             , IFNULL(MAX(if(type = 4, a.amount, 0)),0) teamReward
        from (select type, sum(amount) amount
                 from dapp_fund_flow
                 where member_id=#{memberId}