Changeset 1889 for sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-routes/routes/locale.php

Timestamp:

09/18/2015 09:45:39 AM (11 years ago)

Author:

dd32

Message:

Translate: On the waiting tab, only display child projects (WordPress/Theme/Plugin/etc) not grandchildren (Development/Readme/etc), and force WordPress projects to appear at the start of the list if there's pending strings.

File:

• sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-routes/routes/locale.php (modified) (2 diffs)

sites/trunk/translate.wordpress.org/includes/gp-plugins/wporg-routes/routes/locale.php

@@ -444 +444 @@
             }
 
+            // Limit to only showing base-level projects
+            $parent_project_sql .= " AND tp.parent_project_id IN( (SELECT id FROM {$gpdb->projects} WHERE parent_project_id IS NULL AND active = 1) )";
+
         }
 
@@ -481 +484 @@
             case 'strings-waiting':
                 $filter_where = 'AND (stats.waiting > 0 OR stats.fuzzy > 0 )';
-                $filter_order_by = 'stats.fuzzy DESC, stats.waiting DESC, tp.name ASC';
+                $filter_order_by = "tp.path LIKE 'wp/%%' AND (stats.fuzzy + stats.waiting) > 0 DESC, (stats.fuzzy + stats.waiting) DESC, tp.name ASC";
                 break;