From 0ec22dcf4fd9c4496e6f681e7fab89f56c6e4e8a Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期四, 02 四月 2020 14:45:20 +0800
Subject: [PATCH] vip 消息
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java | 23 +++++++++++++++++++++++
1 files changed, 23 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 4991fca..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;
@@ -48,4 +49,26 @@
* @return
*/
List<InviteOrderSubsidy> listByOrderNoAndType(@Param("orderNo") String orderNo, @Param("type") Integer type);
+
+
+ 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