X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=DataObjects%2FI18n.php;h=9711cb6ce1b592f5a1c9a352628184d3f8cfabe3;hb=39538dd1c71297fb385a26c1aead204229558d44;hp=cae6e3bc24127a598049c408d7426eab2d3b7730;hpb=5d4ac076dc4f620fbb91944eead3e0af66216a03;p=Pman.Core diff --git a/DataObjects/I18n.php b/DataObjects/I18n.php index cae6e3bc..9711cb6c 100644 --- a/DataObjects/I18n.php +++ b/DataObjects/I18n.php @@ -131,6 +131,10 @@ class Pman_Core_DataObjects_I18n extends DB_DataObject "); } + + 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 +149,61 @@ 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) {