<?php
namespace App\Models;

class PageModel
{
    public static function getBySlug(string $slug, string $lang): array|false
    {
        return Database::fetchOne(
            'SELECT * FROM pages WHERE slug = :slug AND lang = :lang AND is_published = 1',
            [':slug' => $slug, ':lang' => $lang]
        );
    }

    public static function getAll(string $lang = 'fr'): array
    {
        return Database::fetchAll(
            'SELECT * FROM pages WHERE lang = :lang AND is_published = 1 ORDER BY sort_order',
            [':lang' => $lang]
        );
    }
}