公用-运维项目

-- 先备份
insert into fssp_asia_backup.`bpm_ru_id_user`
select distinct u.* from bpm_ru_id_user u ,act_ru_task t ,bpm_sys_org_member m
where u.PROC_INST_ID = t.PROC_INST_ID_
and u.TASK_INST_ID = t.ID_
and u.REF_BPM_SYS_ORG_MEMBER_ID = m.pk_id
and m.USER_CODE='change_3/10100039'

-- 查找对应组织编码
select * from bpm_sys_org_member where pk_id='202407147223'
-- 根据组织编码及工号及有效性查找获取对应id（202407135859 ） 注意当有多个，取最后一个
select * from bpm_sys_org_member where user_code in ('10100039') and IS_ACTIVE='1' and ORG_CODE='ZB022'

-- 刷新数据
update bpm_ru_id_user u ,(
select distinct u.pk_id,'202407135859' as REF_BPM_SYS_ORG_MEMBER_ID from bpm_ru_id_user u ,act_ru_task t ,bpm_sys_org_member m
where u.PROC_INST_ID = t.PROC_INST_ID_
and u.TASK_INST_ID = t.ID_
and u.REF_BPM_SYS_ORG_MEMBER_ID = m.pk_id
and m.USER_CODE='change_3/10100039'
) t set u.REF_BPM_SYS_ORG_MEMBER_ID = t.REF_BPM_SYS_ORG_MEMBER_ID
where u.pk_id = t.pk_id