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.QualityUnqualified;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface QualityUnqualifiedMapper extends BaseMapper<QualityUnqualified> {

    IPage<QualityUnqualified> qualityUnqualifiedListPage(Page page, @Param("qualityUnqualified") QualityUnqualified qualityUnqualified);

    List<QualityUnqualified> qualityUnqualifiedExport(@Param("qualityUnqualified") QualityUnqualified qualityUnqualified);

    QualityUnqualified getUnqualified(@Param("id") Integer id);

    // 手动新增不合格时，根据产品名称和规格型号查询对应的产品型号 ID
    Long getModelId(@Param("productName") String productName, @Param("model") String model);

    // 根据生产订单和前序工序名称列表查询未解除隔离的不合格记录
    List<QualityUnqualified> selectUnqualifiedByProductOrderAndProcessNames(@Param("productOrderId") Long productOrderId,
                                                                            @Param("processNames") List<String> processNames);

    /**
     * 查询不合格记录关联的生产订单信息。
     */
    List<QualityUnqualified> selectUnqualifiedWithProductionOrder();
}