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/HongBaoV2CountMapper.java | 424 +++++++++++++++++++++++++++++----------------------- 1 files changed, 234 insertions(+), 190 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 4d84adf..e8552bb 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,191 +1,235 @@ -package com.yeshi.fanli.dao.mybatis; - -import java.math.BigDecimal; -import java.util.Date; -import java.util.List; - -import org.apache.ibatis.annotations.Param; - -import com.yeshi.fanli.dto.ChartTDO; -import com.yeshi.fanli.vo.order.HongBaoV2VO; - -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 uid - * @return - */ - Long countNumberByUid(@Param("uid") Long uid); - - /** - * 缁熻鎬婚噾棰� - * - * @param channel - * 娓犻亾 - * @param type - * @param state - * @param years - * @param startTime - * @param endTime - * @return - */ - List<ChartTDO> countHongBaoMoney(@Param("channel") String channel, @Param("dateType") Integer dateType, - @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<ChartTDO> countHongBaoNum(@Param("channel") String channel, @Param("dateType") Integer dateType, - @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<ChartTDO> 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<ChartTDO> 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<ChartTDO> count24HOderByChannel(@Param("channel") String channel, @Param("type") Integer type, - @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime); - - List<HongBaoV2VO> listShareAndInviteMoney(@Param("start") long start, @Param("count") int count, - @Param("date") String date); - - /** - * 缁熻濂栧姳鍒告�婚噾棰� - * - * @return - */ - BigDecimal countRebateCouponMoney(); - - /** - * 缁熻鐢ㄦ埛宸插埌璐� - * - * @param uid - * @param typeList - * @param minGetTime - * @param maxGetTime - * @return - */ - BigDecimal sumAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList, - @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime); - - long countAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList, - @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime); - - - /** - * 缁熻杩斿埄璁㈠崟 - * @param uid - * @return - */ - long countRebateOrder(@Param("uid") Long uid); - - /** - * 缁熻鍒嗕韩鍜岄個璇疯鍗� - * @param uid - * @return - */ - long countShareOrInviteOrder(@Param("uid") Long uid); - - /** - * 缁熻涓嬬骇浜х敓鏈夋晥鍒嗕韩濂栭噾 - * @param uid - * @param teamUid 涓嬬骇id - * @param endTime 缁撴潫鏃堕棿 - * @return - */ - BigDecimal getShareRewardByTeamUid(@Param("uid") Long uid, @Param("teamUid") Long teamUid, @Param("endTime") Date endTime); - - /** - * 缁熻涓嬬骇涓婁釜鏈夋晥璁㈠崟 - * @param uid - * @param teamUid 涓嬬骇id - * @param endTime 缁撴潫鏃堕棿 - * @return - */ - BigDecimal getShareRewardByTeamUidLastMonth(@Param("uid") Long uid, @Param("teamUid") Long teamUid); - +package com.yeshi.fanli.dao.mybatis; + +import java.math.BigDecimal; +import java.util.Date; +import java.util.List; + +import org.apache.ibatis.annotations.Param; + +import com.yeshi.fanli.dto.ChartTDO; +import com.yeshi.fanli.vo.order.HongBaoV2VO; + +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 uid + * @return + */ + Long countNumberByUid(@Param("uid") Long uid); + + /** + * 缁熻鎬婚噾棰� + * + * @param channel + * 娓犻亾 + * @param type + * @param state + * @param years + * @param startTime + * @param endTime + * @return + */ + List<ChartTDO> countHongBaoMoney(@Param("channel") String channel, @Param("dateType") Integer dateType, + @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<ChartTDO> countHongBaoNum(@Param("channel") String channel, @Param("dateType") Integer dateType, + @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<ChartTDO> 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<ChartTDO> countHongBaoTotalNum(@Param("dateType") Integer dateType, @Param("year") String year, + @Param("startTime") String startTime, @Param("endTime") String endTime); + + // 绱鎻愭垚璁㈠崟鏁伴噺锛堝寘鍚棤鏁堣鍗曪級 + int getTotalTiChengCount(Long uid); + + + // 绱鎻愭垚绾㈠寘鏁伴噺锛堝寘鍚棤鏁堬級 + long getHongBaoCount(@Param("uid") Long uid, @Param("type") Integer type); + + /** + * 缁熻鏈け鏁堣鍗曟暟閲� + * + * @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<ChartTDO> count24HOderByChannel(@Param("channel") String channel, @Param("type") Integer type, + @Param("years") String years, @Param("startTime") String startTime, @Param("endTime") String endTime); + + List<HongBaoV2VO> listShareAndInviteMoney(@Param("start") long start, @Param("count") int count, + @Param("date") String date); + + /** + * 缁熻濂栧姳鍒告�婚噾棰� + * + * @return + */ + BigDecimal countRebateCouponMoney(); + + /** + * 缁熻鐢ㄦ埛宸插埌璐� + * + * @param uid + * @param typeList + * @param minGetTime + * @param maxGetTime + * @return + */ + BigDecimal sumAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList, + @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime); + + long countAlreadyGetMoneyByUid(@Param("uid") Long uid, @Param("typeList") List<Integer> typeList, + @Param("minGetTime") Date minGetTime, @Param("maxGetTime") Date maxGetTime); + + + /** + * 缁熻杩斿埄璁㈠崟 + * @param uid + * @return + */ + long countRebateOrder(@Param("uid") Long uid); + + /** + * 缁熻鍒嗕韩鍜岄個璇疯鍗� + * @param uid + * @return + */ + long countShareOrInviteOrder(@Param("uid") Long uid); + + /** + * 缁熻涓嬬骇浜х敓鏈夋晥鍒嗕韩濂栭噾 + * @param uid + * @param teamUid 涓嬬骇id + * @param endTime 缁撴潫鏃堕棿 + * @return + */ + + BigDecimal getOrderRewardByTeamUid(@Param("uid") Long uid, @Param("teamUid") Long teamUid, @Param("endTime") Date endTime); + + /** + * 缁熻涓嬬骇涓婁釜鏈夋晥璁㈠崟 + * @param uid + * @param teamUid 涓嬬骇id + * @param endTime 缁撴潫鏃堕棿 + * @return + */ + BigDecimal getOrderRewardByTeamUidTheMonth(@Param("uid") Long uid, @Param("teamUid") Long teamUid); + + /** + * 缁熻宸插埌璐﹂噾棰� + * @param uid + * @param list 绫诲瀷 + * @return + */ + BigDecimal getRewardMoneyByUid(@Param("uid") Long uid, @Param("list") List<Integer> list); + + /** + * 娉細1.鏈夋晥涓�绾ч槦鍛樺畾涔夛細2019骞�1鏈�1鏃ヨ捣锛岃嚜璐垨鍒嗕韩1绗斾笖浠樻鎬婚噾棰濅笉灏忎簬 payment 鍏冿紙閫�娆句负澶辨晥 + * @param uid + * @param list 绫诲瀷 + * @return + */ + long countValidOrderTeamUserByUid(@Param("uid") Long uid, @Param("time") Long time, + @Param("payment") BigDecimal payment); + + + /** + * 鏌ヨ鐢ㄦ埛涓被鍨嬮璁″閲� + * @param uid + * @param dateType 鏃ユ湡绫诲瀷 + * @param hbType 绾㈠寘绫诲瀷 + * @return + */ + BigDecimal getRewardMoneyByDate(@Param("uid") Long uid, @Param("day")Integer dateType, + @Param("type") Integer hbType, @Param("orderState") Integer orderState, + @Param("orderNo") String orderNo, @Param("moneyState") Integer moneyState, + @Param("startTime") String startTime, @Param("endTime") String endTime,@Param("listSource") List<Integer> listSource); + + /** + * 缁熻鍚勪釜璁㈠崟绫诲瀷 鏈夋晥涓暟 + * @param orderType + * @param preDay + * @return + */ + Integer countOrderByTypeAndDate(@Param("orderType") Integer orderType, @Param("preDay") String preDay); + + } \ No newline at end of file -- Gitblit v1.8.0