CoreGameStrategy::getNbPostDay() - Code Metrics - video-games-records/dwh-bundle - Measure and Improve Code Quality continuously with Scrutinizer

CoreGameStrategy::getNbPostDay() A
last analyzed 2024-12-08 14:20 UTC

↳ Parent: CoreGameStrategy

Complexity

Conditions	2
Paths	2

Size

Total Lines	26
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	18
dl	0
loc	26
rs	9.6666
c	0
b	0
f	0
cc	2
nc	2
nop	2

<?php

declare(strict_types=1);

namespace VideoGamesRecords\DwhBundle\DataProvider\Strategy\Core;

use VideoGamesRecords\DwhBundle\Contracts\Strategy\CoreStrategyInterface;

class CoreGameStrategy extends AbstractCoreProvider implements CoreStrategyInterface
{
    public function supports(string $name): bool
    {
        return $name === self::TYPE_GAME;
    }

    /**
     * @return array
     */
    public function getData(): array
    {
        return $this->em->getRepository('VideoGamesRecords\CoreBundle\Entity\Game')
            ->findAll();
    }

    /**
     * @param $date1
     * @param $date2
     * @return array
     */
    public function getNbPostDay($date1, $date2): array
    {
        //----- data nbPostDay
        $query = $this->em->createQuery(
            "
            SELECT
                 ga.id,
                 COUNT(pc.id) as nb
            FROM VideoGamesRecords\CoreBundle\Entity\PlayerChart pc
            JOIN pc.chart c
            JOIN c.group gr
            JOIN gr.game ga
            WHERE pc.lastUpdate BETWEEN :date1 AND :date2
            GROUP BY ga.id"
        );

        $query->setParameter('date1', $date1);
        $query->setParameter('date2', $date2);
        $result = $query->getResult();

        $data = array();
        foreach ($result as $row) {
            $data[$row['id']] = $row['nb'];
        }

        return $data;
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace VideoGamesRecords\DwhBundle\DataProvider\Strategy\Core;
6
7			use VideoGamesRecords\DwhBundle\Contracts\Strategy\CoreStrategyInterface;
8
9			class CoreGameStrategy extends AbstractCoreProvider implements CoreStrategyInterface
10			{
11			public function supports(string $name): bool
12			{
13			return $name === self::TYPE_GAME;
14			}
15
16			/**
17			* @return array
18			*/
19			public function getData(): array
20			{
21			return $this->em->getRepository('VideoGamesRecords\CoreBundle\Entity\Game')
22			->findAll();
23			}
24
25			/**
26			* @param $date1
27			* @param $date2
28			* @return array
29			*/
30			public function getNbPostDay($date1, $date2): array
31			{
32			//----- data nbPostDay
33			$query = $this->em->createQuery(
34			"
35			SELECT
36			ga.id,
37			COUNT(pc.id) as nb
38			FROM VideoGamesRecords\CoreBundle\Entity\PlayerChart pc
39			JOIN pc.chart c
40			JOIN c.group gr
41			JOIN gr.game ga
42			WHERE pc.lastUpdate BETWEEN :date1 AND :date2
43			GROUP BY ga.id"
44			);
45
46			$query->setParameter('date1', $date1);
47			$query->setParameter('date2', $date2);
48			$result = $query->getResult();
49
50			$data = array();
51			foreach ($result as $row) {
52			$data[$row['id']] = $row['nb'];
53			}
54
55			return $data;
56			}
57			}
58

video-games-records / dwh-bundle

CoreGameStrategy::getNbPostDay() A last analyzed 2024-12-08 14:20 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CoreGameStrategy::getNbPostDay() A
last analyzed 2024-12-08 14:20 UTC