<?php
ob_start();
require("includes/check_auth_user.php");
require("includes/dbconnect.php");
include('includes/function.php');

$formname = "Check In Report";

$myyear = $_SESSION["tit_" . $dbname];

$admin = $_SESSION["admin_" . $dbname];
$zdb = $_SESSION["zdbyear_" . $dbname];
$username = $_SESSION["username_" . $dbname];
$zroot = $_SESSION["zdir"];
$zcono = $_SESSION["comp_" . $dbname];
$modet = $_GET["mode"];

$yearalpha1 = substr($myyear, 0, 1);
$nyear = substr($myyear, -4);

$yearalpha = strtoupper($yearalpha1);

mysqli_select_db($conn, $zdb);
include("includes/linkshead.php");
?>


<!-- <script src="https://kit.fontawesome.com/3ada711723.js" crossorigin="anonymous"></script> -->
<script src="MyScript/checkin_rooms.js?a=2" type="text/javascript"></script>
<!--<style rel="stylesheet" src="styles/tab_pane.css"></style>-->
<style>
    /* CSS */
    .button-29 {
        align-items: center;
        appearance: none;
        background-image: radial-gradient(100% 100% at 100% 0, #52529B 0, #b3b3f2 100%);
        border: 0;
        border-radius: 6px;
        box-shadow: rgba(45, 35, 66, .4) 0 2px 4px, rgba(45, 35, 66, .3) 0 7px 13px -3px, rgba(58, 65, 111, .5) 0 -3px 0 inset;
        box-sizing: border-box;
        color: #fff;
        cursor: pointer;
        display: inline-flex;
        font-family: "JetBrains Mono", monospace;
        height: 48px;
        justify-content: center;
        line-height: 1;
        list-style: none;
        overflow: hidden;
        padding-left: 16px;
        padding-right: 16px;
        position: relative;
        text-align: left;
        text-decoration: none;
        transition: box-shadow .15s, transform .15s;
        user-select: none;
        -webkit-user-select: none;
        touch-action: manipulation;
        white-space: nowrap;
        will-change: box-shadow, transform;
        font-size: 18px;
    }

    .button-29:focus {
        /*linear-gradient(to top right, #33ccff 0%, #ff99cc 100%);*/
        box-shadow: #33ccff 0 0 0 1.5px inset, rgba(45, 35, 66, .4) 0 2px 4px, rgba(45, 35, 66, .3) 0 7px 13px -3px, #ff99cc 0 -3px 0 inset;
    }

    .button-29:hover {
        box-shadow: rgba(45, 35, 66, .4) 0 4px 8px, rgba(45, 35, 66, .3) 0 7px 13px -3px, #33ccff 0 -3px 0 inset;
        transform: translateY(-2px);
    }

    .button-29:active {
        box-shadow: #3c4fe0 0 3px 7px inset;
        transform: translateY(2px);
    }

    .sksahil {
        border-radius: 10px;
        background: linear-gradient(to top right, #33ccff 0%, #ff99cc 100%);
        margin-left: 1%;
    }

    .sksahil2 {
        border-radius: 10px;
        background-color: #fff;
        /* background-color:  rgb(192,192,192,0.1); */
        margin-top: 5px;
        margin-bottom: 5px;
    }


    .skk {
        border-bottom: 1px solid grey !important;
        color: white;
    }

    .slk {
        background: black !important;
    }

    .txtt {
        color: whitesmoke;
        text-transform: uppercase;
        font-family: 'Franklin Gothic Medium', 'Arial Narrow', Arial, sans-serif;
    }
    @media print{

        a[href]:after {
            content: none !important;
        }
        .noPrint{
            display: none;
        }

        .newtab{
            width:100%;
        }

        .rmctg {
            /*        background: rgb(255,255,255);
                    background: linear-gradient(90deg, rgba(255,255,255,1) 0%, rgba(34,161,213,1) 100%); */
            /*        background: #B19CD9;*/
            text-transform: uppercase;

        }

        .stick{
            font-size: 20px;
        }

        .rmtp {
            background: lightyellow; 
            /*background: #40E0D0;*/
            /*         background: radial-gradient(circle, rgba(148, 187, 233, 1) -50000%, rgba(190, 190, 190, 1) 100%); 
                     background: radial-gradient(circle, rgba(238,174,202,1) 0%, rgba(148,187,233,1) 100%); */


        }

        /*CSS*/

        .styled-table {
            border-collapse: collapse;
            margin: 25px 0;
            font-size: 0.9em;
            font-family: sans-serif;
            min-width: 400px;
            box-shadow: 0 0 20px rgba(0, 0, 0, 0.15);
            border-radius: 6px 6px 0 0;
            overflow: hidden;
        }

        .styled-table thead tr {
            /*background-color: lightgray;*/
            background: linear-gradient(91.9deg, rgb(75, 207, 250) 6.3%, rgb(25, 159, 249) 98.9%);

            /* background: linear-gradient(90deg, rgba(2,0,36,1) 0%, rgba(124,123,136,1) 0%, rgba(255,205,0,0.7962535355939251) 0%, rgba(163,163,163,1) 60%);  */
            color: #ffffff;
            text-align: left;
        }

        .sknew {
            /*background: linear-gradient(to top right, #33ccff 0%, #ff99cc 100%);*/
            /*margin-left: 1%;*/
            color: black;
            font-family: verdana;
            font-size: 16px;
        }

        .styled-table th,
        .styled-table td {
            padding: 12px 15px;
        }

        .styled-table tbody tr {
            border-bottom: 1px solid #dddddd;
        }

        .styled-table tbody tr:nth-of-type(even) {
            background-color: #f3f3f3;
        }

        .styled-table tbody tr:last-of-type {
            border-bottom: 2px solid #c2b47e;
        }

        .styled-table tbody tr.active-row {
            font-weight: bold;
            color: grey;
        }


    }
</style>
</head>
<br>

<div class="row table-responsive noPrint"  align="center" style="padding:1%">
    <div class="col-md-2"></div>
    <div class="col-md-2 sksahil">
        <label class="txtt"><b>City</b></label>

        <?php
        echo "<select name='city' class='scity skk  select2' style='width:100%' autocomplete='off'> ";
        echo "<option value=''></option>";

        $gcity = mysqli_query($conn, "SELECT `code`,`name` FROM `city` ORDER BY `name`") or die(mysqli_error($conn));
        while ($icity = mysqli_fetch_array($gcity)) {
            echo "<option value='$icity[code]'>$icity[name]</option>";
        }

        echo "</select>";
        ?>
    </div>

    <div class="col-md-2  sksahil">
        <label class="txtt"><b>Hotel Name</b></label>

        <?php
        echo "<select name='hotelnm' class='shotelnm skk  select2' style='width:100%' autocomplete='off' > ";

        echo "<option value=''></option>";
        $mhotl = mysqli_query($conn, "SELECT code,hotelnm FROM hotels  order by hotelnm ") or die(mysqli_error($conn));
        while ($thotl = mysqli_fetch_array($mhotl)) {
            echo "<option value='$thotl[code]'>$thotl[hotelnm]</option>";
        }
        echo "</select>";
        ?>
    </div>






    <div class="col-md-2 sksahil">
        <label class="txtt"><b>Query Date</b></label>
        <input type='date' min="<?php echo date('Y-m-d'); ?>" name='mcheckin' class='mcheckin text-center skk' style="color:white">
    </div>

    <div class="col-md-1 ">
        <button class="button-29 sksearch" type="button">Search</button>
    </div>
</div>

<div class="row table-responsive hoteldetail" style="padding: 2%">


</div>


<?php include("includes/linksfoot.php"); ?>
