$num = pg_numrows($resultcons); $areatotal = 0; $areatrans = 0; for ($p = 0; $p < $num; $p++) { db_fieldsmemory($resultcons, $p); $areatrans += $it08_areatrans; //$areatotal += $it08_area; antes eu somava a area total para aparecer na guia, agora na linha de baixo //eu apenas coloco a primeira area total de uma das construcoes para aprecer na guia, conforme solicitado $areatotal += $it08_area; } } /*============================================================================================================================================================================*/ /********************************************************** T R A N S M I T E N T E S *****************************************************************************************/ /*============================================================================================================================================================================*/ //die($clitbinome->sql_queryguia("","it03_nome as z01_nome,it03_sexo,it03_cpfcnpj as z01_cgccpf,it03_endereco as z01_ender,it03_numero,it03_compl,it03_cxpostal,it03_bairro as z01_bairro,it03_munic as z01_munic,it03_uf as z01_uf,it03_cep as z01_cep,it03_mail,it22_itbi,it22_setor as j34_setor,it22_quadra as j34_quadra,it22_lote as j34_lote,it22_descrlograd as j14_nome,it22_numero as j39_numero,it22_compl,it06_matric,it04_codigo,it04_descr,it04_desconto,it04_obs,it04_aliquota,itbi.*,itburbano.*,itbirural.*,itbiavalia.*",""," it03_guia = $itbi and it03_tipo = 't' and it03_princ = 't' ")); $result1 = $clitbinome->sql_record($clitbinome->sql_queryguia("", "it03_nome as z01_nome,it03_sexo,it03_cpfcnpj as z01_cgccpf,it03_endereco as z01_ender,it03_numero,it03_compl,it03_cxpostal,it03_bairro as z01_bairro,it03_munic as z01_munic,it03_uf as z01_uf,it03_cep as z01_cep,it03_mail,it22_itbi,it22_setor as j34_setor,it22_quadra as j34_quadra,it22_lote as j34_lote,it22_descrlograd as j14_nome,j13_descr,it22_numero as j39_numero,it22_compl,it06_matric,it04_codigo,it04_descr,it04_desconto,it04_obs,it04_aliquota,itbi.*,itburbano.*,itbirural.*,itbiavalia.*", "", " it03_guia = {$itbi} and it03_tipo = 't' and it03_princ = 't' ")); if ($clitbinome->numrows > 0) { //db_criatabela($result1);exit; db_fieldsmemory($result1, 0); } $propri = ""; //$result = $clitbipropriold->sql_record($clitbipropriold->sql_query("",""," z01_nome as nomeoutro","it20_guia"," it20_guia = $itbi and it20_pri = 'f' and it20_numcgm not in ($z01_numcgm)")); // die($clitbinome->sql_queryguia("","it03_nome as nomeoutro, it03_guia as it20_guia,it03_sexo ",""," it03_guia = $itbi and it03_tipo = 't' and it03_princ= 'f' ")); $result = $clitbinome->sql_record($clitbinome->sql_queryguia("", "it03_nome as nomeoutro, it03_guia as it20_guia,it03_sexo ", "", " it03_guia = {$itbi} and it03_tipo = 't' and it03_princ= 'f' ")); //if($clitbipropriold->numrows > 0){ $transmitentesm = 0; $transmitentesf = 0; if ($clitbinome->numrows > 0) { $traco = ''; $propri .= "\n" . 'OUTRO(S) TRANSMITENTE(S) : '; $num = pg_numrows($result);