kuc管理

tangzy

2022-07-11 8a1b4a973e598688b9cc9e05c6f34e13c4fa9d73

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
 
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);
    Map<String, String> statisticsStockMonth(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);
}