db_fieldsmemory($result, 0);
$result = $clitbi->sql_record($clitbi->sql_query($itbi));
db_fieldsmemory($result, 0);
$areaterreno = $it01_areaterreno;
$areatran = $it01_areatrans;
$result = $clitburbano->sql_record($clitburbano->sql_query($itbi));
if ($clitburbano->numrows > 0) {
db_fieldsmemory($result, 0);
$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;
}
