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