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

Timestamp:

Dec 19, 2013, 11:23:12 PM (11 years ago)

Author:

maron

Message:

• Fixed: Export dbc text only, if varible ($s1,$t1..) is keep
• Added: Filter translation where varibles are bad translated

File:

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

trunk/Modules/Translation/TranslationList.php

@@ -41 +41 @@
                 else $Selected = '';
                 $Output .= '<option value="5"'.$Selected.'>Rozpracované-Nepřeložené</option>';
+                if($Filter['State'] == 6) $Selected = ' selected="selected"';
+                else $Selected = '';
+                $Output .= '<option value="6"'.$Selected.'>S chybějícím $N,$S..</option>';
                 $Output .= '</select></td>';
         
@@ -171 +174 @@
                                         ' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`Complete` = 1) AND '.
                                         '(`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`))';
+                        else if($Filter['State'] == 6) {
+                        
+                        if($Filter['Group'] != 0)
+                                foreach($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
+                                if($GroupItem['Visible'] == 1) {
+                                $Items[] = ''.  
+                           '`T`.`'.$GroupItem['Column'].'` NOT LIKE "%$%" '.
+                           ' AND EXISTS ('.
+                                          'SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE `Sub`.`'.$GroupItem['Column'].'` LIKE "%$%"'.
+                                                                        ' AND `Sub`.`Entry` = `T`.`Entry` AND `Sub`.`Language` = '.$this->System->Config['OriginalLanguage'].' AND '.
+                                                                        '`Sub`.`VersionStart` = `T`.`VersionStart` AND `Sub`.`VersionEnd` = `T`.`VersionEnd`'.
+                                        ')'.
+                        '';
+                      }
+        $Filter['SQL'] .= $UserFilter.$VersionFilter.' AND (`T`.`Complete` = 1) AND `T`.`Language` != '.$this->System->Config['OriginalLanguage'];
+
+        $Filter['SQL'] .= ' AND ('.implode(' OR ', $Items).') ';
+
+        
+       
+                    }
                 }