新审批
__JvOHkqjhV41mUo4ITRv
__JvOHkqjhV41mUo4ITRv
iscript
=0||rolename.indexOf("省厅")>=0||rolename.indexOf("核查人员")>=0){
sqlWhere= " AND 1 = 1";
}else{
sqlWhere= " and item_officePoliceAddressID in " + deptidsStr;
}
// 1保安培训公司许可审批
// var viewid1 = "__nCJzHFgeUqL4zPLZZTy";
// var link1 = getUrl.view( applicationid, viewid1 )+"&_backURL=../../../portal/good/closeTab.jsp";
/* var fuwu=0;
var sql1="select count(1)as item_fuwu from tlk_SecurityTrainingS where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
println("sql1======"+sql1);
var datas = queryByDSName("SecurityFlow",sql1);
if(datas!=null){
for(var iterator = datas.iterator();iterator.hasNext();){
var map1 = iterator.next();//取值
var fuwu= map1.get("item_fuwu");
}
}*/
// 1保安培训公司许可审批
/*var viewid1 = "__nCJzHFgeUqL4zPLZZTy";
var countNum1='100';
var sql1="select id,domainid from tlk_SecurityTrainingS where item_auditstatus ='3' "+sqlWhere;
println("sql1==========="+sql1);
var t_count1 = countBySQL(sql1);
println("t_count1=========="+t_count1);
if(t_count1 > 0) {
countNum1 = t_count1;
} */
var viewid1 = "__nCJzHFgeUqL4zPLZZTy";
var countNum1=100;
var sql1="select count(1)as item_fuwu from tlk_SecurityTrainingS where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
println("sql1==========="+sql1);
var t_count1 = queryByDSName("SecurityFlow",sql1);
println("t_count1=========="+t_count1);
if(t_count1.size() > 0) {
countNum1 = t_count1.get(0).get('item_fuwu');
}
// 2保安服务公司许可审批
var viewid2 = "__odnwF3kc5rTASq2mSfx";
var countNum2='100';
var sql2="select id,domainid from tlk_SecuritySeviceK where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
println("sql2==========="+sql2);
var t_count2 = countBySQL(sql2);
println("t_count2=========="+t_count2);
if(t_count2 > 0) {
countNum2 = t_count2;
}
// 3本市保安服务公司设立分公司审批表
var viewid3 = "__OKn6SkYi9wbwGhYCSuU";
var countNum3=0;
var sql3="select id,domainid from tlk_Establish where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
println("sql3==========="+sql3);
var t_count3 = countBySQL(sql3);
println("t_count3=========="+t_count3);
if(t_count3 > 0) {
countNum3 = t_count3;
}
// 4外省保安跨区服务设立分公司审批
var viewid4 = "__sgaCPSmp2kvruWAErWT";
var countNum4=0;
var sql4="select id,domainid from tlk_Crossr where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count4 = countBySQL(sql4);
if(t_count4 > 0) {
countNum4 = t_count4;
}
// 5 自行招用保安员单位撤销备案
var viewid5 = "__URg0Hb4bnxz174VTJTf"
var countNum5=0;
var sql5="select id,domainid from tlk_Revoke where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count5 = countBySQL(sql5);
if(t_count5 > 0) {
countNum5 = t_count5;
}
// 保安服务公司年度报告备案
/*var viewid6 = "__JIpUTyOi3rOkles3lSZ";
var countNum6=0;
var sql6="select id,domainid from tlk_YearReportApproval where item_auditstatus !='-1' and item_auditstatus !='-1'"+sqlWhere;
var t_count6 = countBySQL(sql6);
if(t_count6 > 0) {
countNum6 = t_count6;
} */
// 自行招用保安员单位备案
var viewid7 = "__bGrKKyJ4vlX8xUO3Tx2";
var countNum7=0;
var sql7="select id,domainid from tlk_Recruitment where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count7 = countBySQL(sql7);
if(t_count7 > 0) {
countNum7 = t_count7;
}
//变更
/*var viewid8 = "__5mrHduDMJ7oq90zQAVz";
var countNum8=0;
//var sql8 = "select id,domainid ,item_officePoliceAddressID from tlk_LegalChange where item_auditstatus !='-1' "+sqlWhere;
/* var sql8= "select id,domainid,item_officePoliceAddressID from (";
sql8 += "select id,domainid ,item_officePoliceAddressID from tlk_LegalChange where item_auditstatus !='-1' "
sql8 += "UNION ALL ";
sql8 += "select id,domainid,item_officePoliceAddressID from tlk_scope_business where item_auditstatus !='-1' "
sql8 += "UNION ALL ";
sql8 += "select id,domainid ,item_officePoliceAddressID from tlk_scope_business2 where item_auditstatus !='-1' " ;
sql8 += "UNION ALL ";
sql8 += "select id,domainid ,item_officePoliceAddressID from tlk_scope_business3 where item_auditstatus !='-1'";
sql8 += "UNION ALL ";
sql8 += "select id,domainid ,item_officePoliceAddressID from tlk_scope_business4 where item_auditstatus !='-1' " ;
sql8 += " ) A where 1=1 "+sqlWhere; */
var sql8="SELECT '"+getDomainid()+"'as item_domainid,id, domainid,item_companyName,item_securityTrainPermitNo,item_address,ITEM_AUDITSTATUS,AUDITORNAMES,STATELABEL FROM (SELECT id, domainid,item_companyName,item_securityTrainPermitNo,item_address,ITEM_AUDITSTATUS,AUDITORNAMES,STATELABEL FROM tlk_LegalChangeK WHERE statelabel = '' AND item_auditstatus = '3' AND domainid = '"+getDomainid()+"' UNION ALL SELECT id, domainid,item_companyName,item_securityTrainPermitNo,item_address,ITEM_AUDITSTATUS,AUDITORNAMES,STATELABEL FROM tlk_scope_nameChangeS WHERE statelabel= '' "+
" AND item_auditstatus = '3' AND domainid = '"+getDomainid()+"' UNION ALL SELECT id, domainid,item_companyName,item_securityTrainPermitNo,item_address,ITEM_AUDITSTATUS,AUDITORNAMES,STATELABEL FROM tlk_CCmoneyChangeK WHERE statelabel = '' AND item_auditstatus = '3' AND domainid = '"+getDomainid()+"' UNION ALL SELECT id, domainid,item_companyName,item_securityTrainPermitNo,item_address,ITEM_AUDITSTATUS,AUDITORNAMES,STATELABEL FROM "+
" tlk_scope_addressChangeK WHERE statelabel = '' AND item_auditstatus = '3' AND domainid = '"+getDomainid()+"' UNION ALL SELECT id, domainid,item_companyName,item_securityTrainPermitNo,item_address,ITEM_AUDITSTATUS,AUDITORNAMES,STATELABEL FROM tlk_scope_businessK WHERE statelabel = '' AND item_auditstatus = '3' AND domainid = '"+getDomainid()+"' ) A WHERE 1 = 1 "+sqlWhere;
/*println("sql8============================"+sql8);
var t_count8 = countBySQL(sql8);
if(t_count8 > 0) {
countNum8 = t_count8;
}
*/
// 2法人变更
var viewid9 = "__FkTzarfOcLwjP7LL6AU";
var countNum9=0;
var sql9="select id,domainid from tlk_LegalChangeK where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
println("sql9==========="+sql9);
var t_count9 = countBySQL(sql9);
println("t_count9=========="+t_count9);
if(t_count9 > 0) {
countNum9 = t_count9;
}
// 项目名称
var viewid10 = "__3T8Ajt1esXLFGX5QFph";
var countNum10=0;
var sql10="select id,domainid from tlk_scope_nameChangeS where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count10 = countBySQL(sql10);
if(t_count10 > 0) {
countNum10 = t_count10;
}
// 资金变更
var viewid11 = "__3DF85WUuNWYq3Z4Ga6M";
var countNum11=0;
var sql11="select id,domainid from tlk_CCmoneyChangeK where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count11 = countBySQL(sql11);
if(t_count11 > 0) {
countNum11 = t_count11;
}
// 地址变更
var viewid12 = "__FtK4LmUd2qFwpwkzUoL";
var countNum12=0;
var sql12="select id,domainid from tlk_scope_addressChangeK where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count12 = countBySQL(sql12);
if(t_count12 > 0) {
countNum12 = t_count12;
}
// 范围变更
var viewid13 = "__kR5Q2S4kYLYqaTWxaMx";
var countNum13=0;
var sql13="select id,domainid from tlk_scope_businessK where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count13 = countBySQL(sql13);
if(t_count13 > 0) {
countNum13 = t_count13;
}
// 培训法人变更
var viewid14 = "__dW4pKW23AI8obmTno5N";
var countNum14=0;
var sql14="select id,domainid from tlk_RecordChangeApproval where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count14 = countBySQL(sql14);
if(t_count14 > 0) {
countNum14 = t_count14;
}
// 培训名称变更
var viewid15 = "__GFwDgSYhBp4XsHlOgnR";
var countNum15=0;
var sql15="select id,domainid from tlk_NameChangeProgram where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count15 = countBySQL(sql15);
if(t_count15 > 0) {
countNum15 = t_count15;
}
// 培训资金变更
var viewid16 = "__XsUrI18dsSjx1DkV86f";
var countNum16=0;
var sql16="select id,domainid from tlk_registeredCapital where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count16 = countBySQL(sql16);
if(t_count16 > 0) {
countNum16 = t_count16;
}
// 培训地址变更
var viewid17 = "__2B3tQvtaCEThX9nHYmh";
var countNum17=0;
var sql17="select id,domainid from tlk_registeredAddress where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count17 = countBySQL(sql17);
if(t_count17 > 0) {
countNum17 = t_count17;
}
// 培训范围变更
var viewid18 = "__C6yCvz4IYVSSKRZYLNb";
var countNum18=0;
var sql18="select id,domainid from tlk_businessScope where item_auditstatus ='3' and domainid = '"+getDomainid()+"' "+sqlWhere;
var t_count18 = countBySQL(sql18);
if(t_count18 > 0) {
countNum18 = t_count18;
}
var html="";
html+= ""+fuwu+"培训许可 | ";
// html+= "
"+fuwu+"培训许可 | ";
//2服务许可
html+= ""+countNum2+"服务许可 | ";
//3服务分公司
html+= ""+countNum3+"服务分公司 | ";
//4 跨区分公司
html+= ""+countNum4+"跨区分公司 | ";
//5 撤销备案
html+= ""+countNum5+"撤销备案 | ";
//6 年度报告
// html+= ""+countNum6+"年度报告 | ";
//7 自行招用保安员单位备案
html+= ""+countNum7+"自行招用备案 | ";
//8 变更
//html+= ""+countNum8+"变更 | ";
//法人变更
html+= ""+countNum9+"法人变更 | ";
//培训范围变更
html+= ""+countNum18+"培训范围变更 | ";
html+= "
| |
";
//项目变更
html+= ""+countNum10+"名称变更 | ";
//资金变更
html+= ""+countNum11+"资金变更 | ";
//范围变更
html+= ""+countNum13+"范围变更 | ";
//地址变更
html+= ""+countNum12+"地址变更 | ";
//培训法人变更
html+= ""+countNum14+"培训法人变更 | ";
//培训名称变更
html+= ""+countNum15+"培训名称变更 | ";
//培训资金变更
html+= ""+countNum16+"培训资金变更 | ";
//培训地址变更
html+= ""+countNum17+"培训地址变更 |
";
//培训范围变更
//html+= ""+countNum18+"培训范围变更 | ";
html+="
";
return html;
})()
]]>
0
true
true
{"icon":"undefined","icontype":"font", "fontUrl":"undefined", "iconFontColor":"#000"}
font
1
#000
false
0
0
false