| ${IF(fr_authority="SUPERROLE" ||INARRAY("公司高层",fr_authority)>0,"","AND PARENTID IN (SELECT PARENTID FROM IMP_DEPARTMANAGER A LEFT JOIN IMP_ADMIN_DTL B ON A.DEPARTID=B.ADMINID WHERE A.MANAGERID='"+fr_username+"')")} ${if(fr_username="admin" || INARRAY("公司高层",fr_authority)>0,"","AND B.PERSONID IN (SELECT PERSONID FROM DIM_PERSON WHERE INSTR(MANAGERSTR,(SELECT ','||ID||',' FROM DIM_PERSON WHERE PERSONID='"+fr_username+"'),1,1)>0 UNION ALL SELECT PERSONID FROM DIM_PERSON WHERE PERSONID='"+fr_username+"')")} ${IF(LEN(deptId)==0,"","AND A.ADMINIDTREE IN (SELECT DISTINCT T.ADMINIDTREE FROM DIM_ADMIN T WHERE DATAFROM='OA'--OA部门 AND ISCOMPANY='0'--部门 AND ISCANCELED = '0'--未取消 AND COMPANYID IN ('181', '381') START WITH T.ADMINIDTREE IN ('"+deptId+"') CONNECT BY T.FADMINID=PRIOR T.ADMINID)")} ${IF(LEN(DEPT)==0,"","AND A .ADMINIDTREE IN ("+"'"+treelayer(DEPT,true,"\',\'")+"'"+")")} 这三段代码都有什么作用啊，还有("+"'"+treelayer(DEPT,true,"\',\'")+"'"+")")}这是什么意思呀 |
