Witaj Gościu! ( Zaloguj | Rejestruj )

Forum PHP.pl

> [Symfony] Doctrine i left joiny
blackroger
post
Post #1





Grupa: Zarejestrowani
Postów: 176
Pomógł: 0
Dołączył: 8.11.2008

Ostrzeżenie: (0%)
-----


witam. jest sobie takie cos:

  1. return Doctrine_Core::getTable('Article')->createQuery('a')
  2. ->leftJoin('a.Translation t')
  3. ->leftJoin('a.Gallery g')
  4. ->leftJoin('g.Translation t2')
  5. ->where('t.lang = ?', $lang)
  6. ->addWhere('a.f_menu = ?', $this->getTId())
  7. ->addWhere('t2.lang = ?', $lang)
  8. ->orderBy('a.t_position')
  9. ->execute();


Przy zrzucie na toArray:

  1. (
  2. [0] => Array
  3. (
  4. [t_id] => 7
  5. [f_menu] => 10
  6. [f_article_type] =>
  7. [f_user] =>
  8. [t_latitude] =>
  9. [t_longitude] =>
  10. [t_position] => 7
  11. [d_created_at] => 2011-05-05 13:47:01
  12. [d_modified_at] =>
  13. [Translation] => Array
  14. (
  15. [pl] => Array
  16. (
  17. [t_id] => 7
  18. [t_title] =>
  19. [e_content] =>
  20. )
  21.  
  22. )
  23.  
  24. [Gallery] => Array
  25. (//i tu jest pusto chociaz zapytanie zwraca wyniki
  26. )
  27.  
  28. )
  29.  
  30. )





Zapytanie z debuggera:
  1. 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?

Go to the top of the page
+Quote Post

Posty w temacie


Reply to this topicStart new topic
1 Użytkowników czyta ten temat (1 Gości i 0 Anonimowych użytkowników)
0 Zarejestrowanych:

 



RSS Aktualny czas: 19.08.2025 - 05:04