invoice.dao.php

Aller à la documentation de ce fichier.

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

class InvoiceDAO
{
    private ?PDO $pdo;
 

    public function __construct(?PDO $pdo)
    {
        $this->pdo = $pdo;
    }

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

    public function hydrate(array $invoiceTab): Invoice
    {
        $invoice = new Invoice();
        $invoice->setId($invoiceTab['id']);
        $invoice->setCreatedAt(new DateTime($invoiceTab['created_at']));
        $invoice->setPlayerUuid($invoiceTab['player_uuid']);
        switch ($invoiceTab['payment_type']) {
            case 'card':
                $invoice->setPaymentType(PaymentType::Card);
                break;
            case 'paypal':
                $invoice->setPaymentType(PaymentType::PayPal);
                break;
            case 'comuscoins':
                $invoice->setPaymentType(PaymentType::ComusCoins);
                break;
            default:
                break;
        }
        return $invoice;
    }

    public function createInvoice(string $player_uuid, string $payment_type): void
    {
        $stmt = $this->pdo->prepare(
            'INSERT INTO ' . DB_PREFIX . 'invoice (player_uuid, payment_type)
            VALUES (:player_uuid, :payment_type)');
        $stmt->bindParam(':player_uuid', $player_uuid);
        $stmt->bindParam(':payment_type', $payment_type);
        $stmt->execute();
 
        $invoice = $this->getPdo()->lastInsertId();
    }

    public function getPdo(): ?PDO
    {
        return $this->pdo;
    }

    public function setPdo(?PDO $pdo): void
    {
        $this->pdo = $pdo;
    }

    public function createInvoiceWithArticles(string $player_uuid, string $payment_type, array $articles): void
    {
        $stmt = $this->pdo->prepare(
            'INSERT INTO ' . DB_PREFIX . 'invoice (player_uuid, payment_type)
        VALUES (:player_uuid, :payment_type)'
        );
        $stmt->bindParam(':player_uuid', $player_uuid);
        $stmt->bindParam(':payment_type', $payment_type);
        $stmt->execute();
 
        $invoiceId = $this->pdo->lastInsertId();
 
        $stmt = $this->pdo->prepare(
            'INSERT INTO ' . DB_PREFIX . 'invoice_row (invoice_id, article_id) VALUES (:invoice_id, :article_id)'
        );
        foreach ($articles as $article) {
            $stmt->bindParam(':invoice_id', $invoiceId);
            $stmt->bindParam(':article_id', $article);
            $stmt->execute();
        }
    }
 
}