One Hat Cyber Team

Your IP : 216.73.216.36

Server IP : 162.240.179.46

Server : Linux vps-14493116.nutrivittasaude.com.br 5.14.0-611.49.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Apr 21 16:39:08 EDT 2026 x86_64

Server Software : Apache

PHP Version : 8.2.31

Buat File | Buat Folder

View File Name : servicos_site.php

<?php
require_once __DIR__ . '/../config/database.php';
header('Content-Type: application/json; charset=utf-8');

$empresaId = (int)($_GET['empresa_id'] ?? 0);
$profissionalId = (int)($_GET['profissional_id'] ?? 0);

if (!$empresaId) {
    echo json_encode([]);
    exit;
}

if ($profissionalId) {
    $stmt = $pdo->prepare("SELECT s.id, s.nome, s.descricao, s.preco, s.duracao, s.foto FROM servicos s JOIN servicos_profissionais sp ON s.id = sp.servico_id WHERE s.empresa_id = ? AND sp.profissional_id = ? AND s.ativo = 1 AND s.mostrar_site = 1 ORDER BY s.nome");
    $stmt->execute([$empresaId, $profissionalId]);
} else {
    $stmt = $pdo->prepare("SELECT id, nome, descricao, preco, duracao, foto FROM servicos WHERE empresa_id = ? AND ativo = 1 AND mostrar_site = 1 ORDER BY nome");
    $stmt->execute([$empresaId]);
}

echo json_encode($stmt->fetchAll());