penalty.dao.php

Aller à la documentation de ce fichier.

<?php

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

class PenaltyDAO
{
    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 hydrateMany(array $datas): array
    {
        $penalties = [];
        foreach ($datas as $data) {
            $penalties[] = $this->hydrate($data);
        }
        return $penalties;
    }

    public function hydrate(array $data): Penalty
    {
        $penalty = new Penalty();
        $penalty->setId($data['id']);
        $penalty->setCreatedBy($data['created_by']);
        $penalty->setCancelledBy($data['cancelled_by']);
        $penalty->setPenalizedUuid($data['penalized_uuid']);
        $penalty->setReason($data['reason']);
        $penalty->setDuration($data['duration']);
        $penalty->setCreatedAt(new DateTime($data['created_at']));
        $penalty->setUpdatedAt(new DateTime($data['updated_at']));
        return $penalty;
    }

    public function createPenalty(Penalty $penalty): bool
    {
        $stmt = $this->pdo->prepare("INSERT INTO " . DB_PREFIX . "penalty (created_by, penalized_uuid, reason, duration, type, created_at, updated_at) VALUES (:created_by, :penalized_uuid, :reason, :duration, :type, :created_at, :updated_at)");
 
        $createdBy = $penalty->getCreatedBy();
        $penalizedUuid = $penalty->getPenalizedUuid();
        $reason = $penalty->getReason();
        $duration = $penalty->getDuration();
        $penaltyType = $this->transformPenaltyTypeToString($penalty->getType());
        $createdAt = $penalty->getCreatedAt()->format('Y-m-d H:i:s');
        $updatedAt = $penalty->getUpdatedAt()->format('Y-m-d H:i:s');
 
        $stmt->bindParam(":created_by", $createdBy);
        $stmt->bindParam(":penalized_uuid", $penalizedUuid);
        $stmt->bindParam(":reason", $reason);
        $stmt->bindParam(":duration", $duration);
        $stmt->bindParam(":type", $penaltyType);
        $stmt->bindParam(":created_at", $createdAt);
        $stmt->bindParam(":updated_at", $updatedAt);
 
        return $stmt->execute();
    }

    private function transformPenaltyTypeToString(?PenaltyType $penaltyType): ?string
    {
        return match ($penaltyType) {
            PenaltyType::MUTED => 'muted',
            PenaltyType::BANNED => 'banned',
            default => null
        };
    }

    public function findLastMutedByPlayerUuid(string $playerUuid): ?Penalty
    {
        $stmt = $this->pdo->prepare("SELECT * FROM " . DB_PREFIX . "penalty WHERE penalized_uuid = :penalized_uuid AND type = 'muted' ORDER BY created_at DESC LIMIT 1");
        $stmt->bindParam(":penalized_uuid", $playerUuid);
        $stmt->execute();
        $data = $stmt->fetch();
        if ($data === false) {
            return null;
        }
        return $this->hydrate($data);
    }

    public function findLastPenaltyByPlayerUuid(string $playerUuid): ?Penalty
    {
        $stmt = $this->pdo->prepare("SELECT * FROM " . DB_PREFIX . "penalty WHERE penalized_uuid = :penalized_uuid ORDER BY created_at DESC LIMIT 1");
        $stmt->bindParam(":penalized_uuid", $playerUuid);
        $stmt->execute();
        $data = $stmt->fetch();
        if ($data === false) {
            return null;
        }
        return $this->hydrate($data);
    }
}