事假病假申请_flow_engine_字段重配.sql
5.25 KB
-- 事假病假申请(F_EnCode=qjsq,F_Id=806449575979123973)
-- 与 PC 页 workFlow/leave-apply-pages/personal-leave-apply + leave-apply-page.vue dataForm 对齐
-- 修正:去掉 formData. 前缀、flowTitl 拼写、startDate/endDate/applyDateText → leaveStartTime/leaveEndTime/applyDate
--
-- 注意:下方 F_FlowTemplateJson 仅适用于「发起节点 → 单一审批节点」的线性流程(与当前库中该流程一致)。
-- 若你在流程设计器里已增加并行/多审批节点,请勿整段覆盖 F_FlowTemplateJson,应只在各节点 properties 内替换 formOperates。
UPDATE flow_engine
SET
F_FormUrl = 'workFlow/leave-apply-pages/personal-leave-apply',
F_AppFormUrl = '/pagesA/personal-leave-apply/personal-leave-apply',
F_FormTemplateJson = '[{"filedName":"流程标题","filedId":"flowTitle","required":false},{"filedName":"单据号","filedId":"billNo","required":false},{"filedName":"紧急程度","filedId":"flowUrgent","required":false},{"filedName":"申请人员","filedId":"applyUser","required":false},{"filedName":"申请日期","filedId":"applyDate","required":false},{"filedName":"申请部门","filedId":"applyDept","required":false},{"filedName":"申请职位","filedId":"applyPost","required":false},{"filedName":"请假类别","filedId":"leaveType","required":false},{"filedName":"请假原因","filedId":"leaveReason","required":false},{"filedName":"开始时间","filedId":"leaveStartTime","required":false},{"filedName":"结束时间","filedId":"leaveEndTime","required":false},{"filedName":"请假天数","filedId":"leaveDayCount","required":false},{"filedName":"请假小时","filedId":"leaveHour","required":false},{"filedName":"相关附件","filedId":"fileJson","required":false}]',
F_FlowTemplateJson = '{"type":"start","content":"所有人","properties":{"initiator":[],"initiatePos":[],"initiateRole":[],"title":"发起节点","formOperates":[{"id":"flowTitle","name":"流程标题","required":false,"read":true,"write":true},{"id":"billNo","name":"单据号","required":false,"read":true,"write":true},{"id":"flowUrgent","name":"紧急程度","required":false,"read":true,"write":true},{"id":"applyUser","name":"申请人员","required":false,"read":true,"write":true},{"id":"applyDate","name":"申请日期","required":false,"read":true,"write":true},{"id":"applyDept","name":"申请部门","required":false,"read":true,"write":true},{"id":"applyPost","name":"申请职位","required":false,"read":true,"write":true},{"id":"leaveType","name":"请假类别","required":false,"read":true,"write":true},{"id":"leaveReason","name":"请假原因","required":false,"read":true,"write":true},{"id":"leaveStartTime","name":"开始时间","required":false,"read":true,"write":true},{"id":"leaveEndTime","name":"结束时间","required":false,"read":true,"write":true},{"id":"leaveDayCount","name":"请假天数","required":false,"read":true,"write":true},{"id":"leaveHour","name":"请假小时","required":false,"read":true,"write":true},{"id":"fileJson","name":"相关附件","required":false,"read":true,"write":true}]},"nodeId":"U3cfV83","childNode":{"type":"approver","content":"管理员/admin","properties":{"title":"审批节点","formOperates":[{"id":"flowTitle","name":"流程标题","required":false,"read":true,"write":false},{"id":"billNo","name":"单据号","required":false,"read":true,"write":false},{"id":"flowUrgent","name":"紧急程度","required":false,"read":true,"write":false},{"id":"applyUser","name":"申请人员","required":false,"read":true,"write":false},{"id":"applyDate","name":"申请日期","required":false,"read":true,"write":false},{"id":"applyDept","name":"申请部门","required":false,"read":true,"write":false},{"id":"applyPost","name":"申请职位","required":false,"read":true,"write":false},{"id":"leaveType","name":"请假类别","required":false,"read":true,"write":false},{"id":"leaveReason","name":"请假原因","required":false,"read":true,"write":false},{"id":"leaveStartTime","name":"开始时间","required":false,"read":true,"write":false},{"id":"leaveEndTime","name":"结束时间","required":false,"read":true,"write":false},{"id":"leaveDayCount","name":"请假天数","required":false,"read":true,"write":false},{"id":"leaveHour","name":"请假小时","required":false,"read":true,"write":false},{"id":"fileJson","name":"相关附件","required":false,"read":true,"write":false}],"approvers":["admin"],"approverPos":[],"approverRole":[],"assigneeType":6,"circulateRole":[],"circulatePosition":[],"circulateUser":[],"isCustomCopy":false,"progress":"50","rejectStep":"0","description":"","managerLevel":1,"countersignRatio":100,"formField":"","nodeId":"","getUserUrl":"","counterSign":0,"noApproverHandler":true,"hasFreeApprover":false,"hasAuditBtn":true,"auditBtnText":"通 过","hasRejectBtn":true,"rejectBtnText":"拒 绝","hasRevokeBtn":true,"revokeBtnText":"撤 回","hasTransferBtn":true,"transferBtnText":"转 办","hasPrintBtn":false,"printBtnText":"打 印","printId":"","hasSign":false,"timeoutConfig":{"on":false,"quantity":1,"type":"day","handler":1},"messageType":[1],"hasApproverFunc":false,"approverInterfaceUrl":"","hasApproverRejectFunc":false,"approverRejectInterfaceUrl":"","approverInterfaceType":"GET","hasRecallFunc":false,"recallInterfaceUrl":""},"nodeId":"sDcfV83","prevId":"U3cfV83"}}'
WHERE F_Id = '806449575979123973';