From 30d8e227e8d823b6c38c3b9c90ac2df03b63befe Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 25 二月 2025 16:41:22 +0800
Subject: [PATCH] 淘宝转链接口更新
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/InviteOrderSubsidyMapper.java | 67 +++++++++++++++++++++++++++++++++
1 files changed, 66 insertions(+), 1 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..4ca6f06 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,8 @@
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;
@@ -9,10 +12,72 @@
/**
* 鏌ヨ鐢ㄦ埛琛ヨ创
+ *
* @param uid
* @param orderNo
* @param Type
* @return
*/
- InviteOrderSubsidy getByOrderNoAndType(@Param("uid")Long uid, @Param("orderNo")String orderNo,@Param("type") Integer type);
+ 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