suggestion.dao.php

Aller à la documentation de ce fichier.

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

class SuggestionDAO
{
    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 create(Suggestion $suggestion): bool
    {
        $stmt = $this->pdo->prepare('INSERT INTO ' . DB_PREFIX . 'suggestion (object, content, author_uuid) VALUES (:object, :content, :author_uuid)');
        $object = match ($suggestion->getObject()) {
            SuggestObject::BUG => 'bug',
            SuggestObject::GAME => 'jeu',
            SuggestObject::UI => 'ui',
            SuggestObject::OTHER => 'other',
        };
        $content = $suggestion->getContent();
        $authorUuid = $suggestion->getAuthorUuid();
        $stmt->bindParam(':object', $object);
        $stmt->bindParam(':content', $content);
        $stmt->bindParam(':author_uuid', $authorUuid);
        return $stmt->execute();
    }

    public function findAllWaiting(): ?array
    {
        $stmt = $this->pdo->prepare(
            'SELECT s.*, p.username
            FROM ' . DB_PREFIX . 'suggestion s
            JOIN ' . DB_PREFIX . 'player p ON s.author_uuid = p.uuid
            WHERE s.treated_by IS NULL'
        );
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $suggestsTab = $stmt->fetchAll();
        if (!$suggestsTab) {
            return null;
        }
        return $this->hydrateMany($suggestsTab);
    }

    private function hydrateMany(array $suggestsTab): array
    {
        $suggests = [];
        if ($suggestsTab) {
            foreach ($suggestsTab as $suggestTab) {
                $suggests[] = $this->hydrate($suggestTab);
            }
        }
        return $suggests;
    }

    public function hydrate(array $data): Suggestion
    {
        $suggestion = new Suggestion();
        $suggestion->setId($data['id']);
        $suggestion->setObject(
            match ($data['object']) {
                'bug' => SuggestObject::BUG,
                'jeu' => SuggestObject::GAME,
                'ui' => SuggestObject::UI,
                'other' => SuggestObject::OTHER,
            }
        );
        $suggestion->setContent($data['content']);
        $suggestion->setAuthorUuid($data['author_uuid']);
        $suggestion->setCreatedAt(new DateTime($data['created_at']));
        $suggestion->setAuthorUsername($data['username']);
        return $suggestion;
    }

    public function deny(?int $id): bool
    {
        $stmt = $this->pdo->prepare('UPDATE ' . DB_PREFIX . 'suggestion SET treated_by = :treated_by WHERE id = :id');
        $stmt->bindParam(':treated_by', $_SESSION['uuid']);
        $stmt->bindParam(':id', $id);
 
        return $stmt->execute();
    }

    public function accept(?int $id): bool
    {
        $stmt = $this->pdo->prepare('UPDATE ' . DB_PREFIX . 'suggestion SET treated_by = :treated_by, accepted = 1 WHERE id = :id');
        $stmt->bindParam(':treated_by', $_SESSION['uuid']);
        $stmt->bindParam(':id', $id);
 
        return $stmt->execute();
    }

    public function findById(?int $id)
    {
        $stmt = $this->pdo->prepare(
            'SELECT s.*, p.username
            FROM ' . DB_PREFIX . 'suggestion s
            JOIN ' . DB_PREFIX . 'player p ON s.author_uuid = p.uuid
            WHERE s.id = :id'
        );
        $stmt->bindParam(':id', $id);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $suggestTab = $stmt->fetch();
        if (!$suggestTab) {
            return null;
        }
        return $this->hydrate($suggestTab);
    }
}