/**
* Internal method to fetch the next row from the result set
*
* @return array|null
*/
protected function getNextRow()
{
# If the result resource is invalid then don't bother trying to fetch
if (!$this->result) {
return;
}
switch ($this->mode) {
case "mysql":
$row = $this->result->fetch_assoc();
break;
case "postgres":
case "redshift":
$row = pg_fetch_assoc($this->result);
break;
case "odbc":
$row = odbc_fetch_array($this->result, $this->position + 1);
break;
case "sqlite":
$row = $this->result->fetchArray(SQLITE3_ASSOC);
break;
case "mssql":
$row = mssql_fetch_assoc($this->result);
break;
}
# If the fetch fails then there are no rows left to retrieve
if (!$row) {
return;
}
$this->position++;
return $row;
}
public function query($sql)
{
$rs = odbc_exec($this->dbConnection(), $sql);
if (is_resource($rs)) {
while ($result[] = odbc_fetch_array($rs)) {
}
odbc_free_result($rs);
$this->close();
return $result;
} else {
$this->halt('Database query error', $sql);
}
}
function ImportData($objOdbc, $objMySql, $strTableName)
{
global $objMySql;
$objMySql->query("TRUNCATE `" . strtolower($strTableName) . '`;');
$objResult = odbc_exec($objOdbc, "SELECT * FROM " . $strTableName . ";");
print "Migrating " . odbc_num_rows($objResult) . " rows of data for " . $strTableName . "... [0]";
$intCount = 0;
while ($arrResult = odbc_fetch_array($objResult)) {
print str_repeat(chr(8), strlen($intCount) + 1);
$intCount++;
print $intCount . ']';
$strColumns = 'pkid';
$strValues = 'NULL';
foreach ($arrResult as $strKey => $strValue) {
$strColumns .= ', `' . strtolower($strKey) . '`';
if (strlen($strValue)) {
$strValues .= ", '" . $objMySql->escape_string($strValue) . "'";
} else {
$strValues .= ', NULL';
}
}
$strSql = sprintf('INSERT INTO `%s` VALUES (%s);', strtolower($strTableName), $strValues);
$objMySql->query($strSql);
}
print " Done.\r\n";
}
function fetch()
{
if ($this->rows = odbc_fetch_array($this->result)) {
return 1;
} else {
$this->err_no = -1;
$this->err_msg = "";
return 0;
}
}
/**
*
* @param type $query
* @param type $type
* @return type
*/
public function execute($query, $type = null)
{
$result = array();
switch ($this->db_engine) {
case "pgsql":
$resultado = pg_query($this->conn, $query);
while ($row = pg_fetch_row($resultado)) {
$result[] = $row;
}
pg_close($this->conn);
break;
case "mssql":
$resultado = odbc_exec($this->conn, $query);
while ($row = odbc_fetch_array($resultado)) {
$result[] = $row;
}
break;
case "mysql":
$result = array();
$resultado = mysql_query($query);
if (gettype($resultado) == "boolean") {
$result = $resultado;
} else {
while ($row = mysql_fetch_row($resultado)) {
$result[] = $row;
}
}
mysql_close($this->conn);
break;
}
return $result;
}
function db_fetch($oStmt)
{
if (function_exists(odbc_fetch_array)) {
return odbc_fetch_array($oStmt);
}
return odbc_fetch_array_hack($oStmt);
}
function doquery($query, $table, $fetch = false)
{
global $link, $debug, $ugamela_root_path;
@(include $ugamela_root_path . 'config.php');
if (!$link) {
$link = odbc_connect($dbsettings["server"], $dbsettings["user"], $dbsettings["pass"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error");
//message(mysql_error()."<br />$query","SQL Error");
odbc_select_db($dbsettings["name"]) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error");
}
// por el momento $query se mostrara
// pero luego solo se vera en modo debug
$sqlquery = odbc_exec($query, str_replace("{{table}}", $dbsettings["prefix"] . $table)) or $debug->error(odbc_error() . "<br />{$query}", "SQL Error");
//message(mysql_error()."<br />$query","SQL Error");
unset($dbsettings);
//se borra la array para liberar algo de memoria
global $numqueries, $debug;
//,$depurerwrote003;
$numqueries++;
//$depurerwrote003 .= ;
$debug->add("<tr><th>Query {$numqueries}: </th><th>{$query}</th><th>{$table}</th><th>{$fetch}</th></tr>");
if ($fetch) {
//hace el fetch y regresa $sqlrow
$sqlrow = odbc_fetch_array($sqlquery);
return $sqlrow;
} else {
//devuelve el $sqlquery ("sin fetch")
return $sqlquery;
}
}
function listadoProductosPorSO($CODIGOSO)
{
//realizamos la conexion mediante odbc
$conn = odbc_connect("cnx_sistemaBD", "ANDREA", "1234") or die(odbc_errormsg());
$consulta = "SELECT productos.CODIGOPRODUCTO, UPPER(productos.NOMBREPRODUCTO) As NOMBREPRODUCTO, \n productos.DESCRIPCIONPUB, productos.PRECIOPUBLICO, productos.CANTIDADDISPONIBLE, \n productos.TIPOPRODUCTO, productos.ESPECIFICACIONTEC, productos.VIDEO,\n FABRICANTES.NOMBREFABRICANTE , CATEGORIAS.NOMBRECATEGORIA\n FROM productos, fabricantes, categorias where \n productos.FABRICANTES_CODFABRICANTE =FABRICANTES.CODFABRICANTE \n and categorias.CODIGOCATEGORIA= productos.CATEGORIAS_CODIGOCATEGORIA AND productos.SISTEMAOP_CODIGOSO='" . $CODIGOSO . "'\n ORDER BY productos.NOMBREPRODUCTO";
//almacena el resultado de la consulta
$resultado = odbc_exec($conn, $consulta) or die(odbc_errormsg());
//exit($resultado);
// echo get_resource_type ( $resultado);
//crea variable de tipo array
$SO = array();
while ($row = odbc_fetch_array($resultado)) {
array_push($SO, $row);
//$SO = $row;
// echo $row['CODIGOPRODUCTO'];
//echo $row['DESCRIPCIONPUB'];
}
//return print_r($SO);
if (!json_encode($SO)) {
exit("problemas al imprimir con json_encode");
} else {
return json_encode($SO);
}
//cierra la conexion
odbc_close($conn);
}
function PegaData($banco)
{
$sql = "SELECT GETDATE() as data ;";
$result = mysql_query($sql, $conexao);
$dados = odbc_fetch_array($result);
return $dados['data'];
}
function _import_db()
{
//
$sql = 'SELECT *
FROM provedor
ORDER BY nit';
$result = $this->query($sql);
while ($row = odbc_fetch_array($result)) {
$this->p[] = $row;
}
odbc_free_result($result);
unset($row);
//
$sql = 'SELECT *
FROM constancia
ORDER BY exencion';
$result = $this->query($sql);
while ($row = odbc_fetch_array($result)) {
$this->e[] = $row;
}
odbc_free_result($result);
unset($row);
//
$sql = 'SELECT *
FROM factura
ORDER BY exencion, factura';
$result = $this->query($sql);
while ($row = odbc_fetch_array($result)) {
$this->f[] = $row;
}
odbc_free_result($result);
//
return;
}
function head_cus($customer_no)
{
$link = Fconectar();
if ($link) {
// Se define la consulta que va a ejecutarse, como en sql
$sql_datos_cus = "\n\t\t\t\t\tSELECT C.par_cus_no, C.cus_no, C.cus_name, V1.slspsn_name AS Vendedor, V2.slspsn_name AS Cobrador, C.ar_terms_cd \n\t\t\t\t\tFROM\n\t\t\t\t\tARCUSFIL_SQL AS C,\n\t\t\t\t\tARSLMFIL_SQL AS V1,\n\t\t\t\t\tARSLMFIL_SQL AS V2\n\t\t\t\t\tWHERE\n\t\t\t\t\tC.slspsn_no = V1.slspsn_no AND\n\t\t\t\t\tC.collector = V2.slspsn_no AND\n\t\t\t\t\tC.cus_no = '{$customer_no}'\n\t\t\t\t";
// Se ejecuta la consulta y se guardan los resultados
$results = odbc_exec($link, $sql_datos_cus) or die("Error en instruccion SQL {$sql_datos_cus}");
$existe = odbc_num_rows($results);
if ($existe) {
$registro = odbc_fetch_array($results);
$head_cus_no = $registro['cus_no'];
$head_cus_name = $registro['cus_name'];
$head_ar_terms_cd = $registro['ar_terms_cd'];
$head_slspsn_name = $registro['Vendedor'];
$head_collector = $registro['Cobrador'];
} else {
$mensaje = "No existen registros!";
}
} else {
Ferror("No se pudo establecer coneccion con la Base de Datos!");
}
// Se cierra la conexión
odbc_close($link);
echo "\n\t\t<div align='center'>\n\t\t<table width='40%' border='3' cellpadding='0' cellspacing='10' bordercolor='#DCF3A4' align='center'>\n\t\t\t<th colspan='2'>EDADES DE CARTERA POR CLIENTE (Datos hasta: " . date('d-m-Y') . ")</th>\t\n\t\t\t<tr>\n\t\t\t\t<td>Cliente:</td>\n\t\t\t\t<td>(" . number_format($head_cus_no, 0, '', '') . ") - {$head_cus_name}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Vendedor:</td>\n\t\t\t\t<td>{$head_slspsn_name}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Cobrador:</td>\n\t\t\t\t<td>{$head_collector}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td>Condición de Pago:</td>\n\t\t\t\t<td>{$head_ar_terms_cd}</td>\n\t\t\t</tr>\n\t\t\t<tr>\n\t\t\t\t<td colspan='2' align='center'>Generado: " . date('d-m-Y H:i:s') . "</td>\n\t\t\t</tr>\n\t\t</table>\n\t\t</div>\n\t\t";
}
public function fetchData($sql)
{
try {
$res = odbc_exec(self::connection(), $sql);
//execute sql query using db connection
/*var_dump($res);*/
if (!$res) {
throw new Exception('odbc error code: ' . odbc_error() . '\\n sql query: ' . $sql);
}
$arrReturn = array();
//define array to collect channel data
//echo odbc_num_rows($res);
while ($data = odbc_fetch_array($res)) {
// check for all records returned
$arrReturn[] = $data;
//fetch data into return array from db resultset
}
self::closeConnection();
// close db connection
return $arrReturn;
//return array back
} catch (Exception $e) {
throw new Exception($e->getMessage());
}
}
public function setStartCode()
{
$query = 'SELECT TOP 1 MemberCardNo FROM POS_Member WHERE MemberCardNo LIKE \'T%\' ORDER BY Code DESC';
$res = Processor::execErp($query);
$member = odbc_fetch_array($res);
$this->code = getArrayVal($member, 'MemberCardNo');
return $this;
}
function to_array($res)
{
if ($array = odbc_fetch_array($res)) {
return $array;
} else {
return false;
}
}
public function Query($sql)
{
$rs = odbc_exec($this->db_link, $sql);
while ($row = odbc_fetch_array($rs)) {
$rows[] = $row;
}
return $rows;
}
function _odbc_num_rows($res)
{
$rows = 0;
while (odbc_fetch_array($res)) {
$rows++;
}
return $rows;
}
/** Returns a full list of tables in an array. */
function getTables(){
if ($this->getConn()){
$return = array();
if ($this->getType() == "mysql"){
$f_gt = $this->query("SHOW TABLE STATUS", $this->conn);
while($d_gt = $this->query_fetch_assoc($f_gt)){
$return[] = array(
"name" => $d_gt[Name],
"engine" => $d_gt[Engine],
"collation" => $d_gt[Collation],
"rows" => $d_gt[Rows]
);
}
return $return;
}elseif($this->getType() == "pgsql"){
$f_gt = $this->query("SELECT relname FROM pg_stat_user_tables ORDER BY relname");
while($d_gt = $this->query_fetch_assoc($f_gt)){
$return[] = array(
"name" => $d_gt[relname],
"engine" => "pgsql",
"collation" => "pgsql"
);
}
return $return;
}elseif($this->getType() == "sqlite" || $this->getType() == "sqlite3"){
$f_gt = $this->query("SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name");
while($d_gt = $this->query_fetch_assoc($f_gt)){
if ($d_gt["name"] != "sqlite_sequence"){
$return[] = array(
"name" => $d_gt[name],
"engine" => "sqlite",
"collation" => "sqlite"
);
}
}
return $return;
}elseif($this->getType() == "access"){
$f_gt = odbc_tables($this->conn);
while($d_gt = odbc_fetch_array($f_gt)){
if ($d_gt[TABLE_TYPE] == "TABLE"){
$return[] = array(
"name" => $d_gt[TABLE_NAME],
"engine" => "access",
"collation" => "access"
);
}
}
return $return;
}else{
throw new Exception("Not a valid type: " . $this->getType());
}
}
}
public function fetchAssoc($result)
{
if (!is_resource($result)) {
throw new DbControlException("Ilegal parameter result. Must be valid result resource.");
} else {
# odbc_fetch_array returns the same array like forexample mysql_fetch_assoc (array associated by colnames)
return $row = odbc_fetch_array($result);
}
}
public function clienteDebug()
{
$sth = odbc_exec($this->objOdbc, "SELECT CLIE, NOME, CGC FROM SIF01D WHERE CLIE = 1044");
while ($data[] = odbc_fetch_array($sth)) {
}
$this->Close();
array_pop($data);
return $data;
}
public static function fetchMightExistMembers($result)
{
$mightExistMembers = [];
$nameQuery = self::getNameQuery(self::getNameList($result));
if ($res = Processor::execErp($nameQuery)) {
while ($mightExistMembers[] = odbc_fetch_array($res)) {
}
}
return $mightExistMembers;
}
function validaCategoria($strID)
{
$con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n DATABASE=lotus;", "TSI", "SistemasInternet123");
$SQL = "select count(*) as 'QTD' from PRODUTO where IDPRODUTO = '" . $strID . "'";
$res = odbc_exec($con, $SQL);
$RFP = odbc_fetch_array($res);
if ($RFP['QTD'] >= 1) {
return 1;
} else {
return 0;
}
}
function VERICAUSUARIO($login)
{
$con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\t\t\tDATABASE=lotus;", "TSI", "SistemasInternet123");
$SQL = "SELECT COUNT(*) AS QTD FROM USUARIO WHERE LOGINUSUARIO = '" . $login . "'";
odbc_exec($con, $SQL);
$res = odbc_exec($con, $SQL);
$RFP = odbc_fetch_array($res);
if ($RFP['QTD'] >= 1) {
return 0;
} else {
return 1;
}
}
public function getRank()
{
$this->sql = "SELECT [GuildID] FROM [PS_GameData].[dbo].[Guilds] WHERE [Del] = 0\r\t\t\t\t\t ORDER BY [GuildPoint] DESC";
$this->res = odbc_exec($this->link, $this->sql);
$this->count = 1;
while ($this->fet = odbc_fetch_array($this->res)) {
if ($this->fet['GuildID'] == $this->gid) {
break;
}
$this->count++;
}
return $this->count;
}
function odbc_fila($sql, $fila)
{
$cnn_odbc = odbc_connect("ctw", "", "");
$rs = odbc_exec($cnn_odbc, $sql);
$value = "NO_EXISTE";
$value = odbc_fetch_array($rs, 1);
odbc_free_result($rs);
odbc_close($cnn_odbc);
//if(!$rs){
// return odbc_error($rs);
//} else {
return $value[$fila];
//}
}
function ccb_odbc_utility_fetch_array($result)
{
$finalArray;
$ti = 0;
$temp;
while (1) {
$temp = odbc_fetch_array($result);
if ($temp == false) {
break;
}
$finalArray[$ti] = $temp;
$ti = $ti + 1;
}
return $finalArray;
}
function VerificaUsuario()
{
$con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\t\tDATABASE=lotus;", "TSI", "SistemasInternet123");
$SQL = "select count(*) AS RESULTADO from usuario where LoginUsuario ='" . $_GET['nome'] . "' and senhaUsuario = '" . $_GET['pass'] . "'";
$res = odbc_exec($con, $SQL);
while ($RFP = odbc_fetch_array($res)) {
if ($RFP['RESULTADO'] >= 1) {
print '<script>alert("Bem Vindo");</script>';
sucess();
} else {
print '<script>alert("Usuario nao encontrado");</script>';
nonSucess();
}
}
}
public function count()
{
if ($res = odbc_num_rows($this->result) == -1) {
$res = 0;
$tmp = $this->numrow;
$this->moveFirst();
while ($this->next()) {
$res++;
}
$this->numrow = $tmp;
odbc_fetch_array($this->result, $tmp);
return $res;
} else {
return $res;
}
}
function db_fetch_assoc($res)
{
switch (DATABASE) {
case 'mysql':
return mysql_fetch_assoc($res);
case 'mysqli':
return mysqli_fetch_assoc($res);
case 'sqlserver':
return odbc_fetch_array($res);
}
}
function fetch_array($resource_array)
{
global $db_connection_type;
switch ($db_connection_type) {
case "odbc":
$result = odbc_fetch_array($resource_array);
break;
case "mysql":
$result = mysql_fetch_array($resource_array);
}
return $result;
}
function verificaIntegridade2($idProduto)
{
$con = odbc_connect("DRIVER={SQL Server}; SERVER=i9yueekhr9.database.windows.net;\n\t\tDATABASE=lotus;", "TSI", "SistemasInternet123");
$SQL = "select count(*) as QTD from itempedido where idProduto =" . $idProduto;
odbc_exec($con, $SQL);
$res = odbc_exec($con, $SQL);
$RFP = odbc_fetch_array($res);
if ($RFP['QTD'] >= 1) {
return false;
} else {
return true;
}
}
