企业id获取驻勤点
__ZLuP7RGirprZZ6SCdiX
__ZLuP7RGirprZZ6SCdiX
published
__mcGC4dSEiims7vtdtr1
UTF-8
get
/fkzh/getAttendance/{id}
json
" + categoryName);
var cateCode = getCodeWithCategoryName(categoryName);
println('cateCode ==================>' + cateCode);
var sqlUser = "select * FROM tlk_categorypermissions WHERE ITEM_PEOPLE LIKE '%" + getWebUser().getId() + "%' and (ITEM_TYPE is not null or ITEM_TYPE != '')";
println("执行sql ==========================>" + sqlUser);
var users = queryBySQL(sqlUser);
println("获取数据 ==========================>" + users);
//可见现场态势
var sceneData = '';
//可见驻勤点
var dutyData = '';
if (users != null) {
for (var iterator = users.iterator(); iterator.hasNext();) {
var map1 = iterator.next();//取值
sceneData += map1.getItemValueAsString("scene");
dutyData += map1.getItemValueAsString("duty");
}
}
println("dutyData =================>" + dutyData);
var dutyParams = ""
var dutyDataarr = dutyData.split(";");
for (var i = 0; i < dutyDataarr.length; i++) {
dutyParams += "'" + dutyDataarr[i] + "',"
}
dutyParams += "'0000'"
//获取用户可见企业
var sqlu = "SELECT * FROM tlk_fkzhnewpermissions where ITEM_PEOPLE like '%" + getWebUser().getId() + "%'";
println("sql ================== >" + sqlu);
var datauser = queryBySQL(sqlu);//获取用户下的权限
println("datauser ================== >" + datauser);
var dIds = '';
var ptype = '';
if (datauser != null) {
for (var iteratorUser = datauser.iterator(); iteratorUser.hasNext();) {
doc = iteratorUser.next();
dIds += doc.getItemValueAsString("attendanceLayer");
}
}
var deps = dIds.split(";");
var deptids = "";
for (var i = 0; i < deps.length; i++) {
deptids += "'" + deps[i] + "',"
}
deptids += "'6666'"
var sqlTemp = ''
var sql = "SELECT a.domainid ,a.ID," +
"a.ITEM_ATTENDANCESITENAME," +
"a.ITEM_ATTENDANCESITECONTENT," +
"a.ITEM_ATTENDANCESITEADDRESS," +
"a.ITEM_ATTENDANCESITEFULLADDRESS," +
"a.ITEM_ATTENDANCESITELONGITUDE ," +
"a.ITEM_ATTENDANCESITELATITUDE ," +
"a.ITEM_PERFORMRANGE," +
"a.ITEM_OFFICEPOLICEADDRESS," +
"a.ITEM_PRINCIPALIDCARDNO," +
"a.ITEM_PRINCIPALNAME," +
"a.ITEM_PRINCIPALPHONENO," +
"a.ITEM_SERVEOBJECTNAME," +
"a.ITEM_CONTRACTSTATE," +
"a.ITEM_ATTENDANCESITETYPE," +
"(SELECT count(*) FROM tlk_attendance_site_base_info as b,tlk_attendance_site_person_info as p WHERE b.id = p.ITEM_ATTENDANCESITEID and b.id = a.id )as item_personSum" +
" FROM tlk_attendance_site_base_info as a where a.DOMAINID in ('" + id + "')"
//var params = getDomainids("attendancePermissions");
println("sql ===========================>" + sql)
var datas = queryByDSName("baibaodunFlow", sql);
result.put("data", datas);
println("result ====================>" + result);
return result;
})()]]>