public function somaCrianca12()
 {
     //$html = "<h4>this->crianca12_tmp: $this->crianca12_tmp<h4>";
     $html = "";
     if ($this->crianca12_tmp != 0) {
         $crianca_12 = $this->crianca12_tmp;
         $perc_crianca_12 = $crianca_12 * 30;
         if ((int) $this->total_dia_semana != 0) {
             $soma1 = round((int) $this->total_dia_semana / 100 * $perc_crianca_12);
         } else {
             $soma1 = 0;
         }
         if ((int) $this->total_fim_semana != 0) {
             $soma2 = round((int) $this->total_fim_semana / 100 * $perc_crianca_12);
         } else {
             $soma2 = 0;
         }
         $str = $this->getLabel('LABEL_ACRESCIMO');
         $str = str_replace("%", "{$perc_crianca_12}%", $str);
         $soma_crianca_12 = $soma1 + $soma2;
         $this->total_acrescimo($soma_crianca_12);
         $this->total = (int) $this->total + (int) $soma_crianca_12;
         $this->total_formatado = $this->formataReais($this->total);
         $html .= "(Base 30%) = " . $str . " ( " . $crianca_12 . " " . $this->getLabel('LABEL_CRIANCAS_ACIMA12_2') . ") =&nbsp;" . $this->moeda . " " . formataReais($soma_crianca_12);
         $crianca_12_perc = 30;
         $crianca_12_perc_mult = $perc_crianca_12;
         $crianca_12_valor = $soma_crianca_12;
         $crianca_12_excedente = $this->crianca12_tmp;
         return $html;
     } else {
         return false;
     }
 }
            $html .= "<div class='ResetFloat'></div>";
            $html .= "<div class='LabelAcomodacaoTitle left'>{$str} ( {$crianca_6_12} " . getLabel('LABEL_CRIANCAS_6A12_2', $_SESSION['LANGUAGE']) . ") =&nbsp;</span></div>";
            $html .= "<div class='LabelAcomodacaoTitle left'>R\$ " . formataReais($soma_crianca_6_12) . "</span></div>";
            $valor_4 = $soma_crianca_6_12 + $valor_4;
            $CRIANCA_6A12_PERC = 15;
            $CRIANCA_6A12_PERC_MULT = $perc_crianca_6_12;
            $CRIANCA_6A12_VALOR = $CRIANCA_6A12_VALOR + $soma_crianca_6_12;
            $CRIANCA_6A12_EXCEDENTE = $CRIANCA_6A12_EXCEDENTE + $crianca_6_12;
        }
        $html .= "<div class='ResetFloat'></div>";
        if ($soma_crianca_12 != 0) {
            $crianca_12 = $soma_crianca_12;
            $perc_crianca_12 = $soma_crianca_12 * 30;
            $dias == 1 ? $valor_pacote = $tqts->VALOR : ($valor_pacote = $valor_4);
            $valor_pacote_1_perc = $valor_pacote / 100;
            $soma_crianca_12 = round($valor_pacote_1_perc * $perc_crianca_12);
            $str = getLabel('LABEL_ACRESCIMO', $_SESSION['LANGUAGE']);
            $str = str_replace("%", "{$perc_crianca_12}%", $str);
            $html .= "<div class='ResetFloat'></div>";
            $html .= "<div class='LabelAcomodacaoTitle left'>{$str} ( {$crianca_12} " . getLabel('LABEL_CRIANCAS_ACIMA12_2', $_SESSION['LANGUAGE']) . ") =&nbsp;</span></div>";
            $html .= "<div class='LabelAcomodacaoTitle left'>R\$ " . formataReais($soma_crianca_12) . "</span></div>";
            $valor_4 = $soma_crianca_12 + $valor_4;
            $CRIANCA_12_PERC = 30;
            $CRIANCA_12_PERC_MULT = $perc_crianca_12;
            $CRIANCA_12_VALOR = $CRIANCA_12_VALOR + $soma_crianca_12;
            $CRIANCA_12_EXCEDENTE = $CRIANCA_12_EXCEDENTE + $crianca_12;
        }
    }
    $html .= "</div>";
    $html .= "<div class='ResetFloat'></div>";
}
                }
                $count == 0 ? $display = "display: block;" : ($display = "display: none;");
                /*
																		 $html .= "<div class='$quarto_tipo->CODQUARTOTIPO'data-fancybox-group='gallery' title='$quarto_tipo->NOME $titulo' style='$display;'>";
																		 $html .= "<img src='$foto->URL' alt='$quarto_tipo->NOME $titulo' />";
																		 $html .= "<a href='$foto->URL' class='melhores-icon'><span></span></a>";
																		 $html .= "</div>";
																		 
																*/
                $html .= "<div class='{$quarto_tipo->CODQUARTOTIPO}' href='{$foto->URL}' data-fancybox-group='gallery' title='{$quarto_tipo->NOME} {$titulo}' style='{$display}'>";
                $html .= "<img src='{$foto->URL}' alt='{$quarto_tipo->NOME} {$titulo}' />";
                $html .= "<a href='{$foto->URL}' class='melhores-icon'><span></span></a>";
                $html .= "</div>";
                $count++;
            }
        }
        $html .= "</p>";
        $html .= "</div>";
        $html .= "</div>";
        $html .= "<div class='TopQuartoReserva'>";
        $html .= "<div class='ResultQuatosTableTRTitle'>{$quarto_tipo->NOME}</div>";
        $quarto_tipo->VALOR == "0" || $quarto_tipo->VALOR == null ? $quarto_tipo->VALOR = "0,00" : ($quarto_tipo->VALOR = formataReais($quarto_tipo->VALOR));
        $html .= "<div class='DiariaLabel'>" . getLabel('LABEL_DIARIA', $_SESSION['LANGUAGE']) . ": <span class='DiariaPreco'>R\$ {$quarto_tipo->VALOR}</div>";
        //$html .= "<div class='DiariaLabel'>Capacidade: <span class='DiariaPreco'>$quarto_tipo->PESSOAS ".getLabel('LABEL_PESSOAS', $_SESSION['LANGUAGE'])."</span></div>";
        $html .= "</div>";
        $html .= "</div>";
        $html .= "<div class='ResetFloat'></div>";
        $html .= "<div class='ReservaDescript' id='ReservaDescriptId_{$quarto_tipo->CODQUARTO}'>";
        $html .= "<input type='hidden' id='ReservaDescriptInputHidden_{$quarto_tipo->CODQUARTO}' value='{$i}'/>";
        $html .= "<div class='acord_each'>";
        $html .= "<div class='acord_title' id='ReservaDescript_{$quarto_tipo->CODQUARTO}' class='btn_azul font14'>" . getLabel('LABEL_MAISINFO', $_SESSION['LANGUAGE']) . "</div>";
                $s = limpaValorReal($_POST["VALOR_TOTAL"]);
                $result = mysql_query("SELECT ROUND({$s}/2) AS RES;");
                while ($row = mysql_fetch_object($result)) {
                    $piece .= " " . formataReais($row->RES);
                }
                //$piece .= " ".formataReais($_POST["PGTO_SINAL"]);
                //$piece .= " ";
                break;
            case 13:
                $piece .= " " . formataReais($_POST["VALOR_TOTAL"]);
                break;
            case 14:
                $s = limpaValorReal($_POST["VALOR_TOTAL"]);
                $result = mysql_query("SELECT ROUND({$s}/2) AS RES;");
                while ($row = mysql_fetch_object($result)) {
                    $piece .= " " . formataReais($row->RES);
                }
                //$piece .= " ".formataReais($_POST["PGTO_SINAL"]);
                break;
        }
        $i++;
    }
}
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = "smtps.bol.com.br";
$mail->Port = 587;
$mail->SMTPAuth = true;
$mail->Username = "******";
$mail->Password = '******';
$mail->From = "*****@*****.**";
*/
$html .= "<div class='ReservaTotalli'><span class='DiariaLabel'><span class='DiariaPreço right' id='adultosExcedentesFinalize'>0</span> " . getLabel('LABEL_EXCEDENTES', $_SESSION['LANGUAGE']) . "</div>";
//$html .= "<div class='ReservaTotalli'><span class='DiariaLabel'><span class='DiariaPreço right' id='adultosExcedentesFinalizeValor'><span class='DiariaPreço right'><i>0,00<i></span></span> ".getLabel('LABEL_ADULTOS_EXCEDENTES_VALOR', $_SESSION['LANGUAGE'])."</div>";
$criancas = $_POST["criancas_5a"] + $_POST["criancas_6a12"] + $_POST["criancas_acima12"];
if ($criancas == '') {
    $criancas = 0;
}
$html .= "<div class='ReservaTotalli'><span class='DiariaPreço right' id='adultosCriancas'>{$criancas}</span> <span class='DiariaLabel'>" . getLabel('LABEL_CRIANCAS', $_SESSION['LANGUAGE']) . "</div>";
if ($_POST["nQuartos"] == '') {
    $_POST["nQuartos"] = "<span class='DiariaPreço right' ><i>" . getLabel('LABEL_NAO_INFORMADO', $_SESSION['LANGUAGE']) . "<i></span>";
}
$html .= "<div class='ReservaTotalli'><span class='DiariaPreço right' id='quartosFinalize'>" . $_POST["nQuartos"] . "</span> <span class='DiariaLabel'>" . getLabel('LABEL_QUARTOS', $_SESSION['LANGUAGE']) . "</div>";
if ($valor == '') {
    $valor = "<span class='DiariaPreço right' id='totalFinalize'><i>0,00<i></span>";
} else {
    $valor = "<span class='DiariaPreço right' id='totalFinalize'><i>" . formataReais($valor) . "<i></span>";
}
$html .= "<div class='ReservaTotalli' style='display: none'><span class='DiariaLabel'>" . getLabel('LABEL_VALOR_TOTAL', $_SESSION['LANGUAGE']) . ": R\$ <span class='DiariaPreço'>" . $valor . "</span></div>";
$html .= "<div class='ReservaPreload' id='ReservaPreloadSubmit' onclick=\"javascript: getParameterHidden();\">";
$html .= "<div class='ReservaTotalliBtn' id='ReservaTotalliBtn'>";
$html .= "<input class='DiariaReserva' type='submit' id='AjaxSubmit' value='" . getLabel('LABEL_PROXIMO', $_SESSION['LANGUAGE']) . "'/>";
$html .= "</div>";
$html .= "</div>";
$html .= "<div class='ReservaPreload' id='ReservaPreload'>";
$html .= "<img src='../image/preload.gif' alt='' border=''/>";
$html .= "</div>";
$html .= "<div class='ErroAjaxMassage' id='ErroAjaxMassage'></div>";
$html .= "<div>";
$html .= "<input type='hidden' name='SomaQuartos' id='SomaQuartos' value='0'/>";
$html .= "<input type='hidden' name='SomaTotal' id='SomaTotal' value='0,00'/>";
$html .= "<input type='hidden' name='somaCriancas' id='somaCriancas' value='0'/>";
        $ispgto = "<span class='AtivoStatus' onclick=\"javascript:getAlterstatusfull('{$qtos_tipo->CODEXTRA}', 'CODEXTRA', 'ISPGTO', 'extras', '" . getLabel('LABEL_JS_REGISTRO', $_SESSION['LANGUAGE']) . "')\">" . getLabel('LABEL_SIM', $_SESSION['LANGUAGE']) . "</span>";
    } else {
        $ispgto = "<span class='InativoStatus' onclick=\"javascript:getAlterstatusfull('{$qtos_tipo->CODEXTRA}', 'CODEXTRA', 'ISPGTO', 'extras', '" . getLabel('LABEL_JS_REGISTRO', $_SESSION['LANGUAGE']) . "')\">" . getLabel('LABEL_NAO', $_SESSION['LANGUAGE']) . "</span>";
    }
    if ($i % 2 == 0) {
        $pi .= "<tr class='LinhaPar'>";
    } else {
        $pi .= "<tr class='LinhaImpar'>";
    }
    $pi .= "<td align='right'><input type='checkbox' name='{$qtos_tipo->CODEXTRA}'/></td>";
    $pi .= "<td>{$qtos_tipo->DTA}</td>";
    (string) ($nome = getlinguagemdasessao());
    $pi .= "<td>" . $qtos_tipo->{$nome} . "</td>";
    $pi .= "<td align='center'>{$ispgto}</td>";
    $pi .= "<td align='center'>{$disponivel}</td>";
    $qtos_tipo->VALOR == '0' || $qtos_tipo->VALOR == "" ? $pi .= "<td align='center'>0,00</td>" : ($pi .= "<td align='center'>" . formataReais($qtos_tipo->VALOR) . "</td>");
    $pi .= "<td align='center'><input type='text' name='_{$qtos_tipo->CODEXTRA}' value='{$qtos_tipo->QUANTIDADE}' style='width: 20px' maxlength='3' onkeypress='return formataNumDV(event, this, 3);'/></td>";
    $pi .= "<td align='center'>{$status}</td>";
    $owner = mysql_query("SELECT login.LOGIN FROM login\r\r\t\t\t\t\t\t\t\t\tINNER JOIN login_rel_pessoa ON login_rel_pessoa.CODLOGIN=login.CODLOGIN\r\r\t\t\t\t\t\t\t\t\tWHERE login_rel_pessoa.CODPESSOA='{$qtos_tipo->OWNER}'");
    $owner = mysql_fetch_object($owner);
    $pi .= "<td>{$owner->LOGIN}</td>";
    $pi .= "</tr>";
    $i++;
}
$pi .= "</table>";
$pi .= "</div>";
$pi .= "</td>";
$pi .= "</tr>";
$pi .= "</table>";
$pi .= "</div>";
$pi .= "<div><input type='hidden' value='ACTION' name='ACTION'/></div>";
								$status = "<span class='AtivoStatus' onclick=\"javascript:getAlterstatusfull('$qtos_tipo->CODDICA', 'CODDICA', 'STATUS', 'dicas', '".getLabel('LABEL_JS_REGISTRO', $_SESSION['LANGUAGE'])."')\">".getLabel('LABEL_ATIVO', $_SESSION['LANGUAGE'])."</span>";
							} 
							else 
							{
								$status = "<span class='InativoStatus' onclick=\"javascript:getAlterstatusfull('$qtos_tipo->CODDICA', 'CODDICA', 'STATUS', 'dicas', '".getLabel('LABEL_JS_REGISTRO', $_SESSION['LANGUAGE'])."')\">".getLabel('LABEL_INATIVO', $_SESSION['LANGUAGE'])."</span>";
							}
							*/
    if ($i % 2 == 0) {
        $pi .= "<tr class='LinhaPar'>";
    } else {
        $pi .= "<tr class='LinhaImpar'>";
    }
    $pi .= "<td align='right'><input type='checkbox' name='{$qtos_tipo->CODDICA}'/></td>";
    $pi .= "<td>{$qtos_tipo->DTA}</td>";
    $pi .= "<td>" . compliteCod($qtos_tipo->N_CONHECIMENTO) . "</td>";
    $pi .= "<td>" . formataDataForBrazil($qtos_tipo->DTAINICIO) . "</td>";
    $pi .= "<td>" . formataDataForBrazil($qtos_tipo->DTAFIM) . "</td>";
    //$pi.= "<td align='center'><input type='text' name='_$qtos_tipo->CODDICA' value='$qtos_tipo->ORDEM' style='width: 20px' maxlength='3' onkeypress='return formataNumDV(event, this, 3);'/></td>";
    switch ((int) $qtos_tipo->STATUS) {
        case 0:
            $status = "Aguardando confirmaÁ„o da reserva";
            break;
    }
    $pi .= "<td>R\$ " . formataReais(round($qtos_tipo->VALOR_TOTAL / 2)) . "</td>";
    $pi .= "<td>R\$ " . formataReais($qtos_tipo->VALOR_TOTAL) . "</td>";
    $pi .= "<td>{$status}</td>";
    $owner = mysql_query("SELECT login.LOGIN FROM login\r\r\t\t\t\t\t\t\t\t\tINNER JOIN login_rel_pessoa ON login_rel_pessoa.CODLOGIN=login.CODLOGIN\r\r\t\t\t\t\t\t\t\t\tWHERE login_rel_pessoa.CODPESSOA='{$qtos_tipo->OWNER}'");
    $owner = mysql_fetch_object($owner);
    $pi .= "<td>{$owner->LOGIN}</td>";
    $pi .= "</tr>";
    $i++;
 if(mysql_num_rows($diff) != 0)
 {
 	$diff = mysql_fetch_object($diff);
 	($diff->DiffDate == "1")
 	? $html .= "<div class='pacotes_noites'>".$diff->DiffDate." ".getLabel('LABEL_NOITE', $_SESSION['LANGUAGE'])."</div>" 
 	: $html .= "<div class='pacotes_noites'>".$diff->DiffDate." ".getLabel('LABEL_NOITES', $_SESSION['LANGUAGE'])."</div>"; 
 }
 */
 $html .= "<div class='pacotes_data'>" . $pacote->DTAINICIOBRAZIL . " a " . $pacote->DTAFIMBRAZIL . "</div>";
 $html .= "</div>";
 $html .= "<div>";
 $html .= $pacote->DESCRICAO;
 $html .= "</div>";
 $html .= "</div>";
 $html .= "<div class='pacotes_right'>";
 $html .= "<div class='valor'><strong>R\$</strong> " . formataReais($pacote->VALOR_PARA) . "</div>";
 /*
  * inicio do formulario			
  */
 //$html .= "<form  onSubmit='return false' id='formReserva_".$i."' name='formReserva' method='post' action='$dados_relevantes->HTTPS/index.php?actionType=reservas.form.submit'>";
 $html .= "<form  onSubmit='return false' id='formReserva_" . $i . "' name='formReserva' method='post' action='{$dados_relevantes->HTTP}/contato'>";
 /*
 $html .= "<input type='hidden' name='language_".$i."' id='language_".$i."' value='".$_SESSION["LANGUAGE"]."'/>";
 $html .= "<input type='hidden' name='dtainicio_".$i."' id='dtainicio_".$i."' value='".$pacote->DTAINICIOBRAZIL."'/>";
 $html .= "<input type='hidden' name='dtafim_".$i."' id='dtafim_".$i."' value='".$pacote->DTAFIMBRAZIL."' />";
 $html .= "<input type='hidden' name='codquartotipo' id='codquartotipo' value='".$pacote->CODQUARTOTIPO."' />";
 $html .= "<input type='hidden' name='codpacote' id='codpacote' value='".$pacote->CODPACOTE."' />";
 
 $html .= "<div class='pacotes_select_pessoas field_reserva'>";
                           $html .= "<div class='field_reserva-text'>".getLabel('LABEL_ADULTOS', $_SESSION['LANGUAGE'])."</div>";
                           $html .= "<select name='adulto_".$i."' id='adulto_".$i."' class='pte_pessoas field_reserva-select'>";
Esempio n. 9
0
function trataValorMoedaReal($real)
{
    if (substr_count($real, '-') == 1) {
        $real = str_replace("-", "", $real);
        $real = "<font color='red'>- " . formataReais($real) . "</font>";
        return $real;
    } else {
        return formataReais($real);
    }
}
    }
    $html .= "</div>";
}
if ($_POST["screen_option_3_ok"] == "NOACTION") {
    $tqts = mysql_query("SELECT \r\t\t\t\t\t\t\t\t\t\tquartos_tipo.CODQUARTOTIPO,\r\t\t\t\t\t\t\t\t\t\tquartos_tipo.NOME,\r\t\t\t\t\t\t\t\t\t\tquartos_tipo.SIGLA,\r\t\t\t\t\t\t\t\t\t\tquartos_tipo.VALOR\r\t\t\t\t\t\t\t\t\tFROM\r\t\t\t\t\t\t\t\t\t\tquartos_tipo\r\t\t\t\t\t\t\t\t\tWHERE quartos_tipo.CODQUARTOTIPO='" . $_POST["select_quarto_tipo_3"] . "'\r\t\t\t\t\t\t\t\t\tGROUP BY quartos_tipo.CODQUARTOTIPO \r\t\t\t\t\t\t\t\t\tORDER BY (quartos_tipo.ORDEM+0) ASC");
    if (mysql_num_rows($tqts) != 0) {
        $tqts = mysql_fetch_object($tqts);
    }
    $html .= "<div class='painel'>";
    $html .= "<div class='Acomodacoes painel-label'>";
    $html .= getLabel('LABEL_ACOMODACAO', $_SESSION['LANGUAGE']) . " (4)";
    $html .= "</div>";
    $html .= "<div class='ResetFloat' style='margin-bottom: 3%'></div>";
    $html .= "<div class='LabelAcomodacaoTitle textright'>{$tqts->NOME}</span></div>";
    $html .= "<div class='ResetFloat'></div>";
    $html .= "<div class='LabelAcomodacaoTitle textright'>R\$ " . formataReais($tqts->VALOR) . "</span></div>";
    $html .= "<div class='ResetFloat' style='margin-bottom: 3%'></div>";
    for ($i = 0; $i < (int) $_POST["screen_pessoa_3"]; $i++) {
        $html .= "<div class='EntradaText'>";
        $html .= "<input type='text' value='' style='width: 328px;' class='falecom inp-nome' name='quarto_4_text_name_" . $i . "' id='quarto_4_text_name_" . $i . "' placeholder='" . getLabel('LABEL_NAME', $_SESSION['LANGUAGE']) . "'/>";
        $html .= "<select name='quarto_4_select_" . $i . "' id='quarto_4_select_" . $i . "' style='width: 180px !important'>";
        $html .= "<option value='0'>" . getLabel('LABEL_ADULTO', $_SESSION['LANGUAGE']) . "</option>";
        $html .= "<option value='1'>" . getLabel('LABEL_CRIANCAS_5ANOS_2', $_SESSION['LANGUAGE']) . "</option>";
        $html .= "<option value='2'>" . getLabel('LABEL_CRIANCAS_6A12_2', $_SESSION['LANGUAGE']) . "</option>";
        $html .= "<option value='3'>" . getLabel('LABEL_CRIANCAS_ACIMA12_2', $_SESSION['LANGUAGE']) . "</option>";
        $html .= "</select>";
        $html .= "</div>";
    }
    $html .= "</div>";
}
$html .= "<div class='painel'>";
 if ($qtos_tipo->STATUS == "1") {
     $status = "<span class='AtivoStatus' onclick=\"javascript:getAlterstatusfull('{$qtos_tipo->CODQUARTOTIPO}', 'CODQUARTOTIPO', 'STATUS', 'quartos_tipo', '" . getLabel('LABEL_JS_REGISTRO', $_SESSION['LANGUAGE']) . "')\">" . getLabel('LABEL_ATIVO', $_SESSION['LANGUAGE']) . "</span>";
 } else {
     $status = "<span class='InativoStatus' onclick=\"javascript:getAlterstatusfull('{$qtos_tipo->CODQUARTOTIPO}', 'CODQUARTOTIPO', 'STATUS', 'quartos_tipo', '" . getLabel('LABEL_JS_REGISTRO', $_SESSION['LANGUAGE']) . "')\">" . getLabel('LABEL_INATIVO', $_SESSION['LANGUAGE']) . "</span>";
 }
 if ($i % 2 == 0) {
     $pi .= "<tr class='LinhaPar'>";
 } else {
     $pi .= "<tr class='LinhaImpar'>";
 }
 $pi .= "<td align='right'><input type='checkbox' name='{$qtos_tipo->CODQUARTOTIPO}'/></td>";
 $pi .= "<td>{$qtos_tipo->DTA}</td>";
 $pi .= "<td>{$qtos_tipo->NOME}</td>";
 $pi .= "<td>{$qtos_tipo->SIGLA}</td>";
 $qtos_tipo->VALOR == "0" || $qtos_tipo->VALOR == null ? $qtos_tipo->VALOR = "0,00" : ($qtos_tipo->VALOR = formataReais($qtos_tipo->VALOR));
 $qtos_tipo->VALOR_FINAL == "0" || $qtos_tipo->VALOR_FINAL == null ? $qtos_tipo->VALOR_FINAL = "0,00" : ($qtos_tipo->VALOR_FINAL = formataReais($qtos_tipo->VALOR_FINAL));
 $qtos_tipo->VALOR_MEDIA == "0" || $qtos_tipo->VALOR_MEDIA == null ? $qtos_tipo->VALOR_MEDIA = "0,00" : ($qtos_tipo->VALOR_MEDIA = formataReais($qtos_tipo->VALOR_MEDIA));
 $qtos_tipo->VALOR_MEDIA_FINAL == "0" || $qtos_tipo->VALOR_MEDIA_FINAL == null ? $qtos_tipo->VALOR_MEDIA_FINAL = "0,00" : ($qtos_tipo->VALOR_MEDIA_FINAL = formataReais($qtos_tipo->VALOR_MEDIA_FINAL));
 $qtos_tipo->VALOR_BAIXA == "0" || $qtos_tipo->VALOR_BAIXA == null ? $qtos_tipo->VALOR_BAIXA = "0,00" : ($qtos_tipo->VALOR_BAIXA = formataReais($qtos_tipo->VALOR_BAIXA));
 $qtos_tipo->VALOR_BAIXA_FINAL == "0" || $qtos_tipo->VALOR_BAIXA_FINAL == null ? $qtos_tipo->VALOR_BAIXA_FINAL = "0,00" : ($qtos_tipo->VALOR_BAIXA_FINAL = formataReais($qtos_tipo->VALOR_BAIXA_FINAL));
 $pi .= "<td align='center'>{$status}</td>";
 $owner = mysql_query("SELECT login.LOGIN FROM login\r\r\t\t\t\t\t\t\t\t\tINNER JOIN login_rel_pessoa ON login_rel_pessoa.CODLOGIN=login.CODLOGIN\r\r\t\t\t\t\t\t\t\t\tWHERE login_rel_pessoa.CODPESSOA='{$qtos_tipo->OWNER}'");
 $owner = mysql_fetch_object($owner);
 $pi .= "<td>{$owner->LOGIN}</td>";
 $pi .= "<td align='center'><input type='text' name='_{$qtos_tipo->CODQUARTOTIPO}' value='{$qtos_tipo->ORDEM}' style='width: 20px' maxlength='3' onkeypress='return formataNumDV(event, this, 3);'/></td>";
 $pi .= "</tr>";
 $pi .= "<tr>";
 $pi .= "<td colspan='7'>";
 $pi .= "<table>";
 $pi .= "<tr>";
 $pi .= "<td colspan='2'>" . getLabel('LABEL_ALTA_TEMPORADA', $_SESSION['LANGUAGE']) . "</td>";
                    $piece .= getLabel('LABEL_CARTAO_CREDITO', $_SESSION['LANGUAGE']);
                }
                break;
            case 12:
                $s = limpaValorReal($_POST["VALOR_TOTAL"]);
                $result = mysql_query("SELECT ROUND({$s}/2) AS RES;");
                while ($row = mysql_fetch_object($result)) {
                    $piece .= " " . formataReais($row->RES);
                }
                //$piece .= " ".formataReais($_POST["PGTO_SINAL"]);
                break;
            case 13:
                $piece .= " " . formataReais($_POST["VALOR_TOTAL"]);
                break;
            case 14:
                $piece .= " " . formataReais($_POST["PGTO_SINAL"]);
                break;
        }
        $i++;
    }
}
$quebra_linha = "\n";
$emailsender = "*****@*****.**";
$nomeremetente = "Pousada Maravista";
$emaildesitnatario = $_POST["email"];
$nomedesitnatario = $_POST["nome_empresa"];
$comcopia = "*****@*****.**";
$assunto = getLabel('LABEL_PRE_RESERV_CONFIRM_2', $_SESSION['LANGUAGE']) . " - Cod: " . $_POST["N_CONHECIMENTO"];
$assunto = "=?UTF-8?B?" . base64_encode($assunto) . "?=";
$mensagemHTML = $piece;
$headers = "MIME-Version: 1.1{$quebra_linha}";
    $acomodacoes = mysql_query("SELECT \r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tquartos.NOME as QUARTO, quartos_tipo.NOME as TIPO, reservas_rel_quartos.REFERENCIA\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM quartos_tipo\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN quartos_rel_quartos_tipo ON quartos_rel_quartos_tipo.CODQUARTOTIPO=quartos_tipo.CODQUARTOTIPO\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN quartos ON quartos_rel_quartos_tipo.CODQUARTO=quartos.CODQUARTO\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN reservas_rel_tipo_quarto ON reservas_rel_tipo_quarto.CODTIPOQUARTO=quartos_rel_quartos_tipo.CODQUARTOTIPO\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN reservas_rel_quartos ON reservas_rel_quartos.CODQUARTO=quartos.CODQUARTO\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE reservas_rel_quartos.CODRESERVA='" . $_GET["codreserva"] . "'\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND reservas_rel_tipo_quarto.CODRESERVA='" . $_GET["codreserva"] . "'\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY reservas_rel_quartos.REFERENCIA\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY (reservas_rel_quartos.REFERENCIA+0) ASC");
    if (mysql_num_rows($acomodacoes) != 0) {
        $i = 1;
        while ($acomodacao = mysql_fetch_object($acomodacoes)) {
            $pi .= "<div>{$i}. ({$acomodacao->TIPO}) {$acomodacao->QUARTO}</div>";
            $guests = mysql_query("SELECT guest.CODGUEST, guest.NOME, guest.FAIXA_ETARIA FROM guest\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN reservas_rel_guest ON reservas_rel_guest.CODGUEST=guest.CODGUEST\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN reservas ON reservas_rel_guest.CODRESERVA=reservas.CODRESERVA\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE reservas_rel_guest.REFERENCIA={$acomodacao->REFERENCIA}\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND reservas.CODRESERVA='" . $_GET["codreserva"] . "'\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tGROUP BY guest.CODGUEST\r\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY FAIXA_ETARIA ASC");
            $pi .= "<ol style='list-style-type: lower-roman'>";
            while ($guest = mysql_fetch_object($guests)) {
                switch ($guest->FAIXA_ETARIA) {
                    case '0':
                        $guest->FAIXA_ETARIA = "(" . getLabel('LABEL_ADULTO', $_SESSION['LANGUAGE']) . ")";
                        break;
                    case '1':
                        $guest->FAIXA_ETARIA = "(" . getLabel('LABEL_CRIANCAS_5ANOS_2', $_SESSION['LANGUAGE']) . ")";
                        break;
                    case '2':
                        $guest->FAIXA_ETARIA = "(" . getLabel('LABEL_CRIANCAS_6A12_2', $_SESSION['LANGUAGE']) . ")";
                        break;
                    case '3':
                        $guest->FAIXA_ETARIA = "(" . getLabel('LABEL_CRIANCAS_ACIMA12_2', $_SESSION['LANGUAGE']) . ")";
                        break;
                }
                $pi .= "<li>{$guest->NOME} {$guest->FAIXA_ETARIA}</li>";
            }
            $pi .= "</ol>";
            $i++;
        }
    }
    $pi .= "</td>";
    $pi .= "</tr>";
}
    $html .= "</table>";
}
//alta temporada
$html .= "<div class='blog_header'>";
$html .= "<ul class='left'>";
$html .= "<li class=''><strong>" . getLabel('LABEL_ALTA_TEMPORADA', $_SESSION['LANGUAGE']) . "</strong><br>" . formataDataForBrazil($dados_relevantes->DTA_INICIO_ALTA) . " " . getLabel('LABEL_ATE', $_SESSION['LANGUAGE']) . " " . formataDataForBrazil($dados_relevantes->DTA_FIM_ALTA) . "</li>";
$html .= "<li style='padding-left:12px'></li>";
$html .= "</ul>";
$html .= "<ul class='blog_labels'>";
$html .= "<li>" . getLabel('LABEL_SEGASEX', $_SESSION['LANGUAGE']) . "</li>";
$html .= "<li>" . getLabel('LABEL_SABADOM', $_SESSION['LANGUAGE']) . "</li>";
$html .= "</ul>";
$html .= "</div>";
$html .= "<div class='sep-pattern-1'></div>";
$quarto_tipos = mysql_query("\r\n\t\t\tSELECT \r\n\t\t\t\tquartos_tipo.*, \r\n\t\t\t\tquartos_tipo.NOME as TIPO, \r\n\t\t\t\tdescricao." . $_SESSION["LANGUAGE"] . " as DESCRICAO,\r\n\t\t\t\tfotos.URL,\r\n\t\t\t\tfotos.TITULO\r\n\t\t\tFROM quartos_tipo\r\n\t\t\tINNER JOIN quartos_tipo_rel_descricao ON quartos_tipo_rel_descricao.CODQUARTOTIPO=quartos_tipo.CODQUARTOTIPO\r\n\t\t\tINNER JOIN descricao ON descricao.CODDESCRICAO=quartos_tipo_rel_descricao.CODDESCRICAO\r\n\t\t\tINNER JOIN quartos_tipo_rel_fotos ON quartos_tipo_rel_fotos.CODQUARTOTIPO=quartos_tipo.CODQUARTOTIPO\r\n\t\t\tINNER JOIN fotos ON quartos_tipo_rel_fotos.CODFOTO=fotos.CODFOTO\r\n\t\t\tWHERE \r\n\t\t\tquartos_tipo.STATUS=1\r\n\t\t\tAND fotos.STATUS=1\r\n\t\t\tAND fotos.DESTAQUE=1\r\n\t\t\tORDER BY (quartos_tipo.ORDEM+0) ASC\r\n\t\t");
if (mysql_num_rows($quarto_tipos) != 0) {
    $html .= "<table class='fotos_container'>";
    while ($qtp = mysql_fetch_object($quarto_tipos)) {
        $html .= "<tr class='post_simples'>";
        $html .= "<td><input type='button' onclick='location.href=\"index.php?actionType=reservas\" ' value='" . getLabel('LABEL_MAIS', $_SESSION['LANGUAGE']) . "'class='BtnFiltro small'/></td>";
        $html .= "<td class='post_simples_titulo'>" . $qtp->TIPO . "</td>";
        $html .= "<td class='fotos_descricao blog_tarifas' >";
        $html .= "<div class='blog_colbaixa blog_col temporada valor'><strong>R\$</strong> " . formataReais($qtp->VALOR) . "</div>";
        $html .= "</td>";
        $html .= "<td class='fotos_descricao blog_tarifas last' >";
        $html .= "<div class='blog_col_alta blog_col temporada valor'><strong>R\$</strong> " . formataReais($qtp->VALOR_FINAL) . "</div>";
        $html .= "</td>";
        $html .= "</tr>";
    }
    $html .= "</table>";
}
$html .= "<div class='col1 cnt-cc-number'>";
$html .= "<label for='cartaoNumero'>" . getLabel('LABEL_NUMBER_CARD', $_SESSION['LANGUAGE']) . "</label>";
$html .= "<input type='text' name='cartaoNumero' id='cartaoNumero' class='cc-numero' value='" . $_POST["cartaoNumero"] . "' placeholder='" . getLabel('LABEL_NUMERO_DO_CARTAO', $_SESSION['LANGUAGE']) . "' pattern='\\d*' required/>";
$html .= "<div class='card-cntr inactive'>";
$html .= "<div class='card card-visa'></div>";
$html .= "<div class='card card-master'></div>";
// $html .="<div class='card card-amex'></div>";
$html .= "<div class='card card-dinn'></div>";
$html .= "</div>";
$html .= "</div>";
$html .= "<div>";
$html .= "<div class='col2'>";
$html .= "<label for='cartaoValidade'>" . getLabel('LABEL_DATA_DE_VENCIMENTO', $_SESSION['LANGUAGE']) . "</label>";
$html .= "<td><input type='text' name='cartaoValidade' id='cartaoValidade' class='cc-exp' value='" . $_POST["cartaoValidade"] . "' placeholder='MM / AAAA' pattern='\\d*' maxlength='9' required/>";
$html .= "</div>";
$html .= "<div class='col2'>";
$html .= "<label>" . getLabel('LABEL_CODIGO_SEGURANCA', $_SESSION['LANGUAGE']) . "</label>";
$html .= "<td><input type='text' name='cartaoCodigoSeguranca' id='cartaoCodigoSeguranca' class='cc-cvc' value='" . $_POST["cartaoCodigoSeguranca"] . "' placeholder='CVC' pattern='\\d*' maxlength='4' autocomplete='off' required/>";
$html .= "</div>";
$html .= "<div class='col1'>";
$html .= "<label for='nomeTitulo'>" . getLabel('LABEL_NOME_TITULAR', $_SESSION['LANGUAGE']) . "</label>";
$html .= "<input type='text' name='nomeTitulo' id='nomeTitulo' value='" . $_POST["nomeTitulo"] . "' onkeypress=\"return caixaAlta();\" onkeyout=\"return caixaAlta();\" placeholder='" . getLabel('LABEL_NOME', $_SESSION['LANGUAGE']) . "' required/>";
$html .= "</div>";
$html .= "</div>";
$html .= "<div class='cont-footer' style='display:inline-block;width: 100%;margin-bottom:12px'>";
$html .= "<div class='cont-val-total left'>";
$html .= "<label for='val_total'>" . getLabel('LABEL_TOTAL', $_SESSION['LANGUAGE']) . " R\$ " . formataReais($_POST["VALOR_TOTAL"]) . "</label>";
$html .= "<h2 name='val_total'>50% = R\$ " . formataReais((int) $_POST["VALOR_TOTAL"] / 2) . "</h2>";
$html .= "</td>";
$html .= "</div>";
$html .= "<div class='cont-forma push-right'>";
$html .= "</div>";
/*
		
		
		["quarto_1_text_name_0"]=> string(7) "Rogeiro" 
		["quarto_1_select_0"]=> string(1) "0" 
		["quarto_1_text_name_1"]=> string(7) "Rogeiro" 
		["quarto_1_select_1"]=> string(1) "0" 
		["nome_empresa"]=> string(7) "Rogeiro" 
		["email"]=> string(7) "rogeiro" 
		["telefone"]=> string(7) "Rogeiro" 
		["observacoes"]=> string(14) "
		["termos"]=> string(2) "on" 
		["screen_option_0_ok"]=> string(8) "NOACTION" 
		["select_quarto_tipo_0"]=> string(32) "E8493102B7E20E78B162C13F4ABB668A" 
		["screen_pessoa_0"]=> string(1) "2" 
		["datainicio"]=> string(10) "10/01/2014" 
		["Prepara_datainicio"]=> string(10) "2014-01-10" 
		["Prepara_dtafim"]=> string(10) "2014-01-11" 
		["datafim"]=> string(10) "11/01/2014" 
		["Prepara_pessoas"]=> string(1) "2" 
		["Prepara_adultos"]=> string(1) "2" 
		["Prepara_criancas_5a"]=> string(1) "0" 
		["Prepara_criancas_6a12"]=> string(1) "0" 
		["Prepara_criancas_acima12"]=> string(1) "0" 
		["nQuartos"]=> string(1) "1" 
		["Prepara_nCrianca"]=> string(1) "0" 
		["ACTION"]=> string(6) "ACTION" 
		["ACTION_FINALIZE"]=> string(15) "ACTION_FINALIZE" 
		["ADULTO_PERC"]=> string(1) "0" 
		["ADULTO_PERC_MULT"]=> string(1) "0" 
            */
            case 10:
                if ($reserva->FORMA_PGTO == "1") {
                    $piece .= "<br/>" . getLabel('LABEL_DEPOSITO', $_SESSION['LANGUAGE']);
                }
                break;
            case 11:
                $s = limpaValorReal($total);
                $result = mysql_query("SELECT ROUND({$s}/2) AS RES;");
                while ($row = mysql_fetch_object($result)) {
                    $piece .= " " . formataReais($row->RES);
                }
                //$piece .= " ".formataReais($sinal);
                break;
            case 12:
                $piece .= " " . formataReais($total);
                break;
        }
        $i++;
    }
}
$quebra_linha = "\n";
$emailsender = "*****@*****.**";
$nomeremetente = "Pousada Maravista";
$emaildesitnatario = $_POST["email"];
$nomedesitnatario = $_POST["nome_empresa"];
$comcopia = "*****@*****.**";
$assunto = getLabel('LABEL_RESERVA_CANCELADA', $_SESSION['LANGUAGE']) . " - Cod: " . $_POST["N_CONHECIMENTO"];
$assunto = "=?UTF-8?B?" . base64_encode($assunto) . "?=";
$mensagemHTML = $piece;
$headers = "MIME-Version: 1.1{$quebra_linha}";
$pi .= "<div class='EntradaTextForm' id='InsertValor' style='display: {$display};'>";
$pi .= "<div class='Prom'>" . getLabel('LABEL_VALOR_PROM_PACOTES', $_SESSION['LANGUAGE']) . "</div>";
$pi .= "<div class='Userlabel'>" . getLabel('LABEL_VALOR_DE', $_SESSION['LANGUAGE']) . ":</div>";
$pi .= "<div>";
if (!empty($_POST) && isset($_POST['ACTION'])) {
    $pi .= "<input class='LiloginText' style='width: 250px'  type='text' id='valor_de' name='valor_de' value='" . $_POST['valor_de'] . "' maxlength='70' placeholder='" . getLabel('LABEL_VALOR_DE', $_SESSION['LANGUAGE']) . "'  maxlength='3' onkeypress='formataValor(event, this, 12);' onkeydown='backspaceFormataValor(event, this)'/>";
} else {
    $row->VALOR_DE == '0' || $row->VALOR_DE == '' ? $pi .= "<input class='LiloginText' style='width: 250px'  type='text' id='valor_de' name='valor_de' value='0,00' maxlength='70' placeholder='" . getLabel('LABEL_VALOR_DE', $_SESSION['LANGUAGE']) . "'  maxlength='3' onkeypress='formataValor(event, this, 12);' onkeydown='backspaceFormataValor(event, this)'/>" : ($pi .= "<input class='LiloginText' style='width: 250px'  type='text' id='valor_de' name='valor_de' value='" . formataReais($row->VALOR_DE) . "' maxlength='70' placeholder='" . getLabel('LABEL_VALOR_DE', $_SESSION['LANGUAGE']) . "'  maxlength='3' onkeypress='formataValor(event, this, 12);' onkeydown='backspaceFormataValor(event, this)'/>");
}
$pi .= "</div>";
$pi .= "<div class='Userlabel'>" . getLabel('LABEL_VALOR_PARA', $_SESSION['LANGUAGE']) . ":</div>";
$pi .= "<div>";
if (!empty($_POST) && isset($_POST['ACTION'])) {
    $pi .= "<input class='LiloginText' style='width: 250px'  type='text' id='valor_para' name='valor_para' value='" . $_POST['valor_para'] . "' maxlength='70' placeholder='" . getLabel('LABEL_VALOR_PARA', $_SESSION['LANGUAGE']) . "'  maxlength='3' onkeypress='formataValor(event, this, 12);' onkeydown='backspaceFormataValor(event, this)'/>";
} else {
    $row->VALOR_PARA == '0' || $row->VALOR_PARA == '' ? $pi .= "<input class='LiloginText' style='width: 250px'  type='text' id='valor_para' name='valor_para' value='0,00' maxlength='70' placeholder='" . getLabel('LABEL_VALOR_PARA', $_SESSION['LANGUAGE']) . "'  maxlength='3' onkeypress='formataValor(event, this, 12);' onkeydown='backspaceFormataValor(event, this)'/>" : ($pi .= "<input class='LiloginText' style='width: 250px'  type='text' id='valor_para' name='valor_para' value='" . formataReais($row->VALOR_PARA) . "' maxlength='70' placeholder='" . getLabel('LABEL_VALOR_PARA', $_SESSION['LANGUAGE']) . "'  maxlength='3' onkeypress='formataValor(event, this, 12);' onkeydown='backspaceFormataValor(event, this)'/>");
}
$pi .= "</div>";
$pi .= "</div>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div>";
if (!empty($_POST) && isset($_POST['ACTION'])) {
    $_POST['disponivel'] == 'on' ? $pi .= "<input type='checkbox' name='disponivel' checked='true'/> <span class='Userlabel'>" . getLabel('LABEL_DISPONIVEL', $_SESSION['LANGUAGE']) . "</span>" : ($pi .= "<input type='checkbox' name='disponivel'/> <span class='Userlabel'>" . getLabel('LABEL_DISPONIVEL', $_SESSION['LANGUAGE']) . "</span>");
} else {
    $row->DISPONIVEL == '1' ? $pi .= "<input type='checkbox' name='disponivel' checked='true'/> <span class='Userlabel'>" . getLabel('LABEL_DISPONIVEL', $_SESSION['LANGUAGE']) . "</span>" : ($pi .= "<input type='checkbox' name='disponivel'/> <span class='Userlabel'>" . getLabel('LABEL_DISPONIVEL', $_SESSION['LANGUAGE']) . "</span>");
}
$pi .= "</div>";
$pi .= "<div style='margin-bottom: 3px;'></div>";
$pi .= "<div>";
if (!empty($_POST) && isset($_POST['ACTION'])) {
    $_POST['temporada'] == 'on' ? $pi .= "<input type='checkbox' name='temporada' checked='true'/> <span class='Userlabel'>" . getLabel('LABEL_BAIXA_TEMPORADA', $_SESSION['LANGUAGE']) . "</span>" : ($pi .= "<input type='checkbox' name='temporada'/> <span class='Userlabel'>" . getLabel('LABEL_BAIXA_TEMPORADA', $_SESSION['LANGUAGE']) . "</span>");
							$xnome = trim( htmlentities( $_POST['buscar'] ) );
							
							$dtainicio = formataDataForUSA($xnome);
							$dtafim = formataDataForUSA($xnome);
							$real = limpaValorReal($xnome);
							
							$criterio .= "AND ";
							
							if( $_POST['status'] != "" && $_POST['buscar'] != "" )
							{
								$criterio .= " valor.VALOR_TOTAL LIKE '%$real%' 
								OR valor.VALOR_TOTAL LIKE '%$xnome%' 
								OR valor.N_CONHECIMENTO LIKE '%$xnome%' 
								OR reservas.DTAINICIO LIKE '%$dtainicio%' 
								OR reservas.DTAFIM LIKE '%$dtafim%'
								AND reservas.STATUS='".$_POST['status']."'";	
							}
							elseif( $_POST['status'] != "" )
							{
								$criterio .= " reservas.STATUS='".$_POST['status']."'";
							}
							elseif( $_POST['buscar'] != "" )
							{
								$criterio .= " valor.VALOR_TOTAL LIKE '%$real%' 
								OR valor.VALOR_TOTAL LIKE '%$xnome%' 
								OR valor.N_CONHECIMENTO LIKE '%$xnome%' 
								OR reservas.DTAINICIO LIKE '%$dtafim%'
								OR reservas.DTAFIM LIKE '%$dtainicio%'
								";	
							}*/
}
            $diff = mysql_fetch_object($diff);
            $diff->DiffDate == "1" ? $html .= "<div>" . $diff->DiffDate . " " . getLabel('LABEL_NOITE', $_SESSION['LANGUAGE']) . "</div>" : ($html .= "<div>" . $diff->DiffDate . " " . getLabel('LABEL_NOITES', $_SESSION['LANGUAGE']) . "</div>");
        }
        $pacote->ISTEMPORADA == '1' ? $html .= "<div>" . getLabel('LABEL_BAIXA_TEMPORADA', $_SESSION['LANGUAGE']) . "</div>" : ($html .= "<div>" . getLabel('LABEL_ALTA_TEMPORADA', $_SESSION['LANGUAGE']) . "</div>");
        $_POST["VALOR_TOTAL"] = $pacote->VALOR_PARA;
        $html .= "<div>";
        //$html .= "<div>".getLabel('LABEL_VALOR_DE', $_SESSION['LANGUAGE']).": ".formataReais($pacote->VALOR_DE)."</div>";
        //$html .= "<div>".getLabel('LABEL_VALOR_PARA', $_SESSION['LANGUAGE']).": ".formataReais($pacote->VALOR_PARA)."</div>";
        $html .= "<div>" . getLabel('LABEL_TOTAL', $_SESSION['LANGUAGE']) . " R\$ " . formataReais($_POST["VALOR_TOTAL"]) . "</div>";
        $html .= "</div>";
        var_dump($_POST);
        $html .= "<div>" . $pacote->DESCRICAO . "</div>";
        $html .= "<div>";
    }
}
$html .= "<p>";
$html .= "<form id='formReserva' name='form1' method='post' action='index.php?actionType=reservas.forma.pgto.cielo'>";
$html .= "<div class='ContainerAcomodacao pag-deposito'>";
$html .= "<div class='EntradaText' style='margin-bottom: 12px'><b>" . getLabel('LABEL_NOME_EMPRESA', $_SESSION['LANGUAGE']) . ":</b> " . $_POST['nome_empresa'] . "</div>";
$html .= "<div class='EntradaText' style='margin-bottom: 12px'><b>E-mail:</b> " . $_POST['email'] . "</div>";
$html .= "<div class='EntradaText' style='margin-bottom: 40px; border: none'><b>" . getLabel('LABEL_FONE_CEL', $_SESSION['LANGUAGE']) . ":</b> " . $_POST['telefone'] . "</div>";
$html .= "<p class='alert-blue'>";
$html .= getLabel('LABEL_TERMO_SERVICO_CARTOES', $_SESSION['LANGUAGE']);
$html .= "&nbsp;<span><a href='http://www.maravista.com.br/termos' target='_blank' title='" . getLabel('LABEL_TERMOS', $_SESSION['LANGUAGE']) . "'>" . getLabel('LABEL_TERMOS', $_SESSION['LANGUAGE']) . "</a></span>";
$html .= "</p>";
$html .= "<p>";
$html .= "<center>";
$html .= "<h2>";
$html .= "Cielo";
$html .= "</h2>";
if ($_POST["ACTION_CIELO"] == "ACTION_CIELO") {
     $html .= "</div>";
     $html .= "<div class='pacotes_left'>";
     $html .= "<div class='pacotes_titulo'>" . $pacote->PACOTE . "</div>";
     $html .= "<div class='pacotes_quarto'>" . $pacote->NOME . "</div>";
     $html .= "</div>";
     $diff = mysql_query("SELECT DATEDIFF('" . $pacote->DTAFIM . "','" . $pacote->DTAINICIO . "') as DiffDate");
     if (mysql_num_rows($diff) != 0) {
         $diff = mysql_fetch_object($diff);
         $diff->DiffDate == "1" ? $html .= "<div class='pacotes_noites'>" . $diff->DiffDate . " " . getLabel('LABEL_NOITE', $_SESSION['LANGUAGE']) . "</div>" : ($html .= "<div class='pacotes_noites'>" . $diff->DiffDate . " " . getLabel('LABEL_NOITES', $_SESSION['LANGUAGE']) . "</div>");
     }
     //( $pacote->ISTEMPORADA == '1' )
     //? $html .= "<div>".getLabel('LABEL_BAIXA_TEMPORADA', $_SESSION['LANGUAGE'])."</div>"
     //: $html .= "<div>".getLabel('LABEL_ALTA_TEMPORADA', $_SESSION['LANGUAGE'])."</div>";
     $html .= "<div class='pacotes_right'>";
     //$html .= "<div>".getLabel('LABEL_VALOR_DE', $_SESSION['LANGUAGE']).": ".formataReais($pacote->VALOR_DE)."</div>";
     $html .= "<div>R\$ " . formataReais($pacote->VALOR_PARA) . "</div>";
     //$html .= "</div>";
     $html .= "<div>" . $pacote->DTAINICIOBRAZIL . " a " . $pacote->DTAFIMBRAZIL . "</div>";
     $html .= "<div>" . $pacote->DESCRICAO . "</div>";
     $html .= "<div>" . getLabel('LABEL_PESSOAS', $_SESSION['LANGUAGE']) . "</div>";
     $html .= "<div>";
     $html .= "<select name='pessoas' id='pessoas' onchange=\"setPessoas(this.value)\">";
     $html .= "<option value='2'>02</option>";
     $html .= "<option value='3'>03</option>";
     $html .= "<option value='4'>04</option>";
     $html .= "</select>";
     $html .= "</div>";
     $html .= "<div><input type='submit' value='" . getLabel('LABEL_RESERVAS_PRE', $_SESSION['LANGUAGE']) . "'/></div>";
     $html .= "</form>";
     $html .= "</div>";
 }
<?php

header("Content-Type: text/html; charset=ISO-8859-1");
require_once "../server/Connection.class.php";
require_once "../server/lib.php";
$conn = new Connection();
$quartos = mysql_query("SELECT VALOR FROM quartos WHERE CODQUARTO='" . $_POST['CODQUARTO'] . "'");
if (mysql_num_rows($quartos) != 0) {
    $quarto = mysql_fetch_object($quartos);
    $total = (int) limpaValorReal($_POST['TOTAL']);
    $valor = (int) limpaValorReal($quarto->VALOR);
    if ($_POST['CALCULO'] == 'SOMAR') {
        (int) ($soma = $total + $valor);
        (string) ($n = formataReais($soma));
        $ref = trim($_POST['CODQUARTO'] . ":{$n}");
    } else {
        (int) ($soma = $total - $valor);
        (string) ($n = formataReais($soma));
        $ref = trim($_POST['CODQUARTO'] . ":{$n}");
    }
} else {
    $ref = trim($_POST['CODQUARTO'] . ":" . $_POST['TOTAL']);
}
$conn->close();
print $ref;