保安员信息批量导入 __DXZvc8mnEmDqMARhK7G 16 2048 1536 rollback 1612924101239 保安员信息 0 171 38 142 34 securityMan 1612924119470 手机号 0 92 161 142 34 phone false 1612924120605 姓名 0 35 112 142 34 securityName false 1612924101239 1612924120605 false false 600;160;181;88 1612924126094 1612924129334 人员类型 0 162 208 142 34 jobType false 1612924138486 所属部门 0 228 252 142 34 DeptName false //根据手机号码去后台企业域查询，有则带出用户数据，isFromDomain等于是，如果不存在，则为否 #include @quot;sysfunction@quot;; (function(){ var DeptName = getItemValueAsString(@quot;DeptName@quot;); var domainid = getDomainid(); var phone = getItemValueAsString(@quot;phone@quot;); if(isNotNull(phone)){ var doc = getCurrentDocument(); var sql = @quot;Select DOMAINID,id,TELEPHONE as item_telephone,NAME as item_name,ID as item_ID,DEFAULTDEPARTMENT as item_deptid,DIMISSION as item_DIMISSION,CERTIFICATIONSTATUS as item_CERTIFICATIONSTATUS,CERTIFICATIONTIME as item_CERTIFICATIONTIME,ID_TYPE as item_ID_TYPE,ID_NUMBER as item_ID_NUMBER From @quot; +sysfunction.DS_OBPM+@quot;.t_user where loginno='@quot;+phone+@quot;' AND domainid='@quot;+domainid+@quot;' @quot;; var datart = findBySQL(sql); if(datart != null){ doc.findItem(@quot;isInMyCompany@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;isFromDomain@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;DeptID@quot;).setValue(datart.getItemValueAsString(@quot;deptid@quot;)); doc.findItem(@quot;isCertified@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONSTATUS@quot;)); doc.findItem(@quot;LastAuthTime@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONTIME@quot;)); doc.findItem(@quot;documentType@quot;).setValue(datart.getItemValueAsString(@quot;ID_TYPE@quot;)); doc.findItem(@quot;documentID@quot;).setValue(datart.getItemValueAsString(@quot;ID_NUMBER@quot;)); }else { //如果在其他组织域,则自动带出认证信息 var sql2 = @quot;Select DOMAINID,id,TELEPHONE as item_telephone,NAME as item_name,ID as item_ID,DEFAULTDEPARTMENT as item_deptid,DIMISSION as item_DIMISSION,CERTIFICATIONSTATUS as item_CERTIFICATIONSTATUS,CERTIFICATIONTIME as item_CERTIFICATIONTIME,ID_TYPE as item_ID_TYPE,ID_NUMBER as item_ID_NUMBER From @quot; +sysfunction.DS_OBPM+@quot;.t_user where loginno='@quot;+phone+@quot;' AND domainid !='@quot;+domainid+@quot;'@quot;; var datart2 = findBySQL(sql2); if(datart2!=null){ doc.findItem(@quot;isInMyCompany@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;isFromDomain@quot;).setValue(@quot;否@quot;); doc.findItem(@quot;isCertified@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONSTATUS@quot;)); doc.findItem(@quot;LastAuthTime@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONTIME@quot;)); doc.findItem(@quot;documentType@quot;).setValue(datart.getItemValueAsString(@quot;ID_TYPE@quot;)); doc.findItem(@quot;documentID@quot;).setValue(datart.getItemValueAsString(@quot;ID_NUMBER@quot;)); } //判断部门名称是否存在 var sql3=@quot;select DOMAIN_ID as domainid,id,ID as item_deptid,name as item_name From @quot; +sysfunction.DS_OBPM+@quot;.t_department where name='@quot;+DeptName+@quot;' AND DOMAIN_ID ='@quot;+domainid+@quot;'@quot;; var datart3 = findBySQL(sql3); if(datart3!=null){ doc.findItem(@quot;DeptID@quot;).setValue(datart3.getItemValueAsString(@quot;deptid@quot;)); }else{ return @quot;此部门在组织中不存在@quot;; } } } })() 1612924252974 证件类型 0 295 206 142 34 documentType false //根据手机号码去后台企业域查询，有则带出用户数据，isFromDomain等于是，如果不存在，则为否 #include @quot;sysfunction@quot;; (function(){ var DeptName = getItemValueAsString(@quot;DeptName@quot;); var domainid = getDomainid(); var phone = getItemValueAsString(@quot;phone@quot;); if(isNotNull(phone)){ var doc = getCurrentDocument(); var sql = @quot;Select DOMAINID,id,TELEPHONE as item_telephone,NAME as item_name,ID as item_ID,DEFAULTDEPARTMENT as item_deptid,DIMISSION as item_DIMISSION,CERTIFICATIONSTATUS as item_CERTIFICATIONSTATUS,CERTIFICATIONTIME as item_CERTIFICATIONTIME,ID_TYPE as item_ID_TYPE,ID_NUMBER as item_ID_NUMBER From @quot; +sysfunction.DS_OBPM+@quot;.t_user where TELEPHONE='@quot;+phone+@quot;' AND domainid='@quot;+domainid+@quot;' @quot;; var datart = findBySQL(sql); if(datart != null){ doc.findItem(@quot;isInMyCompany@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;isFromDomain@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;DeptID@quot;).setValue(datart.getItemValueAsString(@quot;deptid@quot;)); doc.findItem(@quot;isCertified@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONSTATUS@quot;)); doc.findItem(@quot;LastAuthTime@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONTIME@quot;)); doc.findItem(@quot;documentType@quot;).setValue(datart.getItemValueAsString(@quot;ID_TYPE@quot;)); doc.findItem(@quot;documentID@quot;).setValue(datart.getItemValueAsString(@quot;ID_NUMBER@quot;)); }else { //如果在其他组织域,则自动带出认证信息 var sql2 = @quot;Select DOMAINID,id,TELEPHONE as item_telephone,NAME as item_name,ID as item_ID,DEFAULTDEPARTMENT as item_deptid,DIMISSION as item_DIMISSION,CERTIFICATIONSTATUS as item_CERTIFICATIONSTATUS,CERTIFICATIONTIME as item_CERTIFICATIONTIME,ID_TYPE as item_ID_TYPE,ID_NUMBER as item_ID_NUMBER From @quot; +sysfunction.DS_OBPM+@quot;.t_user where TELEPHONE='@quot;+phone+@quot;' AND domainid !='@quot;+domainid+@quot;'@quot;; var datart2 = findBySQL(sql2); if(datart2!=null){ doc.findItem(@quot;isInMyCompany@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;isFromDomain@quot;).setValue(@quot;否@quot;); doc.findItem(@quot;isCertified@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONSTATUS@quot;)); doc.findItem(@quot;LastAuthTime@quot;).setValue(datart.getItemValueAsString(@quot;CERTIFICATIONTIME@quot;)); doc.findItem(@quot;documentType@quot;).setValue(datart.getItemValueAsString(@quot;ID_TYPE@quot;)); doc.findItem(@quot;documentID@quot;).setValue(datart.getItemValueAsString(@quot;ID_NUMBER@quot;)); } //判断部门名称是否存在 var sql3=@quot;select DOMAIN_ID as domainid, id,ID as item_deptid,name as item_name From @quot; +sysfunction.DS_OBPM+@quot;.t_department where name='@quot;+DeptName+@quot;' AND DOMAIN_ID ='@quot;+domainid+@quot;'@quot;; var datart3 = findBySQL(sql3); if(datart3!=null){ doc.findItem(@quot;DeptID@quot;).setValue(datart3.getItemValueAsString(@quot;deptid@quot;)); doc.findItem(@quot;isInMyCompany@quot;).setValue(@quot;是@quot;); doc.findItem(@quot;isFromDomain@quot;).setValue(@quot;否@quot;); }else{ return @quot;此部门在组织中不存在@quot;; } } } })() 1612924256286 证件号码 0 363 169 142 34 documentID false 1612924259038 入职日期 0 431 122 142 34 entryDate false 1612924101239 1612924119470 false false 92;161;171;38 1612924407302 1612924101239 1612924129334 false false 162;208;171;38 1612924409605 1612924101239 1612924138486 false false 223;253;171;38 1612924411789 1612924101239 1612924252974 false false 294;208;171;38 1612924413997 1612924101239 1612924256286 false false 363;169;171;38 1612924416613 1612924101239 1612924259038 false false 431;123;171;38 1612924419493 ]]> /uploads/exceltemplate/保安员批量导入.xls