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

Dir : ~/home/lifeprimeti/meta.lifeprimeti.com.br/api/

View File Name : agendamentos.php

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

$empresaId = (int)($_GET['empresa_id'] ?? 1);

if (isset($_GET['id'])) {
    $id = (int)$_GET['id'];
    $stmt = $pdo->prepare("
        SELECT a.*, u.nome as cliente_nome, u2.nome as profissional_nome, s.nome as servico_nome, s.preco
        FROM agendamentos a
        JOIN usuarios u ON a.cliente_id = u.id
        JOIN profissionais p ON a.profissional_id = p.id
        JOIN usuarios u2 ON p.usuario_id = u2.id
        JOIN servicos s ON a.servico_id = s.id
        WHERE a.id = ? AND a.empresa_id = ?
    ");
    $stmt->execute([$id, $empresaId]);
    $a = $stmt->fetch();
    if ($a) {
        $a['data_formatada'] = formatarData($a['data']);
        $a['hora_formatada'] = formatarHora($a['hora']);
        $a['hora_fim_formatada'] = formatarHora($a['hora_fim']);
        $a['preco_formatado'] = formatarMoeda($a['preco']);
        $a['status_label'] = getStatusLabel($a['status']);
        unset($a['preco']);
    }
    echo json_encode($a ?: ['error' => 'Nao encontrado']);
    exit;
}

$start = $_GET['start'] ?? date('Y-m-01');
$end = $_GET['end'] ?? date('Y-m-t');
$profissionalId = (int)($_GET['profissional_id'] ?? 0);

$sql = "SELECT a.*, u.nome as cliente_nome, u2.nome as profissional_nome, s.nome as servico_nome, s.preco FROM agendamentos a JOIN usuarios u ON a.cliente_id = u.id JOIN profissionais p ON a.profissional_id = p.id JOIN usuarios u2 ON p.usuario_id = u2.id JOIN servicos s ON a.servico_id = s.id WHERE a.empresa_id = ? AND a.data BETWEEN ? AND ?";
$params = [$empresaId, $start, $end];

if ($profissionalId) {
    $sql .= " AND a.profissional_id = ?";
    $params[] = $profissionalId;
}

$stmt = $pdo->prepare($sql);
$stmt->execute($params);
$agendamentos = $stmt->fetchAll();

$eventos = [];
foreach ($agendamentos as $a) {
    $cores = [
        'pendente' => '#f59e0b',
        'confirmado' => '#10b981',
        'em_andamento' => '#3b82f6',
        'concluido' => '#6366f1',
        'cancelado' => '#ef4444',
    ];
    $eventos[] = [
        'id' => (string)$a['id'],
        'title' => $a['cliente_nome'] . ' - ' . $a['servico_nome'],
        'start' => $a['data'] . 'T' . $a['hora'],
        'end' => $a['data'] . 'T' . $a['hora_fim'],
        'backgroundColor' => $cores[$a['status']] ?? '#667eea',
        'borderColor' => 'transparent',
        'textColor' => '#fff',
        'extendedProps' => [
            'status' => $a['status'],
            'cliente' => $a['cliente_nome'],
            'profissional' => $a['profissional_nome'],
            'servico' => $a['servico_nome'],
            'valor' => formatarMoeda($a['preco']),
        ]
    ];
}

echo json_encode($eventos);