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/farmplant/service/impl/FarmProductStockServiceImpl.java | 65 ++++++++++++++++++++++++++++++++
1 files changed, 65 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java b/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java
index 6a4058f..065f6b5 100644
--- a/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java
+++ b/src/main/java/org/springblade/modules/farmplant/service/impl/FarmProductStockServiceImpl.java
@@ -1,6 +1,7 @@
package org.springblade.modules.farmplant.service.impl;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
+import org.springblade.core.mp.support.Condition;
import org.springblade.modules.farmplant.entity.FarmProductStock;
import org.springblade.modules.farmplant.mapper.FarmProductStockMapper;
import org.springblade.modules.farmplant.service.FarmProductStockService;
@@ -30,6 +31,21 @@
return page.setRecords(baseMapper.selectFarmProductStockPage(page, farmProductStock));
}
+ @Override
+ public IPage<FarmProductStockVO> selectFarmProductStockPagesCount(IPage<Object> page, FarmProductStockVO farmProductStock) {
+ return baseMapper.selectFarmProductStockPageCount(page,farmProductStock);
+ }
+
+ @Override
+ public List<FarmProductStockVO> selectFarmProductStockPages(FarmProductStockVO farmProductStock) {
+ return baseMapper.selectFarmProductStockPages(farmProductStock);
+ }
+
+ @Override
+ public List<FarmProductStock> findFarmProductStockByFarmIdAndStrainId(String farmId, Integer strainId) {
+ return baseMapper.findFarmProductStockByFarmIdAndStrainId(farmId,strainId);
+ }
+
/**
* 统计产量
* @param farmProductStock
@@ -51,7 +67,56 @@
}
@Override
+ public IPage<FarmProductStockVO> statisticsProductx(IPage<FarmProductStockVO> page, FarmProductStockVO farmProductStock) {
+ return page.setRecords(baseMapper.statisticsProductx(page, farmProductStock));
+ }
+
+
+ @Override
public Map<String, String> selctProductCount(String year) {
return baseMapper.selctProductCount(year);
}
+
+ @Override
+ public Map<String, String> statisticsStock(String year,String deptId) {
+ return baseMapper.statisticsStock(year,deptId);
+ }
+ @Override
+ public List<Map<String, String>> statisticsStockMonth(String year,String farmId) {
+ //按年统计
+ if (year.length()==4){
+ return baseMapper.statisticsStockYear(year,farmId);
+ }
+ //按月统计
+ if (year.length()==7){
+ return baseMapper.statisticsStockMonth(year,farmId);
+ }
+ //按日统计
+ if (year.length()==10){
+ return baseMapper.statisticsStockDay(year,farmId);
+ }
+ return null;
+ }
+ @Override
+ public Map<String, String> productsSupervise(String year,String deptId) {
+ return baseMapper.productsSupervise(year,deptId);
+ }
+ @Override
+ public List<Map<String, Double>> statisticsYield(String year,String deptId) {
+ return baseMapper.statisticsYield(year,deptId);
+ }
+
+ @Override
+ public boolean stockCompare(double sale,String id) {
+ return baseMapper.stockCompare(sale,id);
+ }
+ @Override
+ public boolean stockReduce(double sale,String id) {
+ return baseMapper.stockReduce(sale,id);
+ }
+
+ @Override
+ public FarmProductStock selectBy2Id(String strainId, String landId) {
+ return baseMapper.selectBy2Id(strainId,landId);
+ }
}
--
Gitblit v1.9.3