| | |
| | | |
| | | <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} |