Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $wall_post_obj->getAlbum()->getId()
- $wall_post_obj->getAlbum()->getName()
- $qb_1 = $em->createQueryBuilder();
- $q_1 = $qb_1->select('wp, fromUsr.id,
- fromUsr.professional_image,
- fromUsr.gender,
- fromUsr.firstname,
- fromUsr.lastname')
- ->from( 'Entitieswall_post', 'wp' )
- ->LeftJoin( 'wp.wall_postsFrom_user', 'fromUsr' )
- ->where( 'wp.id IN (:selected_wp_ids_r)' )
- ->setParameter( 'selected_wp_ids_r', $selected_wp_ids_r )
- ->orderBy( 'wp.last_activity_datetime', 'DESC' );
- // wallpost Comments join
- $q_1->addSelect( 'wall_comments, comment_user' );
- $q_1->LeftJoin( 'wp.wall_postsComment', 'wall_comments' );
- $q_1->LeftJoin( 'wall_comments.commentsIlook_user', 'comment_user' );
- // wallpost Likes join
- $q_1->addSelect( 'likes' );
- $q_1->LeftJoin( 'wp.wall_postsLikes', 'likes' );
- $q_1->LeftJoin( 'likes.likesLiked_by', 'likedByUser' );
- $q_1 = $q_1->getQuery()->getResult ();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement