用工需求人员导入 __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 project_id = getRelateDocument().getItemValueAsString(@quot;project_id@quot;); var project_domain_id=findDocument(project_id).getDomainid() var domainid = getDomainid() var person_name = doc.findItem(@quot;person_name@quot;).getValue() var telephone = doc.findItem(@quot;telephone@quot;).getValue() var id_number = doc.findItem(@quot;id_number@quot;).getValue() var sex = doc.findItem(@quot;sex@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, IF (( SELECT count(1) FROM obpm2.tenant_user_credential_details WHERE idnum = e.ITEM_documentID AND active =1 and state= 1 and certificateType='1' LIMIT 1) =1 , '是', '否' ) AS IScertification,ITEM_companyName,case ITEM_jobType when '0' then '一般职员' when '1' then '普通保安员' else ITEM_jobType end as ITEM_jobType,(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 e where item_documentID='@quot;+id_number+@quot;' and domainid='@quot;+domainid+@quot;' and ITEM_isInMyCompany='1' limit 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;); ITEM_jobType= map1.get(@quot;ITEM_jobType@quot;); IScertification= map1.get(@quot;IScertification@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) var work_person_id=doc.getId(); var selectsql2=@quot;select id from tlk_project_person where item_person_id='@quot;+item_userID+@quot;' and item_project_id='@quot;+project_id+@quot;' @quot; var datas3 = queryByDSName(@quot;baibaodunFlow@quot;,selectsql2); if(datas3.size()@gt;0){ }else{ var process = getDocumentProcess(); var formProcess = getFormProcess(); var projectInfo = formProcess.doView(@quot;__fEyatoqCe7eldmvPiUH@quot;); var projectInfoDoc = process.doNew(projectInfo,getWebUser(),createParamsTable()); projectInfoDoc.addStringItem(@quot;work_person_id@quot;,work_person_id); projectInfoDoc.addStringItem(@quot;name@quot;,person_name); projectInfoDoc.addStringItem(@quot;sex@quot;,sex); projectInfoDoc.addStringItem(@quot;id_number@quot;,id_number); projectInfoDoc.addStringItem(@quot;phone@quot;,telephone); projectInfoDoc.addStringItem(@quot;occupation_type@quot;,ITEM_jobType); projectInfoDoc.addStringItem(@quot;person_type@quot;,@quot;企业人员@quot;); projectInfoDoc.addStringItem(@quot;domain_name@quot;,company_name); projectInfoDoc.addStringItem(@quot;person_id@quot;,item_userID); projectInfoDoc.addStringItem(@quot;project_id@quot;,project_id); projectInfoDoc.addStringItem(@quot;is_certified@quot;,IScertification); projectInfoDoc.setDomainid(project_domain_id); process.doCreate(projectInfoDoc); } })() //在表单控件值脚本中获取当前文档对象 (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