| | |
| | | package com.yeshi.fanli.dao.mybatis.money; |
| | | |
| | | import java.math.BigDecimal; |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | |
| | |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.money.UserMoneyDetail; |
| | | import com.yeshi.fanli.entity.money.UserMoneyDetail.UserMoneyDetailTypeEnum; |
| | | import com.yeshi.fanli.vo.money.UserMonthMoneyVO; |
| | | |
| | | public interface UserMoneyDetailMapper extends BaseMapper<UserMoneyDetail> { |
| | |
| | | * @return |
| | | */ |
| | | List<UserMonthMoneyVO> selectMonthMoneyByUid(@Param("uid") Long uid, @Param("dateFormat") List<String> dateFormat); |
| | | |
| | | |
| | | /** |
| | | * 根据用户ID获取资金明细(老版) |
| | | * |
| | | * @param uid |
| | | * @param start |
| | | * @param count |
| | | * @return |
| | | */ |
| | | |
| | | List<UserMoneyDetail> selectByUidWithState(@Param("uid")Long uid,@Param("start") long start, @Param("count")int count); |
| | | |
| | | Long selectCountByUidWithState(@Param("uid")Long uid); |
| | | List<UserMoneyDetail> selectByUidWithState(@Param("uid") Long uid, @Param("start") long start, |
| | | @Param("count") int count); |
| | | |
| | | Long selectCountByUidWithState(@Param("uid") Long uid); |
| | | |
| | | /** |
| | | * 统计某个用户某段时间内产生的明细之和 |
| | | * |
| | | * @param uid |
| | | * @param typeList |
| | | * @param minDate |
| | | * @param maxDate |
| | | * @return |
| | | */ |
| | | BigDecimal getTotalMoneyByTypeAndUidWithDate(@Param("uid") Long uid, @Param("typeList") List<String> typeList, |
| | | @Param("minDate") Date minDate, @Param("maxDate") Date maxDate); |
| | | |
| | | /** |
| | | * 根据类型,用户ID,唯一标识查询 |
| | | * @param type |
| | | * @param uid |
| | | * @param sourceIdentifyId |
| | | * @return |
| | | */ |
| | | UserMoneyDetail selectByTypeAndUidAndIdentifyCode(@Param("type") UserMoneyDetailTypeEnum type, |
| | | @Param("uid") Long uid, @Param("sourceIdentifyId") Long sourceIdentifyId); |
| | | |
| | | } |