From 972d3bc71115ec977dccf835fbcd148da3bcc86c Mon Sep 17 00:00:00 2001
From: yujian <yujian@123.com>
Date: 星期二, 03 九月 2019 16:41:49 +0800
Subject: [PATCH] 统计可用的免单券数量-countUsableFreeCouponForBuy
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/integral/IntegralTaskRecordMapper.java | 48 ++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 44 insertions(+), 4 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 35f1c1f..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);
+
/**
* 缁熻浠婃棩绗嚑娆″畬鎴愮殑浠诲姟
*
@@ -96,4 +107,33 @@
* @return
*/
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