src/main/java/cc/mrbird/febs/mall/mapper/MallScoreRecordMapper.java
@@ -20,4 +20,6 @@ IPage<MallScoreRecord> gerRoleReleaseListInPage(Page<MallScoreRecord> page, @Param("record")AdminRoleReleaseDto roleReleaseDto); IPage<MallMoneyFlow> gerRoleReleaseChildInPage(Page<MallMoneyFlow> page, @Param("record")MallScoreRecord mallScoreRecord); BigDecimal selectSurplusCntByMemberId(@Param("memberId")Long id); } src/main/java/cc/mrbird/febs/mall/service/impl/ScoreServiceImpl.java
@@ -58,6 +58,7 @@ private final MallMemberBankMapper mallMemberBankMapper; private final MallMemberWithdrawMapper mallMemberWithdrawMapper; private final IApiMallMemberService mallMemberService; private final MallScoreRecordMapper mallScoreRecordMapper; @Override public ScoreSignVo scoreSign() { @@ -117,6 +118,9 @@ GreenScoreEnum.SCORE_POOL_CNT.getType(), GreenScoreEnum.SCORE_POOL_CNT.getCode()); apiScoreVoucherInfoVo.setScorePoolCnt(new BigDecimal(scorePoolCntDic.getValue()).setScale(2,BigDecimal.ROUND_DOWN)); BigDecimal voucherCntSurplus = mallScoreRecordMapper.selectSurplusCntByMemberId(member.getId()); apiScoreVoucherInfoVo.setVoucherCntSurplus(voucherCntSurplus); return apiScoreVoucherInfoVo; } src/main/java/cc/mrbird/febs/mall/vo/ApiScoreVoucherInfoVo.java
@@ -13,6 +13,9 @@ @ApiModelProperty(value = "绿色积分") private BigDecimal voucherCnt; @ApiModelProperty(value = "绿色积分-待释放") private BigDecimal voucherCntSurplus; /** * 数量 */ src/main/resources/mapper/modules/MallScoreRecordMapper.xml
@@ -41,4 +41,11 @@ order by a.created_time desc </select> <select id="selectSurplusCntByMemberId" resultType="java.math.BigDecimal"> select IFNULL(sum(IFNULL(surplus_cnt,0)),0) from mall_score_record where member_id = #{memberId} </select> </mapper>