cloudroam
2024-11-27 0d0a028920745bcdc5d9ddbf0ab3cbccfe167c63
src/main/java/com/mzl/flower/mapper/wallet/WalletBillRecordMapper.java
@@ -10,6 +10,7 @@
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import java.math.BigDecimal;
import java.util.List;
/**
@@ -34,5 +35,8 @@
    @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);
}