Changeset 40978

Timestamp:

07/01/2017 11:24:26 AM (7 years ago)

Author:

boonebgorges

Message:

Introduce $comment_count param for WP_Query.

This parameter allows querying for posts with a specific value of
comment_count. It is also possible to query for posts that match
a comment_count comparison by passing an array with 'value' and
'compare' operators (eg array( 'compare' => '>', 'value' => 5 )).

Props ramon fincken.
Fixes #28399.

Location:

trunk

Files:

• src/wp-includes/class-wp-query.php (modified) (3 diffs)
• tests/phpunit/tests/query/commentCount.php (added)

trunk/src/wp-includes/class-wp-query.php

@@ -642 +642 @@
      *              Introduced `RAND(x)` syntax for `$orderby`, which allows an integer seed value to random sorts.
      * @since 4.6.0 Added 'post_name__in' support for `$orderby`. Introduced the `$lazy_load_term_meta` argument.
+     * @since 4.9.0 Introduced the `$comment_count` parameter.
      * @access public
      *
@@ -658 +659 @@
      *     @type array        $category__not_in        An array of category IDs (NOT in).
      *     @type string       $category_name           Use category slug (not name, this or any children).
+     *     @type array|int    $comment_count           Filter results by comment count. Provide an integer to match
+     *                                                 comment count exactly. Provide an array with integer 'value'
+     *                                                 and 'compare' operator ('=', '!=', '>', '>=', '<', '<=' ) to
+     *                                                 compare against comment_count in a specific way.
      *     @type string       $comment_status          Comment status.
      *     @type int          $comments_per_page       The number of comments to return per page.
@@ -2141 +2146 @@
         }
 
+        // Matching by comment count.
+        if ( isset( $q['comment_count'] ) ) {
+            // Numeric comment count is converted to array format.
+            if ( is_numeric( $q['comment_count'] ) ) {
+                $q['comment_count'] = array(
+                    'value' => intval( $q['comment_count'] ),
+                );
+            }
+
+            if ( isset( $q['comment_count']['value'] ) ) {
+                $q['comment_count'] = array_merge( array(
+                    'compare' => '=',
+                ), $q['comment_count'] );
+
+                // Fallback for invalid compare operators is '='.
+                $compare_operators = array( '=', '!=', '>', '>=', '<', '<=' );
+                if ( ! in_array( $q['comment_count']['compare'], $compare_operators, true ) ) {
+                    $q['comment_count']['compare'] = '=';
+                }
+
+                $where .= $wpdb->prepare( " AND {$wpdb->posts}.comment_count {$q['comment_count']['compare']} %d", $q['comment_count']['value'] );
+            }
+        }
+
         // MIME-Type stuff for attachment browsing