$cgccpf = str_replace(".", "", $cgccpf);
$cgccpf = str_replace("/", "", $cgccpf);
$cgccpf = str_replace("-", "", $cgccpf);
$sql_exe = "select ident from db_config";
$result = pg_exec($sql_exe) or die("Erro: " . pg_ErrorMessage($conn));
db_fieldsmemory($result, 0);
/*
$sql_exe = "select * from iptubase,cgm
where j01_matric = $matricula and
j01_numcgm = z01_numcgm ";
if ( $db_verifica_ip == "0" ) {
$sql_exe = $sql_exe . " and trim(z01_cgccpf) = '$cgccpf' and trim(z01_cgccpf) != ''";
}
$result = pg_exec($sql_exe) or die("Erro: ".pg_ErrorMessage($conn));
*/
$result = $cliptubase->sql_record($cliptubase->sql_query("", "*", "", "iptubase.j01_matric = {$matricula} and j01_numcgm = z01_numcgm"));
} else {
/*
$result = pg_exec("select * from iptubase,cgm
where j01_matric = $matricula and
j01_numcgm = z01_numcgm") or die("Erro: ".pg_ErrorMessage($conn));
$cgccpf = trim(pg_result($result,0,'z01_cgccpf'));
*/
$result = $cliptubase->sql_record($cliptubase->sql_query("", "*", "", "iptubase.j01_matric = {$matricula} and cgm.j01_numcgm = z01_numcgm"));
}
db_fieldsmemory($result, 0);
include "libs/db_mens.php";
if ($cliptubase->numrows == 0) {
db_logs("{$matricula}", "", 0, "Dados Inconsistentes. Numero : {$matricula}");
db_redireciona("digitaitbi.php?" . base64_encode("erroscripts=Os dados informados não conferem, verifique!"));
$script = false;
if ($id_usuario != "" || $_COOKIE["cookie_codigo_cgm"] != "") {
$usuario = $id_usuario == "" ? $_COOKIE["cookie_codigo_cgm"] : $id_usuario;
$result = $clcgm->sql_record($clcgm->sql_query("", "cgm.z01_cgccpf, cgm.z01_nome, cgm.z01_numcgm", "", "cgm.z01_numcgm = {$usuario}"));
$linhas = $clcgm->numrows;
if ($linhas != 0) {
db_fieldsmemory($result, 0);
//11 14
if (strlen($z01_cgccpf) > 11) {
$cgc = $z01_cgccpf;
$cpf = "";
} else {
$cgc = "";
$cpf = $z01_cgccpf;
}
// iptu
$result2 = $cliptubase->sql_record($cliptubase->sql_query("", "*", "", "cgm.z01_numcgm = {$z01_numcgm}"));
$linhas2 = $cliptubase->numrows;
?>
<table width="60%" border="1" bordercolor="#cccccc" cellpadding="5" cellspacing="0" class="texto">
<tr>
<td width="100%" nowrap height="28" bgcolor="<?php
echo $w01_corfundomenu;
?>
">
<table width="100%" border="0" cellpadding="1" cellspacing="0" class="texto">
<tr><td>
<img src="imagens/icone.gif" border="0">
</td><td>
CNPJ/CPF: <span class="bold3"><?php
echo $z01_cgccpf;
?>
