package com.yuanchu.mom.mapper;
|
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.yuanchu.mom.dto.PersonTrainingRecordDto;
|
import com.yuanchu.mom.dto.PersonTrainingRecordListDto;
|
import com.yuanchu.mom.dto.TrainingRecordPersonDetailedDto;
|
import com.yuanchu.mom.pojo.PersonTrainingRecord;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import org.apache.ibatis.annotations.Param;
|
|
import java.util.List;
|
|
/**
|
* <p>
|
* 培训记录 Mapper 接口
|
* </p>
|
*
|
* @author
|
* @since 2024-10-12 04:50:48
|
*/
|
public interface PersonTrainingRecordMapper extends BaseMapper<PersonTrainingRecord> {
|
|
List<PersonTrainingRecordDto> trainingAndAssessmentRecordsPage(Integer trainingDetailedId, String userName);
|
|
IPage<PersonTrainingRecordListDto> personnelTrainingPersonnel(Page page, String userName, Integer userId, Integer departLimsId);
|
|
IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetails(Page page, Integer userId);
|
|
/**
|
* 根据详情id查询培训人员
|
* @param trainingDetailedId
|
* @return
|
*/
|
List<PersonTrainingRecordDto> selectListByTrainingDetailedId(@Param("trainingDetailedId") Integer trainingDetailedId);
|
|
/**
|
* 查询人员信息
|
* @param userId
|
* @return
|
*/
|
PersonTrainingRecordListDto selectUserTraining(@Param("userId") Integer userId);
|
|
/**
|
* 根据用户id查询培训记录
|
* @param userId
|
* @return
|
*/
|
List<TrainingRecordPersonDetailedDto> selectPersonDetailedDtos(Integer userId);
|
|
/**
|
* 根据用户id和年份查询人员明细 培训记录
|
* @param page
|
* @param userId
|
* @param year
|
* @return
|
*/
|
IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetailsOfUserIdAndYear(Page page, Integer userId, Integer year);
|
|
/**
|
* 根据用户id和年份查询人员明细 培训记录导出
|
* @param userId
|
* @param trainingDate
|
* @return
|
*/
|
List<TrainingRecordPersonDetailedDto> selectPersonDetailedDtosByTrainingDate(Integer userId, Integer year);
|
}
|