Changeset 8249

Timestamp:

02/14/2019 06:43:05 AM (6 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' ) );
+    }
 }