本文整理汇总了PHP中EntityRepository::createQueryBuilder方法的典型用法代码示例。如果您正苦于以下问题:PHP EntityRepository::createQueryBuilder方法的具体用法?PHP EntityRepository::createQueryBuilder怎么用?PHP EntityRepository::createQueryBuilder使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类EntityRepository
的用法示例。
在下文中一共展示了EntityRepository::createQueryBuilder方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: findVotesByComment
/**
* Finds all votes belonging to a comment.
*
* @param \FOS\CommentBundle\Model\VotableCommentInterface $comment
* @return array|null
*/
public function findVotesByComment(VotableCommentInterface $comment)
{
$qb = $this->repository->createQueryBuilder('v');
$qb->join('v.comment', 'c');
$qb->andWhere('c.id = :commentId');
$qb->setParameter('commentId', $comment->getId());
$votes = $qb->getQuery()->execute();
return $votes;
}
示例2: findInvoiceItemsByInvoiceId
/**
* {@inheritDoc}
*/
public function findInvoiceItemsByInvoiceId($invoiceId)
{
$qb = $this->repository->createQueryBuilder('a');
$qb->join('a.invoice', 't')->where('t.id = :invoiceId')->setParameter('invoiceId', $invoiceId);
$invoiceiItems = $qb->getQuery()->execute();
if (!$invoiceiItems) {
return array();
}
return $invoiceiItems;
}
示例3: findCommentTreeByCommentId
/**
* Returns the requested comment tree branch
*
* @param integer $commentId
* @param string $sorter
* @return array See findCommentTreeByThread
*/
public function findCommentTreeByCommentId($commentId, $sorter = null)
{
$qb = $this->repository->createQueryBuilder('c');
$qb->join('c.thread', 't')->where('LOCATE(:path, CONCAT(\'/\', CONCAT(c.ancestors, \'/\'))) > 0')->orderBy('c.ancestors', 'ASC')->setParameter('path', "/{$commentId}/");
$comments = $qb->getQuery()->execute();
if (!$comments) {
return array();
}
$sorter = $this->getSortingFactory()->getSorter($sorter);
$trimParents = current($comments)->getAncestors();
return $this->organiseComments($comments, $sorter, $trimParents);
}