大屏溯源统计次数sql修改

guoshilong

2022-11-08 72b971c98c46531064d74b68fc8fe8864ed0b544

 src/main/java/org/springblade/modules/farmplant/mapper/FarmProductStockMapper.java

@@ -25,7 +25,17 @@
    * @return
    */
   List<FarmProductStockVO> selectFarmProductStockPage(@Param("page") IPage page, @Param("farmProductStock") FarmProductStockVO farmProductStock);

   /**
    * 农资库存整合
    * @param page
    * @param farmProductStock
    * @return
    */
   IPage<FarmProductStockVO> selectFarmProductStockPageCount(IPage<Object> page, FarmProductStockVO farmProductStock);
   List<FarmProductStockVO> selectFarmProductStockPages(@Param("farmProductStock") FarmProductStockVO farmProductStock);

   List<FarmProductStock> findFarmProductStockByFarmIdAndStrainId(@Param("farmId") String farmId, @Param("strainId") Integer strainId);

   /**
    * 统计产量
@@ -43,4 +53,12 @@
   List<Map<String, Double>> statisticsYield(String year,String deptId);
   boolean stockCompare(double sale,String id);
   boolean stockReduce(double sale,String id);

   /**
    * 查找对应数据
    * @param strainId 品种id
    * @param landId 地块id
    * @return
    */
   FarmProductStock selectBy2Id(@Param("strainId") String strainId, @Param("landId") String landId);
}