-- ============================================================ -- HRM 审批流程分类补齐 + 请假流程绑定到正确分类 -- 生成时间:2026-10-30 -- -- 问题:请假申请「提交审批」报 1030001006,前端拿不到可选流程 -- -- 根因: -- 1. 代码里 HRM 四个审批模块各要求一个分类码: -- hrm_leave_approve / overtime_approve / hrm_resignation_approve / hrm_transfer_approve -- 而 bpm_category 里这四个分类一个都没有 -- 2. 库里已部署的请假流程(key=qingjia)被挂在 -- 「考勤异常审批 hrm_attendance_approve」分类下,按 hrm_leave_approve 过滤查不到 -- -- 做法: -- 1. 补建 4 个分类(幂等) -- 2. 为 qingjia 的每个已部署版本,复制一份 bpm_process_definition_info -- 记录到 hrm_leave_approve 分类,保留原记录的 model_id / 表单 / 流程配置 -- 3. 原有 hrm_attendance_approve 绑定保留不动(不影响其它功能) -- ============================================================ -- ---------- 1. 补建 4 个分类 ---------- INSERT INTO `bpm_category` (`name`, `code`, `description`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT '请假审批', 'hrm_leave_approve', '员工请假申请的审批流程分类', 0, 15, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM `bpm_category` WHERE `code` = 'hrm_leave_approve' AND `deleted` = b'0'); INSERT INTO `bpm_category` (`name`, `code`, `description`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT '加班审批', 'overtime_approve', '员工加班申请的审批流程分类', 0, 16, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM `bpm_category` WHERE `code` = 'overtime_approve' AND `deleted` = b'0'); INSERT INTO `bpm_category` (`name`, `code`, `description`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT '离职审批', 'hrm_resignation_approve', '员工离职申请的审批流程分类', 0, 17, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM `bpm_category` WHERE `code` = 'hrm_resignation_approve' AND `deleted` = b'0'); INSERT INTO `bpm_category` (`name`, `code`, `description`, `status`, `sort`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT '调岗审批', 'hrm_transfer_approve', '员工调岗申请的审批流程分类', 0, 18, '1', NOW(), '1', NOW(), b'0' WHERE NOT EXISTS (SELECT 1 FROM `bpm_category` WHERE `code` = 'hrm_transfer_approve' AND `deleted` = b'0'); -- ---------- 2. 复制 qingjia 的流程定义信息到 hrm_leave_approve ---------- -- 用原记录做模板,保证表单/流程配置完整带过去;model_id 加后缀避免与源记录冲突 INSERT INTO `bpm_process_definition_info` (`process_definition_id`, `model_id`, `model_type`, `category`, `icon`, `description`, `form_type`, `form_id`, `form_conf`, `form_fields`, `form_custom_create_path`, `form_custom_view_path`, `simple_model`, `visible`, `sort`, `start_user_ids`, `start_dept_ids`, `manager_user_ids`, `allow_cancel_running_process`, `allow_withdraw_task`, `process_id_rule`, `auto_approval_type`, `title_setting`, `summary_setting`, `creator`, `create_time`, `updater`, `update_time`, `deleted`) SELECT p.`ID_`, CONCAT(src.`model_id`, '-leave'), src.`model_type`, 'hrm_leave_approve', src.`icon`, src.`description`, src.`form_type`, src.`form_id`, src.`form_conf`, src.`form_fields`, src.`form_custom_create_path`, src.`form_custom_view_path`, src.`simple_model`, src.`visible`, src.`sort`, src.`start_user_ids`, src.`start_dept_ids`, src.`manager_user_ids`, src.`allow_cancel_running_process`, src.`allow_withdraw_task`, src.`process_id_rule`, src.`auto_approval_type`, src.`title_setting`, src.`summary_setting`, '1', NOW(), '1', NOW(), b'0' FROM `act_re_procdef` p JOIN `bpm_process_definition_info` src ON src.`process_definition_id` = p.`ID_` AND src.`deleted` = b'0' WHERE p.`key_` = 'qingjia' AND NOT EXISTS ( SELECT 1 FROM `bpm_process_definition_info` x WHERE x.`process_definition_id` = p.`ID_` AND x.`category` = 'hrm_leave_approve' AND x.`deleted` = b'0' ); -- ---------- 3. 校验 ---------- SELECT id, name, code, status, sort FROM `bpm_category` WHERE code IN ('hrm_leave_approve','overtime_approve','hrm_resignation_approve','hrm_transfer_approve') AND deleted = b'0' ORDER BY sort; SELECT info.`category`, info.`process_definition_id`, p.`name_`, p.`version_`, p.`suspension_state_` AS 状态_1激活, CASE WHEN info.`form_fields` IS NULL THEN '无表单' ELSE '有表单' END AS 表单 FROM `bpm_process_definition_info` info JOIN `act_re_procdef` p ON p.`ID_` = info.`process_definition_id` WHERE info.`category` = 'hrm_leave_approve' AND info.`deleted` = b'0' ORDER BY p.`version_`;