luoyb
2021-02-18 8a2b8ef34fd521457c5ede0c561bb1214985bc3b
febs-server/febs-server-hr/src/main/java/cc/mrbird/febs/server/hr/mapper/EmpBaseInfoMapper.java
@@ -5,6 +5,7 @@
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;
import java.util.Date;
import java.util.List;
/**
@@ -60,4 +61,30 @@
            "        </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);
}