Changeset 674 for trunk/admin/index.php

Timestamp:

Dec 29, 2013, 8:49:21 PM (11 years ago)

Author:

maron

Message:

• Added: script for merge Texts
• Fixed: script for repair version end
• Fixed: progress file

File:

• trunk/admin/index.php (modified) (4 diffs)

trunk/admin/index.php

@@ -31 +31 @@
   '<small>Nastaví špatné version end a Take na originální text, které vzniklo v důsledku importu a špatně indexovaného indexu Take</small><br/><br/>'.    
   '<a href="'.$System->Link('/admin/?action=dbcstructure').'">Připravit dbc strukturu</a><br/>'.
-  '<small>Otevře dbc soubory převedené do textové formy pro přípravu struktury pro import</small><br/><br/>';    
+  '<small>Otevře dbc soubory převedené do textové formy pro přípravu struktury pro import</small><br/><br/>'.    
+  '<a href="'.$System->Link('/admin/?action=merge').'">Sjednocení textů</a><br/>'.
+  '<small>Sjednotí stejné originální texty v databázi</small><br/><br/>';    
   return($Output);
 }
@@ -101 +103 @@
 {
   global $System,$TranslationTree;
-  
-  foreach($TranslationTree as $Group)  {
+  $Output = '';
+ // foreach($TranslationTree as $Group)  
+  $Group = $TranslationTree[1];
+    {
     
     $sql = 'SELECT `T`.`ID`,`T`.`Take`,`sub1`.`ID` as `origID`,T.`VersionStart`,T.`VersionEnd`,`sub1`.`VersionStart` as OrigStart,sub1.`VersionEnd` as `OrigEnd` FROM `'.$Group['TablePrefix'] .'` as `T` '.
       ' JOIN `'.$Group['TablePrefix'].'` as `sub1` ON `sub1`.`Language` = 0 AND `T`.`Entry` = `sub1`.`Entry` AND `T`.`VersionStart` = `sub1`.`VersionStart` '.
-      ' WHERE `T`.`Take` != `sub1`.`Take`'. 
+      ' WHERE `T`.`Take` != `sub1`.`ID` AND `T`.`Language` != 0'. 
     //  ' WHERE `T`.`Language` != 0 AND `T`.`VersionEnd` != `sub1`.`VersionEnd` AND `T`.`Take` NOT IN'. 
     //  '(Select `ID` FROM `'.$Group['TablePrefix'].'` as `sub2` WHERE `sub2`.`Language` = 0 AND `T`.`Entry` = `sub2`.`Entry` AND `T`.`VersionStart` = `sub2`.`VersionStart`)'.
@@ -120 +124 @@
     echo '<br / >Verze '.$Group['TablePrefix'].' opraveny!';
   }
-  return($Output);
+  return('Hotovo!');
+}   
+
+function StripText($Text) {
+  $Text = strtolower($Text);
+  $Text = str_replace(' ', '', $Text);
+  return ($Text);
+}  
+
+function MergeSameText()
+{
+  global $System,$TranslationTree;
+  $Output = '';
+//  foreach($TranslationTree as $Group)  
+  $Group = $TranslationTree[1];
+  {
+    
+    $sql = 'SELECT * FROM `'.$Group['TablePrefix'] .'` as `T` '.
+    //  ' JOIN `'.$Group['TablePrefix'].'` as `sub1` ON `sub1`.`Language` = 0 AND `T`.`Entry` = `sub1`.`Entry` AND `T`.`VersionStart` < `sub1`.`VersionStart` '.
+      ' WHERE `T`.`Language` = 0 '. 
+      ' ORDER BY `T`.`VersionStart`';  //LIMIT 1000 
+      //echo $sql;
+                $DbResult = $System->Database->query($sql);
+    echo ': <br />'.$Group['TablePrefix'].': ';
+                while($line = $DbResult->fetch_assoc())
+                {
+      $sql = 'SELECT * FROM `'.$Group['TablePrefix'] .'` as `T` '.
+      ' WHERE  `T`.`Language` = 0 AND `T`.`VersionStart` > '.$line['VersionEnd'].' AND `T`.`Entry` = '.$line['Entry']. 
+      ' ORDER BY `T`.`VersionStart` LIMIT 1';  //LIMIT 1000  
+   //   echo $sql;
+                  $DbResult2 = $System->Database->query($sql);
+                  if($DbResult2->num_rows > 0) {
+        $line2 = $DbResult2->fetch_assoc();
+      
+        $Same = true;         
+        foreach($TranslationTree[$Group['Id']]['Items'] as $Column) {
+          if ($this->StripText($line[$Column['Column']]) <> $this->StripText($line2[$Column['Column']])) 
+            $Same = false;
+        } 
+        if ($Same) {
+           echo $line['ID'].'='.$line2['ID'].' (';
+        //               $System->Database->query('UPDATE `'.$Group['TablePrefix'].'` SET `Take` = NULL WHERE ID='.$line2['ID']);
+
+          $sql = 'SELECT * FROM `'.$Group['TablePrefix'] .'` as `T` '.
+          ' WHERE `T`.`Entry` = '.$line['Entry'].' AND `T`.`Take` = '.$line2['ID'];  
+                      $DbResult3 = $System->Database->query($sql);
+                    if($DbResult3->num_rows > 0) {
+             $line3 = $DbResult3->fetch_assoc();
+             echo $line3['ID'].' ';
+                         $System->Database->query('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = '.$line2['VersionEnd'].', `VersionStart` = '.$line['VersionStart'].', `Take` = '.$line['ID'].' WHERE ID='.$line3['ID']);
+          }
+
+                         $System->Database->query('DELETE FROM`'.$Group['TablePrefix'].'` WHERE ID='.$line2['ID']);
+                         $System->Database->query('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = '.$line2['VersionEnd'].' WHERE ID='.$line['ID']);
+          echo '), ';
+        }
+      }    
+                }
+    echo 'Texty '.$Group['TablePrefix'].' sjednoceny!';
+  }
+  return('Hotovo!');
 }     
 
@@ -220 +284 @@
         else if($_GET['action'] == 'repairversion') $Output .= $this->RepairVersionEnd();
         else if($_GET['action'] == 'dbcstructure') $Output .= $this->DbcStructure();
+        else if($_GET['action'] == 'merge') $Output .= $this->MergeSameText();
         else $Output .= $this->ShowMenu();
       } else $Output .= $this->ShowMenu();