//获取特定部门下的某个角色用户作为流程审批人
(function(){
var roleid = getRoleIdByName("系统管理员");
var userlist = createObject("java.util.ArrayList");
var sql = "select t.*,'"+getDomainid()+"' as domainid from(select userid as item_userid from t_user_department_role_set where departmentid in (select id from t_department where name in ('江铃汽车股份有限公司','产品研发总院')) and roleid in ('"+roleid+"') and userid is not null)t where 1 = 1";
var datas = queryBySQL(sql);
if(datas!=null){
for(var iter = datas.iterator();iter.hasNext();){
var docone = iter.next();
var userid = docone.getItemValueAsString("userid");
var userVO = getUserById(userid);
userlist.add(userVO);
}
}
return userlist;
})();发布者：chain，转转请注明出处：https://chain996.top/?p=4149
微信扫一扫 
支付宝扫一扫 
