Exemplo n.º 1
0
 public function findUserPost(User $user, Post $post)
 {
     return $this->createQueryBuilder('nv')->join('nv.post', 'p')->join('nv.user', 'u')->leftJoin('nv.comment', 'c')->where('p.id = ' . $post->getId())->andWhere('u.id = ' . $user->getId())->andWhere('p.publie = 1')->addSelect('c')->getQuery()->getResult();
 }