From 28cf328a098334b51a3e9d2d56f983fb8c862211 Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期六, 23 五月 2020 09:54:38 +0800
Subject: [PATCH] 足迹、收藏订单兼容新需求

---
 fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java |   32 ++++++++++++++++++++++++++++++--
 1 files changed, 30 insertions(+), 2 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..0d43286 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,8 +49,35 @@
 	 * @return
 	 */
 	List<InviteOrderSubsidy> listByOrderNoAndType(@Param("orderNo") String orderNo, @Param("type") Integer type);
-	
+
+	List<InviteOrderSubsidy> listByOrderNoAndTypeAndUid(@Param("orderNo") String orderNo, @Param("type") Integer type,
+			@Param("uid")	Long uid);
 
 	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);
+
+	/**
+	 * 缁熻鐢ㄦ埛鏈夋晥閲戦
+	 * @param uid
+	 * @param day 1浠婃棩 2鏄ㄦ棩 3鏈湀  4涓婃湀
+	 * @return
+	 */
+	BigDecimal sumMoneyByUidAndDateAndState(@Param("uid") long uid, @Param("day") Integer day,
+			@Param("level") Integer level, @Param("state") Integer state);
+
 }
\ No newline at end of file

--
Gitblit v1.8.0