orocrm / crm

     *

     * @return int

     */

    public function getCustomersCountWhatMakeCarts(AclHelper $aclHelper, \DateTime $from, \DateTime $to)

    {

        $qb = $this->createQueryBuilder('c');

        try {

            $qb

                ->select('COUNT(DISTINCT c.customer) + SUM(CASE WHEN c.isGuest = true THEN 1 ELSE 0 END)')

                ->andWhere($qb->expr()->between('c.createdAt', ':from', ':to'))

                ->setParameters([

                    'from' => $from,

                    'to'   => $to

                ]);

            $this->applyActiveChannelLimitation($qb);

            return (int) $aclHelper->apply($qb)->getSingleScalarResult();

        } catch (NoResultException $ex) {

            return 0;

        }

    }

}

     *

     * @return int

     */

    public function getUniqueBuyersCount(AclHelper $aclHelper, DateTime $from, DateTime $to)

    {

        $qb = $this->createQueryBuilder('o');

        try {

            $qb

                ->select('COUNT(DISTINCT o.customer) + SUM(CASE WHEN o.isGuest = true THEN 1 ELSE 0 END)')

                ->andWhere($qb->expr()->between('o.createdAt', ':from', ':to'))

                ->setParameters([

                    'from' => $from,

                    'to'   => $to

                ]);

            $this->applyActiveChannelLimitation($qb);

            return (int) $aclHelper->apply($qb)->getSingleScalarResult();

        } catch (NoResultException $ex) {

            return 0;

        }

    }

}