user.dao.php

Aller à la documentation de ce fichier.

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

class UserDAO
{
    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): ?User
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'user
            WHERE id = :id');
        $stmt->bindParam(':id', $id);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $userTab = $stmt->fetch();
        if ($userTab === false) {
            return null;
        }
        return $this->hydrate($userTab);
    }

    public function hydrate(array $data): User
    {
        $user = new User();
        $user->setId($data['id']);
        $user->setEmail($data['email']);
        $user->setEmailVerifiedAt($data['email_verified_at'] ? new DateTime($data['email_verified_at']) : null);
        $user->setEmailVerifyToken($data['email_verif_token']);
        $user->setPassword($data['password']);
        $user->setDisabled($data['disabled']);
        $user->setCreatedAt(new DateTime($data['created_at']));
        $user->setUpdatedAt(new DateTime($data['updated_at']));
        return $user;
    }

    public function update(User $user): bool
    {
        $stmt = $this->pdo->prepare(
            'UPDATE ' . DB_PREFIX . 'user
            SET email = :email,
                email_verified_at = :email_verified_at,
                email_verif_token = :email_verif_token,
                password = :password,
                disabled = :disabled
            WHERE id = :id'
        );
 
        $email = $user->getEmail();
        $verifiedAt = $user->getEmailVerifiedAt()?->format('Y-m-d H:i:s');
        $emailVerifyToken = $user->getEmailVerifyToken();
        $password = $user->getPassword();
        $disabled = $user->getDisabled();
        $id = $user->getId();
 
        $stmt->bindParam(':email', $email);
        $stmt->bindParam(':email_verified_at', $verifiedAt);
        $stmt->bindParam(':email_verif_token', $emailVerifyToken);
        $stmt->bindParam(':password', $password);
        $stmt->bindParam(':disabled', $disabled);
        $stmt->bindParam(':id', $id);
        return $stmt->execute();
    }
 

    public function findByEmail(?string $email): ?User
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'user
            WHERE email = :email');
        $stmt->bindParam(':email', $email);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $userTab = $stmt->fetch();
        if ($userTab === false) {
            return null;
        }
        return $this->hydrate($userTab);
    }

    public function disableAccount($id): void
    {
        $stmt = $this->pdo->prepare(
            'UPDATE ' . DB_PREFIX . 'user
            SET disabled = 1
            WHERE id = :id');
        $stmt->bindParam(':id', $id);
        $stmt->execute();
    }

    public function findByEmailVerifyToken(string $emailVerifToken): ?User
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'user
            WHERE email_verif_token = :email_verif_token');
        $stmt->bindParam(':email_verif_token', $emailVerifToken);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $userTab = $stmt->fetch();
        if ($userTab === false) {
            return null;
        }
        return $this->hydrate($userTab);
    }
 

    public function createUser(string $email, string $password, string $emailVerifToken): bool
    {
        $stmtUser = $this->pdo->prepare("INSERT INTO " . DB_PREFIX . "user (email, password, email_verified_at, email_verif_token, disabled) VALUES (:email, :password, null, :email_verif_token, 0)");
        $stmtUser->bindParam(':email', $email);
        $stmtUser->bindParam(':password', $password);
        $stmtUser->bindParam(':email_verif_token', $emailVerifToken);
        return $stmtUser->execute();
    }

    public function confirmUser(string $emailVerifToken): bool
    {
        $stmtUser = $this->pdo->prepare("UPDATE " . DB_PREFIX . "user SET email_verified_at = now(), email_verif_token = null WHERE email_verif_token = :email_verif_token");
        $stmtUser->bindParam(':email_verif_token', $emailVerifToken);
        return $stmtUser->execute();
    }
}