Changeset 32683 for trunk/src/wp-includes/user.php

Timestamp:

06/02/2015 01:29:44 PM (11 years ago)

Author:

boonebgorges

Message:

Introduce 'has_published_posts' parameter for WP_User_Query.

This allows user query results to be limited to those users who have published
posts in at least one of the specified post types.

Props joehoyle, boonebgorges.
Fixes #32250.

File:

• trunk/src/wp-includes/user.php (modified) (3 diffs)

trunk/src/wp-includes/user.php

@@ -570 +570 @@
          *                                         include meta fields. Default 'all'.
          *     @type string       $who             Type of users to query. Accepts 'authors'. Default empty (all users).
+         *     @type bool|array   $has_published_posts Pass an array of post types to filter results to users who have
+         *                                             published posts in those post types. `true` is an alias for all
+         *                                             public post types.
          * }
          */
@@ -593 +596 @@
                                 'count_total' => true,
                                 'fields' => 'all',
-                                'who' => ''
+                                'who' => '',
+                                'has_published_posts' => null,
                         ) );
                 }
@@ -650 +654 @@
                         $qv['meta_compare'] = '!=';
                         $qv['blog_id'] = $blog_id = 0; // Prevent extra meta query
+                }
+
+                if ( $qv['has_published_posts'] && $blog_id ) {
+                        if ( true === $qv['has_published_posts'] ) {
+                                $post_types = get_post_types( array( 'public' => true ) );
+                        } else {
+                                $post_types = (array) $qv['has_published_posts'];
+                        }
+
+                        foreach ( $post_types as &$post_type ) {
+                                $post_type = $wpdb->prepare( '%s', $post_type );
+                        }
+
+                        $posts_table = $wpdb->get_blog_prefix( $blog_id ) . 'posts';
+                        $this->query_where .= " AND $wpdb->users.ID IN ( SELECT DISTINCT $posts_table.post_author FROM $posts_table WHERE $posts_table.post_status = 'publish' AND $posts_table.post_type IN ( " . join( ", ", $post_types ) . " ) )";
                 }