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/soldr/service/ISoldrService.java |   25 +++++++++++++++++++++++--
 1 files changed, 23 insertions(+), 2 deletions(-)

diff --git a/src/main/java/org/springblade/modules/soldr/service/ISoldrService.java b/src/main/java/org/springblade/modules/soldr/service/ISoldrService.java
index 9e8db02..748eea3 100644
--- a/src/main/java/org/springblade/modules/soldr/service/ISoldrService.java
+++ b/src/main/java/org/springblade/modules/soldr/service/ISoldrService.java
@@ -43,6 +43,27 @@
 	IPage<SoldrVO> selectLists(IPage<SoldrVO> page, SoldrVO soldr);
 	void  del(Long id);
 	void  dels(Long id);
-	List<SoldrVO> selectSol();
-	List<Map<String, Object>> selectCz(Long sid);
+	List<SoldrVO> selectSol(String farmId);
+	List<Map<String, Object>> selectCz(Long sid,String deptId);
+
+	/**
+	 * 根据stockId、amount1、specs1、specs_val1、specs_val2、sid          找到soldr表中对应的数据
+	 * @param stockId1	种类id
+	 * @param specs1	规格
+	 * @param specsVal1	规格值（0：克 1：斤 2：公斤 3：吨 4：毫升 5：升 ）
+	 * @param specsVal2	规格值2( 0:袋 1：包 2：瓶 3：盒 4：箱 5：桶 6:支)
+	 * @param sid	农资库存表主键
+	 * @param type	出库类型
+	 */
+	Soldr getByServalParam(String stockId1, String specs1, Integer specsVal1, Integer specsVal2, Long sid,String type);
+
+	/**
+	 * 撤销逻辑删除 使is_deleted从1变0
+	 * @param id
+	 */
+	void cancelDel(Long id);
+
+    SoldrVO getSoldrInfo(SoldrVO soldr);
+
+	Boolean delLogic(Long id);
 }

--
Gitblit v1.9.3