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

Timestamp:

10/06/2022 10:31:49 PM (3 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;
+            }
         }