package com.ruoyi.system.mapper;

import com.ruoyi.common.basic.PageInfo;
import com.ruoyi.system.domain.SysEmployee;
import com.ruoyi.system.dto.SysEmployeePageRequest;
import com.ruoyi.system.vo.SysEmployeeVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 员工管理数据层
 *
 * @author ruoyi
 */
@Mapper
public interface SysEmployeeMapper
{
    public List<SysEmployeeVO> pageList(@Param("query") SysEmployeePageRequest query,
                                        @Param("contactPhoneHash") String contactPhoneHash,
                                        @Param("pageInfo") PageInfo<SysEmployeeVO> pageInfo);

    public SysEmployeeVO selectVoById(Long employeeId);

    public List<SysEmployeeVO> selectVoByName(@Param("employeeName") String employeeName);

    public SysEmployee selectById(Long employeeId);

    public SysEmployee checkEmployeeNoUnique(@Param("employeeNo") String employeeNo,
                                             @Param("excludeEmployeeId") Long excludeEmployeeId);

    public SysEmployee checkPhoneUnique(@Param("contactPhoneHash") String contactPhoneHash,
                                        @Param("excludeEmployeeId") Long excludeEmployeeId);

    public SysEmployee checkCardNoUnique(@Param("cardNo") String cardNo,
                                         @Param("excludeEmployeeId") Long excludeEmployeeId);

    public int insertEmployee(SysEmployee employee);

    public int updateEmployee(SysEmployee employee);

    public int updateEnabled(@Param("employeeIds") List<Long> employeeIds, @Param("enabled") Boolean enabled,
                             @Param("updateBy") String updateBy);

    public int clearCard(@Param("employeeIds") List<Long> employeeIds, @Param("updateBy") String updateBy);

    public int updateCardNo(@Param("employeeId") Long employeeId, @Param("cardNo") String cardNo,
                            @Param("updateBy") String updateBy);

    public int clearFace(@Param("employeeIds") List<Long> employeeIds, @Param("updateBy") String updateBy);

    public int deleteByIds(@Param("employeeIds") List<Long> employeeIds, @Param("updateBy") String updateBy);
}