Passed
Pull Request — master (#28)
by
unknown
04:02
created

DownloadRepository::getProviderStats()   A

Complexity

Conditions 2
Paths 2

Size

Total Lines 32
Code Lines 25

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
cc 2
eloc 25
c 1
b 0
f 0
nc 2
nop 2
dl 0
loc 32
rs 9.52
1
<?php
2
3
namespace App\Repositories;
4
5
use App\Document\Provider;
6
use Doctrine\ODM\MongoDB\DocumentRepository;
7
8
class DownloadRepository extends DocumentRepository
9
{
10
    public function getProviderStats(Provider $provider, $version = null)
11
    {
12
        $builder = $this->createAggregationBuilder();
13
        $builder
14
            ->addFields()
15
            ->field('stringdate')
16
            ->dateToString('%Y-%m-%d', '$date')
17
            ->match()
18
            ->field('provider')
19
            ->equals($provider->getName())
20
            ->sort('date', -1);
21
22
        if ($version) {
23
            $builder->match()
24
                ->field('version')
25
                ->equals($version);
26
        }
27
28
        $builder
29
            ->group()
30
            ->field('id')
31
            ->expression('$stringdate')
32
            ->field('downloads')
33
            ->sum(1)
34
35
            ->project()
36
            ->excludeFields(['_id'])
37
            ->includeFields(['date', 'downloads'])
38
            ->field('date')
39
            ->expression('$_id');
40
41
        return $builder->execute();
42
    }
43
44
    public function countLast7Days()
45
    {
46
        $qb = $this->createQueryBuilder()->count();
47
48
        $date = new \DateTime();
49
        $date->sub(new \DateInterval('P7D'));
50
        $qb->field('date')->gte($date);
51
52
        return $qb->getQuery()->execute();
53
    }
54
}
55