getDataPermissionSql __K9C0HmAjnqJZgTI2sjd __K9C0HmAjnqJZgTI2sjd : " + roles); // for(var iter=roles.iterator();roles !=null && iter.hasNext();){ // var role=iter.next(); // println("当前用户的角色="+role.getName()); // if(role.getName()=="管理员"){ // return "1=1"; // } // } var domainId = getDomainid(); var allSuperIdsSql = " SELECT GROUP_CONCAT(lv SEPARATOR ',') as ITEM_SUPERIORIDS,'"+domainId+"' as DOMAINID FROM (SELECT @pv:=(SELECT GROUP_CONCAT(ID SEPARATOR ',') FROM "+dsName2+".t_user "+ " WHERE FIND_IN_SET(SUPERIOR, @pv)) AS lv FROM "+dsName2+".t_user JOIN "+ " (SELECT @pv:='"+userVO.getId()+"') tmp) a"; var whereSql = "'"+userVO.getId()+"'"; println("getDataPermissionSql()函数库的allSuperIdsSql----->: " + allSuperIdsSql); var subdocs = queryBySQL(allSuperIdsSql); var superiorIds = null; if(subdocs!= null && subdocs.size() > 0) { for (var iter = subdocs.iterator(); iter.hasNext();) { var subdoc = iter.next(); superiorIds = subdoc .getItemValueAsString("SUPERIORIDS"); if(superiorIds){ var arr = splitText(superiorIds,","); for(var i=0;i 0