-- 用印审批详情:展示使用的印章信息,并支持预览印章图片 -- -- 机制:bpm_business_attach 把「流程 Key」映射到业务详情组件, -- 审批详情页在 processDefinition 为普通表单且带 businessKey 时自动改为 CUSTOM, -- 渲染 component_path 指向的组件,并把 businessKey(用印申请 id)作为 id 传入。 -- 本脚本幂等,可重复执行。 INSERT INTO bpm_business_attach (process_definition_key, business_type, component_path, status, remark, creator, create_time, updater, update_time, deleted) SELECT 'hrm-seal-use-approval', 'pd_seal_application', '/mes/pd/seal/detail/approve/index.vue', 0, '用印审批展示用印申请信息与印章图片', '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS ( SELECT 1 FROM bpm_business_attach WHERE process_definition_key = 'hrm-seal-use-approval' AND deleted = b'0' ); UPDATE bpm_business_attach SET component_path = '/mes/pd/seal/detail/approve/index.vue', business_type = 'pd_seal_application', status = 0, updater = '1', update_time = NOW() WHERE process_definition_key = 'hrm-seal-use-approval' AND deleted = b'0'; -- 校验:应返回 1 行,status=0(启用) SELECT id, process_definition_key, component_path, status FROM bpm_business_attach WHERE process_definition_key = 'hrm-seal-use-approval' AND deleted = b'0';