X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FI18n.php;h=3f52fb5a58c962a6ef643df2742cbfffe9b7fd79;hb=cd94d312a825c83ccc154c4b0c6bee4bb1d8c34c;hp=aca38a4e79dec5c85b4edddccb67393d7d25d9d6;hpb=1da188f769fd540f5863ffe801c3fc0e65c23cd5;p=Pman.Core

diff --git a/DataObjects/I18n.php b/DataObjects/I18n.php
index aca38a4e..3f52fb5a 100644
--- a/DataObjects/I18n.php
+++ b/DataObjects/I18n.php
@@ -7,7 +7,7 @@
  * It should eventually replace most of that..
  * 
  */
-require_once 'DB/DataObject.php';
+class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
 
 class Pman_Core_DataObjects_I18n extends DB_DataObject 
 {
@@ -128,9 +128,12 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
             
             $this->selectAdd("
                 i18n_translate(ltype, lkey, 'en') as lval_en
-                
             ");
         }
+         
+        if (!empty($q['!code'])) {
+            $this->whereAddIn('!lkey', explode(',', $q['!code']), 'string'); 
+        }
         if (!empty($q['query']['name'])) {
             //DB_DAtaObject::debugLevel(1);
             $v = strtoupper($this->escape($q['query']['name']));
@@ -145,8 +148,60 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
             }
             
         }
+        
+        if(!empty($q['_with_geoip_count'])) {
+            
+            $this->selectAdd("
+                (
+                    SELECT
+                            COUNT(geoip_division.id)
+                    FROM
+                            geoip_division
+                    WHERE
+                            geoip_division.country = i18n.lkey
+                ) AS no_of_division,
+                (
+                    SELECT
+                            COUNT(geoip_city.id)
+                    FROM
+                            geoip_city
+                    WHERE
+                            geoip_city.country = i18n.lkey
+                ) AS no_of_city
+            ");
+        }
+        
+        if(!empty($q['_hide_unused'])) {
+            $this->whereAdd("
+                (
+                    SELECT
+                            COUNT(geoip_division.id)
+                    FROM
+                            geoip_division
+                    WHERE
+                            geoip_division.country = i18n.lkey
+                ) > 0
+            ");
+        }
     }
     
+    function lookupCode($inlang,$ltype,$name)
+    {
+        $x = DB_DataObject::factory('i18n');
+        $x->ltype = $ltype;
+        $x->lval = $name;
+        $x->inlang= $inlang;
+        
+        $x->limit(1);
+        if ($x->find(true) && !empty($x->lkey)) {
+            return $x->lkey;
+        }
+        return '';
+        
+        
+    }
+    
+    
     function translate($inlang,$ltype,$kval)
     {
         
@@ -287,10 +342,10 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
         if ($ltype === false) {
             // trigger all builds.
             //DB_DataObject::debugLevel(1);
-//            $this->buildDB('c');
-//            $this->buildDB('l');
-//            $this->buildDB('m');
-            $this->buildDB('p');
+            $this->buildDB('c');
+            $this->buildDB('l');
+            $this->buildDB('m');
+            $this->buildDB('p', 'en');
             return;
         }
         
@@ -354,7 +409,7 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject
      
     function defaultTranslate($lang, $type, $k) 
     {
-        print_R($lang);exit;
+      
         static $cache;