From 991770ca69d356362f123d1ff6d8df1ec7046c9c Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Mon, 17 Oct 2022 11:21:42 +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