orocrm / crm

     * @return int

     * @throws \Doctrine\ORM\NonUniqueResultException

     */

    public function getAbandonedRevenueByPeriod(\DateTime $start, \DateTime $end, AclHelper $aclHelper)

    {

        $qb = $this->getAbandonedQB($start, $end);

        $qb->select('SUM(cart.grandTotal) as val');

        $this->applyActiveChannelLimitation($qb);

        $value = $aclHelper->apply($qb)->getOneOrNullResult();

        return $value['val'] ? : 0;

    }

    /**

     * @param \DateTime $start

     * @return int

     * @throws \Doctrine\ORM\NonUniqueResultException

     */

    public function getAbandonedCountByPeriod(\DateTime $start, \DateTime $end, AclHelper $aclHelper)

    {

        $qb = $this->getAbandonedQB($start, $end);

        $qb->select('COUNT(cart.grandTotal) as val');

        $this->applyActiveChannelLimitation($qb);

        $value = $aclHelper->apply($qb)->getOneOrNullResult();

        return $value['val'] ? : 0;

    }

    /**

     * @param \DateTime $start