From 0b57cfd62e842b309d03467b96a331c673ecad7c Mon Sep 17 00:00:00 2001 From: admin <weikou2014> Date: 星期二, 21 四月 2020 14:08:18 +0800 Subject: [PATCH] 删除普通会员等级 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/InviteOrderSubsidyDebtMapper.java | 23 ++++++++++++++++++----- 1 files changed, 18 insertions(+), 5 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/InviteOrderSubsidyDebtMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/InviteOrderSubsidyDebtMapper.java index 9b99595..90ba8dc 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/InviteOrderSubsidyDebtMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/InviteOrderSubsidyDebtMapper.java @@ -1,6 +1,7 @@ package com.yeshi.fanli.dao.mybatis.money; import java.math.BigDecimal; +import java.util.Date; import java.util.List; import org.apache.ibatis.annotations.Param; @@ -20,8 +21,9 @@ * @param pageSize * @return */ - List<InviteOrderSubsidyDebt> listByLeftMoneyAndUid(@Param("minMoney") BigDecimal minMoney, - @Param("maxMoney") BigDecimal maxMoney, @Param("uid") Long uid, @Param("start") long start, + List<InviteOrderSubsidyDebt> listByLeftMoneyAndUidAndMaxEstimatePayTime(@Param("minMoney") BigDecimal minMoney, + @Param("maxMoney") BigDecimal maxMoney, @Param("uid") Long uid, + @Param("maxEstimatePayTime") Date maxEstimatePayTime, @Param("start") long start, @Param("count") int count); /** @@ -32,8 +34,9 @@ * @param uid * @return */ - long countByLeftMoneyAndUid(@Param("minMoney") BigDecimal minMoney, @Param("maxMoney") BigDecimal maxMoney, - @Param("uid") Long uid); + long countByLeftMoneyAndUidAndMaxEstimatePayTime(@Param("minMoney") BigDecimal minMoney, + @Param("maxMoney") BigDecimal maxMoney, @Param("uid") Long uid, + @Param("maxEstimatePayTime") Date maxEstimatePayTime); InviteOrderSubsidyDebt selectByPrimaryKeyForUpdate(Long id); @@ -43,6 +46,16 @@ * @param uid * @return */ - BigDecimal sumLeftMoneyByUid(Long uid); + BigDecimal sumLeftMoneyByUid(@Param("uid")Long uid,@Param("maxEstimatePayTime")Date maxEstimatePayTime); + + + /** + * 璁$畻娆犳閲戦锛堣ˉ璐碔D锛� + * + * @param uid + * @return + */ + InviteOrderSubsidyDebt getBySourceId(@Param("sourceId")Long sourceId); + } \ No newline at end of file -- Gitblit v1.8.0