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 | 6 ++++++
1 files changed, 6 insertions(+), 0 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 7b2049f..955a832 100644
--- a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
+++ b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
@@ -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