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("'", '‘', $ingles); $espanhol = str_replace("'", '‘', $espanhol); $portugues = str_replace("'", '‘', $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("'", '‘', $ingles); $espanhol = str_replace("'", '‘', $espanhol); $portugues = str_replace("'", '‘', $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>";
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;