客户公海导入 __K9C0HmAjnqJZgTI2sjd __K9C0HmAjnqJZgTI2sjd 16 2048 1536 rollback 1628428997387 客户公海导入 0 349 200 142 34 customerghdr 1628429100997 客户名称 0 102 101 142 34 name false (function(){ var doc=getCurrentDocument() var empid = getWebUser().getId(); var userid = @quot;@quot;; var name = doc.getItemValueAsString(@quot;name@quot;); var domainid = getDomainid(); var id = new Packages.cn.myapps.util.sequence.Sequence().getSequence(); id+=@quot;--__XkDFLgsWaxXzCqmGBO1@quot; var uuid = new Packages.cn.myapps.util.sequence.Sequence().getSequence(); uuid+=@quot;--__xyiP8yV2DWw6GjvyWaJ@quot; var uuid2 = new Packages.cn.myapps.util.sequence.Sequence().getSequence(); uuid2+=@quot;--__xyiP8yV2DWw6GjvyWaJ@quot; if(!isNotNull(name)){ return @quot;客户名称必须填写！@quot; } var province = doc.getItemValueAsString(@quot;province@quot;); if(!isNotNull(province)){ return @quot;省必须填写！@quot; } var provincecode = @quot;@quot;; var checksql = @quot;select regionid from mcs.tlk_sysregion where regionfullname = '@quot;+province+@quot;'@quot; var datas = queryByDSName(@quot;mcs@quot;,checksql); if(datas!=@quot;[]@quot;){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 provincecode = map1.get(@quot;regionid@quot;); } }else{ return @quot;省不存在！@quot; } var city = doc.getItemValueAsString(@quot;city@quot;); var cityg = province+city if(!isNotNull(city)){ return @quot;市必须填写！@quot; } var citycode = @quot;@quot;; var checksql = @quot;select regionid from mcs.tlk_sysregion where regionFullName = '@quot;+cityg+@quot;'@quot; var datas = queryByDSName(@quot;mcs@quot;,checksql); if(datas!=@quot;[]@quot;){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 citycode = map1.get(@quot;regionid@quot;); } }else{ return @quot;市不存在！@quot; } var district = doc.getItemValueAsString(@quot;district@quot;); var districtg = province+city+district if(!isNotNull(district)){ return @quot;区必须填写！@quot; } var districtcode = @quot;@quot; var checksql = @quot;select regionid from mcs.tlk_sysregion where regionFullName = '@quot;+districtg+@quot;'@quot; var datas = queryByDSName(@quot;mcs@quot;,checksql); if(datas!=@quot;[]@quot;){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 districtcode = map1.get(@quot;regionid@quot;); } }else{ return @quot;区不存在！@quot; } var industry = doc.getItemValueAsString(@quot;industry@quot;); if(!isNotNull(industry)){ return @quot;所属行业必须填写！@quot; } var type = doc.getItemValueAsString(@quot;type@quot;); if(!isNotNull(type)){ return @quot;客户类型必须填写！@quot; } var khjl = doc.getItemValueAsString(@quot;khjl@quot;); if(!isNotNull(khjl)){ return @quot;客户经理必须填写！@quot; } var xmjl = doc.getItemValueAsString(@quot;xmjl@quot;); if(industry == @quot;保安行业@quot; || industry == @quot;大型活动相关行业@quot; || industry == @quot;监管行业@quot; || industry == @quot;其他行业@quot;){ }else{ return @quot;导入失败，所属行业无对应值@quot; }; if(type == @quot;直接客户@quot; || type == @quot;经销客户@quot; || type == @quot;合作伙伴@quot; || type == @quot;供应商@quot;){ }else{ return @quot;导入失败，客户类型无对应值@quot; } var sql = @quot; SELECT id FROM tlk_customer WHERE ITEM_NAME = '@quot; + name + @quot;' AND DOMAINID = '@quot; + domainid + @quot;' AND ITEM_ISDELETED != '1' @quot;; println( @quot;name----sql-----@gt;: @quot; + sql ); var datas = queryByDSName(@quot;mcs@quot;,sql); if(datas!=@quot;[]@quot;){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 id = map1.get(@quot;id@quot;); } var upsql = @quot;update mcs.tlk_customer set LASTMODIFIED = now(),item_province = '@quot;+provincecode+@quot;',item_city = '@quot;+citycode+@quot;',item_regionid = '@quot;+districtcode+@quot;',item_industryid = (select case '@quot;+industry+@quot;' when '保安行业' then '01' when '大型活动相关行业' then '02' when '其他行业' then '03' when '监管行业' then '04' else '01' end as industryid from dual limit 1),item_type = (select case '@quot;+type+@quot;' when '直接客户' then '01' when '经销客户' then '02' when '合作伙伴' then '03' when '供应商' then '04' else '01' end as type from dual limit 1) where id = '@quot;+id+@quot;'@quot; println(@quot;upsql--------@quot;+upsql); updateByDSName(@quot;mcs@quot;,upsql); }else{ var insql = @quot;insert into mcs.tlk_customer(created,domainid,item_name,item_province,item_city,item_regionid,item_industryid,item_type,id,ITEM_isdeleted) select now(),'@quot;+domainid+@quot;','@quot;+name+@quot;','@quot;+provincecode+@quot;','@quot;+citycode+@quot;','@quot;+districtcode+@quot;',case '@quot;+industry+@quot;' when '保安行业' then '01' when '大型活动相关行业' then '02' when '其他行业' then '03' when '监管行业' then '04' else '01' end as industryid,case '@quot;+type+@quot;' when '直接客户' then '01' when '经销客户' then '02' when '合作伙伴' then '03' when '供应商' then '04' else '01' end as type,'@quot;+id+@quot;','0' as is_deleted from dual@quot;; println(@quot;insql-----------@quot;+insql); insertByDSName(@quot;mcs@quot;,insql); } var ssql = @quot;select item_userid from baibaodunflow.vw_employee where item_securityname = '@quot;+khjl+@quot;' and domainid = '@quot;+domainid+@quot;' limit 1@quot; println(@quot;ssql-coderxiaoc-----------@quot;+ssql); var datas = queryByDSName(@quot;mcs@quot;,ssql); if(datas!=@quot;[]@quot;){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 userid = map1.get(@quot;item_userid@quot;); } var insql = @quot;INSERT INTO mcs.tlk_customerfollow(LASTMODIFIED,FORMNAME,AUTHOR,CREATED,FORMID,ISTMP,VERSIONS,APPLICATIONID,STATEINT,LASTMODIFIER,DOMAINID,AUDITORLIST,COAUDITORLIST,STATELABELINFO,ITEM_CUSTOMERNAME,ITEM_CUSTOMERID,ITEM_BELONGERID,ID,ITEM_BELONGERNAME,AUTHOR_USER_INDEX,ITEM_TYPE)VALUES(now(),'客户模块/customerFollow','@quot;+userid+@quot;',now(),'__xyiP8yV2DWw6GjvyWaJ','\0','1','__K9C0HmAjnqJZgTI2sjd','0','@quot;+userid+@quot;','@quot;+domainid+@quot;','{}','{}','[{\@quot;nodes\@quot;:[{\@quot;nodeId\@quot;:\@quot;\@quot;,\@quot;stateLabel\@quot;:\@quot;\@quot;,\@quot;state\@quot;:\@quot;\@quot;,\@quot;auditors\@quot;:[],\@quot;coAuditors\@quot;:[]}]}]','@quot;+name+@quot;','@quot;+id+@quot;','@quot;+userid+@quot;','@quot;+uuid+@quot;','@quot;+khjl+@quot;','$$$test','客户经理');@quot; println(@quot;insql-----------@quot;+insql) insertByDSName(@quot;mcs@quot;,insql); }else{ return @quot;客户经理不存在！@quot; } var ssql2 = @quot;select item_userid from baibaodunflow.vw_employee where item_securityname = '@quot;+xmjl+@quot;' and domainid = '@quot;+domainid+@quot;' limit 1@quot; var datas = queryByDSName(@quot;mcs@quot;,ssql2); if(isNotNull(xmjl)){ if(datas!=@quot;[]@quot;){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 userid = map1.get(@quot;item_userid@quot;); } var insql = @quot;INSERT INTO mcs.tlk_customerfollow(LASTMODIFIED,FORMNAME,AUTHOR,CREATED,FORMID,ISTMP,VERSIONS,APPLICATIONID,STATEINT,LASTMODIFIER,DOMAINID,AUDITORLIST,COAUDITORLIST,STATELABELINFO,ITEM_CUSTOMERNAME,ITEM_CUSTOMERID,ITEM_BELONGERID,ID,ITEM_BELONGERNAME,AUTHOR_USER_INDEX,ITEM_TYPE)VALUES(now(),'客户模块/customerFollow','@quot;+empid+@quot;',now(),'__xyiP8yV2DWw6GjvyWaJ','\0','1','__K9C0HmAjnqJZgTI2sjd','0','@quot;+empid+@quot;','@quot;+domainid+@quot;','{}','{}','[{\@quot;nodes\@quot;:[{\@quot;nodeId\@quot;:\@quot;\@quot;,\@quot;stateLabel\@quot;:\@quot;\@quot;,\@quot;state\@quot;:\@quot;\@quot;,\@quot;auditors\@quot;:[],\@quot;coAuditors\@quot;:[]}]}]','@quot;+name+@quot;','@quot;+id+@quot;','@quot;+userid+@quot;','@quot;+uuid2+@quot;','@quot;+xmjl+@quot;','$$$test','项目经理');@quot; println(@quot;insql-----------@quot;+insql) insertByDSName(@quot;mcs@quot;,insql); }else{ return @quot;项目经理不存在！@quot; } } })() 1628429137078 省 0 252 101 142 34 province false 1628429157232 区 0 550 103 142 34 district false 1628429166213 客户经理 0 255 320 142 34 khjl false 1628429168178 市 0 403 101 142 34 city false 1628429170255 所属行业 0 704 101 142 34 industry false (function(){ var doc=getCurrentDocument() var industry = doc.getItemValueAsString(@quot;industry@quot;); if(industry == @quot;保安行业@quot;) ; else if(industry == @quot;大型活动相关行业@quot;) ; else if(industry == @quot;监管行业@quot;) ; else if(industry == @quot;其他行业@quot;) ; else return @quot;导入失败，“所属行业”无对应值，请下载正确模板导入@quot;; })() 1628429357999 客户类型 0 113 319 142 34 type false (function(){ var doc=getCurrentDocument() var type = doc.getItemValueAsString(@quot;type@quot;); if(type == @quot;直接客户@quot;) ; else if(type == @quot;经销客户@quot;) ; else if(type == @quot;合作伙伴@quot;) ; else if(type == @quot;供应商@quot;) ; else return @quot;导入失败，“客户类型”无对应值，请下载正确模板导入@quot;; })() 1628428997387 1628429100997 false false 101;101;352;203 1628429514344 1628428997387 1628429137078 false false 252;101;352;203 1628429519115 1628428997387 1628429168178 false false 403;101;351;201 1628429528371 1628428997387 1628429157232 false false 550;103;351;201 1628429531401 1628428997387 1628429170255 false false 704;101;351;201 1628429534165 1628428997387 1628429166213 false false 100;249;351;200 1628429545916 1628428997387 1628429357999 false false 365;275;351;200 1628429557718 1628479329774 项目经理 0 401 301 142 34 xmjl false 1628428997387 1628479329774 false false 402;302;349;200 1628479347412 ]]> /uploads/exceltemplate/客户公海导入模板.xlsx