大屏溯源统计次数sql修改

guoshilong

2022-11-08 72b971c98c46531064d74b68fc8fe8864ed0b544

 src/main/java/org/springblade/modules/farm/controller/FarmingRecordController.java

@@ -29,6 +29,8 @@
import org.springblade.modules.farm.entity.FarmingRecord;
import org.springblade.modules.farm.service.FarmingRecordService;
import org.springblade.modules.farm.vo.FarmingRecordVO;
import org.springblade.modules.farmplant.entity.Strain;
import org.springblade.modules.farmplant.service.StrainService;
import org.springblade.modules.soldr.entity.Soldr;
import org.springblade.modules.soldr.service.ISoldrService;
import org.springblade.modules.soldrecord.service.ISoldrecordService;
@@ -58,7 +60,7 @@
   private final ISoldrService soldrService;
   private final ISoldrecordService soldrecordService;
   private final IStockfactoryService stockfactoryService;

   private final StrainService strainService;
   /**
    * 详情
    */
@@ -68,6 +70,16 @@
   public R<FarmingRecord> detail(FarmingRecord farm) {
      FarmingRecord detail = farmService.getOne(Condition.getQueryWrapper(farm));
      return R.data(detail);
   }

   /**
    * 获取农事记录详情带中文
    * @param farmingRecordVO
    * @return
    */
   @GetMapping("/details")
   public R details(FarmingRecordVO farmingRecordVO){
      return R.data(farmService.getDetails(farmingRecordVO));
   }

   /**
@@ -89,6 +101,14 @@
   @ApiOperation(value = "分页", notes = "传入farm")
   public R<IPage<FarmingRecordVO>> page(FarmingRecordVO farm, Query query) {
      IPage<FarmingRecordVO> pages = farmService.selectFarmingRecordPage(Condition.getPage(query), farm);
      return R.data(pages);
   }

   @GetMapping("/pageNz")
   @ApiOperationSupport(order = 3)
   @ApiOperation(value = "分页", notes = "传入farm")
   public R<IPage<FarmingRecordVO>> pageNz(FarmingRecordVO farm, Query query) {
      IPage<FarmingRecordVO> pages = farmService.selectFarmingRecordPageByNz(Condition.getPage(query), farm);
      return R.data(pages);
   }

@@ -159,13 +179,16 @@
         stockfactory.setId(ids);
         Stockfactory detailstock = stockfactoryService.getOne(Condition.getQueryWrapper(stockfactory));
         String agriculturalName = detailstock.getAgriculturalName();
         String content = agriculturalName + "   " + v + "公斤";
         Strain strain = strainService.getById(farm.getStrainId());
         String content =strain.getStrainName()+"-"+ agriculturalName + "   " + v + "公斤";
         farm.setContent(content);
         //使用农资数量等于已出农资数量
         if (farm.getSnum() == detail.getAmount1()) {
            soldrService.dels(id);
         } else {
            soldrecordService.updateSold(amount1 - farm.getSnum(), id, detail.getCensus() - v);
            detail.setAmount1(detail.getAmount1()-farm.getSnum());
            soldrService.updateById(detail);
         }
      }
      return R.status(farmService.save(farm));