Tul xxx Tul

Viewing: Plans.php

<?php

namespace App\Services;

use App\Storage\Database;
use PDO;

class Plans
{
    private static function connection(): PDO
    {
        return Database::connection();
    }

    public static function all(): array
    {
        $stmt = self::connection()->query('SELECT id, name, price, description, features, status FROM plans ORDER BY price ASC');
        return $stmt->fetchAll();
    }

    public static function active(): array
    {
        $stmt = self::connection()->query('SELECT id, name, price, description, features FROM plans WHERE status = 1 ORDER BY price ASC');
        return $stmt->fetchAll();
    }

    public static function find(int $id): ?array
    {
        $stmt = self::connection()->prepare('SELECT * FROM plans WHERE id = :id LIMIT 1');
        $stmt->execute(['id' => $id]);
        $plan = $stmt->fetch();

        return $plan !== false ? $plan : null;
    }

    public static function create(array $data): int
    {
        $stmt = self::connection()->prepare(
            'INSERT INTO plans (name, price, description, features, status) VALUES (:name, :price, :description, :features, :status)'
        );

        $stmt->execute([
            'name' => $data['name'],
            'price' => $data['price'],
            'description' => $data['description'] ?: null,
            'features' => $data['features'] ?: null,
            'status' => (int) $data['status'],
        ]);

        return (int) self::connection()->lastInsertId();
    }

    public static function update(int $id, array $data): bool
    {
        $stmt = self::connection()->prepare(
            'UPDATE plans SET name = :name, price = :price, description = :description, features = :features, status = :status WHERE id = :id'
        );

        return $stmt->execute([
            'id' => $id,
            'name' => $data['name'],
            'price' => $data['price'],
            'description' => $data['description'] ?: null,
            'features' => $data['features'] ?: null,
            'status' => (int) $data['status'],
        ]);
    }

    public static function delete(int $id): bool
    {
        $stmt = self::connection()->prepare('DELETE FROM plans WHERE id = :id');
        return $stmt->execute(['id' => $id]);
    }
}
User / IP	: 216.73.216.217
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64