From 62084735c1f5d6b6d4771aadf4d9241479a4d4ee Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Mon, 24 Oct 2022 15:06:16 +0800
Subject: [PATCH] 用户查询增加模糊查询；修复当编辑用户时账号解封的问题；全景管理查询未删除的数据；当性别，生日未填时数据库同时也录入数据
---
src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java | 11 ++++++++++-
1 files changed, 10 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 a172811..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);
@@ -55,4 +56,12 @@
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