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

Timestamp:

06/16/2016 11:08:30 PM (7 years ago)

Author:

jeremyfelt

Message:

Multisite: Add search column support to WP_Site_Query.

domain and/or path can be used to specify which column(s) should be searched.

See #35791.

File:

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

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

@@ -142 +142 @@
      *     @type int          $deleted           Limit results to deleted sites. Accepts '1' or '0'. 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'.
+     *                                           Default empty array.
      *     @type bool         $update_site_cache Whether to prime the cache for found sites. Default false.
      * }
@@ -171 +173 @@
             'deleted'           => null,
             'search'            => '',
+            'search_columns'    => array(),
             'count'             => false,
             'date_query'        => null, // See WP_Date_Query
@@ -482 +485 @@
         // Falsey search strings are ignored.
         if ( strlen( $this->query_vars['search'] ) ) {
-            $this->sql_clauses['where']['search'] = $this->get_search_sql(
-                $this->query_vars['search'],
-                array( 'domain', 'path' )
-            );
+            $search_columns = array();
+
+            if ( $this->query_vars['search_columns'] ) {
+                $search_columns = array_intersect( $this->query_vars['search_columns'], array( 'domain', 'path' ) );
+            }
+
+            if ( ! $search_columns ) {
+                $search_columns = array( 'domain', 'path' );
+            }
+
+            /**
+             * Filters the columns to search in a WP_Site_Query search.
+             *
+             * The default columns include 'domain' and 'path.
+             *
+             * @since 4.6.0
+             *
+             * @param array         $search_columns Array of column names to be searched.
+             * @param string        $search         Text being searched.
+             * @param WP_Site_Query $this           The current WP_Site_Query instance.
+             */
+            $search_columns = apply_filters( 'site_search_columns', $search_columns, $this->query_vars['search'], $this );
+
+            $this->sql_clauses['where']['search'] = $this->get_search_sql( $this->query_vars['search'], $search_columns );
         }
 
@@ -564 +587 @@
         global $wpdb;
 
-        $like = '%' . $wpdb->esc_like( $string ) . '%';
+        if ( false !== strpos( $string, '*' ) ) {
+            $like = '%' . implode( '%', array_map( array( $wpdb, 'esc_like' ), explode( '*', $string ) ) ) . '%';
+        } else {
+            $like = '%' . $wpdb->esc_like( $string ) . '%';
+        }
 
         $searches = array();