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);
	List<FarmProductStockVO> selectFarmProductStockPages(@Param("farmProductStock") FarmProductStockVO farmProductStock);

	/**
	 * 统计产量
	 * @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(String year,String deptId);
	List<Map<String, String>> statisticsStockYear(String year,String deptId);
	List<Map<String, String>> statisticsStockMonth(String year,String deptId);
	List<Map<String, String>> statisticsStockDay(String year,String deptId);
	Map<String, String> productsSupervise(String year,String deptId);
	List<Map<String, Double>> statisticsYield(String year,String deptId);
	boolean stockCompare(double sale,String id);
	boolean stockReduce(double sale,String id);
}