3 * Media Library List Table class.
6 * @subpackage List_Table
10 class WP_Media_List_Table extends WP_List_Table {
12 function __construct( $args = array() ) {
13 $this->detached = isset( $_REQUEST['detached'] ) || isset( $_REQUEST['find_detached'] );
15 parent::__construct( array(
17 'screen' => isset( $args['screen'] ) ? $args['screen'] : null,
21 function ajax_user_can() {
22 return current_user_can('upload_files');
25 function prepare_items() {
26 global $lost, $wpdb, $wp_query, $post_mime_types, $avail_post_mime_types;
30 if ( !empty( $lost ) )
31 $q['post__in'] = implode( ',', $lost );
33 list( $post_mime_types, $avail_post_mime_types ) = wp_edit_attachments_query( $q );
35 $this->is_trash = isset( $_REQUEST['status'] ) && 'trash' == $_REQUEST['status'];
37 $this->set_pagination_args( array(
38 'total_items' => $wp_query->found_posts,
39 'total_pages' => $wp_query->max_num_pages,
40 'per_page' => $wp_query->query_vars['posts_per_page'],
44 function get_views() {
45 global $wpdb, $post_mime_types, $avail_post_mime_types;
47 $type_links = array();
48 $_num_posts = (array) wp_count_attachments();
49 $_total_posts = array_sum($_num_posts) - $_num_posts['trash'];
50 $total_orphans = $wpdb->get_var( "SELECT COUNT( * ) FROM $wpdb->posts WHERE post_type = 'attachment' AND post_status != 'trash' AND post_parent < 1" );
51 $matches = wp_match_mime_types(array_keys($post_mime_types), array_keys($_num_posts));
52 foreach ( $matches as $type => $reals )
53 foreach ( $reals as $real )
54 $num_posts[$type] = ( isset( $num_posts[$type] ) ) ? $num_posts[$type] + $_num_posts[$real] : $_num_posts[$real];
56 $class = ( empty($_GET['post_mime_type']) && !$this->detached && !isset($_GET['status']) ) ? ' class="current"' : '';
57 $type_links['all'] = "<a href='upload.php'$class>" . sprintf( _nx( 'All <span class="count">(%s)</span>', 'All <span class="count">(%s)</span>', $_total_posts, 'uploaded files' ), number_format_i18n( $_total_posts ) ) . '</a>';
58 foreach ( $post_mime_types as $mime_type => $label ) {
61 if ( !wp_match_mime_types($mime_type, $avail_post_mime_types) )
64 if ( !empty($_GET['post_mime_type']) && wp_match_mime_types($mime_type, $_GET['post_mime_type']) )
65 $class = ' class="current"';
66 if ( !empty( $num_posts[$mime_type] ) )
67 $type_links[$mime_type] = "<a href='upload.php?post_mime_type=$mime_type'$class>" . sprintf( translate_nooped_plural( $label[2], $num_posts[$mime_type] ), number_format_i18n( $num_posts[$mime_type] )) . '</a>';
69 $type_links['detached'] = '<a href="upload.php?detached=1"' . ( $this->detached ? ' class="current"' : '' ) . '>' . sprintf( _nx( 'Unattached <span class="count">(%s)</span>', 'Unattached <span class="count">(%s)</span>', $total_orphans, 'detached files' ), number_format_i18n( $total_orphans ) ) . '</a>';
71 if ( !empty($_num_posts['trash']) )
72 $type_links['trash'] = '<a href="upload.php?status=trash"' . ( (isset($_GET['status']) && $_GET['status'] == 'trash' ) ? ' class="current"' : '') . '>' . sprintf( _nx( 'Trash <span class="count">(%s)</span>', 'Trash <span class="count">(%s)</span>', $_num_posts['trash'], 'uploaded files' ), number_format_i18n( $_num_posts['trash'] ) ) . '</a>';
77 function get_bulk_actions() {
79 $actions['delete'] = __( 'Delete Permanently' );
80 if ( $this->detached )
81 $actions['attach'] = __( 'Attach to a post' );
86 function extra_tablenav( $which ) {
88 <div class="alignleft actions">
90 if ( 'top' == $which && !is_singular() && !$this->detached && !$this->is_trash ) {
91 $this->months_dropdown( 'attachment' );
93 do_action( 'restrict_manage_posts' );
94 submit_button( __( 'Filter' ), 'button', false, false, array( 'id' => 'post-query-submit' ) );
97 if ( $this->detached ) {
98 submit_button( __( 'Scan for lost attachments' ), 'secondary', 'find_detached', false );
99 } elseif ( $this->is_trash && current_user_can( 'edit_others_posts' ) ) {
100 submit_button( __( 'Empty Trash' ), 'apply', 'delete_all', false );
106 function current_action() {
107 if ( isset( $_REQUEST['find_detached'] ) )
108 return 'find_detached';
110 if ( isset( $_REQUEST['found_post_id'] ) && isset( $_REQUEST['media'] ) )
113 if ( isset( $_REQUEST['delete_all'] ) || isset( $_REQUEST['delete_all2'] ) )
116 return parent::current_action();
119 function has_items() {
123 function no_items() {
124 _e( 'No media attachments found.' );
127 function get_columns() {
128 $posts_columns = array();
129 $posts_columns['cb'] = '<input type="checkbox" />';
130 $posts_columns['icon'] = '';
131 /* translators: column name */
132 $posts_columns['title'] = _x( 'File', 'column name' );
133 $posts_columns['author'] = __( 'Author' );
135 $taxonomies = array();
137 $taxonomies = get_taxonomies_for_attachments( 'objects' );
138 $taxonomies = wp_filter_object_list( $taxonomies, array( 'show_admin_column' => true ), 'and', 'name' );
140 $taxonomies = apply_filters( 'manage_taxonomies_for_attachment_columns', $taxonomies, 'attachment' );
141 $taxonomies = array_filter( $taxonomies, 'taxonomy_exists' );
143 foreach ( $taxonomies as $taxonomy ) {
144 if ( 'category' == $taxonomy )
145 $column_key = 'categories';
146 elseif ( 'post_tag' == $taxonomy )
147 $column_key = 'tags';
149 $column_key = 'taxonomy-' . $taxonomy;
151 $posts_columns[ $column_key ] = get_taxonomy( $taxonomy )->labels->name;
154 /* translators: column name */
155 if ( !$this->detached ) {
156 $posts_columns['parent'] = _x( 'Uploaded to', 'column name' );
157 if ( post_type_supports( 'attachment', 'comments' ) )
158 $posts_columns['comments'] = '<span class="vers"><div title="' . esc_attr__( 'Comments' ) . '" class="comment-grey-bubble"></div></span>';
160 /* translators: column name */
161 $posts_columns['date'] = _x( 'Date', 'column name' );
162 $posts_columns = apply_filters( 'manage_media_columns', $posts_columns, $this->detached );
164 return $posts_columns;
167 function get_sortable_columns() {
170 'author' => 'author',
171 'parent' => 'parent',
172 'comments' => 'comment_count',
173 'date' => array( 'date', true ),
177 function display_rows() {
180 add_filter( 'the_title','esc_html' );
183 while ( have_posts() ) : the_post();
184 $user_can_edit = current_user_can( 'edit_post', $post->ID );
186 if ( $this->is_trash && $post->post_status != 'trash'
187 || !$this->is_trash && $post->post_status == 'trash' )
190 $alt = ( 'alternate' == $alt ) ? '' : 'alternate';
191 $post_owner = ( get_current_user_id() == $post->post_author ) ? 'self' : 'other';
192 $att_title = _draft_or_post_title();
194 <tr id='post-<?php echo $post->ID; ?>' class='<?php echo trim( $alt . ' author-' . $post_owner . ' status-' . $post->post_status ); ?>' valign="top">
197 list( $columns, $hidden ) = $this->get_column_info();
198 foreach ( $columns as $column_name => $column_display_name ) {
199 $class = "class='$column_name column-$column_name'";
202 if ( in_array( $column_name, $hidden ) )
203 $style = ' style="display:none;"';
205 $attributes = $class . $style;
207 switch ( $column_name ) {
211 <th scope="row" class="check-column">
212 <?php if ( $user_can_edit ) { ?>
213 <label class="screen-reader-text" for="cb-select-<?php the_ID(); ?>"><?php echo sprintf( __( 'Select %s' ), $att_title );?></label>
214 <input type="checkbox" name="media[]" id="cb-select-<?php the_ID(); ?>" value="<?php the_ID(); ?>" />
221 $attributes = 'class="column-icon media-icon"' . $style;
223 <td <?php echo $attributes ?>><?php
224 if ( $thumb = wp_get_attachment_image( $post->ID, array( 80, 60 ), true ) ) {
225 if ( $this->is_trash || ! $user_can_edit ) {
229 <a href="<?php echo get_edit_post_link( $post->ID, true ); ?>" title="<?php echo esc_attr( sprintf( __( 'Edit “%s”' ), $att_title ) ); ?>">
230 <?php echo $thumb; ?>
242 <td <?php echo $attributes ?>><strong>
243 <?php if ( $this->is_trash || ! $user_can_edit ) {
246 <a href="<?php echo get_edit_post_link( $post->ID, true ); ?>"
247 title="<?php echo esc_attr( sprintf( __( 'Edit “%s”' ), $att_title ) ); ?>">
248 <?php echo $att_title; ?></a>
250 _media_states( $post ); ?></strong>
253 if ( preg_match( '/^.*?\.(\w+)$/', get_attached_file( $post->ID ), $matches ) )
254 echo esc_html( strtoupper( $matches[1] ) );
256 echo strtoupper( str_replace( 'image/', '', get_post_mime_type() ) );
260 echo $this->row_actions( $this->_get_row_actions( $post, $att_title ) );
268 <td <?php echo $attributes ?>><?php
269 printf( '<a href="%s">%s</a>',
270 esc_url( add_query_arg( array( 'author' => get_the_author_meta('ID') ), 'upload.php' ) ),
279 <td <?php echo $attributes ?>><?php echo has_excerpt() ? $post->post_excerpt : ''; ?></td>
284 if ( '0000-00-00 00:00:00' == $post->post_date ) {
285 $h_time = __( 'Unpublished' );
287 $m_time = $post->post_date;
288 $time = get_post_time( 'G', true, $post, false );
289 if ( ( abs( $t_diff = time() - $time ) ) < DAY_IN_SECONDS ) {
291 $h_time = sprintf( __( '%s from now' ), human_time_diff( $time ) );
293 $h_time = sprintf( __( '%s ago' ), human_time_diff( $time ) );
295 $h_time = mysql2date( __( 'Y/m/d' ), $m_time );
299 <td <?php echo $attributes ?>><?php echo $h_time ?></td>
304 if ( $post->post_parent > 0 )
305 $parent = get_post( $post->post_parent );
310 $title = _draft_or_post_title( $post->post_parent );
311 $parent_type = get_post_type_object( $parent->post_type );
313 <td <?php echo $attributes ?>><strong>
314 <?php if ( current_user_can( 'edit_post', $post->post_parent ) && $parent_type->show_ui ) { ?>
315 <a href="<?php echo get_edit_post_link( $post->post_parent ); ?>">
316 <?php echo $title ?></a><?php
320 <?php echo get_the_time( __( 'Y/m/d' ) ); ?>
325 <td <?php echo $attributes ?>><?php _e( '(Unattached)' ); ?><br />
326 <?php if ( $user_can_edit ) { ?>
327 <a class="hide-if-no-js"
328 onclick="findPosts.open( 'media[]','<?php echo $post->ID ?>' ); return false;"
330 <?php _e( 'Attach' ); ?></a>
337 $attributes = 'class="comments column-comments num"' . $style;
339 <td <?php echo $attributes ?>>
340 <div class="post-com-count-wrapper">
342 $pending_comments = get_pending_comments_num( $post->ID );
344 $this->comments_bubble( $post->ID, $pending_comments );
352 if ( 'categories' == $column_name )
353 $taxonomy = 'category';
354 elseif ( 'tags' == $column_name )
355 $taxonomy = 'post_tag';
356 elseif ( 0 === strpos( $column_name, 'taxonomy-' ) )
357 $taxonomy = substr( $column_name, 9 );
362 $taxonomy_object = get_taxonomy( $taxonomy );
363 echo '<td ' . $attributes . '>';
364 if ( $terms = get_the_terms( $post->ID, $taxonomy ) ) {
366 foreach ( $terms as $t ) {
367 $posts_in_term_qv = array();
368 $posts_in_term_qv['taxonomy'] = $taxonomy;
369 $posts_in_term_qv['term'] = $t->slug;
371 $out[] = sprintf( '<a href="%s">%s</a>',
372 esc_url( add_query_arg( $posts_in_term_qv, 'upload.php' ) ),
373 esc_html( sanitize_term_field( 'name', $t->name, $t->term_id, $taxonomy, 'display' ) )
376 /* translators: used between list items, there is a space after the comma */
377 echo join( __( ', ' ), $out );
385 <td <?php echo $attributes ?>>
386 <?php do_action( 'manage_media_custom_column', $column_name, $post->ID ); ?>
397 function _get_row_actions( $post, $att_title ) {
400 if ( $this->detached ) {
401 if ( current_user_can( 'edit_post', $post->ID ) )
402 $actions['edit'] = '<a href="' . get_edit_post_link( $post->ID, true ) . '">' . __( 'Edit' ) . '</a>';
403 if ( current_user_can( 'delete_post', $post->ID ) )
404 if ( EMPTY_TRASH_DAYS && MEDIA_TRASH ) {
405 $actions['trash'] = "<a class='submitdelete' href='" . wp_nonce_url( "post.php?action=trash&post=$post->ID", 'trash-post_' . $post->ID ) . "'>" . __( 'Trash' ) . "</a>";
407 $delete_ays = !MEDIA_TRASH ? " onclick='return showNotice.warn();'" : '';
408 $actions['delete'] = "<a class='submitdelete'$delete_ays href='" . wp_nonce_url( "post.php?action=delete&post=$post->ID", 'delete-post_' . $post->ID ) . "'>" . __( 'Delete Permanently' ) . "</a>";
410 $actions['view'] = '<a href="' . get_permalink( $post->ID ) . '" title="' . esc_attr( sprintf( __( 'View “%s”' ), $att_title ) ) . '" rel="permalink">' . __( 'View' ) . '</a>';
411 if ( current_user_can( 'edit_post', $post->ID ) )
412 $actions['attach'] = '<a href="#the-list" onclick="findPosts.open( \'media[]\',\''.$post->ID.'\' );return false;" class="hide-if-no-js">'.__( 'Attach' ).'</a>';
415 if ( current_user_can( 'edit_post', $post->ID ) && !$this->is_trash )
416 $actions['edit'] = '<a href="' . get_edit_post_link( $post->ID, true ) . '">' . __( 'Edit' ) . '</a>';
417 if ( current_user_can( 'delete_post', $post->ID ) ) {
418 if ( $this->is_trash )
419 $actions['untrash'] = "<a class='submitdelete' href='" . wp_nonce_url( "post.php?action=untrash&post=$post->ID", 'untrash-post_' . $post->ID ) . "'>" . __( 'Restore' ) . "</a>";
420 elseif ( EMPTY_TRASH_DAYS && MEDIA_TRASH )
421 $actions['trash'] = "<a class='submitdelete' href='" . wp_nonce_url( "post.php?action=trash&post=$post->ID", 'trash-post_' . $post->ID ) . "'>" . __( 'Trash' ) . "</a>";
422 if ( $this->is_trash || !EMPTY_TRASH_DAYS || !MEDIA_TRASH ) {
423 $delete_ays = ( !$this->is_trash && !MEDIA_TRASH ) ? " onclick='return showNotice.warn();'" : '';
424 $actions['delete'] = "<a class='submitdelete'$delete_ays href='" . wp_nonce_url( "post.php?action=delete&post=$post->ID", 'delete-post_' . $post->ID ) . "'>" . __( 'Delete Permanently' ) . "</a>";
427 if ( !$this->is_trash ) {
428 $title =_draft_or_post_title( $post->post_parent );
429 $actions['view'] = '<a href="' . get_permalink( $post->ID ) . '" title="' . esc_attr( sprintf( __( 'View “%s”' ), $title ) ) . '" rel="permalink">' . __( 'View' ) . '</a>';
433 $actions = apply_filters( 'media_row_actions', $actions, $post, $this->detached );