optsLib __8daFPzFlLmRvYJij9jy __8daFPzFlLmRvYJij9jy 0){ for(var iter=datart.iterator();iter.hasNext();){ var docvo=iter.next(); opts.add(docvo.getItemValueAsString("itemValue"),docvo.getItemValueAsString("itemKey")); } } return opts; } /** 00 在逃、吸毒、重点人员监管里处理状态 **/ function getproblem_Options(codeType,Checkbox){ var opts=createOptions(); var sql = "select '"+getDomainid()+"' as domainid, codeType as item_codeType, codeDesc as item_codeDesc,itemKey as item_itemKey,itemValue as item_itemValue, orderNO FROM Sys_Options where codeType = '"+codeType+"' order by orderNO "; var datart = queryBySQLWithCache(sql); if(Checkbox==null&&codeType!="dispose" ){ opts.add("",""); } if(datart.size()>0){ for(var iter=datart.iterator();iter.hasNext();){ var docvo=iter.next(); opts.add(docvo.getItemValueAsString("itemValue"),docvo.getItemValueAsString("itemKey")); } } return opts; } /** 01 保安监管的字典库 **/ function getSys_Options(codeType,Checkbox){ var opts=createOptions(); var sql = "select '"+getDomainid()+"' as domainid, codeType as item_codeType, codeDesc as item_codeDesc,itemKey as item_itemKey,itemValue as item_itemValue, orderNO FROM Sys_Options where codeType = '"+codeType+"' order by orderNO "; var datart = queryBySQLWithCache(sql); if(Checkbox==null){ opts.add("",""); } if(datart.size()>0){ for(var iter=datart.iterator();iter.hasNext();){ var docvo=iter.next(); opts.add(docvo.getItemValueAsString("itemValue"),docvo.getItemValueAsString("itemKey")); } } return opts; } /** 03 单选是否选择 **/ function getYesOrNo(){ var opts=createOptions(); opts.add("是","1"); opts.add("否","0"); return opts; } /** 04 机构类型 **/ function getOfficeType(){ var opts=createOptions(); opts.add("保安协会","0101"); opts.add("保安服务公司","0102"); opts.add("保安培训单位","0103"); opts.add("自行招用保安单位","0104"); return opts; } // 05 普通保安服务公司设立许可/武装守护押运保安服务公司设立许可/中外合资经营、中外合作经营或外资独资经营保安服务公司设立许可 function getSevicePermitType(){ var opts=createOptions(); opts.add("请选择",""); opts.add("普通保安服务公司设立许可","1"); opts.add("武装守护押运保安服务公司设立许可","2"); opts.add("中外合资经营、中外合作经营或外资独资经营保安服务公司设立许可","3"); return opts; } // 06 下拉单选:企业根据意见处理、辞退、留用、企业自行处理 function getPoliceSuggestedTreatment(){ var opts=createOptions(); opts.add("请选择",""); opts.add("企业根据意见处理","企业根据意见处理"); opts.add("辞退","辞退"); opts.add("留用","留用"); opts.add("企业自行处理","企业自行出处理"); return opts; } //07 主项信息不符合、涉军人员、犯罪、吸毒、抢劫犯、在逃、流浪、一级监控人员、重点人员 function getQuestionType(){ var opts=createOptions(); opts.add("请选择",""); opts.add("主项信息不符合","1"); opts.add("涉军人员","2"); opts.add("犯罪","3"); opts.add("吸毒","4"); opts.add("抢劫犯","5"); opts.add("在逃","6"); opts.add("流浪","7"); opts.add("一级监控人员","8"); opts.add("重点人员","9"); return opts; } /** 08 证书类型 **/ function getCertificateType(){ var opts=createOptions(); opts.add("保安资格证","1"); opts.add("保安等级证","2"); opts.add("保安持枪证","3"); return opts; } /** 09 人员类别 **/ function getJobType2(){ var opts=createOptions(); opts.add("请选择",""); opts.add("一般人员","0"); opts.add("普通保安员","1"); return opts; } /** 10 是否为分/子公司 **/ function getIsSub(){ var opts=createOptions(); opts.add("请选择",""); opts.add("否","1"); opts.add("分公司","2"); opts.add("子公司","3"); return opts; } /** 11 获取地区 **/ function getRegion(){ var opts=createOptions(); opts.add("请选择",""); var sql="select '"+getDomainid()+"' as domainid,item_region FROM organizationauth.tlk_RegionSystem"; var datart=queryBySQL(sql); if(datart!=null){ for(var iter=datart.iterator();iter.hasNext();){ var docvo=iter.next(); opts.add(docvo.getItemValueAsString("region"),docvo.getItemValueAsString("region")); } } return opts; } /** 12 保安服务公司类型 **/ function getSecurityType(){ var opts=createOptions(); opts.add("普通保安服务公司","1"); opts.add("武装守护押运保安服务公司","2"); opts.add("中外合资经营、中外合作经营或外资独资经营保安服务公司","3"); return opts; } /** 13 等级证申报状态 **/ function getApprovalState(){ var opts=createOptions(); opts.add("请选择",""); opts.add("申报中","0"); opts.add("申报通过","1"); opts.add("申报不通过","2"); opts.add("申报撤销","3"); opts.add("审批中","4"); return opts; } /** 14 背景筛查状态 **/ function getCensorState(){ var opts=createOptions(); opts.add("请选择",""); opts.add("审核中","0"); opts.add("正常","1"); opts.add("关注","2"); opts.add("申诉通过","3"); opts.add("申诉不通过","4"); opts.add("申诉中","5"); return opts; } /** 15 实习状态 **/ function getPracticeState(){ var opts=createOptions(); opts.add("请选择",""); opts.add("实习中","0"); opts.add("实习完成","1"); return opts; } /** 16 材料审核状态 **/ function getCheckState(){ var opts=createOptions(); opts.add("请选择",""); opts.add("未审核","0"); opts.add("审核通过","1"); opts.add("审核不通过","2"); opts.add("审核中","3"); opts.add("-","4");//自然人 return opts; } // 17 户籍类型 function getHouseholdType(){ var opts=createOptions(); opts.add("请选择",""); opts.add("农村","1"); opts.add("城镇","2"); return opts; } //18 户籍所在地类型 function getresidentPlaceType(){ var opts=createOptions(); opts.add("请选择",""); opts.add("本市","1"); opts.add("外埠","2"); return opts; } //19 社保项目 function getSocialInsuranceProject(){ var opts=createOptions(); opts.add("请选择",""); opts.add("养老保险","1"); opts.add("医疗保险","2"); opts.add("失业保险","3"); opts.add("工伤保险","4"); opts.add("生育保险","5"); return opts; } function getSex(){ var opts=createOptions(); opts.add("请选择",""); opts.add("男","1"); opts.add("女","2"); return opts; } // 4国籍/地区 国家 function getNationality(){ var opts=createOptions(); opts.add("请选择",""); var sql="select '"+getDomainid()+"' AS domainid,orderno as item_orderno,name as item_name FROM SYS_Nationality ORDER BY orderno"; var datart=queryBySQLWithCache(sql); if(datart!=null){ for(var iter=datart.iterator();iter.hasNext();){ var docvo=iter.next(); opts.add(docvo.getItemValueAsString("name"),docvo.getItemValueAsString("name")); } } return opts; } //12 学历 function getEducation(){ var opts=createOptions(); opts.add("请选择",""); opts.add("小学","1"); opts.add("初中","2"); opts.add("高中","3"); opts.add("中专","4"); opts.add("大专","5"); opts.add("本科","6"); opts.add("硕士研究生","7"); opts.add("博士","8"); opts.add("博士后","9"); opts.add("其他","10"); return opts; } //11 血型 function getBloodType(){ var opts=createOptions(); opts.add("请选择",""); opts.add("A","A"); opts.add("B","B"); opts.add("O","O"); opts.add("AB","AB"); return opts; } //10 民族 function getNation(){ var opts=createOptions(); opts.add("请选择",""); var sql="select '"+getDomainid()+"' AS domainid,orderno as item_orderno,name as item_name FROM SYS_Nation ORDER BY orderno"; var datart=queryBySQLWithCache(sql); if(datart!=null){ for(var iter=datart.iterator();iter.hasNext();){ var docvo=iter.next(); opts.add(docvo.getItemValueAsString("name"),docvo.getItemValueAsString("name")); } } return opts; } //9 政治面貌 function getPoliticalOutlook(){ var opts=createOptions(); opts.add("请选择",""); opts.add("群众","13"); opts.add("中共党员","01"); opts.add("中共预备党员","02"); opts.add("共青团员","03"); opts.add("民革会员","04"); opts.add("民盟盟员","05"); opts.add("民建会员","06"); opts.add("民进会员","07"); opts.add("农工党党员","08"); opts.add("致公党党员","09"); opts.add("九三学社社员","10"); opts.add("台盟盟员","11"); opts.add("无党派民主人士","12"); return opts; } /* 驻勤点类型 */ function StationYypeList(){ var opts = createOptions(); opts.add("请选择分类",""); opts.add("党政机关","01"); opts.add("中学(公立)","02"); opts.add("中学(私立)","22"); opts.add("小学(公立)","03"); opts.add("小学(私立)","23"); opts.add("幼儿园(公立)","04"); opts.add("幼儿园(私立)","24"); opts.add("医疗机构(一级)","05"); opts.add("医疗机构(二级)","25"); opts.add("医疗机构(三级)","26"); opts.add("高等院校","06"); opts.add("公交安全","07"); //opts.add("轨道交通","08"); opts.add("娱乐场所","09"); opts.add("金融网点(银行)","10"); opts.add("金融网点(证券)","27"); opts.add("酒店餐饮","11"); opts.add("商市场","12"); opts.add("写字楼","13"); opts.add("公园景区","14"); opts.add("园区","15"); opts.add("文化中心","16"); opts.add("体育场馆","17"); opts.add("会展中心","18"); opts.add("企事业单位(国企)","19"); opts.add("企事业单位(央企)","28"); opts.add("企事业单位(私企)","29"); opts.add("居民社区","20"); opts.add("乡镇街道","21"); opts.add("公交线路","30"); opts.add("公交场站","31"); opts.add("轨道线路","32"); opts.add("轨道安检","33"); opts.add("轨道乘务","34"); opts.add("重点站区 ","35"); return opts; } /** 通用:获取下级监管机构 */ function getSubordinateRegulatorId(regulatorId,dbName){ try { println("获取"+regulatorId+"下级监管机构,数据库为:organizationAuth") if (regulatorId != null && regulatorId != ''&& dbName != null && dbName != ''){ //var subordinateRegulatorIds="("; var subordinateRegulatorIds="('"+regulatorId+"'"; regulatorId=regulatorId.replace("_","\\_"); var regulatorSql = "SELECT '" + getDomainid() + "' AS domainid,id,id as item_id,ITEM_CODE FROM " + " organizationAuth.tlk_departmentlevel WHERE ITEM_INDEXCODE like '%" + regulatorId + "\\_\\_\\_%';"; println("获取下级监管机构SQL ===>" + regulatorSql); var datas = queryByDSName("organizationAuth", regulatorSql); if (isNotNull(datas)&&datas!="[]") { for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 var code= map1.get("ITEM_CODE"); /*if(iterator.hasNext()){ subordinateRegulatorIds+="'"+code+"',"; }else{ subordinateRegulatorIds+="'"+code+"'"; }*/ subordinateRegulatorIds+=",'"+code+"'"; } } subordinateRegulatorIds+=")"; println("获取"+regulatorId+"下级监管机构,结果:"+subordinateRegulatorIds); return subordinateRegulatorIds; } }catch (e){ println("获取下级监管机构异常"+e) } } /** 通用:获取当前层级监管机构名称 */ function getRegulatorName(regulatorId,dbName){ try { if (regulatorId != null && regulatorId != ''&& dbName != null && dbName != ''){ var regulatorSql = "SELECT '" + getDomainid() + "' AS domainid,id,id as item_id,ITEM_CODE,ITEM_NAME FROM " + " organizationAuth.tlk_departmentlevel WHERE ITEM_CODE = '" + regulatorId + "';"; println("获取当前层级监管机构名称SQL ===>" + regulatorSql); var datas = queryByDSName("organizationAuth", regulatorSql); if (isNotNull(datas)&&datas!="[]") { var iterator = datas.iterator(); if(iterator.hasNext()){ var map1 = iterator.next();//取值 var code= map1.get("ITEM_NAME"); return code; } } return ""; } }catch (e){ println("获取当前层级监管机构名称"+e) } } ]]> 90