3 * Table Definition for i18n
5 * This is heavily related to the Pman_I18n implementation..
7 * It should eventually replace most of that..
10 require_once 'DB/DataObject.php';
12 class Pman_Core_DataObjects_I18n extends DB_DataObject
15 /* the code below is auto generated do not remove the above tag */
17 public $__table = 'i18n'; // table name
18 public $id; // int(11) not_null primary_key auto_increment
19 public $ltype; // string(1) not_null multiple_key
20 public $lkey; // string(8) not_null
21 public $inlang; // string(8) not_null
22 public $lval; // string(64) not_null
25 /* the code above is auto generated do not remove the tag below */
28 // we have a small default set of languages available..
29 // you can modify this by making this setting in the index.php loader.
30 // Pman_Core_i18n = array( 'c' => *, 'l' => '*', 'm' => '*')
33 // translated versions availalable
36 'en', 'zh_CN', 'zh_HK',
38 // languages available
41 'en', 'zh_CN', 'zh_HK', 'zh_TW', 'th', 'ko', 'ja', 'ms',
50 'AU', 'CN', 'HK', 'IN', 'ID', 'JP', 'MY', 'NZ', 'TW', 'SG', 'TH', 'KR', 'US', 'PH', 'VN','**'
53 'USD', 'HKD', 'GBP', 'CNY', 'SGD', 'JPY'
58 // the default configuration.
60 function applyFilters($q, $au)
63 //DB_DataObject::debugLevel(1);
64 if (!empty($q['query']['_with_en'])) {
66 i18n_translate(ltype, lkey, 'en') as lval_en
81 // -------------- code to handle importing into database..
86 // returns a list of all countries/languages etc.. (with '*')
87 function availableCodes($t)
92 require_once 'I18Nv2/Country.php';
94 $c = new I18Nv2_Country('en');
95 $ret = array_keys($c->codes);
99 require_once 'I18Nv2/Language.php';
100 $c = new I18Nv2_Language('en');
101 $ret = array_keys($c->codes);
105 require_once 'I18Nv2/Currency.php';
106 $c = new I18Nv2_Currency('en');
107 $ret = array_keys($c->codes);
112 foreach ($ret as $k=>$v) {
113 $ret[$k] = strtoupper($v);
121 function buildDB($ltype= false, $inlang= false )
123 if ($ltype === false) {
124 // trigger all builds.
125 DB_DataObject::debugLevel(1);
131 if ($inlang == '**') {
132 return; // dont bother building generic..
136 if ($inlang === false) {
137 // do we want to add our 'configured ones..'
138 // We only build translatiosn for our configured ones..
139 //foreach( $this->availableCodes('l') as $l) {
141 foreach( $this->cfg['t'] as $l) {
142 $this->buildDB($ltype, $l);
147 $list = $this->availableCodes($ltype);
149 //DB_DataObject::debugLevel(1);
151 foreach($list as $lkey) {
152 $x = DB_DataObject::factory('i18n');
156 if ($x->find(true)) {
158 $x->lval = $this->defaultTranslate($inlang, $ltype, $lkey);
162 $x->lval = $this->defaultTranslate($inlang, $ltype, $lkey);
171 * default translate - use i18n classes to provide a value.
176 function defaultTranslate($lang, $type, $k)
185 $lbits = explode('_', strtoupper($lang));
188 if (!isset($cache[$lang])) {
189 require_once 'I18Nv2/Country.php';
190 require_once 'I18Nv2/Language.php';
191 require_once 'I18Nv2/Currency.php';
192 $cache[$lang] = array(
193 'l' => new I18Nv2_Language($lang, 'UTF-8'),
194 'c' => new I18Nv2_Country($lang, 'UTF-8'),
195 'm' => new I18Nv2_Currency($lang, 'UTF-8')
197 //echo '<PRE>';print_r(array($lang, $cache[$lang]['c']));
201 return 'Other / Unknown';
206 $tolang = explode('_', $k);
208 $ret = $cache[$lang][$type]->getName($tolang[0]);
209 if (count($tolang) > 1) {
210 $ret.= '('.$tolang[1].')';
214 $ret = $cache[$lang][$type]->getName($k);
215 //print_r(array($k, $ret));