luoyb
2021-01-28 2e524b26f4a7e9f75f2b29ae2edbcf932ee5f645
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
package cc.mrbird.febs.server.hr.mapper;
 
import cc.mrbird.febs.server.hr.entity.EmpBadRecord;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;
 
import java.util.List;
 
/**
 * name:EmpBadrecord
 * package:cc.mrbird.febs.server.hr.controller
 * description:员工不良记录信息实体Mapper
 *
 * @author luoyibo
 * @date 2021-01-24 20:35:55
 * @since JDK1.8
 */
public interface EmpBadRecordMapper extends BaseMapper<EmpBadRecord> {
    @Update("<script>        " +
            " UPDATE t_emp_badrecord SET delFlag = 1,\n" +
            " modifyTime = NOW(),\n" +
            "  modifier = #{operatorId}, \n" +
            "  version = version+1 \n" +
            "  WHERE badId IN \n" +
            "         <foreach item=\"delId\" collection=\"list\" open=\"(\" close=\")\" separator=\",\">\n" +
            "             #{delId}\n" +
            "         </foreach>\n" +
            "</script>")
    void logicDeleteByIds(@Param("list") List<String> list,@Param("operatorId") String operatorId);
}