Changeset 40340 for trunk/src/wp-includes/class-wp-site-query.php

Timestamp:

03/27/2017 07:47:53 PM (8 years ago)

Author:

jeremyfelt

Message:

Multisite: Add lang_id support to WP_Site_Query.

Sites can now be queried by lang_id, lang__in, and lang__not_in.

Props ocean90.
Fixes #40196.

File:

• trunk/src/wp-includes/class-wp-site-query.php (modified) (4 diffs)

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

@@ -100 +100 @@
      *
      * @since 4.6.0
+     * @since 4.8.0 Introduced the 'lang_id', 'lang__in', and 'lang__not_in' parameters.
      * @access public
      *
@@ -139 +140 @@
      *     @type int          $spam              Limit results to spam sites. Accepts '1' or '0'. Default empty.
      *     @type int          $deleted           Limit results to deleted sites. Accepts '1' or '0'. Default empty.
+     *     @type int          $lang_id           Limit results to a language ID. Default empty.
+     *     @type array        $lang__in          Array of language IDs to include affiliated sites for. Default empty.
+     *     @type array        $lang__not_in      Array of language IDs to exclude affiliated sites for. Default empty.
      *     @type string       $search            Search term(s) to retrieve matching sites for. Default empty.
      *     @type array        $search_columns    Array of column names to be searched. Accepts 'domain' and 'path'.
@@ -170 +174 @@
             'spam'              => null,
             'deleted'           => null,
+            'lang_id'           => null,
+            'lang__in'          => '',
+            'lang__not_in'      => '',
             'search'            => '',
             'search_columns'    => array(),
@@ -470 +477 @@
             $public = absint( $this->query_vars['public'] );
             $this->sql_clauses['where']['public'] = $wpdb->prepare( "public = %d ", $public );
+        }
+
+        if ( is_numeric( $this->query_vars['lang_id'] ) ) {
+            $lang_id = absint( $this->query_vars['lang_id'] );
+            $this->sql_clauses['where']['lang_id'] = $wpdb->prepare( "lang_id = %d ", $lang_id );
+        }
+
+        // Parse site language IDs for an IN clause.
+        if ( ! empty( $this->query_vars['lang__in'] ) ) {
+            $this->sql_clauses['where']['lang__in'] = 'lang_id IN ( ' . implode( ',', wp_parse_id_list( $this->query_vars['lang__in'] ) ) . ' )';
+        }
+
+        // Parse site language IDs for a NOT IN clause.
+        if ( ! empty( $this->query_vars['lang__not_in'] ) ) {
+            $this->sql_clauses['where']['lang__not_in'] = 'lang_id NOT IN ( ' . implode( ',', wp_parse_id_list( $this->query_vars['lang__not_in'] ) ) . ' )';
         }