寻找一个通用的解决方案来实现i18n到Yii模型。
最近我为像你这样的项目选择了一个非常相似的数据库模式。
唯一的区别是，我没有使用单独的语言表，我将语言信息存储在i18n表中。

以下解决方案没有自定义SQL语句，但我认为这可以用关系params实现，反正，如果你使用外键在你的数据库（例如MySQL InnoDB）gii将创建base_material和base_material_i18n表之间的关系，如

class BaseMaterial extends CActiveRecord

public function relation（）
{
return array b $ b'baseMaterialI18ns'=> array（self :: HAS_MANY，'base_material_i18n'，'id'），
）;
}



class BaseMaterialI18n extends CActiveRecord

public function relation（）
{
return array
'baseMaterial'=> array（self :: BELONGS_TO，'base_material'，'id'），
）;
}


现在您可以使用对象符号来访问您的翻译关系。

  $ model = BaseMaterial :: model（） - > with（'baseMaterialI18ns'） - > findByPk ）; 
 foreach（$ model-> baseMaterialI18ns AS $ translation）{
 if（$ translation-> language！=我需要的语言）continue：
 // data ... 
} 
 

我想过为这些模型创建一个行为或基类它将作为管理翻译的助手 - 伪代码：

  I18nActiveRecord扩展CActiveRecord 

 protected $ _attributesI18n; 

 //在查询上填充_attributesI18n ... 

 public function __get（$ name）{
 if（isset（$ this-> _attributesI18n ['language_I_need '] [$ name]））
 return $ this-> _attributesI18n [$ name]; 
 else if（isset（$ this-> _attributesI18n ['fallback_language'] [$ name]））
 return $ this-> _attributesI18n [$ name]; 
 else 
 parent :: __ get（）; 
} 
 

CActiveRecord __get（）source

有更多的工作要做，以找到所需的i18n记录，也可以进一步限制with（）选项来提高性能，减少PHP侧的解析。

但是可能有不同的用例，如何确定值，例如。所有翻译，翻译或后备，无后备（空值）。
这里的情况很有帮助。

PS：我会为 github项目！

I’m having a problem getting the data from my database which I created to be completely multilingual, and I hope someone here can help me.

I’ve split up all my tables in 2 parts; the "universal" table (does not contain any text that needs to be translated) and the table which contains all the fields that need to be translated with their translations.

Example tables:

base_material
    id
    picture
base_material_i18n
    base_material_id
    localization_id
    name
    description
    review_status
    review_notes
localization
    id
    language_name

Query to get the translations (using English (en) as a fall-back language if there is no translation available):

SELECT o.id
     , o.type
     , o.code
     , o.position
     , ifnull(t.name,d.name) name
     , ifnull(t.description,d.description) description
  FROM base_material o
       INNER JOIN base_material_i18n d
               ON ( o.id=d.base_material_id)
       LEFT OUTER JOIN base_material_i18n t
                    ON ( d.base_material_id=t.base_material_id AND t.localization_id='nl' )
 WHERE d.localization_id='en'

My question is how I can automatically get those translations (with the fall-back language as in this query) attached to my model in Yii when I’m searching for the base_material objects? (This is only 1 example table, but almost all my tables (20+) are built in this way, so if possible I would be needing something flexible)

An example of an existing system using what I would need is Propel: http://propel.posterous.com/propel-gets-i18n-behavior-and-why-it-matters

Any ideas how to go about doing that? I’ve checked the existing Yii extensions regarding multilingual sites (like Multilingual Active Record), but they all use a different database design (general information+fall-back language in the main table, translations in the i18n table), and I’m not sure how to change those extensions to use my kind of DB model.

If someone knows of a way to change that existing extension so it can use my kind of DB scheme, then that would be absolutely brilliant and probably the best way to do this.

Edit: I've added a bounty because I still can't find anything on how to let Propel work with Yii (there does exist an extension for Doctrine, but Doctrine doesn't support this kind of DB model with translations either), nor any more information as to how to deal with this using an existing Yii extension or with scopes.

Edit: 98 times viewed but only 3 upvotes and 1 comment. I can't help feeling like I'm doing something wrong here, be it in my question or application/database design; either that or my problem is just very unique (which would surprise me, as I don't think my multilingual database design is that absurd ;-). So, if anyone knows of a better all-round solution for multilingual sites with Yii and/or Propel (apart from the current extensions which I really don't like due to the duplication of text fields) or something similar, please let me know as well.

Thanks in advance!

I am also looking for a generic solution to implement i18n into Yii models. Recently I chose a very similar database schema for a project like you. The only difference is, that I am not using a separate language table, I store the language information in the i18n table.

The following solution is without a custom SQL statement, but I think this could be implemented with relation params, anyway, if you're working with foreign key in your database (eg. MySQL InnoDB) gii will create relations between your base_material and base_material_i18n table, like

class BaseMaterial extends CActiveRecord

public function relations()
{
    return array(
        'baseMaterialI18ns' => array(self::HAS_MANY, 'base_material_i18n', 'id'),
    );
}



class BaseMaterialI18n extends CActiveRecord

public function relations()
{
    return array(
        'baseMaterial' => array(self::BELONGS_TO, 'base_material', 'id'),
    );
}

Now you'd be able to access your translations by using the object notation for relations.

$model = BaseMaterial::model()->with('baseMaterialI18ns')->findByPk(1);
foreach($model->baseMaterialI18ns AS $translation) {
  if ($translation->language != "the language I need") continue:
  // do something with translation data ...
}

I thought about creating a behavior or base class for those models which would act a as helper for managing the translations - pseudo code:

I18nActiveRecord extends CActiveRecord

protected $_attributesI18n;

// populate _attributesI18n on query ...

public function __get($name) {
  if(isset($this->_attributesI18n['language_I_need'][$name]))
    return $this->_attributesI18n[$name];
  else if(isset($this->_attributesI18n['fallback_language'][$name]))
    return $this->_attributesI18n[$name];
  else 
    parent::__get();
}

CActiveRecord __get() source

There is more work to be done to find the needed i18n record, also you could further limit the with() option to improve performance and reduce parsing on the PHP side.

But there may be different use cases how to determine the value, e.g. all translations, translation or fallback, no fallback (empty value). Scenarios could be helpful here.

PS: I would be up for a github project!