绑定 __KWBHssgPtqkxvqhTKlW __KWBHssgPtqkxvqhTKlW 16 2048 1536 rollback 1680154937718 绑定设备信息 0 363 111 142 34 import_binded_log 1680154958021 资源编号 0 231 237 142 34 number false 1680154937718 1680154937718 false false 369;126;369;126 1680154963309 1680154937718 1680154958021 false false 274;246;369;126 1680154965901 1680154969596 保安员姓名 0 440 248 142 34 binded_user_name false 1680154970205 保安员证件号码 0 594 239 142 34 binded_user_idnumber false //判断表单某字段不能为空 (function(){ var process = getDocumentProcess(); var binded_user_idnumber = getItemValueAsString(@quot;binded_user_idnumber@quot;); var device_number = getItemValueAsString(@quot;number@quot;); var usersql=@quot;SELECT s1.name as item_domain_name,u.name as item_name,u.telephone as item_telephone,uc.number as item_number,t2.ITEM_attendanceSiteName,@quot;+ @quot;t2.id as item_attid,u.id as item_userid @quot;+ @quot; FROM obpm2.tenant_organizations s1 @quot;+ @quot;INNER JOIN obpm2.tenant_employees e ON e.organization_id = s1.id @quot;+ @quot;INNER JOIN obpm2.tenant_users u ON e.tenant_user_id = u.id @quot;+ @quot;LEFT JOIN obpm2.tenant_user_credentials uc on u.selected_credential_id=uc.id @quot;+ @quot;LEFT JOIN baibaodunflow.tlk_attendance_site_person_info t3 ON e.id = t3.ITEM_securityId @quot;+ @quot;LEFT JOIN baibaodunflow.tlk_attendance_site_base_info t2 ON t3.ITEM_attendanceSiteId = t2.id @quot;+ @quot;WHERE uc.number='@quot;+binded_user_idnumber+@quot;' and e.status='0' and s1.id='@quot;+getDomainid()+@quot;' @quot;; println(@quot;当前人员sql@quot;+usersql) var domain_name=@quot;@quot;; var securityName=@quot;@quot;; var telephone=@quot;@quot;; var attid=@quot;@quot;; var userid=@quot;@quot;; var idCardNumber=@quot;@quot;; var userdatas = queryByDSName(@quot;dispatch@quot;,usersql); if(userdatas.size()@gt;0){ for(var useriterator = userdatas.iterator();useriterator.hasNext();){ var usermap = useriterator.next();//取值 var domain_name= usermap.get(@quot;item_domain_name@quot;);//公司名称 var securityName= usermap.get(@quot;item_name@quot;);//姓名 var telephone= usermap.get(@quot;item_telephone@quot;);//电话号码 var idCardNumber= usermap.get(@quot;item_number@quot;);//电话号码 var attid= usermap.get(@quot;item_attid@quot;);//驻勤点id var userid= usermap.get(@quot;item_userid@quot;);//用户id } } var deviceId=@quot;@quot; var deviceSql=@quot;select id from tlk_device where item_number='@quot;+device_number+@quot;'@quot; var devicedatas = queryByDSName(@quot;dispatch@quot;,deviceSql); if(devicedatas.size()@gt;0){ for(var deviceiterator = devicedatas.iterator();deviceiterator.hasNext();){ var devicemap = deviceiterator.next();//取值 deviceid= devicemap.get(@quot;id@quot;); } } if(isNotNull(deviceid)){ var deviceDoc=findDocument(deviceid); deviceDoc.findItem(@quot;binded_user_id@quot;).setValue(userid); deviceDoc.findItem(@quot;binded_user_name@quot;).setValue(securityName); deviceDoc.findItem(@quot;binded_user_telephone@quot;).setValue(telephone); deviceDoc.findItem(@quot;binded_user_idnumber@quot;).setValue(idCardNumber); deviceDoc.findItem(@quot;binded_user_attid@quot;).setValue(attid); deviceDoc.findItem(@quot;binded_assigner_id@quot;).setValue(getWebUser().getId()); deviceDoc.findItem(@quot;binded_assigner_name@quot;).setValue(getWebUser().getName()); deviceDoc.findItem(@quot;binded_assigner_time@quot;).setValue(getToday()); deviceDoc.findItem(@quot;product_category@quot;).setValue(@quot;00001@quot;); process.doUpdate(deviceDoc); var logfromid=@quot;__6rscK9Pm01I8q19OywP@quot;; var process = getDocumentProcess(); var formProcess = getFormProcess(); var logSubform = formProcess.doView(logfromid); var logdoc = process.doNew(logSubform, getWebUser(), createParamsTable()); logdoc.findItem(@quot;device_id@quot;).setValue(deviceId); logdoc.findItem(@quot;binded_user_id@quot;).setValue(userid); logdoc.findItem(@quot;binded_user_name@quot;).setValue(securityName); logdoc.findItem(@quot;binded_assigner_id@quot;).setValue(getWebUser().getId()); logdoc.findItem(@quot;binded_assigner_name@quot;).setValue(getWebUser().getName()); logdoc.findItem(@quot;device_number@quot;).setValue(deviceDoc.findItem(@quot;number@quot;).getValue()); logdoc.findItem(@quot;product_category@quot;).setValue(deviceDoc.findItem(@quot;product_category@quot;).getValue()); logdoc.findItem(@quot;binded_domain_name@quot;).setValue(deviceDoc.findItem(@quot;domain_name@quot;).getValue()); process.doCreate(logdoc); } })() 1680154937718 1680154969596 false false 440;248;369;126 1680154979101 1680154937718 1680154970205 false false 594;239;363;111 1680154986501 ]]> /uploads/exceltemplate/保安员信息.xlsx