-- ============================================================ -- 撤回:删除我之前误建的 HRM 审批分类 -- 生成时间:2026-10-30 -- -- 背景:上一轮我误判请假审批缺少 BPM 分类,新建了 4 个分类, -- 并把 qingjia 的流程定义复制了一份挂到 hrm_leave_approve 下。 -- -- 实际情况:请假审批本来就该归在「考勤异常审批 hrm_attendance_approve」 -- 分类下(原绑定 id=13/14 一直都在),不需要单独分类。 -- -- 本次处理: -- 1. 删除我复制的 2 条流程绑定(id=20/21,model_id 带 -leave 后缀) -- 2. 删除 4 个误建分类(其中 hrm_leave_approve 有绑定,另 3 个是空壳) -- 3. 代码侧 HrmLeaveApplicationService.APPROVE_CATEGORY_CODE -- 已改为 hrm_attendance_approve,保持与原绑定一致 -- -- 保留:hrm_attendance_approve 分类及其原有的 2 条 qingjia 绑定(id=13/14) -- 幂等:可重复执行 -- ============================================================ -- ---------- 1. 处理前快照 ---------- SELECT '分类' AS 项, id, name, code FROM bpm_category WHERE code IN ('hrm_leave_approve','overtime_approve','hrm_resignation_approve','hrm_transfer_approve') AND deleted = b'0' UNION ALL SELECT '绑定', id, model_id, category FROM bpm_process_definition_info WHERE category = 'hrm_leave_approve' AND deleted = b'0'; -- ---------- 2. 删除我复制的流程绑定(只删 model_id 带 -leave 后缀的)---------- DELETE FROM bpm_process_definition_info WHERE category = 'hrm_leave_approve' AND model_id LIKE '%-leave'; -- ---------- 3. 删除 4 个误建分类 ---------- DELETE FROM bpm_category WHERE code IN ('hrm_leave_approve','overtime_approve','hrm_resignation_approve','hrm_transfer_approve') AND deleted = b'0'; -- ---------- 4. 校验:这些分类应已不存在 ---------- SELECT COUNT(*) AS 残留分类数 FROM bpm_category WHERE code IN ('hrm_leave_approve','overtime_approve','hrm_resignation_approve','hrm_transfer_approve'); SELECT COUNT(*) AS 残留绑定位数 FROM bpm_process_definition_info WHERE category = 'hrm_leave_approve'; -- ---------- 5. 确认原绑定完好(应为 2 条:qingjia v1/v2)---------- SELECT id, process_definition_id, category FROM bpm_process_definition_info WHERE category = 'hrm_attendance_approve' AND deleted = b'0' ORDER BY id;