From 63bf3eac0b63606348e40d994a54de1cd4b6d3b9 Mon Sep 17 00:00:00 2001 From: yujian <yujian@163.com> Date: 星期六, 28 三月 2020 16:44:50 +0800 Subject: [PATCH] 数据统计 + 会员 --- fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java index 27750e1..f3e4b05 100644 --- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java +++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java @@ -1,5 +1,6 @@ package com.yeshi.fanli.dao.mybatis.order; +import java.math.BigDecimal; import java.util.List; import org.apache.ibatis.annotations.Param; @@ -52,4 +53,22 @@ InviteOrderSubsidy selectByPrimaryKeyForUpdate(Long id); + + + /** + * 缁熻鐢ㄦ埛宸插埌璐﹂噾棰� + * @param uid + * @return + */ + BigDecimal sumRecievedMoneyByUid(@Param("uid") long uid, @Param("level") Integer level); + + + /** + * 缁熻鐢ㄦ埛鏈夋晥閲戦 + * @param uid + * @param day 1浠婃棩 2鏄ㄦ棩 3鏈湀 4涓婃湀 + * @return + */ + BigDecimal sumValidMoneyByUidAndDate(@Param("uid") long uid, @Param("day") Integer day, @Param("level") Integer level); + } \ No newline at end of file -- Gitblit v1.8.0