|
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 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, Double>> statisticsYield(String year,String deptId);
|
boolean stockCompare(double sale,String id);
|
boolean stockReduce(double sale,String id);
|
}
|
