Changeset 658 for trunk/Modules/Export/Export.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/Export/Export.php (modified) (3 diffs)

trunk/Modules/Export/Export.php

@@ -278 +278 @@
   "</document>";
     return($Buffer);
-  }      
+  }    
+  
+  function HaveVarible($String1, $String2) 
+  {
+          //Export only if translate have same varible %
+            if (strpos($String1,'$')) {
+              while (strpos($String1,'$')) {
+                $String1 = substr($String1,strpos($String1,'$'));
+                $varible = $String1;
+                if (strpos($varible,' ')) $varible = substr($varible,0,strpos($varible,' '));
+                if (strpos($varible,'.')) $varible = substr($varible,0,strpos($varible,'.'));
+                if (strpos($varible,'%')) $varible = substr($varible,0,strpos($varible,'%'));
+                if (strpos($varible,chr(10))) $varible = substr($varible,0,strpos($varible,chr(10)));
+                if (false == strpos($String2,$varible)) {
+
+                 return(false);
+                }
+              }
+            }
+          return (true);
+  }  
 
   function ExportToDBC()
@@ -309 +329 @@
         $LookupTable = array();
         $DbResult2 = $this->Database->query($this->BuildQuery($Group));
-        while($DbRow = $DbResult2->fetch_assoc())
-          $LookupTable[$DbRow[$Group['PrimaryKeyItem']]] = $DbRow;
+        while($DbRow = $DbResult2->fetch_assoc()) {
+          //Export only if translate have same varible %
+          $CanExport = true;
+          foreach($TranslationTree[$Group['Id']]['Items'] as $Column)  {
+            $DbRow[$Column['Column']] = str_replace ( '$ ','$',$DbRow[$Column['Column']]);
+            if (!$this->HaveVarible($DbRow['En'.$Column['Column']],$DbRow[$Column['Column']])) {
+              $CanExport = false;
+            }  
+            if (!$this->HaveVarible($DbRow[$Column['Column']],$DbRow['En'.$Column['Column']])) {
+              $CanExport = false;
+            }  
+          }
+
+          if ($CanExport)
+            $LookupTable[$DbRow[$Group['PrimaryKeyItem']]] = $DbRow;
+          else echo 'NE='.$DbRow[$Column['ID']].',';
+        }
       
         // Open original DBC file
@@ -348 +383 @@
             $LookupTableItem = $LookupTable[$PrimaryKeyItem];          
             foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
-            {
+            {  
               if(array_key_exists($GroupItem['Id'], $ColumnIndexes))
                 $Line[$ColumnIndexes[$GroupItem['Id']]] = $LookupTableItem[$GroupItem['Column']];