package com.mzl.flower.mapper.wallet;
|
|
import com.mzl.flower.dto.request.wallet.QueryWalletAmountDTO;
|
import com.mzl.flower.entity.wallet.WalletDO;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import java.math.BigDecimal;
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author @TaoJie
|
* @since 2024-10-22
|
*/
|
@Repository
|
public interface WalletMapper extends BaseMapper<WalletDO> {
|
|
|
@Select("select * from t_wallet where supplier_id =#{supplierId}")
|
public WalletDO getTotalAmount(String supplierId);
|
|
BigDecimal getWaittingSettlementAmount(@Param("dto") WalletDO walletDO);
|
|
@Select("select label from t_code_value where type_code='WALLET_ONLINE_TIME' and value='online'")
|
String selectWalletOnlineTime();
|
|
BigDecimal getSupplierTotalTransactionAmount(@Param("dto") QueryWalletAmountDTO queryWalletAmountDTO);
|
|
}
|