<?php

namespace App;

use PDO;
use PDOException;

class SignatureTemplateManager
{
    private $pdo;

    public function __construct()
    {
        $this->pdo = new PDO('sqlite:' . DB_PATH);
        $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    /**
     * Récupère toutes les signatures
     */
    public function getAllSignatures()
    {
        $stmt = $this->pdo->query("SELECT * FROM signatures ORDER BY created_at DESC");
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }

    /**
     * Récupère une signature par ID
     */
    public function getSignatureById($id)
    {
        $stmt = $this->pdo->prepare("SELECT * FROM signatures WHERE id = ?");
        $stmt->execute([$id]);
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }

    /**
     * Crée une nouvelle signature
     */
    public function createSignature($name, $content)
    {
        $stmt = $this->pdo->prepare("INSERT INTO signatures (name, content) VALUES (?, ?)");
        return $stmt->execute([$name, $content]);
    }

    /**
     * Met à jour une signature
     */
    public function updateSignature($id, $name, $content)
    {
        $stmt = $this->pdo->prepare("UPDATE signatures SET name = ?, content = ? WHERE id = ?");
        return $stmt->execute([$name, $content, $id]);
    }

    /**
     * Supprime une signature
     */
    public function deleteSignature($id)
    {
        $stmt = $this->pdo->prepare("DELETE FROM signatures WHERE id = ?");
        return $stmt->execute([$id]);
    }

    /**
     * Récupère tous les templates
     */
    public function getAllTemplates()
    {
        $stmt = $this->pdo->query("SELECT * FROM templates ORDER BY created_at DESC");
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }

    /**
     * Récupère un template par ID
     */
    public function getTemplateById($id)
    {
        $stmt = $this->pdo->prepare("SELECT * FROM templates WHERE id = ?");
        $stmt->execute([$id]);
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }

    /**
     * Crée un nouveau template
     */
    public function createTemplate($name, $content)
    {
        $stmt = $this->pdo->prepare("INSERT INTO templates (name, content) VALUES (?, ?)");
        return $stmt->execute([$name, $content]);
    }

    /**
     * Met à jour un template
     */
    public function updateTemplate($id, $name, $content)
    {
        $stmt = $this->pdo->prepare("UPDATE templates SET name = ?, content = ? WHERE id = ?");
        return $stmt->execute([$name, $content, $id]);
    }

    /**
     * Supprime un template
     */
    public function deleteTemplate($id)
    {
        $stmt = $this->pdo->prepare("DELETE FROM templates WHERE id = ?");
        return $stmt->execute([$id]);
    }
}
