id_, report_id_, authority_, object_type_, object_id_ SELECT d.id_, d.authority_, d.object_id_, d.report_id_, d.object_type_, ( CASE WHEN d.object_type_ = 'org' THEN org.name_ WHEN d.object_type_ = 'role' THEN role.name_ WHEN d.object_type_ = 'user' THEN users.fullname_ END ) AS name FROM qf_report_authority AS d LEFT JOIN uc_org org ON org.id_ = d.object_id_ LEFT JOIN uc_role role ON role.id_ = d.object_id_ LEFT JOIN uc_user users ON users.id_ = d.object_id_ WHERE d.report_id_ = #{reportId} SELECT id_ FROM uc_role code_ in #{code} SELECT DISTINCT ri.*, rau.authority_ FROM qf_report_authority rau LEFT JOIN qf_report_info ri ON ri.id_ = rau.report_id_ WHERE ri.is_dele_ = '0' and ri.flag_ = 1 and ri.tyep_ = #{vo.tyep} and ri.business_ = #{vo.business} and ri.name_ = #{vo.name} and ri.name_en_ = #{vo.nameEn} and ((rau.object_type_='user' and rau.object_id_= #{currentUserId}) or (rau.object_type_='org' and rau.object_id_ in #{orgId} ) or (rau.object_type_='role' and rau.object_id_ in #{roleId} ) ) order by ri.sn_