-- ============================================================
|
-- 撤回:删除我之前误建的 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;
|