已分配客户导入 __K9C0HmAjnqJZgTI2sjd __K9C0HmAjnqJZgTI2sjd 16 2048 1536 rollback 1709709596207 已分配客户导入 0 545 203 142 34 customerdr 1709709800080 项目经理 0 686 92 142 34 xmjl false 1709709800223 客户经理 0 512 98 142 34 khjl false 1709709800631 客户名称 0 280 129 142 34 name false (function(){ var doc = getCurrentDocument(); var domainid = getDomainid(); var name = doc.getItemValueAsString(@quot;name@quot;); if(!isNotNull(name)){ return @quot;客户名称必须填写！@quot; } var khjl = doc.getItemValueAsString(@quot;khjl@quot;); if(!isNotNull(khjl)){ return @quot;客户经理必须填写！@quot; } var xmjl = doc.getItemValueAsString(@quot;xmjl@quot;); var empid = getWebUser().getId(); var domainid = getDomainid() var userid = @quot;@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; var id = @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;); } }else{ return @quot;客户名称不存在！@quot; } var ssql = @quot;select item_userid from baibaodunflow.vw_employee where item_securityname = '@quot;+khjl+@quot;' and domainid = '@quot;+domainid+@quot;' limit 1@quot; 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;+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;+uuid+@quot;','@quot;+khjl+@quot;','$$$test','客户经理');@quot; println(@quot;insql-----------@quot;+insql) insertByDSName(@quot;mcs@quot;,insql); }else{ return @quot;客户经理不存在！@quot; } if(isNotNull(xmjl)){ 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(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; } } })() 1709709800631 1709709596207 false false 545;203;278;130 1709709808231 1709709800223 1709709596207 false false 545;203;512;98 1709709810319 1709709800080 1709709596207 false false 545;203;687;92 1709709812079 ]]> /uploads/exceltemplate/已分配客户跟进人导入模板.xlsx