package cn.iocoder.yudao.module.mes.dal.mysql.safety; import cn.iocoder.yudao.framework.mybatis.core.mapper.BaseMapperX; import cn.iocoder.yudao.framework.mybatis.core.query.LambdaQueryWrapperX; import cn.iocoder.yudao.module.mes.dal.dataobject.safety.MesSafetyTrainingAttendeeDO; import org.apache.ibatis.annotations.Mapper; import java.util.List; /** * 安全生产 - 培训参训人员 Mapper * * @author 超级管理员 */ @Mapper public interface MesSafetyTrainingAttendeeMapper extends BaseMapperX { default List selectListByTrainingId(Long trainingId) { return selectList(new LambdaQueryWrapperX() .eq(MesSafetyTrainingAttendeeDO::getTrainingId, trainingId) .orderByAsc(MesSafetyTrainingAttendeeDO::getId)); } default MesSafetyTrainingAttendeeDO selectByTrainingIdAndUserId(Long trainingId, Long userId) { return selectOne(new LambdaQueryWrapperX() .eq(MesSafetyTrainingAttendeeDO::getTrainingId, trainingId) .eq(MesSafetyTrainingAttendeeDO::getUserId, userId)); } default void deleteByTrainingId(Long trainingId) { delete(new LambdaQueryWrapperX() .eq(MesSafetyTrainingAttendeeDO::getTrainingId, trainingId)); } default Long selectCountByTrainingId(Long trainingId) { return selectCount(new LambdaQueryWrapperX() .eq(MesSafetyTrainingAttendeeDO::getTrainingId, trainingId)); } default Long selectCountSignedByTrainingId(Long trainingId) { return selectCount(new LambdaQueryWrapperX() .eq(MesSafetyTrainingAttendeeDO::getTrainingId, trainingId) .in(MesSafetyTrainingAttendeeDO::getSignStatus, MesSafetyTrainingAttendeeDO.SIGN_DONE, MesSafetyTrainingAttendeeDO.SIGN_LATE)); } }