php - 多对多 Doctrine : count left join collection

Question

注意:这是 Doctrine many to many: has user liked the article? 的后续内容

拥有三个实体:用户、文章、评论以及用户和评论之间的“commentLikedByUser”多对多关系，我需要从文章中获取评论集合，包括要使用的虚拟属性“userLiked”(bool)在 View 上。

//CommentRepository.php
public function findCommentsFromArticle($articleId,$userId)
{
    $result = $this->createQueryBuilder('c')
        ->where('c.article = :articleId')
        ->addSelect('COUNT(u) AS userLiked', 'c')
        ->leftJoin("c.users", 'u', 'WITH', 'u.id = :userId')
        ->setParameters(['articleId' => $articleId, 'userId' => $userId])
        ->orderBy('c.id', 'ASC')
        ->getQuery()
        ->getResult();

    dd($result);
}

转储以下内容:

如您所见，“userFavorite”的位置不正确，而是位于 Comment 对象之外。我该如何解决这个问题？

Answer 1

也许试试这个代码:

//CommentRepository.php
public function findCommentsFromArticle($articleId,$userId)
{
   $result = $this->createQueryBuilder('c')
    ->where('c.article = :articleId')
    ->addSelect('COUNT(u) AS userLiked', 'c')
    ->leftJoin('c.users', 'u')
    ->andWhere('u.id = :userId')
    ->setParameters(['articleId' => $articleId, 'userId' => $userId])
    ->orderBy('c.id', 'ASC')
    ->getQuery()
    ->getResult();

dd($result);

}