-- ===================================================================== -- MES 仓储域 BPM 审批流程手工部署脚本 -- 目标库：mom-xgdl（local profile） -- -- 部署 6 个专用流程，流程定义 KEY_ 与各业务监听器 getProcessDefinitionKey() 完全一致： -- 分类/KEY_ 流程名 监听器 -- misc_receipt_approve 杂项入库审批流程 MesWmMiscReceiptStatusListener -- misc_issue_approve 杂项出库审批流程 MesWmMiscIssueStatusListener -- return_vendor_approve 供应商退货审批流程 MesWmReturnVendorStatusListener -- item_receipt_approve 采购入库审批流程 MesWmItemReceiptStatusListener -- stock_taking_result_approve 盘点结果审批流程 MesWmStockTakingTaskResultStatusListener -- equipment_receipt_approve 设备入库审批流程 MesWmEquipmentReceiptStatusListener -- -- BPMN 模板：crm-invoice-audit（candidateStrategy=36 发起人提交自动通过）复制并替换 key/名称。 -- 约束遵守 bpm-manual-deployment 记忆： -- model_type=10；ENGINE_VERSION_ 留 NULL（不写空串）；META_INFO_ 含 sort；deployment=32位无横线ID。 -- ===================================================================== SET NAMES utf8mb4; -- 1. ACT_RE_DEPLOYMENT ------------------------------------------------- INSERT INTO `mom-xgdl`.`ACT_RE_DEPLOYMENT` (ID_, NAME_, CATEGORY_, KEY_, TENANT_ID_, DEPLOY_TIME_, ENGINE_VERSION_) VALUES ('10000000000000000000000000000001', '杂项入库审批流程', 'misc_receipt_approve', '', '', NOW(), NULL), ('10000000000000000000000000000002', '杂项出库审批流程', 'misc_issue_approve', '', '', NOW(), NULL), ('10000000000000000000000000000003', '供应商退货审批流程', 'return_vendor_approve', '', '', NOW(), NULL), ('10000000000000000000000000000004', '采购入库审批流程', 'item_receipt_approve', '', '', NOW(), NULL), ('10000000000000000000000000000005', '盘点结果审批流程', 'stock_taking_result_approve', '', '', NOW(), NULL), ('10000000000000000000000000000006', '设备入库审批流程', 'equipment_receipt_approve', '', '', NOW(), NULL); -- 2. ACT_GE_BYTEARRAY（BPMN XML：从 crm-invoice-audit 模板复制并替换 key/名称）---- INSERT INTO `mom-xgdl`.`ACT_GE_BYTEARRAY` (ID_, REV_, NAME_, DEPLOYMENT_ID_, BYTES_, GENERATED_) SELECT '30000000000000000000000000000001', 1, 'misc_receipt_approve.bpmn', '10000000000000000000000000000001', CAST(REPLACE(REPLACE(CONVERT(BYTES_ USING utf8mb4), 'crm-invoice-audit', 'misc_receipt_approve'), '开票审批流程', '杂项入库审批流程') AS BINARY), 0 FROM `mom-xgdl`.`ACT_GE_BYTEARRAY` WHERE ID_ = 'c101d3e1-0001-11f2-8a27-00155dad6485' UNION ALL SELECT '30000000000000000000000000000002', 1, 'misc_issue_approve.bpmn', '10000000000000000000000000000002', CAST(REPLACE(REPLACE(CONVERT(BYTES_ USING utf8mb4), 'crm-invoice-audit', 'misc_issue_approve'), '开票审批流程', '杂项出库审批流程') AS BINARY), 0 FROM `mom-xgdl`.`ACT_GE_BYTEARRAY` WHERE ID_ = 'c101d3e1-0001-11f2-8a27-00155dad6485' UNION ALL SELECT '30000000000000000000000000000003', 1, 'return_vendor_approve.bpmn', '10000000000000000000000000000003', CAST(REPLACE(REPLACE(CONVERT(BYTES_ USING utf8mb4), 'crm-invoice-audit', 'return_vendor_approve'), '开票审批流程', '供应商退货审批流程') AS BINARY), 0 FROM `mom-xgdl`.`ACT_GE_BYTEARRAY` WHERE ID_ = 'c101d3e1-0001-11f2-8a27-00155dad6485' UNION ALL SELECT '30000000000000000000000000000004', 1, 'item_receipt_approve.bpmn', '10000000000000000000000000000004', CAST(REPLACE(REPLACE(CONVERT(BYTES_ USING utf8mb4), 'crm-invoice-audit', 'item_receipt_approve'), '开票审批流程', '采购入库审批流程') AS BINARY), 0 FROM `mom-xgdl`.`ACT_GE_BYTEARRAY` WHERE ID_ = 'c101d3e1-0001-11f2-8a27-00155dad6485' UNION ALL SELECT '30000000000000000000000000000005', 1, 'stock_taking_result_approve.bpmn', '10000000000000000000000000000005', CAST(REPLACE(REPLACE(CONVERT(BYTES_ USING utf8mb4), 'crm-invoice-audit', 'stock_taking_result_approve'), '开票审批流程', '盘点结果审批流程') AS BINARY), 0 FROM `mom-xgdl`.`ACT_GE_BYTEARRAY` WHERE ID_ = 'c101d3e1-0001-11f2-8a27-00155dad6485' UNION ALL SELECT '30000000000000000000000000000006', 1, 'equipment_receipt_approve.bpmn', '10000000000000000000000000000006', CAST(REPLACE(REPLACE(CONVERT(BYTES_ USING utf8mb4), 'crm-invoice-audit', 'equipment_receipt_approve'), '开票审批流程', '设备入库审批流程') AS BINARY), 0 FROM `mom-xgdl`.`ACT_GE_BYTEARRAY` WHERE ID_ = 'c101d3e1-0001-11f2-8a27-00155dad6485'; -- 3. ACT_RE_PROCDEF（ENGINE_VERSION_ 必须 NULL，不写空串）---------------- INSERT INTO `mom-xgdl`.`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_FROM_, DERIVED_FROM_ROOT_, DERIVED_VERSION_) VALUES ('misc_receipt_approve:1:10000000000000000000000000000001', 1, 'misc_receipt_approve', '杂项入库审批流程', 'misc_receipt_approve', 1, '10000000000000000000000000000001', 'misc_receipt_approve.bpmn', '', '', 0, 0, 1, '', NULL, '', '', 0), ('misc_issue_approve:1:10000000000000000000000000000002', 1, 'misc_issue_approve', '杂项出库审批流程', 'misc_issue_approve', 1, '10000000000000000000000000000002', 'misc_issue_approve.bpmn', '', '', 0, 0, 1, '', NULL, '', '', 0), ('return_vendor_approve:1:10000000000000000000000000000003', 1, 'return_vendor_approve', '供应商退货审批流程', 'return_vendor_approve', 1, '10000000000000000000000000000003', 'return_vendor_approve.bpmn', '', '', 0, 0, 1, '', NULL, '', '', 0), ('item_receipt_approve:1:10000000000000000000000000000004', 1, 'item_receipt_approve', '采购入库审批流程', 'item_receipt_approve', 1, '10000000000000000000000000000004', 'item_receipt_approve.bpmn', '', '', 0, 0, 1, '', NULL, '', '', 0), ('stock_taking_result_approve:1:10000000000000000000000000000005', 1, 'stock_taking_result_approve', '盘点结果审批流程', 'stock_taking_result_approve', 1, '10000000000000000000000000000005', 'stock_taking_result_approve.bpmn', '', '', 0, 0, 1, '', NULL, '', '', 0), ('equipment_receipt_approve:1:10000000000000000000000000000006', 1, 'equipment_receipt_approve', '设备入库审批流程', 'equipment_receipt_approve', 1, '10000000000000000000000000000006', 'equipment_receipt_approve.bpmn', '', '', 0, 0, 1, '', NULL, '', '', 0); -- 4. ACT_RE_MODEL（META_INFO_ 含 sort；EDITOR_SOURCE_VALUE_ID_ 对齐 BPMN bytearray）---- INSERT INTO `mom-xgdl`.`ACT_RE_MODEL` (ID_, REV_, NAME_, KEY_, CATEGORY_, CREATE_TIME_, LAST_UPDATE_TIME_, VERSION_, META_INFO_, DEPLOYMENT_ID_, EDITOR_SOURCE_VALUE_ID_, EDITOR_SOURCE_EXTRA_VALUE_ID_, TENANT_ID_) VALUES ('20000000000000000000000000000001', 1, '杂项入库审批流程', 'misc_receipt_approve', 'misc_receipt_approve', NOW(), NOW(), 1, '{"allowCancelRunningProcess":true,"allowWithdrawTask":false,"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"","formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":{"enable":false,"template":""},"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":{"enable":false,"infix":"","length":5,"postfix":"","prefix":""},"sort":1785465606001,"startDeptIds":[],"startUserIds":[],"summarySetting":{"enable":false,"summary":[]},"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":{"enable":false,"title":""},"type":10,"visible":true}', '10000000000000000000000000000001', '30000000000000000000000000000001', NULL, ''), ('20000000000000000000000000000002', 1, '杂项出库审批流程', 'misc_issue_approve', 'misc_issue_approve', NOW(), NOW(), 1, '{"allowCancelRunningProcess":true,"allowWithdrawTask":false,"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"","formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":{"enable":false,"template":""},"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":{"enable":false,"infix":"","length":5,"postfix":"","prefix":""},"sort":1785465606002,"startDeptIds":[],"startUserIds":[],"summarySetting":{"enable":false,"summary":[]},"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":{"enable":false,"title":""},"type":10,"visible":true}', '10000000000000000000000000000002', '30000000000000000000000000000002', NULL, ''), ('20000000000000000000000000000003', 1, '供应商退货审批流程', 'return_vendor_approve', 'return_vendor_approve', NOW(), NOW(), 1, '{"allowCancelRunningProcess":true,"allowWithdrawTask":false,"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"","formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":{"enable":false,"template":""},"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":{"enable":false,"infix":"","length":5,"postfix":"","prefix":""},"sort":1785465606003,"startDeptIds":[],"startUserIds":[],"summarySetting":{"enable":false,"summary":[]},"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":{"enable":false,"title":""},"type":10,"visible":true}', '10000000000000000000000000000003', '30000000000000000000000000000003', NULL, ''), ('20000000000000000000000000000004', 1, '采购入库审批流程', 'item_receipt_approve', 'item_receipt_approve', NOW(), NOW(), 1, '{"allowCancelRunningProcess":true,"allowWithdrawTask":false,"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"","formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":{"enable":false,"template":""},"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":{"enable":false,"infix":"","length":5,"postfix":"","prefix":""},"sort":1785465606004,"startDeptIds":[],"startUserIds":[],"summarySetting":{"enable":false,"summary":[]},"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":{"enable":false,"title":""},"type":10,"visible":true}', '10000000000000000000000000000004', '30000000000000000000000000000004', NULL, ''), ('20000000000000000000000000000005', 1, '盘点结果审批流程', 'stock_taking_result_approve', 'stock_taking_result_approve', NOW(), NOW(), 1, '{"allowCancelRunningProcess":true,"allowWithdrawTask":false,"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"","formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":{"enable":false,"template":""},"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":{"enable":false,"infix":"","length":5,"postfix":"","prefix":""},"sort":1785465606005,"startDeptIds":[],"startUserIds":[],"summarySetting":{"enable":false,"summary":[]},"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":{"enable":false,"title":""},"type":10,"visible":true}', '10000000000000000000000000000005', '30000000000000000000000000000005', NULL, ''), ('20000000000000000000000000000006', 1, '设备入库审批流程', 'equipment_receipt_approve', 'equipment_receipt_approve', NOW(), NOW(), 1, '{"allowCancelRunningProcess":true,"allowWithdrawTask":false,"autoApprovalType":0,"description":"","formCustomCreatePath":"","formCustomViewPath":"","formId":1,"formType":10,"icon":null,"managerUserIds":[1],"printTemplateSetting":{"enable":false,"template":""},"processAfterTriggerSetting":null,"processBeforeTriggerSetting":null,"processIdRule":{"enable":false,"infix":"","length":5,"postfix":"","prefix":""},"sort":1785465606006,"startDeptIds":[],"startUserIds":[],"summarySetting":{"enable":false,"summary":[]},"taskAfterTriggerSetting":null,"taskBeforeTriggerSetting":null,"titleSetting":{"enable":false,"title":""},"type":10,"visible":true}', '10000000000000000000000000000006', '30000000000000000000000000000006', NULL, ''); -- 5. bpm_process_definition_info（model_type=10，deleted=0）--------------- INSERT INTO `mom-xgdl`.`bpm_process_definition_info` (process_definition_id, model_id, model_type, category, icon, description, form_type, form_id, form_conf, form_fields, simple_model, visible, sort, start_user_ids, start_dept_ids, manager_user_ids, allow_cancel_running_process, allow_withdraw_task, deleted, creator, create_time, updater, update_time) VALUES ('misc_receipt_approve:1:10000000000000000000000000000001', '20000000000000000000000000000001', 10, 'misc_receipt_approve', NULL, NULL, 10, 1, '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"重置"},"submitBtn":{"show":true,"innerText":"提交"}}', '[]', NULL, 1, 1785465606001, NULL, NULL, '1', 1, 1, 0, '1', NOW(), '1', NOW()), ('misc_issue_approve:1:10000000000000000000000000000002', '20000000000000000000000000000002', 10, 'misc_issue_approve', NULL, NULL, 10, 1, '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"重置"},"submitBtn":{"show":true,"innerText":"提交"}}', '[]', NULL, 1, 1785465606002, NULL, NULL, '1', 1, 1, 0, '1', NOW(), '1', NOW()), ('return_vendor_approve:1:10000000000000000000000000000003', '20000000000000000000000000000003', 10, 'return_vendor_approve', NULL, NULL, 10, 1, '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"重置"},"submitBtn":{"show":true,"innerText":"提交"}}', '[]', NULL, 1, 1785465606003, NULL, NULL, '1', 1, 1, 0, '1', NOW(), '1', NOW()), ('item_receipt_approve:1:10000000000000000000000000000004', '20000000000000000000000000000004', 10, 'item_receipt_approve', NULL, NULL, 10, 1, '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"重置"},"submitBtn":{"show":true,"innerText":"提交"}}', '[]', NULL, 1, 1785465606004, NULL, NULL, '1', 1, 1, 0, '1', NOW(), '1', NOW()), ('stock_taking_result_approve:1:10000000000000000000000000000005', '20000000000000000000000000000005', 10, 'stock_taking_result_approve', NULL, NULL, 10, 1, '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"重置"},"submitBtn":{"show":true,"innerText":"提交"}}', '[]', NULL, 1, 1785465606005, NULL, NULL, '1', 1, 1, 0, '1', NOW(), '1', NOW()), ('equipment_receipt_approve:1:10000000000000000000000000000006', '20000000000000000000000000000006', 10, 'equipment_receipt_approve', NULL, NULL, 10, 1, '{"form":{"layout":"horizontal","labelAlign":"right","size":"middle","colon":false,"labelCol":{"style":{"width":"125px"}},"wrapperCol":{"span":24},"labelWidth":"100px"},"resetBtn":{"show":false,"innerText":"重置"},"submitBtn":{"show":true,"innerText":"提交"}}', '[]', NULL, 1, 1785465606006, NULL, NULL, '1', 1, 1, 0, '1', NOW(), '1', NOW()); -- ===================================================================== -- 附录：M6 菜单/权限补充（已在 mom-xgdl 执行） -- 重复执行会主键冲突，注意幂等。 -- ===================================================================== -- SN 码补"更新"按钮（出入库/详情接口依赖 mes:wm-sn:update） INSERT INTO `mom-xgdl`.`system_menu` (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (1065725, 'SN 码更新', 'mes:wm-sn:update', 3, 3, 5897, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'); -- 设备入库单菜单（仓储物流 5780 下，组件 wls/equipmentreceipt/index） INSERT INTO `mom-xgdl`.`system_menu` (id, name, permission, type, sort, parent_id, path, icon, component, component_name, status, visible, keep_alive, always_show, creator, create_time, updater, update_time, deleted) VALUES (1065726, '设备入库', '', 2, 20, 5780, 'equipment-receipt', 'fa-solid:box-open', 'wls/equipmentreceipt/index', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065727, '设备入库查询', 'mes:wm:equipment-receipt:query', 3, 1, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065728, '设备入库创建', 'mes:wm:equipment-receipt:create', 3, 2, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065729, '设备入库更新', 'mes:wm:equipment-receipt:update', 3, 3, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065730, '设备入库删除', 'mes:wm:equipment-receipt:delete', 3, 4, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065731, '设备入库提交', 'mes:wm:equipment-receipt:submit', 3, 5, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065732, '设备入库执行', 'mes:wm:equipment-receipt:finish', 3, 6, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0'), (1065733, '设备入库取消', 'mes:wm:equipment-receipt:cancel', 3, 7, 1065726, '', '', '', '', 0, b'1', b'1', b'1', '1', NOW(), '1', NOW(), b'0');