| | |
| | | import org.apache.ibatis.annotations.Select; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.List; |
| | | |
| | | /** |
| | |
| | | @Select("select * from t_wallet_bill_record where withdraw_record_id = #{withdrawRecordId}") |
| | | WalletBillRecordDO getBillRecordByWithdrawRecordId(Long withdrawRecordId); |
| | | |
| | | @Select("SELECT COALESCE(SUM(change_amount), 0) AS change_amount FROM t_wallet_bill_record WHERE supplier_id = #{supplierId} and wallet_id = #{walletId} AND remark = '历史订单统一提现'") |
| | | BigDecimal getHistoryAmount(Long walletId, Long supplierId); |
| | | } |
| | | |
| | | |