1. 权限设置

管辖员工权限清单

select '间接管理' 管理类型,cu.cu_name 管理人,sbcu.cu_name  被管人
from mps_employee_subusersreal t,
mps_employee cu,
mps_employee sbcu
where cu.cu_id = cus_cuid
and cus_subcuid = sbcu.cu_id

select '直接管理' 管理类型,cu.cu_name 管理人,sbcu.cu_name  被管人
from mps_employee_subusers t,
mps_employee cu,
mps_employee sbcu
where cu.cu_id = cs_cuid
and cs_subcuid = sbcu.cu_id