php - 如何在dql中选择AVG？

Question

我想在 dql 中获取列的平均值，但我没有运气。

    $qb = $this->em->getRepository($this->target)->createQueryBuilder('m');         
    $qb
        ->select($qb->expr()->avg('m.total_online as ACU'))
        ->where('m.server = :server')
        ->andWhere('m.time LIKE :time')
        ->setParameter('server', $server)
        ->setParameter('time',$date.'%');           
        $rs= $qb->getQuery()
        ->getResult();

但它不会给我预期的结果:

+--------+
| ACU    |
+--------+
| 0.1429 |
+--------+

我的sql是:

SELECT AVG(Total_Online) as ACU FROM `monitor` WHERE time like '2016-12-01%' AND server='$x'

有人能帮帮我吗？？谢谢

Answer 1

我在这里得到了答案:

$qb = $this->em->createQueryBuilder();
$rs = $qb
        ->select($qb->expr()->avg('m.total_online'))
        ->from($this->target,'m')
        ->where('m.server = :server')
        ->andWhere('m.time LIKE :time')
        ->setParameter('server', $server)
        ->setParameter('time',$date.'%')            
        ->getQuery()
        ->getResult();

希望对大家有所帮助。