Advertisement
Guest User

Untitled

a guest
May 7th, 2015
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. $wall_post_obj->getAlbum()->getId()
  2.  
  3. $wall_post_obj->getAlbum()->getName()
  4.  
  5. $qb_1 = $em->createQueryBuilder();
  6. $q_1 = $qb_1->select('wp, fromUsr.id,
  7. fromUsr.professional_image,
  8. fromUsr.gender,
  9. fromUsr.firstname,
  10. fromUsr.lastname')
  11. ->from( 'Entitieswall_post', 'wp' )
  12. ->LeftJoin( 'wp.wall_postsFrom_user', 'fromUsr' )
  13. ->where( 'wp.id IN (:selected_wp_ids_r)' )
  14. ->setParameter( 'selected_wp_ids_r', $selected_wp_ids_r )
  15. ->orderBy( 'wp.last_activity_datetime', 'DESC' );
  16.  
  17. // wallpost Comments join
  18. $q_1->addSelect( 'wall_comments, comment_user' );
  19. $q_1->LeftJoin( 'wp.wall_postsComment', 'wall_comments' );
  20. $q_1->LeftJoin( 'wall_comments.commentsIlook_user', 'comment_user' );
  21.  
  22. // wallpost Likes join
  23. $q_1->addSelect( 'likes' );
  24. $q_1->LeftJoin( 'wp.wall_postsLikes', 'likes' );
  25. $q_1->LeftJoin( 'likes.likesLiked_by', 'likedByUser' );
  26.  
  27. $q_1 = $q_1->getQuery()->getResult ();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement