Get Resource Opportunities Data

Get opportunities resource data. :param db: The database session for accessing the database. :param auth: The authorization token for the request. :param resource_uri: The resource uri for the opportunities. :param status: List of status values to filter by (active, implemented, discarded). :param sort: Field to sort by (cost_savings, time_savings, effort) - for backward compatibility. :param sort_by: Field to sort by (cost_savings, time_savings, effort). :param sort_order: Sort direction (asc, desc). :return: ok status and optional message.