package com.yeshi.fanli.dao.mybatis.tlj;
|
|
import java.math.BigDecimal;
|
import java.util.Date;
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Param;
|
|
import com.yeshi.fanli.dao.BaseMapper;
|
import com.yeshi.fanli.entity.bus.tlj.UserTaoLiJinOrigin;
|
|
public interface UserTaoLiJinOriginMapper extends BaseMapper<UserTaoLiJinOrigin> {
|
|
/**
|
* 根据日期类型统计金额
|
* @param uid
|
* @param dateType 1今日 、2昨日、3本月、4上月
|
* @return
|
*/
|
BigDecimal countMoneyByDate(@Param("uid")long uid, @Param("dateType")int dateType);
|
|
|
/**
|
* 根据用户、来源统计
|
* @param uid
|
* @param origin
|
* @return
|
*/
|
long countByUidAndOrigin(@Param("uid")long uid, @Param("origin")String origin);
|
|
/**
|
* 根据用户、来源统计
|
* @param uid
|
* @param origin
|
* @return
|
*/
|
UserTaoLiJinOrigin getByUidAndOrigin(@Param("uid")long uid, @Param("origin")String origin);
|
|
/**
|
* 统计本月等级红包
|
* @param uid
|
* @param origin
|
* @return
|
*/
|
long countRankByThisMonth(@Param("uid")long uid);
|
|
|
/**
|
* 统计本月等级红包
|
* @param uid
|
* @param origin
|
* @return
|
*/
|
UserTaoLiJinOrigin getRankByThisMonth(@Param("uid")long uid, @Param("type")String type);
|
|
|
/**
|
* 查询过期的红包 排除等级
|
* @param date
|
* @return
|
*/
|
List<UserTaoLiJinOrigin> getOverdueTaoLiJin(@Param("uid")long uid, @Param("date")Date date);
|
|
|
/**
|
* 查询过期的红包-等级
|
* @param date
|
* @return
|
*/
|
List<UserTaoLiJinOrigin> getOverdueTaoLiJinByRank(@Param("uid")long uid, @Param("date")Date date);
|
|
/**
|
* 查询剩余淘礼金
|
* @param uid
|
* @return
|
*/
|
List<UserTaoLiJinOrigin> getSurplusLiJin(@Param("uid")long uid);
|
|
|
/**
|
* 统计用户红包记录
|
* @param uid
|
* @return
|
*/
|
long countByUidAndType(@Param("uid")long uid, @Param("type")String type);
|
|
|
/**
|
* 统计金额
|
* @param rightsId
|
* @param origin
|
* @return
|
*/
|
BigDecimal countMoneyByOrigin(@Param("rightsId")String rightsId, @Param("origin")String origin);
|
|
/**
|
* 根据淘礼金id查询
|
* @param rightsId
|
* @return
|
*/
|
UserTaoLiJinOrigin getOriginByRightsId(@Param("rightsId")String rightsId);
|
|
}
|
