| | |
|---|
| | | package com.mzl.flower.mapper.wallet; |
|---|
| | | |
|---|
| | | import com.mzl.flower.dto.request.wallet.QueryWalletAmountDTO; |
|---|
| | | import com.mzl.flower.dto.response.wallet.WalletWithdrawVO; |
|---|
| | | import com.mzl.flower.entity.wallet.WalletDO; |
|---|
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
|---|
| | | import org.apache.ibatis.annotations.Param; |
|---|
| | |
|---|
| | | |
|---|
| | | BigDecimal getSupplierTotalTransactionAmount(@Param("dto") QueryWalletAmountDTO queryWalletAmountDTO); |
|---|
| | | |
|---|
| | | |
|---|
| | | @Select("select sum(t.withdrawable_amount) + sum(t.withdrawing_amount) as supplierPendingAmount, sum(t.withdrawn_amount) as supplierCompleteAmount from t_wallet t") |
|---|
| | | WalletWithdrawVO getSumWithdrawTotal(); |
|---|
| | | |
|---|
| | | //历史变动总金额 通过备注 |
|---|
| | | @Select("select sum(t.change_amount) from t_wallet_bill_record t where t.remark = '历史订单统一提现' and type = 'withdraw' ") |
|---|
| | | BigDecimal getSumHistoryWithdrawTotal(); |
|---|
| | | } |
|---|
