From a3243dabdec4b7c730002e98e9300a37f8f9930e Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Wed, 02 Nov 2022 15:17:39 +0800
Subject: [PATCH] 20221021
---
src/main/java/cc/mrbird/febs/dapp/mapper/IgtOnHookPlanOrderItemDao.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/dapp/mapper/IgtOnHookPlanOrderItemDao.java b/src/main/java/cc/mrbird/febs/dapp/mapper/IgtOnHookPlanOrderItemDao.java
index fb843a5..47ecfa8 100644
--- a/src/main/java/cc/mrbird/febs/dapp/mapper/IgtOnHookPlanOrderItemDao.java
+++ b/src/main/java/cc/mrbird/febs/dapp/mapper/IgtOnHookPlanOrderItemDao.java
@@ -5,6 +5,8 @@
import org.apache.ibatis.annotations.Param;
import java.math.BigDecimal;
+import java.util.Date;
+import java.util.List;
public interface IgtOnHookPlanOrderItemDao extends BaseMapper<IgtOnHookPlanOrderItem> {
@@ -15,4 +17,21 @@
BigDecimal selectTotalAmountByByOrderIdAndMemberIdAndState(@Param("orderId") Long orderId, @Param("memberId")Long memberId
, @Param("state")int i, @Param("isGoal")int isGoal);
+
+ IgtOnHookPlanOrderItem selectByMemberIdAndBelongNum( @Param("memberId")Long memberId, @Param("recordNum")String recordNum);
+
+ BigDecimal selectTotalProfitByMemberIdAndStateAndIsgoal(@Param("memberId")Long memberId
+ , @Param("state")int i, @Param("isGoal")int isGoal);
+
+ List<IgtOnHookPlanOrderItem> selectByIgtIdAndMemberId(@Param("orderId") Long orderId, @Param("memberId")Long memberId);
+
+ BigDecimal selectTotalAmountByCreateTimeAndOrderId(@Param("startTime")Date startTime, @Param("endTime")Date endTime, @Param("orderId")Long id);
+
+ Long selectByIsgoalAndOrderId(@Param("isGoal")int i, @Param("orderId")Long orderId);
+
+ IgtOnHookPlanOrderItem selectByCreateTimeAndIsgoaAndOrderId(@Param("id")Long id, @Param("isGoal")int i, @Param("orderId")Long orderId);
+
+ IgtOnHookPlanOrderItem selectOneByIgtIdAndMemberId(@Param("orderId") Long orderId, @Param("memberId")Long memberId);
+
+ BigDecimal selectTotalAmountByIDAndOrderId(@Param("start")Long id, @Param("end")Long id1, @Param("orderId")Long orderId);
}
--
Gitblit v1.9.1