game.dao.php

Aller à la documentation de ce fichier.

<?php
 
namespace ComusParty\Models;
 
use DateTime;
use Exception;
use PDO;

class GameDAO
{
    private ?PDO $pdo;

    public function __construct(?PDO $pdo)
    {
        $this->pdo = $pdo;
    }

    public function getPdo(): ?PDO
    {
        return $this->pdo;
    }

    public function setPdo(?PDO $pdo): void
    {
        $this->pdo = $pdo;
    }

    public function findById(int $id): ?Game
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'game
            WHERE id = :id');
        $stmt->bindParam(':id', $id);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $gameTab = $stmt->fetch();
        if ($gameTab === false) {
            return null;
        }
        return $this->hydrate($gameTab);
    }

    public function hydrate(array $gameTab): Game
    {
        $game = new Game();
        $game->setId($gameTab['id']);
        $game->setName($gameTab['name']);
        $game->setDescription($gameTab['description']);
        $game->setPathImg($gameTab['img_path']);
        $game->setState($this->transformStringToGameState($gameTab['state']));
        $game->setCreatedAt(new DateTime($gameTab['created_at']));
        $game->setUpdatedAt(new DateTime($gameTab['updated_at']));
        $game->setTags($gameTab['tags'] ?? null);
        return $game;
    }

    private function transformStringToGameState(string $state): ?GameState
    {
        return match (strtoupper($state)) {
            'AVAILABLE' => GameState::AVAILABLE,
            'UNAVAILABLE' => GameState::UNAVAILABLE,
            'MAINTENANCE' => GameState::MAINTENANCE,
            default => null,
        };
    }

    public function findAll(): array
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'game');
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $gamesTab = $stmt->fetchAll();
        return $this->hydrateMany($gamesTab);
    }

    public function hydrateMany(array $gamesTab): array
    {
        $games = [];
        foreach ($gamesTab as $gameTab) {
            $games[] = $this->hydrate($gameTab);
        }
        return $games;
    }

    public function findAllWithTags(): array
    {
        $stmt = $this->pdo->prepare(
            'SELECT g.*, GROUP_CONCAT(t.name) as tags
            FROM ' . DB_PREFIX . 'game g
            JOIN ' . DB_PREFIX . 'tagged tg ON g.id = tg.game_id
            JOIN ' . DB_PREFIX . 'tag t ON tg.tag_id = t.id
            GROUP BY g.id;');
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $gamesTab = $stmt->fetchAll();
        $gamesTab = array_map(function ($game) {
            $game['tags'] = explode(',', $game['tags']);
            return $game;
        }, $gamesTab);
        return $this->hydrateMany($gamesTab);
    }

    public function findWithDetailsById(?int $id): ?Game
    {
        $stmt = $this->pdo->prepare(
            'SELECT g.*, GROUP_CONCAT(t.name) as tags
            FROM ' . DB_PREFIX . 'game g
            JOIN ' . DB_PREFIX . 'tagged tg ON g.id = tg.game_id
            JOIN ' . DB_PREFIX . 'tag t ON tg.tag_id = t.id
            WHERE g.id = :id
            GROUP BY g.id;');
        $stmt->bindParam(':id', $id);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $gameTab = $stmt->fetch();
        if ($gameTab === false) {
            return null;
        }
        $gameTab['tags'] = explode(',', $gameTab['tags']);
        return $this->hydrate($gameTab);
    }
}