Changeset 8901 for trunk/wp-admin/upload.php

Timestamp:

09/16/2008 04:24:28 AM (17 years ago)

Author:

azaozz

Message:

Reattaching of orphan attachments and choose post/page ajaxed search box

File:

• trunk/wp-admin/upload.php (modified) (13 diffs)

trunk/wp-admin/upload.php

@@ -11 +11 @@
 add_thickbox();
 wp_enqueue_script( 'media-upload' );
+wp_enqueue_script( 'wp-ajax-response' );
+wp_enqueue_script( 'jquery-ui-draggable' );
+wp_enqueue_script( 'jquery-ui-resizable' );
 
 if (!current_user_can('upload_files'))
     wp_die(__('You do not have permission to upload files.'));
 
-// Handle bulk deletes
-if ( isset($_GET['action']) && isset($_GET['media']) ) {
+if ( isset($_GET['find_detached'] ) ) {
+    check_admin_referer('bulk-media');
+
+    if ( ! current_user_can('edit_posts') )
+        wp_die( __('You are not allowed to scan for lost attachments.') );
+
+    $all_posts = $wpdb->get_col("SELECT ID FROM $wpdb->posts WHERE post_type = 'post' OR post_type = 'page'");
+    $all_att = $wpdb->get_results("SELECT ID, post_parent FROM $wpdb->posts WHERE post_type = 'attachment'");
+
+    $lost = array();
+    foreach ( (array) $all_att as $att ) {
+        if ( $att->post_parent > 0 && ! in_array($att->post_parent, $all_posts) )
+            $lost[] = $att->ID;
+    }
+    $_GET['detached'] = 1;
+
+} elseif ( isset($_GET['found_post_id']) && isset($_GET['media']) ) {
+    check_admin_referer('bulk-media');
+
+    if ( ! ( $parent_id = (int) $_GET['found_post_id'] ) )
+        return;
+
+    $parent = &get_post($parent_id);
+    if ( !current_user_can('edit_post', $parent_id) )
+        wp_die( __('You are not allowed to edit this post.') );
+
+    $attach = array();
+    foreach( (array) $_GET['media'] as $att_id ) {
+        $att_id = (int) $att_id;
+
+        if ( !current_user_can('edit_post', $att_id) )
+            continue;
+
+        $attach[] = $att_id;
+    }
+
+    if ( ! empty($attach) ) {
+        $attach = implode(',', $attach);
+        $attached = $wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_parent = %d WHERE post_type = 'attachment' AND ID IN ($attach)", $parent_id) );
+
+        $message = sprintf( __ngettext('Added %1$s attachment to <strong>%2$s</strong>', 'Added %1$s attachments to <strong>%2$s</strong>', $attached, apply_filters( "the_title", $parent->post_title ) ) , $attached, apply_filters( "the_title", $parent->post_title ) );
+    }
+
+    $_GET['detached'] = 1;
+
+} elseif ( isset($_GET['action']) && isset($_GET['media']) ) {
     check_admin_referer('bulk-media');
     if ( $_GET['action'] == 'delete' ) {
@@ -51 +98 @@
 wp_enqueue_script('media');
 
-list($post_mime_types, $avail_post_mime_types) = wp_edit_attachments_query();
+if ( ! isset( $_GET['paged'] ) || $_GET['paged'] < 1 )
+    $_GET['paged'] = 1;
+
+if ( isset($_GET['detached']) ) {
+
+    if ( isset($lost) ) {
+        $start = ( $_GET['paged'] - 1 ) * 50;
+        $page_links_total = ceil(count($lost) / 50);
+        $lost = implode(',', $lost);
+
+        $orphans = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE post_type = 'attachment' AND ID IN ($lost) LIMIT $start, 50" );
+    } else {
+        $start = ( $_GET['paged'] - 1 ) * 25;
+        $orphans = $wpdb->get_results( "SELECT SQL_CALC_FOUND_ROWS * FROM $wpdb->posts WHERE post_type = 'attachment' AND post_parent < 1 LIMIT $start, 25" );
+        $page_links_total = ceil($wpdb->get_var( "SELECT FOUND_ROWS()" ) / 25);
+    }
+
+    $post_mime_types = array(
+                'image' => array(__('Images'), __('Manage Images'), __ngettext_noop('Image (%s)', 'Images (%s)')),
+                'audio' => array(__('Audio'), __('Manage Audio'), __ngettext_noop('Audio (%s)', 'Audio (%s)')),
+                'video' => array(__('Video'), __('Manage Video'), __ngettext_noop('Video (%s)', 'Video (%s)')),
+            );
+    $post_mime_types = apply_filters('post_mime_types', $post_mime_types);
+
+    $avail_post_mime_types = get_available_post_mime_types('attachment');
+
+    if ( isset($_GET['post_mime_type']) && !array_intersect( (array) $_GET['post_mime_type'], array_keys($post_mime_types) ) )
+        unset($_GET['post_mime_type']);
+
+} else {
+    list($post_mime_types, $avail_post_mime_types) = wp_edit_attachments_query();
+}
 
 if ( is_singular() ) {
@@ -58 +136 @@
 }
 
-require_once('admin-header.php');
-
-if ( !isset( $_GET['paged'] ) )
-    $_GET['paged'] = 1;
-
-?>
+require_once('admin-header.php'); ?>
 
 <form class="search-form" action="" method="get">
@@ -90 +163 @@
 
 <h2><?php
-if ( is_singular() ) {
-    printf(__('Comments on %s'), apply_filters( "the_title", $post->post_title));
+if ( isset($_GET['detached']) ) {
+    _e('Unattached Media');
+} elseif ( is_singular() ) {
+    printf( __('Comments on %s'), apply_filters("the_title", $post->post_title) );
 } else {
     $post_mime_type_label = _c('Media|manage media header');
@@ -97 +172 @@
         $post_mime_type_label = $post_mime_types[$_GET['post_mime_type']][1];
     //TODO: Unreachable code: $post_listing_pageable is undefined, Similar code in edit.php
-    //if ( $post_listing_pageable && !is_archive() && !is_search() ) 
+    //if ( $post_listing_pageable && !is_archive() && !is_search() )
     //  $h2_noun = is_paged() ? sprintf(__( 'Previous %s' ), $post_mime_type_label) : sprintf(__('Latest %s'), $post_mime_type_label);
     //else
@@ -128 +203 @@
     foreach ( $reals as $real )
         $num_posts[$type] += $_num_posts[$real];
-$class = empty($_GET['post_mime_type']) ? ' class="current"' : '';
+
+$class = empty($_GET['post_mime_type']) && ! isset($_GET['detached']) ? ' class="current"' : '';
 $type_links[] = "<li><a href=\"upload.php\"$class>".__('All Types')."</a>";
 foreach ( $post_mime_types as $mime_type => $label ) {
@@ -142 +218 @@
     sprintf(__ngettext($label[2][0], $label[2][1], $num_posts[$mime_type]), number_format_i18n( $num_posts[$mime_type] )) . '</a>';
 }
+$class = isset($_GET['detached']) ? ' class="current"' : '';
+$type_links[] = '<li><a href="upload.php?detached=1"' . $class . '>' . __('Unattached') . '</a>';
+
 echo implode(' | </li>', $type_links) . '</li>';
 unset($type_links);
@@ -156 +235 @@
 $messages[2] = __('Media deleted.');
 
-if (isset($_GET['message'])) : ?>
-<div id="message" class="updated fade"><p><?php echo $messages[$_GET['message']]; ?></p></div>
+if ( isset($_GET['message']) && (int) $_GET['message'] )
+    $message = $messages[$_GET['message']];
+
+if ( $message ) { ?>
+<div id="message" class="updated fade"><p><?php echo $message; ?></p></div>
 <?php $_SERVER['REQUEST_URI'] = remove_query_arg(array('message'), $_SERVER['REQUEST_URI']);
-endif;
+}
 ?>
 
@@ -167 +249 @@
 
 <?php
+if ( ! isset($page_links_total) )
+    $page_links_total =  $wp_query->max_num_pages;
+
 $page_links = paginate_links( array(
     'base' => add_query_arg( 'paged', '%#%' ),
     'format' => '',
-    'total' => $wp_query->max_num_pages,
+    'total' => $page_links_total,
     'current' => $_GET['paged']
 ));
@@ -179 +264 @@
 
 <div class="alignleft">
-<select name="action">
+<select name="action" id="select-action">
 <option value="" selected><?php _e('Actions'); ?></option>
 <option value="delete"><?php _e('Delete'); ?></option>
+<?php if ( isset($orphans) ) { ?>
+<option value="attach"><?php _e('Attach to a post'); ?></option>
+<?php } ?>
 </select>
-<input type="submit" value="<?php _e('Apply'); ?>" name="doaction" class="button-secondary action" />
+<input type="submit" id="submit" value="<?php _e('Apply'); ?>" name="doaction" class="button-secondary action" />
 <?php wp_nonce_field('bulk-media'); ?>
 <?php
 
-if ( !is_singular() ) :
+if ( ! is_singular() && ! isset($_GET['detached']) ) {
     $arc_query = "SELECT DISTINCT YEAR(post_date) AS yyear, MONTH(post_date) AS mmonth FROM $wpdb->posts WHERE post_type = 'attachment' ORDER BY post_date DESC";
 
@@ -218 +306 @@
 <input type="submit" id="post-query-submit" value="<?php _e('Filter'); ?>" class="button-secondary" />
 
-<?php endif; // is_singular ?>
+<?php } // ! is_singular ?>
+
+<?php if ( isset($_GET['detached']) ) { ?>
+    <input type="submit" id="find_detached" name="find_detached" value="<?php _e('Scan for lost attachments'); ?>" class="button-secondary" />
+<?php } ?>
 
 </div>
@@ -226 +318 @@
 
 <br class="clear" />
-
-<?php include( 'edit-attachment-rows.php' ); ?>
-
 <?php wp_nonce_field( 'hiddencolumns', 'hiddencolumnsnonce', false ); ?>
+
+<?php if ( isset($orphans) ) { ?>
+<table class="widefat">
+<thead>
+<tr>
+    <th scope="col" class="check-column"><input type="checkbox" /></th>
+    <th scope="col"></th>
+    <th scope="col"><?php echo _c('Media|media column header'); ?></th>
+    <th scope="col"><?php echo _c('Date Added|media column header'); ?></th>
+</tr>
+</thead>
+
+<tbody id="the-list" class="list:post">
+<?php
+    if ( $orphans ) {
+        foreach ( $orphans as $post ) {
+            $class = 'alternate' == $class ? '' : 'alternate';
+            $att_title = empty($post->post_title) ? __('(no title)') : wp_specialchars( apply_filters('the_title', $post->post_title) );
+?>
+    <tr id='post-<?php echo $post->ID; ?>' class='<?php echo $class; ?>' valign="top">
+        <th scope="row" class="check-column"><input type="checkbox" name="media[]" value="<?php echo $post->ID; ?>" /></th>
+
+        <td class="media-icon"><?php
+        if ( $thumb = wp_get_attachment_image( $post->ID, array(80, 60), true ) ) { ?>
+            <a href="media.php?action=edit&amp;attachment_id=<?php echo $post->ID; ?>" title="<?php echo attribute_escape(sprintf(__('Edit "%s"'), $att_title)); ?>"><?php echo $thumb; ?></a>
+<?php   } ?></td>
+
+        <td><strong><a href="<?php echo get_edit_post_link( $post->ID ); ?>" title="<?php echo attribute_escape(sprintf(__('Edit "%s"'), $att_title)); ?>"><?php echo $att_title; ?></a></strong><br />
+        <?php echo strtoupper(preg_replace('/^.*?\.(\w+)$/', '$1', get_attached_file($post->ID))); ?>
+
+        <p>
+        <?php
+        $actions = array();
+        $actions['edit'] = '<a href="' . get_edit_post_link($post->ID, true) . '">' . __('Edit') . '</a>';
+        $actions['delete'] = "<a class='submitdelete' href='" . wp_nonce_url("post.php?action=delete&amp;post=$post->ID", 'delete-post_' . $post->ID) . "' onclick=\"if ( confirm('" . js_escape(sprintf( ('draft' == $post->post_status) ? __("You are about to delete this attachment '%s'\n  'Cancel' to stop, 'OK' to delete.") : __("You are about to delete this attachment '%s'\n  'Cancel' to stop, 'OK' to delete."), $post->post_title )) . "') ) { return true;}return false;\">" . __('Delete') . "</a>";
+        $actions['view'] = '<a href="' . get_permalink($post->ID) . '" title="' . attribute_escape(sprintf(__('View "%s"'), $title)) . '" rel="permalink">' . __('View') . '</a>';
+        $actions['attach'] = '<a href="#the-list" onclick="findPosts.open(\'media[]\',\''.$post->ID.'\');return false;">'.__('Attach').'</a>';
+        $action_count = count($actions);
+        $i = 0;
+        foreach ( $actions as $action => $link ) {
+            ++$i;
+            ( $i == $action_count ) ? $sep = '' : $sep = ' | ';
+            echo "<span class='$action'>$link$sep</span>";
+        } ?>
+        </p></td>
+
+<?php   if ( '0000-00-00 00:00:00' == $post->post_date && 'date' == $column_name ) {
+            $t_time = $h_time = __('Unpublished');
+        } else {
+            $t_time = get_the_time(__('Y/m/d g:i:s A'));
+            $m_time = $post->post_date;
+            $time = get_post_time( 'G', true );
+            if ( ( abs($t_diff = time() - $time) ) < 86400 ) {
+                if ( $t_diff < 0 )
+                    $h_time = sprintf( __('%s from now'), human_time_diff( $time ) );
+                else
+                    $h_time = sprintf( __('%s ago'), human_time_diff( $time ) );
+            } else {
+                $h_time = mysql2date(__('Y/m/d'), $m_time);
+            }
+        } ?>
+        <td><?php echo $h_time ?></td>
+    </tr>
+<?php   }
+
+    } else { ?>
+    <tr><td colspan="5"><?php _e('No posts found.') ?></td></tr>
+<?php } ?>
+</tbody>
+</table>
+<script type="text/javascript">
+    (function($){
+        $('#submit').click(function(e) {
+            if ( 'attach' == $('#select-action').val() ) {
+                e.preventDefault();
+                findPosts.open();
+            }
+        });
+    })(jQuery);
+</script>
+<?php find_posts_div();
+
+} else {
+    include( 'edit-attachment-rows.php' );
+} ?>
 
 </form>
@@ -285 +459 @@
 </div>
 
-<?php 
+<?php
 
 include('admin-footer.php');