| | |
| | | package cc.mrbird.febs.server.hr.mapper; |
| | | |
| | | import cc.mrbird.febs.server.hr.entity.EmpBaseInfo; |
| | | import cc.mrbird.febs.server.hr.entity.EmpJobChange; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.apache.ibatis.annotations.Update; |
| | | |
| | | import java.util.Date; |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * name:EmpBaseinfo |
| | |
| | | " </foreach>\n" + |
| | | "</script>") |
| | | int momentToNormal(@Param("list") List<String> list, @Param("operatorId") String operatorId); |
| | | /** |
| | | * |
| | | * 关闭员工档案 |
| | | * |
| | | * date 2021-02-18 12:54 |
| | | * @author: luoyibo |
| | | * @param ids 待关闭档案员工 Id |
| | | * @param dimissionType 离职类型 |
| | | * @param dimissionDate 离职日期 |
| | | * @param remark 备注 |
| | | * @return boolean |
| | | */ |
| | | @Update("<script> " + |
| | | " UPDATE t_emp_baseinfo SET empStatus = 1,\n" + |
| | | " dimissionDate = #{dimissionDate},\n" + |
| | | " dimissionType = #{dimissionType},\n" + |
| | | " remark = #{remark},\n" + |
| | | " modifyTime = NOW(),\n" + |
| | | " modifier = #{operatorId}, \n" + |
| | | " version = version+1 \n" + |
| | | " WHERE empId IN \n" + |
| | | " <foreach item=\"delId\" collection=\"list\" open=\"(\" close=\")\" separator=\",\">\n" + |
| | | " #{delId} \n" + |
| | | " </foreach>\n" + |
| | | "</script>") |
| | | int closeEmpArchives(@Param("list") List<String> list, @Param("dimissionType") String dimissionType, @Param("dimissionDate") Date dimissionDate, @Param("remark") String remark, @Param("operatorId") String operatorId); |
| | | |
| | | @Update("<script> " + |
| | | " UPDATE t_emp_baseinfo SET \n" + |
| | | " deptId = #{mapParams.deptId},\n" + |
| | | " deptName = #{mapParams.deptName},\n" + |
| | | " jobId = #{mapParams.jobId},\n" + |
| | | " jobName = #{mapParams.jobName},\n" + |
| | | " modifyTime = NOW(),\n" + |
| | | " modifier = #{mapParams.operatorId}, \n" + |
| | | " version = version+1 \n" + |
| | | " WHERE empId IN \n" + |
| | | " <foreach item=\"delId\" collection=\"list\" open=\"(\" close=\")\" separator=\",\">\n" + |
| | | " #{delId} \n" + |
| | | " </foreach>\n" + |
| | | "</script>") |
| | | int changeEmpJob(@Param("list") List<String> list, @Param("mapParams") Map<String,Object> mapParams); |
| | | } |