保安员模糊查询（授权）
__ZLuP7RGirprZZ6SCdiX
__ZLuP7RGirprZZ6SCdiX
published
__mcGC4dSEiims7vtdtr1
UTF-8
get
/fkzh/auth/getSecurityman
json
" + sql);
var data1 = queryBySQL(sql);//获取用户下的权限
println("data1 ================== >" + data1);
var departmentIds = '';
var ptype = '';
if (data1 != null) {
for (var iterator = data1.iterator(); iterator.hasNext();) {
doc = iterator.next();
departmentIds += doc.getItemValueAsString("domainLayer");
ptype = doc.getItemValueAsString("permissionsType");
}
}
//查询符合的部门保安
var deps = departmentIds.split(";");
var deptids = "";
for (var i = 0; i < deps.length; i++) {
deptids += "'" + deps[i] + "',"
}
deptids += "'不存在'";
var result = new Packages.java.util.HashMap(); //创建指定类对象
var sql = "SELECT a.ITEM_securityName, a.domainid AS item_domainid, a.ITEM_LonLatJson, a.item_userId, a.item_companyName, '__2t8RijBWNoIGeIjqotR' AS domainid, a.ITEM_phone, a.ITEM_pirture, a.ITEM_DEPTNAME,( SELECT g.ITEM_ATTENDANCESITENAME FROM tlk_attendance_site_base_info AS g, tlk_attendance_site_person_info AS h WHERE g.id = h.ITEM_ATTENDANCESITEID AND a.ITEM_DOCUMENTID = h.ITEM_DOCUMENTID LIMIT 1 ) AS ITEM_ATTENDANCESITENAME, ( SELECT g.id FROM tlk_attendance_site_base_info AS g, tlk_attendance_site_person_info AS h WHERE g.id = h.ITEM_ATTENDANCESITEID AND a.ITEM_DOCUMENTID = h.ITEM_DOCUMENTID LIMIT 1 ) AS ITEM_ATTENDANCESITENAME FROM vw_employee AS a WHERE a.domainid IN (" + deptids +")"
if(name.length() > 0) {
sql += " and name like '%"+name+"%'"
}
println("sql ====>" + sql );
var datas = queryByDSName("baibaodunFlow", sql);
result.put("data", datas);
result.put("code", 0);
return result;
})()
]]>