public static function realizar() { try { $arrayReserva = array(); $arrayReserva['Usuario'] = $_POST['user']; $arrayReserva['Habitacion'] = $_POST['habitacion']; $arrayReserva['Duracion'] = $_POST['Duracion']; $arrayReserva['TipoReserva'] = $_POST['reserva']; $arrayReserva['FechaEntrada'] = $_POST['fechaEn']; $arrayReserva['FechaSalida'] = $_POST['fechaSal']; $arrayReserva['Estado'] = "Activa"; $reserva = new reserva($arrayReserva); $reserva->realizar(); header("Location: ../V/pages/formsReserva.php"); } catch (Exception $e) { //header("Location: ../insertar.php?respuesta=error"); } }
public function update(reserva $reserva) { $mysqli = new mysqli(Connection::DBHOST, Connection::DBUSERNAME, Connection::DBPASS, Connection::DBNAME); $query = "UPDATE reserva SET id_casa=?, id_persona_reserva=?, id_estadp=?, fecha_desde=FROM_UNIXTIME(?),\n fecha_hasta=FROM_UNIXTIME(?), valor=?, observacion=? where id=?"; $statement = $mysqli->prepare($query); $idCasa = $reserva->getIdCasa(); $idPersonaReserva = $reserva->getIdPersonaReserva(); $idEstado = $reserva->getIdEstado(); $fechaDesde = $reserva->getFechaDesde(); $fechaHasta = $reserva->getFechaHasta(); $valor = $reserva->getFechaHasta(); $observacion = $reserva->getObservacion(); $id = $reserva->getId(); $statement->bind_param("iiiiidsi", $idCasa, $idPersonaReserva, $idEstado, $fechaDesde->getTimestamp(), $fechaHasta->getTimestamp(), $valor, $observacion, $id); $statement->execute(); $statement->close(); $mysqli->close(); }
public function populaReserva($row) { $reserva = new reserva(); $reserva->setdias_permanencia($row['dias_permanencia']); $reserva->setnro_pessoas($row['nro_pessoas']); $reserva->setvalor_diaria($row['valor_diaria']); $reserva->setnhospede($row['nhospede']); return $reserva; }
<?php include_once "../../login/check.php"; if (!empty($_POST)) { include_once "../../class/reserva.php"; $reserva = new reserva(); $CodReserva = $_POST['CodReserva']; $reserva->eliminarRegistro("CodReserva=" . $CodReserva); }
<?php include_once "../../login/check.php"; $folder = "../../"; $codreserva = $_POST['codreserva']; include_once "../../class/reserva.php"; $reserva = new reserva(); $res = $reserva->eliminarRegistro("codreserva=" . $codreserva);
<?php /*echo "<pre>"; print_r($_POST); echo "</pre>";*/ extract($_POST); $valores = array("fechaevento" => "'{$fechaevento}'", "horaevento" => "'{$horaevento}'", "direccionevento" => "'{$direccionevento}'", "nroinvitados" => "'{$nroinvitados}'", "nombrecliente" => "'{$nombrecliente}'", "cicliente" => "'{$cicliente}'", "telefonocliente" => "'{$telefonocliente}'", "correo" => "'{$correo}'", "tipo" => "'Pedido'", "cuentatigo" => "''", "codcolor" => "'{$codcolor}'", "coddiseno" => "'{$coddiseno}'", "codflores" => "'{$codflores}'", "codglobos" => "'{$codglobos}'", "total" => "'{$total}'", "opciondecoracion" => "'{$opciondecoracion}'", "acuenta" => "'0'", "saldo" => "'0'", "estado" => "'Pendiente'", "id" => "'0'", "nivel" => "'0'"); /*echo "<pre>"; print_r($valores); echo "</pre>";*/ include_once "../class/reserva.php"; $reserva = new reserva(); $reserva->insertarRegistro($valores); $folder = "../"; include_once $folder . "cabecerahtml.php"; include_once $folder . "cabecera.php"; ?> <section class=""> <div class="container"> <div class="row"> <h2 class="section-title">Mensaje de Confirmación</h2> <div class="col-sm-8"> <div class="panel panel-default"> <div class="panel-heading"></div> <div class="panel-body"> <div class="alert alert-info"> <h4>Gracias por Confiar en Nosotros</h4> <br> <h5>Su Reserva Personalizada se Registro Correctamente</h5> </div> </div>
<?php include_once "../../login/check.php"; $codreserva = $_GET['c']; include_once "../../class/reserva.php"; $reserva = new reserva(); $res = $reserva->mostrarTodoRegistro("codreserva=" . $codreserva); $res = array_shift($res); include_once "../../class/servicio.php"; $servicio = new servicio(); $ser = $servicio->mostrarTodoRegistro("", "1", "titulo"); include_once "../../class/color.php"; $color = new color(); $col = $color->mostrarTodoRegistro("", 1, "descripcion"); include_once "../../class/diseno.php"; $diseno = new diseno(); $dis = $diseno->mostrarTodoRegistro("", 1, "descripcion"); include_once "../../class/flores.php"; $flores = new flores(); $flo = $flores->mostrarTodoRegistro("", 1, "descripcion"); include_once "../../class/globos.php"; $globos = new globos(); $glo = $globos->mostrarTodoRegistro("", 1, "descripcion"); $folder = "../../"; include_once $folder . "cabecerahtml.php"; ?> <script language="javascript" type="text/javascript"> $(document).on("ready",function(){ $(document).on("change","[name=total],[name=acuenta],[name=saldo]",function(e){ var total=parseFloat($("[name=total]").val()); var acuenta=parseFloat($("[name=acuenta]").val());
<?php $cantidadmaxima = 0; $FechaEvento = $_POST['FechaEvento']; include_once "class/reserva.php"; $reserva = new reserva(); $res = $reserva->mostrarTodoRegistro("estado='Confirmado' and fechaevento='{$FechaEvento}'"); if (count($res) > $cantidadmaxima) { ?> <div class="alert alert-danger"><small>Personal no Disponible para esta fecha</small></div> <script>$("#botonenviar").attr("disabled","disabled")</script> <?php } else { ?> <div class="alert alert-success"><small>Personal Disponible para esta fecha</small></div> <script>$("#botonenviar").removeAttr("disabled")</script> <?php }
<?php include_once "../../login/check.php"; if (!empty($_POST)) { include_once "../../class/reserva.php"; $reserva = new reserva(); $CodAlumno = $_POST['CodAlumno']; ?> <table class="table table-striped table-hover table-bordered"> <thead> <tr><th>N</th><th><?php echo $idioma['MontoReserva']; ?> </th><th><?php echo $idioma['FechaReserva']; ?> </th></tr> </thead> <?php foreach ($reserva->mostrarTodoRegistro("CodAlumno={$CodAlumno}") as $r) { $i++; ?> <tr><td><?php echo $i; ?> </td><td><?php echo $r['MontoReserva']; ?> </td><td><?php echo fecha2Str($r['FechaRegistro']); ?>
<?php include_once "../../class/reserva.php"; $reserva = new reserva(); extract($_POST); $res = $reserva->mostrarTodoRegistro("fechaevento='{$fechaevento}' and nombrecliente LIKE '{$nombrecliente}%' and estado LIKE '{$estado}' and tipo LIKE '{$tipo}'", 1, ""); ?> <table class="table table-bordered table-striped table-hover"> <thead> <tr><th>Nº</th><th>Fecha Evento</th><th>Hora Evento</th><th>Nro Invitados</th><th>Nombre Cliente</th><th>C.I. Cliente</th><th>Telefono Cliente</th><th>Total</th><th>A Cuenta</th><th>Saldo</th><th>Estado</th><th>Tipo Evento</th><th>Personal</th><th></th></tr> </thead> <?php foreach ($res as $r) { $i++; switch ($r['estado']) { case "Pendiente": $estado = "danger"; break; case "Confirmado": $estado = "success"; break; } ?> <tr> <td class="der"><?php echo $i; ?> </td> <td><?php echo date("d-m-Y", strtotime($r['fechaevento'])); ?>
<?php include_once "../../login/check.php"; /*echo "<pre>"; print_r($_POST); echo "</pre>";*/ extract($_POST); $valores = array("codservicio" => "'{$codservicio}'", "fechaevento" => "'{$fechaevento}'", "horaevento" => "'{$horaevento}'", "direccionevento" => "'{$direccionevento}'", "nroinvitados" => "'{$nroinvitados}'", "nombrecliente" => "'{$nombrecliente}'", "cicliente" => "'{$cicliente}'", "telefonocliente" => "'{$telefonocliente}'", "tipo" => "'{$tipo}'", "cuentatigo" => "''", "codcolor" => "'{$codcolor}'", "coddiseno" => "'{$coddiseno}'", "codflores" => "'{$codflores}'", "codglobos" => "'{$codglobos}'", "total" => "'{$total}'", "opciondecoracion" => "'{$opciondecoracion}'", "conclusion" => "'{$conclusion}'", "acuenta" => "'{$acuenta}'", "saldo" => "'{$saldo}'", "estado" => "'{$estado}'", "id" => "'0'", "nivel" => "'0'"); /*echo "<pre>"; print_r($valores); echo "</pre>";*/ include_once "../../class/reserva.php"; $reserva = new reserva(); $reserva->actualizarRegistro($valores, "codreserva={$codreserva}"); header("Location:listar.php");