导入制证人员 __MaYb74WQzpuReipenIM __MaYb74WQzpuReipenIM 16 2048 1536 rollback 1736825134837 人员名单 0 630 314 142 34 honor_person 1736825198662 证书是否已生成 0 870 227 142 34 is_build false //表单某字段值为当前打开文档Id (function(){ var nowdomainid=getDomainid(); var domainprocess = getDomainProcess();//获取企业域对象 var domaindoc=domainprocess.doView(nowdomainid); var domain_name = domaindoc.getName(); var doc=getCurrentDocument(); doc.findItem(@quot;is_build@quot;).setValue(@quot;0@quot;) var id_number = getItemValueAsString(@quot;id_number@quot;); var phone=@quot;@quot; var userID=@quot;@quot; var sql=@quot;select ITEM_phone,ITEM_userID,id from baibaodunflow.vw_employee where ITEM_documentID='@quot;+id_number+@quot;' and domainid='@quot;+getDomainid()+@quot;' and ITEM_isInMyCompany='1' @quot; var datas = queryByDSName(@quot;tms@quot;,sql); if(datas.size()@gt;0){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 phone = map1.get(@quot;ITEM_phone@quot;); userID = map1.get(@quot;ITEM_userID@quot;); tuser_id=map1.get(@quot;id@quot;); } } doc.findItem(@quot;user_id@quot;).setValue(userID) doc.findItem(@quot;phone@quot;).setValue(phone) doc.findItem(@quot;id_number@quot;).setValue(id_number) doc.findItem(@quot;create_name@quot;).setValue(getWebUser().getName()) doc.findItem(@quot;create_time@quot;).setValue(getToday()) doc.findItem(@quot;domain_id@quot;).setValue(nowdomainid) doc.findItem(@quot;domain_name@quot;).setValue(domain_name) doc.findItem(@quot;tuser_id@quot;).setValue(tuser_id) doc.findItem(@quot;certificate_id@quot;).setValue(@quot;tiqC9j4wBch5Zf8jrR7--__M4fveWhJEz5jFlQyWwa@quot;) })() 1736825201880 姓名 0 514 167 142 34 name false 1736825206702 身份证 0 660 173 142 34 id_number false 1736825201880 1736825134837 false false 630;314;514;167 1736825357881 1736825206702 1736825134837 false false 630;314;660;173 1736825360491 1736825198662 1736825134837 false false 630;314;870;227 1736825363274 ]]> /uploads/exceltemplate/制证人员导入xlsx.xlsx