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/integral/IntegralTaskRecordMapper.java | 205 +++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 157 insertions(+), 48 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/integral/IntegralTaskRecordMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/integral/IntegralTaskRecordMapper.java index d4c9f9b..9919bf0 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/integral/IntegralTaskRecordMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/integral/IntegralTaskRecordMapper.java @@ -1,48 +1,157 @@ -package com.yeshi.fanli.dao.mybatis.integral; - -import java.util.List; - -import org.apache.ibatis.annotations.Param; - -import com.yeshi.fanli.dao.BaseMapper; -import com.yeshi.fanli.entity.integral.IntegralTaskRecord; - -public interface IntegralTaskRecordMapper extends BaseMapper<IntegralTaskRecord> { - - /** - * 鏈鍙栭噾甯� - * @param count - * @param uid - * @return - */ - List<IntegralTaskRecord> listNotReceived(@Param("count") int count, @Param("uid") Long uid); - - - /** - * 鎬诲畬鎴� - * @param uid - * @param dateType - * @return - */ - Integer getTotalGoldCoin(@Param("uid") Long uid, @Param("cid") Long cid, @Param("dateType")Integer dateType); - - /** - * 缁熻瀹屾垚鏁伴噺 - * @param uid - * @param cid - * @param dateType - * @return - */ - Integer countFinished(@Param("uid") Long uid, @Param("cid") Long cid, @Param("dateType")Integer dateType); - - /** - * 杩�7澶╃鍒版儏鍐� - * @param uid - * @param cid - * @param sortState 1鍊掑簭-鍒涘缓鏃堕棿 - * @return - */ - List<IntegralTaskRecord> listDaySignRecord(@Param("uid") Long uid, @Param("cid") Long cid); - -} - +package com.yeshi.fanli.dao.mybatis.integral; + +import java.util.Date; +import java.util.List; +import java.util.Set; + +import org.apache.ibatis.annotations.Param; + +import com.yeshi.fanli.dao.BaseMapper; +import com.yeshi.fanli.entity.integral.IntegralTaskRecord; + +public interface IntegralTaskRecordMapper extends BaseMapper<IntegralTaskRecord> { + + /** + * 鏈鍙栭噾甯� + * + * @param count + * @param uid + * @return + */ + List<IntegralTaskRecord> listNotReceived(@Param("count") int count, @Param("uid") Long uid); + + /** + * 鏈鍙栭噾甯�- 鎺掗櫎id + * + * @param count + * @param uid + * @return + */ + List<IntegralTaskRecord> listNotReceivedExcludeId(@Param("count") int count, @Param("uid") Long uid, + @Param("list") Set<Long> idList); + + /** + * 鎬诲畬鎴� + * + * @param uid + * @param dateType + * @return + */ + Integer getTotalGoldCoin(@Param("uid") Long uid, @Param("cid") Long cid, @Param("dateType") Integer dateType); + + /** + * 缁熻瀹屾垚鏁伴噺 + * + * @param uid + * @param cid + * @param dateType + * @return + */ + Integer countFinished(@Param("uid") Long uid, @Param("cid") Long cid, @Param("dateType") Integer dateType); + + /** + * 杩�7澶╃鍒版儏鍐� + * + * @param uid + * @param cid + * @param sortState + * 1鍊掑簭-鍒涘缓鏃堕棿 + * @return + */ + List<IntegralTaskRecord> listDaySignRecord(@Param("uid") Long uid, @Param("cid") Long cid); + + + /** + * 杩炵画绛惧埌鎯呭喌 + * + * @param uid + * @param cid + * @param sortState + * 1鍊掑簭-鍒涘缓鏃堕棿 + * @return + */ + List<IntegralTaskRecord> listDateSignRecord(@Param("uid") Long uid, @Param("cid") Long cid); + + /** + * 杩�7澶╃鍒版儏鍐� + * + * @param uid + * @param cid + * @param sortState + * 1鍊掑簭-鍒涘缓鏃堕棿 + * @return + */ + List<IntegralTaskRecord> listSignRecordByDateTime(@Param("uid") Long uid, @Param("cid") Long cid, + @Param("dateTime") String dateTime); + + /** + * 鏈鍙栭噾甯� + * + * @param count + * @param uid + * @return + */ + int countTotalGoldCoin(@Param("uid") Long uid); + + /** + * 鏇存柊棰嗗彇鐘舵�� + * + * @param uid + */ + void updateReceived(@Param("uid") Long uid); + + /** + * 鏍规嵁浠诲姟ID涓庢椂闂存鏌ヨ浠诲姟瀹屾垚鏁伴噺 + * + * @param taskId + * @param uid + * @param minTime + * @param maxTime + */ + int countGetCountByTaskIdAndDay(@Param("taskId") Long taskId, @Param("uid") Long uid, + @Param("minTime") Date minTime, @Param("maxTime") Date maxTime); + + /** + * 缁熻浠婃棩绗嚑娆″畬鎴愮殑浠诲姟 + * + * @param count + * @param uid + * @return + */ + int countByTaskIdTodayNum(@Param("uid") Long uid, @Param("tid") Long tid, @Param("date") String date, + @Param("recordId") Long recordId); + + /** + * 鏍规嵁绫诲瀷涓庡垱寤烘椂闂存绱� + * + * @param cid + * @param minTime + * @param maxTime + * @param start + * @param count + * @return + */ + List<IntegralTaskRecord> listByCidAndUidAndCreateTime(@Param("cid") Long cid, @Param("uid") Long uid, + @Param("minTime") Date minTime, @Param("maxTime") Date maxTime, @Param("start") long start, + @Param("count") int count); + + long countByCidAndUidAndCreateTime(@Param("cid") Long cid, @Param("uid") Long uid, @Param("minTime") Date minTime, + @Param("maxTime") Date maxTime); + + /** + * 鏍规嵁鐢ㄦ埛ID涓庝换鍔D鏌ヨ + * + * @param uid + * @param taskId + * @param start + * @param count + * @return + */ + List<IntegralTaskRecord> listByUidAndTaskId(@Param("uid") Long uid, @Param("taskId") Long taskId, + @Param("start") long start, @Param("count") int count); + + /** + * 鏇存柊閲戝竵澶辨晥 + */ + void invalidGoldCoin(); +} -- Gitblit v1.8.0