public function getAll()
    {

        $qb = $this->getQueryBuilder()
            ->select('SUM(i.totalPrice)')
            ->innerJoin('t.items', 'i')
            ->where('t.status = :status')
            ->setParameter('status', Transaction::STATUS_PAID);

        return $qb->getQuery()
            ->getSingleScalarResult();
    }