X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=DataObjects%2FI18n.php;h=3f52fb5a58c962a6ef643df2742cbfffe9b7fd79;hp=618f53d8c4aad62de1ca10022a709871b619102f;hb=cd94d312a825c83ccc154c4b0c6bee4bb1d8c34c;hpb=3b8fb72708d6aa8f90048d27bebf4888fe40b697 diff --git a/DataObjects/I18n.php b/DataObjects/I18n.php index 618f53d8..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 { @@ -52,9 +52,11 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject 'm' => array( 'USD', 'HKD', 'GBP', 'CNY', 'SGD', 'JPY' ), + 'p' => '*', 'add_l'=> array(), // key -> value additional languages... 'add_c'=> array(), // additional countries...(eg. '-R' => 'Regional' ) 'add_m'=> array(), // additional currencies... + 'add_p'=> array(), // additional currencies... ); @@ -126,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'])); @@ -138,12 +143,65 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject if (!empty($q['_filtered']) && !empty($this->ltype)) { $cfg = $this->cfg(); $filter = $cfg[$this->ltype]; - $this->whereAddIn('lkey', $filter, 'string'); + if(is_array($filter)){ + $this->whereAddIn('lkey', $filter, 'string'); + } + } + + 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) { @@ -199,7 +257,7 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject { $ret = array(); $cfg = $this->cfg(); - echo '
';print_r($cfg); + //echo '';print_r($cfg); switch ($t) { case 'c': require_once 'I18Nv2/Country.php'; @@ -248,6 +306,15 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject } $ret[] = '**'; break; + case 'p': + require_once 'I18Nv2/PhonePrefix.php'; + $c = new I18Nv2_PhonePrefix('en'); + $ret = array_keys($c->codes); + if (!empty($cfg['add_p'])) { + $ret = array_merge($ret, array_keys($cfg['add_p'])); + } + $ret[] = '**'; + break; } @@ -272,13 +339,13 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject { $cfg = $this->cfg(); - //print_r($cfg); if ($ltype === false) { // trigger all builds. //DB_DataObject::debugLevel(1); $this->buildDB('c'); $this->buildDB('l'); $this->buildDB('m'); + $this->buildDB('p', 'en'); return; } @@ -307,7 +374,6 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject $complete = $x->fetchAll('lkey'); $list = $this->availableCodes($ltype); - //echo ''; print_r($list); foreach($list as $lkey) { // skip ones we know we have done... @@ -361,10 +427,12 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject require_once 'I18Nv2/Country.php'; require_once 'I18Nv2/Language.php'; require_once 'I18Nv2/Currency.php'; + require_once 'I18Nv2/PhonePrefix.php'; $cache[$lang] = array( 'l' => new I18Nv2_Language($lang, 'UTF-8'), 'c' => new I18Nv2_Country($lang, 'UTF-8'), - 'm' => new I18Nv2_Currency($lang, 'UTF-8') + 'm' => new I18Nv2_Currency($lang, 'UTF-8'), + 'p' => new I18Nv2_PhonePrefix($lang, 'UTF-8') ); //echo '';print_r(array($lang, $cache[$lang]['c'])); }