大屏溯源统计次数sql修改

guoshilong

2022-11-08 72b971c98c46531064d74b68fc8fe8864ed0b544

 src/main/java/org/springblade/modules/farm/service/impl/FarmRecordServiceImpl.java

@@ -1,11 +1,18 @@
package org.springblade.modules.farm.service.impl;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import org.springblade.modules.farm.entity.FarmingRecord;
import org.springblade.modules.farm.mapper.FarmingRecordMapper;
import org.springblade.modules.farm.service.FarmingRecordService;
import org.springblade.modules.farm.vo.FarmingRecordVO;
import org.springblade.modules.recovery.vo.RecoveryVO;
import org.springblade.modules.system.entity.DictBiz;
import org.springblade.modules.system.service.IDictBizService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * 农事记录服务实现类
@@ -15,6 +22,9 @@
@Service
public class FarmRecordServiceImpl extends ServiceImpl<FarmingRecordMapper, FarmingRecord> implements FarmingRecordService {

   @Autowired
   private IDictBizService dictBizService;

   /**
    * 自定义分页
    * @param page
@@ -23,7 +33,50 @@
    */
   @Override
   public IPage<FarmingRecordVO> selectFarmingRecordPage(IPage<FarmingRecordVO> page, FarmingRecordVO farm) {
      return page.setRecords(baseMapper.selectFarmingRecordPage(page, farm));
      List<FarmingRecordVO> recordVOS = baseMapper.selectFarmingRecordPage(page, farm);
      recordVOS.forEach(recordVO->{
         //查询字典对应的名称
         DictBiz dictBiz = new DictBiz();
         dictBiz.setTenantId(farm.getTenantId());
         dictBiz.setCode("farmingType");
         dictBiz.setDictKey(recordVO.getType());
         DictBiz one = dictBizService.getOne(new QueryWrapper<>(dictBiz));
         //设置名称
         recordVO.setTypeName(one.getDictValue());
      });
      return page.setRecords(recordVOS);
   }

   @Override
   public IPage<FarmingRecordVO> selectFarmingRecordPageByNz(IPage<FarmingRecordVO> page, FarmingRecordVO farm) {
      List<FarmingRecordVO> recordVOS = baseMapper.selectFarmingRecordPageByNz(page, farm);
      recordVOS.forEach(recordVO->{
         //查询字典对应的名称
         DictBiz dictBiz = new DictBiz();
         dictBiz.setTenantId(farm.getTenantId());
         dictBiz.setCode("farmingType");
         dictBiz.setDictKey(recordVO.getType());
         DictBiz one = dictBizService.getOne(new QueryWrapper<>(dictBiz));
         //设置名称
         recordVO.setTypeName(one.getDictValue());
      });
      return page.setRecords(recordVOS);
   }

   @Override
   public List<FarmingRecordVO> selectFarmingRecordPages(FarmingRecordVO farm) {
      List<FarmingRecordVO> farmingRecordVOS = baseMapper.selectFarmingRecordPages(farm);
      farmingRecordVOS.forEach(recordVO->{
         //查询字典对应的名称
         DictBiz dictBiz = new DictBiz();
         dictBiz.setTenantId(recordVO.getTenantId());
         dictBiz.setCode("farmingType");
         dictBiz.setDictKey(recordVO.getType());
         DictBiz one = dictBizService.getOne(new QueryWrapper<>(dictBiz));
         //设置名称
         recordVO.setTypeName(one.getDictValue());
      });
      return farmingRecordVOS;
   }


@@ -32,8 +85,8 @@
    * @return
    */
   @Override
   public Object getFarmingCount() {
      return baseMapper.getFarmingCount();
   public Object getFarmingCount(String farmId) {
      return baseMapper.getFarmingCount(farmId);
   }

   /**
@@ -41,7 +94,47 @@
    * @return
    */
   @Override
   public Object getFarmingStatis() {
      return baseMapper.getFarmingStatis();
   public Object getFarmingStatis(String farmId) {
      return baseMapper.getFarmingStatis(farmId);
   }

   @Override
   public Double selectJyCount(String deptId) {
      return baseMapper.selectJyCount(deptId);
   }

   @Override
   public Double selectQyCount(String deptId) {
      return baseMapper.selectQyCount(deptId);
   }

   @Override
   public Double selectByCount(String deptId) {
      return baseMapper.selectByCount(deptId);
   }

   /**
    * 查询农事记录信息(种植开始起)
    * @param recoveryVO 采收信息
    * @return
    */
   @Override
   public List<FarmingRecordVO> getFarmingRecordByFarmPlantId(RecoveryVO recoveryVO) {
      return baseMapper.getFarmingRecordByFarmPlantId(recoveryVO);
   }

   /**
    * 查询农事操作记录（不分页）
    * @param farm
    * @return
    */
   @Override
   public List<FarmingRecordVO> getFarmingRecordListfarm(FarmingRecordVO farm) {
      return baseMapper.getFarmingRecordListfarm(farm);
   }

   @Override
   public FarmingRecordVO getDetails(FarmingRecordVO farmingRecordVO) {
      return baseMapper.getDetails(farmingRecordVO);
   }
}