File: /home/asjudine/www/apostventas/fidelizacion_bonos_formulario_reservar.php
<?php
require_once("../Conectarse.php");
//DATOS FIDELIZACION BONOS
$control = mysql_query('SELECT cedula, nombre_completo, numerocontrato, bono1, bono2, bono3, bono4, bono5, accion_envio FROM fidelizacion_bonos WHERE cedula = "'.$_GET["ced2"].'" and numerocontrato = "'.$_GET["numcon"].'" ');
if (!$control) {
die('Invalid query control: ' . mysql_error());
}
$row_control=mysql_num_rows($control);
list($cedula, $nombre_completo, $numero_contrato, $bono1, $bono2, $bono3, $bono4, $bono5, $accion_envio) = mysql_fetch_row($control);
//DATOS CARTERA
$control2= mysql_query('SELECT direccion, telefono, celular, ciudad, email FROM cartera_serviasjudinet WHERE cedula = "'.$_GET["ced2"].'" and numerocontrato = "'.$_GET["numcon"].'"');
if (!$control2) {
die('Invalid query control2: ' . mysql_error());
}
$row_control2=mysql_num_rows($control2);
list($direccion, $telefono, $celular, $ciudad, $email) = mysql_fetch_row($control2);
?>
<!DOCTYPE html>
<html>
<head>
<title>FIDELIZACION ACCION BONO</title>
<meta http-equiv="X-UA-Compatible" content="IE=8; IE=9; IE=edge" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
*{margin: 0;padding: 0;}
body{background-color:#EAEAEA;font-family:Verdana, Geneva, sans-serif;}
header {background-color: #B7271F; text-align: center;}
.titulo{width: 100%;text-align: center;background-color: #dbd8c9;color: #b20606;padding: 6px 0;font-size: 18px;}
table{margin: 0 auto;border: 8px solid #bebebe; text-align: center;}
.divirmenu{text-align: center;}
.irmenu{width: 200px;background-color: #1c4fa0;color: #fff; padding: 4px;border-radius: 6px;}
.irmenu:hover{background-color: #67a0d9; color: #000;}
.direcciona{width: 200px;background-color: #D4090C;color: #fff; padding: 4px;border-radius: 3px;}
.direcciona:hover{background-color: #67a0d9; color: #000;}
.fecha{background-color: #d6e08b; padding: 2px;color: #000;font-size: 15px; text-align: center;}
td{padding: 1px; border: 1px solid #a0a0a0;}
.td{background-color: #e5e5e5; padding: 1px 30px;color: #00135F;font-size: 14px;font-weight: 600; text-align: center;}
.boton1{width:30%;background-color: #ffffff;color: #000;padding: 2px;border:2px solid #580000;border-radius:10px;}
.boton1:hover{background-color: #6f0000;color: #fff;cursor: pointer;}
input[type=text],select{border-radius: 5px; padding: 3px;background-color: #FFF;}
.tdtitulo{background-color: #e3dec0; color: #b20606; padding: 2px; text-align: center; font-size: 12px; font-weight: 900}
.tdfull{background-color: #fff; color: #000; padding: 1px; text-align: center; font-size: 12px;}
.botonnew{width: 90px; background-color: #e3dec0;color: #b20606;padding: 1px;border-radius:5px;}
.botonnew:hover{width: 90px; background-color: #cbbd6a;color: #000;padding: 1px;border-radius:5px;}
.tdizq{background-color: #e5e5e5; padding: 1px 10px;color: #00135F;font-size: 12px;font-weight: 600; text-align: left;}
.tdcen{background-color: #e5e5e5; padding: 1px 10px;color: #00135F;font-size: 12px;font-weight: 600; text-align: center;}
.tdder{background-color: #e5e5e5; padding: 1px 2px;color: #00135F;font-size: 12px;font-weight: 600; text-align: right;}
.tdderroja{background-color: #e5e5e5; padding: 1px 2px;color: #D40609;font-size: 12px;font-weight: 600; text-align: left;}
.tdcenroja{background-color: #e5e5e5; padding: 1px 2px;color: #D40609;font-size: 12px;font-weight: 600; text-align: center;}
.tdizqroja{background-color: #e5e5e5; padding: 1px 2px;color: #D40609;font-size: 12px;font-weight: 600; text-align: right;}
.tdbono{background-color: #FFFFCC; padding: 1px 2px;color: #00135F;font-size: 12px;font-weight: 600; text-align: right;}
/*Estilo Complementario*/
.tdi{background-color: #F9FBC8; padding: 1px 10px;color: #00135F;font-size: 12px;font-weight: 600; text-align: left;}
.tdc{background-color: #F9FBC8; padding: 1px 10px;color: #00135F;font-size: 12px;font-weight: 600; text-align: center;}
.tdd{background-color: #F9FBC8; padding: 1px 2px;color: #00135F;font-size: 12px;font-weight: 600; text-align: right;}
.tdrojad{background-color: #EEE; color: #8A0002; padding: 1px 4px;font-size: 12px;font-weight: 600; text-align: right;}
.tdrojai{background-color: #EEE; color: #8A0002; padding: 1px 4px;font-size: 12px;font-weight: 600; text-align: left;}
.rojo{color:#C60000;}
.aprobado{background-color:#2CA316; color:#FFF; padding:4px; cursor:pointer;}
.aprobado:hover{background-color:#296411; color:#FFF; padding:4px;}
.denegado{background-color:#BE161B; color:#FFF; padding:4px; cursor:pointer;}
.denegado:hover{background-color:#A42023; color:#FFF; padding:4px;}
.pendiente{background-color:#5170EC; color:#FFF; padding:4px;}
.pendiente:hover{background-color:#1B3A8D; color:#FFF; padding:4px;}
.valida{background-color:#A41518; color:#FFF;}
.hit{background-color: #47547C; color: #fff; padding: 2px; text-align: center; font-size: 12px; font-weight: 900;}
</style>
<script>
function Verificar() {
//var expreg = /^[A-Z]{1,2}\s\d{4}\s([B-D]|[F-H]|[J-N]|[P-T]|[V-Z]){3}$/;
var expreg = /^[0-9]+$/;
var numeroadultos = document.getElementById('numero_adultos');
var numeroninos = document.getElementById('numero_ninos');
if (document.frm.numero_adultos.value == ""){
alert("Capture Numero de adultos")
document.frm.numero_adultos.focus()
return (false);
}
if (document.frm.numero_ninos.value == ""){
alert("Capture Numero de niņos")
document.frm.numero_ninos.focus()
return (false);
}
if (document.frm.ano.value == ""){
alert("Seleccione aņo")
document.frm.ano.focus()
return (false);
}
if (document.frm.mesi.value == ""){
alert("Seleccione mes")
document.frm.mesi.focus()
return (false);
}
if (document.frm.dias.value == ""){
alert("Seleccione dias")
document.frm.dias.focus()
return (false);
}
return(true);
}
</script>
</head>
<body>
<header>
<img src="../ELEMENTS/bannerInterasjudinet.png" alt="" width=" 700" height="70">
</header>
<h3 class="titulo">FORMULARIO ACCION DE FIDELIZACION BONOS</h3>
<form method="post" name="frm" id="frm" onSubmit="return Verificar()">
<table border="0" cellspacing="2">
<tr>
<td class="tdder">Cedula:</td>
<td class="tdizq"><input type="text" name="cedula" id="cedula" value="<?php echo $cedula; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Nombre:</td>
<td class="tdizq"><input type="text" name="nombre_completo" id="nombre_completo" value="<?php echo $nombre_completo; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Contrato:</td>
<td class="tdizq"><input type="text" name="numero_contrato" id="numero_contrato" value="<?php echo $numero_contrato; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Ciudad:</td>
<td class="tdizq"><input type="text" name="ciudad" id="ciudad" value="<?php echo $ciudad; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Direccion:</td>
<td class="tdizq"><input type="text" name="direccion" id="direccion" value="<?php echo $direccion; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Telefono:</td>
<td class="tdizq"><input type="text" name="telefono" id="telefono" value="<?php echo $telefono; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Celular:</td>
<td class="tdizq"><input type="text" name="celular" id="celular" value="<?php echo $celular; ?>"size="50" maxlength="40" readonly></td>
</tr>
<tr>
<td class="tdder">Email:</td>
<td class="tdizq"><input type="text" name="email" id="email" value="<?php echo $email; ?>"size="50" maxlength="40" readonly></td>
</tr>
<!--
<tr>
<td class="tdder">Metodo:</td>
<td class="tdizq">
<select name="metodo" id="metodo">
<option value="">--SELECCIONE--</option>
<option value="CELULAR">CELULAR</option>
<option value="EMAIL">EMAIL</option>
<option value="DIRECCION">DIRECCION</option>
</select>
</td>
</tr>
-->
<!--<tr>
<td class="tdderroja">Accion Envio:</td>
<td class="tdizq"><input type="text" name="accion_envio" id="accion_envio" value="<?php echo $accion_envio; ?>"size="50" maxlength="40" readonly></td>
</tr>-->
<tr>
<td class="tdderroja">Accion Envio:</td>
<td class="tdizq"><textarea name="medios_envio" id="medios_envio" cols="53" rows="6" readonly><?php echo $accion_envio; ?></textarea></td>
</tr>
<tr>
<td class="tdizqroja">Fecha de Reserva:</td>
<td class="tdizq">
<select name="anos" id="anos" class="sel3">
<option value="2020" selected>2020</option>
<option value="2021">2021</option>
<option value="2022">2022</option>
<option value="2023">2023</option>
<option value="2024">2024</option>
<option value="2025">2025</option>
<option value="2026">2026</option>
<option value="2027">2027</option>
<option value="2028">2028</option>
<option value="2029">2029</option>
<option value="2030">2030</option>
</select>-
<select name="mesi" id="mesi" class="sel3">
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>-
<select name="dias" id="dias" class="sel3">
<option value="00">00</option>
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
</td>
</tr>
<tr>
<td class="tdder">Cantidad Adultos:</td>
<td class="tdizq"><input type="text" name="numero_adultos" id="numero_adultos" value="<?php echo $numero_adultos; ?>"size="50" maxlength="40" pattern="[0-9]+"></td>
</tr>
<tr>
<td class="tdder">Cantidad Niņos:</td>
<td class="tdizq"><input type="text" name="numero_ninos" id="numero_ninos" value="<?php echo $numero_ninos; ?>"size="50" maxlength="40" pattern="[0-9]+"></td>
</tr>
<tr>
<td class="tdder">Nombre de Contacto:</td>
<td class="tdizq"><input type="text" name="nombre_contacto" id="nombre_contacto" value="<?php echo $nombre_contacto; ?>"size="50" maxlength="40"></td>
</tr>
<tr>
<td class="tdder">Celular de Contacto:</td>
<td class="tdizq"><input type="text" name="celular_contacto" id="celular_contacto" value="<?php echo $celular_contacto; ?>"size="50" maxlength="40" pattern="[0-9]+"></td>
</tr>
</table>
<div align="center"><input name="guardar" id="guardar" type="submit" class="direcciona" value="GUARDAR "/></div>
</form>
</body>
</html>
<?php
if(isset($_POST["guardar"])){
$cambia_estado = 2; //cambia a estado Importante
$caso = $_POST["metodo"];
$fecha_reserva = $_POST["anos"].'-'.$_POST["mesi"].'-'.$_POST["dias"] ;
$fecha_auto = date("Y-m-d");
$time =time();
ini_set('date.timezone','America/Bogota');
$hora_auto=date("H:i:s",$time);
$sql_update = mysql_query("UPDATE fidelizacion_bonos SET fecha_reserva = '".$fecha_reserva."', numero_adultos = '".$_POST["numero_adultos"]."', numero_ninos = '".$_POST["numero_ninos"]."', nombre_contacto = '".$_POST["nombre_contacto"]."', celular_contacto = '".$_POST["celular_contacto"]."', estado = '".$cambia_estado."' WHERE cedula = '".$_GET["ced2"]."' and numerocontrato = '".$_GET["numcon"]."' ");
if (!$sql_update) {die('Invalid query 3: ' . mysql_error());}
echo "<script>alert('Los datos fueron Guardados');</script>";
echo "<script languaje='javascript'>window.close();</script>";
}
?>