From 72b971c98c46531064d74b68fc8fe8864ed0b544 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Tue, 08 Nov 2022 09:04:56 +0800
Subject: [PATCH] 大屏溯源统计次数sql修改

---
 src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java |    8 +++++++-
 1 files changed, 7 insertions(+), 1 deletions(-)

diff --git a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
index c19f03b..955a832 100644
--- a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
+++ b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
@@ -41,7 +41,7 @@
 	 */
 	List<ProcessInvVO> selectProcessInvPage(IPage page, @Param("processInv") ProcessInvVO processInv);
 
-	ProcessInv selectBySPId(@Param("strainId") Long strainId, @Param("productId") Long productId);
+	ProcessInv selectBySPId(@Param("strainId") Long strainId, @Param("productId") Long productId,@Param("fpsId") Long fpsId);
 
 	ProcessInv selectBySFId(@Param("strainId")Long strainId, @Param("fpsId")String fpsId);
 
@@ -58,4 +58,10 @@
 	ProcessInv findById(@Param("prodId") String prodId);
 
     Double statisticsStock(@Param("year") String year, @Param("farmId") String farmId);
+
+    ProcessInv selectByFarmIdProductId(@Param("productId") Long productId,@Param("farmId") String farmId);
+
+	ProcessInv selectByProcessIdLandId(@Param("processId") String processId, @Param("landId") String landId);
+
+	boolean stockAdd(@Param("saleNum") Double saleNum, @Param("proid") String proid);
 }

--
Gitblit v1.9.3