-- ============================================================ -- BPM 审批详情「业务表单」映射配置 -- -- 作用: -- 流程详情页的「审批详情」区域,在流程为「流程表单(NORMAL)」时, -- 会根据 bpm_business_attach 中的 process_definition_key 找到对应的 -- 业务详情组件并渲染,从而显示完整单据信息。 -- -- 说明: -- 1. 本脚本为幂等脚本,重复执行不会产生重复数据。 -- 2. 不包含 tenant_id(项目不使用多租户)。 -- 3. status = 0 表示启用(CommonStatusEnum.ENABLE)。 -- ============================================================ -- 表不存在时创建(幂等,不破坏已有数据) CREATE TABLE IF NOT EXISTS bpm_business_attach ( id BIGINT NOT NULL AUTO_INCREMENT COMMENT '编号', process_definition_key VARCHAR(64) NOT NULL COMMENT '流程定义的 Key', business_type VARCHAR(64) DEFAULT NULL COMMENT '业务类型', component_path VARCHAR(255) NOT NULL COMMENT '业务详情组件路径', status TINYINT NOT NULL DEFAULT 0 COMMENT '状态:0 开启 1 关闭', remark VARCHAR(500) DEFAULT NULL COMMENT '备注', creator VARCHAR(64) DEFAULT '' COMMENT '创建者', create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', updater VARCHAR(64) DEFAULT '' COMMENT '更新者', update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', deleted BIT(1) NOT NULL DEFAULT b'0' COMMENT '是否删除', PRIMARY KEY (id), KEY idx_bpm_business_attach_key (process_definition_key) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = 'BPM 业务附件配置'; INSERT INTO bpm_business_attach (process_definition_key, business_type, component_path, status, remark, creator, updater) SELECT t.k, t.biz, t.path, 0, t.remark, '1', '1' FROM ( -- 已有组件 SELECT 'contract_approve' AS k, 'crm_contract' AS biz, '/crm/contract/detail/approve/index.vue' AS path, 'CRM 合同审批详情' AS remark UNION ALL SELECT 'crm-invoice-audit', 'crm_invoice', '/crm/invoice/detail/approve/index.vue', 'CRM 开票审批详情' UNION ALL SELECT 'crm-receivable-audit', 'crm_receivable', '/crm/receivable/detail/approve/index.vue', 'CRM 回款审批详情' UNION ALL SELECT 'erp-finance-payment-audit', 'erp_finance_payment', '/erp/finance/payment/detail/approve/index.vue', 'ERP 付款单审批详情' UNION ALL SELECT 'hrm_leave_approve', 'hrm_leave_application', '/hrm/leave/detail/approve/index.vue', 'HRM 请假审批详情' UNION ALL SELECT 'hrm_resignation_approve', 'hrm_resignation_application', '/hrm/resignation/detail/approve/index.vue', 'HRM 离职审批详情' UNION ALL SELECT 'hrm_transfer_approve', 'hrm_transfer_application', '/hrm/transfer/detail/approve/index.vue', 'HRM 调动审批详情' UNION ALL SELECT 'hrm_attendance_approve', 'hrm_attendance_exception', '/hrm/attendance/exception/detail/approve/index.vue', 'HRM 考勤异常审批详情' -- 新增组件 UNION ALL SELECT 'refund_approve', 'crm_refund', '/crm/refund/detail/approve/index.vue', 'CRM 退费审批详情' UNION ALL SELECT 'cancellation_approve', 'crm_cancellation', '/crm/cancellation/detail/approve/index.vue', 'CRM 销户审批详情' UNION ALL SELECT 'purchase_plan_approve', 'erp_purchase_plan', '/erp/purchase/plan/detail/approve/index.vue', 'ERP 采购计划审批详情' UNION ALL SELECT 'purchase_request_approve', 'erp_purchase_request', '/erp/purchase/request/detail/approve/index.vue', 'ERP 采购申请审批详情' UNION ALL SELECT 'purchase_approve', 'erp_purchase_order', '/erp/purchase/order/detail/approve/index.vue', 'ERP 采购订单审批详情' UNION ALL SELECT 'hrm_regularize_approve', 'hrm_regularize_application', '/hrm/regularize/detail/approve/index.vue', 'HRM 转正审批详情' UNION ALL SELECT 'performance_appraise_approve', 'hrm_performance_appraise', '/hrm/performance-appraise/detail/approve/index.vue', 'HRM 绩效考核审批详情' UNION ALL SELECT 'mes-pd-project-audit', 'mes_pd_project', '/mes/pd/project/detail/approve/index.vue', 'MES 设计项目审批详情' UNION ALL SELECT 'pd_tech_confirm_approve', 'product_tech_confirm', '/mes/pd/tech-confirm/detail/approve/index.vue', 'MES 技术确认函审批详情' UNION ALL SELECT 'equipment_receipt_approve', 'mes_wm_equipment_receipt', '/wls/equipmentreceipt/detail/approve/index.vue', 'MES 设备入库审批详情' UNION ALL SELECT 'item_receipt_approve', 'mes_wm_item_receipt', '/wls/itemreceipt/detail/approve/index.vue', 'MES 采购入库审批详情' UNION ALL SELECT 'misc_issue_approve', 'mes_wm_misc_issue', '/wls/miscissue/detail/approve/index.vue', 'MES 杂项出库审批详情' UNION ALL SELECT 'misc_receipt_approve', 'mes_wm_misc_receipt', '/wls/miscreceipt/detail/approve/index.vue', 'MES 杂项入库审批详情' UNION ALL SELECT 'return_vendor_approve', 'mes_wm_return_vendor', '/wls/returnvendor/detail/approve/index.vue', 'MES 供应商退货审批详情' UNION ALL SELECT 'stock_taking_result_approve', 'mes_wm_stock_taking_task', '/wls/stocktaking/task/detail/approve/index.vue', 'MES 盘点结果审批详情' UNION ALL SELECT 'compensation_approve', 'after_sale_compensation', '/aftersales/compensation/detail/approve/index.vue', '售后赔付审批详情' ) t WHERE NOT EXISTS ( SELECT 1 FROM bpm_business_attach a WHERE a.process_definition_key = t.k ); -- 已有配置若被禁用或路径不对,统一修正为启用状态 UPDATE bpm_business_attach SET status = 0 WHERE process_definition_key IN ( 'contract_approve', 'crm-invoice-audit', 'crm-receivable-audit', 'erp-finance-payment-audit', 'hrm_leave_approve', 'hrm_resignation_approve', 'hrm_transfer_approve', 'hrm_attendance_approve', 'refund_approve', 'cancellation_approve', 'purchase_plan_approve', 'purchase_request_approve', 'purchase_approve', 'hrm_regularize_approve', 'performance_appraise_approve', 'mes-pd-project-audit', 'pd_tech_confirm_approve', 'equipment_receipt_approve', 'item_receipt_approve', 'misc_issue_approve', 'misc_receipt_approve', 'return_vendor_approve', 'stock_taking_result_approve', 'compensation_approve' );