package org.springblade.modules.training.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.apply.excel.ApplyInfoExcel;
import org.springblade.modules.training.entity.TrainingRegistration;
import org.springblade.modules.training.vo.TrainingRegistrationVo;

import java.util.List;

/**
 * 报名培训Mapper 接口
 * @author zhongrj
 */
public interface TrainingRegistrationMapper extends BaseMapper<TrainingRegistration> {



	/**
	 * 自定义分页
	 *
	 * @param page   分页
	 * @param recruitment 实体
	 * @return
	 */
	List<TrainingRegistrationVo> selectTrainingRegistrationPage(IPage page, @Param("trainingRegistration") TrainingRegistrationVo recruitment);

	/**
	 * 详情
	 * @param trainingRegistration 报名培训信息对象
	 */
	TrainingRegistrationVo selectTrainingRegistrationInfo(@Param("trainingRegistration") TrainingRegistration trainingRegistration);

	/**
	 * 导出报名数数据
	 * @param trainingRegistration 培训报名对象
	 * @return
	 */
    List<ApplyInfoExcel> getTrainingRegistrationExcelList(@Param("trainingRegistration")TrainingRegistrationVo trainingRegistration);

	/**
	 * 查询准考证前缀相同的数量
	 * @param result
	 * @return
	 */
    int getCandidateNoCount(@Param("result")String result);

	/**
	 * 查询培训报名信息
	 * @param trainingRegistration 培训报名对象信息
	 * @return
	 */
    Integer getTrainingRegistrationInfo(@Param("trainingRegistration")TrainingRegistration trainingRegistration);

	/**
	 * 查询已报名培训公司未关联考试的人员
	 * @return
	 */
    List<Long> getTrainIds(@Param("trainingRegistration") TrainingRegistrationVo trainingRegistration);
}