Bug#860386: [DDTP] Please provide pages to list descriptions that had been previously translated
Package: debian-i18n
Tags: l10n
Severity: wishlist
Hi,
please provide HTML pages (such as this [1] or this [2]) to list the package
descriptions that had been translated but aren't anymore because the description has
been modified (e.g. a trivial typo fixed by maintainer causes the loss of the whole
translation).
Unfortunately the translators have no possibility to fetch this type of descriptions
and the number of losses is very large if compared with "real" translations; this is
a very sad situation and a waste of lot of work :(
E.g. for "pt" language we have 2425 complete translations in DDTP and 1877 formerly
translated descriptions (>77% ...) [3]
An indicative patch is attached ("something" words are not so explanatory).
Note that the query is the same as that which gathers the counts displayed in [3]
(numbers between round brackets).
Thanks a lot for your work in l10n projects and happy Easter :)
[1] http://ddtp2.debian.net/ddt.cgi?alluntranslatedpackages=it
[2] http://ddtp2.debian.net/ddt.cgi?allpackages=it
[3] http://ddtp2.debian.net/
--- ddt.cgi 2017-04-15 18:11:39.932861451 +0200
+++ ddt.cgi-new 2017-04-15 18:13:45.586184068 +0200
@@ -135,4 +135,5 @@
'alltranslatedpackages' => $LANGUAGE_NAME,
'alluntranslatedpackages' => $LANGUAGE_NAME,
+ 'something' => $LANGUAGE_NAME,
'package' => $PACKAGE_NAME,
'diff1' => qr/^\d+$/,
@@ -834,4 +835,30 @@
print "<br>\n";
print "</BODY>\n";
+} elsif (param('something')) {
+
+ my $language=param('something');
+
+ my $package;
+ my $description_id;
+
+ print "Content-type: text/html; charset=UTF-8\n";
+ print "\n";
+ print "<HTML>\n";
+ print "<HEAD>\n";
+ print "<meta http-equiv=\"content-type\" content=\"text/html;charset=UTF-8\">";
+ print "<TITLE>Debian Description Tracking -- something -- </TITLE>\n";
+ print "</HEAD>\n";
+ print "<BODY>\n";
+ print "<h3>Something</h3>\n";
+
+ my $sth = $dbh->prepare("SELECT description_id,package FROM description_tb WHERE description_id in (SELECT description_id FROM active_tb) and description_id not in (SELECT description_id FROM translation_tb WHERE description_id in (SELECT description_id FROM active_tb) and language=?) and package in (SELECT package FROM description_tb WHERE description_id in (SELECT description_id FROM translation_tb WHERE language=?) GROUP BY package) ORDER BY package");
+ $sth->execute($language,$language);
+
+ print "<pre>";
+ while(($description_id,$package) = $sth->fetchrow_array) {
+ print "<a href=\"ddt.cgi?desc_id=$description_id&getuntrans=$language\">$package</a>";
+ print "\n";
+ }
+ print "</pre>";
} else {
print "Content-type: text/html; charset=UTF-8\n";
Reply to: