Changeset 13184 for trunk/src/bp-core/classes/class-bp-user-query.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-core/classes/class-bp-user-query.php (modified) (5 diffs)

trunk/src/bp-core/classes/class-bp-user-query.php

@@ -18 +18 @@
  *
  * @since 1.7.0
+ * @since 10.0.0 Added $date_query parameter.
  *
  * @param array $query {
@@ -50 +51 @@
  *     @type array             $xprofile_query      Filter results by xprofile data. Requires the xprofile component.
  *                                                  See {@see BP_XProfile_Query} for details.
+ *     @type array             $date_query          Filter results by member last activity date. See first parameter of
+ *                                                  {@link WP_Date_Query::__construct()} for syntax. Only applicable if
+ *                                                  $type is either 'active', 'random', 'newest', or 'online'.
  *     @type bool              $populate_extras     True if you want to fetch extra metadata
  *                                                  about returned users, such as total group and friend counts.
@@ -173 +177 @@
                     'meta_value'          => false,
                     'xprofile_query'      => false,
+                    'date_query'          => false,
                     'populate_extras'     => true,
                     'count_total'         => 'count_query',
@@ -283 +288 @@
                 $sql['order']   = "DESC";
 
+                // Date query.
+                $date_query = BP_Date_Query::get_where_sql( $date_query, 'u.date_recorded' );
+                if ( ! empty( $date_query ) ) {
+                    $sql['where']['date_query'] = $date_query;
+                }
+
                 break;
 
@@ -303 +314 @@
                     $sql['orderby'] = "ORDER BY u.date_recorded";
                     $sql['order'] = "DESC";
+                }
+
+                // Date query.
+                $date_query = BP_Date_Query::get_where_sql( $date_query, 'u.date_recorded' );
+                if ( ! empty( $date_query ) ) {
+                    $sql['where']['date_query'] = $date_query;
                 }