VideoGamesRecords\DwhBundle\DataProvider\Core\GameProvider

Complexity

Total Complexity

3

Size/Duplication

Total Lines	42
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getNbPostDay()	0	26	2
A	getData()	0	4	1

<?php

namespace VideoGamesRecords\DwhBundle\DataProvider\Core;

class GameProvider extends AbstractTablePlayerProvider
{
    /**
     * @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;
    }
}