Changeset 38625 for trunk/src/wp-admin/includes/post.php

Timestamp:

09/20/2016 01:44:07 AM (8 years ago)

Author:

joemcgill

Message:

Media: Make media library searchable by filename.

This applies a new private function, _filter_query_attachment_filenames(),
to the post_clauses filter hook during wp_ajax_query_attachments() and
wp_edit_attachments_query_vars() to include _wp_attached_file post meta
in search queries performed from the media library or in a WP_Media_List_Table.

Props wonderboymusic, DrewAPicture, joemcgill, swissspidy.
Fixes #22744.

File:

• trunk/src/wp-admin/includes/post.php (modified) (1 diff)

trunk/src/wp-admin/includes/post.php

@@ -1145 +1145 @@
     }
 
+    // Filter query clauses to include filenames.
+    add_filter( 'posts_clauses', '_filter_query_attachment_filenames' );
+
     return $q;
+}
+
+/**
+ * Filter the SQL clauses of an attachment query to include filenames.
+ *
+ * @since 4.7.0
+ * @access private
+ *
+ * @param array $clauses An array including WHERE, GROUP BY, JOIN, ORDER BY,
+ *                       DISTINCT, fields (SELECT), and LIMITS clauses.
+ * @return array The modified clauses.
+ */
+function _filter_query_attachment_filenames( $clauses ) {
+    global $wpdb;
+    remove_filter( 'posts_clauses', __FUNCTION__ );
+
+    $clauses['join'] = " INNER JOIN {$wpdb->postmeta} ON ( {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id )";
+    $clauses['groupby'] = "{$wpdb->posts}.ID";
+
+    $clauses['where'] = preg_replace(
+        "/\({$wpdb->posts}.post_content (NOT LIKE|LIKE) (\'[^']+\')\)/",
+        "$0 OR ( {$wpdb->postmeta}.meta_key = '_wp_attached_file' AND {$wpdb->postmeta}.meta_value $1 $2 )",
+        $clauses['where'] );
+
+    return $clauses;
 }