moderator.dao.php

Aller à la documentation de ce fichier.

<?php

 
namespace ComusParty\Models;
 
use DateMalformedStringException;
use DateTime;
use PDO;

class ModeratorDAO
{
    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 findByUuid(string $uuid): ?Moderator
    {
        $stmt = $this->pdo->prepare('SELECT * FROM ' . DB_PREFIX . 'moderator WHERE uuid = :uuid');
        $stmt->bindParam(':uuid', $uuid);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $moderatorTab = $stmt->fetch();
        if ($moderatorTab === false) {
            return null;
        }
        return $this->hydrate($moderatorTab);
    }

    public function hydrate(array $data): ?Moderator
    {
        $moderator = new Moderator();
        $moderator->setUuid($data['uuid']);
        $moderator->setUserId($data['user_id']);
        $moderator->setFirstName($data['first_name']);
        $moderator->setLastName($data['last_name']);
        $moderator->setCreatedAt(new DateTime($data['created_at']));
        $moderator->setUpdatedAt(new DateTime($data['updated_at']));
        return $moderator;
    }

    public function findByUserId(int $userId): ?Moderator
    {
        $stmt = $this->pdo->prepare('SELECT * FROM ' . DB_PREFIX . 'moderator WHERE user_id = :userId');
        $stmt->bindParam(':userId', $userId);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $moderatorTab = $stmt->fetch();
        if ($moderatorTab === false) {
            return null;
        }
        return $this->hydrate($moderatorTab);
    }

    public function hydrateMany(array $data): array
    {
        $moderators = [];
        foreach ($data as $moderator) {
            $moderators[] = $this->hydrate($moderator);
        }
        return $moderators;
    }
 
}