Tul xxx Tul

Viewing: Service.php

<?php

declare(strict_types=1);

class Service extends Model
{
    public function getAll(string $status = 'all'): array
    {
        if (!$this->db instanceof PDO) {
            return [];
        }

        try {
            $sql = "SELECT * FROM services";
            $params = [];

            if ($status !== 'all') {
                $sql .= " WHERE status = :status";
                $params['status'] = $status;
            }

            $sql .= " ORDER BY sort_order ASC, created_at DESC";
            $statement = $this->db->prepare($sql);
            $statement->execute($params);

            return $statement->fetchAll() ?: [];
        } catch (PDOException $exception) {
            error_log('Error obteniendo Servicios: ' . $exception->getMessage());
            return [];
        }
    }

    public function findById(int $id): ?array
    {
        if (!$this->db instanceof PDO) {
            return null;
        }

        $statement = $this->db->prepare('SELECT * FROM services WHERE id = :id LIMIT 1');
        $statement->execute(['id' => $id]);
        $row = $statement->fetch();

        return $row ?: null;
    }

    public function create(array $data): ?int
    {
        if (!$this->db instanceof PDO) {
            return null;
        }

        $statement = $this->db->prepare(
            'INSERT INTO services (title, description, price, icon, sort_order, status)
             VALUES (:title, :description, :price, :icon, :sort_order, :status)'
        );

        $ok = $statement->execute([
            'title' => $data['title'],
            'description' => $data['description'],
            'price' => isset($data['price']) ? (float)$data['price'] : null,
            'icon' => $data['icon'] ?? 'fas fa-star',
            'sort_order' => (int) ($data['sort_order'] ?? 0),
            'status' => $data['status'] ?? 'active'
        ]);

        return $ok ? (int) $this->db->lastInsertId() : null;
    }

    public function update(int $id, array $data): bool
    {
        if (!$this->db instanceof PDO) {
            return false;
        }

        $statement = $this->db->prepare(
            'UPDATE services
             SET title = :title,
                 description = :description,
                 price = :price,
                 icon = :icon,
                 sort_order = :sort_order,
                 status = :status
             WHERE id = :id'
        );

        return $statement->execute([
            'id' => $id,
            'title' => $data['title'],
            'description' => $data['description'],
            'price' => isset($data['price']) ? (float)$data['price'] : null,
            'icon' => $data['icon'] ?? 'fas fa-star',
            'sort_order' => (int) ($data['sort_order'] ?? 0),
            'status' => $data['status'] ?? 'active'
        ]);
    }

    public function delete(int $id): bool
    {
        if (!$this->db instanceof PDO) {
            return false;
        }

        $statement = $this->db->prepare('DELETE FROM services WHERE id = :id');
        return $statement->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