printJavascript('includes/xajax/','',''); ?>
SetAssociativo(); $tabdes->Execute($sql); ?> Você está no destino:  fields['nomedestino'])?>SetAssociativo(); $tabdes->Execute($sql); ?> Você está na temporada:  fields['descricao'])?> SetAssociativo(); $tabpct1 = new $db; $tabpct1->SetAssociativo(); $tabpct2 = new $db; $tabpct2->SetAssociativo(); $tabpct3 = new $db; $tabpct3->SetAssociativo(); $tabcam = new $db; $tabcam->SetAssociativo(); $sql="select registro, titulodoroteiro from tabpct where 1=1 and publicar=1 "; if($_GET['destino']!=''){ $sql.="and destino='".$_GET['destino']*1 ."'"; }else if($_GET['Temporada']!=''){ $sql.="and galho2='".$_GET['Temporada']*1 ."'"; } $tabipct->Execute($sql); $qtdLinhas = $tabipct->qtdLinhas*1; $sql.= "order by titulodoroteiro limit 10 offset ". $_GET['Posicao']*1; $posAtual = ($_GET['Posicao']*1+1); $tabipct->Execute($sql); $t=1; $o=1; while(!$tabipct->EOF){?>
fields['registro']; $sql="select cambiofechamento, moedafechamento from tabpct where registro='". $pacote*1 ."'"; $tabpct3->Execute($sql); $sql="select sigla from tabcam where registro='".$tabpct3->fields['moedafechamento']*1 ."'"; $tabcam->Execute($sql); $cambiofechamento = ereg_replace(',', '.', $tabpct3->fields['cambiofechamento'])*1; $totaldbl = 0; $totaltpl = 0; $totalsgl = 0; $totalchd = 0; $totalchl = 0; $totalinf = 0; $compratotaldbl = 0; $compratotaltpl = 0; $compratotalsgl = 0; $compratotalchd = 0; $compratotalchl = 0; $compratotalinf = 0; //Aereo $sql= "select distinct on (b.registro) b.registro, obtercambio(b.moedacompra) as cambiocompra, b.tarifaadt, b.tarifachd, b.tarifainf, b.markup1 " ."from tabfor a " ."join tabfort1 b on a.registro=b.fornecedor " ."join tabpct1 c on b.registro=c.registrotarifa where tipo='Aereo' and c.pacote='". $pacote*1 ."' "; $tabpct1->Execute($sql); if(!$tabpct1->EOF){ while(!$tabpct1->EOF){ $totaldbl+=(( ($tabpct1->fields['tarifaadt'] / ((100-$tabpct1->fields['markup1'])/100)) * $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totaltpl+=(( ($tabpct1->fields['tarifaadt'] / ((100-$tabpct1->fields['markup1'])/100)) * $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalsgl+=(( ($tabpct1->fields['tarifaadt'] / ((100-$tabpct1->fields['markup1'])/100)) * $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalchd+=(( ($tabpct1->fields['tarifachd'] / ((100-$tabpct1->fields['markup1'])/100)) * $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalchl+=(( ($tabpct1->fields['tarifachd'] / ((100-$tabpct1->fields['markup1'])/100)) * $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalinf+=(( ($tabpct1->fields['tarifainf'] / ((100-$tabpct1->fields['markup1'])/100)) * $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $compratotaldbl+=( $tabpct1->fields['tarifaadt'] * $tabpct1->fields['cambiocompra'] ) ; $compratotaltpl+=( $tabpct1->fields['tarifaadt'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalsgl+=( $tabpct1->fields['tarifaadt'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalchd+=( $tabpct1->fields['tarifachd'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalchl+=( $tabpct1->fields['tarifachd'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalinf+=( $tabpct1->fields['tarifainf'] * $tabpct1->fields['cambiocompra'] ) ; $tabpct1->MoveNext(); } } //Receptivo $sql= "select b.registro, obtercambio(b.moedacompra) as cambiocompra, " ."b.tarifadbl, b.tarifatpl, b.tarifasgl, b.tarifachd, b.tarifachl, b.tarifainf, b.markup1 " ."from tabfor a " ."join tabfort3 b on a.registro=b.fornecedor " ."join tabpct1 c on b.registro=c.registrotarifa where tipo='Receptivo' and c.pacote='". $pacote*1 ."' "; $tabpct1->Execute($sql); if(!$tabpct1->EOF){ while(!$tabpct1->EOF){ $totaldbl+= ((($tabpct1->fields['tarifadbl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totaltpl+= ((($tabpct1->fields['tarifatpl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalsgl+= ((($tabpct1->fields['tarifasgl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalchd+= ((($tabpct1->fields['tarifachd'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalchl+= ((($tabpct1->fields['tarifachl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalinf+= ((($tabpct1->fields['tarifainf'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $compratotaldbl+=( $tabpct1->fields['tarifadbl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotaltpl+=( $tabpct1->fields['tarifatpl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalsgl+=( $tabpct1->fields['tarifasgl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalchd+=( $tabpct1->fields['tarifachd'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalchl+=( $tabpct1->fields['tarifachl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalinf+=( $tabpct1->fields['tarifainf'] * $tabpct1->fields['cambiocompra'] ) ; $tabpct1->MoveNext(); } } //Serviços $sql= "select b.registro, obtercambio(b.moedacompra) as cambiocompra, " ."b.tarifadbl, b.tarifatpl, b.tarifasgl, b.tarifachd, b.tarifachl, b.tarifainf, b.markup1 " ."from tabfor a " ."join tabfort4 b on a.registro=b.fornecedor " ."join tabpct1 c on b.registro=c.registrotarifa where tipo='Servico' and c.pacote='". $pacote*1 ."' "; $tabpct1->Execute($sql); if(!$tabpct1->EOF){ while(!$tabpct1->EOF){ $totaldbl+= ((($tabpct1->fields['tarifadbl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totaltpl+= ((($tabpct1->fields['tarifatpl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalsgl+= ((($tabpct1->fields['tarifasgl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalchd+= ((($tabpct1->fields['tarifachd'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalchl+= ((($tabpct1->fields['tarifachl'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $totalinf+= ((($tabpct1->fields['tarifainf'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) ; $compratotaldbl+=( $tabpct1->fields['tarifadbl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotaltpl+=( $tabpct1->fields['tarifatpl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalsgl+=( $tabpct1->fields['tarifasgl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalchd+=( $tabpct1->fields['tarifachd'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalchl+=( $tabpct1->fields['tarifachl'] * $tabpct1->fields['cambiocompra'] ) ; $compratotalinf+=( $tabpct1->fields['tarifainf'] * $tabpct1->fields['cambiocompra'] ) ; $tabpct1->MoveNext(); } } //Rodoviario $sql= "select distinct on (b.registro) b.registro, obtercambio(b.moedacompra) as cambiocompra, b.valortotal, c.qtddepagantes, b.markup1 " ."from tabfor a " ."join tabfort5 b on a.registro=b.fornecedor " ."join tabpct1 c on b.registro=c.registrotarifa where c.tipo='Rodoviario' and c.pacote='". $pacote*1 ."' "; $tabpct1->Execute($sql); if(!$tabpct1->EOF){ while(!$tabpct1->EOF){ $qtddepagantes = $tabpct1->fields['qtddepagantes']*1>0? $tabpct1->fields['qtddepagantes']*1 : '1' ; $totaldbl+=( ((($tabpct1->fields['valortotal'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) / $qtddepagantes) ; $totaltpl+=( ((($tabpct1->fields['valortotal'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) / $qtddepagantes) ; $totalsgl+=( ((($tabpct1->fields['valortotal'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) / $qtddepagantes) ; $totalchd+=( ((($tabpct1->fields['valortotal'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) / $qtddepagantes) ; $totalchl+=( ((($tabpct1->fields['valortotal'] / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) / $qtddepagantes) ; $totalinf+= 0; $compratotaldbl+=(( $tabpct1->fields['valortotal'] * $tabpct1->fields['cambiocompra'] )/ $qtddepagantes) ; $compratotaltpl+=(( $tabpct1->fields['valortotal'] * $tabpct1->fields['cambiocompra'] )/ $qtddepagantes) ; $compratotalsgl+=(( $tabpct1->fields['valortotal'] * $tabpct1->fields['cambiocompra'] )/ $qtddepagantes) ; $compratotalchd+=(( $tabpct1->fields['valortotal'] * $tabpct1->fields['cambiocompra'] )/ $qtddepagantes) ; $compratotalchl+=(( $tabpct1->fields['valortotal'] * $tabpct1->fields['cambiocompra'] )/ $qtddepagantes) ; $compratotalinf+= 0; $tabpct1->MoveNext(); } } //Hotel - Principal $sql= "select distinct b.registro, c.conjugar as ordem, a.fantasia, b.regime, b.idadechd, b.idadechl, b.idadeinf, a.endereco, a.bairro, obtercambio(b.moedacompra) as cambiocompra, c.qtddenoites, b.acomodacoesdisponiveis, a.site, b.observacao, b.promocao, b.diaria, " ."(select unidade from tabfor3 where registro=b.unidade limit 1) as unidade, b.imposto, b.tarifadbl, b.tarifatpl, b.tarifasgl, b.tarifachd, b.tarifachl, b.tarifainf, b.markup1, b.markup2, " ."(select pax from tabfor3 where registro=b.unidade limit 1) as paxunidade, (select informacoes from tabfor3 where registro=b.unidade limit 1) as infounidade, " ."(select distancia from tabfor2 where fornecedor=a.registro limit 1) as distancia, (select aeroporto from tabfor2 where fornecedor=a.registro limit 1) as aeroporto," ."(select tempo from tabfor2 where fornecedor=a.registro limit 1) as tempo " ."from tabfor a " ."join tabfort2 b on a.registro=b.fornecedor " ."join tabpct1 c on b.registro=c.registrotarifa " ."join tabpct d on c.pacote=d.registro " ."where c.tipo='Hotel' and c.pacote='". $pacote*1 ."' and current_date+d.qtddenoites <= d.validadeate " ."order by c.conjugar "; $tabpct1->Execute($sql); if(!$tabpct1->EOF){ $sql="select validadede, validadeate, (select descricao from tabglh where registro=tabpct.galho2 limit 1) as temporada from tabpct where registro='". $pacote*1 ."'"; $tabi = new $db; $tabi->SetAssociativo(); $tabi->Execute($sql); ?>
SetAssociativo(); $tab->Execute($sql); if(!$tab->EOF){ while(!$tab->EOF){ $campo="Transporte Aéreo - ". $tab->fields['fantasia'] ." - ". $tab->fields['trecho'] ." "; $tab->MoveNext(); } } $sql= "select a.tempoviagem, a.embarquedesembarque, (select nomedestino from tabdes where registro=a.destino limit 1) as nomedestino from tabfort5 a " ."join tabpct1 b on a.registro=b.registrotarifa where b.tipo='Rodoviario' and b.pacote='". $pacote*1 ."' order by a.registro limit 1 "; $tab = new $db; $tab->SetAssociativo(); $tab->Execute($sql); if(!$tab->EOF){ while(!$tab->EOF){ $campo="Transporte Rodoviário - Ônibus de Turismo - Destino: ". $tab->fields['nomedestino'] ." - Tempo aproximado da viagem: ". $tab->fields['tempoviagem'] ." - Embarque e desembarque: ". $tab->fields['embarquedesembarque'] ." - consulte com nossa equipe outros locais de embarque e desembarque deste roteiro."; $tab->MoveNext(); } } $sql= "select a.servicos as descricao, a.duracao from tabfort3 a " ."join tabpct1 b on a.registro=b.registrotarifa where b.tipo='Receptivo' and b.pacote='". $pacote*1 ."' " ."union " ."select a.passeios as descricao, a.duracao from tabfort5 a " ."join tabpct1 b on a.registro=b.registrotarifa where b.tipo='Rodoviario' and b.pacote='". $pacote*1 ."' "; $tab->Execute($sql); if(!$tab->EOF){ while(!$tab->EOF){ $campo2="". $tab->fields['descricao'] .""; $tab->MoveNext(); } } $sql="select validadede, validadeate, qtddenoites, qtddedias, passeiosservicos, titulodoroteiro from tabpct where registro='".$pacote."'"; $tabi1 = new $db; $tabi1->SetAssociativo(); $tabi1->Execute($sql); $campo3=todata($tabi1->fields['validadede']); $campo4=todata($tabi1->fields['validadeate']); $campo5=$tabi1->fields['qtddedias']; $campo6=$tabi1->fields['qtddenoites']; $campo7=strip_tags(html_entity_decode($tabi1->fields['passeiosservicos'])); ?>
fields['titulodoroteiro'])?>
Duração: dias / noites
Transporte:
Passeios / Serviços:
Passeios / Serviços:
Validade: fields['validadede'])?> à fields['validadeate'])?> - fields['temporada']) ?>
fields['galho1a']*1!=1){ ?> fields['galho1a']*1!=1){ ?> EOF){ if($pos*1==0){ //primeiro registro $tarifadbl = (((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifatpl = (((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifasgl = (((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifachd = (((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifachl = (((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifainf = (((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; if($tabpct1->fields['markup2']>0){ $tarifadblextra = (((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifatplextra = (((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifasglextra = (((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifachdextra = (((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifachlextra = (((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifainfextra = (((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); }else{ $tarifadblextra = 0; $tarifatplextra = 0; $tarifasglextra = 0; $tarifachdextra = 0; $tarifachlextra = 0; $tarifainfextra = 0; } $compratarifadbl = ((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifatpl = ((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifasgl = ((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifachd = ((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifachl = ((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifainf = ((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); /*if($tarifadbl*1>0){$zeradbl=1;}else{$zeradbl=0;} if($tarifatpl*1>0){$zeratpl=1;}else{$zeratpl=0;} if($tarifasgl*1>0){$zerasgl=1;}else{$zerasgl=0;} if($tarifachd*1>0){$zerachd=1;}else{$zerachd=0;} if($tarifachl*1>0){$zerachl=1;}else{$zerachl=0;} if($tarifainf*1>0){$zerainf=1;}else{$zerainf=0;}*/ $zeradbl = 1; $zeratpl = 1; $zerasgl = 1; $zerachd = 1; $zerachl = 1; $zerainf = 1; $sql="select sigladoaeroporto from tabaer where registro='".$tabpct1->fields['aeroporto']*1 ."'"; $tabaer = new $db; $tabaer->SetAssociativo(); $tabaer->Execute($sql); $ordemanterior = $tabpct1->fields['ordem']*1; $site = $tabpct1->fields['site']; $fantasia = ''. $tabpct1->fields['fantasia'] .''; $unidade = $tabpct1->fields['unidade']; $endereco = $tabpct1->fields['endereco']; $bairro = $tabpct1->fields['bairro']; $fantasia2 = $tabpct1->fields['fantasia']; $paxunidade = $tabpct1->fields['paxunidade']; $infounidade = $tabpct1->fields['infounidade']; $idadechd = $tabpct1->fields['idadechd']; $idadechl = $tabpct1->fields['idadechl']; $idadeinf = $tabpct1->fields['idadeinf']; $regime = $tabpct1->fields['regime']; $observacao = $tabpct1->fields['observacao']; $promocao = $tabpct1->fields['promocao']; $aeroporto = $tabaer->fields['sigladoaeroporto']; $distancia = $tabpct1->fields['distancia']; $tempo = $tabpct1->fields['tempo']; $diaria = $tabpct1->fields['diaria']; $informacoes = '
Noite Adicional
Hotel Unidade Regime DBL TPL SGL CHD CHL INFDBL TPL SGL CHD CHL INF
'.utf8_encode($fantasia2) .'
Promoção
'.utf8_encode($promocao) .'
Diária
'.utf8_encode($diaria) .'
Observação
'.utf8_encode($observacao) .'
Aeroporto
'. $aeroporto .' - '. $distancia.'km - '. $tempo.'
'; $chkdispDBL=substr($tabpct1->fields['acomodacoesdisponiveis'], 1, 1)*1; $chkdispTPL=substr($tabpct1->fields['acomodacoesdisponiveis'], 2, 1)*1; $chkdispSGL=substr($tabpct1->fields['acomodacoesdisponiveis'], 0, 1)*1; $chkdispCHD=substr($tabpct1->fields['acomodacoesdisponiveis'], 4, 1)*1; $chkdispCHL=substr($tabpct1->fields['acomodacoesdisponiveis'], 5, 1)*1; $chkdispINF=substr($tabpct1->fields['acomodacoesdisponiveis'], 6, 1)*1; }else{ if($ordemanterior*1==$tabpct1->fields['ordem']*1){ //se estiver conjugado $tarifadbl+= (((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifatpl+= (((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifasgl+= (((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifachd+= (((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifachl+= (((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifainf+= (((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; if($tabpct1->fields['markup2']>0){ $tarifadblextra = (((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifatplextra = (((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifasglextra = (((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifachdextra = (((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifachlextra = (((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifainfextra = (((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); }else{ $tarifadblextra = 0; $tarifatplextra = 0; $tarifasglextra = 0; $tarifachdextra = 0; $tarifachlextra = 0; $tarifainfextra = 0; } $compratarifadbl+= ((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifatpl+= ((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifasgl+= ((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifachd+= ((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifachl+= ((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifainf+= ((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $zeradbl = 1; $zeratpl = 1; $zerasgl = 1; $zerachd = 1; $zerachl = 1; $zerainf = 1; $sql="select sigladoaeroporto from tabaer where registro='".$tabpct1->fields['aeroporto']*1 ."'"; $tabaer = new $db; $tabaer->SetAssociativo(); $tabaer->Execute($sql); $site = $tabpct1->fields['site']; $ordemanterior = $tabpct1->fields['ordem']*1; $fantasia.= '
'. $tabpct1->fields['fantasia'] .''; $unidade.= '
'. $tabpct1->fields['unidade']; $endereco = $tabpct1->fields['endereco']; $bairro = $tabpct1->fields['bairro']; $fantasia2 = $tabpct1->fields['fantasia']; $paxunidade = $tabpct1->fields['paxunidade']; $infounidade = $tabpct1->fields['infounidade']; $idadechd = $tabpct1->fields['idadechd']; $idadechl = $tabpct1->fields['idadechl']; $idadeinf = $tabpct1->fields['idadeinf']; $regime.= '
'. $tabpct1->fields['regime']; $observacao = $tabpct1->fields['observacao']; $promocao = $tabpct1->fields['promocao']; $aeroporto = $tabaer->fields['sigladoaeroporto']; $distancia = $tabpct1->fields['distancia']; $tempo = $tabpct1->fields['tempo']; $diaria = $tabpct1->fields['diaria']; $informacoes.= '
'.utf8_encode($fantasia2) .'
Promoção
'.utf8_encode($promocao) .'
Diária
'.utf8_encode($diaria) .'
Observação
'.utf8_encode($observacao) .'
Aeroporto
'. $aeroporto .' - '. $distancia.'km - '. $tempo.'
'; if($chkdispDBL>substr($tabpct1->fields['acomodacoesdisponiveis'], 1, 1)*1){$chkdispDBL=0;} if($chkdispTPL>substr($tabpct1->fields['acomodacoesdisponiveis'], 2, 1)*1){$chkdispTPL=0;} if($chkdispSGL>substr($tabpct1->fields['acomodacoesdisponiveis'], 0, 1)*1){$chkdispSGL=0;} if($chkdispCHD>substr($tabpct1->fields['acomodacoesdisponiveis'], 4, 1)*1){$chkdispCHD=0;} if($chkdispCHL>substr($tabpct1->fields['acomodacoesdisponiveis'], 5, 1)*1){$chkdispCHL=0;} if($chkdispINF>substr($tabpct1->fields['acomodacoesdisponiveis'], 6, 1)*1){$chkdispINF=0;} }else{ $class = $class==''?'alternacao':''; $class2 = $class2=='alternacao2'?'alternacao3':'alternacao2'; $sql= "select precovendadbl, precovendatpl, precovendasgl, precovendachl, precovendachd, precovendainf, " ."descontoacrescimodbl, descontoacrescimotpl, descontoacrescimosgl, descontoacrescimochd, descontoacrescimochl, descontoacrescimoinf, " ."habilitarsite " ."from tabpct2 where pacote='". $pacote*1 ."' and conjugar='". $ordemanterior*1 ."' "; $tabpct2->Execute($sql); if((!$tabpct2->EOF)&&($atualizaPrecos*1==0)){ $precovendadbl = tostring($tabpct2->fields['precovendadbl']); $precovendatpl = tostring($tabpct2->fields['precovendatpl']); $precovendasgl = tostring($tabpct2->fields['precovendasgl']); $precovendachd = tostring($tabpct2->fields['precovendachd']); $precovendachl = tostring($tabpct2->fields['precovendachl']); $precovendainf = tostring($tabpct2->fields['precovendainf']); $habilitar=$tabpct2->fields['habilitarsite']*1; if($habilitar*1>0){$checked='checked';}else{$checked='';} }else{ $precovendadbl = tostringN(($tarifadbl + $totaldbl)*$zeradbl); $precovendatpl = tostringN(($tarifatpl + $totaltpl)*$zeratpl); $precovendasgl = tostringN(($tarifasgl + $totalsgl)*$zerasgl); $precovendachd = tostringN(($tarifachd + $totalchd)*$zerachd); $precovendachl = tostringN(($tarifachl + $totalchl)*$zerachl); $precovendainf = tostringN(($tarifainf + $totalinf)*$zerainf); $habilitar=1; $checked='checked'; } $descontodbl=$tabpct2->fields['descontoacrescimodbl']; $descontotpl=$tabpct2->fields['descontoacrescimotpl']; $descontosgl=$tabpct2->fields['descontoacrescimosgl']; $descontochd=$tabpct2->fields['descontoacrescimochd']; $descontochl=$tabpct2->fields['descontoacrescimochl']; $descontoinf=$tabpct2->fields['descontoacrescimoinf']; //DBL if($chkdispDBL*1==0){ $dbl = 'NA'; $dblextra = 'NA'; $compradbl='NA'; }else{ $dbl = tostringN(($tarifadbl + $totaldbl + $descontodbl)*$zeradbl); $dblextra = tostringN($tarifadblextra); $compradbl=tostringN(($compratarifadbl + $compratotaldbl)*$zeradbl); } //TPL if($chkdispTPL*1==0){ $tpl = 'NA'; $tplextra = 'NA'; $compratpl='NA'; }else{ $tpl = tostringN(($tarifatpl + $totaltpl + $descontotpl)*$zeratpl); $tplextra = tostringN($tarifatplextra); $compratpl=tostringN(($compratarifatpl + $compratotaltpl)*$zeratpl); } //SGL if($chkdispSGL*1==0){ $sgl = 'NA'; $sglextra = 'NA'; $comprasgl='NA'; }else{ $sgl = tostringN(($tarifasgl + $totalsgl + $descontosgl)*$zerasgl); $sglextra = tostringN($tarifasglextra); $comprasgl=tostringN(($compratarifasgl + $compratotalsgl)*$zerasgl); } //CHD if($chkdispCHD*1==0){ $chd = 'NA'; $chdextra = 'NA'; $comprachd='NA'; }else{ $chd = tostringN(($tarifachd + $totalchd + $descontochd)*$zerachd); $chdextra = tostringN($tarifachdextra); $comprachd=tostringN(($compratarifachd + $compratotalchd)*$zerachd); } //CHL if($chkdispCHL*1==0){ $chl = 'NA'; $chlextra = 'NA'; $comprachl='NA'; }else{ $chl = tostringN(($tarifachl + $totalchl + $descontochl)*$zerachl); $chlextra = tostringN($tarifachlextra); $comprachl=tostringN(($compratarifachl + $compratotalchl)*$zerachl); } //INF if($chkdispINF*1==0){ $inf = 'NA'; $infextra = 'NA'; $comprainf='NA'; }else{ $inf = tostringN(($tarifainf + $totalinf + $descontoinf)*$zerainf); $infextra = tostringN($tarifainfextra); $comprainf=tostringN(($compratarifainf + $compratotalinf)*$zerainf); } $q==1; ?> i fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['galho1a']*1!=1){ ?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifatpl = (((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifasgl = (((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifachd = (((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifachl = (((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; $tarifainf = (((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup1'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ) * $tabpct1->fields['qtddenoites']*1; if($tabpct1->fields['markup2']>0){ $tarifadblextra = (((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifatplextra = (((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifasglextra = (((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifachdextra = (((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifachlextra = (((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); $tarifainfextra = (((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100))) / ((100-$tabpct1->fields['markup2'])/100) )* $tabpct1->fields['cambiocompra']) / $cambiofechamento ); }else{ $tarifadblextra = 0; $tarifatplextra = 0; $tarifasglextra = 0; $tarifachdextra = 0; $tarifachlextra = 0; $tarifainfextra = 0; } $compratarifadbl = ((($tabpct1->fields['tarifadbl']+($tabpct1->fields['tarifadbl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifatpl = ((($tabpct1->fields['tarifatpl']+($tabpct1->fields['tarifatpl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifasgl = ((($tabpct1->fields['tarifasgl']+($tabpct1->fields['tarifasgl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifachd = ((($tabpct1->fields['tarifachd']+($tabpct1->fields['tarifachd']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifachl = ((($tabpct1->fields['tarifachl']+($tabpct1->fields['tarifachl']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $compratarifainf = ((($tabpct1->fields['tarifainf']+($tabpct1->fields['tarifainf']*($tabpct1->fields['imposto']/100)))* $tabpct1->fields['cambiocompra']) * $tabpct1->fields['qtddenoites']*1); $zeradbl = 1; $zeratpl = 1; $zerasgl = 1; $zerachd = 1; $zerachl = 1; $zerainf = 1; $sql="select sigladoaeroporto from tabaer where registro='".$tabpct1->fields['aeroporto']*1 ."'"; $tabaer = new $db; $tabaer->SetAssociativo(); $tabaer->Execute($sql); $ordemanterior = $tabpct1->fields['ordem']*1; $site = $tabpct1->fields['site']; $fantasia = ''. $tabpct1->fields['fantasia'] .''; $unidade = $tabpct1->fields['unidade']; $endereco = $tabpct1->fields['endereco']; $bairro = $tabpct1->fields['bairro']; $fantasia2 = $tabpct1->fields['fantasia']; $paxunidade = $tabpct1->fields['paxunidade']; $infounidade = $tabpct1->fields['infounidade']; $idadechd = $tabpct1->fields['idadechd']; $idadechl = $tabpct1->fields['idadechl']; $idadeinf = $tabpct1->fields['idadeinf']; $regime = $tabpct1->fields['regime']; $observacao = $tabpct1->fields['observacao']; $promocao = $tabpct1->fields['promocao']; $aeroporto = $tabaer->fields['sigladoaeroporto']; $distancia = $tabpct1->fields['distancia']; $tempo = $tabpct1->fields['tempo']; $diaria = $tabpct1->fields['diaria']; $informacoes = '
'.utf8_encode($fantasia2) .'
Promoção
'.utf8_encode($promocao) .'
Diária
'.utf8_encode($diaria) .'
Observação
'.utf8_encode($observacao) .'
Aeroporto
'. $aeroporto .' - '. $distancia.'km - '. $tempo.'
'; $chkdispDBL=substr($tabpct1->fields['acomodacoesdisponiveis'], 1, 1)*1; $chkdispTPL=substr($tabpct1->fields['acomodacoesdisponiveis'], 2, 1)*1; $chkdispSGL=substr($tabpct1->fields['acomodacoesdisponiveis'], 0, 1)*1; $chkdispCHD=substr($tabpct1->fields['acomodacoesdisponiveis'], 4, 1)*1; $chkdispCHL=substr($tabpct1->fields['acomodacoesdisponiveis'], 5, 1)*1; $chkdispINF=substr($tabpct1->fields['acomodacoesdisponiveis'], 6, 1)*1; } } $pos++; $tabpct1->MoveNext(); } $class = $class==''?'alternacao':''; $class2 = $class2=='alternacao2'?'alternacao3':'alternacao2'; $sql= "select precovendadbl, precovendatpl, precovendasgl, precovendachl, precovendachd, precovendainf, " ."descontoacrescimodbl, descontoacrescimotpl, descontoacrescimosgl, descontoacrescimochd, descontoacrescimochl, descontoacrescimoinf, " ."habilitarsite " ."from tabpct2 where pacote='". $pacote*1 ."' and conjugar='". $tabpct1->fields['ordem']*1 ."' "; $tabpct2->Execute($sql); if((!$tabpct2->EOF)&&($atualizaPrecos*1==0)){ $precovendadbl = tostring($tabpct2->fields['precovendadbl']); $precovendatpl = tostring($tabpct2->fields['precovendatpl']); $precovendasgl = tostring($tabpct2->fields['precovendasgl']); $precovendachd = tostring($tabpct2->fields['precovendachd']); $precovendachl = tostring($tabpct2->fields['precovendachl']); $precovendainf = tostring($tabpct2->fields['precovendainf']); $habilitar=$tabpct2->fields['habilitarsite']*1; if($habilitar*1>0){$checked='checked';}else{$checked='';} }else{ $precovendadbl = tostringN(($tarifadbl + $totaldbl)*$zeradbl); $precovendatpl = tostringN(($tarifatpl + $totaltpl)*$zeratpl); $precovendasgl = tostringN(($tarifasgl + $totalsgl)*$zerasgl); $precovendachd = tostringN(($tarifachd + $totalchd)*$zerachd); $precovendachl = tostringN(($tarifachl + $totalchl)*$zerachl); $precovendainf = tostringN(($tarifainf + $totalinf)*$zerainf); $habilitar=1; $checked='checked'; } $descontodbl=$tabpct2->fields['descontoacrescimodbl']; $descontotpl=$tabpct2->fields['descontoacrescimotpl']; $descontosgl=$tabpct2->fields['descontoacrescimosgl']; $descontochd=$tabpct2->fields['descontoacrescimochd']; $descontochl=$tabpct2->fields['descontoacrescimochl']; $descontoinf=$tabpct2->fields['descontoacrescimoinf']; //DBL if($chkdispDBL*1==0){ $dbl = 'NA'; $dblextra = 'NA'; $compradbl='NA'; }else{ $dbl = tostringN(($tarifadbl + $totaldbl + $descontodbl)*$zeradbl); $dblextra = tostringN($tarifadblextra); $compradbl=tostringN(($compratarifadbl + $compratotaldbl)*$zeradbl); } //TPL if($chkdispTPL*1==0){ $tpl = 'NA'; $tplextra = 'NA'; $compratpl='NA'; }else{ $tpl = tostringN(($tarifatpl + $totaltpl + $descontotpl)*$zeratpl); $tplextra = tostringN($tarifatplextra); $compratpl=tostringN(($compratarifatpl + $compratotaltpl)*$zeratpl); } //SGL if($chkdispSGL*1==0){ $sgl = 'NA'; $sglextra = 'NA'; $comprasgl='NA'; }else{ $sgl = tostringN(($tarifasgl + $totalsgl + $descontosgl)*$zerasgl); $sglextra = tostringN($tarifasglextra); $comprasgl=tostringN(($compratarifasgl + $compratotalsgl)*$zerasgl); } //CHD if($chkdispCHD*1==0){ $chd = 'NA'; $chdextra = 'NA'; $comprachd='NA'; }else{ $chd = tostringN(($tarifachd + $totalchd + $descontochd)*$zerachd); $chdextra = tostringN($tarifachdextra); $comprachd=tostringN(($compratarifachd + $compratotalchd)*$zerachd); } //CHL if($chkdispCHL*1==0){ $chl = 'NA'; $chlextra = 'NA'; $comprachl='NA'; }else{ $chl = tostringN(($tarifachl + $totalchl + $descontochl)*$zerachl); $chlextra = tostringN($tarifachlextra); $comprachl=tostringN(($compratarifachl + $compratotalchl)*$zerachl); } //INF if($chkdispINF*1==0){ $inf = 'NA'; $infextra = 'NA'; $comprainf='NA'; }else{ $inf = tostringN(($tarifainf + $totalinf + $descontoinf)*$zerainf); $infextra = tostringN($tarifainfextra); $comprainf=tostringN(($compratarifainf + $compratotalinf)*$zerainf); } $f==1;?> i fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['galho1a']*1!=1){ ?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?> fields['sigla']?>
MoveNext(); } ?>