Changeset 29934

Timestamp:

10/17/2014 01:36:36 AM (12 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();
                 }