package com.ruoyi.admin.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.admin.entity.Withdraw;
|
import com.ruoyi.admin.vo.UserWithdrawRecordVO;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
/**
|
* <p>
|
* 用户提现记录表 Mapper 接口
|
* </p>
|
*
|
* @author hjl
|
* @since 2024-05-29
|
*/
|
public interface WithdrawMapper extends BaseMapper<Withdraw> {
|
|
/**
|
* 获取用户提现金额
|
*
|
* @param cityIdList 城市id
|
* @return 总金额
|
*/
|
BigDecimal withdrawalTotalMoney(@Param("ids") List<String> cityIdList);
|
|
/**
|
* 年度查询
|
*
|
* @param cityIdList 城市id
|
* @return 年度提现总额
|
*/
|
BigDecimal withdrawalTotalMoneyByYear(@Param("ids") List<String> cityIdList);
|
|
/**
|
* 月度查询
|
*
|
* @param cityIdList 城市id
|
* @return 年度提现总额
|
*/
|
BigDecimal withdrawalTotalMoneyByMonth(@Param("ids") List<String> cityIdList);
|
|
/**
|
* 用户所关联提现记录分页列表
|
*
|
* @param userId 用户id
|
* @param page 分页参数
|
* @return 分页列表
|
*/
|
IPage<UserWithdrawRecordVO> withdrawList(@Param("userId") Integer userId, Page<UserWithdrawRecordVO> page);
|
}
|
