| | |
| | | @TableField(exist = false) |
| | | private BigDecimal myTeamAchieve; |
| | | |
| | | @ApiModelProperty(value = "累计提现") |
| | | @TableField(exist = false) |
| | | private BigDecimal withdrawAmount; |
| | | |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.math.BigDecimal; |
| | | |
| | | public interface MemberCoinWithdrawDao extends BaseMapper<MemberCoinWithdrawEntity> { |
| | | |
| | | IPage<AdminMemberCoinWithdrawVo> findMemberWithdrawCoinInPage(Page<MemberCoinWithdrawEntity> page, @Param("record")MemberCoinWithdrawEntity memberCoinWithdrawEntity); |
| | |
| | | Integer selectByMemberIdAndCreateTime(@Param("memberId")Long memberIdOut, @Param("createTime")String createTime, @Param("type")String type); |
| | | |
| | | MemberCoinWithdrawEntity selectByFlowId(@Param("memberId")Long memberId,@Param("flowId")Long id); |
| | | |
| | | BigDecimal selectByMemberIdAndStatus(@Param("memberId")Long memberId, @Param("status")Integer status); |
| | | } |
| | |
| | | private final MallGoodsCategoryMapper mallGoodsCategoryMapper; |
| | | private final PlatformBannerMapper platformBannerMapper; |
| | | private final MallGoodsImagesMapper goodsImagesMapper; |
| | | private final MemberCoinWithdrawDao memberCoinWithdrawDao; |
| | | |
| | | @Override |
| | | @Transactional(rollbackFor = Exception.class) |
| | |
| | | |
| | | BigDecimal totalIncomeMember = dappMemberDao.selectAllAchieveByInviteId(memberEntity.getInviteId()); |
| | | memberEntity.setMyTeamAchieve(totalIncomeMember); |
| | | |
| | | BigDecimal withdrawAmount = memberCoinWithdrawDao.selectByMemberIdAndStatus(memberId, MemberCoinWithdrawEntity.STATUS_YES); |
| | | memberEntity.setWithdrawAmount(withdrawAmount); |
| | | } |
| | | } |
| | | return dappMemberEntityIPage; |
| | |
| | | and a.flow_id = #{flowId} |
| | | </select> |
| | | |
| | | <select id="selectByMemberIdAndStatus" resultType="java.math.BigDecimal"> |
| | | SELECT |
| | | IFNULL(sum(IFNULL(a.amount, 0)),0) |
| | | FROM |
| | | member_coin_withdraw a |
| | | where a.member_id = #{memberId} |
| | | and a.status = #{status} |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | {field: 'coinAmount', title: '余额', minWidth: 130}, |
| | | {field: 'scoreAmount', title: '赠送积分', minWidth: 130}, |
| | | {field: 'balance', title: '资产包', minWidth: 130}, |
| | | {field: 'withdrawAmount', title: '累计提现', minWidth: 130}, |
| | | {field: 'myTeamAchieve', title: '团队业绩', minWidth: 130}, |
| | | {field: 'myShareAchieve', title: '共享业绩', minWidth: 130}, |
| | | {field: 'activeStatus', title: '是否激活', templet:'#switchActiveStatus', minWidth: 120}, |