App\Repositories\DownloadRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	countLast7Days()	0	9	1
A	getProviderStats()	0	32	2

<?php

namespace App\Repositories;

use App\Document\Provider;
use Doctrine\ODM\MongoDB\DocumentRepository;

class DownloadRepository extends DocumentRepository
{
    public function getProviderStats(Provider $provider, $version = null)
    {
        $builder = $this->createAggregationBuilder();
        $builder
            ->addFields()
            ->field('stringdate')
            ->dateToString('%Y-%m-%d', '$date')
            ->match()
            ->field('provider')
            ->equals($provider->getName())
            ->sort('date', -1);

        if ($version) {
            $builder->match()
                ->field('version')
                ->equals($version);
        }

        $builder
            ->group()
            ->field('id')
            ->expression('$stringdate')
            ->field('downloads')
            ->sum(1)

            ->project()
            ->excludeFields(['_id'])
            ->includeFields(['date', 'downloads'])
            ->field('date')
            ->expression('$_id');

        return $builder->execute();
    }

    public function countLast7Days()
    {
        $qb = $this->createQueryBuilder()->count();

        $date = new \DateTime();
        $date->sub(new \DateInterval('P7D'));
        $qb->field('date')->gte($date);

        return $qb->getQuery()->execute();
    }
}