uas-eis/src/main/java/com/uas/eis/serviceImpl/UasSyncService.java

package com.uas.eis.serviceImpl;

import com.uas.eis.dao.BaseDao;
import com.uas.eis.entity.Employee;
import com.uas.eis.entity.HrOrg;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UasSyncService {

    @Autowired
    private BaseDao baseDao;

    public List<Employee> getADUserList() {
        return  baseDao.query("select em_code,em_name,or_code orcode,em_class,em_adid,em_emptype,em_position  from employee  left join hrorg on em_defaultorid=or_id"+
                " where em_adid is not  null or em_class<>'离职' order by em_id asc"
                ,
                Employee.class);
    }
    public List<HrOrg> getADOrgList() {
       return  baseDao.query("select * from (select or_code,or_name,or_status,or_neteasyid,prior or_neteasyid parentnetEasyId,substr(sys_connect_by_path( or_name,'-'),instr(sys_connect_by_path( or_name,'-'),'-',1,2)+1) or_path,level as or_level " +
                        "from hrorg where or_needsync=-1 start with or_PCODE is null connect by prior  or_CODE= or_PCODE) order by or_level asc"
                ,
                HrOrg.class);
    }
    public List<Employee> getNetEasyUserList() {
        return  baseDao.query("select em_code,em_name,or_code orcode,or_neteasyid orneteasyid,em_class,em_neteasyid,em_emptype,em_isneteasy,em_position,em_password,em_mobile from employee  left join hrorg on em_defaultorid=or_id"+
                        " where em_neteasyid is not  null or em_class<>'离职' order by em_id asc"
                ,
                Employee.class);
    }

    public List<Employee> getYongHDelUserList() {
        return  baseDao.query("select em_code,em_name,em_class,em_yonghongid,em_mobile,em_email from employee"+
                        " where EM_YONGHONGID is not null and (EM_ISYONGHONG=0 or em_class='离职') order by em_id asc" ,Employee.class);
    }
    public List<Employee> getYongHAddUserList() {
        return  baseDao.query("select em_code,em_name,em_class,em_yonghongid,em_mobile,em_email from employee "+
                        " where nvl(EM_YONGHONGID,' ')=' ' and  em_class<>'离职' and EM_ISYONGHONG=-1 order by em_id asc"  , Employee.class);
    }

}