大屏溯源统计次数sql修改

guoshilong

2022-11-08 72b971c98c46531064d74b68fc8fe8864ed0b544

 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);
   }
}