404

D7net
:/ var / www / html / crsys / adm / vendor / api /
Filename : excluir_rev_orca.php
back
<?php
header('Content-Type: application/json');

// Conexão com o banco de dados
include_once "ConectaPdo.php";

// Captura do ID enviado via POST
$id = $_GET['item'] ?? null;
$usuario_id = $_GET['usu_id'] ?? null;
$empr_id = $_GET['empr_id'] ?? null;
$orca_id = $_GET['orca_id'] ?? null;
$num_revisao = $_GET['num_revisao'] ?? null;

if ($id) {
    try {
        $sqlDelete = "DELETE FROM gre_item_orcamento WHERE id = :id";
        $stmtDelete = $pdo->prepare($sqlDelete);
        $stmtDelete->bindParam(':id', $id, PDO::PARAM_INT);
        $stmtDelete->execute();
        $sqlInsert = "insert into gre_item_orcamento
                      (select * from gre_item_trab it
                      WHERE it.id = :id)";
        $sqlInsert = $pdo->prepare($sqlInsert);
        $sqlInsert->bindParam(':id', $id, PDO::PARAM_INT);
        $sqlInsert->execute();        
        $sqlPegaFrete = "
            SELECT coalesce(vlr_frete,0) vlr_frete, 
                  coalesce(vlr_desc,0) vlr_desc
            FROM gre_cab_trab
            WHERE empr_id = :empr_id
              AND orca_id = :orca_id
              AND num_revisao = :num_revisao
        ";

        $stmtFrete = $pdo->prepare($sqlPegaFrete);

        $stmtFrete->execute([
            ':empr_id'     => $empr_id,
            ':orca_id'     => $orca_id,
            ':num_revisao' => $num_revisao
        ]);
        $resultFrete = $stmtFrete->fetch(PDO::FETCH_ASSOC);
        $vlr_frete = $resultFrete['vlr_frete'] ?? 0;
        $vlr_desc = $resultFrete['vlr_desc'] ?? 0;
        $sqlPegaVlrs = "
            select sum(base_total) vlr_base_total, 
                   sum(vlr_insumo) vlr_insumo,
                    sum(vlr_dife_item) vlr_dife_item,
               sum(vlr_total) vlr_total
            from gre_item_orcamento
            WHERE empr_id = :empr_id
              AND orca_id = :orca_id
              AND num_revisao = :num_revisao

        ";

        $stmtVlrs = $pdo->prepare($sqlPegaVlrs);

        $stmtVlrs->execute([
            ':empr_id'     => $empr_id,
            ':orca_id'     => $orca_id,
            ':num_revisao' => $num_revisao
        ]);
        $resultVlrs = $stmtVlrs->fetch(PDO::FETCH_ASSOC);
        $vlr_base_total = $resultVlrs['vlr_base_total'] ?? 0;
        $vlr_insumo = $resultVlrs['vlr_insumo'] ?? 0;
        $vlr_dife_item = $resultVlrs['vlr_dife_item'] ?? 0;
        $vlr_total = $resultVlrs['vlr_total'] ?? 0;
        $vlr_total = $vlr_total + $vlr_frete - $vlr_desc;
        $sqlUpdateCab = "
            UPDATE gre_cab_orcamento
            SET vlr_semdesc    = :vlr_semdesc,
                vlr_base_total = :vlr_base_total,
                vlr_insumo = :vlr_insumo,
                vlr_dife_revisao = :vlr_dife_item,
                vlr_total      = :vlr_total
            WHERE empr_id = :empr_id
              and orca_id = :orca_id
              AND num_revisao = :num_revisao
        ";
        $stmtUpdateCab = $pdo->prepare($sqlUpdateCab);
        $stmtUpdateCab->execute([
            ':vlr_semdesc'    => $vlr_base_total,
            ':vlr_base_total' => $vlr_base_total,
            ':vlr_insumo'      => $vlr_insumo,
            ':vlr_dife_item'      => $vlr_dife_item,
            ':vlr_total'      => $vlr_total,
            ':orca_id'        => $orca_id,
            ':num_revisao'    => $num_revisao,
            ':empr_id'    => $empr_id
                
        ]);
      echo json_encode([
    'status' => 'success',
    'mensagem' => 'Excluído com sucesso.'
]);
exit;  
    } catch (PDOException $e) {
        echo json_encode([
            'status' => 'error',
            'mensagem' => 'Erro ao excluir item: ' . $e->getMessage()
        ]);
    }
} else {
    echo json_encode([
        'status' => 'error',
        'mensagem' => 'ID do item não fornecido.'
    ]);
}