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/process/service/IProcessService.java |   22 ++++++++++++++++++++++
 1 files changed, 22 insertions(+), 0 deletions(-)

diff --git a/src/main/java/org/springblade/modules/process/service/IProcessService.java b/src/main/java/org/springblade/modules/process/service/IProcessService.java
index 51eed46..97a8820 100644
--- a/src/main/java/org/springblade/modules/process/service/IProcessService.java
+++ b/src/main/java/org/springblade/modules/process/service/IProcessService.java
@@ -21,6 +21,9 @@
 import org.springblade.core.mp.base.BaseService;
 import com.baomidou.mybatisplus.core.metadata.IPage;
 
+import java.util.List;
+import java.util.Map;
+
 /**
  * 加工记录表 服务类
  *
@@ -38,4 +41,23 @@
 	 */
 	IPage<ProcessVO> selectProcessPage(IPage<ProcessVO> page, ProcessVO process);
 
+	/**
+	 * 库存对比
+	 * @param saleNum 销售数量
+	 * @param proid 加工表主键
+	 * @return
+	 */
+	boolean stockCompare(Double saleNum, String proid);
+
+	/**
+	 * 对应库存减少
+	 * @param saleNum 销售数量
+	 * @param proid 加工表主键
+	 * @return
+	 */
+	Boolean stockReduce(Double saleNum, String proid);
+
+    Double statistics(String year, String farmId);
+
+	List<Map<String, String>> statisticsMonth(String year, String farmId);
 }

--
Gitblit v1.9.3