witam. jest sobie takie cos:
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();
Przy zrzucie na toArray:
(
(
[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] =>
(
(
[t_id] => 7
[t_title] =>
[e_content] =>
)
)
(//i tu jest pusto chociaz zapytanie zwraca wyniki
)
)
)
Zapytanie z debuggera:
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
Co robię nie tak że Doctrine nie widzi tej tabeli gallery?