From b3da9f82b7740d39742fef1a81a56c22fe1c8b9c Mon Sep 17 00:00:00 2001
From: yujian <yujian@163.com>
Date: 星期一, 08 六月 2020 17:27:02 +0800
Subject: [PATCH] 券后价调整
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java | 99 +++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 82 insertions(+), 17 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 29ccc7e..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,18 +1,83 @@
-package com.yeshi.fanli.dao.mybatis.order;
-
-import org.apache.ibatis.annotations.Param;
-
-import com.yeshi.fanli.dao.BaseMapper;
-import com.yeshi.fanli.entity.order.InviteOrderSubsidy;
-
-public interface InviteOrderSubsidyMapper extends BaseMapper<InviteOrderSubsidy> {
-
- /**
- * 鏌ヨ鐢ㄦ埛琛ヨ创
- * @param uid
- * @param orderNo
- * @param Type
- * @return
- */
- InviteOrderSubsidy getByOrderNoAndType(@Param("uid")Long uid, @Param("orderNo")String orderNo,@Param("type") Integer type);
+package com.yeshi.fanli.dao.mybatis.order;
+
+import java.math.BigDecimal;
+import java.util.List;
+
+import org.apache.ibatis.annotations.Param;
+
+import com.yeshi.fanli.dao.BaseMapper;
+import com.yeshi.fanli.entity.order.InviteOrderSubsidy;
+
+public interface InviteOrderSubsidyMapper extends BaseMapper<InviteOrderSubsidy> {
+
+ /**
+ * 鏌ヨ鐢ㄦ埛琛ヨ创
+ *
+ * @param uid
+ * @param orderNo
+ * @param Type
+ * @return
+ */
+ InviteOrderSubsidy getByOrderNoAndType(@Param("uid") Long uid, @Param("orderNo") String orderNo,
+ @Param("type") Integer type);
+
+ /**
+ * 鏌ヨ鍔犻攣
+ *
+ * @param uid
+ * @param orderNo
+ * @param type
+ * @return
+ */
+ InviteOrderSubsidy getByOrderNoAndTypeForUpdate(@Param("uid") Long uid, @Param("orderNo") String orderNo,
+ @Param("type") Integer type);
+
+ /**
+ * 鏍规嵁璁㈠崟鍙蜂笌鏉ユ簮绫诲瀷鏌ヨ
+ *
+ * @param orderNo
+ * @param type
+ * @return
+ */
+ long countByOrderNoAndType(@Param("orderNo") String orderNo, @Param("type") Integer type);
+
+ /**
+ * 鏍规嵁璁㈠崟鍙蜂笌鏉ユ簮绫诲瀷鏌ヨ
+ *
+ * @param orderNo
+ * @param type
+ * @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