You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2.1 KiB
2.1 KiB
点击机构查询
功能操作
常规查询方式,点击机构进行数据查询。
基本操作
- 数据默认查询
- 排序垃圾数据
- 现职人员
- 人员类别(公务员)
- 报表条件(如:统计中央一级)
- 统计范围(按照统计关系所在单位,,默认包含下级)
- 操作用户的权限脚本
-- 默认点击查询
select tmp.a0000, '0A9E21F1CBA1276AE0743D859E081777' sessionid,
(@i := @i + 1) as i
from (select @i := 0) as it,
(select a01.a0000, '0A9E21F1CBA1276AE0743D859E081777' sessionid
from A01 a01
where 1 = 1
and a01.status != '4' -- 排序垃圾数据
and a0163 = '1' -- 现职人员
and exists(select 1
from a02 a02,
competence_userdept cu
where cu.userid = '1'
and a02.A0201B = b0111
and a01.a0000 = a02.a0000
and a0281 = 'true' -- 职务输出
and a02.a0201b like '001.001.007%') -- 权限脚本
order by length(torgid), (select concat(LPAD(SORTID, 6, 0), torgid )
from b01 where B0111 = torgid) asc, -- 数据排序
torder asc, a0000 asc) tmp
-- 点击“其他人员”机构
select tmp.a0000, '0A9E21F1CBA1276AE0743D859E081777' sessionid,
(@i := @i + 1) as i
from (select @i := 0) as it,
(select a01.a0000, '0A9E21F1CBA1276AE0743D859E081777' sessionid
from A01 a01
where 1 = 1
and a01.status != '4' -- 排序垃圾数据
and not exists (select 1
from a02,
b01
where a02.a0000 = a01.a0000
and b0111 = a0201b
and a0281 = 'true' -- 职务输出
and b0111 != '-1') -- 权限脚本
and a0163 = '1'
order by length(torgid), (select concat(LPAD(SORTID, 6, 0), torgid)
from b01 where B0111 = torgid) asc, -- 数据排序
torder asc, a0000 asc) tmp