orocrm / platform

     *

     * @return integer

     */

    protected function getIdentifyPrevVisitsCount()

    {

        $em           = $this->getEntityManager();

        $queryBuilder = $em

            ->getRepository(self::TRACKING_VISIT_ENTITY)

            ->createQueryBuilder('entity');

        $queryBuilder

            ->select('COUNT (entity.id)')

            ->where('entity.identifierDetected = false')

            ->andWhere('entity.parsedUID > 0')

            ->andWhere('entity.parsingCount < :maxRetries')

            ->setParameter('maxRetries', $this->getMaxRetriesCount());

        if (count($this->skipList)) {

            $queryBuilder->andWhere('entity.id not in(' . implode(',', $this->skipList) . ')');

        }

        return $queryBuilder->getQuery()->getSingleScalarResult();

    }

    /**

     * Returns count of tracking visit events to be processed.

     *

     * @return integer

     */

    protected function getIdentifyPrevVisitEventsCount()

    {

        $em           = $this->getEntityManager();

        $queryBuilder = $em

            ->getRepository(self::TRACKING_VISIT_EVENT_ENTITY)

            ->createQueryBuilder('entity');

        $queryBuilder

            ->select('COUNT (entity.id)')

            ->andWhere('entity.parsingCount < :maxRetries')

            ->setParameter('maxRetries', $this->getMaxRetriesCount());

        if (count($this->skipList)) {

            $queryBuilder->andWhere('entity.id not in(' . implode(',', $this->skipList) . ')');

        }

        return $queryBuilder->getQuery()->getSingleScalarResult();

    }

    /**

     * Process previous visit events