Changeset 13021

Timestamp:

12/07/2023 08:16:08 AM (3 years 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.