$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);
