package com.yeshi.fanli.dao.mybatis.order;
|
|
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.order.OrderTeamReward;
|
|
public interface OrderTeamRewardMapper extends BaseMapper<OrderTeamReward> {
|
|
/**
|
* 查询用户补贴
|
*
|
* @param uid
|
* @param orderNo
|
* @param Type
|
* @return
|
*/
|
OrderTeamReward getByOrderNoAndType(@Param("uid") Long uid, @Param("orderNo") String orderNo,
|
@Param("type") Integer type);
|
|
/**
|
* 查询加锁
|
*
|
* @param uid
|
* @param orderNo
|
* @param type
|
* @return
|
*/
|
OrderTeamReward getByOrderNoAndTypeForUpdate(@Param("uid") Long uid, @Param("orderNo") String orderNo,
|
@Param("type") Integer type);
|
|
/**
|
* 根据订单号与来源类型查询
|
*
|
* @param orderNo
|
* @param type
|
* @return
|
*/
|
long countByOrderNoAndType(@Param("orderNo") String orderNo, @Param("type") Integer type);
|
|
/**
|
* 根据订单号与来源类型查询
|
*
|
* @param orderNo
|
* @param type
|
* @return
|
*/
|
List<OrderTeamReward> listByOrderNoAndType(@Param("orderNo") String orderNo, @Param("type") Integer type);
|
|
/**
|
* 根据补贴与用户ID查询
|
* @Title: selectBySubsidyIdAndUid
|
* @Description:
|
* @param subsidyId
|
* @param uid
|
* @return
|
* OrderTeamReward 返回类型
|
* @throws
|
*/
|
OrderTeamReward selectBySubsidyIdAndUidForUpdate(@Param("subsidyId") Long subsidyId, @Param("uid") Long uid);
|
|
/**
|
* 根据补贴ID查询
|
* @Title: listBySubsidyId
|
* @Description:
|
* @param subsidyId
|
* @return
|
* List<OrderTeamReward> 返回类型
|
* @throws
|
*/
|
List<OrderTeamReward> listBySubsidyId(Long subsidyId);
|
|
/**
|
* 通过用户ID查询可以结算的奖励列表
|
* @Title: listCanSettleByUid
|
* @Description:
|
* @param uid
|
* @param page
|
* @param pageSize
|
* @return
|
* List<OrderTeamReward> 返回类型
|
* @throws
|
*/
|
List<OrderTeamReward> listCanSettleByUid(@Param("uid") Long uid, @Param("start") long start,
|
@Param("count") int count);
|
|
/**
|
* 通过用户ID统计可以结算的奖励数量
|
* @Title: countCanSettle
|
* @Description:
|
* @param uid
|
* @return
|
* long 返回类型
|
* @throws
|
*/
|
long countCanSettle(@Param("uid") Long uid);
|
|
/**
|
* 获取某个时间点可以结算的用户ID列表
|
* @Title: listCanSettleUid
|
* @Description:
|
* @param time
|
* @param start
|
* @param count
|
* @return
|
* List<Long> 返回类型
|
* @throws
|
*/
|
List<Long> listCanSettleUid( @Param("time") Date time, @Param("start") long start, @Param("count") int count);
|
|
/**
|
* 获取某个时间点可以结算的用户数量
|
* @Title: countCanSettleUid
|
* @Description:
|
* @param time
|
* @return
|
* Long 返回类型
|
* @throws
|
*/
|
Long countCanSettleUid(Date time);
|
|
|
/**
|
* 统计用户已到账金额
|
* @param uid
|
* @return
|
*/
|
BigDecimal sumRecievedMoneyByUid(@Param("uid") long uid, @Param("level") Integer level);
|
|
|
/**
|
* 统计用户有效金额
|
* @param uid
|
* @param day 1今日 2昨日 3本月 4上月
|
* @return
|
*/
|
BigDecimal sumValidMoneyByUidAndDate(@Param("uid") long uid, @Param("day") Integer day, @Param("level") Integer level);
|
}
|
