Operação realizada com sucesso!";
} else {
pg_query($dbcon, 'rollback');
$erroDb = pg_last_error($dbcon);
$msg = "A operação não pode realizada!" . ($erroDb ? (" Erro: " . $erroDb) : "") . "";
}
} else if (isset($_POST["btRm"])) {
$servers = $_POST["listaServersInc"];
pg_query($dbcon, 'begin');
foreach ($servers as $id) {
$query = "delete from pbx_servers_sinc where server_id = '$id'";
$result = pg_query($dbcon, $query);
if (!$result)
break;
}
if ($result) {
pg_query($dbcon, 'commit');
$msg = "Operação realizada com sucesso!";
} else {
pg_query($dbcon, 'rollback');
$erroDb = pg_last_error($dbcon);
$msg = "A operação não pode realizada!" . ($erroDb ? (" Erro: " . $erroDb) : "") . "";
}
}
$servers = GetServerSinc($dbcon);
$serversInc = GetServerSincInc($dbcon);
$smarty->assign("servers", $servers);
$smarty->assign("serversInc", $serversInc);
GetTemplate($smarty, $nomeTpl);
function GetServerSinc($dbcon) {
$ipServer = trim(GetIpServer());
$query = "select id, descricao || '-' || host as descricao
from pbx_sites a
where trim(host) <> '127.0.0.1'
and upper(trim(host)) <> 'LOCALHOST'
and trim(host) <> '$ipServer'
and not exists(select '' from pbx_servers_sinc where server_id = a.id)
order by a.descricao";
$result = pg_query($dbcon, $query);
$select = "\n";
return $select;
}
function GetServerSincInc($dbcon) {
$query = " select id, descricao || '-' || host as descricao
from pbx_sites a
where exists(select '' from pbx_servers_sinc where server_id = a.id)
order by a.descricao";
$result = pg_query($dbcon, $query);
$select = "\n";
return $select;
}
?>