Changeset 1399

Timestamp:

03/13/2015 09:48:54 PM (11 years ago)

Author:

ocean90

Message:

Rosetta: Update page for download stats.

File:

• sites/trunk/global.wordpress.org/public_html/wp-content/mu-plugins/downloads/rosetta-downloads.php (modified) (2 diffs)

sites/trunk/global.wordpress.org/public_html/wp-content/mu-plugins/downloads/rosetta-downloads.php

@@ -1 +1 @@
 <?php
-/* Plugin Name: Rosetta Downloads
- * Author: Nacin
+/**
+ * Plugin Name: Rosetta Downloads
+ * Plugin URI: https://wordpress.org/
+ * Description: Dashboard page for download stats.
+ * Author: Nacin, Dominik Schilling
+ * Version: 1.0
  */
 
 class Rosetta_Downloads {
 
-        function __construct() {
+        /**
+         * Class Constructor.
+         */
+        public function __construct() {
+                add_action( 'plugins_loaded', array( $this, 'plugins_loaded' ) );
+        }
+
+        /**
+         * Attaches hooks once plugins are loaded.
+         */
+        public function plugins_loaded() {
                 add_action( 'admin_menu', array( $this, 'admin_menu' ) );
         }
 
-        function admin_menu() {
-                add_dashboard_page( 'Download Stats', 'Download Stats', 'read', 'download-stats', array( $this, 'render_download_stats' ) );
+        /**
+         * Registers "Download Stats" page.
+         */
+        public function admin_menu() {
+                add_dashboard_page(
+                        __( 'Download Stats', 'rosetta' ),
+                        __( 'Download Stats', 'rosetta' ),
+                        'read',
+                        'download-stats',
+                        array( $this, 'render_download_stats' )
+                );
         }
 
-        function get_counts() {
+        /**
+         * Returns download counts for release packages of the current stable branch.
+         *
+         * @return array Download counts per locale.
+         */
+        function get_release_download_counts() {
                 global $wpdb;
-                $orderby = isset( $_GET['desc'] ) ? 'SUM(`downloads`) DESC' : '`locale`';
-                $stable_branch = implode( '.', array_map( 'absint', explode( '.', WP_CORE_STABLE_BRANCH ) ) );
-                return $wpdb->get_results( "SELECT `locale`, SUM(`downloads`) FROM `download_counts` WHERE `release` LIKE '{$stable_branch}%' AND `release` NOT LIKE '%-%' GROUP BY `locale` ORDER BY $orderby", ARRAY_N );
+
+                $cache = wp_cache_get( 'downloadcounts:release', 'rosetta' );
+                if ( false !== $cache ) {
+                        return $cache;
+                }
+
+                $results = $wpdb->get_results( $wpdb->prepare( "
+                        SELECT
+                                `locale`,
+                                SUM(`downloads`) AS downloads
+                        FROM `download_counts`
+                        WHERE
+                                `release` LIKE %s AND
+                                `release` NOT LIKE '%%-%%'
+                        GROUP BY `locale`
+                ", WP_CORE_STABLE_BRANCH . '%' ) );
+
+                if ( ! $results ) {
+                        return array();
+                }
+
+                $counts = wp_list_pluck( $results, 'downloads', 'locale' );
+
+                wp_cache_add( 'downloadcounts:release', $counts, 'rosetta', 60 );
+
+                return $counts;
         }
 
+        /**
+         * Returns download counts for language packs of the current stable branch.
+         *
+         * @return array Download counts per locale.
+         */
+        function get_translation_download_counts() {
+                global $wpdb;
+
+                $cache = wp_cache_get( 'downloadcounts:translation', 'rosetta' );
+                if ( false !== $cache ) {
+                        return $cache;
+                }
+
+                $results = $wpdb->get_results( $wpdb->prepare( "
+                        SELECT `locale`, SUM(`downloads`) AS downloads
+                        FROM `translation_download_counts`
+                        WHERE
+                                `version` LIKE %s AND
+                                `type` = 'core' AND
+                                `domain` = 'default'
+                        GROUP BY `locale`
+                ", WP_CORE_STABLE_BRANCH . '%' ) );
+
+                if ( ! $results ) {
+                        return array();
+                }
+
+                $counts = wp_list_pluck( $results, 'downloads', 'locale' );
+
+                wp_cache_add( 'downloadcounts:translation', $counts, 'rosetta', 60 );
+
+                return $counts;
+        }
+
+        /**
+         * Renders the "Download Stats" page.
+         */
         function render_download_stats() {
-                echo '<div class="wrap">';
-                screen_icon();
-                echo '<h2>' . __( 'Download Stats', 'rosetta' ) . '</h2>';
-                echo '<table cellpadding=3 cellspacing=2>';
+                $total_release_counts = $total_translation_counts = 0;
+                $this_locale = get_locale();
+                $release_counts = $this->get_release_download_counts();
+                $translation_counts = $this->get_translation_download_counts();
+                $locales = array_unique( array_merge( array_keys( $release_counts ), array_keys( $translation_counts ) ) );
+                $rows = array();
 
-                echo '<p>' . sprintf( __( 'This page shows the <a href="%s">Download Counter</a> number &mdash; total downloads of WordPress %s &mdash; broken down by locale.', 'rosetta' ), 'https://wordpress.org/download/counter/', esc_html( WP_CORE_STABLE_BRANCH ) ) . '</p>';
+                foreach ( $locales as $locale ) {
+                        $release_count = isset( $release_counts[ $locale ] ) ? $release_counts[ $locale ] : 0;
+                        $translation_count = isset( $translation_counts[ $locale ] ) ? $translation_counts[ $locale ] : 0;
+                        $total_release_counts += $release_count;
+                        $total_translation_counts += $translation_count;
 
-                $rows = array();
-                $total = 0;
-                $this_locale = get_locale();
-                foreach ( $this->get_counts() as $value ) {
-                        list( $locale, $sum ) = $value;
-                        $total += $sum;
-                        $sum = number_format_i18n( $sum );
-                        $highlight = $locale == $this_locale ? 'background:#ffffe0;border:1px solid #e6db55;font-weight:bold;' : '';
-                        $row = "<tr><td>$locale</td><td style='{$highlight}text-align:right'>$sum</td></tr>";
+                        $highlight = ( $locale == $this_locale ) ? ' style="background:#ffffe0;font-weight:bold"' : '';
+                        $row = sprintf(
+                                '<tr%s><td>%s</td><td style="text-align:right">%s</td><td style="text-align:right">%s</td></tr>',
+                                $highlight,
+                                $locale,
+                                $release_count ? number_format_i18n( $release_count ) : '&mdash;',
+                                $translation_count ? number_format_i18n( $translation_count ) : '&mdash;'
+                        );
+
                         if ( $locale == 'en' ) {
                                 $rows = array_merge( array( $row ), $rows );
@@ -44 +138 @@
                         }
                 }
-                echo "<tr><td style='width:100px'><strong>" . _x( 'All', 'locales', 'rosetta' ) . "</strong></td><td style='text-align:right'><strong>" . number_format_i18n( $total ) . "</strong></td></tr>";
-                echo implode( "\n", $rows );
-                echo '</table>';
+                ?>
+                <div class="wrap">
+                        <h2><?php _e( 'Download Stats', 'rosetta' ); ?></h2>
+                        <p>
+                                <?php
+                                printf(
+                                        __( 'This page shows the <a href="%s">Download Counter</a> number &mdash; total downloads of WordPress %s &mdash; broken down by locale.', 'rosetta' ),
+                                        'https://wordpress.org/download/counter/',
+                                        esc_html( WP_CORE_STABLE_BRANCH )
+                                );
+                                ?>
+                        </p>
+
+                        <table class="widefat fixed striped" style="max-width:400px">
+                                <thead>
+                                        <tr>
+                                                <th scope="col" style="width:80px"><?php _e( 'Locale', 'rosetta' ); ?></th>
+                                                <th scope="col" style="text-align:right"><?php _e( 'Release Package', 'rosetta' ); ?></th>
+                                                <th scope="col" style="text-align:right"><?php _e( 'Language Pack', 'rosetta' ); ?> <abbr title="Since March 11, 2015.">*</abbr></th>
+                                        </tr>
+                                </thead>
+
+                                <tbody>
+                                        <tr>
+                                                <td>
+                                                        <strong><?php _ex( 'All', 'locales', 'rosetta' ); ?></strong>
+                                                </td>
+                                                <td style="text-align:right">
+                                                        <strong><?php echo number_format_i18n( $total_release_counts ); ?></strong>
+                                                </td>
+                                                <td style="text-align:right">
+                                                        <strong><?php echo number_format_i18n( $total_translation_counts ); ?></strong>
+                                                </td>
+                                        </tr>
+                                        <?php echo implode( "\n", $rows ); ?>
+                                </tbody>
+
+                                <tfoot>
+                                        <tr>
+                                                <th scope="col" style="width:80px"><?php _e( 'Locale', 'rosetta' ); ?></th>
+                                                <th scope="col" style="text-align:right"><?php _e( 'Release Package', 'rosetta' ); ?></th>
+                                                <th scope="col" style="text-align:right"><?php _e( 'Language Pack', 'rosetta' ); ?> <abbr title="Since March 11, 2015.">*</abbr></th>
+                                        </tr>
+                                </tfoot>
+                        </table>
+                </div>
+                <?php
         }
+}
 
-
-}
 new Rosetta_Downloads;