-- 销售角色的人事申请人可在“我的流程”撤销本人发起的实例。 -- BPM 撤销接口仍按流程发起人校验,不能撤销他人的实例。 INSERT INTO system_role_menu (role_id, menu_id, creator, create_time, updater, update_time, deleted, tenant_id) SELECT 165, 1220, '1', NOW(), '1', NOW(), b'0', 0 WHERE EXISTS (SELECT 1 FROM system_role WHERE id = 165 AND deleted = b'0') AND EXISTS (SELECT 1 FROM system_menu WHERE id = 1220 AND permission = 'bpm:process-instance:cancel' AND deleted = b'0') AND NOT EXISTS (SELECT 1 FROM system_role_menu WHERE role_id = 165 AND menu_id = 1220 AND deleted = b'0');