From e7920b14a9baab97035a1a529da85d124a2bcacd Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期二, 16 六月 2020 10:54:29 +0800 Subject: [PATCH] 云发单对测试用户显示 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/HongBaoV2CountMapper.java | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 51 insertions(+), 2 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 11d7b0e..8a44fad 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 @@ -140,9 +140,31 @@ * @param payment * @return */ - Long countMyDirectOrderByCashArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment); + Long countMyDirectOrderByCashArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment, + @Param("type")Integer type); + + /** + * 缁熻宸插埌璐﹁鍗曟暟閲� + * @param uid + * @param payment -浠樻閲戦 + * @param type -绫诲瀷锛� 1鑷喘 2鍒嗕韩 3閭�璇� 4鑷喘+鍒嗕韩 + * @param dateType 1鏈湀 + * @return + */ + Long countOrderByCashArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment, + @Param("type")Integer type, @Param("dateType")Integer dateType); + /** + * 缁熻鏈埌璐﹁鍗曟暟閲� + * @param uid + * @param payment -浠樻閲戦 + * @param type -绫诲瀷锛� 1鑷喘 2鍒嗕韩 3閭�璇� 4鑷喘+鍒嗕韩 + * @param dateType 1鏈湀 + * @return + */ + Long countOrderByCashNotArrival(@Param("uid") Long uid, @Param("payment") BigDecimal payment, + @Param("type")Integer type, @Param("dateType")Integer dateType); /** * 鏌ヨ鐢ㄦ埛涓被鍨嬮璁″閲� @@ -154,7 +176,8 @@ 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("startTime") String startTime, @Param("endTime") String endTime, + @Param("listSource") List<Integer> listSource); /** * 缁熻鍚勪釜璁㈠崟绫诲瀷 鏈夋晥涓暟 @@ -165,4 +188,30 @@ Long countOrderByTypeAndDate(@Param("orderType") Integer orderType, @Param("preDay") String preDay); + /** + * 缁熻杩戞棩鍒拌处鏀跺叆閲戦 + * @param uid + * @param day + * @return + */ + BigDecimal sumMoneyArrivalByUidAndNearDay(@Param("uid") Long uid, @Param("day") int day); + + + /** + * 缁熻缁撶畻閲戦 + * @param uid + * @param minDate + * @param maxDate + * @return + */ + BigDecimal sumMoneyBySettleTimeAndUid(@Param("uid") Long uid, @Param("minDate") Date minDate, @Param("maxDate") Date maxDate); + + /** + * 180鍐呮湭鏀惰揣鐨勯噾棰� + * @param uid + * @return + */ + BigDecimal sumMoneyByANotSettleAndUid(@Param("uid") Long uid); + + } \ No newline at end of file -- Gitblit v1.8.0