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 ) . " ) )";
         }