From f4a0f2acc63d7785eab108419a4e16f5f688cb95 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期六, 18 一月 2020 12:06:27 +0800 Subject: [PATCH] 用户注册信息 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/UserMoneyDetailMapper.java | 186 ++++++++++++++++++++++++++-------------------- 1 files changed, 106 insertions(+), 80 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/UserMoneyDetailMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/UserMoneyDetailMapper.java index 0ba91ce..62ead1b 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/UserMoneyDetailMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/money/UserMoneyDetailMapper.java @@ -1,81 +1,107 @@ -package com.yeshi.fanli.dao.mybatis.money; - -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.money.UserMoneyDetail; -import com.yeshi.fanli.vo.money.UserMonthMoneyVO; - -public interface UserMoneyDetailMapper extends BaseMapper<UserMoneyDetail> { - /** - * 閫氳繃鐢ㄦ埛ID鍜岃繑鍥炵殑鏈�澶ф椂闂寸殑璇︽儏ID鏉ヨ幏鍙栦笅涓�椤电殑鏁版嵁 - * - * @param uid - * @param id - * @param count - * @return - */ - List<UserMoneyDetail> selectByUidWithIndexId(@Param("uid") Long uid, @Param("id") Long id, - @Param("count") int count); - - /** - * 鑾峰彇鐢ㄦ埛鎬诲叡鏈夊灏戣褰曟暟鎹� - * - * @param uid - * @return - */ - Long selectCountByUid(@Param("uid") Long uid); - - /** - * 鎸夋渶澶х殑鍒涘缓鏃堕棿鍜岀敤鎴稩D妫�绱㈠垪琛� - * - * @param uid - * @param date - * @return - */ - List<UserMoneyDetail> selectByMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date, - @Param("count") int count); - - /** - * 鎸夋渶澶х殑鍒涘缓鏃堕棿鍜岀敤鎴稩D妫�绱㈡暟閲� - * - * @param uid - * @param date - * @return - */ - Long selectCountByUidAndMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date); - - /** - * 鎸夌敤鎴稩D鍜屾渶澶ф椂闂存绱㈡湀浠界殑鏁伴噺 - * - * @param uid - * @param maxDate - * @return - */ - int selectMonthCountByUid(@Param("uid") Long uid, @Param("date") Date maxDate); - - /** - * 缁熻鏌愪釜鏈堜唤鐨勬敹鍏ヤ笌鏀嚭 - * - * @param uid - * @param dateFormat - * @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); - +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; + +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> { + /** + * 閫氳繃鐢ㄦ埛ID鍜岃繑鍥炵殑鏈�澶ф椂闂寸殑璇︽儏ID鏉ヨ幏鍙栦笅涓�椤电殑鏁版嵁 + * + * @param uid + * @param id + * @param count + * @return + */ + List<UserMoneyDetail> selectByUidWithIndexId(@Param("uid") Long uid, @Param("id") Long id, + @Param("count") int count, @Param("type") Integer type); + + /** + * 鑾峰彇鐢ㄦ埛鎬诲叡鏈夊灏戣褰曟暟鎹� + * + * @param uid + * @return + */ + Long selectCountByUid(@Param("uid") Long uid, @Param("type") Integer type); + + /** + * 鎸夋渶澶х殑鍒涘缓鏃堕棿鍜岀敤鎴稩D妫�绱㈠垪琛� + * + * @param uid + * @param date + * @return + */ + List<UserMoneyDetail> selectByMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date, + @Param("count") int count, @Param("type") Integer type); + + /** + * 鎸夋渶澶х殑鍒涘缓鏃堕棿鍜岀敤鎴稩D妫�绱㈡暟閲� + * + * @param uid + * @param date + * @return + */ + Long selectCountByUidAndMaxCreateTime(@Param("uid") Long uid, @Param("date") Date date, @Param("type") Integer type); + + /** + * 鎸夌敤鎴稩D鍜屾渶澶ф椂闂存绱㈡湀浠界殑鏁伴噺 + * + * @param uid + * @param maxDate + * @return + */ + int selectMonthCountByUid(@Param("uid") Long uid, @Param("date") Date maxDate, @Param("type") Integer type); + + /** + * 缁熻鏌愪釜鏈堜唤鐨勬敹鍏ヤ笌鏀嚭 + * + * @param uid + * @param dateFormat + * @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); + + /** + * 缁熻鏌愪釜鐢ㄦ埛鏌愭鏃堕棿鍐呬骇鐢熺殑鏄庣粏涔嬪拰 + * + * @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); + + /** + * 鏍规嵁绫诲瀷锛岀敤鎴稩D锛屽敮涓�鏍囪瘑鏌ヨ + * @param type + * @param uid + * @param sourceIdentifyId + * @return + */ + UserMoneyDetail selectByTypeAndUidAndIdentifyCode(@Param("type") UserMoneyDetailTypeEnum type, + @Param("uid") Long uid, @Param("sourceIdentifyId") Long sourceIdentifyId); + } \ No newline at end of file -- Gitblit v1.8.0