$tipo = "urbano";
}
$result = $clitbirural->sql_record($clitbirural->sql_query($itbi));
if ($clitbirural->numrows > 0) {
db_fieldsmemory($result, 0);
$tipo = "rural";
}
$result = $clitbimatric->sql_record($clitbimatric->sql_query($itbi));
if ($clitbimatric->numrows > 0) {
db_fieldsmemory($result, 0);
}
$proprietarios = "";
/************************************************************* A D Q U I R E N T E S ****************************************************************************************/
/*=================================== COM A NOVA EXTRUTURA BUSCA OS DADOS DE TRANSMISSORES E ADQUIRENTES NA TABELA ITBINOME ===================================================*/
/* AKI PEGA SO O ADQUIRENTE PRINCIPAL E SEUS DADOS */
$rscompprinc = $clitbinome->sql_record($clitbinome->sql_query("", " it03_nome as nomecompprinc,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_cpfcnpj as cgccpfcomprador,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_endereco as enderecocomprador, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_numero as numerocomprador, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_compl as complcomprador, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_munic as municipiocomprador,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_uf as ufcomprador,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_cep as cepcomprador,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_sexo as sexocomprador,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_princ as principalcomprador,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t it03_bairro as bairrocomprador", "", " it03_guia = {$itbi} \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t and it03_tipo = 'c' \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t and it03_princ = 't' "));
if ($clitbinome->numrows > 0) {
db_fieldsmemory($rscompprinc, $p);
} else {
db_msgbox('Adquirente principal não encontrado ! ');
echo "<script>window.close()</script>";
exit;
}
/*AKI PEGA OS ADQUIRENTES SECUNDARIOS*/
// die ($clitbinome->sql_query(""," it03_nome as nomecomp, it03_sexo as sexocomprador",""," it03_guia = $itbi and it03_tipo = 'c' and it03_princ = 'f' "));
$result = $clitbinome->sql_record($clitbinome->sql_query("", " it03_nome as nomecomp, it03_sexo as sexocomprador", "", " it03_guia = {$itbi} and it03_tipo = 'c' and it03_princ = 'f' "));
if ($clitbinome->numrows > 0) {
$traco = '';
$proprietarios .= "\n" . 'ADQUIRENTES : ';
$num = pg_numrows($result);
for ($p = 0; $p < $num; $p++) {
