report.dao.php

Aller à la documentation de ce fichier.

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

class ReportDAO
{
    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 insert(Report $report): bool
    {
        $stmt = $this->pdo->prepare(
            'INSERT INTO ' . DB_PREFIX . 'report (object, description, treated_by, reported_uuid, sender_uuid, created_at, updated_at)
            VALUES (:object, :description, :treated_by, :reported_uuid, :sender_uuid, :created_at, :updated_at)'
        );
        $stmt->bindValue(':object', $this->transformReportObjectToString($report->getObject()), PDO::PARAM_STR);
        $stmt->bindValue(':description', $report->getDescription(), PDO::PARAM_STR);
        $stmt->bindValue(':treated_by', $report->getTreatedBy(), PDO::PARAM_STR);
        $stmt->bindValue(':reported_uuid', $report->getReportedUuid(), PDO::PARAM_STR);
        $stmt->bindValue(':sender_uuid', $report->getSenderUuid(), PDO::PARAM_STR);
        $stmt->bindValue(':created_at', $report->getCreatedAt()->format('Y-m-d H:i:s'), PDO::PARAM_STR);
        $stmt->bindValue(':updated_at', $report->getUpdatedAt()->format('Y-m-d H:i:s'), PDO::PARAM_STR);
        return $stmt->execute();
    }

    private function transformReportObjectToString(ReportObject $reportObject): string
    {
        return match ($reportObject) {
            ReportObject::LANGUAGE => 'language',
            ReportObject::SPAM => 'spam',
            ReportObject::LINKS => 'links',
            ReportObject::FAIRPLAY => 'fairplay',
            default => 'other'
        };
    }

    public function findAllWaiting(): ?array
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'report
            WHERE treated_by IS NULL'
        );
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $reportsTab = $stmt->fetchAll();
        if (!$reportsTab) {
            return null;
        }
        return $this->hydrateMany($reportsTab);
    }

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

    public function hydrate(array $data): Report
    {
        $report = new Report();
        $report->setId($data['id']);
        $report->setObject(
            match ($data['object']) {
                'language' => ReportObject::LANGUAGE,
                'spam' => ReportObject::SPAM,
                'links' => ReportObject::LINKS,
                'fairplay' => ReportObject::FAIRPLAY,
                default => ReportObject::OTHER
            }
        );
        $report->setDescription($data['description']);
        $report->setTreatedBy($data['treated_by']);
        $report->setReportedUuid($data['reported_uuid']);
        $report->setSenderUuid($data['sender_uuid']);
        $report->setCreatedAt(new DateTime($data['created_at']));
        $report->setUpdatedAt(new DateTime($data['updated_at']));
        return $report;
    }

    public function findById(int $id): ?Report
    {
        $stmt = $this->pdo->prepare(
            'SELECT *
            FROM ' . DB_PREFIX . 'report
            WHERE id = :id'
        );
        $stmt->bindValue(':id', $id, PDO::PARAM_INT);
        $stmt->execute();
        $stmt->setFetchMode(PDO::FETCH_ASSOC);
        $report = $stmt->fetch();
        if (!$report) {
            return null;
        }
        return $this->hydrate($report);
    }

    public function update(Report $report): void
    {
        $stmt = $this->pdo->prepare(
            'UPDATE ' . DB_PREFIX . 'report
            SET object = :object, description = :description, treated_by = :treated_by, reported_uuid = :reported_uuid
             , sender_uuid = :sender_uuid, updated_at = NOW()
            WHERE id = :id'
        );
        $stmt->bindValue(':object', $this->transformReportObjectToString($report->getObject()), PDO::PARAM_STR);
        $stmt->bindValue(':description', $report->getDescription(), PDO::PARAM_STR);
        $stmt->bindValue(':reported_uuid', $report->getReportedUuid(), PDO::PARAM_STR);
        $stmt->bindValue(':sender_uuid', $report->getSenderUuid(), PDO::PARAM_STR);
        $stmt->bindValue(':treated_by', $report->getTreatedBy(), PDO::PARAM_STR);
        $stmt->bindValue(':id', $report->getId(), PDO::PARAM_INT);
        $stmt->execute();
    }
}