保存__pBoYCpGFR2fbXySQ9d8__DXZvc8mnEmDqMARhK7G11default0){
return "身份证为["+documentID+"]人员记录已经存在，不能重复添加！";
}
if(!isNotNull(jobType)) {
return "请选择职务！";
}else if (jobType.indexOf("3")>=0){
//获取数据id，校验自己id以外的是否已存在。
var sql2 = "SELECT * FROM tlk_managementlayer WHERE ITEM_JOBTYPE LIKE '%3%' and ITEM_IS_DELETE='0' AND domainid='"+domainid+"' and id != '"+doc.getId()+"'";
var nums=countBySQL(sql2);
if(nums>0){
return "法定代表人已存在，不能重复!";
}
}
var registerAddress="";
var institutional_code="";
var sql="SELECT o.name,t2.ITEM_CITYNAMEINDEX,o.institutional_code FROM obpm2.tenant_organizations o LEFT JOIN " +
" baibaodunflow.tlk_citylevel t2 ON o.supervise_region_code = t2.ITEM_NO where o.id='"+domainid+"' limit 1";
var datas = queryByDSName("baibaodunFlow",sql);
if(datas!="[]"){
var iterator = datas.iterator();
if (iterator.hasNext()){
var map1 = iterator.next();//取值
institutional_code= map1.get("institutional_code");
registerAddress= map1.get("ITEM_CITYNAMEINDEX");
domainName= map1.get("name");
}
println("查询"+domainid+"公司数据: {公司名称:"+domainName+",公司监管地区:"+registerAddress+",公司机构类型:"+institutional_code+"}");
if (!isNotNull(registerAddress)){
return "请先完善监管归属信息！";
}
if (!isNotNull(domainName)||!isNotNull(institutional_code)){
return "请先完善单位信息！";
}
var datetime="";
var sql = "SELECT * FROM obpm2.tenant_companies WHERE id = '" + domainid + "'";
println("9999999"+sql)
var datas = queryByDSName("obpm2",sql);
if(datas!="[]"){
var iterator = datas.iterator();
if (iterator.hasNext()){
var map1 = iterator.next();//取值
var date = map1.get("first_issue_service_permit"); // 获取日期对象
}
datetime = format(date, "yyyy-MM-dd"); // 格式化为目标格式
println("公司成立时间：" + datetime);
if (datetime.compareTo("2018-01-01") >= 0) {
println("公司成立时间在2018年1月1日之后，需要进行保安师校验");
if(registerAddress.indexOf("北京市")>=0 && institutional_code=="0102"){
if(isNotNull(jobType)&&((jobType.indexOf("1")>=0)||(jobType.indexOf("2")>=0)||(jobType.indexOf("3")>=0))){
var sql = "select '"+getDomainid()+"' as domainid,b.ITEM_securitycompany,b.ITEM_NAME,b.ITEM_DOCUMENTID " +
" from baibaodunflow.tlk_securitymastermanagement b"+
" where b.ITEM_NAME = '"+name+"' and b.ITEM_DOCUMENTID = '"+documentID+"'";
println("管理层sql："+sql);
var count = countBySQL(sql);
println("管理层sql查询数量："+count);
if(count==0){
return "["+name+"]不是保安师，请重新填写！";
}else{
var datas = queryByDSName("baibaodunFlow",sql);
for(var iterator = datas.iterator();iterator.hasNext();){
var map = iterator.next();//取值
var securitycompany= map.get("ITEM_securitycompany");
println("securitycompany----:"+securitycompany);
if(isNotNull(securitycompany) && !securitycompany.equals(domainName)){
return "["+name+"]保安师资质已被["+securitycompany+"]公司占用，请重新填写！";
}
}
}
}
}
}
else {
println("公司成立时间在2018年1月1日之前，直接通过校验");
return "";
}
}
}
})()]]>01__pBoYCpGFR2fbXySQ9d80falsefalsefalsefalse000false000falsetrue选择__ECz7njnDw9go5uV4wdl|