|
package org.springblade.modules.farmplant.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import org.apache.ibatis.annotations.Param;
|
import org.springblade.modules.farmplant.entity.FarmProductStock;
|
import org.springblade.modules.farmplant.vo.FarmProductStockVO;
|
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 农产品库存Mapper 接口
|
* @since 2022-05-18
|
* @author zhongrj
|
*/
|
public interface FarmProductStockMapper extends BaseMapper<FarmProductStock> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param farmProductStock
|
* @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);
|
|
/**
|
* 统计产量
|
* @param farmProductStock
|
* @return
|
*/
|
List<FarmProductStockVO> statisticsProduct(@Param("farmProductStock") FarmProductStockVO farmProductStock);
|
List<FarmProductStockVO> statisticsProductx(@Param("page") IPage page, @Param("farmProductStock") FarmProductStockVO farmProductStock);
|
Map<String, String> selctProductCount(String year);
|
Map<String, String> statisticsStock(@Param("year") String year,@Param("farmId") String farmId);
|
List<Map<String, String>> statisticsStockYear(@Param("year") String year,@Param("farmId") String farmId);
|
List<Map<String, String>> statisticsStockMonth(@Param("year") String year,@Param("farmId") String farmId);
|
List<Map<String, String>> statisticsStockDay(@Param("year") String year,@Param("farmId") String farmId);
|
Map<String, String> productsSupervise(@Param("year") String year,@Param("farmId") String farmId);
|
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);
|
}
|
