getDomainInformation
__K9C0HmAjnqJZgTI2sjd
__K9C0HmAjnqJZgTI2sjd
: " + sql );
var datas= queryByDSName(this.dsName2,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var process = getDocumentProcess();
var formService = getFormProcess();
var subform = formService.doView("__3emSFNy8kXvsZexxD5i");//目标表单
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var data = iter.next( );
var customerOldId = data.get("ID");
doc.addStringItem("customerOldId",customerOldId); //客户原来的id
var customerName = data.get("NAME");
doc.addStringItem("customerName",customerName); //客户名
println( "customerName----->: " + customerName );
var field14 = data.get("FIELD14");
doc.addStringItem("field14",field14); //行业类型
var field15 = data.get("FIELD15");
doc.addStringItem("field15",field15); //机构类型
var field12 = data.get("FIELD12");
doc.addStringItem("field12",field12); //注册地址
var field13 = data.get("FIELD13");
doc.addStringItem("field13",field13); //经营地址
process.doCreate(doc); //写入数据
}
return "addCustomer success";
},
//获取基础信息视图
getView:function(domainid,wheresql){
//var sql = "SELECT ID, '" + domainid + "' AS DOMAINID, ID AS ITEM_CUSTOMEROLDID, NAME AS ITEM_CUSTOMERNAME, FIELD12 AS ITEM_FIELD12, FIELD13 AS ITEM_FIELD13, FIELD14 AS ITEM_FIELD14, FIELD15 AS ITEM_FIELD15 FROM " + this.dsName2 + ".t_domain WHERE NAME NOT LIKE '%测试%' AND NAME NOT LIKE '%test%' AND NAME NOT LIKE '%bcx%'";
var sql = " SELECT a.ID, '" + domainid + "' AS DOMAINID, a.ID AS ITEM_CUSTOMEROLDID, a.NAME AS ITEM_CUSTOMERNAME, CONCAT(c.place_of_business_province_name, ' ', c.place_of_business_city_name,' ',c.place_of_business_district_name) AS ITEM_FIELD13, CONCAT( c.place_of_register_province_name, ' ', c.place_of_register_city_name,' ',c.place_of_register_district_name ) AS ITEM_FIELD12, c.industry_code AS ITEM_FIELD14, c.institutional_code AS ITEM_FIELD15 FROM " + this.dsName2 + ".t_domain a LEFT JOIN " + this.dsName3 + ".tlk_companyinformation b ON a.id = b.DOMAINID LEFT JOIN " + this.dsName2 + ".tenant_organizations c ON c.id =a.id WHERE a.NAME NOT LIKE '%测试%' AND a.NAME NOT LIKE '%test%' AND a.NAME NOT LIKE '%bcx%' ";
//展示测试数据库
//var sql = "SELECT ID, '" + domainid + "' AS DOMAINID, ID AS ITEM_CUSTOMEROLDID, NAME AS ITEM_CUSTOMERNAME, FIELD12 AS ITEM_FIELD12, FIELD13 AS ITEM_FIELD13, FIELD14 AS ITEM_FIELD14, FIELD15 AS ITEM_FIELD15 FROM " + this.dsName2 + ".t_domain WHERE 1=1 ";
sql += wheresql;
return sql;
},
//获取监管归属
getJianguanguishu:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT ITEM_REGISTERPOLICEADDRESS FROM tlk_setsupervise WHERE DOMAINID = '" + customerOldId + "'";
println( "获取监管归属---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var REGISTERPOLICEADDRESS = data.get("ITEM_REGISTERPOLICEADDRESS");
return REGISTERPOLICEADDRESS;
}
}
},
//获取股权比例
guquanbili:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT SUM(ITEM_STOCKPROPORTION) AS ITEM_STOCKPROPORTION FROM tlk_shareholderinformation WHERE DOMAINID = '" + customerOldId + "'";
println( "获取股权比例---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var STOCKPROPORTION = data.get("ITEM_STOCKPROPORTION");
return STOCKPROPORTION;
}
}
},
//获取管理层信息
guanlicengxinxi:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT GROUP_CONCAT(ITEM_JOBTYPE Separator ';' ) AS ITEM_JOBTYPE FROM tlk_managementlayer WHERE DOMAINID = '" + customerOldId + "'";
println( "获取管理层信息---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var JOBTYPE = data.get("ITEM_JOBTYPE");
return JOBTYPE;
}
}
},
//获取海外经营信息
haiwaijingyingxinxi:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT ID FROM tlk_overseasoperation WHERE DOMAINID = '" + customerOldId + "'";
println( "获取海外经营信息---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ID = data.get("ID");
return ID;
}
}
},
//获取单位信息
danweixinxi:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "select domainid,id from tlk_CompanyInformation WHERE DOMAINID = '" + customerOldId + "'";
println( "获取单位信息---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var id = data.get("id");
return id;
}
}
},
//获取保安员总数
securitySum:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT count(1) as ITEM_SUM from " + this.dsName2 + ".tenant_employees where organization_id = '"+customerOldId+"' and occupation_type = '1' and STATUS = '0'";
println( "获取保安员总数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var SUM = data.get("ITEM_SUM");
return SUM;
}
}
},
//获取核验状态
heyan:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = " SELECT b.checked_status,count(1) as count from tenant_employees a join tenant_users b on a.tenant_user_id = b.id where organization_id = '"+customerOldId+"' and STATUS = 0 and occupation_type = 1 GROUP BY b.checked_status";
println( "获取股权比例---sql------>: " + sql );
var None="无"
var Matched="无"
var Commit="无"
var datas= queryByDSName(this.dsName2,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var checked_status = data.get("checked_status");
var count = data.get("count");
if(checked_status=="0"){//未提交
None = (count==0)?'无':count
}
if(checked_status=="1"){//已核验
Matched=(count==0)?'无':count
}
if(checked_status=="2"){//已提交
Commit=(count==0)?'无':count
}
}
return "未提交: "+None+" | 已核验: "+Matched+" | 已提交: "+Commit;
}
},
//获取一般职员核验状态
checkStatus:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = " SELECT b.checked_status,count(1) as count from tenant_employees a join tenant_users b on a.tenant_user_id = b.id where organization_id = '"+customerOldId+"' and STATUS = 0 and occupation_type = 0 GROUP BY b.checked_status";
println( "获取股权比例---sql------>: " + sql );
var None="无"
var Matched="无"
var Commit="无"
var datas= queryByDSName(this.dsName2,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var checked_status = data.get("checked_status");
var count = data.get("count");
if(checked_status=="0"){//未提交
None = (count==0)?'无':count
}
if(checked_status=="1"){//已核验
Matched=(count==0)?'无':count
}
if(checked_status=="2"){//已提交
Commit=(count==0)?'无':count
}
}
return "未提交: "+None+" | 已核验: "+Matched+" | 已提交: "+Commit;
}
},
//获取认证状态
renzheng:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT b.authenticated_status,count(1) as count from tenant_employees a join tenant_users b on a.tenant_user_id = b.id where organization_id = '"+customerOldId+"' and STATUS = 0 and occupation_type = 1 GROUP BY b.authenticated_status";
println( "获取认证状态---sql------>: " + sql );
var rz="无"
var wrz=0
var datas= queryByDSName(this.dsName2,sql);
var rtn = "";
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var checked_status = data.get("authenticated_status");
var count = data.get("count");
count=Number(count)
if(checked_status=="0"||checked_status=="1"||checked_status=="2"){//未认证
wrz+=count
}
if(checked_status=="3"){//已认证
rz=count
}
}
if(wrz==0){
wrz="无"
}
return "已认证:" + rz + " | 未认证: " +wrz;
}
},
//获取一般职员认证状态
authentication:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT b.authenticated_status,count(1) as count from tenant_employees a join tenant_users b on a.tenant_user_id = b.id where organization_id = '"+customerOldId+"' and STATUS = 0 and occupation_type = 0 GROUP BY b.authenticated_status";
println( "获取认证状态---sql------>: " + sql );
var rz="无"
var wrz=0
var datas= queryByDSName(this.dsName2,sql);
var rtn = "";
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var checked_status = data.get("authenticated_status");
var count = data.get("count");
count=Number(count)
if(checked_status=="0"||checked_status=="1"||checked_status=="2"){//未认证
wrz+=count
}
if(checked_status=="3"){//已认证
rz=count
}
}
if(wrz==0){
wrz="无"
}
return "已认证:" + rz + " | 未认证: " +wrz;
}
},
//获取驻勤点关联状态
zhuqindian:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(1) as ITEM_SUM from (SELECT COUNT(1) FROM obpm2.tenant_users c LEFT JOIN obpm2.tenant_employees a ON c.id = a.tenant_user_id LEFT JOIN obpm2.tenant_user_credentials b ON b.id = c.selected_credential_id AND b.credential_type < 7 LEFT JOIN obpm2.tenant_departments d ON a.department_id = d.id LEFT JOIN tlk_attendance_site_person_info e ON a.organization_id = e.DOMAINID AND b.number = e.ITEM_DOCUMENTID LEFT JOIN tlk_attendance_site_base_info f ON f.id = e.ITEM_ATTENDANCESITEID WHERE a.organization_id = '"+customerOldId+"' AND a.STATUS = '0' AND f.ITEM_attendanceSiteState = '生效' AND a.occupation_type = '1' AND b.credential_type <= 7 GROUP BY a.id)u"
println( "获取有关联驻勤点关联状态---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
var rtny = 0;
var rtnn = 0;
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var rtny = data.get("ITEM_SUM");
}
var cql = "SELECT COUNT(1) as ITEM_SUM FROM (SELECT COUNT(1) FROM obpm2.tenant_users c LEFT JOIN obpm2.tenant_employees a ON c.id = a.tenant_user_id LEFT JOIN obpm2.tenant_user_credentials b ON b.id = c.selected_credential_id AND b.credential_type < 7 LEFT JOIN obpm2.tenant_departments d ON a.department_id = d.id LEFT JOIN tlk_attendance_site_person_info e ON a.organization_id = e.DOMAINID AND b.number = e.ITEM_DOCUMENTID LEFT JOIN tlk_attendance_site_base_info f ON f.id = e.ITEM_ATTENDANCESITEID WHERE a.organization_id = '"+customerOldId+"' AND a.STATUS = '0' AND a.occupation_type = '1' AND b.credential_type <= 7 GROUP BY a.id)u "
println( "获取未关联驻勤点关联状态---sql------>: " + sql );
var datas1= queryByDSName(this.dsName3,cql);
for( var iter = datas1.iterator( ); iter.hasNext( ); )
{
var data1 = iter.next( );
var rtnn = data1.get("ITEM_SUM");
rtnn = Number(rtnn)-Number(rtny)
}
return "已关联：" + rtny + " 未关联：" + rtnn + "";
}
},
//获取一般职员驻勤点关联状态
stayPoint:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(1) as ITEM_SUM from (SELECT COUNT(1) FROM obpm2.tenant_users c LEFT JOIN obpm2.tenant_employees a ON c.id = a.tenant_user_id LEFT JOIN obpm2.tenant_user_credentials b ON b.id = c.selected_credential_id AND b.credential_type < 7 LEFT JOIN obpm2.tenant_departments d ON a.department_id = d.id LEFT JOIN tlk_attendance_site_person_info e ON a.organization_id = e.DOMAINID AND b.number = e.ITEM_DOCUMENTID LEFT JOIN tlk_attendance_site_base_info f ON f.id = e.ITEM_ATTENDANCESITEID WHERE a.organization_id = '"+customerOldId+"' AND a.STATUS = '0' AND f.ITEM_attendanceSiteState = '生效' AND a.occupation_type = '0' AND b.credential_type <= 7 GROUP BY a.id)u"
println( "获取有关联驻勤点关联状态---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
var rtny = 0;
var rtnn = 0;
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var rtny = data.get("ITEM_SUM");
}
var cql = "SELECT COUNT(1) as ITEM_SUM FROM (SELECT COUNT(1) FROM obpm2.tenant_users c LEFT JOIN obpm2.tenant_employees a ON c.id = a.tenant_user_id LEFT JOIN obpm2.tenant_user_credentials b ON b.id = c.selected_credential_id AND b.credential_type < 7 LEFT JOIN obpm2.tenant_departments d ON a.department_id = d.id LEFT JOIN tlk_attendance_site_person_info e ON a.organization_id = e.DOMAINID AND b.number = e.ITEM_DOCUMENTID LEFT JOIN tlk_attendance_site_base_info f ON f.id = e.ITEM_ATTENDANCESITEID WHERE a.organization_id = '"+customerOldId+"' AND a.STATUS = '0' AND a.occupation_type = '0' AND b.credential_type <= 7 GROUP BY a.id)u "
println( "获取未关联驻勤点关联状态---sql------>: " + sql );
var datas1= queryByDSName(this.dsName3,cql);
for( var iter = datas1.iterator( ); iter.hasNext( ); )
{
var data1 = iter.next( );
var rtnn = data1.get("ITEM_SUM");
rtnn = Number(rtnn)-Number(rtny)
}
return "已关联：" + rtny + " 未关联：" + rtnn + "";
}
},
//获取关联合同状态
hetong:function(customerOldId){
if(isNotNull(customerOldId)){
var rtny = 0;
var rtnn = 0
//var sql = "SELECT COUNT(a.ITEM_securityName) AS ITEM_SUM FROM tlk_securityman a LEFT JOIN tlk_contracttoman b ON a.ITEM_PHONE = b.ITEM_PARTYBPHONE WHERE a.DOMAINID = '" + customerOldId + "' AND a.ITEM_isInMyCompany NOT LIKE '%0%' GROUP BY a.ID";
var sql = " SELECT COUNT(1) as sum from tenant_employees e where EXISTS (SELECT 1 from tenant_contracts where organization_id = '"+customerOldId+"' and e.id = employee_id and end_date > NOW() AND begin_date <= NOW()) and status =0 and organization_id = '"+customerOldId+"' and occupation_type = 1;";
println( "获取关联合同状态---sql------>: " + sql );
var datas= queryByDSName(this.dsName2,sql);;
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var rtny = data.get("sum");
}
var cql = "SELECT COUNT(1) as sum from tenant_employees e where not EXISTS (SELECT 1 from tenant_contracts where organization_id = '"+customerOldId+"' and e.id = employee_id and end_date > NOW() AND begin_date <= NOW()) and status =0 and organization_id = '"+customerOldId+"' and occupation_type = 1;";
println( "获取未关联合同状态---sql------>: " + cql );
var datas1= queryByDSName(this.dsName2,cql);;
for( var iter = datas1.iterator( ); iter.hasNext( ); )
{
var data1 = iter.next( );
var rtnn = data1.get("sum");
}
return "已关联：" + rtny + " 未关联：" + rtnn + "";
}
},
//获取一般职员关联合同状态
contractStatus:function(customerOldId){
if(isNotNull(customerOldId)){
var rtny = 0;
var rtnn = 0
//var sql = "SELECT COUNT(a.ITEM_securityName) AS ITEM_SUM FROM tlk_securityman a LEFT JOIN tlk_contracttoman b ON a.ITEM_PHONE = b.ITEM_PARTYBPHONE WHERE a.DOMAINID = '" + customerOldId + "' AND a.ITEM_isInMyCompany NOT LIKE '%0%' GROUP BY a.ID";
var sql = " SELECT COUNT(1) as sum from tenant_employees e where EXISTS (SELECT 1 from tenant_contracts where organization_id = '"+customerOldId+"' and e.id = employee_id and end_date > NOW() AND begin_date <= NOW()) and status =0 and organization_id = '"+customerOldId+"' and occupation_type = 0;";
println( "获取关联合同状态---sql------>: " + sql );
var datas= queryByDSName(this.dsName2,sql);;
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var rtny = data.get("sum");
}
var cql = "SELECT COUNT(1) as sum from tenant_employees e where not EXISTS (SELECT 1 from tenant_contracts where organization_id = '"+customerOldId+"' and e.id = employee_id and end_date > NOW() AND begin_date <= NOW()) and status =0 and organization_id = '"+customerOldId+"' and occupation_type = 0;";
println( "获取未关联合同状态---sql------>: " + cql );
var datas1= queryByDSName(this.dsName2,cql);;
for( var iter = datas1.iterator( ); iter.hasNext( ); )
{
var data1 = iter.next( );
var rtnn = data1.get("sum");
}
return "已关联：" + rtny + " 未关联：" + rtnn + "";
}
},
//获取合同录入总数
hetongluru:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(ID) AS ITEM_SUM FROM tlk_contracttoenterprise WHERE DOMAINID = '" + customerOldId + "' ";
println( "获取合同录入总数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取有效合同数
youxiaohetong:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(ID) AS ITEM_SUM FROM tlk_contracttoenterprise WHERE DOMAINID = '" + customerOldId + "' AND ITEM_CONTRACTSTATE = '有效' ";
println( "获取有效合同数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取已关联驻勤点数
yiguanlianhetong:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(distinct a.ID) AS ITEM_SUM FROM tlk_contracttoenterprise a,tlk_attendance_site_base_info b WHERE a.ID = b.ITEM_CONTRACTIDS AND a.ITEM_CONTRACTSTATE = '有效' AND a.DOMAINID = '" + customerOldId + "' ";
println( "获取已关联驻勤点数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取未关联驻勤点数
weiguanlianhetong:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(distinct a.ID) AS ITEM_SUM FROM tlk_contracttoenterprise a WHERE a.ID NOT IN (SELECT b.ITEM_CONTRACTIDS FROM tlk_attendance_site_base_info b) AND a.ITEM_CONTRACTSTATE = '有效' AND a.DOMAINID = '" + customerOldId + "' ";
println( "获取未关联驻勤点数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取驻勤点总数
zhuqindianzongshu:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(distinct ID) AS ITEM_SUM FROM tlk_attendance_site_base_info WHERE DOMAINID = '" + customerOldId + "' ";
println( "获取驻勤点总数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取驻勤生效状态
zhuqinshengxiaozhuangtai:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT ITEM_ATTENDANCESITESTATE,COUNT(ITEM_ATTENDANCESITESTATE) AS ITEM_SUM FROM tlk_attendance_site_base_info WHERE DOMAINID = '" + customerOldId + "' GROUP BY ITEM_ATTENDANCESITESTATE ";
println( "获取核验状态---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
var rtn = "";
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_ATTENDANCESITESTATE = data.get("ITEM_ATTENDANCESITESTATE");
var ITEM_SUM = data.get("ITEM_SUM");
rtn += ITEM_ATTENDANCESITESTATE + ": " + ITEM_SUM + " ";
}
return rtn;
}
},
//获取已入驻数
yiruzhu:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(distinct a.ID) AS ITEM_SUM FROM tlk_attendance_site_base_info a WHERE a.ID IN ( SELECT b.ITEM_ATTENDANCESITEID FROM tlk_attendance_site_person_info b GROUP BY b.ITEM_ATTENDANCESITEID ) AND a.ITEM_ATTENDANCESITESTATE = '生效' AND a.DOMAINID = '" + customerOldId + "'";
println( "获取已入驻数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取未入驻数
weiruzhu:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(distinct a.ID) AS ITEM_SUM FROM tlk_attendance_site_base_info a WHERE a.ID NOT IN ( SELECT b.ITEM_ATTENDANCESITEID FROM tlk_attendance_site_person_info b GROUP BY b.ITEM_ATTENDANCESITEID ) AND a.ITEM_ATTENDANCESITESTATE = '生效' AND a.DOMAINID = '" + customerOldId + "'";
println( "获取未入驻数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取在职人员总数
securityCount:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT count(1) as ITEM_SUM from " + this.dsName2 + ".tenant_employees where organization_id = '"+customerOldId+"' and occupation_type = '1' and STATUS = '0'";
println( "获取在职人员总数---sql------>: " + sql );
var datas= queryByDSName(this.dsName2,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var SUM = data.get("ITEM_SUM");
return SUM;
}
}
},
//获取在职人员总数
staffCount:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT count(1) as ITEM_SUM from " + this.dsName2 + ".tenant_employees where organization_id = '"+customerOldId+"' and occupation_type = '0' and STATUS = '0'";
println( "获取在职人员总数---sql------>: " + sql );
var datas= queryByDSName(this.dsName2,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var SUM = data.get("ITEM_SUM");
return SUM;
}
}
},
//获取已参保数
yicanbao:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(1) as ITEM_SUM FROM business_support WHERE name_cn='"+customerOldId+"' AND order_status='6'";
println( "获取已参保数---sql------>: " + sql );
var datas= queryByDSName(this.dsName,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取未参保数
weicanbao:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT COUNT(*) AS ITEM_SUM FROM tlk_securityman WHERE ( ITEM_insure IS NULL OR ITEM_insure LIKE '0' OR ITEM_insure LIKE '' ) AND ITEM_isInMyCompany NOT LIKE '%0%' AND DOMAINID = '" + customerOldId + "'";
println( "获取未参保数---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
},
//获取投保率
toubaolv:function(customerOldId){
if(isNotNull(customerOldId)){
var sql = "SELECT(SELECT COUNT(ITEM_insure) FROM tlk_securityman WHERE ITEM_insure = '1' AND DOMAINID = '" + customerOldId + "' ) / (SELECT COUNT(*) FROM tlk_securityman WHERE DOMAINID = '" + customerOldId + "' ) * 100 AS ITEM_SUM";
println( "获取投保率---sql------>: " + sql );
var datas= queryByDSName(this.dsName3,sql);
for( var iter = datas.iterator( ); iter.hasNext( ); )
{
var data = iter.next( );
var ITEM_SUM = data.get("ITEM_SUM");
return ITEM_SUM;
}
}
}
}]]>
162