CoreTeamStrategy::getNbPostDay() - Code Metrics - Inspection of "Feat: Rename AbstractTableProvider to AbstractCore..." - video-games-records/dwh-bundle - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — develop (4ef38d)

by BENARD

created 2023-05-30 18:48 UTC

CoreTeamStrategy::getNbPostDay() A

↳ Parent: CoreTeamStrategy

Complexity

Conditions	2
Paths	2

Size

Total Lines	23
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	17
dl	0
loc	23
rs	9.7
c	0
b	0
f	0
cc	2
nc	2
nop	2

<?php

namespace VideoGamesRecords\DwhBundle\DataProvider\Strategy\Core;

use DateTime;
use VideoGamesRecords\DwhBundle\Contracts\Strategy\CoreStrategyInterface;

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

    /**
     * @return array
     */
    public function getData(): array
    {
        $conn = $this->em->getConnection();
        $sql = "SELECT t.id,
                   t.pointChart,
                   t.pointBadge,
                   t.chartRank0,
                   t.chartRank1,
                   t.chartRank2,
                   t.chartRank3,
                   t.rankPointChart,
                   t.rankMedal,
                   t.rankBadge,
                   t.rankCup,
                   t.gameRank0,
                   t.gameRank1,
                   t.gameRank2,
                   t.gameRank3,
                   t.nbMasterBadge,
                   t.pointGame,
                   t.rankPointGame                  
            FROM vgr_team t";

        $stmt = $conn->prepare($sql);
        $resultSet = $stmt->executeQuery();
        return $resultSet->fetchAllAssociative();
    }

    /**
     * @param DateTime $date1
     * @param DateTime $date2
     * @return array
     */
    public function getNbPostDay(DateTime $date1, DateTime $date2): array
    {
        $query = $this->em->createQuery(
            "
            SELECT
                 t.id,
                 COUNT(pc.id) as nb
            FROM VideoGamesRecords\CoreBundle\Entity\PlayerChart pc
            JOIN pc.player p
            JOIN p.team t
            WHERE pc.lastUpdate BETWEEN :date1 AND :date2
            GROUP BY t.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			namespace VideoGamesRecords\DwhBundle\DataProvider\Strategy\Core;
4
5			use DateTime;
6			use VideoGamesRecords\DwhBundle\Contracts\Strategy\CoreStrategyInterface;
7
8			class CoreTeamStrategy extends AbstractCoreProvider implements CoreStrategyInterface
9			{
10			public function supports(string $name): bool
11			{
12			return $name === self::TYPE_TEAM;
13			}
14
15			/**
16			* @return array
17			*/
18			public function getData(): array
19			{
20			$conn = $this->em->getConnection();
21			$sql = "SELECT t.id,
22			t.pointChart,
23			t.pointBadge,
24			t.chartRank0,
25			t.chartRank1,
26			t.chartRank2,
27			t.chartRank3,
28			t.rankPointChart,
29			t.rankMedal,
30			t.rankBadge,
31			t.rankCup,
32			t.gameRank0,
33			t.gameRank1,
34			t.gameRank2,
35			t.gameRank3,
36			t.nbMasterBadge,
37			t.pointGame,
38			t.rankPointGame
39			FROM vgr_team t";
40
41			$stmt = $conn->prepare($sql);
42			$resultSet = $stmt->executeQuery();
43			return $resultSet->fetchAllAssociative();
44			}
45
46			/**
47			* @param DateTime $date1
48			* @param DateTime $date2
49			* @return array
50			*/
51			public function getNbPostDay(DateTime $date1, DateTime $date2): array
52			{
53			$query = $this->em->createQuery(
54			"
55			SELECT
56			t.id,
57			COUNT(pc.id) as nb
58			FROM VideoGamesRecords\CoreBundle\Entity\PlayerChart pc
59			JOIN pc.player p
60			JOIN p.team t
61			WHERE pc.lastUpdate BETWEEN :date1 AND :date2
62			GROUP BY t.id"
63			);
64
65			$query->setParameter('date1', $date1);
66			$query->setParameter('date2', $date2);
67			$result = $query->getResult();
68
69			$data = array();
70			foreach ($result as $row) {
71			$data[$row['id']] = $row['nb'];
72			}
73			return $data;
74			}
75			}
76
77

video-games-records / dwh-bundle

Branch — develop (4ef38d)

CoreTeamStrategy::getNbPostDay() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like