获取保安公司（授权）
__ZLuP7RGirprZZ6SCdiX
__ZLuP7RGirprZZ6SCdiX
published
UTF-8
get
/fkzh/auth/getdomainList
json
" + sql);
var data1 = queryByDSName("baibaodunFlow",sql);//获取用户下的权限
println("data1 ================== >" + data1);
var departmentIds = '';
var ptype = '';
if (data1 != null) {
for (var iterator = data1.iterator(); iterator.hasNext();) {
doc = iterator.next();
departmentIds += doc.get("item_domainLayer");
ptype = doc.get("item_permissionsType");
}
}
//查询符合的部门保安
var deps = departmentIds.split(";");
var deptids = "";
for (var i = 0; i < deps.length; i++) {
deptids += "'" + deps[i] + "',"
}
deptids += "'不存在'"
println("deptids ==================>>>>>>>" + deptids);
var sql2 = "SELECT (SELECT ITEM_legalPerson FROM tlk_companyinformation as b WHERE b.ITEM_domain_id = d.id limit 1) as legalPerson,(SELECT ITEM_legalPersonPhone FROM tlk_companyinformation as b WHERE b.ITEM_domain_id = d.id limit 1) as legalPersonPhone, d.* FROM obpm2.tenant_organizations as d where d.id in (" + deptids + ")";
var name = getParameter("domainname");
if (name.length() > 0) {
sql2 += " and d.name like '%" + name + "%'";
}
var data = queryByDSName("baibaodunFlow", sql2)
var result = new Packages.java.util.HashMap(); //创建指定类对象
result.put("code", 0);
result.put("data", data);
return result;
})()]]>