From 97da879dc16dffb2fbcc7447dee7db819049fa02 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Sat, 15 Oct 2022 11:35:16 +0800
Subject: [PATCH] 农资查询添加模糊查询
---
src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java | 15 ++++++++++++++-
1 files changed, 14 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 ec7f615..955a832 100644
--- a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
+++ b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
@@ -22,6 +22,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
+import java.util.Map;
/**
* 加工库存表 Mapper 接口
@@ -40,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);
@@ -51,4 +52,16 @@
Boolean stockReduce(@Param("saleNum") Double saleNum, @Param("proid") String proid);
Boolean del(Long id);
+
+ ProcessInvVO getLand(@Param("processInv") ProcessInv processInv);
+
+ 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