package cn.iocoder.yudao.module.mes.dal.mysql.safety; 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.safety.vo.training.MesSafetyTrainingPageReqVO; import cn.iocoder.yudao.module.mes.dal.dataobject.safety.MesSafetyTrainingDO; import org.apache.ibatis.annotations.Mapper; import java.util.List; /** * 安全生产 - 培训批次 Mapper * * @author 超级管理员 */ @Mapper public interface MesSafetyTrainingMapper extends BaseMapperX { default PageResult selectPage(MesSafetyTrainingPageReqVO reqVO) { return selectPage(reqVO, new LambdaQueryWrapperX() .likeIfPresent(MesSafetyTrainingDO::getCode, reqVO.getCode()) .likeIfPresent(MesSafetyTrainingDO::getTitle, reqVO.getTitle()) .eqIfPresent(MesSafetyTrainingDO::getTrainingType, reqVO.getTrainingType()) .eqIfPresent(MesSafetyTrainingDO::getTrainingLevel, reqVO.getTrainingLevel()) .eqIfPresent(MesSafetyTrainingDO::getStatus, reqVO.getStatus()) .geIfPresent(MesSafetyTrainingDO::getStartTime, reqVO.getStartTimeStart()) .leIfPresent(MesSafetyTrainingDO::getStartTime, reqVO.getStartTimeEnd()) .orderByDesc(MesSafetyTrainingDO::getId)); } default MesSafetyTrainingDO selectByCode(String code) { return selectOne(MesSafetyTrainingDO::getCode, code); } default Long selectCountByStatus(Integer status) { return selectCount(new LambdaQueryWrapperX() .eq(MesSafetyTrainingDO::getStatus, status)); } default List selectAllList() { return selectList(new LambdaQueryWrapperX() .orderByDesc(MesSafetyTrainingDO::getId)); } }