我团队的
__Q4kKhtnnyPlzOe2R3oo
__Q4kKhtnnyPlzOe2R3oo
published
__vSridPsPSESg7bvODgI
UTF-8
get
/get_my_team
json
" + title);
var sqlD = "SELECT * from tenant_department_admins where employee_id = '"+uid+"' and organization_id = '"+getDomainid()+"'"
println("sqlD =========>" + sqlD);
var dataD = queryByDSName("obpm2",sqlD);
var sqlPar = "";
if(dataD.size() <= 0) {
result.put("msg","不是部门管理员");
return result;
}else{
for(var iteratordataD = dataD.iterator();iteratordataD.hasNext();){
var dataDMap = iteratordataD.next();//取值
sqlPar += "'"+ dataDMap.get("department_id") +"',";
}
}
sqlPar += "'6666666666666'";
var sql = "SELECT * from VIEW_application where AUTHOR_DEPT_INDEX in ("+sqlPar+") ";
if (isNotNull(title)) {
sql += " and item_title like '%" + title + "%'";
}
sql += " order by item_application_time desc"
var data1 = queryByDSName("oa_flow", sql);
var data1Str = jsonUtils.collection2Json(data1);
var data1Obj = JSON.parse(data1Str);
for (var i = 0; i < data1Obj.length; i++) {
var doc = findDocument(data1Obj[i].id);
println("data1Obj[i].id ===========>" + data1Obj[i].id);
println("doc ===========>" +jsonUtils.toJson(doc.getItemMap()));
data1Obj[i].doc = JSON.parse(jsonUtils.toJson(doc.getItemMap()))
}
result.put("code", "0");
result.put("msg", "获取成功");
result.put("data", jsonUtils.toCollection(JSON.stringify(data1Obj)));
return result;
})()]]>