package com.pingcap.syngmail.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pingcap.syngmail.pojo.EmployeeDTO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author zhuxiaopeng
 * @version 1.0.0
 * @Description 员工mapper类
 * @createTime 2022年04月08日 10:04:00
 */
@Mapper
public interface EmployeeMapper extends BaseMapper<EmployeeDTO> {

    /**
     * @author zhuxiaopeng
     * @description 获取员工信息
     */
//    @Select("SELECT he.id,he.name,he.email,he.area_email_group,he.active\n" +
//            "(SELECT hd.name  FROM hr_departments hd WHERE he.first_department_id = hd.id) first_department,\n" +
//            "(SELECT hd.name  FROM hr_departments hd WHERE he.second_department_id = hd.id) second_department,\n" +
//            "(SELECT hd.name  FROM hr_departments hd WHERE he.third_department_id = hd.id) third_department,\n" +
//            "(SELECT hd.name  FROM hr_departments hd WHERE he.fourth_department_id = hd.id) fourth_department\n" +
//            "from hr_employees he where he.active = 1")
//    List<EmployeeDTO> listEmployeeDepartment();

    /**
     * @author zhuxiaopeng
     * @description 获取员工信息
     */
    @Select("SELECT he.id,he.name,he.email,he.area_email_group,he.active from hr_employees he")
    List<EmployeeDTO> listEmployeeDepartment();
}