Files
supervision-test-repo/sql-changelog/dml/20260806_纪检JJ部门用户挂靠修复.sql
wsm bdb35256da fix(xispeak): 修复测试文档发现的 7 项问题
- 反馈流程部门负责人审批节点 loopCardinality 改用 getTemImplLeaderListLength
- 纪检部门 jj_worker_01/jj_leader_01 挂靠修正到实际纪检部门
- 树子节点 title 改用 speak_status
- Task_0mf32ge 空转节点补齐变量注入改用 tem_impl_leader
- delete/deleteBatch 终止运行中流程并清理 task_task 与反馈子表
- 新增节点填充 tree_depth
- 前端 getCurrentUserDeptId 增强回退(orgCode 不匹配时取首部门)
2026-08-06 16:48:39 +08:00

14 lines
853 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- 修复纪检(JJ)部门用户挂靠:jj_worker_01 / jj_leader_01 原挂靠在不存在的部门 2058729446551752705
-- 导致反馈流程纪检节点 Task_1wfkrvj / Task_1ogk921 的 MI collection 为空、0 实例静默跳过。
-- 现将其挂靠到实际存在的纪检部门 2054466800692432898flow-biz.org.dept.jj)。
-- 说明:getUsersListByDeptIdAndRoleIdLocalApi 走 sys_user_role.dept_idLIKE %deptId%),
-- 故 sys_user_role 为关键修复点;sys_user_depart 同步修正避免悬挂引用。
UPDATE sys_user_role SET dept_id = '2054466800692432898'
WHERE user_id IN ('2058729787494141954','2058729946080776193')
AND dept_id = '2058729446551752705';
UPDATE sys_user_depart SET dep_id = '2054466800692432898'
WHERE user_id IN ('2058729787494141954','2058729946080776193')
AND dep_id = '2058729446551752705';