package com.ruoyi.account.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.ruoyi.account.api.model.UserPoint;
|
import com.ruoyi.account.vo.UserPointDetailVO;
|
import com.ruoyi.account.vo.UserPointExcel;
|
import com.ruoyi.account.vo.UserPointStatisticsPageVO;
|
import com.ruoyi.account.vo.UserPointStatisticsVO;
|
import com.ruoyi.common.core.web.page.PageInfo;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.time.LocalDateTime;
|
import java.util.Collection;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author luodangjia
|
* @since 2024-11-21
|
*/
|
public interface UserPointMapper extends BaseMapper<UserPoint> {
|
|
IPage<UserPoint> queryUserPointPage(@Param("page") IPage<UserPoint> page,@Param("userPoint") UserPoint userPoint);
|
|
List<UserPoint> selectUserPoint(@Param("userPoint") UserPoint userPoint);
|
|
|
/**
|
* 查询积分变更记录
|
* @param pageInfo
|
* @param userId
|
* @param startTime
|
* @param endTime
|
* @param type
|
* @return
|
*/
|
List<UserPointDetailVO> getUserPointDetail(PageInfo<UserPointDetailVO> pageInfo, @Param("userId") Long userId, @Param("startTime") LocalDateTime startTime,
|
@Param("endTime") LocalDateTime endTime, @Param("type") Integer type);
|
|
|
List<UserPointDetailVO> getUserPontDetailPageList(PageInfo<UserPointDetailVO> pageInfo, @Param("userId") Long userId, @Param("types")Collection<Integer> types);
|
|
Integer selectRechargeAndUse(@Param("name")String name,@Param("phone") String phone, @Param("beginTime")LocalDateTime beginTime, @Param("endTime")LocalDateTime endTime,@Param("type")Integer type);
|
|
List<UserPointStatisticsPageVO> getUserPointStatisticsPageList(PageInfo<UserPointStatisticsPageVO> pageInfo, @Param("types")Collection<Integer> types, @Param("name")String name,@Param("phone") String phone,@Param("beginTime") LocalDateTime beginTime,@Param("endTime") LocalDateTime endTime);
|
|
List<UserPointExcel> userPointExcel(@Param("types")Collection<Integer> types, @Param("name")String name,@Param("phone") String phone,@Param("beginTime") LocalDateTime beginTime,@Param("endTime") LocalDateTime endTime);
|
|
}
|
