获取周边的数据
__ZLuP7RGirprZZ6SCdiX
__ZLuP7RGirprZZ6SCdiX
published
__nllT0G4nv31xWU0T9oA
UTF-8
post
/fkzh/getRangeData
json
" + range);
println("longitude ===============>" + longitude);
println("latitude ===============>" + latitude);
var dsName = "baibaodunFlow";
if (!isNotNull(longitude) || !isNotNull(latitude) || !isNotNull(range)) {
result.put("code", 0);
result.put("msg", "参数不能为空");
return result;
}
//获取可见保安员
var sql = "SELECT * FROM tlk_fkzhnewpermissions where item_people like '%" + getWebUser().getId() + "%'";
println("sql ================== >" + 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("peopleLayer");
ptype = doc.getItemValueAsString("permissionsType");
hardwareType = doc.getItemValueAsString("hardwareLayer");
//departmentIds += ";";
}
}
//查询符合的部门保安
departmentIds += ";"
var deps = departmentIds.split(";");
var deptids = "";
for (var i = 0; i < deps.length; i++) {
deptids += "'" + deps[i] + "',"
}
deptids += "'6666666666'";
hardwareType += ";"
var hard = hardwareType.split(";");
var hardids = "";
for (var i = 0; i < hard.length; i++) {
hardids += "'" + hard[i] + "',"
}
hardids += "'88888'";
println("deptids ==================>>>>>>>" + deptids);
var sql2 = "SELECT DISTINCT " +
"s.ITEM_securityName," +
//"s.ITEM_LonLatJson as FIELD25," +
"s.domainid as item_domainid," +
"s.ITEM_LonLatJson," +
//"s.ITEM_userID as ITEM_ID," +
"s.ITEM_userID,'" +
getDomainid() + "' as domainid," +
"s.ITEM_phone," +
"s.ITEM_pirture," +
"s.ITEM_companyName," +
"s.ITEM_DeptName," +
"( SELECT a.ITEM_ATTENDANCESITENAME from tlk_attendance_site_base_info as a ,tlk_attendance_site_person_info as b where a.id = b.ITEM_ATTENDANCESITEID and b.ITEM_DOCUMENTID = s.ITEM_DOCUMENTID LIMIT 1) as ITEM_ATTENDANCESITENAME, " +
"( SELECT a.id from tlk_attendance_site_base_info as a ,tlk_attendance_site_person_info as b where a.id = b.ITEM_ATTENDANCESITEID and b.ITEM_DOCUMENTID = s.ITEM_DOCUMENTID LIMIT 1 ) as ITEM_ATTENDANCESITEID " +
"FROM " +
"vw_employee as s " +
"WHERE s.ITEM_LonLatJson != '' and s.ITEM_LonLatJson is not null and ";
// " u.domainid = '"+getDomainid()+"' " +
if (ptype == '指定企业') {
sql2 += " s.ITEM_DEPTID IN (" + deptids + ") ";
}
else if (ptype == '指定区域') {
sql2 += " s.domainid IN (" + deptids + ") ";
}
else {
sql2 += " s.domainid IN (' ') ";
}
//匹配保安员经纬度
var ttttttttt = " and st_distance_sphere(point(replace( SUBSTRING_INDEX( SUBSTRING_INDEX(s.ITEM_LonLatJson, ',', 2), ':' ,- 1 ),'\"',''),replace(SUBSTRING_INDEX( SUBSTRING_INDEX(s.ITEM_LonLatJson, ',', 1), ':' ,- 1 ),'\"','')),point ("+longitude+", "+latitude+" )) < " + range + " "
sql2 += ttttttttt;
println("sql2 ================== >" + sql2);
var ddddddddd = queryByDSName("baibaodunFlow", sql2);
println("sql2 ================== >rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ");
//硬件资源
var ssssssssss = "SELECT * FROM tlk_baseform where domainid in (" + hardids + ")";
var hardAround = " and st_distance_sphere (point(ITEM_LONGITUDE,ITEM_LATITUDE),point ( " + longitude + ", " + latitude + " )) < " + range + " "
ssssssssss += hardAround;
println("ssssssssss =======>" + ssssssssss);
var hhhhhhhhh = queryByDSName("baibaodunFlow", ssssssssss);
res.put("securityManData", ddddddddd);
res.put("situationData", hhhhhhhhh);
//sdata2 = sdata2.filter( item => {return GetDistance(longitude,latitude,item.FIELD25.longitude,item.FIELD25.latitude) > 300;})
var result = new Packages.java.util.HashMap(); //创建指定类对象
result.put("code", 0);
result.put("data", res);
return result;
})()]]>