getDomainAndContact
__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("__XkDFLgsWaxXzCqmGBO1");//目标表单
var doc = process.doNew(subform,getWebUser(),createParamsTable());
var data = iter.next( );
doc.setDomainid(domainid);//设置企业域id
var synId = data.get("ID");
doc.addStringItem("synId",synId); //客户原来的id
var name = data.get("NAME");
doc.addStringItem("name",name); //客户名
doc.addStringItem("nickname",name); //客户别名
var industryid = data.get("FIELD14");//行业类型
if( industryid == "保安行业" ) doc.addStringItem("industryid","01");
else if( industryid == "大活行业" ) doc.addStringItem("industryid","02");
else doc.addStringItem("industryid","09");
doc.addStringItem("level","01"); //客户等级
doc.addStringItem("source","1"); //客户来源
doc.addStringItem("isdeleted","2"); //是否删除
doc.addStringItem("state","1"); //客户状态
doc.addStringItem("ispartner","02"); //是否重要客户
process.doCreate(doc); //写入数据
var contact_sql = " SELECT LOGINNO, ID, NAME FROM " + this.dsName2 + ".t_user WHERE ISDOMAINUSER = 'true' AND DOMAINID = '" + synId + "' ";
println( "同步企业域管理员到联系人表---sql------>: " + contact_sql );
var contact_datas= queryByDSName(this.dsName2,contact_sql);
for( var contact_iter = contact_datas.iterator( ); contact_iter.hasNext( ); )
{
var contact_process = getDocumentProcess();
var contact_formService = getFormProcess();
var contact_subform = contact_formService.doView("__ACZsBkVcLPuteJ0g7CC");//目标表单
var contact_doc = contact_process.doNew(contact_subform,getWebUser(),createParamsTable());
var contact_data = contact_iter.next( );
var contact_loginno = contact_data.get("LOGINNO");
var contact_name = contact_data.get("NAME");
var contact_id = contact_data.get("ID");
contact_doc.setDomainid(domainid); //设置企业域id
contact_doc.setParent(doc.getId()); //设置父id
contact_doc.addStringItem("customerid",doc.getId()); //所属客户id
contact_doc.addStringItem("customerNickName",name); //所属客户别名
contact_doc.addStringItem("customerName",name); //所属客户名
contact_doc.addStringItem("name",contact_name); //联系人姓名
contact_doc.addStringItem("sex","男"); //联系人性别
contact_doc.addStringItem("telephone",contact_loginno); //联系人电话
contact_doc.addStringItem("phone",contact_loginno); //联系人固定电话
contact_doc.addStringItem("synUserId",contact_id); //联系人原本的id
contact_process.doCreate(contact_doc); //提交
}
}
return "同步企业域数据到客户公海 成功！";
}
catch(e){
return e;
}
}
}]]>
17