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 | 37 +++++++++++++++++++++++++++++++++++--
1 files changed, 35 insertions(+), 2 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 dacf4c2..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;
@@ -28,6 +29,21 @@
@Override
public IPage<FarmProductStockVO> selectFarmProductStockPage(IPage<FarmProductStockVO> page, FarmProductStockVO farmProductStock) {
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);
}
/**
@@ -66,8 +82,20 @@
return baseMapper.statisticsStock(year,deptId);
}
@Override
- public Map<String, String> statisticsStockMonth(String year,String deptId) {
- return baseMapper.statisticsStockMonth(year,deptId);
+ 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) {
@@ -86,4 +114,9 @@
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