break;
										case "1":
											$stt1 = "selected";
										break;
										case "2":
											$stt2 = "selected";
										break;
										case "3":
											$stt3 = "selected";
										break;
										case "4":
											$stt4 = "selected";
										break;
										case "5":
											$stt5 = "selected";
										break;
									}
								
									$pi .= "<option value='' $stt>--</option>";
									$pi .= "<option value='0' $stt0>".getLabel('LABEL_RESERVAS_PRE', $_SESSION['LANGUAGE'])."</option>";
									$pi .= "<option value='1' $stt1>".getLabel('LABEL_RESERVA_CONFIRMADA', $_SESSION['LANGUAGE'])."</option>";
									$pi .= "<option value='2' $stt2>".getLabel('LABEL_RESERVA_CANCELADA', $_SESSION['LANGUAGE'])."</option>";
									$pi .= "<option value='3' $stt3>booking.com</option>";
									$pi .= "<option value='4' $stt4>decolar.com</option>";
									$pi .= "<option value='5' $stt5>outros...</option>";
								$pi .= "</select>";
								
								$pi .= "<div class='Floatbusca'><input class='BtnProprio' type='submit' value='".getLabel('LABEL_ENVIAR', $_SESSION['LANGUAGE'])."'/></div>";
							}
							else
							{*/
    $espanhol = trim(htmlentities(tratapost($_POST['espanhol'])));
    $portugues = trim(htmlentities(tratapost($_POST['portugues'])));
    $ingles = str_replace("'", '&lsquo;', $ingles);
    $espanhol = str_replace("'", '&lsquo;', $espanhol);
    $portugues = str_replace("'", '&lsquo;', $portugues);
    $valor_de = trim(tratapost($_POST['valor_de']));
    if ($valor_de == "") {
        $valor_de = "000";
    } else {
        $valor_de = limpaValorReal($valor_de);
    }
    $valor_para = trim(tratapost($_POST['valor_para']));
    if ($valor_para == "") {
        $valor_para = "000";
    } else {
        $valor_para = limpaValorReal($valor_para);
    }
    $disponivel = trim(tratapost($_POST['disponivel']));
    $temporada = trim(tratapost($_POST['temporada']));
    $ispgto = trim(tratapost($_POST['ispgto']));
    $status = trim(tratapost($_POST['status']));
    $disponivel == 'on' ? $disponivel = 1 : ($disponivel = 0);
    $temporada == 'on' ? $temporada = 1 : ($temporada = 0);
    $ispgto == 'on' ? $ispgto = 1 : ($ispgto = 0);
    $status == 'on' ? $status = 1 : ($status = 0);
    mysql_query("UPDATE `pacotes` SET `CODQUARTOTIPO`='{$codquartotipo}',`PORTUGUES`='{$portugues}',`INGLES`='{$ingles}',`ESPANHOL`='{$espanhol}',`DISPONIVEL`='{$disponivel}',`ISPGTO`='{$ispgto}',`ISTEMPORADA`='{$temporada}',`VALOR_DE`='{$valor_de}',`VALOR_PARA`='{$valor_para}',`STATUS`='{$status}' WHERE `CODPACOTE`='{$codpacote}'");
    echo "<script>alert('* " . getLabel('LABEL_EDIT_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
    echo "<script>window.location = 'index.php?actionType=gerenciar.pacotes';</script>";
    exit;
} else {
    $erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
                case 10:
                	$piece .= $compl;
                break;
                */
            /*
            case 10:
            	$piece .= $compl;
            break;
            */
            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 = "*****@*****.**";
    $row = mysql_fetch_object($row);
}
$erro = "";
if (!empty($_POST) && isset($_POST['ACTION'])) {
    $codextra = $_GET['codextra'];
    $ingles = trim(htmlentities(tratapost($_POST['ingles'])));
    $espanhol = trim(htmlentities(tratapost($_POST['espanhol'])));
    $portugues = trim(htmlentities(tratapost($_POST['portugues'])));
    $ingles = str_replace("'", '&lsquo;', $ingles);
    $espanhol = str_replace("'", '&lsquo;', $espanhol);
    $portugues = str_replace("'", '&lsquo;', $portugues);
    $valor = trim(tratapost($_POST['valor']));
    if ($valor == "") {
        $valor = "000";
    } else {
        $valor = limpaValorReal($valor);
    }
    $disponivel = trim(tratapost($_POST['disponivel']));
    $ispgto = trim(tratapost($_POST['ispgto']));
    $status = trim(tratapost($_POST['status']));
    $disponivel == 'on' ? $disponivel = 1 : ($disponivel = 0);
    $ispgto == 'on' ? $ispgto = 1 : ($ispgto = 0);
    $status == 'on' ? $status = 1 : ($status = 0);
    mysql_query("UPDATE `extras` SET `PORTUGUES`='{$portugues}',`INGLES`='{$ingles}',`ESPANHOL`='{$espanhol}',`DISPONIVEL`='{$disponivel}',`ISPGTO`='{$ispgto}',`VALOR`='{$valor}',`STATUS`='{$status}' WHERE`CODEXTRA`='{$codextra}'");
    echo "<script>alert('* " . getLabel('LABEL_EDIT_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
    echo "<script>window.location = 'index.php?actionType=gerenciar.extras';</script>";
} else {
    $erro = getLabel('ERRO_PREENCHER_TODOS_CAMPOS', $_SESSION['LANGUAGE']);
}
$pi = "<form name='formCpf' method='post' action='index.php?actionType=gerenciar.extras.edit&codextra=" . $_GET['codextra'] . "'>";
$pi .= "<div class='ErroMessage'>* {$erro}!</div>";
$pi .= "</div>";
$pi .= "</td>";
$pi .= "</tr>";
$pi .= "</table>";
$pi .= "<div><input type='hidden' name='ACTION' value='ACTION'/></div>";
$pi .= "</form>";
$pi .= "</div>";
if ($_POST[ACTION] == 'ACTION') {
    foreach ($_POST as $name => $value) {
        if (substr_count($name, '_') == 1) {
            $key = str_replace("_", "", $name);
            mysql_query("UPDATE quartos SET PESSOAS='{$value}' WHERE CODQUARTO='{$key}'");
        }
        if (substr_count($name, '__') == 1) {
            $key = str_replace("__", "", $name);
            mysql_query("UPDATE quartos SET VALOR='" . limpaValorReal($value) . "' WHERE CODQUARTO='{$key}'");
        }
    }
    echo "<script>alert('* " . getLabel('LABEL_EDIT_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
    echo "<script>window.location = 'index.php?actionType=" . $_GET['actionType'] . "';</script>";
}
$pi .= "<form name='List' method='post' action='index.php?actionType=" . $_GET['actionType'] . "'>";
$pi .= "<div class='BtnButtomManage' onclick=\"location = 'index.php?actionType=gerenciar.quartos.add'\" title='" . getLabel('LABEL_ADICIONAR', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_ADICIONAR', $_SESSION['LANGUAGE']) . "</span></div>";
$pi .= "<div class='BtnButtomManage' onclick=\"url('gerenciar.quartos.edit', '', '" . getLabel('LABEL_JS_MAIS_DE_UM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_NENHUM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_UPDATE', $_SESSION['LANGUAGE']) . "')\"  title='" . getLabel('LABEL_EDITAR', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_EDITAR', $_SESSION['LANGUAGE']) . "</span></div>";
/*
		$pi .= "<div class='BtnButtomManage' onclick=\"url('gerenciar.quartos.descricao', '', '".getLabel('LABEL_JS_MAIS_DE_UM', $_SESSION['LANGUAGE'])."', '".getLabel('LABEL_JS_NENHUM', $_SESSION['LANGUAGE'])."', '".getLabel('LABEL_JS_UPDATE', $_SESSION['LANGUAGE'])."')\"  title='".getLabel('LABEL_DESCRICAO', $_SESSION['LANGUAGE'])."'><span class='BtnProprio'>".getLabel('LABEL_DESCRICAO', $_SESSION['LANGUAGE'])."</span></div>";
		$pi .= "<div class='BtnButtomManage' onclick=\"url('gerenciar.quartos.fotos.list', '', '".getLabel('LABEL_JS_MAIS_DE_UM', $_SESSION['LANGUAGE'])."', '".getLabel('LABEL_JS_NENHUM', $_SESSION['LANGUAGE'])."', '".getLabel('LABEL_JS_UPDATE', $_SESSION['LANGUAGE'])."')\"  title='".getLabel('LABEL_LIST_FOTOS', $_SESSION['LANGUAGE'])."'><span class='BtnProprio'>".getLabel('LABEL_LIST_FOTOS', $_SESSION['LANGUAGE'])."</span></div>";
		*/
$pi .= "<div class='ResetFloat'></div>";
$pi .= "<div class='MasterList'>";
$pi .= "<table class='Tableinter'>";
        }
        if (substr_count($name, '____') == 1) {
            $key = str_replace("____", "", $name);
            mysql_query("UPDATE quartos_tipo SET VALOR_MEDIA='" . limpaValorReal($value) . "' WHERE CODQUARTOTIPO='{$key}'");
        }
        if (substr_count($name, '_____') == 1) {
            $key = str_replace("_____", "", $name);
            mysql_query("UPDATE quartos_tipo SET VALOR_MEDIA_FINAL='" . limpaValorReal($value) . "' WHERE CODQUARTOTIPO='{$key}'");
        }
        if (substr_count($name, '______') == 1) {
            $key = str_replace("______", "", $name);
            mysql_query("UPDATE quartos_tipo SET VALOR_BAIXA='" . limpaValorReal($value) . "' WHERE CODQUARTOTIPO='{$key}'");
        }
        if (substr_count($name, '_______') == 1) {
            $key = str_replace("_______", "", $name);
            mysql_query("UPDATE quartos_tipo SET VALOR_BAIXA_FINAL='" . limpaValorReal($value) . "' WHERE CODQUARTOTIPO='{$key}'");
        }
    }
    echo "<script>alert('* " . getLabel('LABEL_EDIT_SUCESSO_LABEL', $_SESSION['LANGUAGE']) . "!')</script>";
    echo "<script>window.location = 'index.php?actionType=gerenciar.quartos.tipos';</script>";
}
$pi .= "<form name='List' method='post' action='index.php?actionType=" . $_GET['actionType'] . "'>";
$pi .= "<div class='BtnButtomManage' onclick=\"location = 'index.php?actionType=gerenciar.quartos.tipos.add'\" title='" . getLabel('LABEL_ADICIONAR', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_ADICIONAR', $_SESSION['LANGUAGE']) . "</span></div>";
$pi .= "<div class='BtnButtomManage' onclick=\"url('gerenciar.quartos.tipos.edit', '', '" . getLabel('LABEL_JS_MAIS_DE_UM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_NENHUM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_UPDATE', $_SESSION['LANGUAGE']) . "')\"  title='" . getLabel('LABEL_EDITAR', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_EDITAR', $_SESSION['LANGUAGE']) . "</span></div>";
$pi .= "<div class='BtnButtomManage' onclick=\"url('gerenciar.quartos.tipos.descricao', '', '" . getLabel('LABEL_JS_MAIS_DE_UM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_NENHUM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_UPDATE', $_SESSION['LANGUAGE']) . "')\"  title='" . getLabel('LABEL_DESCRICAO', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_DESCRICAO', $_SESSION['LANGUAGE']) . "</span></div>";
$pi .= "<div class='BtnButtomManage' onclick=\"url('gerenciar.quartos.tipos.fotos.list', '', '" . getLabel('LABEL_JS_MAIS_DE_UM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_NENHUM', $_SESSION['LANGUAGE']) . "', '" . getLabel('LABEL_JS_UPDATE', $_SESSION['LANGUAGE']) . "')\"  title='" . getLabel('LABEL_LIST_FOTOS', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_LIST_FOTOS', $_SESSION['LANGUAGE']) . "</span></div>";
$pi .= "<div class='BtnButtomManage' onclick=\"location = 'index.php?actionType=gerenciar.quartos.tipos.configuracao'\" title='" . getLabel('LABEL_ADICIONAR', $_SESSION['LANGUAGE']) . "'><span class='BtnProprio'>" . getLabel('LABEL_CONFIG', $_SESSION['LANGUAGE']) . "</span></div>";
$pi .= "<div class='ResetFloat'></div>";
$pi .= "<div class='MasterList'>";
$pi .= "<table class='Tableinter'>";
$pi .= "<tr>";
예제 #7
0
             break;
         case 9:
             $piece .= $_POST["nQuartos"];
             break;
         case 10:
             $piece .= $compl;
             break;
         case 11:
             if ($_POST["FORMA_PGTO"] == "1") {
                 $piece .= getLabel('LABEL_DEPOSITO', $_SESSION['LANGUAGE']);
             } elseif ($_POST["FORMA_PGTO"] == "2") {
                 $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++;
 }
<?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;