ID_, INTERFACE_ID_, INTERFACE_NAME_, ACCESS_RANGE_TYPE_, ACCESS_RANGE_ID, MEMO_, UPDATE_TIME_, CREATE_BY_, CREATE_TIME_, CREATE_ORG_ID_, UPDATE_BY_ SELECT DISTINCT PORTAL_SYS_DATA_ACCESS_DEFINED.INTERFACE_NAME_,MAX(ACCESS_RANGE_TYPE_) ACCESS_RANGE_TYPE_,ACCESS_RANGE_ID,MEMO_,PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_ID_ FROM PORTAL_SYS_DATA_ACCESS_DEFINED LEFT JOIN PORTAL_SYS_METHOD ON PORTAL_SYS_METHOD.ID_ = PORTAL_SYS_DATA_ACCESS_DEFINED.INTERFACE_ID_ LEFT JOIN PORTAL_SYS_DATA_ACCESS_CONTROL ON PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_DEFINED_ID_ = PORTAL_SYS_DATA_ACCESS_DEFINED.ID_ WHERE PORTAL_SYS_METHOD.request_url_=#{alias} AND( PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_TYPE_=1 OR (PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_TYPE_=2 AND PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_ID_ in #{orgId} ) OR (PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_TYPE_=3 AND PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_ID_=#{userId} ) OR (PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_TYPE_=4 AND PORTAL_SYS_DATA_ACCESS_CONTROL.ACCESS_CONTROL_ID_ in #{roleId} ) ) SELECT FULLNAME_ FROM UC_USER WHERE ID_ IN #{userId} SELECT NAME_ FROM UC_ORG WHERE ID_ IN #{orgId} SELECT NAME_ FROM UC_ROLE WHERE ID_ IN #{roleId}