404

D7net
:/ var / www / html / crsys / adm / vendor / api /
Filename : lerOrcamentoOS.php
back
<?php
include_once "ConectaPdo.php";
//var_dump($pdo->getAttribute(PDO::ATTR_EMULATE_PREPARES));
//exit;

$id_usu   = $_GET['usuario_id'] ?? '';
$empr_id  = $_GET['empr_id'] ?? '';
try {
//===============================
//   CONSULTA PRINCIPAL

$sql = "select c.num_contrato,
                c.orca_id,
                c.obra_id,
                c.num_revisao,
                c.obra nome_obra,
                s.nome nome_status,
                cr.cor cor_status
         FROM gre_cab_orcamento c
         INNER JOIN gre_status s ON s.id = c.status_id
         INNER JOIN adms_cors cr ON cr.id = s.cor_id
         where c.empr_id = :empr_id
         and c.status_id in (10,11)
         and c.medidor_id is not null
         AND EXISTS ( SELECT 1
                     FROM gre_agenda ag
                     WHERE ag.empr_id = c.empr_id
                       AND ag.orca_id = c.orca_id
                       AND ag.num_revisao = c.num_revisao
                       AND ag.sit_fase_id <> 1
                 )
         order by c.num_contrato";


$params = [
    ':empr_id' => $empr_id
];

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

$stmt->execute();

    $dados = [];
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $dados[] = [
            "num_contrato" => $row['num_contrato'],
            "orca_id" => $row['orca_id'],
            "num_revisao" => $row['num_revisao'],
            "obra_id" => $row['obra_id'],
            "nome_obra" => $row['nome_obra'],
            "status" => $row['nome_status'],
            "cor" => $row['cor_status']
        ];
    }

    echo json_encode($dados, JSON_UNESCAPED_UNICODE);

} catch (PDOException $e) {
    echo json_encode([
        "erro" => "Falha na consulta: " . $e->getMessage()
    ]);
} catch (Exception $e) {
    echo json_encode([
        "erro" => $e->getMessage()
    ]);
}