-- ============================================================================= -- 补部署 SRM 询价单审批流程:srm_inquiry_approve -- 目标库:mom-ntsh -- 背景:SrmInquiryServiceImpl 提交审核时使用流程 key=srm_inquiry_approve, -- 但 ACT_RE_PROCDEF 中不存在该定义,前端提交报「流程定义不存在」。 -- 方式:复制采购申请审批(purchase_request_approve,发起人 + 角色1审批)模板, -- 仅替换 key 与显示名,保持与采购单据审批一致的审批人配置。 -- 幂等:key 已存在则跳过,可重复执行。 -- ============================================================================= SET NAMES utf8mb4; -- 流程分类(幂等) INSERT INTO bpm_category (name, code, description, status, sort, creator, updater, deleted) SELECT '询价单审批', 'srm_inquiry_approve', '询价单审批', 0, 23, '1', '1', b'0' WHERE NOT EXISTS (SELECT 1 FROM bpm_category WHERE code = 'srm_inquiry_approve' AND deleted = b'0'); -- 审批详情业务组件(幂等):让审批详情页渲染询价明细而非空白通用表单 INSERT INTO bpm_business_attach (process_definition_key, business_type, component_path, status, remark, creator, updater, deleted) SELECT 'srm_inquiry_approve', 'srm_inquiry', '/srm/inquiry/detail/approve/index.vue', 0, '询价单审批业务详情组件', '1', '1', b'0' WHERE NOT EXISTS (SELECT 1 FROM bpm_business_attach WHERE process_definition_key = 'srm_inquiry_approve' AND deleted = b'0'); DROP PROCEDURE IF EXISTS bpm_deploy_srm_inquiry_approve; DELIMITER $$ CREATE PROCEDURE bpm_deploy_srm_inquiry_approve() label_deploy: BEGIN DECLARE v_p_key VARCHAR(64) DEFAULT 'srm_inquiry_approve'; DECLARE v_p_name VARCHAR(128) DEFAULT '询价单审批'; DECLARE v_p_category VARCHAR(64) DEFAULT 'srm_inquiry_approve'; DECLARE v_tpl_key VARCHAR(64) DEFAULT 'purchase_request_approve'; DECLARE v_exist INT DEFAULT 0; DECLARE v_tpl_dep VARCHAR(64) DEFAULT NULL; DECLARE v_tpl_name VARCHAR(255) DEFAULT NULL; DECLARE v_dep VARCHAR(64); DECLARE v_model_id VARCHAR(64); DECLARE v_byte_id VARCHAR(64); DECLARE v_procdef_id VARCHAR(64); DECLARE v_meta TEXT; DECLARE v_sort BIGINT; DECLARE v_now DATETIME; DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; SELECT COUNT(*) INTO v_exist FROM ACT_RE_PROCDEF WHERE KEY_ = v_p_key; IF v_exist > 0 THEN SELECT CONCAT('[SKIP] 流程已存在,跳过:', v_p_key) AS deploy_result; LEAVE label_deploy; END IF; SELECT DEPLOYMENT_ID_ INTO v_tpl_dep FROM ACT_RE_PROCDEF WHERE KEY_ = v_tpl_key ORDER BY VERSION_ DESC LIMIT 1; SELECT NAME_ INTO v_tpl_name FROM ACT_RE_PROCDEF WHERE KEY_ = v_tpl_key ORDER BY VERSION_ DESC LIMIT 1; IF v_tpl_dep IS NULL THEN SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = '模板流程 purchase_request_approve 不存在,无法复制'; END IF; SET v_now = NOW(3); SET v_sort = UNIX_TIMESTAMP(v_now) * 1000; SET v_dep = REPLACE(UUID(), '-', ''); SET v_model_id = REPLACE(UUID(), '-', ''); SET v_byte_id = REPLACE(UUID(), '-', ''); SET v_procdef_id = CONCAT(v_p_key, ':1:', v_dep); START TRANSACTION; -- 1) 部署记录 INSERT INTO ACT_RE_DEPLOYMENT (ID_, NAME_, CATEGORY_, KEY_, TENANT_ID_, DEPLOY_TIME_, ENGINE_VERSION_) VALUES (v_dep, v_p_name, v_p_category, v_p_key, '', v_now, NULL); -- 2) BPMN 字节(替换 key 与显示名) INSERT INTO ACT_GE_BYTEARRAY (ID_, NAME_, DEPLOYMENT_ID_, BYTES_, GENERATED_) SELECT v_byte_id, CONCAT(v_p_key, '.bpmn'), v_dep, CONVERT( REPLACE( REPLACE(CONVERT(BYTES_ USING utf8mb4), v_tpl_key, v_p_key), v_tpl_name, v_p_name) USING utf8mb4), 0 FROM ACT_GE_BYTEARRAY WHERE DEPLOYMENT_ID_ = v_tpl_dep AND NAME_ = CONCAT(v_tpl_key, '.bpmn'); -- 3) 流程定义 INSERT INTO ACT_RE_PROCDEF (ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, HAS_GRAPHICAL_NOTATION_, SUSPENSION_STATE_, TENANT_ID_, ENGINE_VERSION_, DERIVED_VERSION_) VALUES (v_procdef_id, 1, v_p_category, v_p_name, v_p_key, 1, v_dep, CONCAT(v_p_key, '.bpmn'), NULL, NULL, 0, 1, 1, '', NULL, 0); -- 4) 流程模型 SET v_meta = CONCAT( '{"type":10,"formType":10,"sort":', v_sort, ',"visible":true,"allowCancelRunningProcess":true,"allowWithdrawTask":false', ',"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"",', '"formId":4,"managerUserIds":[],"startUserIds":[],"startDeptIds":[],"icon":null,', '"processBeforeTriggerSetting":null,"processAfterTriggerSetting":null,', '"taskBeforeTriggerSetting":null,"taskAfterTriggerSetting":null,', '"printTemplateSetting":null,"summarySetting":null,"titleSetting":null,"processIdRule":null}'); INSERT INTO ACT_RE_MODEL (ID_, NAME_, KEY_, CATEGORY_, CREATE_TIME_, LAST_UPDATE_TIME_, VERSION_, META_INFO_, DEPLOYMENT_ID_, TENANT_ID_) VALUES (v_model_id, v_p_name, v_p_key, v_p_category, v_now, v_now, 1, v_meta, v_dep, ''); -- 5) 流程定义扩展信息(通用审批表单 id=4) INSERT INTO bpm_process_definition_info (process_definition_id, model_id, model_type, category, form_type, form_id, visible, sort, allow_cancel_running_process, allow_withdraw_task, creator, create_time, updater, update_time, deleted) VALUES (v_procdef_id, v_model_id, 10, v_p_category, 10, 4, 1, v_sort, 1, 1, '1', v_now, '1', v_now, 0); COMMIT; SELECT CONCAT('[OK] 已部署新审核流程:', v_p_key, ' (procdef=', v_procdef_id, ')') AS deploy_result; END$$ DELIMITER ; CALL bpm_deploy_srm_inquiry_approve(); -- 校验 SELECT p.KEY_, p.NAME_, p.VERSION_, p.SUSPENSION_STATE_ AS active_flag, i.model_type, i.category, i.form_id FROM ACT_RE_PROCDEF p LEFT JOIN bpm_process_definition_info i ON i.process_definition_id = p.ID_ WHERE p.KEY_ = 'srm_inquiry_approve';