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查看详情
|
Map<String, Object> selectRawInspectsListById(Integer id);
|
|
//清空检验结论
|
void updById(Integer rawInspectId);
|
|
|
}
|
