$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++) {