package com.yuanchu.mom.mapper;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.yuanchu.mom.pojo.RawInspect;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import java.time.LocalDate;
import java.util.List;
import java.util.Map;

/**
* @author Administrator
* @description 针对表【raw_inspect(原材料申请表)】的数据库操作Mapper
* @createDate 2023-07-31 14:43:15
* @Entity com.yuanchu.mom.pojo.RawInspect
*/
public interface RawInspectMapper extends BaseMapper<RawInspect> {

    //计算原材料在某个范围内的合格或不合格数量
    Integer selCountRaw(String begin, String end,Integer judgeState);

    //计算月总产量
    Long seAllCount(String begin, String end);

    //分页查询原材料检验单列表
    IPage<Map<String, Object>> selectRawInspectsList(Page<Object> page, String formTime, String code, Integer insState, String name);

    //根据原材料检验单id查看详情
    List<Map<String, Object>> selectRawInspectsListById(Integer id);
}