获取周边数据
__ZLuP7RGirprZZ6SCdiX
__ZLuP7RGirprZZ6SCdiX
published
__mcGC4dSEiims7vtdtr1
UTF-8
get
/fkzh/getAroundData
json
" + position);
var JSONUtil = new Packages.cn.hutool.json.JSONUtil()
var TLJSONUtil = new Packages.cn.myapps.util.json.JsonUtil();
//查询范围
var range = obj['range'];
var positionJSON = JSON.parse(position)
var longitude = positionJSON.longitude;
var latitude = positionJSON.latitude;
var dsName = "baibaodunFlow";
if (position || range) {
result.put("code", 0);
result.put("msg", "数据为空");
return result;
}
//获取可见保安员
var sql = "SELECT * FROM tlk_fkzhnewpermissions where DOMAINID = '" + getDomainid() + "'";
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 += ";";
}
}
//查询符合的部门保安
var deps = departmentIds.split(";");
var deptids = "";
for (var i = 0; i < deps.length; i++) {
if (i != deps.length - 1) {
deptids += "'" + deps[i] + "',"
} else {
deptids += "'不存在'"
}
}
var hard = hardwareType.split(";");
var hardids = "";
for (var i = 0; i < hard.length; i++) {
if (i != hard.length - 1) {
hardids += "'" + hard[i] + "',"
} else {
hardids += "'不存在'"
}
}
println("deptids ==================>>>>>>>" + deptids);
var sql2 = "SELECT " +
"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 (SUBSTRING_INDEX( SUBSTRING_INDEX( s.ITEM_LonLatJson, ',', 2 ), ':',- 1 ),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 (SUBSTRING_INDEX( SUBSTRING_INDEX( item_position, ',', 2 ), ':',- 1 ),SUBSTRING_INDEX( SUBSTRING_INDEX( item_position, ',', 1 ), ':',- 1 )),point ( " + longitude + ", " + latitude + " )) < " + range + " "
ssssssssss += hardAround;
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;
})()]]>