社区警务项目导入 __DXZvc8mnEmDqMARhK7a __DXZvc8mnEmDqMARhK7a 16 2048 1536 rollback 1685594697467 社区警务 0 424 291 142 34 attendance_site_base_info_s 1685594723946 社区警务名称 0 189 175 142 34 attendanceSiteName false //判断表单某字段不能为空 (function(){ var value = getItemValueAsString(@quot;attendanceSiteName@quot;); if(!isNotNull(value)) { return @quot;社区警务名称必须填写！@quot;; } })() 1685594723946 1685594697467 false false 424;292;296;176 1685594895275 1685595030163 社区警务内容 0 355 180 142 34 attendanceSiteContent false //判断表单某字段不能为空 (function(){ var value = getItemValueAsString(@quot;attendanceSiteContent@quot;); if(!isNotNull(value)) { return @quot;社区警务内容必须填写！@quot;; } })() 1685595030163 1685594697467 false false 424;292;577;176 1685595075055 1685595078993 社区警务详细地址 0 475 179 142 34 attendanceSiteFullAddress false //判断表单某字段不能为空 (function(){ var value = getItemValueAsString(@quot;attendanceSiteFullAddress@quot;); if(!isNotNull(value)) { return @quot;社区警务详细地址必须填写！@quot;; } })() 1685595078993 1685594697467 false false 424;292;655;244 1685595122315 1685595435240 负责人身份证号 0 619 186 142 34 principalIdCardNo false //判断表单某字段不能为空 (function(){ var value = getItemValueAsString(@quot;principalIdCardNo@quot;); if(isNotNull(value)) { var sql = @quot;select @quot;+ @quot;'@quot;+getDomainid()+@quot;' as DOMAINID,ITEM_securityName@quot;+ @quot; from vw_employee@quot;+ @quot; where ITEM_isInMyCompany = '1' and item_documentID='@quot;+value+@quot;' and DOMAINID='@quot;+getDomainid()+@quot;'@quot;; println(@quot;sql--@gt;@quot;+sql); var datas = findBySQL(sql); println(@quot;datas--@gt;@quot;+datas); if(datas == null){ return @quot;负责人应为在职人员@quot;; } }else{ println(@quot;value--@gt;@quot;+value); } })() 1685595522817 执行范围 0 739 195 142 34 performRange false //判断表单某字段不能为空 (function(){ var id=getDomainid(); var process = getDomainProcess();//获取企业域对象 var system_name=process.doView(id); var companyName = system_name.getName(); var value = getItemValueAsString(@quot;principalIdCardNo@quot;); var attendanceSiteName = getItemValueAsString(@quot;attendanceSiteName@quot;); var attendanceSiteContent = getItemValueAsString(@quot;attendanceSiteContent@quot;); var attendanceSiteFullAddress = getItemValueAsString(@quot;attendanceSiteFullAddress@quot;); var principalIdCardNo = getItemValueAsString(@quot;principalIdCardNo@quot;); var performRange = getItemValueAsString(@quot;performRange@quot;); var principal = @quot;@quot;; var principalName = @quot;@quot;; var principalCardType = @quot;@quot;; var principalIdCardNo = @quot;@quot;; var principalPhoneNo = @quot;@quot;; var id = getId(); println(@quot;id====@quot;+id); var today = format(getToday(), @quot;yyyy-MM-dd@quot;); if(isNotNull(value)) { var doc=getCurrentDocument(); var sql = @quot;select @quot;+ @quot;'@quot;+getDomainid()+@quot;' as DOMAINID,@quot;+ @quot;ITEM_userID,@quot;+ //用户ID @quot;ITEM_userID as item_ID,@quot;+ @quot;ITEM_securityName as item_name,@quot; + //保安员姓名 @quot;ITEM_documentType as item_idTYPE,@quot; + //证件类型 @quot;item_documentID as item_idNUMBER,@quot; + //证件号码 @quot;ITEM_phone as item_telephone,@quot; + //手机号 @quot;ITEM_isCertified as item_isCertified,@quot; + //核验状态 @quot;ITEM_shiming as item_CERTIFICATIONSTATUS@quot; + //实名状态 @quot; from vw_employee@quot;+ @quot; where item_documentID='@quot;+value+@quot;' and DOMAINID='@quot;+getDomainid()+@quot;'@quot;; println(@quot;sql--@gt;@quot;+sql); var datart = findBySQL(sql); if(isNotNull(datart)){ principal = datart.getItemValueAsString(@quot;ID@quot;); principalName = datart.getItemValueAsString(@quot;name@quot;); principalCardType = datart.getItemValueAsString(@quot;idTYPE@quot;); principalIdCardNo = datart.getItemValueAsString(@quot;idNUMBER@quot;); principalPhoneNo = datart.getItemValueAsString(@quot;telephone@quot;); if (principalCardType == @quot;1@quot;){ println(@quot;1111111111@quot;) principalCardType = @quot;居民身份证/户口簿@quot;; }else if (principalCardType == @quot;2@quot;){ println(@quot;22222222@quot;) principalCardType = @quot;退伍军人证@quot;; } else if(principalCardType == @quot;3@quot;){ println(@quot;3333333@quot;) principalCardType = @quot;警号@quot;; } else if(principalCardType == @quot;4@quot;){ println(@quot;44444444@quot;) principalCardType = @quot;香港特区护照/身份证@quot;; } else if(principalCardType == @quot;5@quot;){ println(@quot;555555555@quot;) principalCardType = @quot;澳门特区护照/身份证明@quot;; } else if(principalCardType == @quot;6@quot;){ println(@quot;666666666@quot;) principalCardType = @quot;台湾居民来往大陆通行证@quot;; } else if(value == @quot;7@quot;){ println(@quot;7777777777@quot;) principalCardType = @quot;警号@quot;; } else if(principalCardType == @quot;8@quot;){ println(@quot;8888888888@quot;) principalCardType = @quot;外国护照@quot;; } doc.findItem(@quot;principal@quot;).setValue(principal); doc.findItem(@quot;principalName@quot;).setValue(principalName); doc.findItem(@quot;principalCardType@quot;).setValue(principalCardType); doc.findItem(@quot;principalIdCardNo@quot;).setValue(principalIdCardNo); doc.findItem(@quot;principalPhoneNo@quot;).setValue(principalPhoneNo); doc.findItem(@quot;companyName@quot;).setValue(companyName); doc.findItem(@quot;attendanceStartDate@quot;).setValue(today); doc.findItem(@quot;attendanceEndDate@quot;).setValue(@quot;2100-01-01@quot;); doc.findItem(@quot;attendanceSiteState@quot;).setValue(@quot;待完善@quot;); println(@quot;sql--@gt;@quot;+datart.getItemValueAsString(@quot;ID@quot;)); var insql = @quot;INSERT INTO tlk_attendance_site_base_info (id,domainid,item_companyName,item_domain_id,item_company_police,item_attendanceStartDate,item_attendanceEndDate,item_attendanceSiteState,item_attendanceSiteName,item_attendanceSiteType,item_attendanceSiteContent,item_attendanceSiteAddress,item_attendanceSiteFullAddress,item_attendanceSiteLongitude,item_attendanceSiteLatitude,item_performRange,item_officePoliceAddress,item_officePoliceAddressID,item_officePoliceIDIndex,item_principal,item_principalName,item_principalCardType,item_principalIdCardNo,item_principalPhoneNo)VALUES('@quot;+id+@quot;','@quot;+getDomainid()+@quot;','@quot;+companyName+@quot;','@quot;+getDomainid()+@quot;','','@quot;+today+@quot;','2100-01-01','未完善','@quot;+attendanceSiteName+@quot;','','@quot;+attendanceSiteContent+@quot;','','@quot;+attendanceSiteFullAddress+@quot;','00.0000000','00.0000000','@quot;+performRange+@quot;','','','','@quot;+principal+@quot;','@quot;+principalName+@quot;','@quot;+principalCardType+@quot;','@quot;+principalIdCardNo+@quot;','@quot;+principalPhoneNo+@quot;')@quot; println(@quot;insql---------@quot;+insql); insertByDSName(@quot;baibaodunFlow@quot;,insql); }else{ return @quot;@quot;; } } })() //判断表单某字段不能为空 (function(){ var value = getItemValueAsString(@quot;performRange@quot;); if(!isNotNull(value)) { return @quot;执行范围(单位：米）必须填写！@quot;; } })() 1685595435240 1685594697467 false false 424;292;700;192 1685595524857 false false 1685595830662 1685595522817 1685594697467 false false 424;292;1103;199 1685595835323 ]]> /uploads/exceltemplate/社区警务信息导入模板.xlsx