④内部公开请勿外传移动签到审批列表关联出差信息1.新增移动签到业务数据源普通用户登入客户端-企业建模-业务对象建模-动态扩展平台-动态扩展平台高级版，如图将动态扩展平台方案反启用，如图向导增加移动签到数据业务数据源，如图1/9④内部公开请勿外传2/9④内部公开请勿外传增加表关联3/9④内部公开请勿外传其他关联表类似，注意关联条件4/9④内部公开请勿外传表达式中需要增加脚本ANDTO_CHAR(SignRecord.FSIGNTIME,'yyyy-MM-dd')>=TO_CHAR(AtsTripBillEntry.FrealTripStartTime,'yyyy-MM-dd')ANDTO_CHAR(SignRecord.FSIGNTIME,'yyyy-MM-dd')<=TO_CHAR(AtsTripBillEntry.FrealTripEndTime,'yyyy-MM-dd')。导入字段5/9④内部公开请勿外传下列字段是测试配置的，从脚本中考出，供参考"SIGNRECORD".FIDAS"ID","SIGNRECORD".FLatitudeAS"LATITUDE","SIGNRECORD".FLongitudeAS"LONGITUDE","SIGNRECORD".FSignTypeAS"SIGNTYPE","PERSON".FNumberAS"PERSON.NUMBER","PERSON".FName_l2AS"PERSON.NAME","ADMINORG".FName_l2AS"ADMINORG.NAME","SIGNRECORD".FSignDateAS"SIGNDATE","SIGNRECORD".FSignTimeAS"SIGNTIME","SIGNRECORD".FAddressAS"ADDRESS","SIGNRECORD".FNoteAS"NOTE","SIGNRECORD".FAuditOpinionAS"AUDITOPINION","SIGNRECORD".FPersonIDAS"PERSON.ID","IMAGE".FTypeAS"IMAGE.TYPE","IMAGE".FFileAS"IMAGE.FILE","IMAGE".FSizeAS"IMAGE.SIZE","IMAGE".FSizeInByteAS"IMAGE.SIZEINBYTE","IMAGE".FStorageTypeAS"IMAGE.STORAGETYPE","IMAGE".FRemotePathAS"IMAGE.REMOTEPATH",6/9④内部公开请勿外传"IMAGE".FName_l2AS"IMAGE.NAME","IMAGE".FNumberAS"IMAGE.NUMBER","SIGNRECORD".FImageIDAS"IMAGE.ID","ADMINORG".FNumberAS"ADMINORG.NUMBER","SIGNRECORD".FAdminOrgIDAS"ADMINORG.ID","ADMINORG".FIsLeafAS"ADMINORG.ISLEAF","ADMINORG".FLevelAS"ADMINORG.LEVEL","ADMINORG".FLongNumberAS"ADMINORG.LONGNUMBER","ADMINORG".FDisplayName_l2AS"ADMINORG.DISPLAYNAME","ATTACHMENT".FFileAS"ATTACHMENT.FILE","ATTACHMENT".FRemotePathAS"ATTACHMENT.REMOTEPATH","ATTACHMENT".FIDAS"ATTACHMENT.ID","ATTADMINORGUNIT".FLongNumberAS"ATTADMINORGUNIT.LONGNUMBER","ATTADMINORGUNIT".FDisplayName_l2AS"ATTADMINORGUNIT.DISPLAYNAME","ATTADMINORGUNIT".FName_l2AS"ATTADMINORGUNIT.NAME","ATTADMINORGUNIT".FNumberAS"ATTADMINORGUNIT.NUMBER","SIGNRECORD".FAttAdminOrgUnitIDAS"ATTADMINORGUNIT.ID","ATSTRIPBILLENTRY".FRealTripStartTimeAS"ATSTRIPBILLENTRY.REALTRIPSTA36","ATSTRIPBILLENTRY".FRealTripEndTimeAS"ATSTRIPBILLENTRY.REALTRIPEND37","ATSTRIPBILLENTRY".FTripReasonAS"ATSTRIPBILLENTRY.TRIPREASON","ATSTRIPBILLENTRY".FTripEndPlaceAS"ATSTRIPBILLENTRY.TRIPENDPLACE","ATSTRIPBILL".FNumberAS"ATSTRIPBILL.NUMBER","ATSTRIPBILL".FBillStateAS"ATSTRIPBILL.BILLSTATE","SIGNRECORD".FHrOrgUnitIDAS"HRORGUNIT.ID","HRORGUNIT".FName_l2AS"HRORGUNIT.NAME","HRORGUNIT".FNumberAS"HRORGUNIT.NUMBER"增加主键检查脚本7/9④内部公开请勿外传检查无误后，别忘了保存并启用2.修改视图Administrator登入web端-开发平台-视图，在视图列表中搜索移动签到8/9④内部公开请勿外传调整完后注意保存。3.效果图专业用户s-HR考勤管理-移动签到审核列表查看效果9/9
