SUM up all values from table column - Doctrine QueryBuilder.

sum_total_orders_revenue.php

<?php

// Sum all values from order_total column in completed orders, and return.
$qb = $em->createQueryBuilder();
$qb = $qb
->select( 'SUM(e.orderTotal) as totalRevenue' )
->from( '[Vendor]\[Package]\Entity\Orders', 'e' )
->where( $qb->expr()->andX(
	$qb->expr()->eq( 'e.orderStatus', ':status' ),
	// $qb->expr()->in( 'e.state', array( 'queued', 'confirmed' ) )
	) )
->setParameter( 'status', 'completed' )
->getQuery()
;

$totalRevenue = $qb->getOneOrNullResult();

print_r( $totalRevenue );

thanks!

Thx you !

A slightly easier syntax would be:

    public function getAmountToBeInvoiced()
    {
        return $this->createQueryBuilder('t')
            ->select('(sum(t.quantity * t.amount)/100) as invoicableAmount')
            ->andWhere('t.invoicable = :true')
            ->andWhere('t.invoiced = :false')
            ->setParameter('true', true)
            ->setParameter('false', false)
            ->distinct()
            ->getQuery()
            ->getOneOrNullResult();
    }