From e753d1c35c4437356ceaf376dc6c512b40f09b7f Mon Sep 17 00:00:00 2001
From: yujian <yujian@123.com>
Date: 星期四, 06 六月 2019 09:25:44 +0800
Subject: [PATCH] 精选库入库 优化
---
fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/HongBaoOrderMapper.java | 43 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 43 insertions(+), 0 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/HongBaoOrderMapper.java b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/HongBaoOrderMapper.java
index dbc599a..9b46e46 100644
--- a/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/HongBaoOrderMapper.java
+++ b/fanli/src/main/java/com/yeshi/fanli/dao/mybatis/order/HongBaoOrderMapper.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;
@@ -43,4 +44,46 @@
*/
Long countFanLiOrder(Long uid);
+ /**
+ * 鏍规嵁璁㈠崟鍙蜂笌绾㈠寘绫诲瀷璁＄畻璁㈠崟鏁伴噺
+ *
+ * @param orderNo
+ * @param type
+ * @return
+ */
+ long countByOrderNoAndHongBaoType(@Param("orderNo") String orderNo, @Param("type") int type,
+ @Param("sourceType") int sourceType);
+
+ /**
+ * 杩斿埄瓒呰繃涓�瀹氶噾棰濈殑璁㈠崟鏁伴噺
+ *
+ * @param uid
+ * @return
+ */
+ public int countHongBaoOrderCountMoreByUid(@Param("money") BigDecimal money, @Param("uid") Long uid);
+
+ /**
+ * 缁存潈璁㈠崟鏁伴噺锛堝寘鍚個璇疯禋锛�
+ *
+ * @param uid
+ * @return
+ */
+ public int countWeiQuanOrderByUid(Long uid);
+
+ /**
+ * 缁存潈璁㈠崟杩旇繕鐨勯噾棰�
+ *
+ * @param uid
+ * @return
+ */
+ public BigDecimal sumWeiQuanOrderFanAmountByUid(Long uid);
+
+ /**
+ * 瀹夊叏璁㈠崟鏁伴噺
+ *
+ * @param uid
+ * @return
+ */
+ public int countSafeOrderByUid(Long uid);
+
}
\ No newline at end of file
--
Gitblit v1.8.0