作者:手机用户2502909811 | 来源:互联网 | 2023-10-11 14:26
SELECT*FROMWF_INSTANCEA,WFV_TASKB,G_PRJ_XMXXCWHEREA.INSTID=B.INSTID[%=if(isSuper
SELECT * FROM WF_INSTANCE A, WFV_TASK B, G_PRJ_XMXX C
WHERE A.INSTID = B.INSTID [%=if(isSuperAdmin(curUser()),""," AND ((B.FINISHUSER IS NOT NULL AND B.FINISHUSER='"+curUser()+"' OR B.FINISHUSER IS NULL AND B.EXECUSER IS NOT NULL AND B.EXECUSER='"+curUser()+"') OR (B.FINISHUSER IS NULL AND B.EXECUSER IS NULL AND ((B.EXECROLE IS NOT NULL AND "+concatCols("wfdata","B.ROLESUBSYS,'.',B.EXECROLE")+" IN ("+userRoles(curUser(),null,",",true)+")) OR B.EXECROLE IS NULL)))" + if(hasRole('appzjgg', 'SJ_GBKZ') || hasRole('appzjgg', 'SJ_JB'), " AND C.CORG_ IN (select ORGANISEID from ORGANISE where PARENTID = '" + curOrg() + "')", ""))%]
ORDER BY B.ARRIVETIME DESC