<?php

declare(strict_types=1);

namespace App\Models;

use App\Database;
use PDO;

final class User
{
    private PDO $db;

    public function __construct()
    {
        $this->db = Database::connection();
    }

    public function list(): array
    {
        $stmt = $this->db->query('SELECT id, name, email, role, active, created_at FROM users ORDER BY id DESC');
        return $stmt->fetchAll();
    }

    public function save(array $data): bool
    {
        if (!empty($data['id'])) {
            $sql = 'UPDATE users SET name=:name, email=:email, role=:role, active=:active WHERE id=:id';
            return $this->db->prepare($sql)->execute([
                'id' => (int) $data['id'],
                'name' => $data['name'],
                'email' => $data['email'],
                'role' => $data['role'],
                'active' => (int) ($data['active'] ?? 1),
            ]);
        }

        $sql = 'INSERT INTO users (name, email, role, active, created_at) VALUES (:name, :email, :role, :active, NOW())';
        return $this->db->prepare($sql)->execute([
            'name' => $data['name'],
            'email' => $data['email'],
            'role' => $data['role'],
            'active' => (int) ($data['active'] ?? 1),
        ]);
    }
}