Changeset 743 for trunk/Modules/Translation/Form.php

Timestamp:

Jan 9, 2014, 2:44:51 PM (11 years ago)

Author:

maron

Message:

• Modify: Progress.php like all list task
• Modify: Search in form for same text

File:

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

trunk/Modules/Translation/Form.php

@@ -49 +49 @@
           foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
             $Columns .= ' `Orig`.`'.$TextItem['Column'].'` as `Orig_'.$TextItem['Column'].'`, `Tran`.`'.$TextItem['Column'].'` as `'.$TextItem['Column'].'`,';
+
+
+            //search for same text with other entry
+                                          foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
+                                                  if($TextItem['Visible'] == 1)
+                                                  if (($LineAJ[$TextItem['Column']] <> '') and 
+                    ($LineAJ[$TextItem['Column']] == $Line[$TextItem['Column']]) and
+                    (strlen($LineAJ[$TextItem['Column']]) < 20)
+                   )
+                 {       
+                                $sql = 'SELECT '.$Columns.' Tran.`Entry` FROM `'.$Table.'` as Tran';
+                    $join = ' JOIN `'.$Table.'` as `Orig` ON `Orig`.`Language` = 0 AND `Tran`.`Entry` = `Orig`.`Entry` AND `Tran`.`VersionEnd` = `Orig`.`VersionEnd` ';
+                    $where = ' WHERE '.'( `Tran`.'.$Language.' ) AND '.' `Orig`.`'.$TextItem['Column'].'` = "'.$LineAJ[$TextItem['Column']].'" ORDER BY `Tran`.`ModifyTime` DESC LIMIT 1';
+                    $DbResult = $this->Database->query($sql.$join.$where);
+                    while ($LineSearch = $DbResult->fetch_assoc()) {
+                      $Line[$TextItem['Column']] = $LineSearch[$TextItem['Column']];
+                    }
+                 }      
           
                                 $sql = 'SELECT '.$Columns.' Tran.`Entry` FROM `'.$Table.'` as Tran';
@@ -68 +86 @@
           }
           
+                    
         } else {
                                 $DbResult = $this->Database->query('SELECT * FROM `'.$Table.'` WHERE '.