backgroundScreening
__K9C0HmAjnqJZgTI2sjd
__K9C0HmAjnqJZgTI2sjd
: " + jsonString);
//转换json
var jsonObject = Packages.com.bcxin.saas.core.utils.JsonUtil.parseObject(jsonString);
println("jsonObject=====> : " + jsonObject);
//接口调通后获取data，为null结束当前数据比对，更新比对时间，data不为null，进入结果解析
var datafirst = jsonObject.get("data");
println("是否有问题结果：" + datafirst);
if("null".equals(datafirst)){
//更新保安员背景筛查比对时间
var updatetimeSql = "update tlk_securityman set item_lastCompareTime = '"+format(getToday(),"yyyy-MM-dd HH:mm:ss")+"' where ITEM_DOCUMENTID = '"+idnumber+"'";
println("没问题修改比对时间的sql" + updatetimeSql);
updateByDSName(dsName(),updatetimeSql);
return "";
}else{
//获取censorResult
var censorResult = datafirst.get("censorResult");
println("censorResult=====> : " + censorResult);
//获取十一个返回的结果result
var result0 = censorResult.get(0).get("result");//湖南省公安厅拘留所出入所人员信息返回结果
var code0 = censorResult.get(0).get("code");
println("result0=====> : " + result0 + "; 请求状态码：" + code0);
var result1 = censorResult.get(1).get("result");//湖南省涉毒人员信息返回结果
var code1 = censorResult.get(1).get("code");
println("result1=====> : " + result1 + "; 请求状态码：" + code1);
var result2 = censorResult.get(2).get("data");//公安部在逃人员返回值, 返回值为map, {}即为无记录;
var code2 = censorResult.get(2).get("code");
println("result2=====> : " + result2 + "; 请求状态码：" + code2);
var result3 = censorResult.get(3).get("wffzry");//公安部违法犯罪人员返回值, 类型是数组, 空数组即无记录;
var code3 = censorResult.get(3).get("code");
println("result3=====> : " + result3 + "; 请求状态码：" + code3);
var result4 = censorResult.get(4).get("result");//获取湖南省情报重点人员信息
var code4 = censorResult.get(4).get("code");
println("result4=====> : " + result4 + "; 请求状态码：" + code4);
var result5 = censorResult.get(5).get("result");//湖南省工作对象信息
var code5 = censorResult.get(5).get("code");
println("result5=====> : " + result5 + "; 请求状态码：" + code5);
var result6 = censorResult.get(6).get("result");//湖南省公安厅看守所出入所人员信息
var code6 = censorResult.get(6).get("code");
println("result6=====> : " + result6 + "; 请求状态码：" + code6);
var result7 = censorResult.get(7).get("result");//湖南省执法办案违法人员信息(行政)
var code7 = censorResult.get(7).get("code");
println("result7=====> : " + result7 + "; 请求状态码：" + code7);
var result8 = censorResult.get(8).get("result");//湖南省公安厅戒毒所出入所人员信息
var code8 = censorResult.get(8).get("code");
println("result8=====> : " + result8 + "; 请求状态码：" + code8);
var result9 = censorResult.get(9).get("result");//湖南省执法办案违法人员信息(刑事)
var code9 = censorResult.get(9).get("code");
println("result9=====> : " + result9 + "; 请求状态码：" + code9);
var result10 = censorResult.get(10).get("result");//湖南省吸毒人员信息
var code10 = censorResult.get(10).get("code");
println("result10=====> : " + result10 + "; 请求状态码：" + code10);
//定义问题类型返回值
var drugRtn = ""; //涉毒人员返回值 1 8 10
var escapeRtn = ""; //在逃人员返回值 2
var importantRtn = ""; //重点人员返回值 0 3 4 5 6 7 9
//解析比对结果，存于对应变量
if(result0 > 0 && code0 == 200){
importantRtn = importantRtn + censorResult.get(0).get("cxxt") + ";";
}
if(result1 > 0 && code1 == 200){
drugRtn = drugRtn + censorResult.get(1).get("cxxt") + ";";
println("cxxt=====> : " + drugRtn);
}
if(!"{}".equals(result2) && code2 == 200){
escapeRtn = "公安部在逃人员";
}
if(!"[]".equals(result3) && code3 == 200){
importantRtn = importantRtn + "公安部违法犯罪人员;";
}
if(result4 > 0 && code4 == 200){
importantRtn = importantRtn + censorResult.get(4).get("cxxt") + ";";
}
if(result5 > 0 && code5 == 200){
importantRtn = importantRtn + censorResult.get(5).get("cxxt") + ";";
}
if(result6 > 0 && code6 == 200){
importantRtn = importantRtn + censorResult.get(6).get("cxxt") + ";";
}
if(result7 > 0 && code7 == 200){
importantRtn = importantRtn + censorResult.get(7).get("cxxt") + ";";
}
if(result8 > 0 && code8 == 200){
drugRtn = drugRtn + censorResult.get(8).get("cxxt") + ";"
}
if(result9 > 0 && code9 == 200){
importantRtn = importantRtn + censorResult.get(9).get("cxxt") + ";";
}
if(result10 > 0 && code10 == 200){
drugRtn = drugRtn + censorResult.get(10).get("cxxt") + ";"
}
println("涉毒人员比对结果：" + drugRtn);
println("在逃人员比对结果：" + escapeRtn);
println("重点人员比对结果：" + importantRtn);
/**
**涉毒人员、重点人员、在逃人员表单比对
**/
//var deadline = format(getToday(),"yyyy-MM-dd HH:mm:ss"); //获取当前时间
//println("当前时间：" + deadline);
//比对在逃人员表单
if(!"".equals(escapeRtn) && isNotNull(escapeRtn)){
var securityName = "";
var domain_id = "";
var companyName = "";
var documentid = "";
var phone = "";
//sql1比对在逃人员表单数据
var sql1 = "select * from tlk_escapeman where item_documentid = '" + idnumber + "' ORDER BY created DESC limit 1";
println("sql1：" + sql1);
var query1 = queryByDSName(dsName(),sql1);
println("query1：" + query1);
//如果在逃人员表单为空
if(query1 == "[]"){
addEscape(idnumber,securityName,domain_id,companyName,documentid,phone,escapeRtn);//新增记录
}else{ //如果比对在逃人员表不为空，进而比对所在职企业是否相同
//比对在职企业
//var iter = query1.iterator();
for(var iterator = query1.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
domain_id1 = map1.get("item_domain_id");//获取公司id
companyName1 = map1.get("item_companyname");//获取公司id
questionType = map1.get("item_questiontype");//获取公司id
compareTime = map1.get("item_comparetime");//获取公司id
}
//比对在职企业是否相同
println("domain_id1======" + domain_id1);
println("companyName1======" + companyName1);
println("questionType======" + questionType);
println("compareTime======" + compareTime);
println("参数公司名称：" + companyNameO);
println("参数公司id：" + domainid);
println("参数idnumber：" + idnumber);
if(domainid.equals(domain_id1) && companyNameO.equals(companyName1)){ //在职企业相同
println("================");
if(escapeRtn.equals(questionType)){ //比对问题类型相同
//企业与问题类型相同，更新比对时间
println("========更新比对时间========");
var updateSql = "update tlk_EscapeMan set item_lastCompareTime = '"+compareTime+"',item_compareTime = '"+format(getToday(),"yyyy-MM-dd HH:mm:ss")+"' where ITEM_DOCUMENTID = '"+idnumber+"'";
println("修改比对时间的sql" + updateSql);
updateByDSName(dsName(),updateSql);
}else{ //比对问题类型不相同
//新增记录
addEscape(idnumber,securityName,domain_id,companyName,documentid,phone,escapeRtn);
}
}else{//在职企业不同
//新增记录
addEscape(idnumber,securityName,domain_id,companyName,documentid,phone,escapeRtn);
}
}
}
//比对涉毒人员表单
if(!"".equals(drugRtn) && isNotNull(drugRtn)){
var securityName = "";
var domain_id = "";
var companyName = "";
var documentid = "";
var phone = "";
//sql2比对涉毒人员表单数据
var sql2 = "select * from tlk_drugMan where ITEM_DOCUMENTID = '" + idnumber + "' ORDER BY created DESC limit 1";
println("身份证号码：" + idnumber);
println("sql2：" + sql2);
var query2 = queryByDSName(dsName(),sql2);
println("query2：" + query2);
//如果涉毒人员表单为空
if(query2 == "[]"){
addDrug(idnumber,securityName,domain_id,companyName,documentid,phone,drugRtn);//新增记录
}else{ //如果比对涉毒人员表不为空，进而比对所在职企业是否相同
//比对在职企业
for(var iterator = query2.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
domain_id1 = map1.get("item_domain_id");//获取公司id
companyName1 = map1.get("item_companyName");//获取公司名称
questionType = map1.get("item_questionType");//获取问题类型
compareTime = map1.get("item_compareTime");//获取旧纪录比对时间
}
//比对在职企业是否相同
println("domain_id1===2===" + domain_id1);
println("companyName1===2===" + companyName1);
println("参数公司名称：" + companyNameO);
println("参数公司id：" + domainid);
println("参数idnumber：" + idnumber);
if(domainid.equals(domain_id1) && companyNameO.equals(companyName1)){ //在职企业相同
println("================");
if(drugRtn.equals(questionType)){ //比对问题类型相同
//企业与问题类型相同，更新比对时间
println("========更新比对时间========");
var updateSql = "update tlk_drugMan set item_lastCompareTime = '"+compareTime+"',item_compareTime = '"+format(getToday(),"yyyy-MM-dd HH:mm:ss")+"' where ITEM_DOCUMENTID = '"+idnumber+"'";
println("修改比对时间的sql" + updateSql);
updateByDSName(dsName(),updateSql);
}else{ //比对问题类型不相同
//新增记录
addDrug(idnumber,securityName,domain_id,companyName,documentid,phone,drugRtn);
}
}else{//在职企业不同
//新增记录
addDrug(idnumber,securityName,domain_id,companyName,documentid,phone,drugRtn);
}
}
}
//比对重点人员表单
if(!"".equals(importantRtn) && isNotNull(importantRtn)){
var securityName = "";
var domain_id = "";
var companyName = "";
var documentid = "";
var phone = "";
//sql1比对重点人员表单数据
var sql1 = "select * from tlk_importantman where ITEM_DOCUMENTID = '" + idnumber + "' ORDER BY created DESC limit 1";
println("身份证号码：" + idnumber);
println("sql1：" + sql1);
var query1 = queryByDSName(dsName(),sql1);
println("query1：" + query1);
//如果重点人员表单为空
if(query1 == "[]"){
addImportantMan(idnumber,securityName,domain_id,companyName,documentid,phone,importantRtn);//新增记录
}else{ //如果比对重点人员表不为空，进而比对所在职企业是否相同
//比对在职企业
var domain_id1 = "";//获取公司id
var companyName1 = "";//获取公司名称
var questionType = ""; //获取问题类型
var compareTime = ""; //获取旧纪录比对时间
for(var iterator = query1.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
domain_id1 = map1.get("item_domain_id");//获取公司id
companyName1 = map1.get("item_companyName");//获取公司名称
questionType = map1.get("item_questionType");//获取问题类型
compareTime = map1.get("item_compareTime");//获取旧纪录比对时间
}
//比对在职企业是否相同
println("domain_id1======" + domain_id1);
println("companyName1======" + companyName1);
println("参数公司名称：" + companyNameO);
println("参数公司id：" + domainid);
println("参数idnumber：" + idnumber);
if(domainid.equals(domain_id1) && companyNameO.equals(companyName1)){ //在职企业相同
println("================");
if(importantRtn.equals(questionType)){ //比对问题类型相同
//企业与问题类型相同，更新比对时间
println("========更新比对时间========");
var updateSql = "update tlk_importantman set item_lastCompareTime = '"+compareTime+"',item_compareTime = '"+format(getToday(),"yyyy-MM-dd HH:mm:ss")+"' where ITEM_DOCUMENTID = '"+idnumber+"'";
println("修改比对时间的sql" + updateSql);
updateByDSName(dsName(),updateSql);
}else{ //比对问题类型不相同
//新增记录
addImportantMan(idnumber,securityName,domain_id,companyName,documentid,phone,importantRtn);
}
}else{ //在职企业不同
//新增记录
addImportantMan(idnumber,securityName,domain_id,companyName,documentid,phone,importantRtn);
}
}
}
}
//更新保安员背景筛查比对时间
var updatetimeSql = "update tlk_securityman set item_lastCompareTime = '"+format(getToday(),"yyyy-MM-dd HH:mm:ss")+"' where ITEM_DOCUMENTID = '"+idnumber+"'";
println("修改比对时间的sql" + updatetimeSql);
updateByDSName(dsName(),updatetimeSql);
}catch(e){
println("函数库错误信息："+e);
//return e;
}
}
//在逃人员表单新增数据函数
function addEscape(idnumber,securityName,domain_id,companyName,documentid,phone,escapeRtn){
//查询对应数据，字段，insert
var selectSql = "select * from tlk_securityman where ITEM_DOCUMENTID = '" + idnumber + "'";
/* 查询：姓名securityName，所属企业item_companyName，身份证号item_documentid，
手机号item_phone
插入：姓名securityName，所属企业domain_id，身份证号documentID，问题类型questionType，
手机号phone,比对时间compareTime
*/
println("获取保安员信息sql：" + selectSql);
var query = queryByDSName(dsName(),selectSql);
println("获取query：" + query);
if (query!=null){
for(var iterator = query.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
println("在逃人员库selectSql结果集：" + map1);
securityName = map1.get("item_securityName");
domain_id = map1.get("item_domain_id");
companyName = map1.get("item_companyName");
documentid = map1.get("item_documentid");
phone = map1.get("item_phone");
}
}
/*
var registerpoliceidindex = "";
var selectSqls = "select * from tlk_setsupervise where item_domain_id = '"+domain_id+"' limit 1";
var querys = queryByDSName(dsName(),selectSqls);
if (querys!=null){
for(var iterator = querys.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
registerpoliceidindex = map1.get("item_registerpoliceidindex");
}
}
println("registerpoliceidindex:" + registerpoliceidindex);
*/
println("securityName ：" + securityName);
println("domain_id ：" + domain_id);
println("companyName ：" + companyName);
println("phone ：" + phone);
println("documentid ：" + documentid);
//插入在逃人员数据(插入到表单)
var process = getDocumentProcess();
var formService = getFormProcess();
var subform = formService.doView("__ovMcA0Xv3ZRp8VsCFpM"); //表单Id
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var questionType = escapeRtn;
doc.addStringItem("questionType",questionType);
doc.addStringItem("securityName",securityName);
doc.addStringItem("domain_id",domain_id);
doc.addStringItem("companyName",companyName);
doc.addStringItem("documentid",documentid);
doc.addStringItem("phone",phone);
//doc.addStringItem("registerpoliceidindex",registerpoliceidindex);
doc.addStringItem("compareTime",format(getToday(),"yyyy-MM-dd HH:mm:ss"));
doc.addStringItem("policeStatus","0");//新增时设置监管状态为未处理
println("插入测试：" + doc);
process.doCreate(doc);
//调用同步
try{
var docProcess = getDocumentProcess();
var form_id = getFormid();
var application_id = getApplication();
sendDateToqySystemByDoc2(doc,"__nGsPx71jDn3zzNbSCZP","__DXZvc8mnEmDqMARhK7G");
sendDateToJGSystemByDoc(doc,form_id,application_id);
}catch(e){
}
}
//涉毒人员表单新增数据函数
function addDrug(idnumber,securityName,domain_id,companyName,documentid,phone,drugRtn){
//查询对应数据，字段，insert
var selectSql = "select * from tlk_securityman where ITEM_DOCUMENTID = '" + idnumber + "'";
/* 查询：姓名securityName，所属企业item_companyName，身份证号item_documentid，
手机号item_phone
插入：姓名securityName，所属企业domain_id，身份证号documentID，问题类型questionType，
手机号phone,比对时间compareTime
*/
println("获取保安员信息sql：" + selectSql);
var query = queryByDSName(dsName(),selectSql);
println("获取query：" + query);
if (query!=null){
for(var iterator = query.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
println("涉毒人员库selectSql结果集：" + map1);
securityName = map1.get("item_securityName");
domain_id = map1.get("item_domain_id");
companyName = map1.get("item_companyName");
documentid = map1.get("item_documentid");
phone = map1.get("item_phone");
}
}
/*
var registerpoliceidindex = "";
var selectSqls = "select * from tlk_setsupervise where item_domain_id = '"+domain_id+"' limit 1";
var querys = queryByDSName(dsName(),selectSqls);
if (querys!=null){
for(var iterator = querys.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
registerpoliceidindex = map1.get("item_registerpoliceidindex");
}
}
println("registerpoliceidindex:" + registerpoliceidindex);
*/
println("securityName ：" + securityName);
println("domain_id ：" + domain_id);
println("companyName ：" + companyName);
println("phone ：" + phone);
println("documentid ：" + documentid);
//插入涉毒人员数据(插入到表单)
var process = getDocumentProcess();
var formService = getFormProcess();
var subform = formService.doView("__gwmsYV1yeFHTlLPuMzz"); //表单Id
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var questionType = drugRtn;
doc.addStringItem("questionType",questionType);
doc.addStringItem("drugerName",securityName);
doc.addStringItem("domain_id",domain_id);
doc.addStringItem("companyName",companyName);
doc.addStringItem("documentid",documentid);
doc.addStringItem("phone",phone);
//doc.addStringItem("registerpoliceidindex",registerpoliceidindex);
doc.addStringItem("compareTime",format(getToday(),"yyyy-MM-dd HH:mm:ss"));
doc.addStringItem("policeStatus","0");//新增时设置监管状态为未处理
println("插入测试：" + doc);
process.doCreate(doc)
println(process.doCreate(doc));
//调用同步
try{
var docProcess = getDocumentProcess();
var form_id = getFormid();
var application_id = getApplication();
sendDateToqySystemByDoc2(doc,"__ayxQHDgCgft8cKU690v","__DXZvc8mnEmDqMARhK7G");
sendDateToJGSystemByDoc(doc,form_id,application_id);
}catch(e){
}
}
//重点人员表单新增数据函数
function addImportantMan(idnumber,securityName,domain_id,companyName,documentid,phone,importantRtn){
//查询对应数据，字段，insert
var selectSql = "select * from tlk_securityman where ITEM_DOCUMENTID = '" + idnumber + "'";
/* 查询：姓名securityName，所属企业item_companyName，身份证号item_documentid，
手机号item_phone
插入：姓名securityName，所属企业domain_id，身份证号documentID，问题类型questionType，
手机号phone,比对时间compareTime
*/
println("获取保安员信息sql：" + selectSql);
var query = queryByDSName(dsName(),selectSql);
println("获取query：" + query);
if (query!=null){
for(var iterator = query.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
println("重点人员库selectSql结果集：" + map1);
securityName = map1.get("item_securityName");
domain_id = map1.get("item_domain_id");
companyName = map1.get("item_companyName");
documentid = map1.get("item_documentid");
phone = map1.get("item_phone");
}
}
/*
var registerpoliceidindex = "";
var selectSqls = "select * from tlk_setsupervise where item_domain_id = '"+domain_id+"' limit 1";
var querys = queryByDSName(dsName(),selectSqls);
if (querys!=null){
for(var iterator = querys.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
registerpoliceidindex = map1.get("item_registerpoliceidindex");
}
}
println("registerpoliceidindex:" + registerpoliceidindex);
*/
println("securityName ：" + securityName);
println("domain_id ：" + domain_id);
println("companyName ：" + companyName);
println("phone ：" + phone);
println("documentid ：" + documentid);
//插入重点人员数据(插入到表单)
var process = getDocumentProcess();
var formService = getFormProcess();
var subform = formService.doView("__38HWQpmVuW7sNdWBluk"); //表单Id
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var questionType = importantRtn;
doc.addStringItem("questionType",questionType);
doc.addStringItem("securityName",securityName);
doc.addStringItem("domain_id",domain_id);
doc.addStringItem("companyName",companyName);
doc.addStringItem("documentid",documentid);
doc.addStringItem("phone",phone);
doc.addStringItem("compareTime",format(getToday(),"yyyy-MM-dd HH:mm:ss"));
doc.addStringItem("policeStatus","0");//新增时设置监管状态为未处理
println("插入测试：" + doc);
process.doCreate(doc);
//调用同步
try{
var docProcess = getDocumentProcess();
var form_id = getFormid();
var application_id = getApplication();
sendDateToqySystemByDoc2(doc,"__CrVIR32eQhv9xvrEuYF","__DXZvc8mnEmDqMARhK7G");
sendDateToJGSystemByDoc(doc,form_id,application_id);
}catch(e){
}
}
//同步函数
//通知到企业
function sendDateToqySystemByDoc2(doc,form_id,application_id){
/*测试环境地址等配置*/
//定义同步相关变量
var COMPANY_IP = "http://117.78.35.63:8080/obpm"; //外部企业端ip地址
var IS_OUT = "NO"; //判断是否监管内网还是外网，YES 是外网，NO是内网
var MY_IP = "http://49.4.26.74:8010/obpm";//我的ip地址
var JIANGUAN_SYSTEMID = "__wGomeHJBz6CpLFCCl4y";//监管端系统ID
var JGWW_IP = "http://117.78.35.63:8060/obpm";//外网监管端地址
var REGIONID = "430000"; //区域ID
var TARGETSERVICEURL = "/bcxin/receiveData"; //数据摆渡调用接收接口
var MY_CALLBACKURL = "http://49.4.26.74:8010/obpm/bcxin/callBackData";//回调地址
/*正式环境地址等配置
var COMPANY_IP = "http://v5qy.baibaodun.cn/obpm"; //外部企业端ip地址
var IS_OUT = "NO"; //判断是否监管内网还是外网，YES 是外网，NO是内网
var MY_IP = "http://65.26.2.39/obpm";//我的ip地址
var JIANGUAN_SYSTEMID = "__wGomeHJBz6CpLFCCl4y";//监管端系统ID
var JGWW_IP = "http://113.246.57.21:7002/obpm";//外网监管端地址
var REGIONID = "430000"; //区域ID
var TARGETSERVICEURL = "/bcxin/receiveData"; //数据摆渡调用接收接口
var MY_CALLBACKURL = "http://65.26.2.39/obpm/bcxin/callBackData";//回调地址
*/
//NO是内网
var isOut = IS_OUT;
if(isOut=="YES"){
var URLConnector = new Packages.cn.myapps.util.http.HttpRequestUtil();
var domainid = getDomainid();
var applicationId = getApplication();
var formId = doc.getFormid();
var docid = doc.getId();
var domain_id = doc.getItemValueAsString("domain_id");
var srcApp = COMPANY_IP;
var userId = "";
var sql ="select domainid,item_systemAdmin from tlk_CompanyInformation where item_domain_id = '"+domain_id+"'";
var data = findBySQL(sql);
if(isNotNull(data)){
userId= data.getItemValueAsString("systemAdmin");
//println("userId=="+userId);
}else{
userId = "__A7yVvj33RRHsOLgvt0d";
}
var itemsMap = new Packages.com.alibaba.fastjson.JSONObject();
var userlist = createObject("java.util.ArrayList");
for(var iter=doc.getItems().iterator();iter.hasNext();){
var item=iter.next();
itemsMap.put(item.getName(),item.getValue() != null ? item.getValue() : "");
var formService = getFormProcess();
var form=formService.doView(doc.getFormid());
//println("form_id==>" +form_id);
//println("form==>" +form);
var field = form.findFieldByName(item.getName());
var simpleName ="";
if(isNotNull(field)){
simpleName =field.getClass().getSimpleName();
}
if(("AttachmentUploadField".equals(simpleName) || "ImageUploadField".equals(simpleName) ) && isNotNull(item.getValue())){
var JSONArray=new Packages.net.sf.json.JSONArray();
var JSONObject=new Packages.net.sf.json.JSONObject();
//println("item.getValue()==="+item.getValue());
var oldFileArr = JSONArray.fromObject(item.getValue());
for(var i=0 ;i
0