1.许可模板

tangzy

2021-09-06 097a14bada17d8b2bc776ba0d97e6c67bf1eba89

 src/main/java/org/springblade/modules/training/mapper/TrainingRegistrationMapper.java

@@ -3,6 +3,7 @@
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;

@@ -30,4 +31,33 @@
    * @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("number") Integer number,
                     @Param("serialStart")Integer serialStart,
                     @Param("serialEnd")Integer serialEnd);
}