* @copyright 2004-2007 Alan Knowles
* @license http://www.debian.org/misc/bsd.license BSD License (3 Clause)
* @version CVS: $Id$
* @link http://pear.php.net/package/Translation2
*/
/**
* require Translation2_Container class and DB_DataObjects
*/
require_once 'Translation2/Container.php';
require_once 'DB/DataObject.php';
/**
* Simple storage driver for fetching data from a db with DB_DataObject
*
* This storage driver can use all databases which are supported
* by the PEAR::DB abstraction layer to fetch data.
*
* Database Structure:
*
* // meta data etc. not supported yet...
*
* create table translations (
* id int(11) auto_increment not null primary key,
* string_id int(11),
* page varchar(128),
* lang varchar(10),
* translation text
* );
* alter table translations add index page (page);
* alter table translations add index lang (lang);
* alter table translations add index string_id (string_id);
*
*
* - then just run the dataobjects createtables script.
*
* @category Internationalization
* @package Translation2
* @author Alan Knowles
* @copyright 2004-2007 Alan Knowles
* @license http://www.debian.org/misc/bsd.license BSD License (3 Clause)
* @version CVS: $Id$
* @link http://pear.php.net/package/Translation2
*/
class Translation2_Container_dataobjectsimple extends Translation2_Container
{
// {{{ init
/**
* Initialize the container
*
* @param string $table table name
*
* @return boolean true
*/
function init($table = null)
{
$this->_setDefaultOptions();
if (!empty($table)) {
$this->options['table'] = $table;
}
return true;
}
// }}}
// {{{ _setDefaultOptions()
/**
* Set some default options
*
* @return void
* @access private
*/
function _setDefaultOptions()
{
$this->options['table'] = 'translations';
}
// }}}
// {{{ fetchLangs()
/**
* Fetch the available langs if they're not cached yet.
*
* @return void
*/
function fetchLangs()
{
$do = DB_DataObject::factory($this->options['table']);
$do->selectAdd();
$do->selectAdd('distinct lang');
$do->find();
$ret = array();
while ($do->fetch()) {
$l = $do->lang;
$ret[$l] = array(
'id' => $l,
'name' => $l,
'meta' => '',
'error_text' => '',
);
}
$this->langs = $ret;
}
// }}}
// {{{ getPage()
/**
* Returns an array of the strings in the selected page
*
* @param string $pageID page/group ID
* @param string $langID language ID
*
* @return array
*/
function &getPage($pageID = null, $langID = null)
{
$langID = $this->_getLangID($langID);
if (PEAR::isError($langID)) {
return $langID;
}
// First get the array of string IDs
$do = DB_DataObject::factory($this->options['table']);
$do->lang = '-';
$do->page = $pageID;
$do->find();
$stringIDs = array();
while ($do->fetch()) {
$stringIDs[$do->string_id] = $do->translation;
}
// Now get the array of strings
$do = DB_DataObject::factory($this->options['table']);
$do->page = $pageID;
$do->lang = $langID;
$do->find();
$translations = array();
while ($do->fetch()) {
$translations[$do->string_id] = $do->translation;
}
// Construct an associative array of stringIDs and translations
$strings = array();
foreach ($translations as $key => $value) {
$strings[$stringIDs[$key]] = $value;
}
return $strings;
}
// }}}
// {{{ getOne()
/**
* Get a single item from the container, without caching the whole page
*
* @param string $stringID string ID
* @param string $pageID page/group ID
* @param string $langID language ID
*
* @return string
*/
function getOne($stringID, $pageID = null, $langID = null)
{
$langID = $langID ? $langID : (isset($this->currentLang['id']) ? $this->currentLang['id'] : '-');
// get the string id
$do = DB_DataObject::factory($this->options['table']);
$do->lang = '-';
$do->page = $pageID;
$do->translation = $string;
// we dont have the base language translation..
if (!$do->find(true)) {
return '';
}
$stringID = $do->string_id;
$do = DB_DataObject::factory($this->options['table']);
$do->lang = $langID;
$do->page = $pageID;
$do->string_id = $stringID;
//print_r($do);
$do->selectAdd();
$do->selectAdd('translation');
if (!$do->find(true)) {
return '';
}
return $do->translation;
}
// }}}
// {{{ getStringID()
/**
* Get the stringID for the given string
*
* @param string $string string
* @param string $pageID page/group ID
*
* @return string
*/
function getStringID($string, $pageID = null)
{
// get the english version...
$do = DB_DataObject::factory($this->options['table']);
$do->lang = $this->currentLang['id'];
$do->page = $pageID;
$do->translation = $string;
if ($do->find(true)) {
return '';
}
return $do->string_id;
}
// }}}
}
?>