用工需求人员导入 __DXZvc8mnEmDqMARhK7G __DXZvc8mnEmDqMARhK7G 16 2048 1536 rollback 1731675534007 用工人员 0 566 336 142 34 work_person 1731675557339 姓名 0 447 242 142 34 person_name false 1731675559319 证件号码 0 559 189 142 34 id_number false //在表单控件值脚本中获取当前文档对象 (function(){ var process = getDocumentProcess(); var doc=getCurrentDocument(); doc.findItem(@quot;parent_id@quot;).setValue(getRelateDocument().getId()) var domainid = getDomainid() var id_number = doc.findItem(@quot;id_number@quot;).getValue() var item_userID=@quot;@quot;; var company_name=@quot;@quot;; var company_id=@quot;@quot;; var Pheight=@quot;@quot;; var age=@quot;@quot;; var sql=@quot;select item_userID,domainid,ITEM_height,ITEM_companyName,(select TIMESTAMPDIFF(YEAR,concat(substring(ITEM_documentID, 7, 4),'-',substring(ITEM_documentID, 11, 2),'-',substring(ITEM_documentID, 13, 2)),DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%S')))AS item_age from vw_employee where item_documentID='@quot;+id_number+@quot;' and domainid='@quot;+domainid+@quot;' and ITEM_isInMyCompany='1' @quot; var datas = queryByDSName(@quot;baibaodunFlow@quot;,sql); if(datas.size()@gt;0){ for(var iterator = datas.iterator();iterator.hasNext();){ var map1 = iterator.next();//取值 item_userID= map1.get(@quot;item_userID@quot;); company_id= map1.get(@quot;domainid@quot;); Pheight= map1.get(@quot;ITEM_height@quot;); company_name= map1.get(@quot;ITEM_companyName@quot;); item_userID= map1.get(@quot;item_userID@quot;); age= map1.get(@quot;item_age@quot;); } } doc.findItem(@quot;person_id@quot;).setValue(item_userID) doc.findItem(@quot;company_name@quot;).setValue(company_name) doc.findItem(@quot;company_id@quot;).setValue(company_id) doc.findItem(@quot;height@quot;).setValue(Pheight) doc.findItem(@quot;age@quot;).setValue(age) })() //在表单控件值脚本中获取当前文档对象 (function(){ var doc=getCurrentDocument(); var domainid = getDomainid() var id_number = doc.findItem(@quot;id_number@quot;).getValue() var sql=@quot;select 1 from vw_employee where item_documentID='@quot;+id_number+@quot;' and domainid='@quot;+domainid+@quot;' and ITEM_isInMyCompany='1' @quot; var datas = queryByDSName(@quot;baibaodunFlow@quot;,sql); if(!datas.size()@gt;0){ return @quot;身份证号码：@quot;+id_number+@quot;不在本企业在职！@quot; } })() 1731675562573 性别 0 760 231 142 34 sex false 1731675564441 证件类型 0 378 363 142 34 id_type false 1731675566331 手机号 0 593 434 142 34 telephone false 1731675559319 1731675534007 false false 566;336;559;189 1731675859329 1731675562573 1731675534007 false false 566;336;760;231 1731675861144 1731675566331 1731675534007 false false 566;336;593;434 1731675862816 1731675564441 1731675534007 false false 566;336;378;363 1731675864743 1731675557339 1731675534007 false false 566;336;447;242 1731675868726 ]]> /uploads/exceltemplate/用工人员导入模板.xlsx