package cn.iocoder.yudao.module.mes.dal.mysql.qc.patrol; import cn.iocoder.yudao.framework.common.pojo.PageResult; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.mes.controller.admin.qc.patrol.vo.MesQcPatrolPageReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.qc.patrol.MesQcPatrolDO; import org.apache.ibatis.annotations.Mapper; /** * MES 质量巡检记录 Mapper * * @author 超级管理员 */ @Mapper public interface MesQcPatrolMapper extends BaseMapperX { default PageResult selectPage(MesQcPatrolPageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(MesQcPatrolDO::getCode, reqVO.getCode()) .likeIfPresent(MesQcPatrolDO::getName, reqVO.getName()) .eqIfPresent(MesQcPatrolDO::getItemId, reqVO.getItemId()) .likeIfPresent(MesQcPatrolDO::getReelNo, reqVO.getReelNo()) .likeIfPresent(MesQcPatrolDO::getBatchCode, reqVO.getBatchCode()) .eqIfPresent(MesQcPatrolDO::getInspectorUserId, reqVO.getInspectorUserId()) .betweenIfPresent(MesQcPatrolDO::getInspectDate, reqVO.getInspectDate()) .orderByDesc(MesQcPatrolDO::getId)); } default MesQcPatrolDO selectByCode(String code) { return selectOne(MesQcPatrolDO::getCode, code); } }