function getBalanceForUser($link, $user_id, $givenuser)
{
global $psqlschema, $serverid;
$return = array();
$balanacesjsondec = getAllBalances();
$mybal = $balanacesjsondec[$givenuser];
if ($mybal) {
$return['bal'] = isset($mybal["balance"]) ? $mybal["balance"] : 0;
$return['ec'] = isset($mybal["credit"]) ? $mybal["credit"] : 0;
$return['everpaid'] = isset($mybal["everpaid"]) ? $mybal["everpaid"] : 0;
$return['lbal'] = isset($mybal["included_balance_estimate"]) ? $return['bal'] - $mybal["included_balance_estimate"] : $return['bal'];
$return['lec'] = isset($mybal["included_credit_estimate"]) ? $return['ec'] - $mybal["included_credit_estimate"] : $return['ec'];
$return['datadate'] = $mybal["newest"];
$return['balupdate'] = $mybal["last_balance_update"];
} else {
# fall back to sql
$sql = "select * from {$psqlschema}.stats_balances where server={$serverid} and user_id={$user_id} order by time desc limit 1";
$result = pg_exec($link, $sql);
$numrows = pg_numrows($result);
if (!$numrows) {
$return['bal'] = "N/A";
$return['ec'] = "N/A";
$return['lbal'] = "N/A";
$return['datadate'] = "N/A";
} else {
$row = pg_fetch_array($result, 0);
$return['bal'] = $row["balance"];
$return['ec'] = $row["credit"];
$return['lbal'] = "N/A";
$return['datadate'] = $row["time"];
$return['everpaid'] = $row["everpaid"];
}
}
return $return;
}
function open($database, $host, $user, $password)
{
$connect_string = "";
if (!$database) {
return 0;
}
$host = split(":", $host);
if ($host[0]) {
$connect_string .= "host={$host['0']}";
}
if (isset($host[1])) {
$connect_string .= " port={$host['1']}";
}
if ($user) {
$connect_string .= " user={$user} ";
}
if ($password) {
$connect_string .= " password={$password} ";
}
$connect_string .= " dbname={$database}";
$this->connect_id = @pg_Connect($connect_string);
if ($this->connect_id) {
@pg_exec($this->connect_id, "SET DateStyle TO 'ISO'");
}
return $this->connect_id;
}
function my_handler($sql_insert)
{
global $table, $link, $new_name;
$sql_insert = ereg_replace($table, $new_name, $sql_insert);
$result = pg_exec($link, pre_query($sql_insert)) or pg_die(pg_errormessage($link), $sql_insert, __FILE__, __LINE__);
$sql_query = $sql_insert;
}
function db_query($req)
{
// Fonction "surcouche" e mysql_query () qui ajoute la gestion d'erreur
global $type;
global $conn;
switch ($type) {
case "POSTGRESQL":
if ($sth = pg_exec($conn, $req)) {
return $sth;
} else {
echo pg_errormessage($conn);
error_req($req);
}
break;
case "MYSQL":
if ($sth = mysql_query("{$req}")) {
// la requete s'est bien passé
// affichage de la requete si le verbose est activé
return $sth;
} else {
// Erreur dans la requete, donc génération du mail.
echo mysql_error();
error_req($req);
}
}
}
function Fetch()
{
$sql = "\n\t\tSELECT DISTINCT\n\t\t\tcommit_log.commit_date - SystemTimeAdjust() AS commit_date_raw,\n\t\t\tcommit_log.id AS commit_log_id,\n\t\t\tcommit_log.encoding_losses AS encoding_losses,\n\t\t\tcommit_log.message_id AS message_id,\n\t\t\tcommit_log.committer AS committer,\n\t\t\tcommit_log.description AS commit_description,\n\t\t\tto_char(commit_log.commit_date - SystemTimeAdjust(), 'DD Mon YYYY') AS commit_date,\n\t\t\tto_char(commit_log.commit_date - SystemTimeAdjust(), 'HH24:MI') AS commit_time,\n\t\t\tNULL AS port_id,\n\t\t\tNULL AS category,\n\t\t\tNULL AS category_id,\n\t\t\tNULL AS port,\n\t\t\telement_pathname(element.id) AS pathname,\n\t\t\tNULL AS version,\n\t\t\tcommit_log_elements.revision_name AS revision,\n\t\t\tNULL AS epoch,\n\t\t\telement.status AS status,\n\t\t\tNULL AS needs_refresh,\n\t\t\tNULL AS forbidden,\n\t\t\tNULL AS broken,\n\t\t\tNULL AS deprecated,\n\t\t\tNULL AS ignore,\n\t\t\tNULL AS expiration_date,\n\t\t\tNULL AS date_added,\n\t\t\tNULL AS element_id,\n\t\t\tNULL AS short_description,\n\t\t\tNULL AS stf_message";
if ($this->UserID) {
$sql .= ",\n\t onwatchlist ";
}
$sql .= "\n FROM commit_log, commit_log_elements, element ";
if ($this->UserID) {
$sql .= "\n\t LEFT OUTER JOIN\n\t (SELECT element_id as wle_element_id, COUNT(watch_list_id) as onwatchlist\n\t FROM watch_list JOIN watch_list_element \n\t ON watch_list.id = watch_list_element.watch_list_id\n\t AND watch_list.user_id = " . $this->UserID . "\n\t AND watch_list.in_service\t\t\n\t GROUP BY wle_element_id) AS TEMP\n\t ON TEMP.wle_element_id = element.id";
}
$sql .= "\n\t WHERE commit_log.id IN (SELECT tmp.id FROM (SELECT DISTINCT CL.id, CL.commit_date\n FROM commit_log CL\n WHERE CL.committer = '" . pg_escape_string($this->Committer) . "'\nORDER BY CL.commit_date DESC ";
if ($this->Limit) {
$sql .= " LIMIT " . $this->Limit;
}
if ($this->Offset) {
$sql .= " OFFSET " . $this->Offset;
}
$sql .= ")as tmp)\n\t AND commit_log_elements.commit_log_id = commit_log.id\n\t AND commit_log_elements.element_id = element.id\n ORDER BY 1 desc,\n\t\t\tcommit_log_id";
if ($this->Debug) {
echo '<pre>' . $sql . '</pre>';
}
$this->LocalResult = pg_exec($this->dbh, $sql);
if ($this->LocalResult) {
$numrows = pg_numrows($this->LocalResult);
if ($this->Debug) {
echo "That would give us {$numrows} rows";
}
} else {
$numrows = -1;
echo 'pg_exec failed: ' . "<pre>{$sql}</pre>";
}
return $numrows;
}
function CreateDatabase()
{
global $dcl_domain_info, $dcl_domain;
$conn = @pg_connect(sprintf('dbname=template1 port=%s host=%s user=%s password=%s', $dcl_domain_info[$dcl_domain]['dbPort'], $dcl_domain_info[$dcl_domain]['dbHost'], $dcl_domain_info[$dcl_domain]['dbUser'], $dcl_domain_info[$dcl_domain]['dbPassword']));
$query = sprintf('CREATE DATABASE %s', $dcl_domain_info[$dcl_domain]['dbName']);
return pg_exec($conn, $query) > 0;
}
function CreateHTML()
{
global $freshports_CommitMsgMaxNumOfLinesToShow;
if (isset($this->Filter)) {
$sql = "select * from SanityTestFailures({$this->UserID}, '" . pg_escape_string($this->Filter) . "')";
} else {
$sql = "set client_encoding = 'ISO-8859-15';\nSELECT S.*, STF.message as stf_message\n FROM SanityTestFailures({$this->UserID}) S LEFT OUTER JOIN sanity_test_failures STF\n ON S.commit_log_id = STF.commit_log_id";
}
if ($this->MessageID != '') {
$sql .= " WHERE message_id = '" . pg_escape_string($this->MessageID) . "'";
}
$sql .= " ORDER BY S.commit_date_raw DESC, S.category, S.port";
if ($this->Debug) {
echo "\n<p>sql={$sql}</p>\n";
}
$result = pg_exec($this->dbh, $sql);
if (!$result) {
die("read from database failed");
exit;
}
$DisplayCommit = new DisplayCommit($this->dbh, $result);
$DisplayCommit->Debug = $this->Debug;
$DisplayCommit->SetDaysMarkedAsNew($this->DaysMarkedAsNew);
$DisplayCommit->SetUserID($this->UserID);
$DisplayCommit->SetWatchListAsk($this->WatchListAsk);
$DisplayCommit->SanityTestFailure = true;
$RetVal = $DisplayCommit->CreateHTML();
$this->HTML = $DisplayCommit->HTML;
return $RetVal;
}
function start_maint()
{
custom_db("cubit");
pg_exec("VACUUM");
pg_exec("VACUUM FULL");
pg_exec("VACUUM ANALYZE");
pg_exec("REINDEX DATABASE cubit");
$get_comps = "SELECT * FROM companies WHERE status = 'active'";
$run_comps = pg_exec($get_comps) or errDie("Unable to get active companies");
if (pg_numrows($run_comps) < 1) {
return "<li class='err'>No Active Companies Found To Process.</li>";
} else {
#process the blk1 db
custom_db("cubit_blk1");
pg_exec("VACUUM");
pg_exec("VACUUM FULL");
pg_exec("VACUUM ANALYZE");
pg_exec("REINDEX DATABASE cubit_blk1");
#process the active companies
while ($carr = pg_fetch_array($run_comps)) {
$company = "cubit_" . $carr['code'];
custom_db("{$company}");
pg_exec("VACUUM");
pg_exec("VACUUM FULL");
pg_exec("VACUUM ANALYZE");
pg_exec("REINDEX DATABASE {$company}");
}
}
$display = "\r\n\t\t<table " . TMPL_tblDflts . ">\r\n\t\t\t<tr>\r\n\t\t\t\t<td><li class='err'>Process Has Been Completed.</li></td>\r\n\t\t\t</tr>\r\n\t\t</table>";
return $display;
}
/**
* @throws SQLException
* @return void
*/
protected function initTables()
{
include_once 'creole/drivers/pgsql/metadata/PgSQLTableInfo.php';
// Get Database Version
$result = pg_exec($this->dblink, "SELECT version() as ver");
if (!$result) {
throw new SQLException("Failed to select database version");
}
// if (!$result)
$row = pg_fetch_assoc($result, 0);
$arrVersion = sscanf($row['ver'], '%*s %d.%d');
$version = sprintf("%d.%d", $arrVersion[0], $arrVersion[1]);
// Clean up
$arrVersion = null;
$row = null;
pg_free_result($result);
$result = null;
$result = pg_exec($this->dblink, "SELECT oid, relname FROM pg_class\n\t\t\t\t\t\t\t\t\t\tWHERE relkind = 'r' AND relnamespace = (SELECT oid\n\t\t\t\t\t\t\t\t\t\tFROM pg_namespace\n\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t nspname NOT IN ('information_schema','pg_catalog')\n\t\t\t\t\t\t\t\t\t\t AND nspname NOT LIKE 'pg_temp%'\n\t\t\t\t\t\t\t\t\t\t AND nspname NOT LIKE 'pg_toast%'\n\t\t\t\t\t\t\t\t\t\tLIMIT 1)\n\t\t\t\t\t\t\t\t\t\tORDER BY relname");
if (!$result) {
throw new SQLException("Could not list tables", pg_last_error($this->dblink));
}
while ($row = pg_fetch_assoc($result)) {
$this->tables[strtoupper($row['relname'])] = new PgSQLTableInfo($this, $row['relname'], $version, $row['oid']);
}
}
public function query($string = '')
{
if ($string != '') {
$this->query = $this->escape($string);
} else {
$this->query = $this->select . $this->insert . $this->update . $this->delete . $this->create . $this->from . $this->join . $this->where . $this->group . $this->order . $this->limit;
}
$this->insert = " RETURNING id";
$this->result = pg_exec($this->connection, $this->query);
$this->inserted_id = $this->result;
$this->error = pg_errormessage($this->connection);
$this->affected_rows = pg_affected_rows($this->result);
$this->select = '';
$this->insert = '';
$this->update = '';
$this->delete = '';
$this->create = '';
$this->from = '';
$this->join = '';
$this->where = '';
$this->group = '';
$this->order = '';
$this->limit = '';
return $this;
}
function write_details($_POST)
{
extract($_POST);
# validate input
require_lib("validate");
$v = new validate();
$v->isOk($branch_ip, "url", 1, 50, "Invalid Branch IP.");
$v->isOk($branch_company, "url", 4, 4, "Invalid Branch Company Code.");
$v->isOk($branch_username, "string", 1, 50, "Invalid Branch Username.");
// $v->isOk ($branch_password, "url", 1, 50, "Invalid Branch Password.");
// $v->isOk ($branch_passwordconfirm, "url", 1, 50, "Invalid Branch Password.");
// $v->isOk ($branch_ip, "url", 1, 50, "Invalid Branch IP.");
if ($branch_password != $branch_passwordconfirm) {
$v->addError($branch_password, "Passwords do not match.");
}
# display errors, if any
if ($v->isError()) {
$confirmCust = "";
$errors = $v->getErrors();
foreach ($errors as $e) {
$confirmCust .= "<li class='err'>" . $e["msg"] . "</li>";
}
return get_details($_POST, $confirmCust);
}
db_connect();
$add_sql = "\n\t\tINSERT INTO branches_data (\n\t\t\tbranch_name, branch_desc, branch_contact, branch_ip, \n\t\t\tdate_added, last_online, branch_username, branch_password, \n\t\t\tlast_login_from, branch_localuser, branch_company\n\t\t) VALUES (\n\t\t\t'{$branch_name}', '{$branch_desc}', '{$branch_contact}', '{$branch_ip}', \n\t\t\t'now', '1990-01-01', '{$branch_username}', md5('{$branch_password}'), \n\t\t\t'1990-01-01', '{$branch_localuser}', '{$branch_company}'\n\t\t)";
$run_add = pg_exec($add_sql) or errDie("Unable to add branch information.");
$display = "\n\t\t\t\t\t<table " . TMPL_tblDflts . ">\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t<th>Branch Added</th>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t\t<td>Branch Has Been Added.</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t</table>\n\t\t\t\t";
return $display;
}
function Fetch()
{
$sql = "set client_encoding = 'ISO-8859-15';\n\t\tSELECT DISTINCT\n\t\t\tCL.commit_date - SystemTimeAdjust() AS commit_date_raw,\n\t\t\tCL.id AS commit_log_id,\n\t\t\tCL.encoding_losses AS encoding_losses,\n\t\t\tCL.message_id AS message_id,\n\t\t\tCL.committer AS committer,\n\t\t\tCL.description AS commit_description,\n\t\t\tto_char(CL.commit_date - SystemTimeAdjust(), 'DD Mon YYYY') AS commit_date,\n\t\t\tto_char(CL.commit_date - SystemTimeAdjust(), 'HH24:MI') AS commit_time,\n\t\t\tCLP.port_id AS port_id,\n\t\t\tC.name AS category,\n\t\t\tC.id AS category_id,\n\t\t\tE.name AS port,\n\t\t\telement_pathname(E.id) AS pathname,\n\t\t\tCASE when CLP.port_version IS NULL then P.version else CLP.port_version END AS version,\n\t\t\tCASE when CLP.port_version is NULL then P.revision else CLP.port_revision END AS revision,\n\t\t\tCASE when CLP.port_epoch is NULL then P.portepoch else CLP.port_epoch END AS epoch,\n\t\t\tE.status AS status,\n\t\t\tCLP.needs_refresh AS needs_refresh,\n\t\t\tP.forbidden AS forbidden,\n\t\t\tP.broken AS broken,\n\t\t\tP.deprecated AS deprecated,\n\t\t\tP.ignore AS ignore,\n\t\t\tP.expiration_date AS expiration_date,\n\t\t\tdate_part('epoch', P.date_added) AS date_added,\n\t\t\tP.element_id AS element_id,\n\t\t\tP.short_description AS short_description,\n\t\t\tSTF.message AS stf_message";
if ($this->UserID) {
$sql .= ",\n\t onwatchlist ";
}
$sql .= "\n FROM commit_log_ports CLP JOIN (SELECT * FROM commit_log WHERE commit_log.committer = '" . pg_escape_string($this->Committer) . "' ORDER BY commit_date DESC ";
if ($this->Limit) {
$sql .= " LIMIT " . $this->Limit;
}
if ($this->Offset) {
$sql .= " OFFSET " . $this->Offset;
}
$sql .= ") CL on (CLP.commit_log_id = CL.id) \n LEFT OUTER JOIN sanity_test_failures STF ON STF.commit_log_id = CLP.commit_log_id, categories C, ports P, element E ";
if ($this->UserID) {
$sql .= "\n\t LEFT OUTER JOIN\n\t (SELECT element_id as wle_element_id, COUNT(watch_list_id) as onwatchlist\n\t FROM watch_list JOIN watch_list_element \n\t ON watch_list.id = watch_list_element.watch_list_id\n\t AND watch_list.user_id = " . $this->UserID . "\n\t AND watch_list.in_service\t\t\n\t GROUP BY wle_element_id) AS TEMP\n\t ON TEMP.wle_element_id = E.id";
}
$sql .= "\n\t WHERE CLP.port_id = P.id\n\t AND C.id = P.category_id\n\t AND E.id = P.element_id\n ORDER BY 1 desc,\n\t\t\tcommit_log_id,\n\t\t\tcategory,\n\t\t\tport";
if ($this->Debug) {
echo '<pre>' . $sql . '</pre>';
}
$this->LocalResult = pg_exec($this->dbh, $sql);
if ($this->LocalResult) {
$numrows = pg_numrows($this->LocalResult);
if ($this->Debug) {
echo "That would give us {$numrows} rows";
}
} else {
$numrows = -1;
echo 'pg_exec failed: ' . "<pre>{$sql}</pre>";
}
return $numrows;
}
function CreateHTML()
{
global $freshports_CommitMsgMaxNumOfLinesToShow;
if (isset($this->Filter)) {
$sql = "select * from LatestCommitsFiltered({$this->MaxNumberOfPorts}, {$this->UserID}, '" . pg_escape_string($this->Filter) . "')";
} else {
# $sql = "select * from LatestCommits($this->MaxNumberOfPorts, $this->UserID)";
$sql = "\n SELECT LC.*, STF.message AS stf_message\n FROM LatestCommits({$this->MaxNumberOfPorts}, 0, '" . pg_escape_string($this->BranchName) . "') LC LEFT OUTER JOIN sanity_test_failures STF\n ON LC.commit_log_id = STF.commit_log_id\nORDER BY LC.commit_date_raw DESC, LC.category, LC.port, element_pathname";
}
if ($this->Debug) {
echo "\n<p>sql={$sql}</p>\n";
}
$result = pg_exec($this->dbh, $sql);
if (!$result) {
die("read from database failed");
exit;
}
$DisplayCommit = new DisplayCommit($this->dbh, $result);
$DisplayCommit->Debug = $this->Debug;
$DisplayCommit->SetDaysMarkedAsNew($this->DaysMarkedAsNew);
$DisplayCommit->SetUserID($this->UserID);
$DisplayCommit->SetWatchListAsk($this->WatchListAsk);
$RetVal = $DisplayCommit->CreateHTML();
$this->HTML = $DisplayCommit->HTML;
return $RetVal;
}
public function excecute($sql)
{
if ($sql instanceof Query) {
$sql = $sql->getQuery($this->config->getType());
}
$this->last_query = $sql;
return pg_exec($this->connection, $sql);
}
function debitos_tipos_numcgm($numcgm)
{
$instit = db_getsession("DB_instit");
$sql = "select distinct t.k00_tipo,t.k00_descr,t.k00_marcado,b.k00_numcgm,t.k00_emrec,t.k00_agnum,t.k00_agpar\n from arrenumcgm b\n inner join arrecad a on b.k00_numpre = a.k00_numpre\n inner join arretipo t on t.k00_tipo = a.k00_tipo\n inner join arreinstit n on n.k00_numpre = a.k00_numpre\n where b.k00_numcgm = {$numcgm} and n.k00_instit = {$instit}";
// echo "<br> cgm = $sql <br> ";
$result = pg_exec($sql) or die("Sql : " . pg_ErrorMessage());
return pg_numrows($result) == 0 ? false : $result;
}
function pgquery($query)
{
$result = pg_exec($this->pgcon(), $query);
if (!$result) {
$this->mydie("Could not successfully run query ({$query}) from DB: " . pg_ErrorMessage());
}
return $result;
}
function set_privilege($sql_set_privilege)
{
global $link;
if (!($res = @pg_exec($link, $sql_set_privilege))) {
pg_die(pg_errormessage($link), $sql_set_privilege, __FILE__, __LINE__);
} else {
echo "<p>{$sql_set_privilege}</p>\n";
}
}
function larutaes($cod)
{
require "../conectar.php";
$sqleve = "SELECT origen, destino FROM ruta WHERE cod_ruta = {$cod}";
$stateve = pg_exec($dbh, $sqleve);
$datoeve = pg_fetch_assoc($stateve);
$tv = $datoeve[origen] . " - " . $datoeve[destino];
return $tv;
}
function query($query_strg)
{
$query_strg = eregi_replace("limit ([0-9]+),([ 0-9]+)", "limit \\2, \\1", $query_strg);
$this->result = pg_exec($this->conn_id, $query_strg);
if (!$this->result) {
$this->sql_error("Query Error");
}
return $this->result;
}
function elvehiculoes($num)
{
require "../conectar.php";
$sqleve = "SELECT tipo_vehiculo FROM tipo_vehiculo WHERE cod_tipo_vehiculo = {$num}";
$stateve = pg_exec($dbh, $sqleve);
$datoeve = pg_fetch_assoc($stateve);
$tv = $datoeve[tipo_vehiculo];
return $tv;
}
function Header()
{
global $conn;
global $result;
global $url;
//Dados da instituição
$dados = @pg_exec("select nomeinst,ender,munic,uf,telef,email,url,logo from db_config where codigo = " . @$GLOBALS["DB_instit"]);
$url = @pg_result($dados, 0, "url");
$this->SetXY(1, 1);
$this->Image('../imagens/files/' . pg_result($dados, 0, "logo"), 7, 3, 20);
//$this->Cell(100,32,"",1);
$nome = pg_result($dados, 0, "nomeinst");
global $nomeinst;
$nomeinst = pg_result($dados, 0, "nomeinst");
if (strlen($nome) > 42) {
$TamFonteNome = 8;
} else {
$TamFonteNome = 9;
}
$this->SetFont('Arial', 'BI', $TamFonteNome);
$this->Text(33, 9, $nome);
$this->SetFont('Arial', 'I', 8);
$this->Text(33, 14, trim(pg_result($dados, 0, "ender")));
$this->Text(33, 18, trim(pg_result($dados, 0, "munic")) . " - " . pg_result($dados, 0, "uf"));
$this->Text(33, 22, trim(pg_result($dados, 0, "telef")));
$this->Text(33, 26, trim(pg_result($dados, 0, "email")));
$this->Text(33, 30, $url);
//parametros
// $this->SetXY(108,3);
// $this->SetFillColor(235);
// $this->Cell(98,29,"",1,0,0,1);
// $this->Line(178,3,178,32);
// $this->Line(178,13,206,13);
// $this->Line(178,22,206,22);
// $this->Text(180,10,date("d-m-Y"));
// $this->Text(180,20,date("H:i:s"));
// $this->Text(180,30,@$GLOBALS["DB_login"]);
// $this->SetFont('Arial','',6);
// $this->Text(179,5,"Data:");
// $this->Text(179,15,"Hora:");
// $this->Text(179,24,"Login:"******"head1"]);
$this->Text($Espaco, 6, @$GLOBALS["head1"]);
$this->Text($Espaco, 9, @$GLOBALS["head2"]);
$this->Text($Espaco, 12, @$GLOBALS["head3"]);
$this->Text($Espaco, 15, @$GLOBALS["head4"]);
$this->Text($Espaco, 18, @$GLOBALS["head5"]);
$this->Text($Espaco, 21, @$GLOBALS["head6"]);
$this->Text($Espaco, 24, @$GLOBALS["head7"]);
$this->Text($Espaco, 27, @$GLOBALS["head8"]);
$this->Text($Espaco, 30, @$GLOBALS["head9"]);
//$this->Ln(25);
$this->SetY(35);
}
function elclientees($rut)
{
require "../conectar.php";
$sqleve = "SELECT nombre_cliente FROM cliente WHERE rut_cliente = '{$rut}'";
$stateve = pg_exec($dbh, $sqleve);
pg_close($dbh);
$datoeve = pg_fetch_assoc($stateve);
$tv = $datoeve[nombre_cliente];
return $tv;
}
function elresponsablees($cod)
{
require "../conectar.php";
$sqleve = "SELECT nombres, apellido1, apellido2 FROM personal WHERE rut_personal = '{$cod}'";
$stateve = pg_exec($dbh, $sqleve);
$datoeve = pg_fetch_assoc($stateve);
pg_close($dbh);
$tv = $datoeve[nombres] . " " . $datoeve[apellido1] . " " . $datoeve[apellido2];
return $tv;
}
function deleteJob($jobNo)
{
$dir = "/var/www/townguide/www/output/" . $jobNo;
echo "<p>deleteJob({$jobNo}) - directory {$dir}</p>";
$dbconn = pg_connect("host=localhost dbname=townguide user=www password=1234") or die('Could not connect: ' . pg_last_error());
$query = 'delete FROM queue where jobno=' . $jobNo;
$result = pg_exec($query) or die('Query failed: ' . pg_last_error());
deleteDirectory($dir);
echo "<p><a href='admin.php'>Return to Admin Page</a></p>\n";
}
public function execSimpleQuery($sql)
{
$this->connect();
if ($this->connection != null) {
$result = pg_exec($this->connection, $sql);
$this->disconnect();
return $result;
} else {
die("not connected to database!");
}
}
function pgexec($sql)
{
if ($res = pg_exec($this->conn, $sql)) {
pg_close($this->conn);
return $res;
} else {
//echo "No es posible ejecutar esta consulta: <br>";
//echo "$sql";
return false;
}
}
function FetchByMaster($MasterName)
{
$sql = "\nSELECT id AS slave_port_id,\n name AS slave_port_name,\n category_id AS slave_category_id,\n category AS slave_category_name\n FROM ports_active\n WHERE master_port = '" . pg_escape_string($MasterName) . "'\nORDER BY slave_category_name, slave_port_name";
#echo "sql = <pre>$sql</pre>";
$this->LocalResult = pg_exec($this->dbh, $sql);
if (!$this->LocalResult) {
echo pg_errormessage() . " {$sql}";
}
$numrows = pg_numrows($this->LocalResult);
return $numrows;
}
/**
* @throws SQLException
* @return void
*/
protected function initTables()
{
include_once 'creole/drivers/pgsql/metadata/PgSQLTableInfo.php';
$result = pg_exec($this->dblink, "SELECT tablename FROM pg_tables WHERE schemaname NOT IN ('information_schema','pg_catalog') ORDER BY 1");
if (!$result) {
throw new SQLException("Could not list tables", pg_last_error($this->dblink));
}
while ($row = pg_fetch_row($result)) {
$this->tables[strtoupper($row[0])] = new PgSQLTableInfo($this, $row[0]);
}
}
function Insert()
{
# delete the ignore entry for this commit/port combination
$sql = "\nINSERT INTO commit_log_ports_ignore (commit_log_id, port_id, reason)\n values ({$this->commit_log_id}, {$this->port_id}, '" . pg_escape_string($this->reason) . "')";
echo "\$sql='<pre>{$sql}</pre><br>\n";
$this->result = pg_exec($this->dbh, $sql);
if (!$this->result) {
echo pg_errormessage() . " {$sql}";
}
$numrows = pg_affected_rows($this->result);
return $numrows;
}
function pg_insert_id($tablename, $fieldname)
{
$result = pg_exec($this->_connectionID, "SELECT last_value FROM {$tablename}_{$fieldname}_seq");
if ($result) {
$arr = @pg_fetch_row($result, 0);
pg_freeresult($result);
if (isset($arr[0])) {
return $arr[0];
}
}
return false;
}