Changeset 656 for trunk/Modules/Translation/TranslationList.php

Timestamp:

Dec 16, 2013, 2:14:02 PM (11 years ago)

Author:

maron

Message:

• Added: New filter Notcomplete-nottran
• Fixed: Column Take should index always to text with right versionstart and versionend, for importing

File:

• trunk/Modules/Translation/TranslationList.php (modified) (2 diffs)

trunk/Modules/Translation/TranslationList.php

@@ -38 +38 @@
                 else $Selected = '';
                 $Output .= '<option value="4"'.$Selected.'>Anglické</option>';
+                if($Filter['State'] == 5) $Selected = ' selected="selected"';
+                else $Selected = '';
+                $Output .= '<option value="5"'.$Selected.'>Rozpracované-Nepřeložené</option>';
                 $Output .= '</select></td>';
         
@@ -162 +165 @@
                         ') AND (`T`.`Complete` = 0)';
                         else if($Filter['State'] == 4) $Filter['SQL'] .= $VersionFilter.' AND (`T`.`Language` = '.$this->System->Config['OriginalLanguage'].')';
+                        else if($Filter['State'] == 5) $Filter['SQL'] .= $UserFilter.$VersionFilter.' AND (`T`.`Language` != '.$this->System->Config['OriginalLanguage'].
+                        ') AND (`T`.`Complete` = 0)'.
+      'AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE '.
+                                        '(`Sub`.`Language` <> '.$this->System->Config['OriginalLanguage'].')'.$LanguageFilter.
+                                        ' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`Complete` = 1) AND '.
+                                        '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`))';
                 }