Changeset 13184 for trunk/src/bp-groups/classes/class-bp-groups-group.php

Timestamp:

12/12/2021 02:09:02 PM (3 years ago)

Author:

imath

Message:

Support date queries for Members, Groups and Sites

According to components, date queries can be restricted to a limited list of loop types:

• For Members, the $type parameter in bp_has_members() needs to be either active, newest, random or online.
• For Groups, the $type parameter in bp_has_groups() needs to be either active or newest.
• For sites, the $type parameter in bp_has_blogs() needs to be either active or newest.

Props r-a-y

Fixes #8488

File:

• trunk/src/bp-groups/classes/class-bp-groups-group.php (modified) (5 diffs)

trunk/src/bp-groups/classes/class-bp-groups-group.php

@@ -1020 +1020 @@
      * @since 2.8.0 Changed `$search_terms` parameter handling and added `$search_columns` parameter.
      * @since 2.9.0 Added `$slug` parameter.
+     * @since 10.0.0 Added `$date_query` parameter.
      *
      * @param array $args {
@@ -1054 +1055 @@
      *     @type array        $meta_query         Optional. An array of meta_query conditions.
      *                                            See {@link WP_Meta_Query::queries} for description.
+     *     @type array        $date_query         Optional. Filter results by group last activity date. See first
+     *                                            paramter of {@link WP_Date_Query::__construct()} for syntax. Only
+     *                                            applicable if $type is either 'newest' or 'active'.
      *     @type array|string $value              Optional. Array or comma-separated list of group IDs. Results
      *                                            will be limited to groups within the list. Default: false.
@@ -1126 +1130 @@
             'group_type__not_in' => '',
             'meta_query'         => false,
+            'date_query'         => false,
             'include'            => false,
             'parent_id'          => null,
@@ -1314 +1319 @@
         }
 
+        // Process date query for 'date_created' and 'last_activity' sort.
+        if ( 'date_created' === $orderby || 'last_activity' === $orderby ) {
+            $date_query_sql = BP_Date_Query::get_where_sql( $r['date_query'], self::convert_orderby_to_order_by_term( $orderby ) );
+
+            if ( ! empty( $date_query_sql ) ) {
+                $where_conditions['date'] = $date_query_sql;
+            }
+        }
+
         // Sanitize 'order'.
         $order = bp_esc_sql_order( $order );
@@ -1439 +1453 @@
 
     /**
-     * Get the SQL for the 'meta_query' param in BP_Activity_Activity::get()
+     * Get the SQL for the 'meta_query' param in BP_Groups_Group::get()
      *
      * We use WP_Meta_Query to do the heavy lifting of parsing the