Merge branch 'dev_cr' into dev
| | |
| | | } |
| | | |
| | | @ApiOperation(value = "导出沟通记录") |
| | | @PostMapping("exportPersonCommunicationAbility") |
| | | @GetMapping("exportPersonCommunicationAbility") |
| | | public void exportPersonCommunicationAbility(Integer id, HttpServletResponse response) throws Exception{ |
| | | personCommunicationAbilityService.exportPersonCommunicationAbility(id,response); |
| | | } |
| | |
| | | |
| | | @ApiOperation(value = "查询 岗位职责") |
| | | @GetMapping("/personJobResponsibilitiesSelect") |
| | | public Result<IPage<PersonJobResponsibilitiesDto>> personJobResponsibilitiesSelect(Page page, String userId, String departmentId, String userName) { |
| | | public Result personJobResponsibilitiesSelect(Page page, String userId, String departmentId, String userName) { |
| | | IPage<PersonJobResponsibilitiesDto> iPage = personJobResponsibilitiesService.personJobResponsibilitiesSelect(page, userId, departmentId, userName); |
| | | return Result.success(iPage); |
| | | } |
| | |
| | | } |
| | | |
| | | @ApiOperation(value = "导出岗位职业资格证书") |
| | | @PostMapping("/exportPersonPostAuthorizationRecord") |
| | | @GetMapping("/exportPersonPostAuthorizationRecord") |
| | | public void exportPersonPostAuthorizationRecord(Integer id, HttpServletResponse response){ |
| | | personPostAuthorizationRecordService.exportPersonPostAuthorizationRecord(id,response); |
| | | } |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ruoyi.personnel.dto.PersonJobResponsibilitiesDto; |
| | | import com.ruoyi.personnel.pojo.PersonJobResponsibilities; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | */ |
| | | public interface PersonJobResponsibilitiesMapper extends BaseMapper<PersonJobResponsibilities> { |
| | | |
| | | IPage<PersonJobResponsibilitiesDto> personJobResponsibilitiesSelect(Page page, String userId, String departmentId, String userName); |
| | | IPage<PersonJobResponsibilitiesDto> personJobResponsibilitiesSelect(Page page, @Param("userId") String userId, @Param("departmentId") String departmentId, @Param("userName") String userName); |
| | | } |
| | |
| | | */ |
| | | public interface PersonPersonnelCapacityMapper extends BaseMapper<PersonPersonnelCapacity> { |
| | | |
| | | IPage<PersonPersonnelCapacityDto> personPersonnelCapacityPage(Page page, Integer departLimsId, Integer userId, String userName); |
| | | IPage<PersonPersonnelCapacityDto> personPersonnelCapacityPage(Page page, @Param("departLimsId") Integer departLimsId,@Param("userId") Integer userId,@Param("userName") String userName); |
| | | |
| | | /** |
| | | * 查询人员能力接口 |
| | |
| | | import com.baomidou.mybatisplus.extension.plugins.pagination.Page; |
| | | import com.ruoyi.personnel.dto.PersonPostAuthorizationRecordDto; |
| | | import com.ruoyi.personnel.pojo.PersonPostAuthorizationRecord; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | /** |
| | | * <p> |
| | |
| | | */ |
| | | public interface PersonPostAuthorizationRecordMapper extends BaseMapper<PersonPostAuthorizationRecord> { |
| | | |
| | | IPage<PersonPostAuthorizationRecordDto> personPostAuthorizationRecordPage(Page page, Integer departLimsId, Integer userId, String userName); |
| | | IPage<PersonPostAuthorizationRecordDto> personPostAuthorizationRecordPage(Page page, @Param("departLimsId") Integer departLimsId, @Param("userId") Integer userId, @Param("userName") String userName); |
| | | } |
| | |
| | | import com.ruoyi.personnel.dto.PersonRewardPunishmentRecordDto; |
| | | import com.ruoyi.personnel.excel.PersonRewardPunishmentRecordExcel; |
| | | import com.ruoyi.personnel.pojo.PersonRewardPunishmentRecord; |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | |
| | | */ |
| | | public interface PersonRewardPunishmentRecordMapper extends BaseMapper<PersonRewardPunishmentRecord> { |
| | | |
| | | IPage<PersonRewardPunishmentRecordDto> rewardPunishmentPage(Page page, Integer userId, String userName, Date startTime, Date endTime, Integer departmentId); |
| | | IPage<PersonRewardPunishmentRecordDto> rewardPunishmentPage(Page page, @Param("userId") Integer userId, @Param("userName") String userName,@Param("startTime") Date startTime, @Param("endTime") Date endTime,@Param("departmentId") Integer departmentId); |
| | | |
| | | List<PersonRewardPunishmentRecordExcel> rewardPunishmentExport(Integer userId, Integer departmentId, String userName, Date startTime, Date endTime); |
| | | List<PersonRewardPunishmentRecordExcel> rewardPunishmentExport(@Param("userId") Integer userId, @Param("departmentId") Integer departmentId, @Param("userName") String userName, @Param("startTime") Date startTime, @Param("endTime") Date endTime); |
| | | } |
| | |
| | | |
| | | List<PersonTrainingRecordDto> trainingAndAssessmentRecordsPage(@Param("trainingDetailedId") Integer trainingDetailedId,@Param("userName") String userName); |
| | | |
| | | IPage<PersonTrainingRecordListDto> personnelTrainingPersonnel(Page page, String userName, Integer userId, Integer departLimsId); |
| | | IPage<PersonTrainingRecordListDto> personnelTrainingPersonnel(Page page, @Param("userName") String userName, @Param("userId") Integer userId,@Param("departLimsId") Integer departLimsId); |
| | | |
| | | IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetails(Page page, Integer userId); |
| | | |
| | |
| | | * @param year |
| | | * @return |
| | | */ |
| | | IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetailsOfUserIdAndYear(Page page, Integer userId, Integer year); |
| | | IPage<TrainingRecordPersonDetailedDto> queryPersonnelDetailsOfUserIdAndYear(Page page, @Param("userId") Integer userId, @Param("year") Integer year); |
| | | |
| | | /** |
| | | * 根据用户id和年份查询人员明细 培训记录导出 |
| | |
| | | -- 取岗位 |
| | | left join cnas_person_basic_info cpbi on cpbi.user_id = cppc.user_id |
| | | -- 取人员能力的岗位职责 |
| | | left join (SELECT GROUP_CONCAT(e.label) responsibilities, cppc.id |
| | | left join (SELECT GROUP_CONCAT(e.dict_label) responsibilities, cppc.id |
| | | from cnas_person_personnel_capacity cppc |
| | | left join enums e on FIND_IN_SET(e.value, cppc.job_responsibilities) |
| | | where e.category = '岗位职责' |
| | | left join sys_dict_data e on FIND_IN_SET(e.dict_value, cppc.job_responsibilities) |
| | | where e.dict_type = 'responsibilities_list' |
| | | GROUP BY cppc.id) ecp on ecp.id = cppc.id |
| | | <where> |
| | | <if test="userId != null and userId != ''"> |
| | |
| | | * @return |
| | | */ |
| | | @ApiOperation(value = "标准方法删除验证原始记录列表") |
| | | @GetMapping("/delVerifyMethodFileList") |
| | | @DeleteMapping("/delVerifyMethodFileList") |
| | | public Result delVerifyMethodFileList(Integer methodFileId){ |
| | | return Result.success(processMethodVerifyMethodFileService.removeById(methodFileId)); |
| | | } |