Changeset 13021

Timestamp:

12/07/2023 08:16:08 AM (5 months ago)

Author:

dd32

Message:

Plugin Directory: Reviewer Tools: Introduce a ZIP & lines-of-code column to the posts table.

See #7285.

Location:

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory

Files:

• admin/list-table/class-plugin-posts.php (modified) (4 diffs)
• shortcodes/class-upload-handler.php (modified) (1 diff)

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/admin/list-table/class-plugin-posts.php

@@ -14 +14 @@
         'author',
         'reviewer',
+        'zip',
+        'loc',
         'comments',
     ];
@@ -35 +37 @@
         $columns['reviewer'] = __( 'Assigned Reviewer', 'wporg-plugins' );
         $columns['comments'] = '<span class="vers comment-grey-bubble" title="' . esc_attr__( 'Internal Notes', 'wporg-plugins' ) . '"><span class="screen-reader-text">' . __( 'Internal Notes', 'wporg-plugins' ) . '</span></span>';
+        $columns['zip']      = 'Latest Zip';
+        $columns['loc']      = 'Lines of PHP Code'; 
 
         // We don't want the stats column.
@@ -49 +53 @@
     public function filter_sortable_columns( $columns ) {
         $columns[ 'reviewer' ] = [ 'assigned_reviewer_time', 'asc' ];
+        $columns[ 'zip' ]      = [ '_submitted_zip_size', 'asc' ];
+        $columns[ 'loc' ]      = [ '_submitted_zip_loc', 'asc' ];
 
         return $columns;
@@ -654 +660 @@
         }
     }
+
+    public function column_zip( $post ) {
+        if ( ! in_array( $post->post_status, [ 'new', 'pending', 'approved' ] ) ) {
+            echo '-';
+            return;
+        }
+
+        $attachments = get_posts( [
+            'post_parent'    => $post->ID,
+            'post_type'      => 'attachment',
+            'post_mime_type' => 'application/zip',
+            'posts_per_page' => 1,
+            'orderby'        => 'post_date',
+            'order'          => 'DESC',
+        ] )[0];
+
+        foreach ( get_attached_media( 'application/zip', $post ) as $zip_file ) {
+            $zip_size = size_format( filesize( get_attached_file( $zip_file->ID ) ), 1 );
+
+            $url  = wp_get_attachment_url( $zip_file->ID );
+            $name = basename( $url );
+            $name = explode( '_', $name, 3 )[2];
+
+            printf(
+                '<a href="%1$s">%2$s</a><br>%3$s</li>',
+                esc_url( $url ),
+                esc_html( $name ),
+                esc_html( $zip_size )
+            );
+        }
+    }
+
+    public function column_loc( $post ) {
+        echo number_format_i18n( $post->_submitted_zip_loc );
+    }
 }

sites/trunk/wordpress.org/public_html/wp-content/plugins/plugin-directory/shortcodes/class-upload-handler.php

@@ -414 +414 @@
             return $attachment->get_error_message();
         }
+
+        // Store metadata about the uploaded ZIP.
+        // Count lines of PHP code, this is not 100% accurate but it's a good indicator.
+        $lines_of_code = (int) shell_exec( sprintf( "find %s -type f -name '*.php' -exec cat {} + | wc -l", escapeshellarg( $this->plugin_dir ) ) );
+
+        update_post_meta( $plugin_post->ID, '_submitted_zip_size', filesize( get_attached_file( $attachment->ID ) ) );
+        update_post_meta( $plugin_post->ID, '_submitted_zip_loc', $lines_of_code );
 
         // Send plugin author an email for peace of mind.