[242147] Files with all strings marked as non-translatable should show 100% complete
diff --git a/babel-setup.sql b/babel-setup.sql
index 90f050b..fe190ce 100644
--- a/babel-setup.sql
+++ b/babel-setup.sql
@@ -482,7 +482,7 @@
select f.file_id, l.language_id, IF(COUNT(s.string_id) > 0, COUNT(t.string_id)/COUNT(s.string_id)*100,100) AS translate_percent
FROM files AS f
INNER JOIN languages as l ON l.is_active = 1
- LEFT JOIN strings as s ON (s.file_id = f.file_id AND s.is_active AND s.value <> "")
+ LEFT JOIN strings as s ON (s.file_id = f.file_id AND s.is_active AND s.value <> "" AND s.non_translatable = 0)
LEFT JOIN translations AS t ON (s.string_id = t.string_id
AND t.language_id = l.language_id AND t.is_active = 1)
WHERE f.is_active = 1
@@ -509,6 +509,7 @@
ON (t.string_id = s.string_id AND t.language_id = l.language_id AND t.is_active)
WHERE
s.value <> ""
+ AND s.non_translatable = 0
AND p.is_active
GROUP BY p.project_id, v.version, l.language_id;