package org.dromara.qa.qm.mapper;

import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.dromara.qa.qm.domain.bo.QmMatcheckBo;
import org.dromara.qa.qm.domain.QmMatcheck;
import org.dromara.qa.qm.domain.vo.QmMatcheckVo;
import org.dromara.common.mybatis.core.mapper.BaseMapperPlus;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * 材料检验统计Mapper接口
 *
 * @author zhuguifei
 * @date 2026-04-15
 */
public interface QmMatcheckMapper extends BaseMapperPlus<QmMatcheck, QmMatcheckVo> {
    @Results(id = "qmCheckItemMap", value = {
            @Result(property = "itemCode", column = "item_code"),
            @Result(property = "itemName", column = "item_name")
    })
    @Select("SELECT b.item_code, a.item_name FROM QM_JUDGE_DETAILS a " +
            "JOIN QM_CHECKITEM b ON a.item_cod = b.id " +
            "WHERE a.judge_id = #{judgeId} AND a.rid IS NULL AND a.category IN (0)")
    List<Map<String, Object>> getQmCheckItem(@Param("judgeId") String judgeId);

    /**
     * 按批次和牌号查询材料检验统计(多表)
     *
     * @param bo 查询条件
     * @return 材料检验统计列表
     */
    List<QmMatcheckVo> listQmMatcheck(@Param("bo") QmMatcheckBo bo);
}