<?php
session_start();
$com = "C";
include("DMMYSQLG.php");
include("DSA3000.php");
include("DF30000.inc");
include("DF80000.php");
include("JQUERY.inc");
$f_f = "";
if (!isset($_GET['bot']))
    $_GET['bot'] = "";
$bot = $_GET['bot'];
?>
<html>
    <link rel="stylesheet" href="css/estilo1.css" type="text/css"/>
    <script type="text/javascript" language="JavaScript1.2" src="DSSCRIPT.js"></script>
    <?php
    if (!isset($_POST['bot']))
        $_POST['bot'] = "";
    if ($_POST['bot'] == "") {
        $_REQUEST['bot'] = $bot;
        $_POST['bot'] = $bot;
    } else {
        $_REQUEST['bot'] = $_REQUEST['bot'];
        $_POST['bot'] = $_POST['bot'];
    }

    if ($_POST['bot'] == "") {
        echo '<h2>!!! SELECCIONE UN REGISTRO !!!</h2>';
        echo '<meta content="1; url=rec_checkin_PR.php"  HTTP-EQUIV="REFRESH">';
    } else {

        include('rec_checkin_CL.php');
        $varible_clase = new clase();
        $res = $varible_clase->lista_busqueda($_POST["bot"]);
        $reg = mysqli_fetch_array($res);
        if (!isset($_POST['fcodtarifa'])) {
            $_REQUEST['fcodtarifa'] = $reg['fcodtarifa'];
            $_REQUEST['fnumres'] = $reg['fnumres'];
            $_REQUEST['fnumcto'] = $reg['fnumcto'];
            $_REQUEST['fnumctos'] = $reg['fnumctos'];
            $_REQUEST['ffecllegada'] = chfecha($reg['ffecllegada'], 'Y-m-d', 'd/m/Y');
            //$_REQUEST['ffecllegada']=$reg['ffecllegada'];
            $_REQUEST['ffecsalida'] = chfecha($reg['ffecsalida'], 'Y-m-d', 'd/m/Y');
            //$_REQUEST['ffecsalida']=$reg['ffecsalida'];
            $_REQUEST['fnumadu'] = $reg['fnumadu'];
            $_REQUEST['fnummenor'] = $reg['fnummenor'];
            $_REQUEST['ffecalt'] = chfecha($reg['ffecalt'], 'Y-m-d', 'd/m/Y');
            $_REQUEST['ffeccam'] = chfecha($reg['ffeccam'], 'Y-m-d', 'd/m/Y');
            //$_REQUEST['ffecalt']=$reg['ffecalt'];
            $_REQUEST['select1'] = $reg['status'];
            $_REQUEST['alta_huesped'] = $reg['alta_huesped'];
            $_REQUEST['select2'] = $reg['estact'];
            $_REQUEST['ftipocto'] = $reg['ftipocto'];

            //datos
            $_REQUEST['fcodgrupo'] = $reg['fcodgrupo'];
            $_REQUEST['fcodagen'] = $reg['fcodagen'];
            $_REQUEST['fcodmeca'] = $reg['fcodmeca'];
            $_REQUEST['fplan'] = $reg['fplan'];
            $_REQUEST['smerf'] = $reg['smerf'];
            $_REQUEST['fnorasvip'] = $reg['fnorasvip'];
            $_REQUEST['fhorallega'] = $reg['fhorallega'];
            $_REQUEST['codseg'] = $reg['codseg'];
            $_REQUEST['tex'] = $reg['tex'];
            $_REQUEST['tex2'] = $reg['tex2'];
            $_REQUEST['tex3'] = $reg['tex3'];
            $_REQUEST['tex4'] = $reg['tex4'];
            $_REQUEST['tex5'] = $reg['tex5'];
            $_REQUEST['tex6'] = $reg['tex6'];
            $_REQUEST['text1'] = $reg['text1'];
            $_REQUEST['text2'] = $reg['text2'];
            $_REQUEST['text3'] = $reg['text3'];
            $_REQUEST['text4'] = $reg['text4'];
            $_REQUEST['text5'] = $reg['text5'];
            $_REQUEST['text6'] = $reg['text6'];
            $_REQUEST['ftotal'] = $reg['ftotal'];
            $_REQUEST['extra4'] = $reg['extra4'];

            //forma de pago
            $_REQUEST['fformpago'] = $reg['fformpago'];
            $_REQUEST['fnumtar'] = $reg['fnumtar'];
            $_REQUEST['fsaldo'] = $reg['fsaldo'];
            $_REQUEST['flimite'] = $reg['flimite'];
            $_REQUEST['fcodseg'] = $reg['fcodseg'];
            //direccion
            $_REQUEST['fnombre'] = $reg['fnombre'];
            $_REQUEST['fapellido'] = $reg['fapellido'];
            $_REQUEST['flengua'] = $reg['flengua'];
            $_REQUEST['fempresa'] = $reg['fempresa'];
            $_REQUEST['ftelefono'] = $reg['ftelefono'];
            $_REQUEST['fvip'] = $reg['fvip'];
            $_REQUEST['femail'] = $reg['femail'];
            $_REQUEST['fmail'] = $reg['fmail'];
            $_REQUEST['fdireccion'] = $reg['fdireccion'];
            $_REQUEST['tcol'] = $reg['fgntd'];
            $_REQUEST['tcp'] = $reg['fcp'];
            $_REQUEST['pais'] = $reg['fpais'];
            $_REQUEST['estados'] = $reg['festado'];
            $_REQUEST['tmun'] = $reg['fciudad'];
            $_REQUEST['fvehiculo'] = $reg['fvehiculo'];
            $_REQUEST['fplacas'] = $reg['fplacas'];
            $_REQUEST['ftelemp'] = $reg['ftelemp'];
            $_REQUEST['ftiphuesped'] = $reg['ftiphuesped'];
            $_REQUEST['n_reg'] = $reg['n_reg'];
        }
        ?>
        <style type="text/css">
            BODY {
                SCROLLBAR-FACE-COLOR:#0000CC; SCROLLBAR-HIGHLIGHT-COLOR:#00CCFF; SCROLLBAR-SHADOW-COLOR:#0000CC; SCROLLBAR-3DLIGHT-COLOR:#0000CC; SCROLLBAR-ARROW-COLOR:#FFFFFF; SCROLLBAR-TRACK-COLOR:#FFFFFF; SCROLLBAR-DARKSHADOW-COLOR: #330000
            }
            <!--
            .Estilo16 {
                font-size: 14px;
                font-weight: bold;
            }
            .Estilo18 {font-weight: bold}
            .Estilo19 {font-size: 16px;
                       font-weight: bold;
            }
            .Estilo17 {font-size: 14px}
            .pp {
                background-color:#666666;
                ;
            }
            .Estilo20 {color: #FFFFFF}
            .Estilo22 {color: #FFFFFF; font-weight: bold; }
            .Estilo23 {font-size: 16px; font-weight: bold; color: #FFFFFF; }
            -->
        </style>
        <body
        <?php
        if (isset($_POST['bot3'])) {
            echo ' onLoad="deshab()"';
        }
        ?>
            >
            <form  name="frm1" method="post" action="">
                <input name="bot" type="hidden" value="<?php echo $_POST["bot"] ?>">
                <table width="943" border="0" align="center">
                    <tr>
                        <th colspan="15" class=\"titulo\"><div align="center"> CONSULTAR REGISTRO DE HUESPEDES </div></th>
                    </tr>

                    <tr>
                        <td width="94"><strong>ALTA:</strong></td>
                        <td width="47"><!--input name="ffecalt" type="text" id="ffecalt" size="7" disabled="disabled" value="<?php//echo $_REQUEST['ffecalt']; ?>"-->
                            <input name="ffecalt" type="text" id="ffecalt"  class="styTabEspA" disabled="disabled" size="7"
                            <?php
                            if (isset($_POST['bot'])) {
                                $fec1 = $reg["ffecalt"];
                                include('DF20000.php');
                                echo 'value="' . $f_f . '"';
                            }
                            ?>/></td>
                        <td width="139"><input name="alta_huesped" type="text" disabled="disabled" id="alta_huesped" size="16"
                            <?php
                                   if (isset($_POST['bot'])) {
                                       echo 'value="' . $reg['alta_huesped'] . '"';
                                   }
                                   ?>></td>
                        <td colspan="2"><strong>ULTIMO CAMBIO:</strong></td>
                        <td colspan="3"><input name="ffeccam" type="text" class="styTabEspA" id="ffeccam" size="7" disabled="disabled"
                            <?php
                                               if (isset($_POST['bot'])) {
                                                   $fec1 = $reg["ffeccam"];
                                                   include('DF20000.php');
                                                   echo 'value="' . $f_f . '"';
                                               }
                                               ?>>      
                            <input name="fusucamb" type="text" id="fusucamb" disabled="disabled" size="12"
                            <?php
                            if (isset($_POST['bot'])) {
                                echo 'value="' . $reg['fusucamb'] . '"';
                            }
                            ?>></td>
                        <td><strong>FOLIO.</strong></td>
                        <td width="43"><input name="ffecalt2" type="text" id="ffecalt2"  class="styTabEspA" disabled="disabled" size="7"
                            <?php
                            if (isset($_POST['bot'])) {
                                echo 'value="' . $reg['n_reg'] . '"';
                            }
                            ?>/></td>
                        <td><div align="right"><strong>STATUS:</strong></div></td>
                        <td><select name="select1">
                                <option value="RESERVACION"<?php if ($_REQUEST['select1'] == "RESERVACION") echo 'selected'; ?>>RESERVACION</option>
                                <option value="HUESPED"<?php if ($_REQUEST['select1'] == "HUESPED") echo 'selected'; ?>>HUESPED</option>
                                <option value="HISTORICO"<?php if ($_REQUEST['select1'] == "HISTORICO") echo 'selected'; ?>>HISTORICO</option>
                            </select></td>
                    </tr>
                    <tr>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20">
                                <label><strong>FECHA DE LLEGADA:

                                    </strong></label>
                            </span></td>
                        <td width="152"  ><label>
                                <input name="ffecllegada" type="text" id="ffecllegada" tabindex="20" onKeyPress="return validar(event)" size="15" disabled="disabled" value="<?php echo $_REQUEST['ffecllegada']; ?>">
                            </label></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20 Estilo20"><strong>DIAS:</strong></span></td>
                        <td width="89"  ><input name="fnumctos" type="text" id="fnumctos" tabindex="20" onKeyPress="return validar(event)" size="5" disabled="disabled" value="<?php echo $_REQUEST['fnumctos']; ?>"></td>
                        <td colspan="1"  >&nbsp;</td>
                        <td colspan="2" style="#A15E8D"><div align="center" class="Estilo20"><strong>NOTAS:</strong></div></td>
                        <td colspan="2" style="#A15E8D"><div align="center" class="Estilo20"><strong>NOTAS INTERNAS:</strong></div></td>
                    </tr>
                    <tr>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20"><strong>FECHA DE SALIDA</strong>: </span></td>
                        <td  ><input name="ffecsalida" type="text" id="ffecsalida" tabindex="20" onKeyPress="return validar(event)" size="15" disabled="disabled" value="<?php echo $_REQUEST['ffecsalida']; ?>"></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20"><strong>NUMERO DE ADULTOS: </strong></span></td>
                        <td  ><input name="fnumadu" type="text" id="fnumadu" tabindex="20" onKeyPress="return validar(event)" disabled="disabled" size="5"  value="<?php echo $_REQUEST['fnumadu']; ?>"></td>
                        <td width="104" style="#A15E8D"><span class="Estilo22">TIPO DE HABITACION:</span></td>
                        <td colspan="2"  ><label>
                                <input name="ftipocto" type="text" size="15" id="ftipocto" disabled="disabled" value="<?php echo $_REQUEST['ftipocto']; ?>">
                            </label></td>
                        <td colspan="2" rowspan="2"  ><div align="center">
                                <textarea name="fnorasvip" cols="30" rows="3" id="fnorasvip" tabindex="4"><?php echo $_REQUEST['fnorasvip']; ?>
                                </textarea>
                            </div></td>
                            
                            <td colspan="2" rowspan="2"  ><div align="center">
                                    <textarea name="extra4" cols="30" rows="3" id="extra4" tabindex="4"readonly><?php echo $_REQUEST['extra4']; ?>
                                </textarea>
                            </div></td>
                    </tr>
                    <tr>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20"><strong>HORA DE LLEGADA:</strong> </span></td>
                        <td  ><input name="fhorallega" type="text" id="fhorallega" tabindex="20" onKeyPress="return validar(event)" disabled="disabled" size="6"  value="<?php echo $_REQUEST['fhorallega']; ?>"></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20"><strong>NUMERO DE MENORES: </strong></span></td>
                        <td  ><input name="fnummenor" type="text" id="fnummenor" tabindex="20" onKeyPress="return validar(event)" disabled="disabled" size="5"  value="<?php echo $_REQUEST['fnummenor']; ?>"></td>
                        <td style="#A15E8D"><span class="Estilo22">NUMERO DE HABITACION:</span></td>
                        <td colspan="2"  ><input name="fnumcto" type="text" id="fnumcto" tabindex="20" size="5" disabled="disabled" value="<?php echo $_REQUEST['fnumcto']; ?>"></td>
                    </tr>


                    <tr>
                        <th colspan="15" class="titulo"><div align="center" class="Estilo18">CONSULTAR SEGMENTOS </div></th>
                    </tr>
                    <tr>
                        <td width="72" style="#A15E8D"><span class="Estilo22">GRUPO:</span></td>
                        <td colspan="3"  ><span class="Estilo18">
                                <select name="fcodgrupo" id="fcodgrupo">
                                    <option value="">----------SELECCIONE----------</option>
                                     <?php
                                     $sql = mysqli_query($con ,"SELECT * FROM valeryus04");
                                     while ($reg = mysqli_fetch_array($sql)) {
                                         if ($_REQUEST['fcodgrupo'] == $reg['gdescrip']) {
                                             echo '<option value="' . $reg['gdescrip'] . '" selected>' . $reg['gdescrip'] . '</option>';
                                         } else {
                                             echo '<option value="' . $reg['gdescrip'] . '">' . $reg['gdescrip'] . '</option>';
                                         }
                                     }
                                     ?>
                                </select>


                            </span></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo22">MERCADO: </span></td>
                        <td colspan="4"  ><span class="Estilo18">
                                <select name="fcodmeca" id="fcodmeca">
                                    <option value="">-----SELECCIONE-----</option>
                                    <?php
                                    $sql = mysqli_query($con ,"SELECT * FROM tipmerca");
                                    while ($reg = mysqli_fetch_array($sql)) {
                                        if ($_REQUEST['fcodmeca'] == $reg['tdescrip']) {
                                            echo '<option value="' . $reg['tdescrip'] . '" selected>' . $reg['tdescrip'] . '</option>';
                                        } else {
                                            echo '<option value="' . $reg['tdescrip'] . '">' . $reg['tdescrip'] . '</option>';
                                        }
                                    }
                                    ?>
                                </select>
                            </span></td>
                        <td width="76" colspan="2" style="#A15E8D"><span class="Estilo20"><strong>EMPRESA:</strong></span></td>
                        <td width="193"  ><select name="fempresa" id="fempresa">
                                <option value="">-----SELECCIONE-----</option>
    <?php
    $sql = mysqli_query($con ,"SELECT * FROM fcompas");
    while ($reg = mysqli_fetch_array($sql)) {
        if ($_REQUEST['fempresa'] == $reg['pdesco']) {
            echo '<option value="' . $reg['pdesco'] . '" selected>' . $reg['pdesco'] . '</option>';
        } else {
            echo '<option value="' . $reg['pdesco'] . '">' . $reg['pdesco'] . '</option>';
        }
    }
    ?>
                            </select></td>
                    </tr>
                    <tr>
                        <td style="#A15E8D"><span class="Estilo22">AGENCIA:</span></td>
                        <td colspan="3"  ><span class="Estilo18">
                                <select name="fcodagen" id="fcodagen">
                                    <option value="">--SELECCIONE--</option>
    <?php
    $sql = mysqli_query($con ,"SELECT * FROM valeryus07");
    while ($reg = mysqli_fetch_array($sql)) {
        if ($_REQUEST['fcodagen'] == $reg['agdescrip']) {
            echo '<option value="' . $reg['agdescrip'] . '" selected>' . $reg['agdescrip'] . '</option>';
        } else {
            echo '<option value="' . $reg['agdescrip'] . '">' . $reg['agdescrip'] . '</option>';
        }
    }
    ?>
                                </select>
                            </span></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo22">PLAN:</span></td>
                        <td colspan="4"  ><span class="Estilo18">
                                <select name="fplan" id="fplan">
                                    <option value="">--SELECCIONE--</option>
    <?php
    $sql = mysqli_query($con ,"SELECT * FROM pplan");
    while ($reg = mysqli_fetch_array($sql)) {
        if ($_REQUEST['fplan'] == $reg['pdescrip']) {
            echo '<option value="' . $reg['pdescrip'] . '" selected>' . $reg['pdescrip'] . '</option>';
        } else {
            echo '<option value="' . $reg['pdescrip'] . '">' . $reg['pdescrip'] . '</option>';
        }
    }
    ?>
                                </select>
                            </span></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20"><strong>SEGMENTO:</strong></span></td>
                        <td  ><select name="codseg" id="codseg">
                                <option value="">--SELECCIONE--</option>
                                    <?php
                                    $sql = mysqli_query($con ,"SELECT * FROM valeryus06");
                                    while ($reg = mysqli_fetch_array($sql)) {
                                        if ($_REQUEST['codseg'] == $reg['descripcion']) {
                                            echo '<option value="' . $reg['descripcion'] . '" selected>' . $reg['descripcion'] . '</option>';
                                        } else {
                                            echo '<option value="' . $reg['descripcion'] . '">' . $reg['descripcion'] . '</option>';
                                        }
                                    }
                                    ?>
                            </select></td>
                    </tr>
                    <tr>
                        <td height="26" style="#A15E8D"><span class="Estilo20"><strong>SMERF:</strong></span></td>
                        <td colspan="12"  ><label></label><label><span class="Estilo1">
                                    <select name="smerf" id="smerf">
                                        <option value="">--SELECCIONE--</option>
                                    <?php
                                    $sql = mysqli_query($con ,"SELECT * FROM fsmerf");
                                    while ($reg = mysqli_fetch_array($sql)) {
                                        if ($_REQUEST['smerf'] == $reg['descripcion']) {
                                            echo '<option value="' . $reg['descripcion'] . '" selected>' . $reg['descripcion'] . '</option>';
                                        } else {
                                            echo '<option value="' . $reg['descripcion'] . '">' . $reg['descripcion'] . '</option>';
                                        }
                                    }
                                    ?>
                                    </select>
                                </span></label></td>
                    </tr>

                    <tr>
                        <th colspan="15" class="titulo"><div align="center" class="Estilo18">CONSULTAR FORMA DE PAGO </div></th>
                    </tr>
                    <tr>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo1 Estilo20">TARIFA:</span></td>
                        <td colspan="6"  >
                            <span class="Estilo20">
                                <label>
                                    <input name="tex" type="text" id="tex" value="<?php echo $_REQUEST['tex']; ?>" size="5" disabled="disabled">
                                </label>
                                <label>
                                    <input name="tex2" type="text" id="tex2" value="<?php echo $_REQUEST['tex2']; ?>" size="20" disabled="disabled">
                                </label>
                                <label>
                                    <input name="tex3" type="hidden" id="tex3" value="<?php echo $_REQUEST['tex3']; ?>" size="3" disabled="disabled">
                                    <span class="Estilo17"><strong>$</strong></span>
                                    <input name="tex4" type="text" id="tex4" value="<?php echo $_REQUEST['tex4']; ?>" size="5" disabled="disabled">
                                    <input name="tex5" type="text" id="tex5" value="<?php echo $_REQUEST['tex5']; ?>" size="2" disabled="disabled">
                                    = <span class="Estilo17"><strong>$</strong></span>
                                    <input name="tex6" type="text" id="tex6" size="5" value="<?php echo $_REQUEST['tex6']; ?>" disabled="disabled">
                                </label>
                            </span></td>
                        <td colspan="5" style="#A15E8D"><span class="Estilo20"><strong>CODIGO DE SEGURIDAD:
                                    <input name="fcodseg" type="text" id="fcodseg" tabindex="20" size="15" disabled="disabled" value="<?php echo $_REQUEST['fcodseg']; ?>">
                                </strong></span></td>
                        <td style="#A15E8D"><span class="Estilo20"><strong>LIMITE:</strong>
                                <input name="flimite" type="text" id="flimite" tabindex="20" size="15" disabled="disabled" value="<?php echo $_REQUEST['flimite']; ?>">
                            </span></td>
                    </tr>
                    <tr>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo16 Estilo20">TOTAL:</span></td>
                        <td colspan="3"  ><span class="Estilo23">$</span>
                            <span class="Estilo20">
                                <input name="tex4" type="text" id="tex4" tabindex="20" size="15" disabled="disabled" value="<?php echo $_REQUEST['ftotal']; ?>">
                            </span></td>
                        <td colspan="2" style="#A15E8D"><span class="Estilo20"><strong>FORMA DE PAGO:</strong></span></td>
                        <td colspan="5"  ><span class="Estilo1">
                                <select name="fformpago" id="fformpago" onChange="javascript: document.getElementById('frm1').submit()" tabindex="14" disabled="disabled">
                                    <option value="">---SELECCIONE---</option>
                                           <?php
                                           $sql = mysqli_query($con ,"SELECT * FROM valeryus09 WHERE pmontomax = 'ABONO' AND ppago = 'SI'");
                                           while ($reg = mysqli_fetch_array($sql)) {
                                               if ($_REQUEST['fformpago'] == $reg['descripcion']) {
                                                   echo '<option value="' . $reg['descripcion'] . '" selected>' . $reg['descripcion'] . '</option>';
                                               } else {
                                                   echo '<option value="' . $reg['descripcion'] . '">' . $reg['descripcion'] . '</option>';
                                               }
                                           }
                                           ?>
                                </select>
                            </span></td>
                        <td style="#A15E8D"><span class="Estilo20"><strong>NUMERO DE TARJETA:</strong></span></td>
                        <td  ><input name="fnumtar" type="text" id="fnumtar" tabindex="20" size="30" disabled="disabled" value="<?php echo $_REQUEST['fnumtar']; ?>"></td>
                    </tr>

                    <tr>
                        <th colspan="15" class="titulo"><div align="center" class="Estilo18">CONSULTAR DATOS</div></th>
                    </tr>
                    <tr>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>NOMBRE:</strong></span></td>
                        <td colspan="2" bordercolor=" "  >
                            <textarea name="fnombre" cols="25" rows="3" id="fnombre" tabindex="4"><?php echo $_REQUEST['fnombre']; ?>
                            </textarea>	  </td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>APELLIDO:</strong></span></td>
                        <td colspan="3" bordercolor=" "  ><textarea name="fapellido" cols="21" rows="3" id="fapellido" tabindex="4"><?php echo $_REQUEST['fapellido']; ?>
                            </textarea></td>
                        <td width="51" bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>TIPO DE HUESPED:</strong> </span></td>
                        <td colspan="4"  ><select name="ftiphuesped" id="ftiphuesped" onChange="javascript: document.getElementById('frm1').submit()" tabindex="21">
                                <option value="">--SELECCIONE--</option>
    <?php
    $sql = mysqli_query($con ,"SELECT * FROM tiphuesped");
    while ($reg = mysqli_fetch_array($sql)) {
        if ($_REQUEST['ftiphuesped'] == $reg['tpdescrip']) {
            echo '<option value="' . $reg['tpdescrip'] . '" selected>' . $reg['tpdescrip'] . '</option>';
        } else {
            echo '<option value="' . $reg['tpdescrip'] . '">' . $reg['tpdescrip'] . '</option>';
        }
    }
    ?>
                            </select></td>
                        <td colspan="2" style="#A15E8D"><div align="center" class="Estilo1 Estilo20"><strong><span class="Estilo19">VIP</span></strong>
                                <input name="fvip" type="checkbox" id="fvip" disabled="disabled" value="SI" <?php if ($_REQUEST['fvip'] == 'SI') echo 'checked'; ?>>
                            </div></td>
                    </tr>
                    <tr>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo22">TELEFONO:</span></td>
                        <td colspan="2" bordercolor=" "  ><input name="ftelefono" type="text" id="ftelefono" tabindex="20" size="25" disabled="disabled" value="<?php echo $_REQUEST['ftelefono']; ?>"></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>TELEFONO EMPRESA: </strong></span></td>
                        <td colspan="3" bordercolor=" "  ><input name="ftelemp" type="text" id="ftelemp" tabindex="20" size="25" disabled="disabled" value="<?php echo $_REQUEST['ftelemp']; ?>"></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"> <span class="Estilo20"><strong>E-MAIL:</strong></span></td>
                        <td colspan="7" bordercolor=" "  ><input name="fmail" type="text" id="fmail" tabindex="20" size="25" disabled="disabled" value="<?php echo $_REQUEST['fmail']; ?>"></td>
                    </tr>
                    <tr>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo22">E-MAIL EMPRESA: </span></td>
                        <td colspan="2" bordercolor=" "  ><input name="femail" type="text" id="femail" tabindex="20" size="25" disabled="disabled" value="<?php echo $_REQUEST['femail']; ?>"></td>

                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>DIRECCION:</strong></span></td>
                        <td colspan="3" bordercolor=" "  ><input name="fdireccion" type="text" id="fdireccion" tabindex="20" size="20" disabled="disabled" value="<?php echo $_REQUEST['fdireccion']; ?>"></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>COLONIA:</strong></span></td>
                        <td colspan="5" bordercolor=" "  ><span class="Estilo18">
                                <input type="hidden" name="tcol1" id="tcve" value="<?php echo $_REQUEST['tcve']; ?>">
                                <input type="text" name="tcol" id="tcol" disabled="disabled"value="<?php echo $_REQUEST['tcol']; ?>">
                            </span></td>
                    </tr>
                    <tr>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo22">CODIGO POSTAL:</span></td>
                        <td colspan="2" bordercolor=" "  ><input name="tcp" type="text" disabled="disabled" onKeyPress="return validar(event)" value="<?php echo $_REQUEST['tcp']; ?>" maxlength="5"></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>PAIS: </strong></span></td>
                        <td colspan="3" bordercolor=" "  ><span class="Estilo18">
                                <select name="pais" id="pais" onChange="javascript: document.getElementById('frm1').submit()">
                                    <option value="">-----Selecciona-----</option>
                                <?php
                                include("DMMYSQLG.php");
                                @$resultado = mysqli_query($con ,"select * from dxpaises");
                                if (!isset($_REQUEST['pais'])) {
                                    $dt_paises = mysqli_fetch_array($resultado);
                                    $selPais = $dt_paises['cve_pais'];
                                    if (mysqli_num_rows($resultado) > 0)
                                        mysqli_data_seek($resultado, 0);
                                } else {
                                    $selPais = $_REQUEST['pais'];
                                }
                                while ($registro = mysqli_fetch_array($resultado)) {
                                    if ($selPais == $registro['cve_pais']) {
                                        echo '<option value="' . $registro['cve_pais'] . '" selected>' . $registro['des_pais'] . '</option>';
                                    } else {
                                        echo '<option value="' . $registro['cve_pais'] . '">' . $registro['des_pais'] . '</option>';
                                    }
                                }
                                ?>
                                </select>
                            </span></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>ESTADO:</strong></span></td>
                        <td colspan="5" bordercolor=" "  ><span class="Estilo18">
                                <select name="estados" onChange="javascript: document.getElementById('frm1').submit()">
                                    <option  value="">-----Selecciona-----</option>
    <?php
    @$resultado = mysqli_query($con ,"select * from dxestado where cve_pais='$selPais'");
    if (!isset($_REQUEST['estados'])) {
        $dt_estado = mysqli_fetch_array($resultado);
        $selEnt = $dt_estado['cve_estado'];
        if (mysqli_num_rows($resultado) > 0)
            mysqli_data_seek($resultado, 0);
    } else {
        $selEnt = $_REQUEST['estados'];
    }
    while ($registro = mysqli_fetch_array($resultado)) {
        if ($selEnt == $registro['cve_estado']) {
            echo '<option value="' . $registro['cve_estado'] . '" selected>' . $registro['des_estado'] . '</option>';
        } else {
            echo '<option value="' . $registro['cve_estado'] . '">' . $registro['des_estado'] . '</option>';
        }
    }
    ?>
                                </select>
                            </span></td>
                    </tr>
                    <tr>
                        <td height="29" bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo22">DELEGACION O MUNICIPIO </span></td>
                        <td colspan="2" bordercolor=" "  ><span class="Estilo18">
                                <select name="tmun" id="tmun" >
                                    <option  value="">-----Selecciona-----</option>
                                    <?php
                                    @$resultado = mysqli_query($con ,"select * from dxdelmun where cve_estado='$selEnt' and cve_pais='$selPais'");
                                    if (!isset($_REQUEST['tmun'])) {
                                        $dt_delmun = mysqli_fetch_array($resultado);
                                        $selDelMun = $dt_delmun['cve_delmun'];
                                        if (mysqli_num_rows($resultado) > 0)
                                            mysqli_data_seek($resultado, 0);
                                    } else {
                                        $selDelMun = $_REQUEST['tmun'];
                                    }
                                    while (@$registro = mysqli_fetch_array($resultado)) {
                                        if ($selDelMun == $registro['cve_delmun']) {
                                            echo '<option value="' . $registro['cve_delmun'] . '" selected>' . $registro['des_delmun'] . '</option>';
                                        } else {
                                            echo '<option value="' . $registro['cve_delmun'] . '">' . $registro['des_delmun'] . '</option>';
                                        }
                                    }
                                    ?>
                                </select>
                            </span></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>VEHICULO: </strong></span></td>
                        <td colspan="3" bordercolor=" "  ><input name="fvehiculo" type="text" id="fvehiculo" tabindex="20" size="25" disabled="disabled" value="<?php echo $_REQUEST['fvehiculo']; ?>"></td>
                        <td bordercolor="#A15E8D" style="#A15E8D"><span class="Estilo20"><strong>PLACAS:</strong></span></td>
                        <td colspan="7" bordercolor=" "  ><label>
                                <input name="fplacas" type="text" id="fplacas" tabindex="20" size="25" disabled="disabled" value="<?php echo $_REQUEST['fplacas']; ?>">
                            </label></td>
                    </tr>
                </table>
            </form>
                                    <?php
                                    echo '<div align="center">
	<form id="form1" name="form1" action="rec_checkin_PR.php" target="_self">
		<input type="submit" name="submit" value="Regresar" class="bot_WsW">
	</form>
	</div>';
                                    ?>
        </body>
                                    <?php
                                    mysqli_close($con);
                                }
//ultima actualizacion 533-->400
                                ?>
</html>