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