[Symfony] Doctrine i left joiny Opcje

[blackroger]

witam. jest sobie takie cos:

[PHP] pobierz, plaintext 
return Doctrine_Core::getTable('Article')->createQuery('a')
                                                 ->leftJoin('a.Translation t')
                                                 ->leftJoin('a.Gallery g')
                                                 ->leftJoin('g.Translation t2')
                                                 ->where('t.lang = ?', $lang)
                                                 ->addWhere('a.f_menu = ?', $this->getTId())
                                                 ->addWhere('t2.lang = ?', $lang)
                                                 ->orderBy('a.t_position')
                                                 ->execute();
[PHP] pobierz, plaintext 

Przy zrzucie na toArray:

[PHP] pobierz, plaintext 
Array
(
    [0] => Array
        (
            [t_id] => 7
            [f_menu] => 10
            [f_article_type] => 
            [f_user] => 
            [t_latitude] => 
            [t_longitude] => 
            [t_position] => 7
            [d_created_at] => 2011-05-05 13:47:01
            [d_modified_at] => 
            [Translation] => Array
                (
                    [pl] => Array
                        (
                            [t_id] => 7
                            [t_title] => 
                            [e_content] => 
                        )
 
                )
 
            [Gallery] => Array
                (//i tu jest pusto chociaz zapytanie zwraca wyniki
                )
 
        )
 
)
[PHP] pobierz, plaintext 

Zapytanie z debuggera:

[SQL] pobierz, plaintext 
SELECT a.t_id AS a__t_id, a.f_menu AS a__f_menu, a.f_article_type AS a__f_article_type, a.f_user AS a__f_user, a.t_latitude AS a__t_latitude, a.t_longitude AS a__t_longitude, a.t_position AS a__t_position, a.d_created_at AS a__d_created_at, a.d_modified_at AS a__d_modified_at, a2.t_id AS a2__t_id, a2.t_title AS a2__t_title, a2.e_content AS a2__e_content, a2.lang AS a2__lang, a2.slug AS a2__slug, g.t_id AS g__t_id, g.t_filename AS g__t_filename, g.t_extension AS g__t_extension, g.f_gallery_type AS g__f_gallery_type, g.f_menu AS g__f_menu, g.f_article AS g__f_article, g.f_comment AS g__f_comment, g.f_news AS g__f_news, g.t_path AS g__t_path, g.t_size AS g__t_size, g.t_x_size AS g__t_x_size, g.t_y_size AS g__t_y_size, g.t_position AS g__t_position, g.d_created_at AS g__d_created_at, g.d_modified_at AS g__d_modified_at, g2.t_id AS g2__t_id, g2.t_desc AS g2__t_desc, g2.t_tip AS g2__t_tip, g2.lang AS g2__lang, g2.slug AS g2__slug FROM article a LEFT JOIN article_translation a2 ON a.t_id = a2.t_id LEFT JOIN gallery g ON a.t_id = g.f_article LEFT JOIN gallery_translation g2 ON g.t_id = g2.t_id WHERE (a2.lang = 'pl' AND a.f_menu = '10' AND g2.lang = 'pl') ORDER BY a.t_position
[SQL] pobierz, plaintext 

Co robię nie tak że Doctrine nie widzi tej tabeli gallery?

[janek9]

może tak? :

CODE

return Doctrine_Query::create()
->select(a.*,g.*,t.*,t2.*)
->from(Article a)
->leftJoin('a.Translation t')
->leftJoin('a.Gallery g')
->leftJoin('g.Translation t2')
->where('t.lang = ?', $lang)
->addWhere('a.f_menu = ?', $this->getTId())
->addWhere('t2.lang = ?', $lang)
->orderBy('a.t_position')
->execute();