orocrm / crm

     *

     * @return int

     */

    public function getOrdersNumberValues($dateRange)

    {

        list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroCRMMagentoBundle:Order', 'createdAt');

        $qb = $this->getOrderRepository()->getOrdersNumberValueQB();

        $this->applyDateFiltering($qb, 'o.createdAt', $start, $end);

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

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

    }

    /**

     * @param array $dateRange

     *

     * @return int

     */

    public function getAbandonedRevenueValues($dateRange)

    {

        list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroCRMMagentoBundle:Cart', 'createdAt');

        $qb = $this->getCartRepository()->getAbandonedRevenueQB();

        $this->applyDateFiltering($qb, 'cart.createdAt', $start, $end);

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

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

    }

    /**

     * @param array $dateRange

     *

     * @return int

     */

    public function getAbandonedCountValues($dateRange)

    {

        list($start, $end) = $this->dateHelper->getPeriod($dateRange, 'OroCRMMagentoBundle:Cart', 'createdAt');

        $qb    = $this->getCartRepository()->getAbandonedCountQB();

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

        $this->applyDateFiltering($qb, 'cart.createdAt', $start, $end);

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

    }

    /**

     * @param array $dateRange