src/main/java/cc/mrbird/febs/dapp/mapper/DappFundFlowDao.java
@@ -28,5 +28,7 @@ BigDecimal selectSumAmountByMemberIdAndType(@Param("memberId") Long memberId, @Param("type") Integer type); BigDecimal selectSumRunPerkByMemberId(@Param("memberId") Long memberId); DappFundFlowEntity selectNewestFundFlow(@Param("memberId") Long memberId, @Param("type") Integer type); } src/main/java/cc/mrbird/febs/dapp/service/impl/DappWalletServiceImpl.java
@@ -58,6 +58,7 @@ private final ChainProducer chainProducer; private final DappSystemDao dappSystemDao; private final DbMemberNodeMapper dbMemberNodeMapper; private final DappStorageMapper dappStorageMapper; @Override public WalletInfoVo walletInfo() { @@ -80,6 +81,22 @@ BigDecimal withdrawPercent = new BigDecimal(withdrawPercentDic.getValue()); walletInfo.setWithdrawPercent(withdrawPercent); QueryWrapper<DappStorage> objectQueryWrapper = new QueryWrapper<>(); objectQueryWrapper.eq("member_id",member.getId()); objectQueryWrapper.eq("state",1); List<DappStorage> dappStorages = dappStorageMapper.selectList(objectQueryWrapper); BigDecimal storageAva = BigDecimal.ZERO; if(CollUtil.isNotEmpty(dappStorages)){ storageAva = dappStorages.stream().map(DappStorage::getAmount).reduce(BigDecimal.ZERO, BigDecimal::add); } walletInfo.setStorageAva(storageAva); BigDecimal staticPerk = dappFundFlowDao.selectSumAmountByMemberIdAndType(member.getId(), MoneyFlowEnum.STATIC_PERK.getValue()); walletInfo.setStaticPerk(staticPerk); BigDecimal runPerk = dappFundFlowDao.selectSumRunPerkByMemberId(member.getId()); walletInfo.setRunPerk(runPerk); return walletInfo; } src/main/java/cc/mrbird/febs/dapp/vo/WalletInfoVo.java
@@ -35,4 +35,13 @@ @ApiModelProperty(value = "出局额度") private BigDecimal usdtBalance; @ApiModelProperty(value = "生效存储") private BigDecimal storageAva; @ApiModelProperty(value = "静态释放") private BigDecimal staticPerk; @ApiModelProperty(value = "动态释放") private BigDecimal runPerk; } src/main/resources/mapper/dapp/DappFundFlowDao.xml
@@ -88,6 +88,15 @@ and type = #{type} </select> <select id="selectSumRunPerkByMemberId" resultType="java.math.BigDecimal"> select ifnull(sum(amount), 0) from dapp_fund_flow where member_id = #{memberId} and type in (2,3,4,5,6,7,8,9,10) </select> <select id="selectNewestFundFlow" resultType="cc.mrbird.febs.dapp.entity.DappFundFlowEntity"> select * from dapp_fund_flow where member_id=#{memberId} and type = #{type}