<?php
include("include/header.php");
include("include/sidebar.php");
if(!empty($_REQUEST['did'])){
    $did=mysqli_real_escape_string($con,$_REQUEST['did']);
    $q=mysqli_query($con,"delete from hotel_booking where id=$did");
    if($q){
        $_SESSION['msg']="Data Deleted Successfully";
    }else{
        $_SESSION['msg']="Data Deletion Failed";
    }
    header("location:hotel_booking.php");
}
if(!empty($_REQUEST['upid'])){
    $doid=mysqli_real_escape_string($con,$_REQUEST['upid']);
    $do="EditHotelBooking";
    $Row=mysqli_fetch_array(mysqli_query($con,"select * from hotel_booking where id=$doid"));
}else{
    $doid="";
    $do="HotelBooking";
}
?>
<style>
    #loader{
        display:none;
        position:fixed;
        z-index:1000;
        top:0;
        left:0;
        width:100%;
        height:100%;
        background-image:url(images/uploads/loader.gif);
        background-position:50% 50%;
        background-color:rgba(255,255,255,0.6);
        background-repeat:no-repeat;
    }
    body.loading{
        overflow:hidden;
    }
    body.loading #loader{
        display:block;
    }
</style>
<div id="loader"></div>
<link rel="stylesheet" href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css">
<div class="content-wrapper">
    <section class="content-header">
        <h1>
            Hotel Booking
            <small>Add Hotel Booking</small>
        </h1>
        <ol class="breadcrumb">
            <li><a href="index.php"><i class="fa fa-dashboard"></i> Home</a></li>
            <li class="active">Hotel Booking</li>
        </ol>
    </section>
    <!-- Main content -->
    <section class="content container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="box box-primary">
                    <div class="box-header with-border">
                        <h3 class="box-title">Hotel Booking</h3>
                    </div>
                    <div class="box-body">
                        <form role="form" action="action.php" method="post" enctype="multipart/form-data">
                            <input type="hidden" name="do" value="<?=$do;?>" />
                            <input type="hidden" name="doid" value="<?=$doid;?>" />
                            <div class="box-body">
                                <div class="row">
                                    <div class="form-group col-md-3">
                                        <label>First Name</label>
                                        <input name="first_name" type="text" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['first_name']."";}?>" class="form-control" placeholder="Enter First Name" />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Last Name</label>
                                        <input name="last_name" type="text" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['last_name']."";}?>" class="form-control" placeholder="Enter Last Name" />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Email</label>
                                        <input name="email" type="email" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['email']."";}?>" class="form-control" placeholder="Enter Email" />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Mobile</label>
                                        <input name="mobile" type="number" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['mobile']."";}?>" class="form-control" placeholder="Enter Mobile No." />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Hotel Destination</label>
                                        <select class="form-control" name="hotel_destination_id">
                                            <option value="">--Select Hotel Destination--</option>
                                            <?php $query=mysqli_query($con,"select * from hotel_destination");
                                                while($row=mysqli_fetch_array($query)){?>
                                                <option value="<?=$row['id'];?>" <?php if(isset($_REQUEST['upid']) && $Row['hotel_destination_id']==$row['id']){echo "selected";} ?>><?=$row['name'];?></option>
                                            <?php } ?>
                                        </select>
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Check In</label>
                                        <input name="checkin" type="date" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['checkin']."";}?>" class="form-control" placeholder="Enter CheckIn Date." />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Check Out</label>
                                        <input name="checkout" type="date" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['checkout']."";}?>" class="form-control" placeholder="Enter CheckOut Date." />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Kids</label>
                                        <input name="kids" type="number" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['kids']."";}?>" class="form-control" placeholder="Enter Kids" />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Adults</label>
                                        <input name="adults" type="number" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['adults']."";}?>" class="form-control" placeholder="Enter Adults" />
                                    </div>
                                    <div class="form-group col-md-3">
                                        <label>Rooms</label>
                                        <input name="rooms" type="number" value="<?php if(!empty($_REQUEST['upid'])){ echo "".$Row['rooms']."";}?>" class="form-control" placeholder="Enter Rooms" />
                                    </div>
                                </div>
                            </div>
                            <div class="box-footer">
                                <button type="submit" class="btn btn-primary">Submit</button>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="box box-primary">
            <div class="box-header with-border">
              <h3 class="box-title">Hotel Booking Data</h3>
            </div>
            <!-- /.box-header -->
            <div class="box-body table-responsive">
              <table id="example1" class="table table-bordered table-striped">
                <thead>
                <tr>
                    <th>#ID</th>
                    <th>Action</th>
                    <th>First Name</th>
                    <th>Last Name</th>
                    <th>Email</th>
                    <th>Mobile</th>
                    <th>Hotel Destination Name</th>
                    <th>Check In</th>
                    <th>Check Out</th>
                    <th>Kids</th>
                    <th>Adults</th>
                    <th>Rooms</th>
                </tr>
                </thead>
                <tbody>
                    <?php
                        $q=mysqli_query($con,"select hotel_booking.* from hotel_booking 
                                left join hotel_destination on hotel_destination.id=hotel_booking.hotel_destination_id order by id desc");
                        $i=0;
                        while($r=mysqli_fetch_array($q)){$i++;
                    ?>
                <tr>
                    <td><?=$i;?></td>
                  <td>
                      <a href="?upid=<?=$r['id'];?>"><i class="fa fa-pencil"></i></a>
                      <a href="?did=<?=$r['id']?>" onclick="return confirm_click();"><i class="fa fa-close"></i></a>
                  </td>
                  <td><?=$r['first_name'];?></td>
                  <td><?=$r['last_name'];?></td>
                  <td><?=$r['email'];?></td>
                  <td><?=$r['mobile'];?></td>
                  <td><?=$r['name'];?></td>
                  <td><?=$r['checkin'];?></td>
                  <td><?=$r['checkout'];?></td>
                  <td><?=$r['kids'];?></td>
                  <td><?=$r['adults'];?></td>
                  <td><?=$r['rooms'];?></td>
                </tr>
                <?php
                        }
                ?>
                </tbody>
              </table>
            </div>
            <!-- /.box-body -->
          </div>
        </div>
    </section>
</div>
<?php include("include/footer.php"); ?>
<!-- DataTables -->
<script src="bower_components/datatables.net/js/jquery.dataTables.min.js"></script>
<script src="bower_components/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
<!-- page script -->
<script>
  $(document).ready(function () {
    $('#example1').DataTable({
      'paging'      : true,
      'lengthChange': true,
      'searching'   : true,
      'ordering'    : true,
      'info'        : true,
      'autoWidth'   : true
    });
    // $("input[name='sponsor_username']").keyup(function(){
    //     var sponsor_username=$(this).val();
    //     if(sponsor_username.length>5){
    //         $.ajax({  
    //             type: "POST",  
    //             url: "json.php",  
    //             data: {'do':"username_check",'sponsor_username': sponsor_username}, 
    //             dataType: "json",
    //             beforeSend: function(){
    //                 $("body").addClass("loading");
    //             },
    //             success: function(response) {
    //                 if(response=="invalid"){
    //                     $("form").data("sponsor","0");
    //                 }else{
    //                     $("input[name='sponsor_name']").val(response);
    //                     $("form").data("sponsor","1");
    //                 }
    //             },
    //             complete:function(data){
    //                 $("body").removeClass("loading");
    //                 if($("form").data("sponsor")==1&&$("form").data("username")==1){
    //                     $("#submit-btn").prop("disabled",false);
    //                 }else{
    //                     $("#submit-btn").prop("disabled",true);
    //                 }
    //             }
    //         });
    //     }
    // });
});
</script>
</body>
</html>