Changeset 1885 for sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-stats-overview.php

Timestamp:

09/18/2015 12:54:38 AM (8 years ago)

Author:

dd32

Message:

Translate: Stats overview: Add the Forums and Waiting projects to the table. The Waiting column shows the number of strings waiting.
I attempted to add the Colour coding to the waiting list, but a straight percentage calculation isn't the best option, it needs to use a logarithemtric scale, on a percentage scale those with 500 waiting strings look great compared to 2000.
See #1202

File:

• sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-stats-overview.php (modified) (4 diffs)

sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-stats-overview.php

@@ -32 +32 @@
             'meta/themes' => false,
             'meta/plugins' => false,
+            'meta/forums' => false,
             'apps/android' => false,
-            'apps/ios' => false
+            'apps/ios' => false,
+            'waiting' => false,
         );
 
@@ -54 +56 @@
         $sql = "SELECT
                 path, locale, locale_slug,
-                (100 * stats.current/stats.all) as percent_complete
+                (100 * stats.current/stats.all) as percent_complete,
+                stats.waiting+stats.fuzzy as waiting_strings
             FROM {$gpdb->prefix}project_translation_status stats
                 LEFT JOIN {$gpdb->prefix}projects p ON stats.project_id = p.id
@@ -70 +73 @@
             }
             $translation_locale_statuses[ $locale_key ][ $set->path ] = floor( (float) $set->percent_complete );
+            $translation_locale_statuses[ $locale_key ]['waiting'] += (int) $set->waiting_strings;
         }
         unset( $rows, $locale_key, $set );
@@ -76 +80 @@
         $translation_locale_complete = array();
         foreach ( $translation_locale_statuses as $locale => $sets ) {
+            unset( $sets['waiting'] );
             $translation_locale_complete[ $locale ] = round( array_sum( $sets ) / count( $sets ), 3 );
         }