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);
}