What'd be a good pattern on Doctrine to have multiple languages

Question

Hi!

I have this challenge which consist in having a system that offers it's content in multiple languages, however a part of the data contained in the system is not translatable such as dates, ints and such.

I mean if I have a content on the following YAML

Corporativos:
  columns:
    nombre:
      type: string(254)
      notnull: true
    telefonos:
      type: string(500)
    email:
      type: string(254)
    webpage:
      type: string(254)
CorporativosLang:
  columns:
    corporativo_id:
      type: integer(8)
      notnull: true
    lang:
      type: string(16)
      fixed: false
    ubicacion:
      type: string()
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    contacto:
      type: string()
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    tipo_de_hoteles:
      type: string(254)
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
    paises:
      type: string()
      fixed: false
      unsigned: false
      primary: false
      notnull: true
      autoincrement: false
  relations:
    Corporativo:
      class: Corporativos
      local: corporativo_id
      foreign: id
      type: one
      foreignAlias: Data

This would allow me to have different corporative offices, however the place of the corp, the contact and other things can be translate into a different language (lang)

Now this code here would create me a brand new corporative office with 2 translations

    $corporativo = new Corporativos();

    $corporativo->nombre = 'Duck Corp';
    $corporativo->telefonos = '66303713333';
    $corporativo->email = '[email protected]';
    $corporativo->webpage = 'http://quack.com';

    $corporativo->Data[0]->lang = 'en';
    $corporativo->Data[0]->ubicacion = 'zomg';

    $corporativo->Data[1]->lang = 'es';
    $corporativo->Data[1]->ubicacion = 'zomg amigou';

the thing now is I don't know how to retrieve this data in a more friendly way, because if I'd like to access my Corporative info in english I'd had to run DQL for the corp and then another DQL for the specific translation in english,

What I'd love to do is have my translatable fields available in the root so I could simply access them

    $corporativo = new Corporativos();

    $corporativo->nombre = 'Duck Corp';
    $corporativo->telefonos = '66303713333';
    $corporativo->email = '[email protected]';
    $corporativo->webpage = 'http://quack.com';
            $corporativo->lang = 'en';
    $corporativo->ubicacion = 'zomg';

this way the translatable fields would be mapped to the second table automatically.

I hope I can explain my self clear :(

any suggestions ?

Answer 1

http://www.doctrine-project.org/extension/Localizable