package cc.mrbird.febs.server.hr.mapper;
|
|
import cc.mrbird.febs.server.hr.entity.EmpResign;
|
|
import com.baomidou.mybatisplus.core.conditions.Wrapper;
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.baomidou.mybatisplus.core.metadata.IPage;
|
import com.baomidou.mybatisplus.core.toolkit.Constants;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Update;
|
|
import java.util.List;
|
|
/**
|
* name:EmpResign
|
* package:cc.mrbird.febs.server.hr.controller
|
* description:员工辞职申请实体Mapper
|
*
|
* @author luoyibo
|
* @date 2021-01-31 11:26:18
|
* @since JDK1.8
|
*/
|
public interface EmpResignMapper extends BaseMapper<EmpResign> {
|
/**
|
* 根据Id批量逻辑删除记录
|
* <p>
|
* date luoyibo
|
*
|
* @param list 待删除Id
|
* @param operatorId 操作员Id
|
* @return void
|
* @author: 2021-01-31 11:26:18
|
*/
|
@Update("<script> " +
|
" UPDATE t_emp_resign SET delFlag = 1,\n" +
|
" modifyTime = NOW(),\n" +
|
" modifier = #{operatorId}, \n" +
|
" version = version+1 \n" +
|
" WHERE resignId 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);
|
|
@Update("<script> " +
|
" UPDATE t_emp_resign SET delFlag = 0,\n" +
|
" modifyTime = NOW(),\n" +
|
" modifier = #{operatorId}, \n" +
|
" version = version+1 \n" +
|
" WHERE resignId IN \n" +
|
" <foreach item=\"delId\" collection=\"list\" open=\"(\" close=\")\" separator=\",\">\n" +
|
" #{delId} \n" +
|
" </foreach>\n" +
|
"</script>")
|
int momentToNormal(@Param("list") List<String> list, @Param("operatorId") String operatorId);
|
|
IPage<EmpResign> selectPageVo(Page<?> page, @Param(Constants.WRAPPER) Wrapper wrapper);
|
}
|
