Changeset 13337 for trunk/src/bp-activity/classes/class-bp-activity-activity.php

Timestamp:

10/06/2022 10:31:49 PM (4 years ago)

Author:

imath

Message:

Activity introduce 2 new parameters to BP_Activity_Activity::get()`

• The user_id__in parameter makes it possible to retrieve activities for

a list of user IDs.

• The user_id__not_in parameter makes it possible to exclude activity

posted by a list of user IDs from retrieved activities.

Props username_, slaFFik, boonebgorges

Fixes #4184

File:

• trunk/src/bp-activity/classes/class-bp-activity-activity.php (modified) (4 diffs)

trunk/src/bp-activity/classes/class-bp-activity-activity.php

@@ -343 +343 @@
          * @since 2.9.0 Introduced the `$order_by` parameter.
          * @since 10.0.0 Introduced the `$count_total_only` parameter.
+         * @since 11.0.0 Introduced the `$user_id__in` and `$user_id__not_in` parameters.
          *
          * @see BP_Activity_Activity::get_filter_sql() for a description of the
@@ -367 +368 @@
          *     @type string|array $scope             Pre-determined set of activity arguments.
          *     @type array        $filter            See BP_Activity_Activity::get_filter_sql().
+         *     @type array        $user_id__in       An array of user ids to include. Activity posted by users matching one of these
+         *                                           user ids will be included in results. Default empty array.
+         *     @type array        $user_id__not_in   An array of user ids to exclude. Activity posted by users matching one of these
+         *                                           user ids will not be included in results. Default empty array.
          *     @type string       $search_terms      Limit results by a search term. Default: false.
          *     @type bool         $display_comments  Whether to include activity comments. Default: false.
@@ -431 +436 @@
                                 'date_query'        => false,           // Filter by date.
                                 'filter_query'      => false,           // Advanced filtering - see BP_Activity_Query.
+                                'user_id__in'       => array(),         // Array of user ids to include.
+                                'user_id__not_in'   => array(),         // Array of user ids to excluce.
                                 'filter'            => false,           // See self::get_filter_sql().
                                 'scope'             => false,           // Preset activity arguments.
@@ -482 +489 @@
                 if ( $r['filter'] && $filter_sql = BP_Activity_Activity::get_filter_sql( $r['filter'] ) ) {
                         $where_conditions['filter_sql'] = $filter_sql;
+                }
+
+                // User IDs filtering.
+                $user_ids_clause  = array();
+                $user_ids_filters = array_filter(
+                        array_intersect_key(
+                                $r,
+                                array(
+                                        'user_id__in'     => true,
+                                        'user_id__not_in' => true,
+                                )
+                        )
+                );
+
+                foreach ( $user_ids_filters as $user_ids_filter_key => $user_ids_filter ) {
+                        $user_ids_operator = 'IN';
+                        if ( 'user_id__not_in' === $user_ids_filter_key ) {
+                                $user_ids_operator = 'NOT IN';
+                        }
+
+                        if ( $user_ids_clause ) {
+                                $user_ids_clause[] = array(
+                                        'column'  => 'user_id',
+                                        'compare' => $user_ids_operator,
+                                        'value'   => (array) $user_ids_filter,
+                                );
+                        } else {
+                                $user_ids_clause = array(
+                                        'relation' => 'AND',
+                                        array(
+                                                'column'  => 'user_id',
+                                                'compare' => $user_ids_operator,
+                                                'value'   => (array) $user_ids_filter,
+                                        ),
+                                );
+                        }
+                }
+
+                if ( $user_ids_clause ) {
+                        $user_ids_query = new BP_Activity_Query( $user_ids_clause );
+                        $user_ids_sql   = $user_ids_query->get_sql();
+                        if ( ! empty( $user_ids_sql ) ) {
+                                $where_conditions['user_ids_query_sql'] = $user_ids_sql;
+                        }
                 }