App\Service\StatsService::getWanderStats()

Complexity

Conditions	2
Paths	1

Size

Total Lines	78
Code Lines	55

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function getWanderStats(): array
    {
        $stats = $this->cache->get('wander_stats', function(ItemInterface $item) {
            $item->tag('stats');
            $wanderStats = $this->wanderRepository
                ->createQueryBuilder('w')
                ->select('COUNT(w.id) as totalCount')
                ->addSelect('COUNT(w.title) as countWithTitle')
                ->addSelect('COUNT(w.description) as countWithDescription')
                //->addSelect('SUM(w.durationSeconds) as totalDuration')
                ->addSelect('COALESCE(SUM(w.distance), 0) as totalDistance')
                ->addSelect('COALESCE(SUM(w.cumulativeElevationGain), 0) as totalCumulativeElevationGain')
                ->getQuery()
                ->getOneOrNullResult();

            $wanderStats['hasWanders'] = $wanderStats['totalCount'] > 0;

            // Doctrine doesn't support calculating a difference
            // in seconds from two datetime values via ORM. Let's
            // go raw.
            $conn = $this->entityManager->getConnection();
            $sql = 'SELECT COALESCE(SUM(TIME_TO_SEC(TIMEDIFF(end_time, start_time))), 0) FROM wander';
            $stmt = $conn->prepare($sql);
            $stmt->execute();
            $seconds = $stmt->fetchOne();

            $interval = CarbonInterval::seconds($seconds)->cascade();

            $wanderStats['totalDuration'] = $interval;
            $wanderStats['totalDurationForHumans'] = $interval->forHumans([
                    'short' => true
                ]);

            // Set up defaults for average, in case we have no wanders
            $wanderStats['averageWanderDuration'] = 0;
            $wanderStats['averageWanderDurationForHumans'] = '0s';

            if ($wanderStats['hasWanders']) { // Avoid divide by zero
                $interval = CarbonInterval::seconds($seconds / $wanderStats['totalCount'])->cascade();
                $wanderStats['averageDuration'] = $interval;
                $wanderStats['averageDurationForHumans'] = $interval->forHumans([
                        'short' => true
                    ]);
            }

            $wanderStats['longestWanderDistance'] = $this->wanderRepository
                ->createQueryBuilder('w')
                ->select('w.id, w.distance')
                ->orderBy('w.distance', 'desc')
                ->setMaxResults(1)
                ->getQuery()
                ->getOneOrNullResult();

            $wanderStats['shortestWanderDistance'] = $this->wanderRepository
                ->createQueryBuilder('w')
                ->select('w.id, w.distance')
                ->orderBy('w.distance', 'asc')
                ->setMaxResults(1)
                ->getQuery()
                ->getOneOrNullResult();

            $wanderStats['averageWanderDistance'] = $this->wanderRepository
                ->createQueryBuilder('w')
                ->select('AVG(w.distance)')
                ->getQuery()
                ->getSingleScalarResult() ?? 0;

            $qb = $this->wanderRepository
                ->createQueryBuilder('w');
            $wanderStats['imageProcessingBacklog'] = $this->wanderRepository->addWhereHasImages($qb, false)
                ->select('COUNT(w.id)')
                ->getQuery()
                ->getSingleScalarResult();

            return $wanderStats;
        });

        return $stats;
    }
}