【泛微ecology】从数据库导出人员信息，部门取机构全路径

最新推荐文章于 2024-08-06 09:08:29 发布

E-cology

最新推荐文章于 2024-08-06 09:08:29 发布

阅读量2k

点赞数

分类专栏：泛微ecology

本文链接：https://blog.csdn.net/fwecology/article/details/118368595

版权

泛微ecology 专栏收录该内容

107 篇文章 174 订阅

订阅专栏

select
(SELECT
	(SELECT
	fulldeptname
FROM
	(
SELECT
	id,
	sys_connect_by_path ( REPLACE ( subcompanyname, '/', '' ), '/' ) fulldeptname
FROM
	hrmsubcompany START WITH supsubcomid = 0 CONNECT BY supsubcomid = PRIOR id
	)
WHERE
	id = ( SELECT subcompanyid1 FROM HrmDepartment WHERE id = b.DEPARTMENTID )) || fulldeptname
FROM
	(
SELECT
	id,
	sys_connect_by_path ( REPLACE ( departmentname, '/', '' ), '/' ) fulldeptname
FROM
	HrmDepartment START WITH supdepid = 0 CONNECT BY supdepid = PRIOR id
	)
WHERE
	id = b.DEPARTMENTID
	),
	b.LASTNAME,b.LOGINID,case b.SEX when 0 then '男' else '女' end as sex,b.TELEPHONE,
	(select jobtitlename from HRMJOBTITLES where id=b.JOBTITLE) as job,
	(select lastname from HRMRESOURCE where id=b.MANAGERID) as zjsj
from HRMRESOURCE b
where LOGINID is not null
order by DSPORDER