Changeset 29934

Timestamp:

10/17/2014 01:36:36 AM (10 years ago)

Author:

boonebgorges

Message:

Support date_query by user_registered in WP_User_Query.

Props ChriCo, nacin.
Fixes #27283.

Location:

trunk

Files:

• src/wp-includes/date.php (modified) (3 diffs)
• src/wp-includes/user.php (modified) (1 diff)
• tests/phpunit/tests/user/dateQuery.php (added)

trunk/src/wp-includes/date.php

@@ -452 +452 @@
         $valid_columns = array(
             'post_date', 'post_date_gmt', 'post_modified',
-            'post_modified_gmt', 'comment_date', 'comment_date_gmt'
+            'post_modified_gmt', 'comment_date', 'comment_date_gmt',
+            'user_registered',
         );
 
@@ -464 +465 @@
              * @param array $valid_columns An array of valid date query columns. Defaults
              *                 are 'post_date', 'post_date_gmt', 'post_modified',
-             *                 'post_modified_gmt', 'comment_date', 'comment_date_gmt'
+             *                 'post_modified_gmt', 'comment_date', 'comment_date_gmt',
+             *                 'user_registered'
              */
             if ( ! in_array( $column, apply_filters( 'date_query_valid_columns', $valid_columns ) ) ) {
@@ -481 +483 @@
                     'comment_date_gmt',
                 ),
+                $wpdb->users => array(
+                    'user_registered',
+                ),
             );
 

trunk/src/wp-includes/user.php

@@ -741 +741 @@
             $ids = implode( ',', wp_parse_id_list( $qv['exclude'] ) );
             $this->query_where .= " AND $wpdb->users.ID NOT IN ($ids)";
+        }
+
+        // Date queries are allowed for the user_registered field.
+        if ( ! empty( $qv['date_query'] ) && is_array( $qv['date_query'] ) ) {
+            $date_query = new WP_Date_Query( $qv['date_query'], 'user_registered' );
+            $this->query_where .= $date_query->get_sql();
         }