/** * This is a callback function to display the result of each separate query * @param ADORecordSet $rs The recordset returned by the script execetor */ function sqlCallback($query, $rs, $lineno) { global $data, $misc, $lang, $_connection; // Check if $rs is false, if so then there was a fatal error if ($rs === false) { echo htmlspecialchars($_FILES['script']['name']), ':', $lineno, ': ', nl2br(htmlspecialchars($_connection->getLastError())), "<br/>\n"; } else { // Print query results switch (pg_result_status($rs)) { case PGSQL_TUPLES_OK: // If rows returned, then display the results $num_fields = pg_numfields($rs); echo "<p><table>\n<tr>"; for ($k = 0; $k < $num_fields; $k++) { echo "<th class=\"data\">", $misc->printVal(pg_fieldname($rs, $k)), "</th>"; } $i = 0; $row = pg_fetch_row($rs); while ($row !== false) { $id = $i % 2 == 0 ? '1' : '2'; echo "<tr class=\"data{$id}\">\n"; foreach ($row as $k => $v) { echo "<td style=\"white-space:nowrap;\">", $misc->printVal($v, pg_fieldtype($rs, $k), array('null' => true)), "</td>"; } echo "</tr>\n"; $row = pg_fetch_row($rs); $i++; } echo "</table><br/>\n"; echo $i, " {$lang['strrows']}</p>\n"; break; case PGSQL_COMMAND_OK: // If we have the command completion tag if (version_compare(phpversion(), '4.3', '>=')) { echo htmlspecialchars(pg_result_status($rs, PGSQL_STATUS_STRING)), "<br/>\n"; } elseif ($data->conn->Affected_Rows() > 0) { echo $data->conn->Affected_Rows(), " {$lang['strrowsaff']}<br/>\n"; } // Otherwise output nothing... break; case PGSQL_EMPTY_QUERY: break; default: break; } } }
function IsTimestamp($vField) { // FIXME // substr because it could be timestamp or timestamptz return $this->res > 0 && substr(pg_fieldtype($this->res, $vField), 0, 9) == 'timestamp'; }
function field_type($result, $int) { $fieldtype = pg_fieldtype($result, $int); #echo $fieldtype.", ".$fieldlen."<br>"; #if ( strstr($fieldtype, "char") ) $fieldtype = "string"; #if ( $fieldtype == "text" ) $fieldtype = "blob"; return $fieldtype; }
function sql_fieldtype($offset, $query_id = 0) { if (!$query_id) { $query_id = $this->query_result; } return $query_id ? @pg_fieldtype($query_id, $offset) : false; }
/** * Returns information about a table or a result set * * NOTE: doesn't support table name and flags if called from a db_result * * @param mixed $resource PostgreSQL result identifier or table name * @param int $mode A valid tableInfo mode (DB_TABLEINFO_ORDERTABLE or * DB_TABLEINFO_ORDER) * * @return array An array with all the information */ function tableInfo($result, $mode = null) { $count = 0; $id = 0; $res = array(); /* * depending on $mode, metadata returns the following values: * * - mode is false (default): * $result[]: * [0]["table"] table name * [0]["name"] field name * [0]["type"] field type * [0]["len"] field length * [0]["flags"] field flags * * - mode is DB_TABLEINFO_ORDER * $result[]: * ["num_fields"] number of metadata records * [0]["table"] table name * [0]["name"] field name * [0]["type"] field type * [0]["len"] field length * [0]["flags"] field flags * ["order"][field name] index of field named "field name" * The last one is used, if you have a field name, but no index. * Test: if (isset($result['meta']['myfield'])) { ... * * - mode is DB_TABLEINFO_ORDERTABLE * the same as above. but additionally * ["ordertable"][table name][field name] index of field * named "field name" * * this is, because if you have fields from different * tables with the same field name * they override each * other with DB_TABLEINFO_ORDER * * you can combine DB_TABLEINFO_ORDER and * DB_TABLEINFO_ORDERTABLE with DB_TABLEINFO_ORDER | * DB_TABLEINFO_ORDERTABLE * or with DB_TABLEINFO_FULL */ // if $result is a string, then we want information about a // table without a resultset if (is_string($result)) { $id = pg_exec($this->connection, "SELECT * FROM {$result}"); if (empty($id)) { return $this->pgsqlRaiseError(); } } else { // else we want information about a resultset $id = $result; if (empty($id)) { return $this->pgsqlRaiseError(); } } $count = @pg_numfields($id); // made this IF due to performance (one if is faster than $count if's) if (empty($mode)) { for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = is_string($result) ? $result : ''; $res[$i]['name'] = @pg_fieldname($id, $i); $res[$i]['type'] = @pg_fieldtype($id, $i); $res[$i]['len'] = @pg_fieldsize($id, $i); $res[$i]['flags'] = is_string($result) ? $this->_pgFieldflags($id, $i, $result) : ''; } } else { // full $res["num_fields"] = $count; for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = is_string($result) ? $result : ''; $res[$i]['name'] = @pg_fieldname($id, $i); $res[$i]['type'] = @pg_fieldtype($id, $i); $res[$i]['len'] = @pg_fieldsize($id, $i); $res[$i]['flags'] = is_string($result) ? $this->_pgFieldFlags($id, $i, $result) : ''; if ($mode & DB_TABLEINFO_ORDER) { $res['order'][$res[$i]['name']] = $i; } if ($mode & DB_TABLEINFO_ORDERTABLE) { $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i; } } } // free the result only if we were called on a table if (is_resource($id)) { @pg_freeresult($id); } return $res; }
/** * Get the type of the specified field * * @param $lhandle (string) Query result set handle * @param $fnumber (int) Column number */ function db_field_type($lhandle, $fnumber) { return @pg_fieldtype($lhandle, $fnumber); }
function vty_field_type($list,$i){ switch($this->vtAdi){ case 'mysql': return mysql_field_type($list,$i); break; case 'odbc': return odbc_field_type($list,$i); break; case 'mssql': return mssql_field_type($list,$i); break; case 'postgresql': pg_fieldtype($list,$i); break; } }
/** * Returns information about a table or a result set. * * NOTE: only supports 'table' and 'flags' if <var>$result</var> * is a table name. * * @param object|string $result DB_result object from a query or a * string containing the name of a table * @param int $mode a valid tableInfo mode * @return array an associative array with the information requested * or an error object if something is wrong * @access public * @internal * @see DB_common::tableInfo() */ function tableInfo($result, $mode = null) { if (isset($result->result)) { /* * Probably received a result object. * Extract the result resource identifier. */ $id = $result->result; $got_string = false; } elseif (is_string($result)) { /* * Probably received a table name. * Create a result resource identifier. */ $id = @pg_exec($this->connection, "SELECT * FROM {$result} LIMIT 0"); $got_string = true; } else { /* * Probably received a result resource identifier. * Copy it. * Deprecated. Here for compatibility only. */ $id = $result; $got_string = false; } if (!is_resource($id)) { return $this->pgsqlRaiseError(DB_ERROR_NEED_MORE_DATA); } if ($this->options['portability'] & DB_PORTABILITY_LOWERCASE) { $case_func = 'strtolower'; } else { $case_func = 'strval'; } $count = @pg_numfields($id); // made this IF due to performance (one if is faster than $count if's) if (!$mode) { for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = $got_string ? $case_func($result) : ''; $res[$i]['name'] = $case_func(@pg_fieldname($id, $i)); $res[$i]['type'] = @pg_fieldtype($id, $i); $res[$i]['len'] = @pg_fieldsize($id, $i); $res[$i]['flags'] = $got_string ? $this->_pgFieldflags($id, $i, $result) : ''; } } else { // full $res['num_fields'] = $count; for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = $got_string ? $case_func($result) : ''; $res[$i]['name'] = $case_func(@pg_fieldname($id, $i)); $res[$i]['type'] = @pg_fieldtype($id, $i); $res[$i]['len'] = @pg_fieldsize($id, $i); $res[$i]['flags'] = $got_string ? $this->_pgFieldFlags($id, $i, $result) : ''; if ($mode & DB_TABLEINFO_ORDER) { $res['order'][$res[$i]['name']] = $i; } if ($mode & DB_TABLEINFO_ORDERTABLE) { $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i; } } } // free the result only if we were called on a table if ($got_string) { @pg_freeresult($id); } return $res; }
<?php include 'config.inc'; $db = pg_connect($conn_str); $result = pg_exec("SELECT * FROM " . $table_name); pg_numrows($result); pg_numfields($result); pg_fieldname($result, 0); pg_fieldsize($result, 0); pg_fieldtype($result, 0); pg_fieldprtlen($result, 0); pg_fieldisnull($result, 0); pg_result($result, 0, 0); $result = pg_exec("INSERT INTO " . $table_name . " VALUES (7777, 'KKK')"); $oid = pg_getlastoid($result); pg_freeresult($result); pg_errormessage(); $result = pg_exec("UPDATE " . $table_name . " SET str = 'QQQ' WHERE str like 'RGD';"); pg_cmdtuples($result); echo "OK";
function db_lovrot($query, $numlinhas, $arquivo = "", $filtro = "%", $aonde = "_self", $campos_layer = "", $NomeForm = "NoMe", $variaveis_repassa = array(), $automatico = true, $totalizacao = array()) { //Observação : Quando utilizar o parametro automatico, coloque no parametro NomeForm o seguinte "NoMe" e em variaveis_repassa array(). //#00#//db_lovrot //#10#//Esta funcao é utilizada para mostrar registros na tela, podendo páginar os dados //#15#//db_lovrot($query,$numlinhas,$arquivo="",$filtro="%",$aonde="_self",$campos_layer="",$NomeForm="NoMe",$variaveis_repassa=array()); //#20#//$query Select que será executado //#20#//$numlinhas Número de linhas a serem mostradas //#20#//$arquivo Arquivo que será executado quando der um click em uma linha //#20#// Na versão com iframe deverá ser colocado "()" //#20#//$filtro Filtro que será gerado, normamente "" //#20#//$aonde Nome da função que será executada quando der um click //#20#//$campos_layer Campos que serão colocados na layer quando passar o mouse ( não esta implementado ) //#20#//$NomeForm Nome do formulário para colocar variáveis complementares Padrão = "NoMe" //#20#//$variaveis_repassa Array com as variáveis a serem reoassadas para o programa //#99#//Exemplo: //#99#//$js_funcao = ""; //#99#//db_lovrot("select z01_nome from cgm limit 1","()","",$js_funcao); //#99#// //#99#//O cabeçalho da tabela o sistema pega pelo nome do campo e busca na documentação, colcando o label //#99#//Quando não desejar colocar o label da documentacao, o nome do campo deverá ser iniciado com dl_ e o sistema retirará //#99#//estes caracteres e colocará o primeiro caracter em maiusculo //#99#//Criado parametro novo, $totalizacao = array() que devere fornecer os campos que desejar fazer somatorio, conforme //#99#//exemplo abaixo: //#99#// //#99#//$totalizacao["e60_vlremp"] = "e60_vlremp"; totaliza o campo //#99#//$totalizacao["e60_vlranu"] = "e60_vlranu"; totaliza o campo //#99#//$totalizacao["e60_vlrpag"] = "e60_vlrpag"; totaliza o campo //#99#//$totalizacao["e60_vlrliq"] = "e60_vlrliq"; totaliza o campo //#99#//$totalizacao["dl_saldo"] = "dl_saldo"; totaliza o campo ( neste caso, o campo é um alias no sql) //#99#//$totalizacao["totalgeral"] = "z01_nome"; indica qual o campo sera colocado o total global $BrowSe; //cor do cabecalho global $db_corcabec; $db_corcabec = $db_corcabec == "" ? "#CDCDFF" : $db_corcabec; //cor de fundo de cada registro global $cor1; global $cor2; $cor1 = $GLOBALS['w01_corfundomenu']; $cor2 = $GLOBALS['w01_corfundomenuativo']; $mensagem = "Clique Aqui"; $cor1 = $cor1 == "" ? "#97B5E6" : $cor1; $cor2 = $cor2 == "" ? "#E796A4" : $cor2; global $HTTP_POST_VARS; $tot_registros = "tot_registros" . $NomeForm; $offset = "offset" . $NomeForm; //recebe os valores do campo hidden if (isset($HTTP_POST_VARS["totreg" . $NomeForm])) { ${$tot_registros} = $HTTP_POST_VARS["totreg" . $NomeForm]; } else { ${$tot_registros} = 0; } if (isset($HTTP_POST_VARS["offset" . $NomeForm])) { ${$offset} = $HTTP_POST_VARS["offset" . $NomeForm]; } else { ${$offset} = 0; } if (isset($HTTP_POST_VARS["recomecar"])) { $recomecar = $HTTP_POST_VARS["recomecar"]; } // se for a primeira vez que é rodado, pega o total de registros e guarda no campo hidden if (empty(${$tot_registros}) && !empty($query) || isset($recomecar)) { if (isset($recomecar)) { $query = db_getsession("dblov_query_inicial"); } $Dd1 = "disabled"; if (count($totalizacao) > 0 || isset($totalizacao_rep)) { $total_campos = ""; $sep_total_campos = ""; reset($totalizacao); for ($j = 0; $j < count($totalizacao); $j++) { if (key($totalizacao) == $totalizacao[key($totalizacao)]) { $total_campos .= $sep_total_campos . "sum(" . $totalizacao[key($totalizacao)] . ") as " . $totalizacao[key($totalizacao)]; $sep_total_campos = ","; } next($totalizacao); } reset($totalizacao); $tot = db_query("select count(*),{$total_campos}\n\tfrom ({$query}) as temp"); } else { $tot = db_query("select count(*) from ({$query}) as temp"); } //$tot = 0; db_putsession("dblov_query_inicial", $query); ${$tot_registros} = pg_result($tot, 0, 0); if (${$tot_registros} == 0) { $Dd2 = "disabled"; } } if (isset($HTTP_POST_VARS["nova_quantidade_linhas"]) && $HTTP_POST_VARS["nova_quantidade_linhas"] != '') { $HTTP_POST_VARS["nova_quantidade_linhas"] = $HTTP_POST_VARS["nova_quantidade_linhas"] + 0; $numlinhas = $HTTP_POST_VARS["nova_quantidade_linhas"]; } // testa qual botao foi pressionado if (isset($HTTP_POST_VARS["pri" . $NomeForm])) { ${$offset} = 0; $Dd1 = "disabled"; $query = str_replace("\\", "", $HTTP_POST_VARS["filtroquery"]); } else { if (isset($HTTP_POST_VARS["ant" . $NomeForm])) { // if(isset("filtroquery"]); $query = str_replace("\\", "", @$HTTP_POST_VARS["filtroquery"]); if (${$offset} <= $numlinhas) { ${$offset} = 0; $Dd1 = "disabled"; } else { ${$offset} = ${$offset} - $numlinhas; } } else { if (isset($HTTP_POST_VARS["prox" . $NomeForm])) { $query = str_replace("\\", "", $HTTP_POST_VARS["filtroquery"]); // if($numlinhas >= ($$tot_registros - $$offset - $numlinhas)) { if (${$offset} + $numlinhas * 2 >= ${$tot_registros}) { $Dd2 = "disabled"; } if ($numlinhas >= ${$tot_registros} - ${$offset}) { //$$offset = $$tot_registros - $numlinhas; if (${$tot_registros} - ${$offset} - $numlinhas >= $numlinhas) { ${$offset} = $numlinhas; } else { ${$offset} = ${$offset} + $numlinhas; } if (${$offset} > ${$tot_registros}) { ${$offset} = 0; } $Dd2 = "disabled"; } else { ${$offset} = ${$offset} + $numlinhas; } } else { if (isset($HTTP_POST_VARS["ult" . $NomeForm])) { $query = str_replace("\\", "", $HTTP_POST_VARS["filtroquery"]); ${$offset} = ${$tot_registros} - $numlinhas; if (${$offset} < 0) { ${$offset} = 0; } $Dd2 = "disabled"; } else { reset($HTTP_POST_VARS); for ($i = 0; $i < sizeof($HTTP_POST_VARS); $i++) { $ordem_lov = substr(key($HTTP_POST_VARS), 0, 11); if ($ordem_lov == 'ordem_dblov') { $query = str_replace("\\", "", $HTTP_POST_VARS["filtroquery"]); $campo = substr(key($HTTP_POST_VARS), 11); $ordem_ordenacao = ''; if (isset($HTTP_POST_VARS['ordem_lov_anterior'])) { if ($HTTP_POST_VARS['ordem_lov_anterior'] == $HTTP_POST_VARS[key($HTTP_POST_VARS)]) { $ordem_ordenacao = 'desc'; } } if ($HTTP_POST_VARS["codigo_pesquisa"] != '') { $query_anterior = $query; $query_novo_filtro = "select * from (" . $query . ") as x where " . $campo . " ILIKE '" . $HTTP_POST_VARS["codigo_pesquisa"] . "%' order by " . $campo . ' ' . $ordem_ordenacao; $query = $query_novo_filtro; } else { if ($HTTP_POST_VARS["distinct_pesquisa"] == '1') { $query_anterior = $query; $query = "select distinct on (" . $campo . ") * from (" . $query . ") as x order by " . $campo . " " . $ordem_ordenacao; $query_novo_filtro = $query; } else { $query = "select * from (" . $query . ") as x order by " . $campo . " " . $ordem_ordenacao; } } ${$offset} = 0; break; } next($HTTP_POST_VARS); } } } } } $filtroquery = $query; // executa a query e cria a tabela if ($query == "") { exit; } $query .= " limit {$numlinhas} offset " . ${$offset}; $result = db_query($query); $NumRows = pg_numrows($result); if ($NumRows == 0) { if (isset($query_anterior)) { echo "<script>alert('Não existem dados para este filtro');</script>"; if (count($totalizacao) > 0 || isset($totalizacao_rep)) { $total_campos = ""; $sep_total_campos = ""; reset($totalizacao); for ($j = 0; $j < count($totalizacao); $j++) { if (key($totalizacao) == $totalizacao[key($totalizacao)]) { $total_campos .= $sep_total_campos . "sum(" . $totalizacao[key($totalizacao)] . ") as " . $totalizacao[key($totalizacao)]; $sep_total_campos = ","; } next($totalizacao); } reset($totalizacao); $tot = db_query("select count(*),{$total_campos}\n from ({$query_anterior}) as temp"); } else { $tot = db_query("select count(*) from ({$query_anterior}) as temp"); } //$tot = 0; ${$tot_registros} = pg_result($tot, 0, 0); ${$tot_registros} = pg_result($tot, 0, 0); $query = $query_anterior . " limit {$numlinhas} offset " . ${$offset}; $result = db_query($query); $NumRows = pg_numrows($result); $filtroquery = $query_anterior; } } else { if (isset($query_anterior)) { $Dd1 = "disabled"; if (count($totalizacao) > 0 || isset($totalizacao_rep)) { $total_campos = ""; $sep_total_campos = ""; reset($totalizacao); for ($j = 0; $j < count($totalizacao); $j++) { if (key($totalizacao) == $totalizacao[key($totalizacao)]) { $total_campos .= $sep_total_campos . "sum(" . $totalizacao[key($totalizacao)] . ") as " . $totalizacao[key($totalizacao)]; $sep_total_campos = ","; } next($totalizacao); } reset($totalizacao); $tot = db_query("select count(*),{$total_campos}\n\t\t\t\t\tfrom ({$query_novo_filtro}) as temp"); } else { $tot = db_query("select count(*) from ({$query_novo_filtro}) as temp"); } //$tot = 0; ${$tot_registros} = pg_result($tot, 0, 0); if (${$tot_registros} == 0) { $Dd2 = "disabled"; } } } // echo "<script>alert('$NumRows')</script>"; $NumFields = pg_numfields($result); if ($NumRows < $numlinhas && $numlinhas < ${$tot_registros} - ${$offset} - $numlinhas) { $Dd1 = @($Dd2 = "disabled"); } echo "<script>\n\t\tfunction js_mostra_text(liga,nomediv,evt){\n\n\t\t\tevt = (evt)?evt:(window.event)?window.event:'';\n\t\t\tif(liga==true){\n\n\t\t\tdocument.getElementById(nomediv).style.top = 0; //evt.clientY;\n\t\t\tdocument.getElementById(nomediv).style.left = 0; //(evt.clientX+20);\n\t\t\tdocument.getElementById(nomediv).style.visibility = 'visible';\n\t\t\t}else\n document.getElementById(nomediv).style.visibility = 'hidden';\n\t\t\t}\n\t\t\tfunction js_troca_ordem(nomeform,campo,valor){\n\t\t\tobj=document.createElement('input');\n\t\t\t\tobj.setAttribute('name',campo);\n\t\t\t\tobj.setAttribute('type','submit');\n\t\t\t\tobj.setAttribute('value',valor);\n\t\t\t\tobj.setAttribute('style','color:#FCA;background-color:transparent;border-style:none');\n\t\t\t\t\teval('document.'+nomeform+'.appendChild(obj)');\n\t\t\t\teval('document.'+nomeform+'.'+campo+'.click()');\n\t\t\t}\n\t\t\t\tfunction js_lanca_codigo_pesquisa(valor_recebido){\n\t\t\t\tdocument.navega_lov" . $NomeForm . ".codigo_pesquisa.value = valor_recebido;\n\t\t\t}\n\t\t\tfunction js_lanca_distinct_pesquisa(){\n\t\t\tdocument.navega_lov" . $NomeForm . ".distinct_pesquisa.value = 1;\n\t\t\t}\n\t\t\tfunction js_nova_quantidade_linhas(valor_recebido){\n\t\t\tvalor_recebe = Number(valor_recebido);\n if(!valor_recebe){\n\t\t\talert('Valor Inválido!');\n\t\t\tdocument.navega_lov" . $NomeForm . ".nova_quantidade_linhas.value = '';\n document.getElementById('quant_lista').value = '';\n\t\t}else{\n\t\tif(valor_recebe > 100){\n\t\t\tdocument.navega_lov" . $NomeForm . ".nova_quantidade_linhas.value = '100';\n\t\t\tdocument.getElementById('quant_lista').value = 100;\n\t\t}else{\n\t\t\tdocument.navega_lov" . $NomeForm . ".nova_quantidade_linhas.value = valor_recebido;\n\t\t}\n\t\t}\n\t\t}\n\t\t</script>"; echo "<table id=\"TabDbLov\" border=\"1\" cellspacing=\"1\" cellpadding=\"0\" class=\"lov\">\n"; /**** botoes de navegacao ********/ echo "<tr><td colspan=\"" . ($NumFields + 1) . "\" nowrap> <form name=\"navega_lov" . $NomeForm . "\" method=\"post\">\n\t <input type=\"submit\" name=\"pri" . $NomeForm . "\" value=\"Início\" " . @$Dd1 . " class=\"botao\">\n\t <input type=\"submit\" name=\"ant" . $NomeForm . "\" value=\"Anterior\" " . @$Dd1 . " class=\"botao\">\n\t <input type=\"submit\" name=\"prox" . $NomeForm . "\" value=\"Próximo\" " . @$Dd2 . " class=\"botao\">\n\t <input type=\"submit\" name=\"ult" . $NomeForm . "\" value=\"Último\" " . @$Dd2 . " class=\"botao\">\n\t\t\t<input type=\"hidden\" name=\"offset" . $NomeForm . "\" value=\"" . @${$offset} . "\">\n\t\t\t<input type=\"hidden\" name=\"totreg" . $NomeForm . "\" value=\"" . @${$tot_registros} . "\">\n\t\t\t<input type=\"hidden\" name=\"codigo_pesquisa\" value=\"\">\n\n\t\t\t<input type=\"hidden\" name=\"distinct_pesquisa\" value=\"\">\n\n\t\t\t<input type=\"hidden\" name=\"filtro\" value=\"{$filtro}\">\n"; reset($variaveis_repassa); if (sizeof($variaveis_repassa) > 0) { for ($varrep = 0; $varrep < sizeof($variaveis_repassa); $varrep++) { echo "<input type=\"hidden\" name=\"" . key($variaveis_repassa) . "\" value=\"" . $variaveis_repassa[key($variaveis_repassa)] . "\">\n"; next($variaveis_repassa); } } if (isset($ordem_lov) && (isset($ordem_ordenacao) && $ordem_ordenacao == '')) { echo "<input type=\"hidden\" name=\"ordem_lov_anterior\" value=\"" . $HTTP_POST_VARS[key($HTTP_POST_VARS)] . "\">\n"; } if (isset($HTTP_POST_VARS['nova_quantidade_linhas']) && $HTTP_POST_VARS['nova_quantidade_linhas'] == '') { $numlinhas = $HTTP_POST_VARS['nova_quantidade_linhas']; } echo "<input type=\"hidden\" name=\"nova_quantidade_linhas\" value=\"{$numlinhas}\" >\n"; if (isset($totalizacao) && isset($tot)) { if (count($totalizacao) > 0) { $totNumfields = pg_numfields($tot); for ($totrep = 1; $totrep < $totNumfields; $totrep++) { echo "<input type=\"hidden\" name=\"totrep_" . pg_fieldname($tot, $totrep) . "\" value=\"" . db_formatar(pg_result($tot, 0, $totrep), 'f') . "\">"; } reset($totalizacao); $totrepreg = ""; $totregsep = ""; for ($totrep = 0; $totrep < count($totalizacao); $totrep++) { $totrepreg .= $totregsep . key($totalizacao) . "=" . $totalizacao[key($totalizacao)]; $totregsep = "|"; next($totalizacao); } reset($totalizacao); echo "<input type=\"hidden\" name=\"totalizacao_repas\" value=\"" . $totrepreg . "\">"; } } else { if (isset($HTTP_POST_VARS["totalizacao_repas"])) { $totalizacao_split = split("\\|", $HTTP_POST_VARS["totalizacao_repas"]); for ($totrep = 0; $totrep < count($totalizacao_split); $totrep++) { $totalizacao_sep = split("\\=", $totalizacao_split[$totrep]); $totalizacao[$totalizacao_sep[0]] = $totalizacao_sep[1]; if (isset($HTTP_POST_VARS["totrep_" . $totalizacao_sep[0]])) { echo "<input type=\"hidden\" name=\"totrep_" . $totalizacao_sep[0] . "\" value=\"" . $HTTP_POST_VARS["totrep_" . $totalizacao_sep[0]] . "\">"; } } echo "<input type=\"hidden\" name=\"totalizacao_repas\" value=\"" . $HTTP_POST_VARS["totalizacao_repas"] . "\">"; } } echo "<input type=\"hidden\" name=\"filtroquery\" value=\"" . str_replace("\n", "", @$filtroquery) . "\">\n " . ($NumRows > 0 ? "\n Foram retornados <font color=\"red\"><strong>" . ${$tot_registros} . "</strong></font> registros.\n\t\tMostrando de <font color=\"red\"><strong>" . (@${$offset} + 1) . "</strong></font> até\n <font color=\"red\"><strong>" . (${$tot_registros} < @${$offset} + $numlinhas ? $NumRows <= $numlinhas ? ${$tot_registros} : $NumRows : ${$offset} + $numlinhas) . "</strong></font>." : "Nenhum Registro\n\t\tRetornado") . "</form>\n </td></tr>\n"; /*********************************/ /***** Escreve o cabecalho *******/ if ($NumRows > 0) { echo "<tr>\n"; // implamentacao de informacoes complementares // echo "<td title='Outras Informações'>OI</td>\n"; //se foi passado funcao if ($campos_layer != "") { $campo_layerexe = split("\\|", $campos_layer); echo "<td nowrap bgcolor=\"{$db_corcabec}\" title=\"Executa Procedimento Específico.\" align=\"center\">Clique</td>\n"; } $clrotulocab = new rotulolov(); for ($i = 0; $i < $NumFields; $i++) { if (strlen(strstr(pg_fieldname($result, $i), "db_")) == 0) { $clrotulocab->label(pg_fieldname($result, $i)); //echo "<td nowrap bgcolor=\"$db_corcabec\" title=\"".$clrotulocab->title."\" align=\"center\"><b><u>".$clrotulocab->titulo."</u></b></td>\n"; echo "<td nowrap bgcolor=\"{$db_corcabec}\" title=\"" . $clrotulocab->title . "\" align=\"center\"><input name=\"" . pg_fieldname($result, $i) . "\" value=\"" . ucfirst($clrotulocab->titulo) . "\" type=\"button\" onclick=\"js_troca_ordem('navega_lov" . $NomeForm . "','ordem_dblov" . pg_fieldname($result, $i) . "','" . pg_fieldname($result, $i) . "');\" style=\"text-decoration:underline;background-color:transparent;border-style:none\"> </td>\n"; } else { if (strlen(strstr(pg_fieldname($result, $i), "db_m_")) != 0) { echo "<td nowrap bgcolor=\"{$db_corcabec}\" title=\"" . substr(pg_fieldname($result, $i), 5) . "\" align=\"center\"><b><u>" . substr(pg_fieldname($result, $i), 5) . "</u></b></td>\n"; } } } echo "</tr>\n"; } //cria nome da funcao com parametros if ($arquivo == "()") { $arrayFuncao = split("\\|", $aonde); $quantidadeItemsArrayFuncao = sizeof($arrayFuncao); } /********************************/ /****** escreve o corpo *******/ for ($i = 0; $i < $NumRows; $i++) { echo '<tr >' . "\n"; // implamentacao de informacoes complementares // echo '<td onMouseOver="document.getElementById(\'div'.$i.'\').style.visibility=\'visible\';" onMouseOut="document.getElementById(\'div'.$i.'\').style.visibility=\'hidden\';" >-></td>'."\n"; if ($arquivo == "()") { $loop = ""; $caracter = ""; if ($quantidadeItemsArrayFuncao > 1) { for ($cont = 1; $cont < $quantidadeItemsArrayFuncao; $cont++) { if (strlen($arrayFuncao[$cont]) > 3) { for ($luup = 0; $luup < pg_NumFields($result); $luup++) { if (pg_FieldName($result, $luup) == "db_" . $arrayFuncao[$cont]) { $arrayFuncao[$cont] = "db_" . $arrayFuncao[$cont]; } } } $loop .= $caracter . "'" . addslashes(str_replace('"', '', @pg_result($result, $i, strlen($arrayFuncao[$cont]) < 4 ? (int) $arrayFuncao[$cont] : $arrayFuncao[$cont]))) . "'"; //$loop .= $caracter."'".pg_result($result,$i,(int)$arrayFuncao[$cont])."'"; $caracter = ","; } $resultadoRetorno = $arrayFuncao[0] . "(" . $loop . ")"; } else { $resultadoRetorno = $arrayFuncao[0] . "()"; } } /* if($NumRows==1){ if($arquivo!=""){ echo "<td>$resultadoRetorno<td>"; exit; }else{ echo "<script>JanBrowse = window.open('".$arquivo."?".base64_encode("retorno=".($BrowSe==1?0:trim(pg_result($result,0,0))))."','$aonde','width=800,height=600');</script>"; exit; } } */ if (isset($cor)) { $cor = $cor == $cor1 ? $cor2 : $cor1; } else { $cor = $cor1; } // implamentacao de informacoes complementares // $mostradiv=""; if ($campos_layer != "") { $campo_layerexe = split("\\|", $campos_layer); echo "<td id=\"funcao_aux" . $i . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a href=\"\" onclick=\"" . $campo_layerexe[1] . "({$loop});return false\" ><strong>" . $campo_layerexe[0] . " </strong></a></td>\n"; } for ($j = 0; $j < $NumFields; $j++) { if (strlen(strstr(pg_fieldname($result, $j), "db_")) == 0 || strlen(strstr(pg_fieldname($result, $j), "db_m_")) != 0) { if (pg_fieldtype($result, $j) == "date") { if (pg_result($result, $i, $j) != "") { $matriz_data = split("-", pg_result($result, $i, $j)); $var_data = $matriz_data[2] . "/" . $matriz_data[1] . "/" . $matriz_data[0]; } else { $var_data = "//"; } echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim($var_data) . "</a>" : trim($var_data)) . " </td>\n"; } else { if (pg_fieldtype($result, $j) == "float8" || pg_fieldtype($result, $j) == "float4") { $var_data = db_formatar(pg_result($result, $i, $j), 'f', ' '); echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000\" bgcolor=\"{$cor}\" align=right nowrap>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim($var_data) . "</a>" : trim($var_data)) . " </td>\n"; } else { if (pg_fieldtype($result, $j) == "bool") { $var_data = pg_result($result, $i, $j) == 'f' || pg_result($result, $i, $j) == '' ? 'Não' : 'Sim'; echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;align:right\" bgcolor=\"{$cor}\" nowrap>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim($var_data) . "</a>" : trim($var_data)) . " </td>\n"; } else { if (pg_fieldtype($result, $j) == "text") { $var_data = substr(pg_result($result, $i, $j), 0, 10) . "..."; echo "<td onMouseOver=\"js_mostra_text(true,'div_text_" . $i . "_" . $j . "',event);\" onMouseOut=\"js_mostra_text(false,'div_text_" . $i . "_" . $j . "',event)\" id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;align:right\" bgcolor=\"{$cor}\" nowrap>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim($var_data) . "</a>" : trim($var_data)) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'j01_matric') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Imóvel' onclick=\"js_JanelaAutomatica('iptubase','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'm80_codigo') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Lançamento' onclick=\"js_JanelaAutomatica('matestoqueini','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'm40_codigo') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Requisição' onclick=\"js_JanelaAutomatica('matrequi','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'm42_codigo') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Atendimento' onclick=\"js_JanelaAutomatica('atendrequi','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'm45_codigo') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Devolução' onclick=\"js_JanelaAutomatica('matestoquedev','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 't52_bem') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Bem' onclick=\"js_JanelaAutomatica('bem','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'q02_inscr') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Issqn' onclick=\"js_JanelaAutomatica('issbase','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'z01_numcgm') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações Contribuinte/Empresa' onclick=\"js_JanelaAutomatica('cgm','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'e60_numemp' || pg_fieldname($result, $j) == 'e61_numemp' || pg_fieldname($result, $j) == 'e62_numemp') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações do Empenho' onclick=\"js_JanelaAutomatica('empempenho','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == 'e54_autori' || pg_fieldname($result, $j) == 'e55_autori' || pg_fieldname($result, $j) == 'e56_autori') { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações da Autorização de Empenho' onclick=\"js_JanelaAutomatica('empautoriza','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { if (pg_fieldname($result, $j) == "pc10_numero") { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap><a title='Informações da Solicitação' onclick=\"js_JanelaAutomatica('empsolicita','" . trim(pg_result($result, $i, $j)) . "');return false;\"> Inf-> </a>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } else { echo "<td id=\"I" . $i . $j . "\" style=\"text-decoration:none;color:#000000;\" bgcolor=\"{$cor}\" nowrap>" . ($arquivo != "" ? "<a title=\"{$mensagem}\" style=\"text-decoration:none;color:#000000;\" href=\"\" " . ($arquivo == "()" ? "OnClick=\"" . $resultadoRetorno . ";return false\">" : "onclick=\"JanBrowse = window.open('" . $arquivo . "?" . base64_encode("retorno=" . ($BrowSe == 1 ? $i : trim(pg_result($result, $i, 0)))) . "','{$aonde}','width=800,height=600');return false\">") . trim(pg_result($result, $i, $j)) . "</a>" : trim(pg_result($result, $i, $j))) . " </td>\n"; } } } } } } } } } } } } } } } } } echo "</tr>\n"; // implamentacao de informacoes complementares // $divmostra .= "</table>"; // $divmostra .= '<div id="div'.$i.'" name="div'.$i.'" style="position:absolute; left:30px; top:40px; z-index:1; visibility: hidden; border: 1px none #000000; background-color: #CCCCCC; layer-background-color: #CCCCCC;">'; // $divmostra .= '<table border=\"1\" align=\"center\" cellspacing=\"1\">'; // $divmostra .= '<tr>'; // $divmostra .= '<td> '.$mostradiv; // $divmostra .= '</td> '; // $divmostra .= '</tr> '; // $divmostra .= '</table>'; // $divmostra .= '</div>'; } // echo $divmostra; /******************************/ if (count($totalizacao) > 0) { echo "<tr>"; for ($j = 0; $j < $NumFields; $j++) { $key_elemento = array_search(pg_fieldname($result, $j), $totalizacao); if ($key_elemento == true && pg_fieldname($result, $j) == $key_elemento && strlen(strstr(pg_fieldname($result, $j), "db_")) == 0) { @($vertotrep = $HTTP_POST_VARS['totrep_' . $key_elemento]); if (@$vertotrep != "" && !isset($tot)) { echo "<td style=\"text-decoration:none;color:#000000\" bgcolor=\"white\" align=right nowrap> " . $vertotrep . " </td>\n"; } else { if (isset($tot)) { echo "<td style=\"text-decoration:none;color:#000000\" bgcolor=\"white\" align=right nowrap> " . db_formatar(pg_result($tot, 0, $key_elemento), 'f') . " </td>\n"; } else { echo "<td style=\"text-decoration:none;color:#000000\" bgcolor=\"white\" align=right nowrap> </td>\n"; } } } else { if ($key_elemento == 'totalgeral') { echo "<td align='right'><strong>Total Geral : </strong></td>"; } else { if (strlen(strstr(pg_fieldname($result, $j), "db_")) == 0) { echo "<td></td>"; } } } } echo "</tr>"; } if ($NumRows > 0) { echo "<tr><td colspan={$NumFields} >\n <input name='recomecar' type='button' value='Recomeçar' onclick=\"js_troca_ordem('navega_lov" . $NomeForm . "','recomecar','0');\" class=\"botao\">\n\t\t\t\t\t\t<strong>Indique o Conteúdo:</strong><input title='Digite o valor a pesquisar e clique sobre o campo (cabeçalho) a pesquisar' name=indica_codigo type=text onchange='js_lanca_codigo_pesquisa(this.value)' style='background-color:#E6E4F1'>\n\t\t\t\t\t\t<strong>Quantidade a Listar:</strong><input id=quant_lista name=quant_lista type=text onchange='js_nova_quantidade_linhas(this.value)' style='background-color:#E6E4F1' value='{$numlinhas}' size='5'>\n\t\t\t\t\t\t<strong>Mostra Diferentes:</strong><input title='Mostra os valores diferentes clicando no cabeçalho a pesquisar' name=mostra_diferentes type=checkbox onchange='js_lanca_distinct_pesquisa()' style='background-color:#E6E4F1'>\n\t\t\t\t\t\t</td>"; echo "</tr>\n"; } echo "</table>"; for ($i = 0; $i < $NumRows; $i++) { for ($j = 0; $j < $NumFields; $j++) { if (pg_fieldtype($result, $j) == "text") { $clrotulocab->label(pg_fieldname($result, $j)); echo "<div id='div_text_" . $i . "_" . $j . "' style='position:absolute;left:10px; top:10px; visibility:hidden ; background-color:#6699CC ; border:2px outset #cccccc; align:left'>\n\t\t\t\t\t\t<table>\n\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td align='left'>\n\t\t\t\t\t\t<font color='black' face='arial' size='2'><strong>" . $clrotulocab->titulo . "</strong>:</font><br>\n\t\t\t\t\t\t<font color='black' face='arial' size='1'>" . str_replace("\n", "<br>", pg_result($result, $i, $j)) . "</font>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</div>"; } } } if ($automatico == true) { if (pg_numrows($result) == 1 && ${$offset} == 0) { echo "<script>" . @$resultadoRetorno . "</script>"; } } return $result; }
function FieldType($result, $offset) { switch ($this->dbType) { case "mssql": $r = mssql_field_type($result, $offset); break; case "mysql": $r = mysql_field_type($result, $offset); break; case "pg": $r = pg_fieldtype($result, $offset); break; default: $r = False; break; } return $r; }
?> </th> <th><?php echo $strType; ?> </th> <th><?php echo $strValue; ?> </th> </tr> <?php $result = pg_exec($link, pre_query($sql_get_fields)); for ($i = 0; $i < pg_numfields($result); $i++) { $field = pg_fieldname($result, $i); $type = pg_fieldtype($result, $i); $len = pg_fieldsize($result, $i); if ($len < 1) { $len_disp = "var"; $len = 50; } else { $len_disp = $len; } $bgcolor = $cfgBgcolorOne; $i % 2 ? 0 : ($bgcolor = $cfgBgcolorTwo); echo "<tr bgcolor=" . $bgcolor . ">"; echo "<td>{$field}</td>"; echo "<td>{$type} ({$len_disp})</td>"; if ($type == "bool") { echo "<td><select name=fields[]><option value=\"t\">True<option value=\"f\">False</select></td>"; } else {
} updatesquirrel(); } print "CREATE TABLE {$tbl_name} (" . implode(",", $create_fields) . ") WITH OIDS;\n"; foreach ($sequences as $seq_name => $nextval) { print "SELECT setval('{$seq_name}',{$nextval});\n"; } status("done creating query data.\n\n"); // create the insert data queries status("dumping data for table... "); //print "BEGIN;\n"; while ($fld_row = pg_fetch_row($flds_rslt)) { $idata = ""; foreach ($fld_row as $key => $value) { // read the field information $f_type = pg_fieldtype($flds_rslt, $key); // if the type is numeric or float and empty set it to zero if (empty($value) && preg_match("/^(float|numeric|int)/", $f_type)) { $value = "0"; } // escape the quotes $value = str_replace("'", "\\'", $value); $idata[] = "'{$value}'"; updatesquirrel(); } $query_indata = implode(",", $idata); print "INSERT INTO {$tbl_name} (" . implode(",", $insert_fields) . ") VALUES({$query_indata});\n"; } //print "COMMIT;\n"; status("done\n"); }
/** * Returns information about a table or a result set. * * NOTE: only supports 'table' and 'flags' if <var>$result</var> * is a table name. * * @param object|string $result MDB2_result object from a query or a * string containing the name of a table * @param int $mode a valid tableInfo mode * @return array an associative array with the information requested * or an error object if something is wrong * @access public * @internal * @see MDB2_Driver_Common::tableInfo() */ function tableInfo($result, $mode = null) { $db =& $GLOBALS['_MDB2_databases'][$this->db_index]; if ($db->options['portability'] & MDB2_PORTABILITY_LOWERCASE) { $case_func = 'strtolower'; } else { $case_func = 'strval'; } if (is_string($result)) { /* * Probably received a table name. * Create a result resource identifier. */ if (MDB2::isError($connect = $db->connect())) { return $connect; } $id = @pg_exec($db->connection, "SELECT * FROM {$result} LIMIT 0"); $got_string = true; } else { /* * Probably received a result object. * Extract the result resource identifier. */ $id = $result->getResource(); if (empty($id)) { return $db->raiseError(); } $got_string = false; } if (!is_resource($id)) { return $db->raiseError(MDB2_ERROR_NEED_MORE_DATA); } $count = @pg_numfields($id); // made this IF due to performance (one if is faster than $count if's) if (!$mode) { for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = $got_string ? $case_func($result) : ''; $res[$i]['name'] = $case_func(@pg_fieldname($id, $i)); $res[$i]['type'] = @pg_fieldtype($id, $i); $res[$i]['len'] = @pg_fieldsize($id, $i); $res[$i]['flags'] = $got_string ? $this->_pgFieldflags($id, $i, $result) : ''; } } else { // full $res['num_fields'] = $count; for ($i = 0; $i < $count; $i++) { $res[$i]['table'] = $got_string ? $case_func($result) : ''; $res[$i]['name'] = $case_func(@pg_fieldname($id, $i)); $res[$i]['type'] = @pg_fieldtype($id, $i); $res[$i]['len'] = @pg_fieldsize($id, $i); $res[$i]['flags'] = $got_string ? $this->_pgFieldFlags($id, $i, $result) : ''; if ($mode & MDB2_TABLEINFO_ORDER) { $res['order'][$res[$i]['name']] = $i; } if ($mode & MDB2_TABLEINFO_ORDERTABLE) { $res['ordertable'][$res[$i]['table']][$res[$i]['name']] = $i; } } } // free the result only if we were called on a table if ($got_string) { @pg_freeresult($id); } return $res; }
function tipocampo_query($query, $num) { $risul = pg_fieldtype($query, $num); return $risul; }
function &FetchField($fieldOffset = 0) { $off = $fieldOffset; // offsets begin at 0 $o = new ADOFieldObject(); $o->name = @pg_fieldname($this->_queryID, $off); $o->type = @pg_fieldtype($this->_queryID, $off); $o->max_length = @pg_fieldsize($this->_queryID, $off); //print_r($o); //print "off=$off name=$o->name type=$o->type len=$o->max_length<br>"; return $o; }
function get_table_content($link, $table, $handler) { global $cfgQuotes; $result = @pg_exec($link, "SELECT * FROM {$cfgQuotes}{$table}{$cfgQuotes}") or pg_die(pg_errormessage(), "", __FILE__, __LINE__); $iNumFields = pg_numfields($result); // Gather info about each column in the table for ($iField = 0; $iField < $iNumFields; $iField++) { $aryType[] = pg_fieldtype($result, $iField); $aryName[] = pg_fieldname($result, $iField); } $iRec = 0; while ($row = @pg_fetch_array($result, $iRec++)) { unset($schema_vals); unset($schema_fields); unset($schema_insert); for ($iFieldVal = 0; $iFieldVal < $iNumFields; $iFieldVal++) { $strVal = $row[$aryName[$iFieldVal]]; if (eregi("char|text", $aryType[$iFieldVal])) { $strQuote = "'"; $strEmpty = ""; $strVal = addslashes($strVal); } elseif (eregi("date|time|inet|bool", $aryType[$iFieldVal])) { if (empty($strVal)) { $strQuote = ""; } else { $strQuote = "'"; } $strEmpty = "NULL"; } else { $strQuote = ""; $strEmpty = "NULL"; } if (empty($strVal) && $strVal != "0") { $strVal = $strEmpty; } $schema_vals .= " {$strQuote}{$strVal}{$strQuote},"; $schema_fields .= " {$cfgQuotes}{$aryName[$iFieldVal]}{$cfgQuotes},"; } $schema_vals = ereg_replace(",\$", "", $schema_vals); $schema_vals = ereg_replace("^ ", "", $schema_vals); $schema_fields = ereg_replace(",\$", "", $schema_fields); $schema_fields = ereg_replace("^ ", "", $schema_fields); $schema_insert = "INSERT INTO {$cfgQuotes}{$table}{$cfgQuotes} ({$schema_fields}) VALUES({$schema_vals})"; $handler(trim($schema_insert)); } return true; }
function &FetchField($off = 0) { // offsets begin at 0 $o = new ADOFieldObject(); $o->name = @pg_fieldname($this->_queryID, $off); $o->type = @pg_fieldtype($this->_queryID, $off); $o->max_length = @pg_fieldsize($this->_queryID, $off); return $o; }
function sql_fieldtype($offset, $query_id = 0) { $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $starttime = $mtime; if (!$query_id) { $query_id = $this->query_result; } $mtime = microtime(); $mtime = explode(" ", $mtime); $mtime = $mtime[1] + $mtime[0]; $endtime = $mtime; $this->sql_time += $endtime - $starttime; return $query_id ? @pg_fieldtype($query_id, $offset) : false; }