From 9c9911225e32b308520afe3fe8bc20aa5ffa5094 Mon Sep 17 00:00:00 2001
From: yujian <yujian@123.com>
Date: 星期四, 29 八月 2019 15:55:23 +0800
Subject: [PATCH] 红包统计剔除 赠送退回统计
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/integral/IntegralTaskRecordMapper.java | 50 +++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 45 insertions(+), 5 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 180ea70..620558f 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
@@ -61,6 +61,18 @@
List<IntegralTaskRecord> listDaySignRecord(@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
@@ -84,10 +96,9 @@
* @param minTime
* @param maxTime
*/
- int countGetCountByTaskIdAndDay(@Param("taskId") Long taskId,@Param("uid")Long uid, @Param("minTime") Date minTime,
- @Param("maxTime") Date maxTime);
-
-
+ int countGetCountByTaskIdAndDay(@Param("taskId") Long taskId, @Param("uid") Long uid,
+ @Param("minTime") Date minTime, @Param("maxTime") Date maxTime);
+
/**
* 缁熻浠婃棩绗嚑娆″畬鎴愮殑浠诲姟
*
@@ -95,5 +106,34 @@
* @param uid
* @return
*/
- int countByTaskIdTodayNum(@Param("uid") Long uid, @Param("tid") Long tid, @Param("date") Date date);
+ int countByTaskIdTodayNum(@Param("uid") Long uid, @Param("tid") Long tid, @Param("date") String date);
+
+ /**
+ * 鏍规嵁绫诲瀷涓庡垱寤烘椂闂存绱�
+ *
+ * @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);
}
--
Gitblit v1.8.0