保安员证核发（政务网同步数据给企业端）
__KDXZvc8mnEmDqMARhK7G
__KDXZvc8mnEmDqMARhK7G
published
UTF-8
post
/updateOrCreated/certificateservice
;企业端的api
json
0){
var updateSql="update tlk_certificateservice set "+
"item_name='"+name+"',"+
"item_phone='"+phone+"',"+
"item_document_id='"+document_id+"',"+
"item_education_paper='"+education_paper_new+"',"+
"item_examine_body='"+examine_body_new+"',"+
"item_id_card_file='"+id_card_file_new+"',"+
"item_exam_site_region='"+exam_site_region+"',"+
"item_exam_site_id='"+exam_site_id+"',"+
"item_train_name='"+train_name+"',"+
"item_train_id='"+train_id+"',"+
"item_apply_area='"+apply_area+"',"+
"item_registerPoliceAddress='"+registerPoliceAddress+"',"+
"item_registerPoliceAddressIndex='"+registerPoliceAddressIndex+"',"+
"item_certificate_address='"+certificate_address+"',"+
"item_contract_name='"+contract_name+"',"+
"item_registerPoliceAddressID='"+registerPoliceAddressID+"',"+
"item_contract_phone='"+contract_phone+"',"+
"item_auditStatus='"+auditStatus+"',"+
"item_staging='"+staging+"',"+
"created='"+created+"',"+
"LASTMODIFIED='"+LASTMODIFIED+"',"+
"domainid='"+domainid+"',"+
"author='"+author+"',"+
"item_apply_status='',"+
"item_rejectReason=''"+
" where id='"+id+"'";
println(updateSql);
updateByDSName("securitygovernment",updateSql);
}
}
var insertSql="INSERT INTO securitygovernment.tlk_certificateservice ("+
"`ID`,"+
"`ITEM_name`,"+
"`ITEM_phone`,"+
"`ITEM_document_id`,"+
"`ITEM_education_paper`,"+
"`ITEM_examine_body`,"+
"`item_id_card_file`,"+
"`ITEM_exam_site_region`,"+
"`ITEM_exam_site_id`,"+
"`ITEM_train_name`,"+
"`ITEM_train_id`,"+
"`ITEM_apply_area`,"+
"`ITEM_registerPoliceAddress`,"+
"`ITEM_registerPoliceAddressIndex`,"+
"`ITEM_certificate_address`,"+
"`ITEM_contract_name`,"+
"`ITEM_registerPoliceAddressID`,"+
"`ITEM_contract_phone`,"+
"`ITEM_auditStatus`,"+
"`ITEM_STAGING`,"+
"`CREATED`,"+
"`LASTMODIFIED`,"+
"`DOMAINID`,"+
"`author`,"+
"`FORMID`,"+
"`APPLICATIONID`"+
") values ";
if(insertnum==1){
insertSql+=valuseSql;
insertByDSName("securitygovernment",insertSql);
}
var result = new Packages.java.util.HashMap(); //创建指定类对象
result.put("success","1");
result.put("msg","created,success！！");
result.put("data",id);
return result;
} catch (error) {
var result = new Packages.java.util.HashMap(); //创建指定类对象
result.put("success","0");
result.put("msg","缴费失败请联系管理员！！"+error+insertSql);
return result;
}
})()
]]>