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; }
/** * Creates a new OracleSelectQueryResult object. * Creates a new OracleSelectQueryResult object. * @access public * @param integer $resourceId The resource id for this SELECT query. * @param integer $linkId The link identifier for the database connection. * @return object OracleSelectQueryResult A new OracleSelectQueryResult object. */ function OracleSelectQueryResult($resourceId, $linkId) { // ** parameter validation $resourceRule = ResourceValidatorRule::getRule(); ArgumentValidator::validate($resourceId, $resourceRule, true); ArgumentValidator::validate($linkId, $resourceRule, true); // ** end of parameter validation $this->_resourceId = $resourceId; $this->_linkId = $linkId; $this->_currentRowIndex = 0; $this->_currentRow = array(); $this->_currentRow[BOTH] = array(); $this->_currentRow[NUMERIC] = array(); $this->_currentRow[ASSOC] = array(); $this->_numRows = ocifetchstatement($this->_resourceId); ociexecute($this->_resourceId); // if we have at least one row in the result, fetch its array if ($this->hasMoreRows()) { ocifetchinto($this->_resourceId, $this->_currentRow[BOTH], OCI_ASSOC + OCI_NUM + OCI_RETURN_LOBS); foreach ($this->_currentRow[BOTH] as $key => $value) { if (is_int($key)) { $this->_currentRow[NUMERIC][$key] = $value; } else { $this->_currentRow[ASSOC][$key] = $value; } } } }
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]; }
/** * Number of rows in the result set. * * Oracle doesn't have a graceful way to retun the number of rows * so we have to use what amounts to a hack. * * * @access public * @return integer */ function num_rows() { $rowcount = count($this->result_array()); @ociexecute($this->stmt_id); if ($this->curs_id) { @ociexecute($this->curs_id); } return $rowcount; }
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; }
/** * Number of rows in the result set. * * Oracle doesn't have a graceful way to retun the number of rows * so we have to use what amounts to a hack. * * * @access public * @return integer */ function num_rows() { if ($this->num_rows === 0 && count($this->result_array()) > 0) { $this->num_rows = count($this->result_array()); @ociexecute($this->stmt_id); if ($this->curs_id) { @ociexecute($this->curs_id); } } return $this->num_rows; }
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; }
public function batchProcess($batch_id, $username) { // $result = array(); $sql = " DECLARE " . " v_result VARCHAR2(90); " . " BEGIN " . " PKG_PROC_BATCH.proc_batch(:params1,:params2, :v_result); END;"; //$params = array($period, $username, $batch_type); $params = array(array('name' => ':params1', 'value' => $batch_id, 'type' => SQLT_CHR, 'length' => 100), array('name' => ':params2', 'value' => $username, 'type' => SQLT_CHR, 'length' => 32)); // Bind the output parameter $stmt = oci_parse($this->db->conn_id, $sql); foreach ($params as $p) { // Bind Input oci_bind_by_name($stmt, $p['name'], $p['value'], $p['length']); } $message = ''; oci_bind_by_name($stmt, ':v_result', $message, 32); ociexecute($stmt); return $message; }
function query_oracle($sql) { $db = get_oracle_db(); if (!$db) { return false; } $r = oci_parse($db, $sql); if ($r === false) { return false; } $qresult = ociexecute($r); if ($qresutl === false) { return false; } //var_dump(oci_fetch_array($r)); //oci_fetch_all($r, $result); return oci_fetch_array($r); return $result; }
function db_query($ASql, $AQueryType = 0) { global $conn; $ASql = "/*" . $_SERVER['REMOTE_ADDR'] . ", " . $_SERVER['SCRIPT_FILENAME'] . ", " . date('d.m.Y H:i', time()) . "*/" . $ASql; $result = oci_parse($conn, $ASql); $return = array(); ociexecute($result, OCI_DEFAULT); switch ($AQueryType) { case 0: $return = oci_fetch_array($result, OCI_ASSOC); break; case 1: while ($row = oci_fetch_array($result, OCI_ASSOC)) { $return[] = $row; } break; } return $return; }
<?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()); } } }
/** * 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; } }
$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" CONTENT="0; URL=">';
/** * Execute the query * * @access private called by the base class * @param string an SQL query * @return resource */ function _execute($sql) { // oracle must parse the query before it is run. All of the actions with // the query are based on the statement id returned by ociparse $this->_set_stmt_id($sql); ocisetprefetch($this->stmt_id, 1000); return @ociexecute($this->stmt_id, $this->_commit); }
@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>"; for ($j = 1; $j <= @ocinumcols($stat); $j++) {
margin-bottom:1.5em } footer p{ clear:left; margin-bottom:0 } </style> </head> <body> <?php include "mod/nav.php"; include "config/connect.php"; include "func/sitac.logic.list.php"; include "func/sitac.logic.var.php"; $sql = OCIParse($connect, "SELECT ID,WITEL,ID_SITE,NAMA_SITE,ALAMAT,STATUS_SITAC,MITRA_AP,STATUS_DATA,KET_STATUS_SITAC,ID_WS" . " FROM " . $table . " WHERE " . $witel . " AND (" . $jenis . ")" . "ORDER BY PRIORITAS"); ociexecute($sql); ?> <div class="container"> <h3 align="center"><strong>DETIL DATA <?php echo $detail; ?> <br> SITAC - WITEL <?php echo strtoupper($_GET['witel']); ?> </strong></h3><br /> <div class="panel panel-default"> <div class="panel-body"> <div class="row"> <?php if (!empty($_GET['status_update'])) { $alert = "<div id =\"error\" class=\"col-md-12\"><div class=\"form-group\"><div class=\"alert alert-dismissable alert-success\" style=\"background-color: green;\">\n <button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button>\n <strong>SUKSES!</strong> DATA BERHASIL DIUPDATE !\n </div></div></div>";
/** * 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; }
<?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 $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>"; }
/** * Number of rows in the result set * * @access public * @return integer */ function num_rows() { // get the results, count them, // rerun query - otherwise we // won't have data after calling // num_rows() $this->result_array(); $rowcount = count($this->result_array); @ociexecute($this->stmt_id); if ($this->curs_id) { @ociexecute($this->curs_id); } return $rowcount; }
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 . "' "; $result3 = mysql_db_query($basedatos, $sSQL3);
<?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()); } } }
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; }
<?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($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; }