fix #8131 - chinese translations

[Pman.Core] / DataObjects / I18n.php

diff --git a/DataObjects/I18n.php b/DataObjects/I18n.php
index ef145a1..ba3386f 100644 (file)
--- a/DataObjects/I18n.php
+++ b/DataObjects/I18n.php
@@ -220,10 +220,51 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
         
     }
     
+    function codeExists($ltype, $key)
+    {
+        $x = DB_DataObject::factory('i18n');
+        $x->ltype = $ltype;
+        $x->lkey = $key;
+        return $x->count() ? true : false;
+    }
+    
+    // load all all to reduce future queries..
+    function translateCache($inlang, $ltype, $build)
+    {
+        static $cache;
+        $key = "{$inlang} {$ltype}";
+        if (isset($cache[$key])) {
+            return $cache[$key];
+        }
+        if (!$build) {
+            return false;
+        }
+        
+        $x = DB_DataObject::factory('i18n');
+        $x->ltype = $ltype;
+        
+        $x->inlang= $inlang;
+        $cache[$key] = $x->fetchAll('lkey', 'lval');
+        
+        return $cache[$key] ;
+
+    }
+    
     
     function translate($inlang,$ltype,$kval)
     {
         
+        $tc = $this->translateCache($inlang, $ltype, false);
+        if ($tc !== false && isset($tc[$kval])) {
+            return $tc[$kval];
+        }
+        
+        static $cache = array();
+        $cache_key = implode(' ', array($inlang,$ltype,$kval));
+        if (isset($cache[$cache_key ])) {
+            return $cache[$cache_key];
+        }
+        
         $x = DB_DataObject::factory('i18n');
         $x->ltype = $ltype;
         $x->lkey = $kval;
@@ -232,12 +273,15 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
         
         $x->limit(1);
         if ($x->find(true) && !empty($x->lval)) {
+            $cache[$cache_key] = $x->lval;
             return $x->lval;
         }
         $fallback->inlang = 'en';
         if ($fallback->find(true) && !empty($fallback->lval)) {
-           return $fallback->lval;
+            $cache[$cache_key] = $fallback->lval;
+            return $fallback->lval;
         }
+         $cache[$cache_key] = $kval;
         return $kval;
     }
     
@@ -246,7 +290,7 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
     function toTransList($ltype, $inlang)
     {
         
-        
+        $this->is_active = 1;
         $this->ltype = $ltype;
         $this->inlang= $inlang;
         $this->selectAdd();