Changeset 8249

Timestamp:

02/14/2019 06:43:05 AM (8 years ago)

Author:

dd32

Message:

Translate: Add a per-locale stats page which lists plugin/theme translation status.

Notes:

• This is currently not linked from anywhere.
• The number displayed (250) may be lowered, currently only ~245 theme projects and ~200 plugin projects are displayed due to filtering.
• Plugins displays based on Code (Dev+Stable) + Readme (Dev+Stable).

Examples:

• ​https://translate.wordpress.org/locale/de/default/stats/plugins
• ​https://translate.wordpress.org/locale/de/default/stats/themes

See #2290.

Location:

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

Files:

• wporg-gp-customizations/templates/stats-plugin-themes-overview.php (added)
• wporg-gp-routes/inc/class-plugin.php (modified) (2 diffs)
• wporg-gp-routes/inc/routes/class-stats.php (modified) (2 diffs)

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/inc/class-plugin.php

@@ -88 +88 @@
          *  - (/locale)/$locale/$dir/glossary/-export
          *  - (/locale)/$locale/$dir/glossary/-import
+         *  - /locale/$locale/$dir/stats(?:/(plugins|themes))?s
          *  - /stats/?
          *  - /projects/wp-plugins/$project
@@ -143 +144 @@
                         GP::$router->prepend( "(/locale)/$locale/$dir/glossary/-import", array( 'GP_Route_Glossary_Entry', 'import_glossary_entries_get' ) );
                         GP::$router->prepend( "(/locale)/$locale/$dir/glossary/-import", array( 'GP_Route_Glossary_Entry', 'import_glossary_entries_post' ), 'post' );
+                        GP::$router->prepend( "/locale/$locale/$dir/stats(?:/(plugins|themes))?", array( __NAMESPACE__ . '\Routes\Stats', 'get_stats_plugin_theme_overview' ) );
                         GP::$router->prepend( '/stats', array( __NAMESPACE__ . '\Routes\Stats', 'get_stats_overview' ) );
                         GP::$router->prepend( '/consistency', array( __NAMESPACE__ . '\Routes\Consistency', 'get_search_form' ) );

sites/trunk/wordpress.org/public_html/wp-content/plugins/wporg-gp-routes/inc/routes/class-stats.php

@@ -5 +5 @@
 use GP;
 use GP_Route;
+use GP_Locales;
 
 /**
@@ -138 +139 @@
         }
 
+        public function get_stats_plugin_theme_overview( $locale, $locale_slug, $view = false ) {
+                global $wpdb;
+                if ( ! $locale || ! $locale_slug || ! $view ) {
+                        wp_redirect( '/stats', 301 );
+                        die();
+                }
+
+                $gp_locale = GP_Locales::by_slug( $locale );
+
+                $items = array();
+                if ( 'plugins' == $view ) {
+                        // Fetch top 100 plugins..
+                        $items = get_transient( __METHOD__ . '_plugin_items' );
+                        if ( ! $items ) {
+                                $api = wp_safe_remote_get( 'https://api.wordpress.org/plugins/info/1.2/?action=query_plugins&request[per_page]=250' );
+                                foreach ( json_decode( wp_remote_retrieve_body( $api ) )->plugins as $plugin ) {
+                                        $items[ $plugin->slug ] = (object) [
+                                                'installs' => $plugin->active_installs,
+                                        ];
+                                }
+                                set_transient( __METHOD__ . '_plugin_items', $items, DAY_IN_SECONDS );
+                        }
+                } elseif ( 'themes' == $view && defined( 'WPORG_THEME_DIRECTORY_BLOGID' ) ) {
+                        $items = get_transient( __METHOD__ . '_theme_items' );
+                        if ( ! $items ) {
+                                // The Themes API API isn't playing nice.. Easiest way..
+                                switch_to_blog( WPORG_THEME_DIRECTORY_BLOGID );
+                                $items = $wpdb->get_results(
+                                        "SELECT p.post_name as slug, pm.meta_value as installs
+                                        FROM {$wpdb->posts} p
+                                        LEFT JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id AND pm.meta_key = '_active_installs'
+                                        WHERE p.post_type = 'repopackage' AND p.post_status = 'publish'
+                                        ORDER BY pm.meta_value+0 DESC, p.post_date
+                                        LIMIT 250",
+                                        OBJECT_K
+                                );
+                                restore_current_blog();
+                                foreach ( $items as $slug => $details ) {
+                                        unset( $items[$slug]->slug );
+                                }
+                                set_transient( __METHOD__ . '_theme_items', $items, DAY_IN_SECONDS );
+                        }
+                } else {
+                        wp_safe_redirect( '/stats' );
+                        die();
+                }
+
+                $project_ids = [];
+                foreach ( $items as $slug => $details ) {
+                        $items[$slug]->project = GP::$project->by_path( 'wp-' . $view . '/' . $slug );
+                        if ( ! $items[$slug]->project || ! $items[$slug]->project->active ) {
+                                // Not all top-all-time plugins/themes have translation projects.
+                                unset( $items[ $slug ] );
+                                continue;
+                        }
+
+                        if (
+                                'plugins' == $view &&
+                                (
+                                        ! GP::$project->by_path( $items[$slug]->project->path . '/dev' )
+                                        &&
+                                        ! GP::$project->by_path( $items[$slug]->project->path . '/stable' )
+                                )
+                        ) {
+                                // Not all top plugins are translation-aware, lets just skip those..
+                                unset( $items[ $slug ] );
+                                continue;
+                        }
+
+                        $project_ids[ $items[$slug]->project->id ] = $slug;
+                }
+
+                $sql_project_ids = implode( ', ', array_map( 'intval', array_keys( $project_ids ) ) );
+                $stats = $wpdb->get_results( $wpdb->prepare(
+                        "SELECT `project_id`, `all`, `current`, `waiting`, `untranslated`
+                                FROM {$wpdb->project_translation_status}
+                                WHERE project_id IN ($sql_project_ids)
+                                AND locale = %s AND locale_slug = %s",
+                        $locale, $locale_slug
+                ) );
+                foreach ( $stats as $row ) {
+                        $items[ $project_ids[ $row->project_id ] ]->stats = $row;
+                }
+
+                $this->tmpl( 'stats-plugin-themes-overview', compact( 'locale', 'locale_slug', 'view', 'gp_locale', 'items' ) );
+        }
 }