php - symfony 中的查询和子查询

Question

我在 symfony 查询生成器中使用查询和子查询，但是当执行它时，它返回一个错误。

我的代码是:

 $subQb = $em->createQueryBuilder();

            $subquery = $subQb->select('COUNT(v.id)')
                ->from('AdminBundle:Visitsite', 'v')
                ->where('v.site = s.id')
                ->Andwhere('v.createdate > :date')
                ->setParameter('date', $date->format('Y-m-d'))
                ->getDQL();

            $subQb2 = $em->createQueryBuilder();
            $subquery2 = $subQb2->select('quantity')
                ->from('AdminBundle:Limitviewday', 'l')
                ->where($subQb2->expr()->eq('s.limitviewday', 'l.id'))
                ->getDQL();

            $qb = $em->createQueryBuilder();
            $query = $qb->select('s')
                ->from('AdminBundle:Sites', 's')
                ->where('s.quantity > 1')
                ->Andwhere('s.status = 1')
                ->Andwhere($qb->expr()->lte("($subquery)", "($subquery2)"));

            $settlements = $query->getQuery()->getResult();

我的结果是

[Semantical Error] line 0, col 183 near 'quantity FROM': Error: 'quantity' is not defined.

请帮帮我。

Answer 1

我认为错误来自:

$subquery2 = $subQb2->select('quantity') // Expected '<alias>' or '<alias>.<property>'

改为:

$subquery2 = $subQb2->select('l.quantity')