From 88b54772dbcf5ecab1e2316e4e4626ac901b8908 Mon Sep 17 00:00:00 2001 From: yujian <yujian> Date: 星期二, 22 一月 2019 15:58:24 +0800 Subject: [PATCH] 邀请码添加返回状态 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java | 78 +++++++++++++++++++++++++++++++++++++++ 1 files changed, 78 insertions(+), 0 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java index 098300b..a4e1757 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java @@ -1,5 +1,7 @@ package com.yeshi.fanli.dao.mybatis; +import java.math.BigDecimal; +import java.util.Date; import java.util.List; import java.util.Map; @@ -7,6 +9,24 @@ public interface HongBaoV2CountMapper { + + /** + * 缁熻鍘嗗彶鎬诲埌璐﹂噾棰� + * @param uid + * @param state + * @return + */ + BigDecimal countMoneyByUidAndState(@Param("uid")Long uid, @Param("state") Integer state); + + + /** + * 缁熻鍘嗗彶绾㈠寘鏁伴噺 + * @param uid + * @param state + * @return + */ + Integer countNumberByUidAndState(@Param("uid")Long uid, @Param("state") Integer state); + /** * 缁熻鎬婚噾棰� * @param channel 娓犻亾 @@ -35,5 +55,63 @@ @Param("state") Integer state, @Param("year") String year, @Param("startTime")String startTime, @Param("endTime")String endTime); + + /** + * 缁熻鎬讳釜鏁� + * @param channel 娓犻亾 + * @param type + * @param state + * @param years + * @param startTime + * @param endTime + * @return + */ + List<Map<String, Object>> countHongBaoType(@Param("dateType")Integer dateType, + @Param("type") Integer type, @Param("year") String year, + @Param("startTime")String startTime, @Param("endTime")String endTime); + + /** + * 缁熻鎬讳釜鏁� + * @param channel 娓犻亾 + * @param type + * @param state + * @param years + * @param startTime + * @param endTime + * @return + */ + List<Map<String, Object>> countHongBaoTotalNum(@Param("dateType")Integer dateType, @Param("year") String year, + @Param("startTime")String startTime, @Param("endTime")String endTime); + + // 绱鎻愭垚璁㈠崟鏁伴噺锛堝寘鍚棤鏁堣鍗曪級 + int getTotalTiChengCount(Long uid); + + /** + * 缁熻鏈け鏁堣鍗曟暟閲� + * @param uid + * @param dateType + * @return + */ + long countValidNumberByUid(@Param("uid") Long uid, @Param("dateType")Integer dateType); + + /** + * 缁熻鏈埌璐� + * @param uid + * @return + */ + BigDecimal countWillGetMoneyByUid(@Param("uid") Long uid); + + + Date getLastHongBaoTime(@Param("uid") Long uid); + + + /** + * 鏍规嵁娓犻亾 缁熻鏂板鐢ㄦ埛24灏忔椂鍐呬骇鐢熺殑璁㈠崟鏁伴噺 + * + * @param channel + * @return + */ + List<Map<String, Object>> count24HOderByChannel(@Param("channel") String channel, @Param("type") Integer type, + @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime); } \ No newline at end of file -- Gitblit v1.8.0