package com.ruoyi.quality.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.ruoyi.quality.pojo.QualityInspect;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import com.ruoyi.quality.dto.QualityInspectStatDto;
|
import com.ruoyi.quality.dto.QualityPassRateDto;
|
import com.ruoyi.quality.dto.QualityMonthlyPassRateDto;
|
import com.ruoyi.quality.dto.QualityMonthlyDetailDto;
|
import com.ruoyi.quality.dto.QualityParameterStatDto;
|
|
import java.util.List;
|
|
@Mapper
|
public interface QualityInspectMapper extends BaseMapper<QualityInspect> {
|
|
|
IPage<QualityInspect> qualityInspectListPage(Page page, @Param("qualityInspect") QualityInspect qualityInspect);
|
|
List<QualityInspect> qualityInspectExport(@Param("qualityInspect") QualityInspect qualityInspect);
|
|
/**
|
* 根据生产主表ID批量删除过程检验
|
*/
|
int deleteByProductMainIds(@Param("productMainIds") List<Long> productMainIds);
|
|
/**
|
* 获取检验统计数据
|
*/
|
List<QualityInspectStatDto> getInspectStatistics();
|
|
/**
|
* 获取合格率统计数据
|
*/
|
List<QualityPassRateDto> getPassRateStatistics();
|
|
/**
|
* 获取月度合格率统计数据
|
*/
|
List<QualityMonthlyPassRateDto> getMonthlyPassRateStatistics(@Param("year") String year);
|
|
/**
|
* 获取年度合格率统计数据
|
*/
|
List<QualityPassRateDto> getYearlyPassRateStatistics(@Param("year") String year);
|
|
/**
|
* 获取月度完成明细数据
|
*/
|
List<QualityMonthlyDetailDto> getMonthlyCompletionDetails(@Param("year") String year);
|
|
/**
|
* 获取热点检测指标 Top 4 + 其他
|
*/
|
List<QualityParameterStatDto> getTopParameters(@Param("inspectType") Integer inspectType);
|
}
|
